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.

N8094ZRaven S55A · S/N S55A499Cancelled Apr 7, 1998 · Triennial form not returned · Voltar Communications IncN4278RSpargo Lyle R DRAGONFLY · S/N 1Cancelled Feb 20, 1998 · Triennial form not returned · Spargo Lyle RN4089URaven S-60A · S/N S60A267Cancelled Aug 20, 1997 · Triennial form not returned · Knix Radio StationN6679VBellanca 17-30 · S/N 30052Cancelled Sep 8, 1995 · Second triennial mailing, no response · Edwards Dante DN922ETTeague Edwin L PHANTOM · S/N 487Cancelled Aug 24, 1994 · Triennial form not returned · Teague Edwin LN5312RCessna 172M · S/N 17263514Cancelled May 2, 1994 · Triennial form not returned · Cook Charles LN13896Cessna 172M · S/N 17263033Cancelled Jan 22, 1993 · Exported to Czech Republic · Pixler Martin BN85ASStrojnik Alex S-4 · S/N 001Cancelled Dec 29, 1992 · Triennial form not returned · Strojnik AlexN38823Hasforth Chester MITCHELL U2 · S/N 159Cancelled Apr 16, 1992 · Triennial form not returned · Hasforth Chester DN4198PRaven S55A · S/N S55A944Cancelled May 22, 1991 · Triennial form not returned · Voltar Communications IncN89WSStarr Robert H BUMBLE BEE II · S/N 1Cancelled Apr 2, 1991 · Triennial form not returned · Starr Robert HN83WSStarr Robert H STARR · S/N 1Cancelled Nov 26, 1990 · Triennial form not returned · Starr Robert HN6653XCessna 210A · S/N 21057653Cancelled Aug 20, 1984 · Allen Benjamin IncN5262UCessna 172RG · S/N 172RG0309Cancelled Dec 5, 1983 · Ewell Glendel EN2309EFritts-David CASSUTT-3M · S/N 12345Cancelled Sep 10, 1983 · Registration expired, pending cancellation · Built 1978 · Field John CN49774Cessna 152 · S/N 15283512Cancelled Mar 16, 1983 · Exported to Canada · Larry A Sullivan And David C BancroftN3586Nickerson-Pietenpol AIR CAMPER NFL · S/N 1Cancelled Dec 28, 1981 · Built 1970 · Bolan Stev A Et AlN37824Newell SCORPION 133 · S/N RW04Cancelled May 5, 1981 · Newell AlN69395Stinson VULTEE V-77 · S/N 77-477Cancelled Jan 20, 1981 · Sanders A PN5886Rotorway SCORPION TOD BJ201 · S/N 001Cancelled Nov 12, 1980 · Rotorway IncN31222Schramm SCORPION TOO · S/N RW02Cancelled Nov 10, 1980 · Built 1975 · Schramm B JN8010PPiper PA-24-250 · S/N 24-3253Cancelled Apr 6, 1978 · Kessler Ron Bingham F Daniel Arrowsmith RobertN25186Parker ICARUS · S/N JP02Cancelled Jul 12, 1977 · Built 1976 · Parker Jeffrey DN1819GChampion 7ECA · S/N 576Cancelled Dec 1, 1976 · Exported to Canada · Farrer William RN34087Schweizer SGS 1-35 · S/N 10Cancelled Jan 12, 1976 · Arizona Soaring IncN44756Naval Aircraft Factory N3N-3 · S/N 2773Cancelled Sep 15, 1975 · Built 1945 · Sanders A PN4423SCessna 337D · S/N 337-1035Cancelled Mar 12, 1975 · Exported to Canada · Built 1969 · Hazeltine JohnN662APiper PA-22 · S/N 22-65Cancelled Aug 9, 1974 · King John LN7530Schweizer SGS 2-33A · S/N 170Cancelled May 10, 1974 · Exported to Canada · Arizona Soaring IncN6019QMooney M20E · S/N 869Cancelled Jun 25, 1973 · Heidemann LeeN72453Cessna U206D · S/N U206-1413Cancelled Apr 29, 1972 · Blanco FrankN44977Naval Aircraft Factory N3N-3 · S/N 2823Cancelled Mar 9, 1972 · Built 1943 · Sanders A PN45110Naval Aircraft Factory N3N-3 · S/N 4364Cancelled Mar 9, 1972 · Built 1941 · Sanders A PN38191Piper J4E · S/N 4-1557Cancelled Aug 21, 1970 · Miller Jr Max LN45007Naval Aircraft Factory N3N-3 · S/N 2779Cancelled Jun 6, 1965 · A P SandersN19001Taylorcraft A · S/N 107Cancelled Sep 20, 1960 · Aeronautics Division Industrial Arts DeptN47710Aeronca 0-58B · S/N 058B4982Cancelled Sep 20, 1960 · Built 1944 · Arizona State College Aeronautics DeptN83351Aeronca 7AC · S/N 7AC-2018Cancelled Sep 20, 1960 · Arizona State CollegeN85007Aeronca 11AC · S/N 11AC-3732Cancelled Sep 20, 1960 · Aeronautics Division Industrial Arts DeptN4973VStinson L-5 · S/N 02793Cancelled Feb 19, 1958 · Built 1949 · Arizona State College - TempeN43317Taylorcraft BC12-D · S/N 6976Cancelled Feb 29, 1956 · Harold J HartN85272Aeronca 7AC · S/N 7AC-4007Cancelled Feb 20, 1956 · Tempe Airport IncN45173Naval Aircraft Factory N3N-3 · S/N 2638Cancelled Jan 24, 1956 · Sanders A PN2260KLuscombe 8A · S/N 4987Cancelled Feb 20, 1951 · Tempe Arpt IncN847CStinson 108-3 · S/N 108-3847Cancelled Feb 14, 1951 · Tempe Arpt IncN37281Interstate S-1A · S/N 124Cancelled Sep 15, 1949 · W L Hixon
Back to Tempe, AZ