Skip to content

Mooney Aircraft Corporation

Earlier aircraft under this name · 38

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

N20XMMooney M20M · S/N 27-0001Cancelled Jul 14, 2017 · Registration expired, pending cancellation · Built 1989 · Kerrville, TX N20XLMooney M20L · S/N 26-0001Cancelled May 23, 2017 · Registration expired, pending cancellation · Built 1987 · Kerrville, TX N2704WMooney M20E · S/N 1017Cancelled Jan 3, 2011 · Expired dealer · Built 1966 · Kerrville, TX N2717WMooney M20C · S/N 3335Cancelled Jan 3, 2011 · Expired dealer · Built 1966 · Kerrville, TX N3448XMooney M20E · S/N 1134Cancelled Jan 3, 2011 · Expired dealer · Built 1966 · Kerrville, TX N6789VMooney M20F · S/N 700066Cancelled Jan 3, 2011 · Expired dealer · Built 1970 · Kerrville, TX N91547Mooney M20R · S/N 29-0050Cancelled Jan 3, 2011 · Expired dealer · Kerrville, TX N1053BMooney M20R · S/N 29-0258Cancelled Apr 15, 2002 · Exported to South Africa · Built 2000 · Kerrville, TX N91648Mooney M20R · S/N 290022Cancelled Apr 6, 1998 · Exported to Paraguay · Kerrville, TX N91462Mooney M20M · S/N 270098Cancelled Mar 23, 1998 · Exported to United Kingdom · Kerrville, TX N9712PMooney M20K · S/N 250451Cancelled Nov 7, 1997 · Exported to Ecuador · Kerrville, TX N91442Mooney M20M · S/N 270217Cancelled Jul 31, 1996 · Exported to South Africa · Kerrville, TX N91567Mooney M20J · S/N 243375Cancelled Mar 6, 1996 · Exported to Japan · Kerrville, TX N10769Mooney M20R · S/N 290074Cancelled Feb 2, 1996 · Exported to South Africa · Kerrville, TX N9157TMooney M20R · S/N 290055Cancelled Sep 5, 1995 · Exported to South Africa · Kerrville, TX N9170NMooney M20R · S/N 290032Cancelled Jul 26, 1995 · Exported to South Africa · Kerrville, TX N9167HMooney M20R · S/N 290025Cancelled Mar 7, 1995 · Exported to South Africa · Kerrville, TX N91642Mooney M20R · S/N 290021Cancelled Jan 20, 1995 · Exported to South Africa · Kerrville, TX N9131BMooney M20J · S/N 243348Cancelled Oct 13, 1994 · Exported to South Africa · Kerrville, TX N1068WMooney M20K · S/N 251221Cancelled Apr 21, 1994 · Exported to Brazil · Kerrville N1081WMooney M20J · S/N 243311Cancelled Dec 8, 1993 · Exported to Turkey · Kerrville, TX N201MMMooney M20J · S/N 240002Cancelled Nov 8, 1993 · Triennial form not returned · Kerrville, TX N57881Mooney M20J · S/N 241525Cancelled Nov 12, 1992 · Exported to Portugal · Kerrville, TX N5272NMooney M20J · S/N 243084Cancelled Oct 9, 1992 · Exported to Sweden · Kerrville, TX N9152BMooney M20M · S/N 270121Cancelled Mar 23, 1992 · Exported to Japan · Kerrville, TX N9134NMooney M20J · S/N 243222Cancelled Jul 10, 1991 · Exported to South Korea · San Antonio, TX N9134QMooney M20J · S/N 243223Cancelled Jul 10, 1991 · Exported to South Korea · San Antonio, TX N9134RMooney M20J · S/N 243224Cancelled Jul 10, 1991 · Exported to South Korea · San Antonio, TX N9129FMooney M20J · S/N 243196Cancelled May 8, 1991 · Exported to China · San Antonio, TX N1079YMooney M20J · S/N 243166Cancelled Apr 12, 1991 · Exported to France · Kerrville N4770HMooney M20J · S/N 24-0889Cancelled Mar 6, 1980 · Exported to Germany · Built 1979 · Kerrville, TX N4788HMooney M20J · S/N 24-0878Cancelled Feb 1, 1980 · Exported to New Zealand · Built 1979 · Kerrville, TX N4797HMooney M20J · S/N 240884Cancelled Nov 6, 1979 · Exported to Australia · Kerrville, TX N4714HMooney M20J · S/N 24-0816Cancelled Jul 11, 1979 · Exported to Australia · Kerrville, TX N4708HMooney M20J · S/N 240813Cancelled Jun 21, 1979 · Exported to Australia · Kerrville, TX N7731MMooney M22 · S/N 690006Cancelled Oct 16, 1969 · Kerrville, TX N7732MMooney M22 · S/N 690007Cancelled Oct 16, 1969 · Kerrville, TX N7733MMooney M22 · S/N 690008Cancelled Oct 16, 1969 · Kerrville, TX

Back to Mooney Aircraft Corporation