Skip to content

Cancelled registrations · 1,583

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

N500DLRobinson Helicopter R44 · S/N 1178Cancelled Jan 3, 2022 · Sale reported, canceled · Built 2002 N588QUDJI PHANTOM 3 PROFESSION · S/N P77DCE29010669Cancelled Dec 4, 2021 · Registration expired, pending cancellation · Ulbrich Carl J N708TCThunder & Colt THUNDER AX9-140 S2 · S/N 2429Cancelled Dec 4, 2021 · Registration expired, pending cancellation · Built 1993 · Cory Shane D N468AZDJI MAVIC 2 ENTERP DUAL · S/N 298DG3E001LY7DCancelled Nov 15, 2021 · State Of Arizona N8326ZCessna 210-5A(205A) · S/N 205-0326Cancelled Oct 30, 2021 · Sale reported, canceled · Built 1963 N8629MBeech 95-A55 · S/N TC-498Cancelled Oct 25, 2021 · Sale reported, canceled · Built 1963 N5218ACessna 172S · S/N 172S9134Cancelled Oct 19, 2021 · Exported to India · Haarer Ronald K N910RRCameron Balloons US A-250 · S/N 6603Cancelled Oct 2, 2021 · Registration expired, pending cancellation · Cory Shane D N14ATBeech 95-B55 (T42A) · S/N TC-2266Cancelled Sep 25, 2021 · Sale reported, canceled · Built 1979 N7880Schempp-Hirth STANDARD CIRRUS · S/N 80Cancelled Sep 4, 2021 · Registration expired, pending cancellation · Built 1970 · A R A And Associates LLC N4378JPiper PA-28-140 · S/N 28-22764Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Built 1967 · Sinioris John A N831BJCessna 150M · S/N 15076913Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Izzo Michael David Trustee N6402XEvans Duane B ZENITH 601HDS · S/N 6-3904Cancelled Jul 29, 2021 · Third renewal notice · Built 2002 · Evans David D N8014WPiper PA-28-180 · S/N 28-2077Cancelled Jul 3, 2021 · Registration expired, pending cancellation · Built 1964 · Brinkman Joel Aaron N297AZDJI MAVIC 2 PRO · S/N 163CGCRR0A1FBPCancelled Mar 31, 2021 · State Of Arizona N31WWWinter Kenneth E & William E VARI VIGGEN · S/N 133Cancelled Mar 24, 2021 · Built 1981 · Spinelli Charles B N851BYUrban UFM 13 LAMBADA · S/N 26/13Cancelled Mar 6, 2021 · Registration expired, pending cancellation · Built 2002 · Fly By Night Holdings LLC N705MLBeech 200 · S/N BB-705Cancelled Mar 2, 2021 · Built 1980 · Honeywell International Inc N704QJCessna 150M · S/N 15078787Cancelled Feb 27, 2021 · Registration pending, canceled · Built 1976 N25831Balloon Works FIREFLY 7-15 · S/N F7-822Cancelled Jan 30, 2021 · Registration expired, pending cancellation · Built 1993 · Lutz Tanya S N9788KStinson 108-2 · S/N 108-2788Cancelled Jan 11, 2021 · Registration expired, pending cancellation · Built 1947 · Tedhams Kurt A N4917KCessna P210N · S/N P21000367Cancelled Jan 8, 2021 · Sale reported, canceled N445APRobinson Helicopter R44 II · S/N 11607Cancelled Dec 11, 2020 · Sale reported, canceled · Built 2007 N6592PPiper PA-24-180 · S/N 24-1714Cancelled Dec 11, 2020 · Sale reported, canceled · Built 1960 N734FTCessna 172N · S/N 17268826Cancelled Nov 6, 2020 · Sale reported, canceled · Built 1977 N2463VCessna 140 · S/N 14716Cancelled Oct 31, 2020 · Registration expired, pending cancellation · Moen Robert L N5527WCessna P210N · S/N P21000705Cancelled Oct 31, 2020 · Registration expired, pending cancellation · Built 1981 · Bliss Marketing Communications Inc N5706BCessna 182 · S/N 33706Cancelled Oct 31, 2020 · Registration expired, pending cancellation · Moen Robert L N8882PPiper PA-24-260 · S/N 24-4341Cancelled Oct 31, 2020 · Registration expired, pending cancellation · Built 1966 · Ditter Steven J N3852XAero Commander 100 · S/N 144Cancelled Oct 17, 2020 · Sale reported, canceled · Built 1967 N177CWCessna 177 · S/N 17700855Cancelled Oct 10, 2020 · Sale reported, canceled N5557QMooney M20C · S/N 2967Cancelled Oct 10, 2020 · Sale reported, canceled · Built 1965 N466BSMatt Lejcar CH 750 · S/N 75-8707Cancelled Oct 3, 2020 · Registration expired, pending cancellation · Lejcar Matt N1832FBeech F33A · S/N CE-968Cancelled Sep 11, 2020 · Sale reported, canceled · Built 1981 N580AJack M Cupp CHALLENGER I · S/N 0402-0776Cancelled Sep 4, 2020 · Registration expired, pending cancellation · Cupp Jack M N4345WBeech C23 · S/N M-1569Cancelled Aug 31, 2020 · Sale reported, canceled · Built 1974 N192NGNanchang China YAK-18A · S/N 3051217Cancelled Aug 2, 2020 · Registration expired, pending cancellation · Built 1975 · G&C Cj6 LLC N39LPLaister Sailplane Products LP-49 · S/N 39Cancelled Jul 10, 2020 · Registration expired, pending cancellation · Built 1970 · Brodhagen Keith D N3086UCessna 172E · S/N 17250686Cancelled Jun 12, 2020 · Revoked, canceled · Built 1963 · Mcknight William Co Ow N403JPAirbus Industrie A320-231 · S/N 198Cancelled May 29, 2020 · Registration expired, pending cancellation · Jetpro International LLC N747UPAir Creation BUGGY · S/N T98105Cancelled May 29, 2020 · Registration expired, pending cancellation · Built 1998 · Haller Harrison D N56785Boeing A75N1(PT17) · S/N 75-2209Cancelled May 27, 2020 · Revoked, canceled · Built 1941 · Reich Lawrence E N65023Wearden STARDUSTER TOO · S/N SA-170Cancelled May 23, 2020 · Sale reported, canceled · Built 1975 N108FABell OH-58A · S/N 71-20777Cancelled May 1, 2020 · Sale reported, canceled N624AWAirbus Industrie A320-231 · S/N 55Cancelled May 1, 2020 · Registration expired, pending cancellation · Built 1989 · Jetpro International LLC N1211PPalmer PARAPLANE · S/N 01Cancelled Apr 24, 2020 · Revoked, canceled · Palmer Barry Hill N180YCessna 180 · S/N 30685Cancelled Apr 22, 2020 · Built 1954 · Utay Arthur W N350FDEurocopter AS 350 BA · S/N 1182Cancelled Apr 7, 2020 · Built 1979 · Honeywell International Inc N55KKBeech 95-B55 · S/N TC-1731Cancelled Apr 3, 2020 · Sale reported, canceled · Built 1974 N810PMDJI INSPIRE 1 · S/N W13DCI10040580Cancelled Apr 3, 2020 · Registration expired, pending cancellation · Arizona Public Service Co

Back to Phoenix, AZ