Commander Aviation Corp
Earlier aircraft under this name · 124
Cancelled registrations that named this owner when they ended, newest first.
Query with SQL
duckdb -csv -c "SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code WHERE d.registrant_name = 'COMMANDER AVIATION CORP' OR list_contains(d.other_registrant_names, 'COMMANDER AVIATION CORP') ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id"
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 d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code WHERE d.registrant_name = 'COMMANDER AVIATION CORP' OR list_contains(d.other_registrant_names, 'COMMANDER AVIATION CORP') ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
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.
N8882YPiper PA-39 · S/N 39-40N54902Piper PA-25-260 · S/N 25-7656046N6454FCessna 182P · S/N 18264195N80BLPiper PA-30 · S/N 30-1704N68943Cessna 152 · S/N 15282410N7701LRockwell International 690B · S/N 11489N7405LPiper PA-31-310 · S/N 31-7401220N49091Cessna 152 · S/N 152-81144N84859Cessna 172K · S/N 17258642N12992Cessna 172M · S/N 17262433N70289Cessna A188B · S/N 18801880TN8084ECessna 172N · S/N 17272136N7498FHughes 269C · S/N 670600N7979WPiper PA-28-180 · S/N 282032N2169JCessna A188B · S/N 18803406TN5062HBellanca 8GCBC · S/N 31079N29144Cessna U206C · S/N U206-1114N5194YPiper PA-23-250 · S/N 272239N43820Piper PA-28R-201 · S/N 28R7737137N4449QCessna A188B · S/N 18800849N8486FPiper PA-32R-300 · S/N 32R-7780104N75893Cessna 172N · S/N 17268021N23006Piper PA-30 · S/N 30-1578N8630YPiper PA-30 · S/N 30-1771N550TSBeech B90 · S/N LJ345N7972UCessna 172F · S/N 17251972N4285SBeech 95-B55 (T42A) · S/N TC2017N6408ZPiper PA-25-150 · S/N 25-543N8298GCessna A188B · S/N 18801295TN7749GCessna 172L · S/N 172-59449N6484GCessna 150K · S/N 15071984N733VYCessna 172N · S/N 17268594N2309DCessna 170B · S/N 20461N93893Cessna A185F · S/N 18503259N7JSAero Commander S2R · S/N 1630JN733FDCessna 172N · S/N 17268254N3523QCessna 172M · S/N 172-61662N8052VCessna 188 · S/N 188-0302N8600VBellanca 8GCBC · S/N 152-75N21941Cessna A185F · S/N 18503071N2693JCessna 150G · S/N 15065693N8872EPiper PA-32R-300 · S/N 32R-7680182N3965VCessna 150M · S/N 15076667N1360GCessna 310R · S/N 310R0715N70241Cessna A188B · S/N 18801876TN110BCPiper PA-31-310 · S/N 31-602N5257LPiper PA-28-180 · S/N 284554WN950NDCessna 182E · S/N 182-54038N60143Cessna 150J · S/N 150-70102N708FLPiper PA-28-140 · S/N 28-7225307
Back to Commander Aviation Corp