| Field | Type | Description | Example |
|---|---|---|---|
| YYMM | VARCHAR(4) | Travel year and month | 2106 |
| YEAR | INTEGER | Travel year | 2021 |
| MONTH | INTEGER | Travel month | 6 |
| ORG | VARCHAR(3) | IATA airport code of the segment origin | ATL |
| ORG_ID | INTEGER | Unique US DOT ID of the segment origin airport | 30397 |
| O_WAC | INTEGER | Origin world area code | 34 |
| O_STATE | VARCHAR(50) | Origin state code | GA |
| O_COUNTRY | VARCHAR(2) | Origin country code | US |
| O_NAME | VARCHAR(100) | Origin name | Atlanta, GA |
| DST | VARCHAR(3) | IATA airport code of the segment destination | DFW |
| DST_ID | INTEGER | Unique US DOT ID of the segment destination airport | 30194 |
| D_WAC | INTEGER | Destination world area code | 74 |
| D_STATE | VARCHAR(50) | Destination state code | TX |
| D_COUNTRY | VARCHAR(2) | Destination country code | US |
| D_NAME | VARCHAR(100) | Destination name | Dallas/Fort Worth, TX |
| DI | VARCHAR(1) | Domestic or international | D |
| PARENT_AL | VARCHAR(3) | IATA code of the parent operating airline | AA |
| AIRLINE | VARCHAR(3) | IATA code of the metal operating airline | AA |
| ENTITY | VARCHAR(5) | Unique US DOT airline code over years | 0A050 |
| GROUP_CODE | INTEGER | Airline group number | 3 |
| AL_COUNTRY | VARCHAR(2) | Airline domicile country code | US |
| AIRCRAFT | VARCHAR(3) | Aircraft code | 321 |
| AC_GROUP | INTEGER | Aircraft group number | 6 |
| AC_TYPE | INTEGER | Aircraft type number | 699 |
| AC_CONFIG | INTEGER | Aircraft configuration number | 1 |
| ACTUAL_DEPARTURES | INTEGER | Actual departures on the segment in the month | 101 |
| SCHEDULED_DEPARTURES | INTEGER | Scheduled departures on the segment in the month | 104 |
| PAX | INTEGER | Number of passengers transported on the segment | 17294 |
| FREIGHT | INTEGER | Pounds of Freight transported on the segment | 8853 |
| INTEGER | Pounds of Mails transported on the segment | 0 | |
| SEATS | INTEGER | Number of seats on the segment | 18905 |
| PAYLOAD | INTEGER | Available payload in pounds | 5159600 |
| MLW_TONNE | DOUBLE | Maximum Landing Weight in metric tonnes | 7858 |
| ASM | INTEGER | Available Seat Miles | 13819555 |
| RPM | INTEGER | Revenue Passenger Miles | 12641914 |
| BLOCK_MINUTES | INTEGER | Block time in minutes | 14095 |
| FLOWN_MINUTES | INTEGER | Flown time in minutes | 10872 |
| MILES | INTEGER | Miles between the segment origin and the segment destination | 731 |
| SERVICE | VARCHAR(1) | Service code | F |
| FILE | VARCHAR(100) | Data source file | t100/raw/dom_seg/db28seg.dd.wac.202007.202106.asc.gz |
Flight BI
Flight Business Intelligence