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.

N787NMCanadair CL-600-2B16 · S/N 5099Cancelled Jul 9, 2023 · Built 1991 · Worldwide Jet Charter Inc N987AACirrus Design SR22 · S/N 0513Cancelled Jul 1, 2023 · Sale reported, canceled · Built 2003 N2627GCessna 182B · S/N 51927Cancelled May 27, 2023 · Revoked, canceled · Built 1959 · Thompson Vincent T N126LFBeech 58 · S/N TH-440Cancelled May 15, 2023 · Sale reported, canceled · Built 1974 N757ZZCessna R182 · S/N R18201278Cancelled May 13, 2023 · Sale reported, canceled · Built 1979 N564KECameron Balloons US O-105 · S/N 6501Cancelled May 11, 2023 · Built 2007 · Mars Leasing Company N61EXUltramagic S A N-250 · S/N 250/70Cancelled May 11, 2023 · Built 2012 · Mars Leasing N74EXUltramagic N-300 · S/N 300/60Cancelled May 11, 2023 · Built 2016 · Mars Leasing Co N50411Aerostar International S-57A · S/N S57A-3241Cancelled Apr 1, 2023 · Registration expired, pending cancellation · Built 2003 · Aldous Taylor M N773CHDJI PHANTOM 3 PROFESSION · S/N P76DCE29013905Cancelled Mar 4, 2023 · Registration expired, pending cancellation · Arizona Aerial Imaging LLC N774CHDJI INSPIRE 1 · S/N W13DCK11051499Cancelled Mar 4, 2023 · Registration expired, pending cancellation · Arizona Aerial Imaging LLC N294AZDJI MAVIC 2 PRO · S/N 163CGCRR0A1G07Cancelled Feb 20, 2023 · State Of Arizona N6135TCessna 150E · S/N 15060835Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Built 1964 · November Tango LLC N897JKKilbourn J W/Kilbourn M STARDUSTER TWO · S/N JK1Cancelled Jan 14, 2023 · Sale reported, canceled · Built 2000 N10KRKoehler Richard E KR-2 · S/N 5276Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Built 1982 · Giese Gary N5098ECessna 172N · S/N 17271711Cancelled Dec 31, 2022 · Sale reported, canceled · Built 1978 N9124VMooney M20C · S/N 690019Cancelled Dec 29, 2022 · Revoked, canceled · Built 1969 · Vals Fine Portraiture N991CPCessna 172R · S/N 17280283Cancelled Dec 29, 2022 · Sale reported, canceled · Built 1997 N419TTCessna 340 · S/N 340-0091Cancelled Dec 23, 2022 · Sale reported, canceled · Built 1972 N453CACessna 182T · S/N 18282138Cancelled Dec 19, 2022 · Sale reported, canceled · Built 2008 N345DLLeeper Damon L RV-4 · S/N 1345Cancelled Dec 16, 2022 · Sale reported, canceled · Built 1994 N55255Piper PA-28R-200 · S/N 28R-7335204Cancelled Dec 13, 2022 · Sale reported, canceled · Built 1973 N9855RBeech M35 · S/N D-6402Cancelled Nov 16, 2022 · Sale reported, canceled · Built 1960 N686TMEclipse EA500 · S/N 000221Cancelled Nov 7, 2022 · Registration pending, pending cancellation · Built 2008 N5550DBeech H35 · S/N D-5072Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Built 1957 · Mclenaghan Alvin N N9351RSix Chuter SR7 XL · S/N SR7XL-2963Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Built 2004 · Baerg Brendon D N19JTTurner Jerry THORP T-18 · S/N 934Cancelled Oct 1, 2022 · Registration expired, pending cancellation · White William F N93839Cessna 152 · S/N 15285558Cancelled Oct 1, 2022 · Registration expired, pending cancellation · Built 1982 · Wall Richard E N4487TPiper PA-28R-200 · S/N 28R-7235069Cancelled Sep 23, 2022 · Sale reported, canceled · Built 1972 N7029TCessna 172 · S/N 46629Cancelled Sep 3, 2022 · Registration expired, pending cancellation · Smith Robert W N560SLCessna 210N · S/N 21064702Cancelled Aug 30, 2022 · Sale reported, canceled · Built 1982 N7257LAmerican AA-1A · S/N AA1A-0457Cancelled Aug 24, 2022 · Sale reported, canceled · Built 1972 N301MMCessna T210M · S/N 21062754Cancelled Aug 16, 2022 · Sale reported, canceled · Built 1978 N330JFS N I A S SA330J · S/N 1514Cancelled Aug 6, 2022 · Sale reported, canceled N337EVS N I A S SA330J · S/N 1549Cancelled Aug 6, 2022 · Sale reported, canceled · Built 1978 N201HHMooney M20J · S/N 24-0053Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Built 1976 · Schandel George W N662PKDJI PHANTOM 3 PROFESSION · S/N P76DQF28016793Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Hbc Aviation LLC N693XFDJI PHANTOM 3 ADVANCED · S/N P76DCG15010790Cancelled Jul 30, 2022 · Registration expired, pending cancellation · H3d Solutions LLC N4557EGulfstream American AA-5B · S/N AA-5B-1230Cancelled Jul 2, 2022 · Registration expired, pending cancellation · Boehle Aviation LLC N6534AAerostar International S-60A · S/N S60A-3071Cancelled Jul 2, 2022 · Registration expired, pending cancellation · Built 1987 · Davalos Gary R N95397Cameron Balloons US V-77 · S/N 5579Cancelled Jul 2, 2022 · Registration expired, pending cancellation · Hot Air Expeditions Inc N14053Cessna 172R · S/N 17281254Cancelled May 11, 2022 · Exported to India · Built 2005 · Westwind School Of Aeronautics Phoenix LLC N4964SPiper PA-28R-200 · S/N 28R-35684Cancelled Mar 21, 2022 · Sale reported, canceled · Built 1970 N9285LAmerican AA-1A · S/N AA1A-0185Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Built 1971 · Brown Bertina A N2682EQuad City Ultralight CHALLENGER II · S/N 2361Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Built 1991 · Collum James W N250LBCoelho James J RV-4 · S/N 77-3889Cancelled Feb 2, 2022 · Sale reported, canceled N2933LMooney M20C · S/N 670067Cancelled Feb 2, 2022 · Sale reported, canceled · Built 1967 N429WSWild Sky GOAT · S/N 1709Cancelled Jan 24, 2022 · Sale reported, canceled · Built 2019 N779LBCirrus Design SR22 · S/N 2499Cancelled Jan 11, 2022 · Sale reported, canceled · Built 2007 N6064HBell 47G-4A · S/N 7606Cancelled Jan 8, 2022 · Registration expired, pending cancellation · Adler Jordan

Back to Phoenix, AZ