Docs · File formats
Flight Disruption Compensation CSV format
Header names are matched automatically, in any order and any case. Extra columns are ignored.
| Column | Required | Also accepted as | Example |
|---|---|---|---|
| Passenger | Yes | passenger, passenger name, traveller, traveler, name | Jane Murphy |
| Booking reference | booking reference, booking ref, booking, pnr, confirmation, confirmation code | XK4P2L | |
| Airline | airline, carrier, operating airline, operating carrier, airline code | EI | |
| Flight number | Yes | flight number, flight, flight no, flight #, flight num | EI105 |
| Scheduled departure date | Yes | scheduled departure date, departure date, flight date, date, scheduled departure | 2026-06-14 |
| Departure airport | Yes | departure airport, from, origin, dep airport, departure, from airport | DUB |
| Arrival airport | Yes | arrival airport, to, destination, arr airport, arrival, to airport | JFK |
| Scheduled arrival | scheduled arrival, sched arrival, scheduled arrival time, sta | 2026-06-14 13:40 | |
| Actual arrival (or arrival of the replacement flight) | actual arrival, actual arrival time, arrived, ata, arrival time actual | 2026-06-14 18:05 | |
| Arrival delay (minutes) | arrival delay minutes, delay minutes, delay, arrival delay, delay (minutes) | 265 | |
| Status | Yes | status, disruption, event, what happened | Delayed |
| Cancellation notice (days) | cancellation notice days, notice days, days notice, notice, notice given days | 2 | |
| Reason given by the airline | reason given, reason, airline reason, cause, reason given by airline | Technical | |
| Ticket price | ticket price, fare, price, amount paid, ticket cost | 642.00 | |
| Currency | currency, ccy, ticket currency | EUR | |
| Refund or rebooking accepted | refund or rebooking accepted, refund/rebooking, resolution, accepted, outcome, refund or rebooking | Rebooked | |
| EU/UK-licensed carrier | eu/uk carrier, eu uk carrier, eu carrier, eu/uk licensed, eu uk licensed, carrier licence | EU | |
| Carrier size (APPR) | carrier size, appr carrier size, airline size | Large | |
| Distance (km) | distance km, distance, great circle km | 5103 |