Central Airlines Inc
Registered aircraft · 25
Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.
Query with SQL
duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_name = 'CENTRAL AIRLINES INC' OR list_contains(g.other_registrant_names, 'CENTRAL AIRLINES INC') ORDER BY g.n_number"
Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_name = 'CENTRAL AIRLINES INC' OR list_contains(g.other_registrant_names, 'CENTRAL AIRLINES INC') ORDER BY g.n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N118PWAero Commander 500-B · S/N 1460-163N127KHAero Commander 500-B · S/N 500B-1027-38N131JTAero Commander 500-B · S/N 1468-166N23BQAero Commander 500-B · S/N 500A-1065-46N261ERAero Commander 500-B · S/N 1362-133N304JTAero Commander 500-B · S/N 1494-175N324RRAero Commander 500-B · S/N 1386-139N411ETAero Commander 500-B · S/N 1621-214N411JFAero Commander 500-B · S/N 500B-1014-35N415BHAero Commander 500-B · S/N 500B-918-5N443WAAero Commander 500-B · S/N 1315-124N444CAAero Commander 500-B · S/N 1458-162N444CBAero Commander 500-B · S/N 500B-1119-69N516DTAero Commander 500-B · S/N 1574N523ATAero Commander 500-B · S/N 500B-1235-106N610BWAero Commander 500-B · S/N 1523-185N630KCAero Commander 500-B · S/N 500B-997-28N690RRAero Commander 500-B · S/N 500B-1169-88N713SPAero Commander 500-B · S/N 500B-1480-172N716TCAero Commander 500-B · S/N 500B-1225-102N719CAGates Learjet 35A · S/N 251N777CMAero Commander 500-B · S/N 1412-147N818TEAero Commander 500-B · S/N 500B-995-26N917GTAero Commander 500-B · S/N 500B-983-24N922BSAero Commander 500-B · S/N 1598-207
Back to Central Airlines Inc