OpenAirDocs.org
Miami Aviation Corp

Earlier aircraft under this name · 32

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 = 'MIAMI AVIATION CORP' OR list_contains(d.other_registrant_names, 'MIAMI 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.

N852KBDehavilland DHC-6 TWIN OTTER · S/N 145Cancelled Dec 19, 1979 · Exported to Fiji · Opa-Locka, FLN123SCConvair 600-240D · S/N 92Cancelled Apr 19, 1976 · Exported to Uruguay · Opa Locka, FLN8703ADouglas DC-6 · S/N 42900Cancelled Sep 10, 1974N850DDouglas DC-7B · S/N 45456Cancelled May 11, 1972 · Opa Locka, FLN303MADehavilland DHC-6 · S/N 258Cancelled Apr 20, 1971 · Exported to French Polynesia · Opa-Locka, FLN654MADehavilland DHC-6 TWIN OTTER · S/N 220Cancelled Jul 13, 1970 · Exported to Canada · Opa-Locka, FLN7148ZPiper PA-25-235 · S/N 25-2982Cancelled Jul 13, 1970 · Exported to Ecuador · Opa Locka, FLN7151ZPiper PA-25-235 · S/N 25-2990Cancelled Jul 13, 1970 · Exported to Ecuador · Opa Locka, FLN7168ZPiper PA-25-235 · S/N 25-3029Cancelled Jul 13, 1970 · Exported to Ecuador · Opa Locka, FLN7169ZPiper PA-25-235 · S/N 25-3033Cancelled Jul 13, 1970 · Exported to Ecuador · Opa Locka, FLN4798FCessna TP206B · S/N P206-0398Cancelled Feb 24, 1970 · Exported to Colombia · Opa Locka, FLN75885Douglas DC3C · S/N 19242Cancelled Jan 10, 1969 · Exported to Panama · Opa Locka, FLN2420Aero Commander 500-B · S/N 500B-982-23Cancelled Aug 15, 1968 · Exported to Colombia · Opalaca, FLN615PRAero Commander 500-B · S/N 1504-179Cancelled Feb 23, 1968 · Exported to Colombia · Opa Locka, FLN90717Douglas DC-6 · S/N 42884Cancelled Dec 19, 1967 · Exported to Panama · Opa Locka, FLN4720YPiper PA-25-235 · S/N 25-4462Cancelled Dec 7, 1967 · Exported to Venezuela · Opa Locka, FLN4723YPiper PA-25-235 · S/N 25-4466Cancelled Dec 5, 1967 · Exported to Venezuela · Opa Locka, FLN4675YPiper PA-25-235 · S/N 25-4397Cancelled Aug 30, 1967 · Exported to Colombia · Opa Locka, FLN7551ZPiper PA-25 · S/N 25-3599Cancelled May 16, 1967 · Exported to Venezuela · Opa Locka, FLN90727Douglas DC-6 · S/N 42894Cancelled Feb 20, 1967 · Exported to Honduras · Opa Locka, FLN2770BAero Commander 500-B · S/N 1095-08Cancelled Jan 31, 1967 · Exported to Colombia · Opa Locka, FLN7527ZPiper PA-25-235 · S/N 25-3569Cancelled Dec 9, 1965 · Exported to Venezuela · Opa Locka, FLN4997EDouglas DC3C · S/N 12191Cancelled Jul 26, 1965 · Opa-Locka, FLN57985Douglas DC-3A-S1C3G · S/N 19996Cancelled May 25, 1965 · Exported to Philippines · Opa Locka, FLN4993EDouglas DC-3A-S1C3G · S/N 12440Cancelled May 18, 1965 · Exported to Philippines · Opa Locka, FLN7816HPiper PA-12 · S/N 12719Cancelled Jan 25, 1965 · Exported to French Polynesia · Opa Locka, FLN7180ZPiper PA-25-235 · S/N 253052Cancelled Dec 10, 1964 · Exported to VenezuelaN4992EDouglas DC3C · S/N 12139Cancelled Dec 9, 1964 · Exported to Philippines · Opa Locka, FLN4998EDouglas DC3C · S/N 13559Cancelled Dec 9, 1964 · Exported to Philippines · Opa-Locka, FLN7137ZPiper PA-25-235 · S/N 252955Cancelled Sep 11, 1964 · Exported to VenezuelaN6888ZPiper PA-25-235 · S/N 25-2613Cancelled Jun 16, 1964 · Exported to Venezuela · Built 1964 · Opa Locka, FLN2270DDehavilland DHC-6 TWIN OTTER · S/N 98Cancellation date not recorded · Exported to Iceland · Opa Locka, FL
Back to Miami Aviation Corp