Tempe, AZ

Cancelled registrations · 146

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 = 'TEMPE'
  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.

N303AWBoeing 737-3G7 · S/N 24010Cancelled May 9, 2013 · Sale reported, canceled · Built 1988N73SMBellanca 17-31ATC · S/N 75-31111Cancelled May 7, 2013 · Registration expired, pending cancellation · Built 1975 · Hilton KendalN6801ECessna 175A · S/N 56301Cancelled May 2, 2013 · Registration expired, pending cancellation · Built 1959 · Radford Mark AN5769SSchweizer SGS 1-26B · S/N 395Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1968 · Prokes William JN606HMooney M20E · S/N 909Cancelled Apr 10, 2013 · Revoked, canceled · Built 1965 · Badler LelandN95HTToler VARI EZE · S/N 373Cancelled Mar 20, 2013 · Sale reported, canceled · Built 1982N5032SPiper PA-28R-200 · S/N 28R-35794Cancelled Mar 19, 2013 · Registration expired, pending cancellation · Built 1970 · Rice Joel PN8900SCessna 150F · S/N 15062200Cancelled Mar 11, 2013 · Sale reported, canceled · Built 1965N4706PPiper PA-23-250 · S/N 27-234Cancelled Mar 8, 2013 · Built 1960 · Gear Down Hangar LLCN4069LBalloon Works FIREFLY 8-24 · S/N 10046Cancelled Mar 7, 2013 · Registration expired, pending cancellation · Built 1979 · Dudden Brent AN929HCMiller D Charles ROTORWAY EXEC · S/N 3069Cancelled Feb 11, 2013 · Sale reported, canceledN4019TBeech B23 · S/N M-1126Cancelled Nov 15, 2012 · Registration expired, pending cancellation · Built 1968 · Shipman Richard KN3778BBeech C-50 · S/N CH-186Cancelled Nov 9, 2012 · Registration expired, pending cancellation · Built 1955 · Block Scott MN3529HMooney M20C · S/N 20-1224Cancelled Oct 4, 2012 · Registration expired, pending cancellation · Built 1976 · Robertson Gary JrN2100WBeech C23 · S/N M-1472Cancelled Aug 23, 2012 · Registration expired, pending cancellation · Built 1973 · Lytle BillN4614QCessna 210L · S/N 21059514Cancelled Jul 31, 2012 · Revoked, canceled · Built 1971 · Zimmer HugoN4657HPiper PA-17 · S/N 17-65Cancelled Jul 31, 2012 · Revoked, canceled · Built 1948 · Singer Robert EN307SWBoeing 737-3H4 · S/N 22947Cancelled Jul 26, 2012 · Sale reported · Built 1985N236PSMyers Stephen KELLY F1D · S/N 002Cancelled Jul 19, 2012 · Registration expired, pending cancellation · Built 1995 · Smid Philip EN5220SPiper PA-32-300 · S/N 32-40913Cancelled Jun 12, 2012 · Registration pending, canceled · Built 1970N1053SParker Gregory H SCORPION-133 · S/N MSI-102Cancelled May 18, 2012 · Registration expired, pending cancellation · Parker Gregory HN302AWBoeing 737-3G7 · S/N 24009Cancelled Apr 26, 2012 · Sale reported · Built 1988N315AWBoeing 737-3S3 · S/N 23734Cancelled Feb 10, 2012 · Sale reported · Built 1987N78011Cessna A185F · S/N 18503902Cancelled Sep 2, 2010 · Exported to Canada · Built 1979 · Marine Resources IncN565TCCessna T182T · S/N T18208569Cancelled Jul 27, 2010 · Exported to Mexico · Built 2006 · Villarreal John PaulN14767Bellanca 17-30A · S/N 74-30653Cancelled May 6, 2009 · Registration revoked · Built 1973 · Martin Frank AN6049XMooney M20A · S/N 1640Cancelled May 21, 2008 · Built 1960 · Curt Hallam LLCN654HCCessna T210L · S/N 21060538Cancelled Jul 6, 2007 · Triennial form not returned · Built 1974 · Richlind Machinery IncN7461UBoeing 727-222 · S/N 21915Cancelled May 2, 2007 · Sale reported · Built 1980N87JEBeech B100 · S/N BE-27Cancelled May 24, 2005 · Exported to Canada · Built 1977 · C I T Leasing CorpN4465BCessna 170B · S/N 26809Cancelled Apr 4, 2005 · Triennial form not returned · Built 1955 · Gale Guy CN1021SRockwell International S-2R · S/N 1875RCancelled Aug 28, 2004 · Triennial form not returned · Built 1974 · Park Western Leasing IncN754DBLearjet 25 · S/N 014Cancelled Jun 7, 2004 · Built 1968 · C I T Leasing CorpN7680ZPiper PA-25-235 · S/N 25-3831Cancelled Feb 6, 2004 · Exported to Brazil · Built 1966 · Rawlings Robert K DBAN6645ZPiper PA-25-235 · S/N 25-2242Cancelled Feb 5, 2004 · Exported to Brazil · Built 1962 · Rawlings Robert K DBAN7665ZPiper PA-25-235 · S/N 25-3810Cancelled Feb 5, 2004 · Exported to Brazil · Built 1966 · Rawlings Robert K DBAN8796LPiper PA-25-235 · S/N 25-5483Cancelled Feb 5, 2004 · Exported to Brazil · Rawlings Robert K DbaceN4801YPiper PA-25-260 · S/N 25-4582Cancelled Feb 4, 2004 · Exported to Brazil · Built 1968 · Rawlings Robert K DBAN8509LPiper PA-25-235 · S/N 25-4924Cancelled Feb 4, 2004 · Exported to Brazil · Built 1969 · Rawlings Robert DBAN802DMBell 430 · S/N 49063Cancelled Dec 16, 2003 · Exported to Switzerland · Built 2000 · Cit Group/Equipment Financing IncN701JAGulfstream American G-1159 · S/N 007Cancelled Nov 4, 2003 · Triennial form not returned · Built 1968 · C I T Leasing CorporationN664GAGulfstream Aerospace G-V · S/N 664Cancelled Oct 1, 2002 · Exported to Mexico · Built 2001 · C I T Leasing CorpN703PJBoeing 737-130 · S/N 19016Cancelled Jan 11, 2001 · Triennial form not returned · Spectrum Aerospace IncN277AZJamison James L SNS-8 · S/N 48Cancelled Aug 14, 2000 · Triennial form not returned · Jamison James LN3723BBalloon Works FIREFLY 7 · S/N F7-098Cancelled May 9, 2000 · Exported to Belgium · Hot Air Balloon Company Inc DBAN714VXCessna 152 · S/N 15279477Cancelled Jun 17, 1999 · Triennial form not returned · Built 1977 · Silva Judith AN1124SSchweizer SGS 1-26E · S/N 512Cancelled Apr 27, 1999 · Triennial form not returned · Quest Aviation Services IncN6302HAerostar International RAVEN S57-A · S/N S57A3105Cancelled Apr 13, 1999 · Voltar Communications IncN330VPBeech F90 · S/N LA227Cancelled Nov 25, 1998 · Exported to Germany · J L Mark IncN6085CCameron Balloons US A-210 · S/N 5458Cancelled May 28, 1998 · Triennial form not returned · The Hot Air Balloon Company Inc
Back to Tempe, AZ