Cold Case~68min
The Pilot Who Was Never Actually "Positioning"
CAPT-08's roster logs one codeshare flight per duty day as "positioning" (deadheading, excluded from duty-time limits) on 2024-03-05, 2024-03-12, and 2024-03-19 — but the codeshare manifest shows CAPT-08 was the actual operating crew on all three. Recounted as operating duty, CAPT-08's total duty time hits 14.50, 14.25, and 14.25 hours on those three days — over the 14-hour limit every time. CAPT-11 also has a "positioning" codeshare leg, but the manifest shows PARTNER-CREW-22, not CAPT-11, actually operated that flight — genuinely deadheading, no violation.
Tables you'll query
crew_membersflight_assignmentscodeshare_manifests
What you'll learn
JOINsDate & Time FunctionsAggregations & GROUP BY