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.

Aircraft Multiple Operators - ch-aviation

Aircraft Multiple Operators

Column	Data Type	Data description	Key	Data Set	Join On
aircraft_id	int(10)	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	Primary (combined)/foreign	Aircraft	Aircraft ID
operator_ch_code	varchar(5)	Operator ch-aviation code (assigned by ch-aviation). Operator ch-aviation codes can be 2, 3, or 5 characters.	Primary (combined)/foreign	Operators	Operator ch-a Code
operator_name	varchar(255)	Operator name
aircraft_certification	varchar(255)	Certification under which the aircraft operates (following US FAA standards applied globally: Part 91 or Part 135)