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.

N4427TPiper PA-28-140 · S/N 28-7225171Cancelled Sep 28, 2009 · Exported to Philippines · Built 1972N345JFCessna 150M · S/N 15076291Cancelled Sep 18, 2009 · Registration revoked · Built 1974 · Triplet Wilton CN93740Ercoupe 415-C · S/N 1063Cancelled Sep 18, 2009 · Registration revoked · Built 1946 · Irvin Aircraft EnterprisesN9736AFirst Fighter GRP Flying Club F4U CORSAIR-R · S/N PF4U-R-01-1ACancelled Sep 18, 2009 · Registration revoked · First Fighter Grp Flg Club IncN86429Ableiter GREEN HORNET GYRO · S/N 4615Cancelled Sep 16, 2009 · Registration revoked · Built 1962 · Cosmand GeneN2211RCessna T210H · S/N T210-0361Cancelled Jul 14, 2009 · Registration revoked · Built 1968 · Prudential Management Services IncN202NHNagler NAGLER 202 · S/N 74-001Cancelled Jul 10, 2009 · Registration revoked · Nagler Aircraft CorpN1800EBeech C-45H · S/N AF-768Cancelled Jul 9, 2009 · Registration revoked · Built 1952 · Aire Sales & Service IncN1863LBeech V35B · S/N D-9886Cancelled Jul 9, 2009 · Registration revoked · Built 1976 · Demore Allan VN1294YCessna 150B · S/N 15059694Cancelled Jun 30, 2009 · Registration revoked · Built 1962 · Eliason Alden AN36480Balloon Works FIREFLY 7-B · S/N F7B-076Cancelled Mar 31, 2009 · Second triennial mailing, no response · Built 1983 · Bartsch Sally LN131DLLavigna Daniel M JR LANCAIR IV P · S/N LIV-131Cancelled Mar 9, 2009 · Triennial form not returned · Built 1996 · Floatron IncN3672BBeech A36 · S/N E-1707Cancelled Feb 4, 2009 · Triennial form not returned · Built 1980 · Finplan Air Service LLCN704JDCessna 150M · S/N 15078640Cancelled Jan 5, 2009 · Built 1976 · Bursley Richard RN269LMDouglas C-47 · S/N 43-48793Cancelled Nov 18, 2008 · Triennial form not returned · Global Aircraft IncN126GCAerostar S A YAK-52 · S/N 9611908Cancelled Nov 5, 2008 · Exported to Lithuania · Built 1996 · Bromka Alan AN9374SBeech C23 · S/N M-1672Cancelled Aug 25, 2008 · Built 1975 · Arizona Thunderbolts LLCN30867Cessna 177B · S/N 17701515Cancelled Aug 14, 2008 · Exported to Canada · Built 1970 · Phillips Chris RN7438Manis BG 12/16 · S/N 3Cancelled Jul 25, 2008 · Triennial form not returned · Built 1975 · Jorgenson Paul RN720HBoeing 720-051B · S/N 18384Cancelled Jul 14, 2008 · Triennial form not returned · Built 1961 · Honeywell International IncN35347Cessna T182T · S/N T18208045Cancelled Jun 9, 2008 · Triennial form not returned · Stuart Aircraft LLCN627PACessna 152 · S/N 15281078Cancelled Apr 29, 2008 · Triennial form not returned · Built 1977 · Dgv Holdings Inc DBAN7729SSchweizer SGS 1-26D · S/N 429Cancelled Apr 23, 2008 · Built 1968 · Mcanerny Russell RN323DBeech A36 · S/N E2613Cancelled Apr 14, 2008 · Triennial form not returned · Built 1991 · Mesa Pilot DevelopmentN304PAPiper PA-44-180 · S/N 4496123Cancelled Mar 11, 2008 · Sale reported · Built 2002N613TVEurocopter AS 350 B2 · S/N 2883Cancelled Feb 27, 2008 · Built 1995 · Ktvk IncN4698PNorth American T-28B · S/N 138364Cancelled Jan 24, 2008 · Exported to Canada · Presto Andrew J IIIN301FBFantasy Sky Promotions FANTASY SEVEN BALLN · S/N 044Cancelled Dec 18, 2007 · Triennial form not returned · Built 1990 · Newnam James AN20062Cessna 172M · S/N 17260974Cancelled Nov 19, 2007 · Exported to Poland · Built 1972 · Dubaj ChesterN919WKKowtun Walter MINI 500 · S/N 413Cancelled Nov 7, 2007 · Triennial form not returned · Kowtun WalterN999NCPiper PA-32-260 · S/N 32-149Cancelled Nov 6, 2007 · Exported to Canada · Built 1965 · Griffin Phillip WN221JRRobinson Helicopter R22 BETA · S/N 3592Cancelled Oct 25, 2007 · Exported to Canada · Built 2004 · Pdp Aircraft Leasing LLCN97287Cessna 182Q · S/N 18267043Cancelled Oct 18, 2007 · Triennial form not returned · Built 1979 · Kochert Leroy F TrusteeN24322Cessna 172R · S/N 17280866Cancelled Oct 15, 2007 · Exported to Canada · Built 2000 · Aguila Aircraft Leasing LLCN141CWCessna 172S · S/N 172S9389Cancelled Jul 17, 2007 · Exported to Australia · Built 2003 · Crossways LLCN28UMCessna 337 · S/N 337-0028Cancelled May 17, 2007 · Exported to Canada · Built 1965 · Ellegood Michael S TrusteeN285PAPiper PA-28R-201 · S/N 2844064Cancelled May 14, 2007 · Exported to Denmark · Built 2001 · Waa Holdings Inc DBAN133ECessna 172M · S/N 172-61411Cancelled Apr 24, 2007 · Exported to Canada · Jankowski Michael LN64997Aerostar International RX-7 · S/N RX7-3120Cancelled Apr 11, 2007 · Triennial form not returned · Built 1987 · Shluker SteveN728KFGibbs Michael J KITFOX IV-1200 · S/N ICU-093Cancelled Mar 15, 2007 · Triennial form not returned · Built 2003 · Gibbs MichaelN124PWWalker Billy NIEUPORT 17 · S/N 621Cancelled Feb 23, 2007 · Triennial form not returned · Built 1998 · Walker William D JrN233ACBell UH-1H · S/N 65-10036Cancelled Feb 12, 2007 · Triennial form not returned · Built 1965 · Continental Helicopters IncN150MXPilatus PC-12/45 · S/N 580Cancelled Dec 26, 2006 · Exported to Brazil · Built 2004 · Queen Street Pc 12 LLCN65486Cessna 152 · S/N 15281583Cancelled Nov 22, 2006 · Exported to Canada · Built 1978 · Mangis Brian KN95512Cessna 152 · S/N 15285911Cancelled Nov 8, 2006 · Exported to Brazil · Built 1984 · Westwind Aviation IncN96736Cessna 152 · S/N 15286019Cancelled Nov 8, 2006 · Exported to Brazil · Built 1985 · Westwind Aviation IncN2461SCessna 172R · S/N 17280824Cancelled Sep 22, 2006 · Exported to Spain · Built 1999 · Kardan Air LLCN4144CPiper PA-44-180 · S/N 4496020Cancelled Aug 30, 2006 · Triennial form not returned · Built 1998 · Westwind Aviation IncN345JFCessna 150M · S/N 150-76291Cancelled Aug 18, 2006 · Registration revoked · Built 1974 · Triplet Wilton CN5671WPiper PA-28-150 · S/N 28-985Cancelled Aug 2, 2006 · Exported to Mexico · Built 1963 · Parker Mark Charles Boccaccio
Back to Phoenix, AZ