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.
N71873Cessna 182M · S/N 18259787N5906UPiper PA-28-140 · S/N 28-7125142N60195Cessna 150J · S/N 15070140N6446WPiper PA-28-140 · S/N 28-20518N8342JCessna 150G · S/N 15066242N9528WPiper PA-28-140 · S/N 28-22956N852JPiper PA-30 · S/N 30-1913N561GCessna 150H · S/N 15068270N8738SCessna 150F · S/N 15062038N61160Cessna 150J · S/N 15070848N384DBeech 35-A33 · S/N CD-269N6300QMooney M20F · S/N 670393N3523YCessna 182E · S/N 182-54423N6773FCessna 150F · S/N 15063373N7049DPiper PA-22-150 · S/N 22-4946N42452Piper J3C-65 · S/N 14719N4074PPiper PA-23-160 · S/N 23-1552N3797SCessna 172E · S/N 17250997N1311WMooney M20E · S/N 199N4115FCessna 172 · S/N 46015N5626RCessna 172F · S/N 17253244N6949SCessna 150H · S/N 15067649N8996PPiper PA-24-260 · S/N 24-4457N4003ZPiper PA-18-150 · S/N 18-7954
Back to Commander Aviation Corp