Field Name | Description |
---|
|
Passengers | On-Flight Market Passengers Enplaned | Analysis |
Freight | On-Flight Market Freight Enplaned (pounds) | Analysis |
Mail | On-Flight Market Mail Enplaned (pounds) | Analysis |
Distance | Distance between airports (miles) | |
|
UniqueCarrier | Unique Carrier Code. When the same code has been used by multiple carriers, a numeric suffix is used for earlier users, for example, PA, PA(1), PA(2). Use this field for analysis across a range of years. | Analysis |
AirlineID | An identification number assigned by US DOT to identify a unique airline (carrier). A unique airline (carrier) is defined as one holding and reporting under the same DOT certificate regardless of its Code, Name, or holding company/corporation. | Analysis |
UniqueCarrierName | Unique Carrier Name. When the same name has been used by multiple carriers, a numeric suffix is used for earlier users, for example, Air Caribbean, Air Caribbean (1). | |
UniqCarrierEntity | Unique Entity for a Carrier's Operation Region. | Analysis |
CarrierRegion | Carrier's Operation Region. Carriers Report Data by Operation Region | Analysis |
Carrier | Code assigned by IATA and commonly used to identify a carrier. As the same code may have been assigned to different carriers over time, the code is not always unique. For analysis, use the Unique Carrier Code. | |
CarrierName | Carrier Name | |
CarrierGroup | Carrier Group Code. Used in Legacy Analysis | Analysis |
CarrierGroupNew | Carrier Group New | Analysis |
|
OriginAirportID | Origin Airport, Airport ID. An identification number assigned by US DOT to identify a unique airport. Use this field for airport analysis across a range of years because an airport can change its airport code and airport codes can be reused. | Analysis |
OriginAirportSeqID | Origin Airport, Airport Sequence ID. An identification number assigned by US DOT to identify a unique airport at a given point of time. Airport attributes, such as airport name or coordinates, may change over time. | |
OriginCityMarketID | Origin Airport, City Market ID. City Market ID is an identification number assigned by US DOT to identify a city market. Use this field to consolidate airports serving the same city market. | Analysis |
Origin | Origin Airport | Analysis |
OriginCityName | Origin Airport, City Name | |
OriginCountry | Origin Airport, Country | Analysis |
OriginCountryName | Origin Airport, Country Name | |
OriginWac | Origin Airport, World Area Code | Analysis |
|
DestAirportID | Destination Airport, Airport ID. An identification number assigned by US DOT to identify a unique airport. Use this field for airport analysis across a range of years because an airport can change its airport code and airport codes can be reused. | Analysis |
DestAirportSeqID | Destination Airport, Airport Sequence ID. An identification number assigned by US DOT to identify a unique airport at a given point of time. Airport attributes, such as airport name or coordinates, may change over time. | |
DestCityMarketID | Destination Airport, City Market ID. City Market ID is an identification number assigned by US DOT to identify a city market. Use this field to consolidate airports serving the same city market. | Analysis |
Dest | Destination Airport | Analysis |
DestCityName | Dest Airport, City Name | |
DestCountry | Destination Airport, Country | Analysis |
DestCountryName | Destination Airport, Country Name | |
DestWac | Destination Airport, World Area Code | Analysis |
|
Year | Year | |
Quarter | Quarter | Analysis |
Month | Month | Analysis |
|
DistanceGroup | Distance Intervals, every 500 Miles, for Flight Segment | Analysis |
Class | Service Class | Analysis |