Flight Tables lets you save public Arrivals and Departures infomation to a standardised CSV file.
Current version is for Heathrow Airport.
$ pip install flight_tables
Save yesterday's Arrivals and Departures to CSV:
python -m flight_tables.main
If you want to specify a date, add "yyyy-mm-dd" to the command. It will only work for the past few days, where data is still available from the airport API.
Run the script below, but replace "yyyy-mm-dd" with the date you want. It will only work for the past few days, where data is still available from the airport API.
from flight_tables.flight_tables import FlightTables
# Save Arrivals CSV
FlightTables.arrivals_csv("yyyy-mm-dd")
# Save Departures CSV
FlightTables.departures_csv("yyyy-mm-dd")
The output is a csv with these columns:
| flight_id | origin | destination | status | scheduled_datetime | actual_datetime | delay_mins | code_share |
|---|---|---|---|---|---|---|---|
| BA028 | HKG | LHR | Landed | 03/04/2020 05:30 | 03/04/2020 05:39 | 9 | No |
| VA5341 | HKG | LHR | Landed | 03/04/2020 05:30 | 03/04/2020 05:29 | -1 | Alt-Code |
| BA064 | NBO | LHR | Cancelled | 03/04/2020 06:20 | Main-Code | ||
| ... |
Output is saved to your working directory.
Documentation here
The initial motivation was to analyse flight punctuality. When you google for this most results are not detailed enough to compare one flight ID against another.