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.

N522FBMcdonnell Douglas Helicopter 500N · S/N LN002Cancelled Jul 21, 2006 · Exported to Australia · Built 1991 · City Of Phoenix Police DepartmentN526FBMcdonnell Douglas Helicopter 500N · S/N LN006Cancelled May 11, 2006 · Exported to Germany · Built 1992 · City Of Phoenix Police DepartmentN8XSBruss Adam M EUROPA CLASSIC · S/N UK185Cancelled Mar 20, 2006 · Triennial form not returned · Built 2003 · Bruss Adam MN8997Jenkins Joseph A JR 1A · S/N 4368-J1Cancelled Feb 17, 2006 · Second triennial mailing, no response · Jenkins Joseph A JrN7320QCessna 182P · S/N 18260960Cancelled Feb 8, 2006 · Built 1972 · Johnson Bruce TrusteeN999KSCessna T182T · S/N T18208016Cancelled Jan 12, 2006 · Kns Farms LLCN5155NCessna 182Q · S/N 18267548Cancelled Nov 1, 2005 · Triennial form not returned · Built 1980 · Rollins Herbert K 111N5360BCessna 182 · S/N 33360Cancelled Sep 8, 2005 · Exported to Mexico · Built 1956 · Lopez Jose I ValenzuelaN451CPiper PA-32R-301T · S/N 3257379Cancelled Jul 26, 2005 · Exported to Mexico · Built 2005 · Cutter Southwest Aircraft Sales LLCN4057SBalloon Works FIREFLY 7 · S/N 10069Cancelled Jun 17, 2005 · Triennial form not returned · Built 1980 · Haas Frank EN854SGEmbraer EMB-135BJ · S/N 14500854Cancelled Jun 10, 2005 · Exported to Cayman Islands · Built 2005 · Swift Aviation Sales IncN757DUCessna 152 · S/N 15279664Cancelled May 24, 2005 · Exported to Spain · Built 1977 · G Michael Lewin CorpN661XSchempp-Hirth VENTUS-B · S/N 79Cancelled Mar 17, 2005 · Exported to Australia · Built 1982 · Smolder Clement A IIN119GPiper PA-23 · S/N 23-231Cancelled Mar 1, 2005 · Triennial form not returned · Built 1955 · Accelerated Flight Crew Training CorpN124GGriswold-Ivan RUTAN VARIEZE · S/N 124Cancelled Dec 23, 2004 · Triennial form not returned · Built 1979 · Jordan Michael EN57LPParent Leo G JR PHANTOM I · S/N 598Cancelled Dec 15, 2004 · Triennial form not returned · Built 1991 · Parent Leo G JrN4046MRaven Industries RALLY RX7 · S/N RX7-310Cancelled Dec 7, 2004 · Triennial form not returned · Built 1983 · Cory Shane DN5730KRaven S55A · S/N S55A-800Cancelled Nov 3, 2004 · Triennial form not returned · Built 1981 · Newnam James AN32AZBell 206L-3 · S/N 51008Cancelled Oct 14, 2004 · Exported to Canada · Built 1982 · State Of Arizona Department Of Public SafetyN754CAGates Lear Jet 25B · S/N 090Cancelled Oct 6, 2004 · Exported to Canada · Built 1972 · Jescar LLCN398ZAAero Vodochody L-39ZA · S/N 332638Cancelled Oct 5, 2004 · Exported to Canada · Built 1983 · Worldwide Warbirds IncN2NEEastman N L THORP T-18C · S/N 1052Cancelled Sep 17, 2004 · Exported to Canada · Built 1982 · Greenfield Gaylord CN317AJMaule MXT-7-180 · S/N 14067CCancelled Sep 8, 2004 · Exported to Lithuania · Swiggers Arthur PN4367YSpillman Lyle E KITFOX IV · S/N 1532Cancelled Jul 22, 2004 · Triennial form not returned · Spillman Lyle EN2097LHaglund Joel W RV-4 · S/N 3416Cancelled Jul 7, 2004 · Triennial form not returned · Built 1995 · Haglund Joel WN404ZAAero Vodochody L-39ZA · S/N 132036Cancelled Jun 3, 2004 · Exported to United Kingdom · Built 1981 · Worldwide Warbirds IncN28ATCessna 337 · S/N 337-0181Cancelled May 27, 2004 · Triennial form not returned · Built 1965 · Ellegood Michael SN114RPSchempp-Hirth VENTUS-B · S/N 68Cancelled May 20, 2004 · Triennial form not returned · Built 1981 · Heydrich HansN126RSSchaff Robert J KITFOX CLASSIC IV · S/N C9903-0242Cancelled May 18, 2004 · Exported to South Africa · Built 2003 · Schaff Robert JN22CRBeech 35-B33 · S/N CD-435Cancelled May 18, 2004 · Triennial form not returned · Built 1961 · Dahlberg Dennis LN3607BAerostar International RAVEN S-55A · S/N S55A-3046Cancelled May 11, 2004 · Triennial form not returned · Paulson David HN6184DBell 206L-3 · S/N 51253Cancelled Mar 9, 2004 · Triennial form not returned · Airwest Helicopters LLCN642JBBridges John E LONG-EZ · S/N LE-6996Cancelled Feb 11, 2004 · Second triennial mailing, no response · Built 1987 · Bridges John EN200KBBowers Kenneth R JR HIGH FLIGHT1 · S/N 001Cancelled Jan 30, 2004 · Triennial form not returned · Bowers Kenneth R JrN850CBeech 200 · S/N BB-710Cancelled Dec 30, 2003 · Exported to Canada · Built 1980 · Cutter Aviation IncN36FKKirkland Fred HATBOX SPECIAL · S/N 462-96-8303Cancelled Oct 16, 2003 · Kirkland Freddy DN2005Archuleta Harry Manuel RANS S-10 · S/N 1289073Cancelled Oct 15, 2003 · Triennial form not returned · Douglas & Cox LlpN165TBVought TA-7C · S/N 156738Cancelled Jun 12, 2003 · Second triennial mailing, no response · Department Of The NavyN107JBBlumer James Allen MXL II SPORT · S/N 1308Cancelled May 30, 2003 · Second triennial mailing, no response · Gilespie Ted AN90892Balloon Works FIREFLY 8 · S/N F8-365Cancelled Apr 1, 2003 · Triennial form not returned · Built 1990 · Stevens Patrick DN75076Cameron Balloons US N-105 · S/N 5809Cancelled Mar 31, 2003 · Exported to Poland · Built 1992 · Heinrich PhilipN75WLBeech 200 · S/N BB-574Cancelled Mar 19, 2003 · Exported to Canada · Built 1979 · Salt River ProjectN25021Miller Charles MILLERS FLY-BY · S/N 001Cancelled Feb 14, 2003 · Triennial form not returned · Miller D CharlesN4764XCessna TU206G · S/N U20605533Cancelled Jan 16, 2003 · Exported to Mexico · Built 1980 · Desert Wings LLCN2350HBalloon Works FIREFLY 7 · S/N 7730Cancelled Dec 12, 2002 · Built 1978 · Steele Crystal LN205RCCosgrove Robert CHALLENGER II · S/N CHII0886W0205Cancelled Oct 4, 2002 · Second triennial mailing, no response · Cosgrove Robert MN9537UCameron Balloons US V-77 · S/N 5582Cancelled Oct 4, 2002 · Triennial form not returned · Built 1990 · Holt JudyN3SAPiasecki HUP-2 · S/N 128561Cancelled Aug 28, 2002 · Second triennial mailing, no response · Built 1952 · Horton Gerry EN5132ZCessna TU206G · S/N U20606069Cancelled Aug 20, 2002 · Exported to Mexico · Built 1981 · Landiscor IncN3388ECessna 172N · S/N 17271527Cancelled Jul 27, 2002 · Triennial form not returned · Built 1978 · Arndt Carl W
Back to Phoenix, AZ