Do you also provide an API?

ch-aviation can provide the data feeds to you directly via file transfer protocol (FTP), safe file transfer protocol (SFTP) or a shared Amazon Web Services (AWS) S3 bucket.

Which delivery formats you support?

The data is provided as Comma-separated values (.csv) flat files. Optionally we can provide them as Microsoft Excel (.xlsx) or XML (.xml)

How often does data get updated?

The ch-aviation database is updated in batches to ensure all data flows through ch-aviation’s semi-automated quality assurance process built to maximise data integrity. As a result, the data set remains relatively static in the ch-aviation production database, for most data sets for a week or month at a time. Therefore, the most efficient integration option is the transfer of flat files provided for integration into your own applications in various formats.

Spire-ch-aviation Mapping - ch-aviation

Spire-ch-aviation Mapping

Column	Data Type	Data description	Key	Data Set	Join On
flight_id	varchar(255)	Spire internal unique flight ID. Random UUIDv4 sequence	Primary/foreign	Flights	flight_id
ch_code_operator	varchar(5)	Operator ch-aviation code (assigned by ch-aviation). Operator ch-aviation codes can be 2, 3, or 5 characters.	Foreign	Airlines	Airline ch-a Code
flight_type	varchar(20)	Indicator of special flight types (ferry, technical, training)
ch_code_regional_partnership	varchar(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.	Foreign	Airlines	Airline ch-a Code
regional_partnership	varchar(255)	Regional partnership name under which the flight is operated	Foreign	Regional Subsidiaries	Rel Subsidiary
ch_code_cargo_customer	varchar(5)	Cargo customer ch-aviation code (assigned by ch-aviation). Can be 2, 3, 4, or 5 characters.	Foreign	Entities	Entity ch-a Code
cargo_customer	varchar(255)	Name of cargo customer for whom the flights is operated
ch_code_wet_lease_customer	varchar(5)	Wet lease customer ch-aviation code (assigned by ch-aviation). Can be 2, 3, 4, or 5 characters.	Foreign	Entities	Entity ch-a Code
wet_lease_customer	varchar(255)	Wet lease customer name
notes	varchar(255)	Additional free text notes related to the flight
aircraft_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 (Combined)	Aircraft Histories	Aircraft ID
date_from_full	date	From date with operator, registration and variant, the aircraft_id and date_from_full fields are the combined primary key of the Aircraft Histories data set	Foreign (Combined)	Aircraft Histories	Date From Full