Metropolitan Airmotive Inc

Earlier aircraft under this name · 34

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 = 'METROPOLITAN AIRMOTIVE INC' OR list_contains(d.other_registrant_names, 'METROPOLITAN AIRMOTIVE INC')
  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.

N65320Dornier DO28 B-1 · S/N 3094Cancelled Apr 24, 1981 · Exported to Germany · LuxembourgN65322Dornier DO28 B-1 · S/N 3099Cancelled Apr 28, 1980 · Exported to Germany · LuxembourghN1042YDornier DO28 B-1 · S/N 3088Cancelled May 22, 1979 · Exported to Canada · LuxembourgN65318Dornier DO28 B-1 · S/N 3093Cancelled Nov 30, 1978 · Exported to Germany · LuxembourgN65321Dornier DO28 B-1 · S/N 3096Cancelled Sep 26, 1978 · Exported to Germany · LuxembourgN2931LMooney M20F · S/N 670325Cancelled Jan 30, 1974 · Exported to Germany · Linden, NJN41832Dornier DO 27 Q-4 · S/N 2044Cancelled Jul 27, 1973 · Exported to Israel · LuxembourgN62507Dornier DO28 B-1 · S/N 3098Cancelled Jul 11, 1973 · Exported to Israel · LuxembourgN7310NDornier DO 27 Q-4 · S/N 499Cancelled Feb 8, 1973 · Exported to Germany · Linden, NJN74185Dornier DO 27 A5 · S/N 380Cancelled Dec 11, 1972 · Linden, NJN33502Dornier DO 27 A5 · S/N 461Cancelled Aug 28, 1972 · Exported to IsraelN9182XDornier DO28 B-1 · S/N 3087Cancelled Aug 22, 1972 · Exported to Israel · Linden, NJN9454Dornier-Werke DO 27 A · S/N 474Cancelled Jul 18, 1972 · Exported to Israel · Built 1970 · Linden, NJN9456Dornier-Werke DO 27 A · S/N 475Cancelled Jul 18, 1972 · Exported to Israel · Built 1970 · Linden, NJN6295Dornier DO-27 Q1 · S/N 458Cancelled Mar 13, 1972 · Exported to IsraelN6292Dornier DO 27 · S/N 491Cancelled Jan 25, 1972 · Exported to IsraelN5943Dornier DO-27 Q1 · S/N 109Cancelled Aug 10, 1971 · Exported to Israel · Linden, NJN5944Dornier DO-27 Q1 · S/N 167Cancelled Aug 10, 1971 · Exported to Israel · Linden, NJN5945Dornier DO 27 · S/N 184Cancelled Aug 10, 1971 · Exported to Israel · Linden, NJN9535Dornier DO-27 Q1 · S/N 178Cancelled Jul 20, 1971 · Exported to Israel · Linden, NJN9537Dornier DO-27 Q1 · S/N 219Cancelled Jul 16, 1971 · Exported to Israel · Linden, NJN9538Dornier DO 27 · S/N 325Cancelled Jul 12, 1971 · Exported to Israel · Linden, NJN9533Dornier DO 27 · S/N 126Cancelled Jun 14, 1971 · Exported to Israel · Built 1971 · Linden, NJN9534Dornier DO 27 · S/N 147Cancelled Jun 14, 1971 · Exported to Israel · Linden, NJN8505Hiller UH-12B · S/N 733Cancelled May 20, 1971 · Exported to Italy · Linden, NJN8936Dornier DO28 B-1 · S/N 3115Cancelled Apr 12, 1971 · Exported to Israel · Linden, NJN8930Dornier DO28 B-1 · S/N 3102Cancelled Apr 9, 1971 · Exported to Israel · Linden, NJN8932Dornier DO28 B-1 · S/N 3107Cancelled Apr 9, 1971 · Exported to Israel · Linden, NJN9536Dornier DO-27 Q1 · S/N 204Cancelled Apr 7, 1971 · Exported to Israel · Linden, NJN8933Dornier DO28 B-1 · S/N 3113Cancelled Mar 24, 1971 · Linden, NJN8935Dornier DO28 B-1 · S/N 3114Cancelled Mar 24, 1971 · Linden, NJN8323Dornier DO-27 Q1 · S/N 2015Cancelled Aug 18, 1970 · Linden, NJN3037RCessna 320A · S/N 320A0037Cancelled Jun 30, 1970 · New York, NYN3877GCessna U206B · S/N U206-0877Cancelled Nov 6, 1968 · Exported to Kenya · New York, NY
Back to Metropolitan Airmotive Inc