Earlier aircraft under this name · 31

Cancelled registrations that named this owner when they ended, newest first.

Query with SQL

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 = 'MOONEY AIRCRAFT INC' OR list_contains(d.other_registrant_names, 'MOONEY AIRCRAFT INC') ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

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 = 'MOONEY AIRCRAFT INC' OR list_contains(d.other_registrant_names, 'MOONEY AIRCRAFT 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.

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

N6681RMooney M20E · S/N 424Cancelled Mar 1, 1971 · Exported to Australia · Kerrville, TX N9122LMooney M22 · S/N 650001Cancelled Feb 25, 1971 · Kerrville, TX N3596XMooney M-20G · S/N 680165Cancelled Oct 10, 1968 N3597XMooney M-20G · S/N 680166Cancelled Oct 10, 1968 N3598XMooney M-20G · S/N 680167Cancelled Oct 10, 1968 N3599XMooney M-20G · S/N 680168Cancelled Oct 10, 1968 N7725MMooney M22 · S/N 680016Cancelled Oct 10, 1968 · Kerrville, TX N3293FMooney M20F · S/N 670386Cancelled Mar 19, 1968 · Kerrville, TX N3800NMooney M20F · S/N 680123Cancelled Mar 5, 1968 · Exported to Germany · Kerrville, TX N3866NMooney M20F · S/N 680138Cancelled Feb 27, 1968 · Exported to Zambia · Kerrville, TX N3721NMooney M-20G · S/N 680050Cancelled Jan 26, 1968 · Exported to Venezuela N3699NMooney M-20G · S/N 680042Cancelled Dec 21, 1967 · Exported to Canada N3299FMooney M20F · S/N 670392Cancelled Oct 12, 1967 · Exported to Mexico · Kerrville, TX N3261FMooney M20E · S/N 670054Cancelled Sep 18, 1967 · Exported to Canada · Kerrville, TX N6404QMooney M20C · S/N 670144Cancelled Aug 28, 1967 · Exported to Canada N6599BMooney M20B · S/N 1701Cancelled May 21, 1965 · Kerrville, TX N5299BMooney M22 · S/N 6000Cancelled May 20, 1965 · Kerrville, TX N78885Aerostar Acft Corp Of Texas M20C · S/N 2900Cancelled Dec 24, 1964 · Exported to New Zealand · Kerrville, TX N6826UMooney M20D · S/N 185Cancelled Sep 10, 1963 · Exported to South Africa · Kerville, TX N6892UMooney M20C · S/N 2596Cancelled Sep 10, 1963 · Exported to United Kingdom N6082XMooney M20A · S/N 1678Cancelled Mar 9, 1961 · Exported to Chile · Kerrville, TX N6099XMooney M20A · S/N 1001Cancelled Mar 1, 1961 · Kerrville, TX N5246BMooney M20 · S/N 1109Cancelled Jul 19, 1960 · Exported to Germany · Kerrville, TX N8342EMooney M20A · S/N 1520Cancelled Jul 11, 1960 · Exported to Brazil · Kerrville, TX N8187EMooney M20A · S/N 1458Cancelled May 13, 1960 · Exported to Argentina · Built 1959 · Kerrville, TX N1096CMooney M20A · S/N 1367Cancelled Aug 6, 1959 · Exported to Canada · Kerrville, TX N5299BMooney M20 · S/N 1161Cancelled Nov 29, 1957 · Exported to Germany · Kerrville, TX N878BMooney M20 · S/N 1040Cancelled Aug 14, 1956 · Exported to Canada · Kerrville, TX N499MBarnard Marvin R M-19 · S/N 1001Cancelled Jan 24, 1956 · Built 1930 · Kerrville, TX N4085Mooney M-18LA · S/N 122Cancelled Dec 4, 1952 · Wichita, KS N5500QMooney M20E · S/N 603Cancellation date not recorded · Exported to Australia · Kerrville, TX

Back to Mooney Aircraft Inc