Docs · File formats

Flight Disruption Compensation CSV format

Header names are matched automatically, in any order and any case. Extra columns are ignored.
ColumnRequiredAlso accepted asExample
PassengerYespassenger, passenger name, traveller, traveler, nameJane Murphy
Booking referencebooking reference, booking ref, booking, pnr, confirmation, confirmation codeXK4P2L
Airlineairline, carrier, operating airline, operating carrier, airline codeEI
Flight numberYesflight number, flight, flight no, flight #, flight numEI105
Scheduled departure dateYesscheduled departure date, departure date, flight date, date, scheduled departure2026-06-14
Departure airportYesdeparture airport, from, origin, dep airport, departure, from airportDUB
Arrival airportYesarrival airport, to, destination, arr airport, arrival, to airportJFK
Scheduled arrivalscheduled arrival, sched arrival, scheduled arrival time, sta2026-06-14 13:40
Actual arrival (or arrival of the replacement flight)actual arrival, actual arrival time, arrived, ata, arrival time actual2026-06-14 18:05
Arrival delay (minutes)arrival delay minutes, delay minutes, delay, arrival delay, delay (minutes)265
StatusYesstatus, disruption, event, what happenedDelayed
Cancellation notice (days)cancellation notice days, notice days, days notice, notice, notice given days2
Reason given by the airlinereason given, reason, airline reason, cause, reason given by airlineTechnical
Ticket priceticket price, fare, price, amount paid, ticket cost642.00
Currencycurrency, ccy, ticket currencyEUR
Refund or rebooking acceptedrefund or rebooking accepted, refund/rebooking, resolution, accepted, outcome, refund or rebookingRebooked
EU/UK-licensed carriereu/uk carrier, eu uk carrier, eu carrier, eu/uk licensed, eu uk licensed, carrier licenceEU
Carrier size (APPR)carrier size, appr carrier size, airline sizeLarge
Distance (km)distance km, distance, great circle km5103