Spire-ch-aviation Mapping

To access the full sample data set on Amazon Web Services manually or programmatically, the S3 bucket URLs are provided here.

To get user name and password for manual access or access key and secret key for programmatic access, contact sales@ch-aviation.com.

ColumnData TypeData descriptionKeyData SetJoin On
flight_idvarchar(255)Spire internal unique flight ID. Random UUIDv4 sequencePrimary/foreignFlightsflight_id
ch_code_operatorvarchar(5)Operator ch-aviation code (assigned by ch-aviation). Operator ch-aviation codes can be 2, 3, or 5 characters.ForeignOperatorsOperator ch-a Code
flight_typevarchar(20)Indicator of special flight types (ferry, technical, training)
ch_code_regional_partnershipvarchar(5)ch-aviation code for the carrier the regional partnership flights are operated for (assigned by ch-aviation). Operator ch-aviation codes can be 2, 3, or 5 characters.ForeignOperatorsOperator ch-a Code
regional_partnershipvarchar(255)Regional partnership name under which the flight is operatedForeignRegional SubsidiariesRel Subsidiary
ch_code_cargo_customervarchar(5)Cargo customer ch-aviation code (assigned by ch-aviation). Can be 2, 3, 4, or 5 characters.ForeignEntitiesEntity ch-a Code
cargo_customervarchar(255)Name of cargo customer for whom the flights is operated
ch_code_wet_lease_customervarchar(5)Wet lease customer ch-aviation code (assigned by ch-aviation). Can be 2, 3, 4, or 5 characters.ForeignEntitiesEntity ch-a Code
wet_lease_customervarchar(255)Wet lease customer name
notesvarchar(255)Additional free text notes related to the flight
aircraft_idint4Unique 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 setForeign (Combined)Aircraft HistoriesAircraft ID
date_from_fulldateFrom date with operator, registration and variant, the aircraft_id and date_from_full fields are the combined primary key of the Aircraft Histories data setForeign (Combined)Aircraft HistoriesDate From Full