logo Netzschleuder network catalog, repository, and centrifuge

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 time is 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\xe2 for N850US, invalid in UTF-8); they are decoded.
  • (Edge) crs_dep_time, crs_arr_time: the scheduled times of departure and arrival, in local time as hhmm (e.g. 937 for 9:37).
  • (Edge) dep_time, arr_time: the actual times of departure and arrival, in local time as hhmm (-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 (A carrier, B weather, C national air system, D security; 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).
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