Skip to content

Mooney Aircraft Corp

Earlier aircraft under this name · 157

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

N3702HMooney M20K · S/N 25-0123Cancelled Jul 10, 2009 · Exported to Germany · Built 1979 · Kerrville, TX N9147FMooney M20R · S/N 290085Cancelled May 28, 1998 · Exported to Italy · Kerrville N9163VMooney M20R · S/N 290018Cancelled Jan 26, 1995 · Exported to Thailand · Kerrville N9162XMooney M20R · S/N 290014Cancelled Jan 6, 1995 · Exported to South Africa · Kerrville, TX N1118RMooney M20J · S/N 241141Cancelled Nov 8, 1993 · Kerrville, TX N91286Mooney M20J · S/N 243277Cancelled Mar 17, 1993 · Exported to Thailand · Kerrville N91465Mooney M20M · S/N 270099Cancelled Oct 8, 1992 · Exported to Brazil · Kerrville N9157QMooney M20M · S/N 270134Cancelled Jul 13, 1992 · Exported to Italy · Kerrville N9159DMooney M20M · S/N 270135Cancelled Jul 13, 1992 · Exported to Italy · Kerrville N9130XMooney M20J · S/N 243199Cancelled May 28, 1992 · Exported to Brazil · Kerrville N9155GMooney M20M · S/N 270128Cancelled Apr 8, 1992 · Exported to Italy · Kerrville N9149ZMooney M20M · S/N 270113Cancelled Sep 26, 1991 · Exported to Italy · Kerrville N9134ZMooney M20J · S/N 243225Cancelled Jul 10, 1991 · Exported to South Korea · Kerrville, TX N9135BMooney M20J · S/N 243226Cancelled Jul 10, 1991 · Exported to South Korea · Kerrville, TX N9147NMooney M20M · S/N 270102Cancelled Jun 4, 1991 · Exported to Italy · Kerrville N9133NMooney M20J · S/N 243217Cancelled May 14, 1991 · Exported to Spain · Kerrville N201AYMooney M20J · S/N 240422Cancelled Feb 19, 1991 · Exported to France · Kerrville, TX N9124NMooney M20M · S/N 270078Cancelled Jan 24, 1991 · Exported to Italy · Kerrville N9124QMooney M20M · S/N 270080Cancelled Jan 15, 1991 · Exported to Thailand · Kerrville N9132NMooney M20J · S/N 243205Cancelled Dec 19, 1990 · Exported to Italy · Kerrville N9125NMooney M20J · S/N 243177Cancelled Nov 29, 1990 · Exported to Switzerland · Kerrville N57422Mooney M20J · S/N 24-1452Cancelled Jan 14, 1985 · Exported to Australia · Kerrville, TX N5765YMooney M20J · S/N 24-1483Cancelled Jan 11, 1985 · Exported to Australia · Kerrville, TX N5772FMooney M20J · S/N 24-1499Cancelled Dec 7, 1984 · Exported to Thailand · Kerrville, TX N5734XMooney M20J · S/N 24-1453Cancelled Aug 24, 1984 · Exported to Thailand · Kerrville, TX N5653MMooney M20J · S/N 24-1387Cancelled Oct 19, 1983 · Exported to Canada · Kerrville, TX N3995HMooney M20J · S/N 24-1004Cancelled May 18, 1983 · Exported to Australia · Built 1980 · Kerrville, TX N1167WMooney M20K · S/N 25-0693Cancelled Aug 11, 1982 · Exported to United Kingdom · Built 1982 · Kerrville, TX N1170NMooney M20J · S/N 24-1316Cancelled Aug 11, 1982 · Exported to United Kingdom · Kerrville, TX N11671Mooney M20J · S/N 241302Cancelled Jun 14, 1982 · Exported to Australia · Built 1982 · Kerrville, TX N1165KMooney M20J · S/N 24-1294Cancelled May 12, 1982 · Exported to Australia · Built 1982 · Kerrville, TX N1076CMooney M20J · S/N 241165Cancelled Feb 11, 1982 · Exported to Chile · Kerrville, TX N1155RMooney M20J · S/N 241246Cancelled Feb 2, 1982 · Exported to South Africa · Kerrville, TX N1158ZMooney M20K · S/N 25-0650Cancelled Feb 2, 1982 · Exported to South Africa · Built 1982 · Kerrville, TX N1154TMooney M20K · S/N 25-0637Cancelled Jan 7, 1982 · Exported to South Africa · Built 1981 · Kerrville, TX N1141XMooney M20J · S/N 24-1169Cancelled Nov 20, 1981 · Exported to Australia · Built 1981 · Kerrville, TX N1148ZMooney M20K · S/N 25-0600Cancelled Oct 19, 1981 · Exported to South Africa · Built 1981 · Kerrville, TX N231LZMooney M20K · S/N 250306Cancelled Sep 29, 1981 · Exported to Australia · Built 1980 · Kerrville, TX N1092SMooney M20K · S/N 25-0586Cancelled Sep 24, 1981 · Exported to South Africa · Built 1981 · Kerrville, TX N1141YMooney M20J · S/N 24-1170Cancelled Aug 20, 1981 · Exported to South Africa · Built 1981 · Kerrville, TX N1138DMooney M20J · S/N 24-1142Cancelled Aug 5, 1981 · Exported to Australia · Built 1981 · Kerrville, TX N1098TMooney M20K · S/N 25-0568Cancelled Aug 3, 1981 · Exported to South Africa · Built 1981 · Kerrville, TX N1064BMooney M20J · S/N 24-1122Cancelled Jun 29, 1981 · Exported to Australia · Kerrville, TX N10837Mooney M20J · S/N 24-1128Cancelled Jun 29, 1981 · Exported to South Africa · Built 1981 · Kerrville, TX N97827Mooney M20J · S/N 24-1081Cancelled Jun 29, 1981 · Exported to Australia · Kerrville, TX N9900FMooney M20J · S/N 24-1090Cancelled Jun 29, 1981 · Exported to Australia · Kerrville, TX N10248Mooney M20J · S/N 24-1114Cancelled May 29, 1981 · Exported to South Africa · Kerrville, TX N9923SMooney M20J · S/N 24-1094Cancelled May 27, 1981 · Exported to United Kingdom · Kerrville, TX N97080Mooney M20J · S/N 24-1077Cancelled May 8, 1981 · Exported to Australia · Kerrville, TX N9898MMooney M20J · S/N 24-1087Cancelled Apr 24, 1981 · Exported to South Africa · Kerrville, TX

Back to Mooney Aircraft Corp