| Field | Type | Description | Example |
|---|---|---|---|
| SOURCE | VARCHAR(11) | Specific data channel from FAA | ARRIVAL |
| ORG | VARCHAR(200) | Origin airport code, name, and metropolitan area | KLAX/LAX: LOS ANGELES,CA (Los Angeles) |
| ORG_ICAO | VARCHAR(10) | Origin airport 4-character ICAO code, if any | KLAX |
| ORG_IATA | VARCHAR(10) | Origin airport 3-character IATA code, if any | LAX |
| O_CITY | VARCHAR(50) | Origin city | Los Angeles |
| O_TIMEZONE | VARCHAR(50) | Origin time zone | America/Los_Angeles |
| O_STATE | VARCHAR(50) | Origin state code, if any | CA |
| O_COUNTRY | VARCHAR(50) | Origin country code | US |
| GATE | VARCHAR(20) | Departure Gate | G52H |
| DST | VARCHAR(200) | Destination airport code, name, and metropolitan area | KGPI/FCA: KALISPELL,MT (Kalispell-Glacier) |
| DST_ICAO | VARCHAR(10) | Destination airport ICAO code, if any | KGPI |
| DST_IATA | VARCHAR(10) | Destination airport IATA code, if any | FCA |
| D_CITY | VARCHAR(50) | Destination city | Kalispell |
| D_TIMEZONE | VARCHAR(50) | Destination time zone | America/Denver |
| D_STATE | VARCHAR(50) | Destination state code, if any | MT |
| D_COUNTRY | VARCHAR(50) | Destination country code | US |
| AIRLINE | VARCHAR(4) | Carrier ICAO code | SKW |
| AIRLINE_IATA | VARCHAR(3) | Carrier IATA code | OO |
| AL_NAME | VARCHAR(15000) | Carrier name, if any | Skywest Airlines |
| CALLSIGN | VARCHAR(20) | Aircraft Call Sign | SKW5704 |
| AIRCRAFT_ID | VARCHAR(20) | Aircraft ID, which could be aircraft call sign or tail number | SKW5704 |
| FLIGHT_NO | VARCHAR | Flight number, if any | 5704 |
| AIRCRAFT_TYPE | VARCHAR(10) | ICAO aircraft type code | E75L |
| AC_CATEGORY | VARCHAR(26) | ICAO aircraft category | Jet_M |
| SEATS | NUMBER | Number of seats | 77 |
| LOCAL_DATE | DATE | Departure date in local time | 2021-08-18 |
| DOW | VARCHAR(3) | Day of week in local time | Wed |
| GATE_DEPARTURE | TIMESTAMP | Departure time from the gate, if any | 2021-08-18 11:58:00 |
| DEPARTURE_UTC | TIMESTAMP | Departure time in UTC | 2021-08-18 19:51:00 |
| ARRIVAL_UTC | TIMESTAMP | Arrival time in UTC | 2021-08-18 22:18:00 |
| DEPARTURE | TIMESTAMP | Local departure time | 2021-08-18 12:51:00 |
| ARRIVAL | TIMESTAMP | Local arrival time | 2021-08-18 16:18:00 |
| SCHEDULED_DEPARTURE_UTC | TIMESTAMP | Scheduled departure time in UTC | 2021-08-18 19:00:00 |
| SCHEDULED_ARRIVAL_UTC | TIMESTAMP | Scheduled arrival time in UTC | 2021-08-18 21:09:47 |
| SCHEDULED_DEPARTURE | TIMESTAMP | Scheduled local departure time | 2021-08-18 12:00:00 |
| SCHEDULED_ARRIVAL | TIMESTAMP | Scheduled local arrival time | 2021-08-18 15:09:47 |
| SCHEDULED_ORG | VARCHAR(10) | Scheduled origin airport code | KLAX |
| SCHEDULED_DST | VARCHAR(10) | Scheduled destination airport code | KGPI |
| SCHEDULED_AIRCRAFT_TYPE | VARCHAR(10) | Scheduled aircraft type code | CRJ7 |
| FLIGHT_MINUTES | NUMBER | Minutes of flight time | 147 |
| BLOCK_MINUTES | NUMBER | Minutes of block time, which equals taxi-out time + flight time + taxi-in time | 167 |
| TAXI_IN | NUMBER | Minutes from run-way wheels down to the gate | 4 |
| TAXI_OUT | NUMBER | Minutes from the gate to run-way wheels up | 16 |
| DEPARTURE_DELAY | NUMBER | Departure delay in minutes | 51 |
| ARRIVAL_DELAY | NUMBER | Arrival delay in minutes | 69 |
| MILES | DOUBLE | Miles between the origin airport and the destination airport | 1016 |
| FLIGHT_REF | VARCHAR(20) | Flight reference code | 162932749 |
| FLIGHT_PLAN | VARCHAR(4096) | Flight plan code | KL65413400 |
| LOAD_TIME | TIMESTAMP | Time when the data is loaded | 2021-08-18 22:19:17 |
Flight BI
Flight Business Intelligence