| 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 |
