bts_ontime_flights — US domestic flights with on-time performance (1987-2025)
- Description
Temporal networks of the scheduled domestic flights of the large airlines of the United States, from the "Reporting Carrier On-Time Performance" data of the Bureau of Transportation Statistics (BTS) of the US Department of Transportation. The airlines whose share of the revenues of domestic scheduled passenger service is at least 0.5% must report every non-stop domestic flight to the BTS, with its scheduled and actual departure and arrival times, delays, cancellations and diversions (the number of reporting airlines varies between about 10 and 20 over the years). The data start in October 1987; there is one network per calendar year, from 1987 (October to December only) to 2025, named after the year (e.g.
2025).Each node is an airport, identified by the airport ID of the Department of Transportation (which, unlike the three-letter codes, is not reused for different airports), and a directed edge from airport A to airport B is a scheduled flight from A to B (including cancelled and diverted flights), so that the networks are multigraphs with one edge per flight. Only the airports with some flight in the year are included. The times are given as in the source, in the local time of the airports, so the edge
timeis the date of the flight only; the scheduled and actual times of the day are separate properties. The taxi times, wheels-off and wheels-on times, delay groups and time blocks, the details of the diversions (landing airports), and the other identifiers of the airlines and airports (DOT ID and IATA code of the airline, sequence and city market IDs of the airports, FIPS codes and world area codes), given in the source, are not included. The data may be revised by the BTS, so they are those of the time of download. The flights are not a nearly planar network (the airports have no coordinates in these data), so they are laid out as any other network.The networks have the following properties:
- (Node)
airport_id: the airport ID of the Department of Transportation. - (Node)
code: the three-letter code of the airport (as of its last flight of the year). - (Node)
city: the city of the airport, with its state (e.g.Oakland, CA). - (Node)
state: the two-letter code of the state or territory of the airport. - (Edge)
time: the date of the flight, as the Unix time of its beginning (midnight UTC). - (Edge)
airline: the unique carrier code of the airline (as used by the BTS; codes used by several airlines have a numeric suffix for the earlier users, e.g.PA(1)). - (Edge)
flight_number: the flight number. - (Edge)
tail_number: the tail number (registration) of the aircraft (often empty before 1995). In some of the data of 2001 and 2002, the letters S to Z of the tail numbers are given as their bytes in the EBCDIC encoding (e.g.N850\xe4\xe2forN850US, invalid in UTF-8); they are decoded. - (Edge)
crs_dep_time,crs_arr_time: the scheduled times of departure and arrival, in local time ashhmm(e.g. 937 for 9:37). - (Edge)
dep_time,arr_time: the actual times of departure and arrival, in local time ashhmm(-1 if missing, e.g. for cancelled flights). - (Edge)
dep_delay,arr_delay: the departure and arrival delays, in minutes (negative for early departures and arrivals; NaN if missing). - (Edge)
cancelled: whether the flight was cancelled. - (Edge)
cancellation_code: the reason of the cancellation (Acarrier,Bweather,Cnational air system,Dsecurity; empty if not cancelled or not reported, as before mid-2003). - (Edge)
diverted: whether the flight was diverted. - (Edge)
crs_elapsed_time,actual_elapsed_time,air_time: the scheduled and actual elapsed times of the flight, and its time in the air, in minutes (NaN if missing). - (Edge)
distance: the distance between the airports, in miles. - (Edge)
carrier_delay,weather_delay,nas_delay,security_delay,late_aircraft_delay: the minutes of arrival delay attributed to each cause, reported from June 2003 on for flights with an arrival delay of 15 minutes or more (NaN otherwise).
- (Node)
- Tags
- Transportation Airport Multigraph Temporal Timestamps Metadata
- Added
- 2026-10-28
- Citation
-
- Bureau of Transportation Statistics, "Reporting Carrier On-Time Performance (1987-present)." US Department of Transportation (1987-2025) www.transtats.bts.gov
- Upstream URL OK
-
https://www.transtats.bts.gov/Fields.asp?gnoyr_VQ=FGJ
https://transtats.bts.gov/PREZIP/ - Upstream license
- Public domain (US government work), https://www.usa.gov/government-works
- Networks
-
Tip: click on a column header to sort the list, or hover over it for a description.
Column legend
- $\left<k\right>$
- Mean degree
- $\sigma_k$
- Standard deviation of the degrees
- $\lambda_h$
- Largest eigenvalue of the Hashimoto (non-backtracking) matrix
- $\tau$
- Random walk mixing time
- $r$
- Degree assortativity
- $c$
- Global clustering coefficient
- $\oslash$
- (Pseudo-) diameter
- $S$
- Relative size of the largest component
- NPs
- Node properties
- EPs
- Edge properties
Name Nodes Edges $\left<k\right>$ $\sigma_k$ $\lambda_h$ $\tau$ $r$ $c$ $\oslash$ $S$ Kind Mode NPs EPs gt GraphML GML csv 1987 238 1,311,826 5511.87 20349.18 37.13 14.67 -0.16 0.58 5 1.00 Directed Unipartite airport_id code city state time airline flight_number tail_number crs_dep_time crs_arr_time dep_time arr_time dep_delay arr_delay cancelled cancellation_code diverted crs_elapsed_time actual_elapsed_time air_time distance carrier_delay weather_delay nas_delay security_delay late_aircraft_delay 6.7 MiB 17.2 MiB 16.2 MiB 15.4 MiB 1988 238 5,202,096 21857.55 80877.86 39.65 13.28 -0.17 0.61 5 1.00 Directed Unipartite airport_id code city state time airline flight_number tail_number crs_dep_time crs_arr_time dep_time arr_time dep_delay arr_delay cancelled cancellation_code diverted crs_elapsed_time actual_elapsed_time air_time distance carrier_delay weather_delay nas_delay security_delay late_aircraft_delay 25.5 MiB 66.7 MiB 62.6 MiB 60.1 MiB 1989 238 5,041,200 21181.51 78016.06 39.16 13.77 -0.18 0.60 5 1.00 Directed Unipartite airport_id code city state time airline flight_number tail_number crs_dep_time crs_arr_time dep_time arr_time dep_delay arr_delay cancelled cancellation_code diverted crs_elapsed_time actual_elapsed_time air_time distance carrier_delay weather_delay nas_delay security_delay late_aircraft_delay 25.5 MiB 66.4 MiB 62.3 MiB 60.1 MiB 1990 236 5,270,893 22334.29 82839.25 39.38 12.79 -0.19 0.59 5 1.00 Directed Unipartite airport_id code city state time airline flight_number tail_number crs_dep_time crs_arr_time dep_time arr_time dep_delay arr_delay cancelled cancellation_code diverted crs_elapsed_time actual_elapsed_time air_time distance carrier_delay weather_delay nas_delay security_delay late_aircraft_delay 32.5 MiB 70.9 MiB 66.3 MiB 85.2 MiB 1991 233 5,076,925 21789.38 78683.07 40.09 16.74 -0.17 0.60 5 1.00 Directed Unipartite airport_id code city state time airline flight_number tail_number crs_dep_time crs_arr_time dep_time arr_time dep_delay arr_delay cancelled cancellation_code diverted crs_elapsed_time actual_elapsed_time air_time distance carrier_delay weather_delay nas_delay security_delay late_aircraft_delay 30.9 MiB 67.5 MiB 63.1 MiB 81.8 MiB 1992 233 5,092,157 21854.75 81551.84 39.64 14.18 -0.21 0.60 5 1.00 Directed Unipartite airport_id code city state time airline flight_number tail_number crs_dep_time crs_arr_time dep_time arr_time dep_delay arr_delay cancelled cancellation_code diverted crs_elapsed_time actual_elapsed_time air_time distance carrier_delay weather_delay nas_delay security_delay late_aircraft_delay 31.0 MiB 67.8 MiB 63.3 MiB 82.9 MiB 1993 227 5,070,501 22337.01 84334.01 39.05 12.24 -0.21 0.60 5 1.00 Directed Unipartite airport_id code city state time airline flight_number tail_number crs_dep_time crs_arr_time dep_time arr_time dep_delay arr_delay cancelled cancellation_code diverted crs_elapsed_time actual_elapsed_time air_time distance carrier_delay weather_delay nas_delay security_delay late_aircraft_delay 31.1 MiB 68.1 MiB 63.6 MiB 82.8 MiB 1994 226 5,180,048 22920.57 85349.32 38.87 4.39 -0.19 0.61 5 0.99 Directed Unipartite airport_id code city state time airline flight_number tail_number crs_dep_time crs_arr_time dep_time arr_time dep_delay arr_delay cancelled cancellation_code diverted crs_elapsed_time actual_elapsed_time air_time distance carrier_delay weather_delay nas_delay security_delay late_aircraft_delay 32.0 MiB 69.9 MiB 65.3 MiB 85.4 MiB 1995 220 5,327,435 24215.61 90711.19 39.02 4.15 -0.19 0.62 5 0.99 Directed Unipartite airport_id code city state time airline flight_number tail_number crs_dep_time crs_arr_time dep_time arr_time dep_delay arr_delay cancelled cancellation_code diverted crs_elapsed_time actual_elapsed_time air_time distance carrier_delay weather_delay nas_delay security_delay late_aircraft_delay 62.5 MiB 90.3 MiB 84.8 MiB 115.8 MiB 1996 213 5,351,983 25126.68 92902.70 38.46 3.86 -0.18 0.62 5 0.99 Directed Unipartite airport_id code city state time airline flight_number tail_number crs_dep_time crs_arr_time dep_time arr_time dep_delay arr_delay cancelled cancellation_code diverted crs_elapsed_time actual_elapsed_time air_time distance carrier_delay weather_delay nas_delay security_delay late_aircraft_delay 63.3 MiB 91.7 MiB 86.0 MiB 117.1 MiB 1997 206 5,411,843 26271.08 95342.05 38.55 3.91 -0.18 0.63 4 1.00 Directed Unipartite airport_id code city state time airline flight_number tail_number crs_dep_time crs_arr_time dep_time arr_time dep_delay arr_delay cancelled cancellation_code diverted crs_elapsed_time actual_elapsed_time air_time distance carrier_delay weather_delay nas_delay security_delay late_aircraft_delay 64.1 MiB 92.6 MiB 86.9 MiB 118.9 MiB 1998 209 5,384,721 25764.22 94465.45 38.51 3.87 -0.17 0.64 5 0.99 Directed Unipartite airport_id code city state time airline flight_number tail_number crs_dep_time crs_arr_time dep_time arr_time dep_delay arr_delay cancelled cancellation_code diverted crs_elapsed_time actual_elapsed_time air_time distance carrier_delay weather_delay nas_delay security_delay late_aircraft_delay 64.3 MiB 92.6 MiB 86.9 MiB 118.3 MiB 1999 206 5,527,884 26834.39 96921.16 39.84 3.71 -0.16 0.65 5 1.00 Directed Unipartite airport_id code city state time airline flight_number tail_number crs_dep_time crs_arr_time dep_time arr_time dep_delay arr_delay cancelled cancellation_code diverted crs_elapsed_time actual_elapsed_time air_time distance carrier_delay weather_delay nas_delay security_delay late_aircraft_delay 66.6 MiB 96.2 MiB 90.4 MiB 122.1 MiB 2000 206 5,683,047 27587.61 99166.77 40.26 3.65 -0.16 0.66 5 1.00 Directed Unipartite airport_id code city state time airline flight_number tail_number crs_dep_time crs_arr_time dep_time arr_time dep_delay arr_delay cancelled cancellation_code diverted crs_elapsed_time actual_elapsed_time air_time distance carrier_delay weather_delay nas_delay security_delay late_aircraft_delay 42.1 MiB 96.6 MiB 90.6 MiB 93.3 MiB 2001 231 5,967,780 25834.55 99518.70 41.25 3.66 -0.22 0.61 5 1.00 Directed Unipartite airport_id code city state time airline flight_number tail_number crs_dep_time crs_arr_time dep_time arr_time dep_delay arr_delay cancelled cancellation_code diverted crs_elapsed_time actual_elapsed_time air_time distance carrier_delay weather_delay nas_delay security_delay late_aircraft_delay 43.2 MiB 100.9 MiB 94.2 MiB 98.1 MiB 2002 219 5,271,359 24070.13 92121.65 39.34 3.66 -0.24 0.59 5 1.00 Directed Unipartite airport_id code city state time airline flight_number tail_number crs_dep_time crs_arr_time dep_time arr_time dep_delay arr_delay cancelled cancellation_code diverted crs_elapsed_time actual_elapsed_time air_time distance carrier_delay weather_delay nas_delay security_delay late_aircraft_delay 39.5 MiB 89.0 MiB 83.2 MiB 89.7 MiB 2003 283 6,488,540 22927.70 99364.84 43.82 3.60 -0.30 0.55 4 1.00 Directed Unipartite airport_id code city state time airline flight_number tail_number crs_dep_time crs_arr_time dep_time arr_time dep_delay arr_delay cancelled cancellation_code diverted crs_elapsed_time actual_elapsed_time air_time distance carrier_delay weather_delay nas_delay security_delay late_aircraft_delay 57.3 MiB 113.0 MiB 106.0 MiB 115.7 MiB 2004 288 7,129,270 24754.41 107032.86 45.44 3.49 -0.31 0.55 5 1.00 Directed Unipartite airport_id code city state time airline flight_number tail_number crs_dep_time crs_arr_time dep_time arr_time dep_delay arr_delay cancelled cancellation_code diverted crs_elapsed_time actual_elapsed_time air_time distance carrier_delay weather_delay nas_delay security_delay late_aircraft_delay 71.8 MiB 131.6 MiB 123.9 MiB 136.5 MiB 2005 290 7,140,596 24622.74 105592.83 46.01 3.42 -0.32 0.55 5 1.00 Directed Unipartite airport_id code city state time airline flight_number tail_number crs_dep_time crs_arr_time dep_time arr_time dep_delay arr_delay cancelled cancellation_code diverted crs_elapsed_time actual_elapsed_time air_time distance carrier_delay weather_delay nas_delay security_delay late_aircraft_delay 72.4 MiB 133.1 MiB 125.3 MiB 139.1 MiB 2006 297 7,141,922 24046.88 105089.98 47.00 3.48 -0.32 0.56 5 1.00 Directed Unipartite airport_id code city state time airline flight_number tail_number crs_dep_time crs_arr_time dep_time arr_time dep_delay arr_delay cancelled cancellation_code diverted crs_elapsed_time actual_elapsed_time air_time distance carrier_delay weather_delay nas_delay security_delay late_aircraft_delay 75.8 MiB 136.7 MiB 129.0 MiB 143.6 MiB 2007 310 7,455,458 24049.86 104944.60 49.45 4.35 -0.31 0.57 5 1.00 Directed Unipartite airport_id code city state time airline flight_number tail_number crs_dep_time crs_arr_time dep_time arr_time dep_delay arr_delay cancelled cancellation_code diverted crs_elapsed_time actual_elapsed_time air_time distance carrier_delay weather_delay nas_delay security_delay late_aircraft_delay 78.6 MiB 145.0 MiB 136.8 MiB 152.0 MiB 2008 305 7,009,726 22982.71 100501.77 49.62 3.80 -0.30 0.58 5 1.00 Directed Unipartite airport_id code city state time airline flight_number tail_number crs_dep_time crs_arr_time dep_time arr_time dep_delay arr_delay cancelled cancellation_code diverted crs_elapsed_time actual_elapsed_time air_time distance carrier_delay weather_delay nas_delay security_delay late_aircraft_delay 74.0 MiB 136.4 MiB 128.8 MiB 143.2 MiB 2009 296 6,450,285 21791.50 96001.41 45.22 3.90 -0.32 0.53 4 1.00 Directed Unipartite airport_id code city state time airline flight_number tail_number crs_dep_time crs_arr_time dep_time arr_time dep_delay arr_delay cancelled cancellation_code diverted crs_elapsed_time actual_elapsed_time air_time distance carrier_delay weather_delay nas_delay security_delay late_aircraft_delay 64.9 MiB 123.5 MiB 116.7 MiB 129.0 MiB 2010 305 6,450,117 21147.92 94742.57 45.06 3.53 -0.32 0.52 4 1.00 Directed Unipartite airport_id code city state time airline flight_number tail_number crs_dep_time crs_arr_time dep_time arr_time dep_delay arr_delay cancelled cancellation_code diverted crs_elapsed_time actual_elapsed_time air_time distance carrier_delay weather_delay nas_delay security_delay late_aircraft_delay 65.8 MiB 124.2 MiB 117.4 MiB 131.2 MiB 2011 301 6,085,281 20216.88 92529.07 44.47 3.47 -0.33 0.53 5 1.00 Directed Unipartite airport_id code city state time airline flight_number tail_number crs_dep_time crs_arr_time dep_time arr_time dep_delay arr_delay cancelled cancellation_code diverted crs_elapsed_time actual_elapsed_time air_time distance carrier_delay weather_delay nas_delay security_delay late_aircraft_delay 63.7 MiB 118.8 MiB 112.4 MiB 125.2 MiB 2012 313 6,096,762 19478.47 91766.69 44.89 3.52 -0.33 0.54 5 1.00 Directed Unipartite airport_id code city state time airline flight_number tail_number crs_dep_time crs_arr_time dep_time arr_time dep_delay arr_delay cancelled cancellation_code diverted crs_elapsed_time actual_elapsed_time air_time distance carrier_delay weather_delay nas_delay security_delay late_aircraft_delay 66.0 MiB 119.3 MiB 112.9 MiB 126.8 MiB 2013 320 6,369,482 19904.63 93350.48 45.75 3.40 -0.34 0.54 5 1.00 Directed Unipartite airport_id code city state time airline flight_number tail_number crs_dep_time crs_arr_time dep_time arr_time dep_delay arr_delay cancelled cancellation_code diverted crs_elapsed_time actual_elapsed_time air_time distance carrier_delay weather_delay nas_delay security_delay late_aircraft_delay 71.3 MiB 128.2 MiB 121.5 MiB 135.3 MiB 2014 325 5,819,811 17907.11 86850.88 45.83 3.24 -0.35 0.54 5 1.00 Directed Unipartite airport_id code city state time airline flight_number tail_number crs_dep_time crs_arr_time dep_time arr_time dep_delay arr_delay cancelled cancellation_code diverted crs_elapsed_time actual_elapsed_time air_time distance carrier_delay weather_delay nas_delay security_delay late_aircraft_delay 66.6 MiB 118.0 MiB 111.8 MiB 124.9 MiB 2015 322 5,819,079 18071.67 88265.01 45.53 3.07 -0.34 0.55 4 1.00 Directed Unipartite airport_id code city state time airline flight_number tail_number crs_dep_time crs_arr_time dep_time arr_time dep_delay arr_delay cancelled cancellation_code diverted crs_elapsed_time actual_elapsed_time air_time distance carrier_delay weather_delay nas_delay security_delay late_aircraft_delay 65.4 MiB 116.9 MiB 110.8 MiB 124.8 MiB 2016 313 5,617,658 17947.79 85862.56 45.03 3.00 -0.30 0.59 5 1.00 Directed Unipartite airport_id code city state time airline flight_number tail_number crs_dep_time crs_arr_time dep_time arr_time dep_delay arr_delay cancelled cancellation_code diverted crs_elapsed_time actual_elapsed_time air_time distance carrier_delay weather_delay nas_delay security_delay late_aircraft_delay 62.8 MiB 112.3 MiB 106.3 MiB 121.7 MiB 2017 321 5,674,621 17677.95 84878.81 46.19 3.04 -0.29 0.61 5 1.00 Directed Unipartite airport_id code city state time airline flight_number tail_number crs_dep_time crs_arr_time dep_time arr_time dep_delay arr_delay cancelled cancellation_code diverted crs_elapsed_time actual_elapsed_time air_time distance carrier_delay weather_delay nas_delay security_delay late_aircraft_delay 61.0 MiB 113.9 MiB 107.9 MiB 123.5 MiB 2018 358 7,206,195 20129.04 96424.03 52.38 3.07 -0.32 0.60 6 1.00 Directed Unipartite airport_id code city state time airline flight_number tail_number crs_dep_time crs_arr_time dep_time arr_time dep_delay arr_delay cancelled cancellation_code diverted crs_elapsed_time actual_elapsed_time air_time distance carrier_delay weather_delay nas_delay security_delay late_aircraft_delay 78.3 MiB 147.2 MiB 139.3 MiB 159.0 MiB 2019 360 7,422,037 20616.77 98358.76 52.62 3.60 -0.33 0.59 6 1.00 Directed Unipartite airport_id code city state time airline flight_number tail_number crs_dep_time crs_arr_time dep_time arr_time dep_delay arr_delay cancelled cancellation_code diverted crs_elapsed_time actual_elapsed_time air_time distance carrier_delay weather_delay nas_delay security_delay late_aircraft_delay 80.9 MiB 150.4 MiB 142.6 MiB 160.7 MiB 2020 367 4,688,354 12774.81 62562.29 52.55 3.40 -0.35 0.57 6 1.00 Directed Unipartite airport_id code city state time airline flight_number tail_number crs_dep_time crs_arr_time dep_time arr_time dep_delay arr_delay cancelled cancellation_code diverted crs_elapsed_time actual_elapsed_time air_time distance carrier_delay weather_delay nas_delay security_delay late_aircraft_delay 47.9 MiB 88.0 MiB 82.7 MiB 93.9 MiB 2021 371 5,995,397 16160.10 79119.41 53.81 3.08 -0.36 0.57 5 1.00 Directed Unipartite airport_id code city state time airline flight_number tail_number crs_dep_time crs_arr_time dep_time arr_time dep_delay arr_delay cancelled cancellation_code diverted crs_elapsed_time actual_elapsed_time air_time distance carrier_delay weather_delay nas_delay security_delay late_aircraft_delay 66.7 MiB 120.1 MiB 113.8 MiB 128.1 MiB 2022 373 6,729,125 18040.55 86358.34 53.85 3.14 -0.32 0.61 5 1.00 Directed Unipartite airport_id code city state time airline flight_number tail_number crs_dep_time crs_arr_time dep_time arr_time dep_delay arr_delay cancelled cancellation_code diverted crs_elapsed_time actual_elapsed_time air_time distance carrier_delay weather_delay nas_delay security_delay late_aircraft_delay 75.0 MiB 137.2 MiB 130.1 MiB 142.2 MiB 2023 350 6,847,899 19565.43 91504.02 53.41 3.18 -0.31 0.63 5 1.00 Directed Unipartite airport_id code city state time airline flight_number tail_number crs_dep_time crs_arr_time dep_time arr_time dep_delay arr_delay cancelled cancellation_code diverted crs_elapsed_time actual_elapsed_time air_time distance carrier_delay weather_delay nas_delay security_delay late_aircraft_delay 76.6 MiB 141.3 MiB 134.3 MiB 147.3 MiB 2024 348 7,079,061 20342.13 95082.22 54.93 3.04 -0.33 0.62 5 1.00 Directed Unipartite airport_id code city state time airline flight_number tail_number crs_dep_time crs_arr_time dep_time arr_time dep_delay arr_delay cancelled cancellation_code diverted crs_elapsed_time actual_elapsed_time air_time distance carrier_delay weather_delay nas_delay security_delay late_aircraft_delay 79.2 MiB 147.3 MiB 140.2 MiB 153.7 MiB 2025 352 7,001,619 19890.96 94138.33 55.22 3.03 -0.33 0.61 5 1.00 Directed Unipartite airport_id code city state time airline flight_number tail_number crs_dep_time crs_arr_time dep_time arr_time dep_delay arr_delay cancelled cancellation_code diverted crs_elapsed_time actual_elapsed_time air_time distance carrier_delay weather_delay nas_delay security_delay late_aircraft_delay 77.6 MiB 146.9 MiB 139.8 MiB 153.5 MiB