| flight_id | varchar(255) | Spire internal unique flight ID. Random UUIDv4 sequence | Primary | | |
| date | timestamp | Date of flight in UTC | | | |
| observation_start | timestamp | Movement observation start time, UTC | | | |
| observation_end | timestamp | Movement observation end time, UTC | | | |
| altitude_start | int4 | Altitude at observation start in feet | | | |
| altitude_end | int4 | Altitude at observation end in feet | | | |
| callsign | varchar(255) | Flight callsign | | | |
| takeoff_time | timestamp | Take off time, UTC | | | |
| landing_time | timestamp | Landing time, UTC | | | |
| origin_airport_icao | varchar(6) | Origin airport ICAO code | Foreign | Airports | Airport ICAO |
| origin_airport_iata | varchar(3) | Origin airport IATA code | Foreign | Airports | Airport IATA |
| destination_airport_icao | varchar(6) | Destination airport ICAO code | Foreign | Airports | Airport ICAO |
| destination_airport_iata | varchar(3) | Destination airport IATA code | Foreign | Airports | Airport IATA |
| speed_start | int4 | Speed at observation start in km/h | | | |
| speed_end | int4 | Speed at observation end in km/h | | | |
| duration | int4 | Flight duration formatted as hh:mm:ss, difference between landing time and take off time, NULL if one or both are not recorded | | | |
| max_time | timestamp | Maximum of all time stamps for a flight, UTC | | | |
| flight_type | varchar(20) | Indicator of special flight types (ferry, technical, training) | | | |
| regional_partnership | varchar(255) | Regional partnership name under which the flight is operated | Foreign | Regional Subsidiaries | Rel Subsidiary |
| cargo_customer | varchar(255) | Name of cargo customer for whom the flights is operated | | | |
| callsign_icao | varchar(3) | Callsign Operator ICAO three-character code | | | |
| callsign_flight_number | varchar(4) | Callsign Operator flight number | | | |
| callsign_suffix | char(1) | Callsign Operator flight number suffix | | | |
| wet_lease_cha_code | varchar(5) | Wet-lease customer ch-aviation code (assigned by ch-aviation). Same as Operator ch-aviation codes, can be 2, 3, or 5 characters. | Foreign | Operators | Operator ch-a Code |
| wet_lease_customer_name | varchar(255) | Wet-lease customer name | | | |
| id | int4 | Unique ch-aviation created aircraft ID, remains stable throughout an aircraft's life (assigned by ch-aviation), the aircraft_id and date_from_full fields are the combined primary key of the Aircraft Histories data set | Foreign | Aircraft | Aircraft ID |
| cn | varchar(16) | Construction/Line Number | | | |
| msn | varchar(16) | Manufacturer Serial Number | | | |
| aircraft_variant | varchar(255) | Aircraft Variant designation (i.e. A321-200N) | | | |
| ch_airline_code | varchar(5) | Operator ch-aviation code (assigned by ch-aviation). Operator ch-aviation codes can be 2, 3, or 5 characters. | Foreign | Operators | Operator ch-a Code |
| airline_name | varchar(255) | Operator name | | | |
| icao | varchar(3) | Operator ICAO three-character code | | | |
| reg | varchar(16) | Aircraft Registration, blank if unknown or no longer registered | | | |
| hexcode | char(6) | ICAO 24-bit address/Mode-S hexcode | | | |
| seats_y | smallint(6) | Seats in Economy | | | |
| seats_yp | smallint(6) | Seats in Economy Plus/Comfort, ch-aviation applies the following methodology for Economy Plus/Comfort vs. Premium Economy aircraft seat configurations/capacity calculations to ensure comparability across all carriers worldwide: ch-aviation only considers cabins to be Premium Economy if the maximum number of seats per row (Max Abreast) is at least 2 seats less than the maximum number of seats that could physically be fitted in Economy Class for the aircraft type (i.e. 10 for a B777) no matter what the actual maximum abreast configuration on that aircraft is. | | | |
| seats_w | smallint(6) | Seats in Premium Economy, ch-aviation applies the following methodology for Economy Plus/Comfort vs. Premium Economy aircraft seat configurations/capacity calculations to ensure comparability across all carriers worldwide: ch-aviation only considers cabins to be Premium Economy if the maximum number of seats per row (Max Abreast) is at least 2 seats less than the maximum number of seats that could physically be fitted in Economy Class for the aircraft type (i.e. 10 for a B777) no matter what the actual maximum abreast configuration on that aircraft is. | | | |
| seats_c | smallint(6) | Seats in Business, ch-aviation applies the following methodology for Business vs. First aircraft seat configurations/capacity calculations to ensure comparability across all carriers worldwide: ch-aviation only considers narrowbody cabins to be First Class if the maximum number of seats per row (Max Abreast) is 2 and widebody cabins to be First Class if the maximum number of seats across per row is 4 (unless there is a Business and First Class cabin installed on the aircraft and the First Class cabin has more than 4 seats across per row in these exceptional cases). | | | |
| seats_f | smallint(6) | Seats in First, ch-aviation applies the following methodology for Business vs. First aircraft seat configurations/capacity calculations to ensure comparability across all carriers worldwide: ch-aviation only considers narrowbody cabins to be First Class if the maximum number of seats per row (Max Abreast) is 2 and widebody cabins to be First Class if the maximum number of seats across per row is 4 (unless there is a Business and First Class cabin installed on the aircraft and the First Class cabin has more than 4 seats across per row in these exceptional cases). | | | |
| aircraft_role | char(3) | Aircraft's primary role (PAX = Passenger, CAR = Cargo, QUI = Quick Change) | | | |
