Skip to content

Cancelled registrations · 91

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 = 'PALMDALE' 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 = 'PALMDALE'
  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 = 'PALMDALE'
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.

N316TWRust Jim TAILWIND W10 · S/N 1206JRCancelled May 10, 2026 · Sale reported, canceled N53LKSchempp-Hirth DISCUS 2A · S/N 32Cancelled Dec 20, 2025 · Exported to Switzerland · Built 1999 · Rogers Walter A N7397WPiper PA-28-180 · S/N 28-1285Cancelled Jan 21, 2023 · Registration expired, pending cancellation · Campbell Fahali A N791LMLockheed Martin Aeronautics P791 · S/N 0001Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Built 2005 · Lockheed Martin Aeronautics Co N731RBBeaver Robbie EXEC 90 · S/N 01Cancelled Jun 4, 2022 · Registration expired, pending cancellation · Tuosto John M N982LMBalloon Works FIREFLY 8 · S/N F8-395Cancelled Oct 23, 2021 · Registration expired, pending cancellation · Kissack Donald L N8441DPiper PA-22-160 · S/N 22-5696Cancelled Jan 11, 2021 · Registration expired, pending cancellation · Brones Lee O N820TLRagle Wesley R RV6A · S/N 60312Cancelled Oct 3, 2020 · Registration expired, pending cancellation · Built 2003 · Dopler Ted E N5407KNavion NAVION B · S/N NAV-4-2307BCancelled May 29, 2020 · Registration expired, pending cancellation · Built 1951 · Robinson Michael L N21EJJungemann STARDUSTER-II · S/N J-1Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 1976 · Steele Denis F N242XEJennings Aeronautics XE · S/N 242Cancelled May 4, 2019 · Registration expired, pending cancellation · Lockheed Martin Corp N243XEJennings Aeronautics XE · S/N 243Cancelled May 4, 2019 · Registration expired, pending cancellation · Lockheed Martin Corp N245XEJennings Aeronautics XE · S/N 245Cancelled May 4, 2019 · Registration expired, pending cancellation · Lockheed Martin Corp N7723SSchweizer SGS 1-26D · S/N 423Cancelled Mar 14, 2019 · Registration expired, pending cancellation · Built 1968 · Wall Robert F N232XEJennings Aeronautics XE · S/N 232Cancelled Mar 2, 2019 · Registration expired, pending cancellation · Lockheed Martin Corp N233XEJennings Aeronautics XE · S/N 233Cancelled Mar 2, 2019 · Registration expired, pending cancellation · Lockheed Martin Corp N202XEJennings Aeronautics XE · S/N 202Cancelled Feb 25, 2019 · Registration expired, pending cancellation · Lockheed Martin Corp N203XEJennings Aeronautics XE · S/N 203Cancelled Feb 25, 2019 · Registration expired, pending cancellation · Lockheed Martin Corp N148CHDJI INSPIRE 1 · S/N 0410049876Cancelled Jan 14, 2019 · Registration expired, pending cancellation · Coffee House Industries LLC N563THDJI PHANTOM 2 VISION + · S/N PH645357977Cancelled Dec 7, 2018 · Registration expired, pending cancellation · Coffee House Industries LLC N3866XHincy William P RANS S12 XL · S/N 06980848Cancelled Jun 8, 2018 · Registration expired, pending cancellation · Hincy William P N1111HFlug & Fahrzeugwerke HBV DIAMANT 18 · S/N 054Cancelled Mar 19, 2018 · Registration expired, pending cancellation · Built 1969 · Pierson Danny A N71987Luscombe 8A · S/N 3414Cancelled Mar 16, 2018 · Revoked, canceled · Built 1946 · Sandstormers Flying Club N315DFlug UND Fahrzeugwerke HBV DIAMANT · S/N 005Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Built 1966 · Pierson Danny A N5758TCessna 172E · S/N 17251658Cancelled Feb 16, 2018 · Registration expired, pending cancellation · Built 1964 · Mcfarland Ralph D N144TQDiamond Aircraft Ind DA40 D · S/N D4.013Cancelled Feb 8, 2018 · Registration expired, pending cancellation · Built 2003 · Lockheed Martin Corp N9029UVanecek George SR & JR HP-18 · S/N 18-169Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Built 1982 · Wiley Scott L N2507NEvans Don E3 · S/N DE 001Cancelled Jan 17, 2018 · Registration expired, pending cancellation · Evans Don D N4078QCessna 320C · S/N 320C0046Cancelled Jan 4, 2018 · Registration expired, pending cancellation · Built 1965 · Gerker Carl J N54287Fairchild M-62A · S/N T435030Cancelled Nov 20, 2017 · Revoked, canceled · Built 1943 · Debs Edward E N3061QCessna 182K · S/N 18258061Cancelled Jul 14, 2017 · Registration expired, pending cancellation · Built 1967 · Speaker William M N1421QCessna 150L · S/N 15072721Cancelled Apr 5, 2017 · Registration expired, pending cancellation · Built 1971 · Gerker Carl J N18MFFlogerzi Lyle VERIEZE · S/N 18Cancelled Mar 10, 2017 · Registration expired, pending cancellation · Built 1980 · Rand Karl A N7722Roman B-8 · S/N JR-1Cancelled Feb 4, 2017 · Revoked, canceled · Built 1967 · Paris Thomas C N6907DPiper PA-22-150 · S/N 22-4834Cancelled Nov 14, 2014 · Registration expired, pending cancellation · Built 1957 · Weilbacher Christopher J N13JLSons MUSTANG II · S/N RG-56-1067Cancelled Sep 3, 2014 · Registration expired, pending cancellation · Built 1975 · Segrest Kerry N6430VAerostar International RX-7 · S/N RX7-3055Cancelled Oct 22, 2013 · Registration expired, pending cancellation · Built 1986 · Kissack Donald L N39WTAero Vodochody L-39 · S/N 132127Cancelled Sep 20, 2013 · Third renewal notice · Built 1981 · Woltosz Walter S N96076Taylorcraft BC12-D · S/N 8376Cancelled Sep 17, 2013 · Registration expired, pending cancellation · Built 1946 · Towers Ernest A N729DALockheed L-1011-385-1 · S/N 193C-1180Cancelled Aug 29, 2013 · Registration pending, canceled · Built 1980 N6264PPiper PA-24-250 · S/N 24-1372Cancelled Aug 5, 2013 · Revoked, canceled · Built 1959 · Davidson Lee E N5144MTaylorcraft BC12-D · S/N 10444Cancelled Jun 24, 2013 · First renewal notice · Built 1946 · Beech Stanley Howard N6163LCessna 152 · S/N 15284367Cancelled Jun 20, 2013 · Exported to Indonesia · Built 1980 · Cramm Ray E N90CWSchleicher ASW-20B · S/N 20640Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Built 1983 · Serkowski Tom N6KABoxer Aaron I VELOCITY STD FG · S/N DM-0055Cancelled Jun 5, 2013 · Registration expired, pending cancellation · Boxer Aaron I N948RCCrosley Richard VANS RV-8 · S/N 0002Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 2005 · Crosley Richard N68161Cessna T-50 · S/N 3098Cancelled May 2, 2013 · Registration expired, pending cancellation · Built 1943 · Towers Ernest A N5698HPiper PA-16 · S/N 16-309Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1949 · Bregar Carl S II N56560Taylorcraft DCO-65 · S/N L5822Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Built 1943 · Towers Ernest A N4206CStinson 108-3 · S/N 108-5206Cancelled Mar 11, 2013 · Registration expired, pending cancellation · Built 1948 · Gerker Carl J

Back to Palmdale, CA