StudentRecon
Training Record Reconciliation & Audit
Beta v0.5
What’s new in this release

Release 0.5

FAA Requirements Audit

  • Added a Private Pilot ASEL Part 61 and Part 141 FAA requirements audit.
  • Added route-distance checks for solo and night cross-country requirements.
  • Added recent practical-test preparation tracking based on CTA flight dates.
  • Added airport-distance support using an internal airport database.
  • Added CTA route extraction from From, Stops, and To columns.

Release 0.4

Commercial Course

  • Added Commercial Pilot as a course guide option.
  • Added the Commercial course guide CSV.
  • Added Commercial-specific audit columns for Comp/TAA Training, PIC / Solo, Night Solo, XC Solo Day, and XC Solo Night.
  • Added an editable Commercial aircraft CSV for Complex/TAA tail numbers.

CTA Parsing

  • Fixed CTA parsing for long Phase 1 descriptions where Scenario appears as Sscenario.

Report Layout

  • Improved Course Progress Analysis spacing for wider Commercial reports.
  • Adjusted print margins and padding so wide values fit better without reducing print font size.
  • Added a Download PDF button at the top of the report page.

Reconciliation Review

  • Reworked the Totals Reconciliation table into a math-style layout with TFBO Original, Required Adjustments, TFBO Adjusted, CTA Total, and Difference rows.
  • Simplified Required Adjustments so adjustment details appear directly in the totals table instead of a separate Adjustment Details table.
  • Added a Recommended Reconciliation Fix Plan that gives step-by-step CTA/TFBO correction guidance when StudentRecon can identify likely fixes.
  • Added warnings for systemic CTA/TFBO flight-hour mismatches, including outside-dual style cases where TFBO has instructor/ground billing but no aircraft flight hours.
  • Added a warning when CTA and TFBO files may not belong to the same student or date range.
  • Removed the older Missing Record Investigation and Grouped Record Investigation tables.
  • Made the Recommended Reconciliation Fix Plan section more visible in the report.

Regression Checks

  • Added course regression checks to protect Private and Instrument course columns and TD rules.
  • Confirmed Commercial-only fields do not appear in Private or Instrument reports.

Release 0.3

Course Guide Support

  • Added support for multiple course guides, including Private, Instrument G1000, and Instrument Analog.
  • Improved the course selector so no course is selected by default.

Course Progress Analysis

  • Added missing-lesson checks before progress checks.
  • Disabled missing-lesson checks when Transfer Credit exists.
  • Added remaining course-guide lessons to the report even when the student has no matching CTA rows yet.
  • Added a warning section for CTA lessons that do not belong to the selected course guide.
  • Improved row colors for Progress Check Audit, Stage Total, and Course Total.
  • Allowed long Scenario names to wrap.
  • Added sticky table headers on screen and repeated headers when printing.

Ground Assignments

  • Saved ground assignment overrides so repeat audits can reuse prior choices.
  • Expanded ground assignment choices to include progress checks.

Parsing And Rules

  • Updated Private repeat-count logic so same-day duplicate P5S2/P5S3 lessons count as one lesson (solo flights are having two lines in CTA usually).
  • Updated CTA parsing so phase values like 2A are treated as phase 2.
  • Added Lesson Notes from the course guide in progress rows and assignment options.
Training Program
Select the course guide used to audit the student’s progress.
FAA Audit Basis
Select an optional regulatory requirements audit to show in the report.
Upload the CTA Training Record Summary PDF.
Upload the TFBO XML export for the same student.
Beta Release: Results are generated using automated reconciliation rules. Always verify findings against the original CTA and TFBO records before making administrative or training decisions.
Running analysis…
Large CTA PDFs may take a little longer. Please do not refresh or resubmit.