Skip to content

Cancelled registrations · 96

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 = 'CA' AND d.registrant_city = 'ESCONDIDO' 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 = 'CA' AND d.registrant_city = 'ESCONDIDO'
  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 = 'CA' AND d.registrant_city = 'ESCONDIDO'
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.

N2691KCessna 180K · S/N 18053036Cancelled Sep 15, 2026 · Exported to Canada · Built 1979 · Sherburne Constance E Trustee N5804Loeffler PAZMANY PL-1 · S/N CAF-4Cancelled Jan 17, 2026 · Registration pending, canceled N21WTCessna 421B · S/N 421B0486Cancelled Jul 11, 2023 · Built 1973 · Station David H N22XVAirmotive Engineers EOS/001 · S/N 0001Cancelled Dec 31, 2022 · Sale reported, canceled N303KPRichard Michael Krause CCK-1865 · S/N CCK-1865-0013Cancelled Sep 8, 2022 · Third renewal notice · Built 2011 · Bierle Peter M Trustee N2541PPiper PA-22-150 · S/N 22-2904Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Built 1955 · Zapata James A N228KDDJI Innovations INSPIRE 1 · S/N 0410022688Cancelled Dec 4, 2021 · Registration expired, pending cancellation · Kirksey Daniel B N5433TFerreira David P/Lee Daniel J VANS RV-7A · S/N 70675Cancelled Feb 2, 2021 · Registration expired · Built 2018 · Ferreira David P N6237ZDavis Harold F V6-STOL · S/N 2210Cancelled Jul 10, 2020 · Registration expired, pending cancellation · Built 1996 · Davis Harold F N666TEThunder Balloons AX7-77 · S/N 1020Cancelled Feb 19, 2020 · Registration expired · Prentice Mike N350GCPiper PA-31-350 · S/N 31-8252036Cancelled Feb 4, 2020 · Sale reported, pending cancellation · Built 1982 N1642TCessna 182M · S/N 18259338Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Built 1968 · Hudson Kelsey L N6721R3D Robotics SOLO · S/N S111A5702288Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Rose Robert J N48939Aeronca 0-58B · S/N 058B3302Cancelled Aug 29, 2019 · Revoked, pending cancellation · Built 1942 · Rand Alton C N5980BDJI PHANTOM 3 PROFESSION · S/N P77DCH07016355Cancelled Mar 23, 2019 · Registration expired, pending cancellation · Brooks David J N6152QCessna 320F · S/N 320F-0002Cancelled Jul 12, 2018 · Registration expired, pending cancellation · Built 1967 · Abbasi Babak N5651FAlon A-2A · S/N B-251Cancelled Jun 20, 2018 · First renewal notice · Hampton Warren D N81003Cobb Intl Inc/Rotorway Intl 162F · S/N 6865Cancelled Mar 30, 2018 · Registration expired, pending cancellation · Am-Sod Inc N2324CJohnson 1 · S/N 1Cancelled Mar 22, 2018 · Registration expired, pending cancellation · Built 1965 · Stoller Donald G N792CMMckinney Charles/June ROTORWAY EXEC · S/N 2991Cancelled Mar 20, 2018 · Registration expired, pending cancellation · Stoller Donald G N932BSBeech B24R · S/N MC343Cancelled Mar 8, 2018 · Registration expired, pending cancellation · Campbell Don N6012NCessna T210M · S/N 21062880Cancelled Mar 6, 2018 · Registration expired, pending cancellation · Built 1978 · Torres Felipe Vargas N84037Cessna 172K · S/N 17258309Cancelled Jan 26, 2018 · Registration expired, pending cancellation · Dodd Kenneth L N2722URans S-12 · S/N 0295559Cancelled Jan 17, 2018 · Registration expired, pending cancellation · Built 1995 · Dudash George M N9722UQuicksilver MXL II · S/N 3449844Cancelled Jan 17, 2018 · Registration expired, pending cancellation · Dudash George M N6ZLFranks Erik VELOCITY XL RG · S/N 3RX041Cancelled Jan 8, 2018 · Registration expired, pending cancellation · Built 2011 · Franks Erik N1775TPiper PA-28-140 · S/N 28-7125048Cancelled Jun 14, 2017 · Registration expired, pending cancellation · Built 1970 · Finley Gregory T N239HLAvions Max Holste MH 1521 BROUSSARD · S/N 239Cancelled May 15, 2017 · Registration expired, pending cancellation · Built 1960 · Chaffin Gene E N40DBButzbach SMITH MINIPLANE DSA1 · S/N DWB-1Cancelled Apr 7, 2017 · Registration expired, pending cancellation · Built 1976 · Gagian Rodney W N74386Bellanca 14-13-2 · S/N 1499Cancelled Feb 4, 2017 · Revoked, canceled · Built 1947 · Mccoy John D Jr N93704Engineering & Research ERCOUPE 415-C · S/N 1027Cancelled Apr 21, 2016 · First renewal notice · Built 1946 · Hampton Warren D N1876DBeech C35 · S/N D-3120Cancelled Feb 23, 2016 · Built 1952 · Bakerink Ilene Y N241HImre Nagy AIRSHIP · S/N 001Cancelled May 8, 2015 · Registration expired, pending cancellation · Nagy Imre N2617HErcoupe 415-D · S/N 3242Cancelled May 8, 2015 · Registration expired, pending cancellation · Built 1946 · Christofferson Earl S N43907Taylorcraft BC12-D · S/N 7566Cancelled Oct 9, 2014 · Registration expired, pending cancellation · Built 1946 · Mccoy John D Jr N577JSSchifferer John S BREEZY RLU-1 · S/N 4Cancelled Oct 31, 2013 · Registration expired, pending cancellation · Built 1997 · Schifferer John S N99LKKeele Lee CONDOR II · S/N 831503Cancelled Oct 28, 2013 · Registration expired, pending cancellation · Keele K L N8746MBeech A23 · S/N M-622Cancelled Oct 24, 2013 · Registration expired, pending cancellation · Built 1964 · Willford A C N37251Interstate S-1A · S/N 94Cancelled Oct 23, 2013 · Registration expired, pending cancellation · Built 1941 · Baker Roger E N6111ECessna 172N · S/N 17271991Cancelled Oct 21, 2013 · Second renewal notice · Built 1978 · Robertson Steven J N3331JCessna 150G · S/N 15066031Cancelled Aug 13, 2013 · Registration expired, pending cancellation · Built 1966 · Quick Kenneth R N63604Cessna 150M · S/N 15077422Cancelled Aug 6, 2013 · Revoked, canceled · Built 1975 · Ritchie Frank W N2006WAvian Balloon MAGNUM IX · S/N 193Cancelled Aug 5, 2013 · Sale reported, canceled · Built 1995 N6302NNagy Imre HELIUM · S/N 001Cancelled Jun 27, 2013 · Registration expired, pending cancellation · Nagy Imre N578JSKoch Cathy A CRICKET MC-12 · S/N 12-0083Cancelled Jun 12, 2013 · Registration expired, pending cancellation · Koch Cathy A N28498Luscombe 8A · S/N 1365Cancelled Jun 11, 2013 · Sale reported, canceled · Built 1940 N5309KCameron Balloons US C-80 · S/N 6146Cancelled Jan 30, 2013 · Exported to Taiwan · Built 1998 · Murphy John P N1137Mckinley COMPETITION · S/N 001Cancelled Dec 18, 2012 · Registration expired, pending cancellation · Built 1973 · Mckinley Larry N11342Thicksten Robert Paul CHALLENGER II · S/N CH2-0591-0698Cancelled Oct 2, 2012 · Registration expired, pending cancellation · Built 1996 · Thicksten Robert P N2025HErcoupe 415-C · S/N 2648Cancelled Aug 22, 2012 · Registration expired, pending cancellation · Built 1946 · Hale Clarence C Jr

Back to Escondido, CA