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.
N7826WPiper PA-28-180 · S/N 281838N8937PPiper PA-24-260 · S/N 244393N8434VRockwell International S-2R · S/N 2194RN185WCessna A185F · S/N 18502559N725FLPiper PA-28-140 · S/N 28-7225419N80402Cessna 172M · S/N 17266572N80413Cessna 172M · S/N 66575N6232SCessna 150G · S/N 15067032N7865ACessna 180A · S/N 32762N6235FCessna 182P · S/N 18264137N5898RCessna 172G · S/N 17253567N710FLPiper PA-28-140 · S/N 28-7225324N6965HCessna 172M · S/N 17265669N1136PPiper PA-23 · S/N 23-148N61742Cessna 172M · S/N 17264767N4025RPiper PA-32-300 · S/N 32-40321N8392WPiper PA-28-180 · S/N 28-2598N2799FCessna 182J · S/N 185-56899N9054RCessna A188B · S/N 18802090TN2164GCessna 182A · S/N 51464N7057KPiper PA-20 · S/N 20-164N9658PPiper PA-18-150 · S/N 18-7509002N5355PPiper PA-24-250 · S/N 24403N1709FCessna 172H · S/N 17255104N7458LPiper PA-18-150 · S/N 18-7509052N61706Cessna 172M · S/N 172-64746N8433XCessna 172C · S/N 17248933N4137JPiper PA-28-140 · S/N 28-22460N5850BCessna 182A · S/N 33850N78688Piper PA-11 · S/N 11-1455N8596VBellanca 7KCAB · S/N 500-75N5600JCessna 182P · S/N 18263457N92500Cessna 182N · S/N 18260232N8561VBellanca 7ECA · S/N 1063-75N7822NPiper PA-28 · S/N 285274N41225Piper PA-28-151 · S/N 28-7415141N43442Piper PA-28-151 · S/N 28-7415493N8123WPiper PA-28-180 · S/N 28-2230N42010Cessna 182L · S/N 18258806N7180ACessna 172 · S/N 29280N3184ZPiper PA-18-150 · S/N 18-7176N2290RCessna T210J · S/N T2100440N6708NMooney M-20G · S/N 680083N6796RCessna T210 · S/N T210-0196N3318UCessna 182F · S/N 18254718N7086RPiper PA-28-140 · S/N 28-21789N78792Cessna 172K · S/N 17257763N6388RPiper PA-28-140 · S/N 28-21565N60291Cessna 150J · S/N 15070202N6042VAeronca 7CCM · S/N 48-496
Back to Commander Aviation Corp