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.

Airline Financial Figures - ch-aviation

Airline Financial Figures

Column	Data Type	Data description	Package required	Key	Data Set	Join On
Airline Name	varchar(255)	Operator name	Airline Financial Figures
Airline ch-a Code	varchar(5)	Operator ch-aviation code (assigned by ch-aviation). Operator ch-aviation codes can be 2, 3, or 5 characters.	Airline Financial Figures	Primary	Airlines	Airline ch-a Code
Financial Year	int(4)	Financial Year	Airline Financial Figures	Primary
Currency Code	char(3)	Currency ISO 4217 code	Airline Financial Figures	Foreign	Currencies	Currency Code
Passenger Revenue	bigint(20)	Passenger revenue	Airline Financial Figures
Cargo Revenue	bigint(20)	Cargo revenue	Airline Financial Figures
Other Revenue	bigint(20)	Other revenue	Airline Financial Figures
Total Revenue	bigint(20)	Total revenue	Airline Financial Figures
Operating Profit	bigint(20)	Operating profit	Airline Financial Figures
Net Profit	bigint(20)	Net profit	Airline Financial Figures
Employee	int(11)	Number of employees	Airline Financial Figures
Year End Date	date	Financial Year Ende Date	Airline Financial Figures
Data Source	varchar(255)	Data source description	Airline Financial Figures
Data Source URL	text	Data source URL	Airline Financial Figures
Comment	text	Free text remarks	Airline Financial Figures