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.

N1526DBalloon Works FIREFLY 7 · S/N 11090Cancelled Jan 10, 2018 · Registration expired, pending cancellation · Built 1981 · Nash Ken CN103WRRuehle HP-18 · S/N WHR-3Cancelled Jan 9, 2018 · Registration expired, pending cancellation · Built 1977 · Strong Ronald EN36EXUltramagic S A N-250 · S/N 250/31Cancelled Jan 4, 2018 · Registration expired, pending cancellation · Built 2004 · Mars Leasing Co IncN44809Dist 876 Annandale School ACRO SPORT · S/N 502Cancelled Jan 4, 2018 · Registration expired, pending cancellation · Built 1984 · Crawford Shawn LN23728Cahill Mark G SABRE · S/N MC0068Cancelled Jan 2, 2018 · Registration expired, pending cancellation · Built 1998 · Cahill Mark GN2459KCessna 172S · S/N 172S10034Cancelled Jan 2, 2018 · Registration expired, pending cancellation · Built 2005 · Westwind Aircraft Leasing LLCN63348Consolidated Vultee BT-13A · S/N 3457Cancelled Nov 21, 2017 · Revoked, canceled · Built 1942 · Babb Co IncN7628PPiper PA-24-250 · S/N 24-2838Cancelled Nov 21, 2017 · Revoked, canceled · Built 1961 · Starlite Aluminum Sliding Dr CoN8999TCessna 182C · S/N 52899Cancelled Nov 21, 2017 · Revoked, canceled · Built 1960 · Davis Richard GN90235Beech SNB-5 · S/N 67324Cancelled Nov 21, 2017 · Revoked, canceled · Built 1953 · Derrick Bernice LN5141VMorrisey 2150A · S/N SP37Cancelled Nov 20, 2017 · Revoked, canceled · Built 1962 · Amos Flight Operations IncN1931KLuscombe 8A · S/N 4658Cancelled Oct 28, 2017 · Revoked, canceled · Built 1947 · Remington W DN5954DPiper PA-22-150 · S/N 22-4618Cancelled Oct 28, 2017 · Revoked, pending cancellation · Built 1956 · Paradise Airport IncN604BHBeech 60 · S/N P-38Cancelled Oct 27, 2017 · Registration expired, pending cancellation · Built 1968 · Standley James AN653LCCravens Larry L C-653 · S/N C653-001Cancelled Sep 7, 2017 · Registration expired, pending cancellation · Built 1999 · Stevens PatrickN504JPAirbus Industrie A320-231 · S/N 322Cancelled Aug 8, 2017 · Exported to Ukraine · Jetpro International LLCN28398Grumman American Avn. AA-5B · S/N AA5B0590Cancelled Jul 20, 2017 · Registration expired, pending cancellation · Built 1977 · Alpha Flight IncN1363MAir Creation GTE · S/N T06014Cancelled Jul 14, 2017 · Registration expired, pending cancellation · Built 2006 · Mcdermott Cornelius JN308CBCameron Balloons V-77 · S/N 344Cancelled Jul 12, 2017 · Registration expired, pending cancellation · Built 1979 · Clewley Eugene FN93FPiper PA-24-180 · S/N 24-1057Cancelled Jun 30, 2017 · Registration expired, pending cancellation · Built 1959 · Western Maricopa Education Center No 402N38099Texas Helicopter OH-13E/M74 · S/N 77-006Cancelled Jun 21, 2017 · Registration expired, pending cancellation · Built 1977 · Agrinvest International IncN61050Fairchild SA227-DC (C26B) · S/N DC-834MCancelled Jun 16, 2017 · Registration expired, pending cancellation · Pioneer Aviation IncN4304YPiper PA-23-160 · S/N 23-2027Cancelled Jun 14, 2017 · Registration expired, pending cancellation · Built 1962 · Lastgapa LLCN7RSsbm CF-5D · S/N 116837Cancelled Jun 14, 2017 · Ssbm LLCN9PSsbm CF-5D · S/N 116823Cancelled Jun 14, 2017 · Ssbm LLCN6131ZFairchild SA227-DC (C26B) · S/N DC803MCancelled Jun 8, 2017 · Registration expired, pending cancellation · Pioneer Aviation IncN191MHHigginbotham Mark Oneill RANS S-9 · S/N 1005191Cancelled Jun 7, 2017 · Registration expired, pending cancellation · Douglas William HN481CAPiper PA-32R-301T · S/N 3257081Cancelled May 31, 2017 · Registration expired, pending cancellation · Built 1999 · Macho Grande Air LLCN9504YCameron Balloons US V-77 · S/N 5626Cancelled May 26, 2017 · Registration expired, pending cancellation · Built 1990 · Reaksecker Gregory KN2904FRaven Industries S77A · S/N S77A-118Cancelled May 23, 2017 · Registration expired, pending cancellation · Built 1986 · A Aeronautical Adventure IncN7445RPiper PA-28-140 · S/N 28-21986Cancelled May 23, 2017 · Registration expired, pending cancellation · Built 1966 · Bond Nick KN4194FRaven Industries S-66A · S/N S66A-134Cancelled May 22, 2017 · Registration expired, pending cancellation · Built 1982 · A Aeronautical Adventure IncN3289XCessna 310L · S/N 310L-0139Cancelled Apr 18, 2017 · Registration expired, pending cancellation · Built 1967 · Lima Pilots IncN4059KBalloon Works FIREFLY 7 · S/N 7962Cancelled Apr 13, 2017 · Registration expired, pending cancellation · Built 1979 · Schenck Mark SN1677APiper PA-22 · S/N 22-439Cancelled Apr 7, 2017 · Registration expired, pending cancellation · Built 1952 · Roe Patrick JN422TRKurtzman Chad CHALLENGER II · S/N CH2-0804-2519Cancelled Apr 7, 2017 · Registration expired, pending cancellation · Built 2008 · Kurtzman ChadN4279ASchempp-Hirth STANDARD AUSTRIA SH1 · S/N 60Cancelled Apr 7, 2017 · Registration expired, pending cancellation · Built 1964 · Rubenstein Michael TN7672MCessna 175 · S/N 55972Cancelled Apr 7, 2017 · Registration expired, pending cancellation · Built 1959 · Leighton Bruce EN301MCessna 195 · S/N 7772Cancelled Apr 4, 2017 · Registration expired, pending cancellation · Bart JoeN518SHHickam Steven A QUICKIE-1 · S/N 518Cancelled Apr 4, 2017 · Registration expired, pending cancellation · Built 1993 · Cruz Samuel EN5281ZPiper PA-22-108 · S/N 22-8976Cancelled Apr 4, 2017 · Registration expired, pending cancellation · Built 1961 · Gunsch Matthew TN90141Balloon Works FIREFLY 8-24 · S/N F8-140Cancelled Mar 24, 2017 · Registration expired, pending cancellation · Starr William KN324PSBeechcraft TC-12B · S/N 161510Cancelled Mar 20, 2017 · Sale reportedN3487TCessna 177 · S/N 17700787Cancelled Mar 10, 2017 · Registration expired, pending cancellation · Built 1968 · Southwest American Woodworks LLCN48EXUltramagic S A N-250 · S/N 250/55Cancelled Mar 9, 2017 · Built 2009 · Mars LeasingN91PLCessna 210L · S/N 21060477Cancelled Mar 6, 2017 · Registration expired, pending cancellation · Built 1974 · Toro Aviation IncN54177Cirrus Design SR20 · S/N 1496Cancelled Feb 28, 2017 · Registration expired, pending cancellation · Built 2005 · Ice Dragons International AviationN669JCCupp Jackie M CASSUTT SPECIAL · S/N JC4Cancelled Feb 28, 2017 · Registration expired, pending cancellation · Built 1994 · North American Aircraft Holdings LLCN72954Dooley Philip E WAG AERO SPT TRAINER · S/N PD001Cancelled Feb 28, 2017 · Registration expired, pending cancellation · Dooley Philip EN906Cobb Intl/DBA Rotorway Intl IN EXEC 162F · S/N 6050Cancelled Feb 28, 2017 · Registration expired, pending cancellation · Built 2000 · Cobb International Inc
Back to Phoenix, AZ