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.

Entities - ch-aviation

Entities

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.

Column	Data Type	Data description	Package required	Key	Data Set	Join On
Entity Name	varchar(255)	Entity name	Entities
Entity ch-a Code	varchar(4)	Entity ch-aviation code (assigned by ch-aviation)	Entities	Primary
Legal Name	varchar(255)	Entity legal name	Entities
Location	varchar(255)	Location airport name (closest airport if not based at airport itself)	Entities
Location ID	int(11)	Location ID (assigned by ch-aviation)	Entities	Foreign	Airports	Airport ID
Continent	varchar(255)	Continent name	Entities
State Name	varchar(255)	State description	Entities
State Code	char(2)	ISO 3166-2 Alpha-2 subdivision code (used for states)	Entities	Foreign	States	State ISO
Country	varchar(255)	Country name	Entities
Country ISO	char(2)	ISO 3166-1 Alpha-2 country code	Entities	Foreign	Countries	Country ISO
Country_IASA_Status	char(1)	Country International Aviation Safety Assessment program status (assigned by FAA): 0 – not assessed / 1 – Category 1 (meets ICAO standards) / 2 – Category 2 (does not meet ICAO standards)	Entities
Type	varchar(255)	Entity type	Entities
Type Code	char(1)	Entity type code (S- Scheduled Carrier, V- Virtual Carrier, D- Division, C- Cargo Carrier, P- Passenger Charter, B- Business/Private Charter, G- Government, F- Manufacturer, U- Supplier, O - Private Operator, T - Flight Department, R - Ferry Flight Provider, E- Engine Manufacturer, I- IT Provider, L- Lessor, X - Customer/Forwarder, M – MRO Provider , H – Holding Company)	Entities
Status	varchar(255)	Entity status	Entities
Entity Info	varchar(255)	Free text remarks (where applicable)	Entities
Merged into	varchar(255)	Entity this particular entity has been merged into or rebranded to.	Entities
Merged into ch-a Code	varchar(4)	ch-aviation code for the successor entity as a result of a merger or rebranding	Entities	Foreign	Entities	Entity ch-a Code
Website	varchar(255)	URL	Entities
Stock Ticker	varchar(255)	Stock market ticker	Entities
Launch Year	int(4)	Entity launch year	Entities
Termination Year	int(4)	Entity termination year	Entities
Total Seats in Fleet	decimal(10,0)	Number of total seats of all aircraft owned by the entity	Fleets
Number of Aircraft	bigint(20)	Number of aircraft owned by the entity	Fleets
Aircraft on Order	decimal(10,0)	Number of aircraft on order by the entity	Fleets
Number of Engines	decimal(10,0)	Number of engines fitted to aircraft owned by the entity	Fleets