Skip to content

Cancelled registrations · 73

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_state = 'LA' AND d.registrant_city = 'METAIRIE' 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_state = 'LA' AND d.registrant_city = 'METAIRIE'
  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_state = 'LA' AND d.registrant_city = 'METAIRIE'
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.

N25909Balloon Works FIREFLY BOOT · S/N BOOT 01Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Built 1995 · Ward Pamela M N1619Cuccia-Bensen B-8M · S/N 617Cancelled Oct 17, 2020 · Revoked, canceled · Built 1967 · Cuccia Anthony Jr N1620KLuscombe 8A · S/N 4347Cancelled Oct 17, 2020 · Revoked, canceled · Built 1946 · Bertaut Ernest A N288LNAero Commander 112 · S/N 112Cancelled Apr 3, 2020 · Registration expired, pending cancellation · Built 1973 · Everlasting Auto Inc N673ZN3D Robotics X8+ · S/N X815032390009Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Unusual Attitudes LLC N3550KPiper PA-31-350 · S/N 31-8052037Cancelled Jun 26, 2018 · Registration pending, canceled · Built 1979 N5002EBrupbacher Chris CB2000 · S/N H2-02-13-546Cancelled Mar 26, 2018 · Registration expired, pending cancellation · Built 2003 · Mahler Darren J N1815CCessna 170B · S/N 25959Cancelled Mar 23, 2018 · Revoked, canceled · Built 1953 · Scott Donald P N7348YPiper PA-30 · S/N 30-401Cancelled Jun 1, 2017 · Registration expired, pending cancellation · Built 1964 · Pate Larry William N2755JCessna A150M · S/N A1500586Cancelled Apr 13, 2017 · Registration expired, pending cancellation · Built 1975 · Old World Signs Ltd N8140MCessna 310I · S/N 310I0140Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1964 · Kenner Air Inc N3469JCessna 150G · S/N 15066169Cancelled May 14, 2015 · Registration expired, pending cancellation · Built 1967 · Mahler Darren J N4485JLisman Joe W JR GOLDWING STD · S/N 193Cancelled May 5, 2015 · Registration expired, pending cancellation · Lisman Joe W Jr N147DBPiper PA-28-181 · S/N 28-7890027Cancelled May 4, 2015 · Registration expired, pending cancellation · Built 1977 · Morgan Scott D N81968Cessna 182E · S/N 18254120Cancelled Apr 27, 2015 · Registration expired, pending cancellation · Scott Flying Service Inc N7841ZCessna 150C · S/N 15059941Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1963 · Roche Porter Allen N7423SPiper PA-28-180 · S/N 28-1311Cancelled Nov 17, 2014 · Registration expired, pending cancellation · Built 1963 · Bodet Christopher S N7114RMG B-8M · S/N 121463Cancelled Nov 13, 2014 · Registration expired, pending cancellation · Built 1967 · Grumbine Raymond M N62831Piper PA-23-250 · S/N 27-7754064Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Wilson Sharon M N4035KFremin Thomas 162F · S/N 7063Cancelled Oct 9, 2014 · Registration expired, pending cancellation · Built 2007 · Fremin Thomas J N8369KPiper PA-28-161 · S/N 28-8116199Cancelled Sep 12, 2013 · Registration expired, pending cancellation · Built 1981 · Russell Floyd C N1703BBoeing A75 · S/N 75-5826Cancelled Jun 7, 2013 · Sale reported, canceled N852DHHouge Donald B JEFFAIR BARRACUDA · S/N DBH-2Cancelled Jun 5, 2013 · Registration expired, pending cancellation · Bates James L Jr N814MCCaswell Michael E CASWELL MXLII SPORT · S/N 555Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1994 · Caswell Michael E N3712DBeech V35B · S/N D-10354Cancelled Mar 4, 2013 · Built 1980 · Tomcat Aviation LLC N414WCCessna 414 · S/N 414-0650Cancelled Feb 26, 2013 · Exported to Honduras · Built 1975 · Mourra Jose Elias N5664QMooney M20E · S/N 688Cancelled Jan 31, 2013 · Sale reported, canceled · Built 1965 N8711UCessna 172F · S/N 17252615Cancelled Sep 6, 2012 · Registration pending, canceled · Built 1965 N5041Starfire AMPHIBIAN · S/N 101Cancelled Aug 10, 2012 · Revoked, canceled · Royer Edward J N49800Cessna 152 · S/N 15281323Cancelled Aug 9, 2012 · Revoked, canceled · Built 1978 · Evers Lance N4771PPiper PA-23-250 · S/N 27-317Cancelled Aug 6, 2012 · Revoked, canceled · Built 1960 · Wiegand Roy N170NXCessna 170B · S/N 26337Cancelled Jul 24, 2012 · Sale reported, canceled · Built 1954 N20808Feiner Balz SABRE II · S/N S2A-K002Cancelled Aug 5, 2011 · Built 1993 · Grevemberg Kenneth J N10462Woods CORBEN ACE · S/N W-1Cancelled Jun 6, 2011 · Sale reported, canceled · Built 1957 N369BGCirrus Design SR22 · S/N 1969Cancelled Feb 3, 2011 · Exported to Australia · Built 2006 · Burglass & Tankersley LLC N3690PPiper PA-18 · S/N 18-4592Cancelled Jan 12, 2011 · Revoked, pending cancellation · Built 1955 · Elmer W Jay Dr N138MACessna 172R · S/N 17280311Cancelled Nov 25, 2009 · Exported to Honduras · Built 1998 · Mourra Jose E N206HDCessna U206C · S/N U206-1135Cancelled Aug 5, 2009 · Exported to Mexico · Built 1968 · Deubler Henry P Jr N1984YMooney M20E · S/N 271Cancelled Jul 9, 2009 · Registration revoked · Built 1964 · Karno Louis N182LPCessna 182E · S/N 18253906Cancelled Dec 4, 2008 · Triennial form not returned · Pate Larry W N96BACessna 210 · S/N 57117Cancelled Apr 11, 2008 · Triennial form not returned · Built 1960 · Jpl Flyers LLC N649FLPiper PA-28-140 · S/N 28-7125558Cancelled May 1, 2006 · Second triennial mailing, no response · Built 1971 · Bayou Oaks Aviation Inc N802FCPiper PA-28RT-201 · S/N 28R-8018088Cancelled Apr 17, 2006 · Triennial form not returned · Built 1980 · Foxtrot Charlie Inc N48RCBeech A45 · S/N G-156Cancelled Apr 12, 2006 · Triennial form not returned · Built 1953 · Gray And Company Inc N114JVRockwell International 114 · S/N 70Cancelled Apr 5, 2006 · Triennial form not returned · Built 1973 · Commander Flyers LLC N6103DCessna 172N · S/N 17272603Cancelled Mar 30, 2006 · Built 1979 · L And H Aircraft Inc N714UNCessna 152 · S/N 15279445Cancelled Mar 27, 2006 · Triennial form not returned · Built 1977 · Un714 LLC N4130FCessna 172 · S/N 46030Cancelled Feb 7, 2006 · Triennial form not returned · Built 1958 · Groetsch George W III N9385TPiper PA-38-112 · S/N 38-78A0085Cancelled Sep 23, 2004 · Triennial form not returned · Built 1978 · Bonura Rocco F N5107GCessna 172H · S/N 17256224Cancelled Dec 14, 2000 · Deubler Henry P Jr

Back to Metairie, LA