Phoenix, AZ

Cancelled registrations · 1,583

Query with SQL
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.

N13836Stinson SR-5 · S/N 9201ACancelled Apr 22, 2019 · Revoked, canceled · Built 1934 · Airborne Exploration CorpN2341QBeech 23 · S/N M-409Cancelled Apr 22, 2019 · Revoked, canceled · Built 1963 · Desert Skyrunners IncN988ZSCameron Balloons Z-90 · S/N 6223Cancelled Apr 5, 2019 · Built 1999 · Mars LeasingN144BEBirds Eye Productions X8HL · S/N SYN8124Cancelled Mar 23, 2019 · Registration expired, pending cancellation · Birds Eye Productions LLCN146BERitewing RC Z3 · S/N RZ3420Cancelled Mar 23, 2019 · Registration expired, pending cancellation · Birds Eye Productions LLCN147BERitewing RC DRAK67 · S/N RD67981Cancelled Mar 23, 2019 · Registration expired, pending cancellation · Birds Eye Productions LLCN815PMAvyon MICRODRONES MD4-1000 · S/N 260Cancelled Mar 23, 2019 · First renewal notice · Arizona Public ServiceN97395Stinson 108 · S/N 108-395Cancelled Mar 16, 2019 · Registration expired, pending cancellation · Meyer Brent AN112HGDJI INSPIRE 1 · S/N CD20112935581CCancelled Mar 11, 2019 · Registration expired, pending cancellation · Johnson Whitney MN2537FChampion 7ECA · S/N 159Cancelled Mar 9, 2019 · Sale reported, canceled · Built 1965N5973FCessna 210H · S/N 21058973Cancelled Mar 2, 2019 · Sale reported, canceled · Built 1968N363TCRiddell Orin LANCAIR 360 · S/N 925320765SFBCancelled Feb 23, 2019 · Registration expired, pending cancellation · Built 1997 · Hendricks Paul TrusteeN64EXUltramagic N-300 · S/N 300/59Cancelled Feb 23, 2019 · First renewal notice · Built 2016 · Hot Air ExpeditionsN143BEFreefly Systems ALTA · S/N 389841Cancelled Feb 9, 2019 · Registration expired, pending cancellation · Birds Eye Productions LLCN145BEDJI INSPIRE 1 · S/N W130CA18020870Cancelled Feb 9, 2019 · Registration expired, pending cancellation · Birds Eye Productions LLCN7540CForney F-1 · S/N 5655Cancelled Feb 9, 2019 · Revoked, canceled · Built 1958 · Roe Aubrey A DrN254ZDJI PHANTOM 3 PROFESSION · S/N P76DCF26016312Cancelled Feb 5, 2019 · Registration expired, pending cancellation · Oxios JasonN433CSCessna T240 · S/N T24002033Cancelled Feb 5, 2019 · Registration expired · Raymond Aviation LLCN581ECPrecision Drone PACESETTER · S/N DB000208Cancelled Feb 2, 2019 · Registration expired, pending cancellation · Inter Ag Services IncN6385YCessna T210N · S/N 21064358Cancelled Jan 24, 2019 · Sale reported, pending cancellation · Built 1981N548FWhite William F KITFOX MII · S/N 001Cancelled Jan 22, 2019 · Registration expired, pending cancellation · Built 2010 · White William FN9854YAeronca 7FC · S/N 7FC417Cancelled Jan 14, 2019 · Revoked, canceled · Built 1960 · Dietz Sky SailsN52706Cessna 172P · S/N 17274587Cancelled Dec 6, 2018 · Registration expired, pending cancellation · Built 1981 · Call The Ball Aviation LLCN2207SBeech SNB-5 · S/N 39246Cancelled Nov 20, 2018 · Revoked, canceled · Built 1951 · Desert Avn SvcN2209SBeech SNB-5 · S/N 29620Cancelled Nov 20, 2018 · Revoked, canceled · Built 1951 · Desert Avn SvcN2214SBeech SNB-5 · S/N 39865Cancelled Nov 20, 2018 · Revoked, canceled · Built 1952 · Desert Avn SvcN9721XCessna 210B · S/N 21058021Cancelled Nov 17, 2018 · Revoked, canceled · Built 1962 · Forbes Robert PN4534GRobinson Helicopter R44 · S/N 2034Cancelled Nov 6, 2018 · Sale reported, canceled · Built 2009N507SRRobinson Stewart J BEARHAWK · S/N 003-5/6-507Cancelled Nov 6, 2018 · Sale reported, canceled · Built 2015N6885FPiper PA-32R-300 · S/N 32R-7780048Cancelled Oct 12, 2018 · Sale reported, canceled · Built 1976N7522ECameron Balloons US A-105 · S/N 5850Cancelled Sep 13, 2018 · Registration expired, pending cancellation · Built 1993 · Float Balloon Tours LLCN950UPiper PA46-500TP · S/N 4697130Cancelled Sep 13, 2018 · Exported to Australia · Built 2002 · Cutter Southwest Aircraft Sales LLCN7040YPiper PA-30 · S/N 30-43Cancelled Sep 7, 2018 · Sale reported, canceled · Built 1963N2309XCessna 182H · S/N 18256209Cancelled Aug 10, 2018 · Registration expired, pending cancellation · Built 1965 · Dubaj ChesterN411CDWsk-Pzl-Mielec TS-11 ISKRA · S/N 3H1201Cancelled Aug 10, 2018 · Registration expired, pending cancellation · Dubaj ChesterN537THDJI PHANTOM 2 VISION + · S/N PH645480655Cancelled Aug 10, 2018 · Registration expired, pending cancellation · Hanna Darl DN543MSPoland TS-11 ISKRA · S/N 1H0308Cancelled Aug 10, 2018 · Registration expired, pending cancellation · Dubaj ChesterN6148QCessna 152 · S/N 15285171Cancelled Aug 10, 2018 · Registration expired, pending cancellation · Dubaj ChesterN9390VMooney M20F · S/N 700019Cancelled Aug 10, 2018 · Registration expired, pending cancellation · Dubaj ChesterN71403Aerostar International RX-9 · S/N RX9-3007Cancelled Aug 2, 2018 · Sale reported, canceled · Built 1996N8038KStinson 108 · S/N 1083038Cancelled Jul 19, 2018 · Revoked, pending cancellation · Built 1947 · Twyford Jim EnterprisesN4997UBell 47G-2 · S/N 622Cancelled Jul 12, 2018 · Registration expired, pending cancellation · Wall Richard EN110KASchleicher KA 10 · S/N 1007Cancelled Jun 26, 2018 · Registration pending, canceled · Built 1965N115JMSchleicher KA 6 CR · S/N 6098/SICancelled Jun 26, 2018 · Registration pending, canceled · Built 1962N32SNShannon William RV6A · S/N 23805Cancelled Jun 8, 2018 · Registration expired, pending cancellation · Built 2001 · Lee BrandonN9241JPiper PA-28-180 · S/N 28-3315Cancelled Jun 4, 2018 · Sale reported, canceled · Built 1966N9246SBeech C23 · S/N M-1742Cancelled Jun 4, 2018 · Sale reported, canceled · Built 1975N9381VMooney M-20G · S/N 700002Cancelled Jun 4, 2018 · Sale reported, canceled · Built 1969N9801VCessna 172M · S/N 17264509Cancelled Jun 4, 2018 · Sale reported, canceled · Built 1974N8419DPiper PA-22-150 · S/N 22-5673Cancelled Jun 1, 2018 · Sale reported, canceled · Built 1957
Back to Phoenix, AZ