All nonstop commercial departures operating between international points and U.S. airports.
This dataset has the following 16 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
data_dte | data_dte | calendar_date | Data Date | 2023-06-01T00:00:00.000 2023-07-01T00:00:00.000 2023-04-01T00:00:00.000 2023-03-01T00:00:00.000 2023-01-01T00:00:00.000 view top 100 |
Year | year | number | Data Year | 2023 2022 2018 2017 2019 view top 100 |
Month | month | number | Data Month | 3 12 1 7 6 view top 100 |
usg_apt_id | usg_apt_id | number | US Gateway Airport ID - assigned by US DOT to identify an airport | 13303 12478 12892 13930 11618 view top 100 |
usg_apt | usg_apt | text | US Gateway Airport Code - usually assigned by IATA, but in absence of IATA designation, may show FAA-assigned code | MIA JFK LAX ORD EWR view top 100 |
usg_wac | usg_wac | number | US Gateway World Area Code - assigned by US DOT to represent a geographic territory | 33 22 91 74 41 view top 100 |
fg_apt_id | fg_apt_id | number | Foreign Gateway Airport ID - assigned by US DOT to identify an airport | 16271 11032 13252 16229 13744 view top 100 |
fg_apt | fg_apt | text | Foreign Gateway Airport Code - usually assigned by IATA, but in absense of IATA designation, may show FAA-assigned code | YYZ CUN MEX YVR NRT view top 100 |
fg_wac | fg_wac | number | Foreign Gateway World Area Code - assigned by US DOT to represent a geographic territory | 148 936 493 736 429 view top 100 |
airlineid | airlineid | number | Airline ID - assigned by US DOT to identify an air carrier | 19805 19790 19977 20107 19704 view top 100 |
carrier | carrier | text | IATA-assigned air carrier code. If carrier has no IATA code, ICAO- or FAA-assigned code may be used | AA DL UA CO FX view top 100 |
carriergroup | carriergroup | number | Carrier Group Code - 1 denotes US domestic air carriers, 0 denotes foreign air carriers | 1 0 view top 100 |
type | type | text | Defines the type of the four metrics in this report | Departures view top 100 |
Scheduled | scheduled | number | Metric flown by scheduled service operations | 0 1 62 60 8 view top 100 |
Charter | charter | number | Metric flown by charter operations | 0 1 2 4 3 view top 100 |
Total | total | number | Total Metric flown by scheduled service and charter operations | 1 2 62 60 8 view top 100 |