FAA and Bureau of Transportation Statistics
Airports & air traffic
Every public and private airport and runway, passengers boarding and cargo by airport, and airline flights and passengers between airports by month.
Published by FAA and Bureau of Transportation Statistics
Finest detail facility
Tables 6
Airline flights between airports
Sample of 25 rows out of about 8,696,187
· 48 columns
| id | departures_scheduled | departures_performed | payload | seats | passengers | freight | distance | ramp_to_ramp | air_time | unique_carrier | airline_id | unique_carrier_name | unique_carrier_entity | region | carrier | carrier_name | carrier_group | carrier_group_new | origin_airport_id | origin_airport_seq_id | origin_city_market_id | origin | origin_city_name | origin_state_abr | origin_state_fips | origin_state_nm | origin_wac | dest_airport_id | dest_airport_seq_id | dest_city_market_id | dest | dest_city_name | dest_state_abr | dest_state_fips | dest_state_nm | dest_wac | aircraft_group | aircraft_type | aircraft_config | year | quarter | month | distance_group | class | origin_county_fips | dest_county_fips | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | TW | 20211 | Trans World Airways LLC | 0A845 | D | TW | Trans World Airlines Inc. | 3 | 3 | 11423 | 1142302 | 31423 | DSM | Des Moines, IA | IA | 19 | Iowa | 61 | 11423 | 1142302 | 31423 | DSM | Des Moines, IA | IA | 19 | Iowa | 61 | 6 | 655 | 1 | 2000 | 1 | 1 | 1 | F | 19153 | 19153 |
| 2 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | TW | 20211 | Trans World Airways LLC | 0A845 | D | TW | Trans World Airlines Inc. | 3 | 3 | 14683 | 1468301 | 33214 | SAT | San Antonio, TX | TX | 48 | Texas | 74 | 14683 | 1468301 | 33214 | SAT | San Antonio, TX | TX | 48 | Texas | 74 | 6 | 655 | 1 | 2000 | 1 | 1 | 1 | F | 48029 | 48029 |
| 3 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 51.0 | 0.0 | TW | 20211 | Trans World Airways LLC | 0A845 | D | TW | Trans World Airlines Inc. | 3 | 3 | 15016 | 1501601 | 31123 | STL | St. Louis, MO | MO | 29 | Missouri | 64 | 15016 | 1501601 | 31123 | STL | St. Louis, MO | MO | 29 | Missouri | 64 | 6 | 655 | 1 | 2000 | 1 | 1 | 1 | F | 29189 | 29189 |
| 4 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 30.0 | 0.0 | 0.0 | TW | 20211 | Trans World Airways LLC | 0A845 | D | TW | Trans World Airlines Inc. | 3 | 3 | 14771 | 1477101 | 32457 | SFO | San Francisco, CA | CA | 06 | California | 91 | 14831 | 1483101 | 32457 | SJC | San Jose, CA | CA | 06 | California | 91 | 6 | 655 | 1 | 2000 | 1 | 1 | 1 | F | 06081 | 06085 |
| 5 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 80.0 | 0.0 | 0.0 | JI (1) | 20297 | Midway Airlines Inc. | 06693 | D | JI | Midway Airlines Inc. | 2 | 2 | 15304 | 1530401 | 33195 | TPA | Tampa, FL | FL | 12 | Florida | 33 | 13204 | 1320401 | 31454 | MCO | Orlando, FL | FL | 12 | Florida | 33 | 6 | 603 | 1 | 2000 | 1 | 1 | 1 | F | 12057 | 12095 |
| 6 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 81.0 | 0.0 | 0.0 | JI (1) | 20297 | Midway Airlines Inc. | 06693 | D | JI | Midway Airlines Inc. | 2 | 2 | 14100 | 1410001 | 34100 | PHL | Philadelphia, PA | PA | 42 | Pennsylvania | 23 | 11618 | 1161801 | 31703 | EWR | Newark, NJ | NJ | 34 | New Jersey | 21 | 6 | 603 | 1 | 2000 | 1 | 1 | 1 | F | 42045 | 34013 |
| 7 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 318.0 | 0.0 | 0.0 | JI (1) | 20297 | Midway Airlines Inc. | 06693 | D | JI | Midway Airlines Inc. | 2 | 2 | 12451 | 1245101 | 31136 | JAX | Jacksonville, FL | FL | 12 | Florida | 33 | 11697 | 1169702 | 32467 | FLL | Fort Lauderdale, FL | FL | 12 | Florida | 33 | 6 | 603 | 1 | 2000 | 1 | 1 | 1 | F | 12031 | 12011 |
| 8 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 356.0 | 0.0 | 0.0 | JI (1) | 20297 | Midway Airlines Inc. | 06693 | D | JI | Midway Airlines Inc. | 2 | 2 | 10397 | 1039702 | 30397 | ATL | Atlanta, GA | GA | 13 | Georgia | 34 | 14492 | 1449201 | 34492 | RDU | Raleigh/Durham, NC | NC | 37 | North Carolina | 36 | 6 | 603 | 1 | 2000 | 1 | 1 | 1 | F | 13063 | 37183 |
| 9 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 356.0 | 0.0 | 0.0 | JI (1) | 20297 | Midway Airlines Inc. | 06693 | D | JI | Midway Airlines Inc. | 2 | 2 | 14492 | 1449201 | 34492 | RDU | Raleigh/Durham, NC | NC | 37 | North Carolina | 36 | 10397 | 1039702 | 30397 | ATL | Atlanta, GA | GA | 13 | Georgia | 34 | 6 | 603 | 1 | 2000 | 1 | 1 | 1 | F | 37183 | 13063 |
| 10 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 408.0 | 0.0 | 0.0 | JI (1) | 20297 | Midway Airlines Inc. | 06693 | D | JI | Midway Airlines Inc. | 2 | 2 | 14492 | 1449201 | 34492 | RDU | Raleigh/Durham, NC | NC | 37 | North Carolina | 36 | 12451 | 1245101 | 31136 | JAX | Jacksonville, FL | FL | 12 | Florida | 33 | 6 | 603 | 1 | 2000 | 1 | 1 | 1 | F | 37183 | 12031 |
| 11 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 431.0 | 0.0 | 0.0 | JI (1) | 20297 | Midway Airlines Inc. | 06693 | D | JI | Midway Airlines Inc. | 2 | 2 | 12953 | 1295301 | 31703 | LGA | New York, NY | NY | 36 | New York | 22 | 14492 | 1449201 | 34492 | RDU | Raleigh/Durham, NC | NC | 37 | North Carolina | 36 | 6 | 629 | 1 | 2000 | 1 | 1 | 1 | F | 36081 | 37183 |
| 12 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 431.0 | 0.0 | 0.0 | JI (1) | 20297 | Midway Airlines Inc. | 06693 | D | JI | Midway Airlines Inc. | 2 | 2 | 14492 | 1449201 | 34492 | RDU | Raleigh/Durham, NC | NC | 37 | North Carolina | 36 | 12953 | 1295301 | 31703 | LGA | New York, NY | NY | 36 | New York | 22 | 6 | 629 | 1 | 2000 | 1 | 1 | 1 | F | 37183 | 36081 |
| 13 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 463.0 | 0.0 | 0.0 | JI (1) | 20297 | Midway Airlines Inc. | 06693 | D | JI | Midway Airlines Inc. | 2 | 2 | 14492 | 1449201 | 34492 | RDU | Raleigh/Durham, NC | NC | 37 | North Carolina | 36 | 15070 | 1507001 | 31703 | SWF | Newburgh/Poughkeepsie, NY | NY | 36 | New York | 22 | 6 | 603 | 1 | 2000 | 1 | 1 | 1 | F | 37183 | 36071 |
| 14 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 463.0 | 0.0 | 0.0 | JI (1) | 20297 | Midway Airlines Inc. | 06693 | D | JI | Midway Airlines Inc. | 2 | 2 | 15070 | 1507001 | 31703 | SWF | Newburgh/Poughkeepsie, NY | NY | 36 | New York | 22 | 14492 | 1449201 | 34492 | RDU | Raleigh/Durham, NC | NC | 37 | North Carolina | 36 | 6 | 603 | 1 | 2000 | 1 | 1 | 1 | F | 36071 | 37183 |
| 15 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 634.0 | 0.0 | 0.0 | JI (1) | 20297 | Midway Airlines Inc. | 06693 | D | JI | Midway Airlines Inc. | 2 | 2 | 13244 | 1324401 | 33244 | MEM | Memphis, TN | TN | 47 | Tennessee | 54 | 14492 | 1449201 | 34492 | RDU | Raleigh/Durham, NC | NC | 37 | North Carolina | 36 | 6 | 603 | 1 | 2000 | 1 | 1 | 2 | F | 47157 | 37183 |
| 16 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 634.0 | 0.0 | 0.0 | JI (1) | 20297 | Midway Airlines Inc. | 06693 | D | JI | Midway Airlines Inc. | 2 | 2 | 14492 | 1449201 | 34492 | RDU | Raleigh/Durham, NC | NC | 37 | North Carolina | 36 | 13244 | 1324401 | 33244 | MEM | Memphis, TN | TN | 47 | Tennessee | 54 | 6 | 603 | 1 | 2000 | 1 | 1 | 2 | F | 37183 | 47157 |
| 17 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 779.0 | 0.0 | 0.0 | JI (1) | 20297 | Midway Airlines Inc. | 06693 | D | JI | Midway Airlines Inc. | 2 | 2 | 13495 | 1349501 | 33495 | MSY | New Orleans, LA | LA | 22 | Louisiana | 72 | 14492 | 1449201 | 34492 | RDU | Raleigh/Durham, NC | NC | 37 | North Carolina | 36 | 6 | 603 | 1 | 2000 | 1 | 1 | 2 | F | 22051 | 37183 |
| 18 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 779.0 | 0.0 | 0.0 | JI (1) | 20297 | Midway Airlines Inc. | 06693 | D | JI | Midway Airlines Inc. | 2 | 2 | 14492 | 1449201 | 34492 | RDU | Raleigh/Durham, NC | NC | 37 | North Carolina | 36 | 13495 | 1349501 | 33495 | MSY | New Orleans, LA | LA | 22 | Louisiana | 72 | 6 | 603 | 1 | 2000 | 1 | 1 | 2 | F | 37183 | 22051 |
| 19 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 989.0 | 0.0 | 0.0 | JI (1) | 20297 | Midway Airlines Inc. | 06693 | D | JI | Midway Airlines Inc. | 2 | 2 | 13204 | 1320401 | 31454 | MCO | Orlando, FL | FL | 12 | Florida | 33 | 15070 | 1507001 | 31703 | SWF | Newburgh/Poughkeepsie, NY | NY | 36 | New York | 22 | 6 | 603 | 1 | 2000 | 1 | 1 | 2 | F | 12095 | 36071 |
| 20 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 989.0 | 0.0 | 0.0 | JI (1) | 20297 | Midway Airlines Inc. | 06693 | D | JI | Midway Airlines Inc. | 2 | 2 | 15070 | 1507001 | 31703 | SWF | Newburgh/Poughkeepsie, NY | NY | 36 | New York | 22 | 13204 | 1320401 | 31454 | MCO | Orlando, FL | FL | 12 | Florida | 33 | 6 | 603 | 1 | 2000 | 1 | 1 | 2 | F | 36071 | 12095 |
| 21 | 0.0 | 1.0 | 1000.0 | 3.0 | 0.0 | 0.0 | 0.0 | 108.0 | 60.0 | 56.0 | 5V | 20408 | Tatonduk Outfitters Limited d/b/a Everts Air Alaska and Everts Air Cargo | 06860 | D | 3K | Tatonduk Outfitters Limited d/b/a Tatonduk Flying Service | 1 | 1 | 15725 | 1572501 | 35725 | WBQ | Beaver, AK | AK | 02 | Alaska | 1 | 11630 | 1163001 | 31517 | FAI | Fairbanks, AK | AK | 02 | Alaska | 1 | 0 | 035 | 2 | 2000 | 1 | 1 | 1 | F | 02290 | 02090 |
| 22 | 0.0 | 1.0 | 1000.0 | 3.0 | 0.0 | 0.0 | 516.0 | 53.0 | 23.0 | 19.0 | 5V | 20408 | Tatonduk Outfitters Limited d/b/a Everts Air Alaska and Everts Air Cargo | 06860 | D | 3K | Tatonduk Outfitters Limited d/b/a Tatonduk Flying Service | 1 | 1 | 15725 | 1572501 | 35725 | WBQ | Beaver, AK | AK | 02 | Alaska | 1 | 15581 | 1558101 | 35581 | VEE | Venetie, AK | AK | 02 | Alaska | 1 | 0 | 035 | 2 | 2000 | 1 | 1 | 1 | F | 02290 | 02290 |
| 23 | 0.0 | 1.0 | 1000.0 | 3.0 | 1.0 | 0.0 | 0.0 | 158.0 | 88.0 | 84.0 | 5V | 20408 | Tatonduk Outfitters Limited d/b/a Everts Air Alaska and Everts Air Cargo | 06860 | D | 3K | Tatonduk Outfitters Limited d/b/a Tatonduk Flying Service | 1 | 1 | 15581 | 1558101 | 35581 | VEE | Venetie, AK | AK | 02 | Alaska | 1 | 11630 | 1163001 | 31517 | FAI | Fairbanks, AK | AK | 02 | Alaska | 1 | 0 | 035 | 2 | 2000 | 1 | 1 | 1 | F | 02290 | 02090 |
| 24 | 0.0 | 1.0 | 1000.0 | 5.0 | 0.0 | 0.0 | 0.0 | 0.0 | 15.0 | 11.0 | 5V | 20408 | Tatonduk Outfitters Limited d/b/a Everts Air Alaska and Everts Air Cargo | 06860 | D | 3K | Tatonduk Outfitters Limited d/b/a Tatonduk Flying Service | 1 | 1 | 11630 | 1163001 | 31517 | FAI | Fairbanks, AK | AK | 02 | Alaska | 1 | 11630 | 1163001 | 31517 | FAI | Fairbanks, AK | AK | 02 | Alaska | 1 | 0 | 079 | 2 | 2000 | 1 | 1 | 1 | F | 02090 | 02090 |
| 25 | 0.0 | 1.0 | 1000.0 | 5.0 | 0.0 | 0.0 | 0.0 | 15.0 | 18.0 | 14.0 | 5V | 20408 | Tatonduk Outfitters Limited d/b/a Everts Air Alaska and Everts Air Cargo | 06860 | D | 3K | Tatonduk Outfitters Limited d/b/a Tatonduk Flying Service | 1 | 1 | 13768 | 1376801 | 33768 | NUL | Nulato, AK | AK | 02 | Alaska | 1 | 12868 | 1286801 | 32868 | KYU | Koyukuk, AK | AK | 02 | Alaska | 1 | 0 | 079 | 2 | 2000 | 1 | 1 | 1 | F | 02290 | 02290 |
Need the whole thing? Spreadsheet links, downloads, and AI access come with Level 3.
See pricing