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.

N71873Cessna 182M · S/N 18259787Cancelled Feb 15, 1974 · Exported to Canada · Mandan, NDN5906UPiper PA-28-140 · S/N 28-7125142Cancelled Feb 12, 1974 · Exported to Canada · Bismarch, NDN60195Cessna 150J · S/N 15070140Cancelled Feb 7, 1974 · Exported to Canada · Bismzarck, NDN6446WPiper PA-28-140 · S/N 28-20518Cancelled Jan 30, 1974 · Exported to Canada · Mandan, NDN8342JCessna 150G · S/N 15066242Cancelled Jan 25, 1974 · Exported to Canada · Bismarck, NDN9528WPiper PA-28-140 · S/N 28-22956Cancelled Dec 17, 1973 · Exported to Canada · Bismarck, NDN852JPiper PA-30 · S/N 30-1913Cancelled Nov 15, 1973 · Exported to Australia · Bismarack, NDN561GCessna 150H · S/N 15068270Cancelled Oct 2, 1973 · Exported to Canada · Bismarck, NDN8738SCessna 150F · S/N 15062038Cancelled Oct 2, 1973 · Exported to Canada · Bismarck, NDN61160Cessna 150J · S/N 15070848Cancelled Jul 9, 1973 · Exported to Canada · Bismarck, NDN384DBeech 35-A33 · S/N CD-269Cancelled Jun 25, 1973 · Exported to Canada · Bismark, NDN6300QMooney M20F · S/N 670393Cancelled Jun 6, 1973 · Exported to Canada · Bismark, NDN3523YCessna 182E · S/N 182-54423Cancelled May 8, 1973 · Exported to Canada · Bismarck, NDN6773FCessna 150F · S/N 15063373Cancelled May 4, 1973 · Exported to Canada · Bismarck, NDN7049DPiper PA-22-150 · S/N 22-4946Cancelled Apr 18, 1973 · Exported to Canada · Bismarck, NDN42452Piper J3C-65 · S/N 14719Cancelled Dec 13, 1972 · Exported to Canada · Built 1945 · Bismarck, NDN4074PPiper PA-23-160 · S/N 23-1552Cancelled Sep 25, 1972 · Exported to Canada · Bismarck, NDN3797SCessna 172E · S/N 17250997Cancelled Jul 20, 1972 · Exported to Canada · Bismarck, NDN1311WMooney M20E · S/N 199Cancelled Jul 12, 1972 · Exported to Canada · Mandan, NDN4115FCessna 172 · S/N 46015Cancelled May 31, 1972 · Exported to Canada · Built 1959N5626RCessna 172F · S/N 17253244Cancelled May 31, 1972 · Exported to Canada · Mandan, NDN6949SCessna 150H · S/N 15067649Cancelled Apr 6, 1972 · Exported to Canada · Mandan, NDN8996PPiper PA-24-260 · S/N 24-4457Cancelled Mar 8, 1972 · Exported to Canada · Mandan, NDN4003ZPiper PA-18-150 · S/N 18-7954Cancelled Feb 14, 1972 · Exported to Canada · Bismarck, ND
Back to Commander Aviation Corp