Skip to content

Cancelled registrations · 146

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 = 'AZ' AND d.registrant_city = 'TEMPE' 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 = 'AZ' AND d.registrant_city = 'TEMPE'
  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 = 'AZ' AND d.registrant_city = 'TEMPE'
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.

N3408DEurocopter AS 350 B3 · S/N 3408Cancelled May 22, 2026 · Exported to Australia · Built 2001 · Van Horn Aviation LLC N427VCScottish BULLDOG MDL 120/121 · S/N BH120/258Cancelled Mar 25, 2025 · Eagle Mountain Holdings LLC N48PELet BLANIK L-13 · S/N 174908Cancelled Aug 29, 2023 · Dobbins John R N203SHBurkhart Grob Flugzeugbau G102 ASTIR CS · S/N 2180Cancelled Sep 3, 2022 · Registration expired, pending cancellation · Built 1978 · Schneider Alex D N786NPiper PA-28R-200 · S/N 28R-7435095Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Built 1973 · Iftikhar Naveed M N125TPDJI PHANTOM 4 PRO · S/N OAXCE6COA31674Cancelled Sep 4, 2021 · Registration expired, pending cancellation · Tempe Police Department N854TRDJI MAVIC PRO · S/N 08QDE1M01203T3Cancelled Oct 31, 2020 · Registration expired, pending cancellation · Tr-Iag LLC N853TRDJI MATRICE 600 · S/N M64DDF13010019Cancelled May 29, 2020 · Registration expired, pending cancellation · Tr-Iag LLC N852TRDJI INSPIRE 1 · S/N W13DD122061507Cancelled Apr 3, 2020 · Registration expired, pending cancellation · Tr-Iag LLC N6850SDJI PHANTOM 3 PROFESSION · S/N P78DCI28061610Cancelled Nov 29, 2019 · Registration expired, pending cancellation · First Solar Inc N7396P3D Robotics SOLO · S/N S111A5902969Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Pagel Samuel N625NCDJI PHANTOM 3 PROFESSION · S/N P76DCD23010824Cancelled May 1, 2019 · Registration expired, pending cancellation · Arsenych Craig L N139TCThunder & Colt Airborne Amer AX8-90 S 2 · S/N 1942USACancelled Jan 30, 2019 · Registration expired, pending cancellation · Built 1991 · Sklute Kenneth L N579FRDJI S900 · S/N 0370031171Cancelled Dec 11, 2018 · Registration expired, pending cancellation · Fidler Ryan N579GRDJI S1000 · S/N 03P0011815Cancelled Dec 11, 2018 · Registration expired, pending cancellation · Fidler Ryan L N73400Cessna 172M · S/N 17267430Cancelled Mar 28, 2018 · Registration expired, pending cancellation · Built 1976 · Klingman Tim R N11317Cessna 150L · S/N 15075323Cancelled Mar 19, 2018 · Registration expired, pending cancellation · Built 1973 · Klingaman Tim R N8389ZCessna 210-5(205) · S/N 205-0389Cancelled Mar 1, 2018 · Revoked, pending cancellation · Built 1963 · Chappell Hubert H N82YKS C Aerostar S A YAK-52 · S/N 822612Cancelled Jan 9, 2018 · Registration expired, pending cancellation · Built 1982 · Swift Tim N4904VBellanca 17-30 · S/N 30135Cancelled Jan 8, 2018 · Registration expired, pending cancellation · Built 1968 · Klingaman Tim R N74405Bellanca 14-13-2 · S/N 1518Cancelled Oct 30, 2017 · Registration expired, pending cancellation · Built 1947 · Mayhall Joel N1271RBellanca 17-31A · S/N 32-89Cancelled Oct 27, 2017 · Registration expired, pending cancellation · Built 1972 · Klingaman Tim N6649VBellanca 17-30A · S/N 30305Cancelled Oct 23, 2017 · Registration expired, pending cancellation · Built 1970 · Klingaman Tim N9086FBalloon Works FIREFLY 8B · S/N F8B-337Cancelled Sep 26, 2017 · Registration expired, pending cancellation · Ramsey James E N214MRCameron Balloons US O-84 · S/N 5394Cancelled Jul 20, 2017 · Registration expired, pending cancellation · Built 1987 · Sklute Kenneth N852HWEurocopter AS 350 B2 · S/N 2630Cancelled Jul 18, 2017 · Registration expired, pending cancellation · Built 1992 · C I T Leasing Corp N1725YSebring Robert Dale PIETENPOL AIRCAMPER · S/N 101Cancelled Jul 6, 2017 · Registration expired, pending cancellation · Built 1990 · Roy Paul E N727TKCessna 500 · S/N 500-0141Cancelled Mar 24, 2017 · Registration expired, pending cancellation · Built 1974 · Ge Engine Services-Corporate Aviation Inc N79WBCessna TP206C · S/N P206-0509Cancelled Feb 4, 2017 · Revoked, canceled · Built 1968 · Monday Scott N490RSStarling Ronald A PHANTOM · S/N 490Cancelled Dec 8, 2016 · Starling Ronald A N73BPScovil Paul/Bowde KR-2 · S/N 3634Cancelled May 19, 2015 · Registration expired, pending cancellation · Built 1983 · Eskildsen Jim N78JRDassault/Sud FAN JET FALCON · S/N 70Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1966 · Turbo Resources International Inc N51152Strojnik Ales STROJNIK S-5 · S/N 001Cancelled May 6, 2015 · Registration expired, pending cancellation · Built 1992 · Strojnik Ales N2708VCessna 177RG · S/N 177RG0667Cancelled Feb 9, 2015 · Exported to Canada · Built 1975 · N2708v LLC N282AMarinello Anthony JR B-8M · S/N 1220Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Marinello Anthony Jr N714LMCessna 150M · S/N 15079258Cancelled Dec 2, 2014 · Revoked, canceled · Built 1977 · Awbrey Roy C N9639KUniversal Stinson 108-2 · S/N 1082639Cancelled Nov 24, 2014 · Registration expired, pending cancellation · Built 1947 · Marine Resources Inc N86210Aeronca 11AC · S/N 11AC-V14Cancelled Nov 20, 2014 · Registration expired, pending cancellation · Built 1946 · Loveless Brian A N67752Cessna 152 · S/N 15281997Cancelled Nov 13, 2014 · Registration expired, pending cancellation · Built 1978 · G&L Aviation Ltd N41603Culver LFA · S/N 362Cancelled Oct 6, 2014 · Registration expired, pending cancellation · Built 1941 · Bishton David W N3266NPiper J3C-65 · S/N 22457Cancelled Sep 29, 2014 · Registration expired, pending cancellation · Built 1946 · Benedict Rodney J N1511VBalloon Works FIREFLY 7-B · S/N F7B-022Cancelled Sep 5, 2014 · Registration expired, pending cancellation · Built 1982 · P And A Enterprises N305VABoeing 737-247 · S/N 19606Cancelled Aug 7, 2013 · Sale reported, canceled · Built 1968 N63112Consolidated Vultee BT-13A · S/N 8017Cancelled Aug 5, 2013 · Revoked, canceled · Built 1942 · Smith Richard H N7612PPiper PA-24-250 · S/N 24-2823Cancelled Aug 5, 2013 · Registration pending, canceled · Built 1961 N5750WPiper PA-28-150 · S/N 28-2809Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Built 1965 · Duda John N8778VBellanca 17-30A · S/N 30315Cancelled Jun 14, 2013 · Sale reported, canceled · Built 1970 N1366QSmith Thomas J SONERAI II · S/N 662Cancelled Jun 4, 2013 · Registration expired, pending cancellation · Built 1982 · Roy Paul E N8929DPiper PA-22-160 · S/N 22-6087Cancelled May 17, 2013 · Registration expired, pending cancellation · Built 1958 · Hanson Robert H N25KDGlasflugel H 301 LIBELLE · S/N 59Cancelled May 9, 2013 · Sale reported, canceled · Built 1967

Back to Tempe, AZ