Tucson, AZ

Cancelled registrations · 1,234

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

N537WDDouglas Trudeau DJI PHANTOM 2 VISION · S/N PH645349490Cancelled Jul 12, 2018 · Registration expired, pending cancellation · Trudeau DouglasN1408FCessna 172H · S/N 17254903Cancelled Jun 26, 2018 · Registration pending, canceled · Built 1966N701TCCessna 210 · S/N 57300Cancelled Jun 26, 2018 · Registration pending, canceled · Built 1960N9422ZDouglas B-26C · S/N 44-34328Cancelled Jun 26, 2018 · Registration pending, canceled · Built 1944N5NXOakley John R KITFOX IV SPEEDSTER · S/N HBS-046Cancelled Jun 8, 2018 · Registration expired, pending cancellation · Built 1997 · Kaplan Robert BN67034Douglas C-54 · S/N 56548Cancelled Jun 8, 2018 · Registration expired, pending cancellation · Maricopa Aircraft IncN67040Douglas C54B-DC · S/N 27232Cancelled Jun 8, 2018 · Registration expired, pending cancellation · Maricopa Aircraft IncN9923UGrumman American Avn. AA-1C · S/N AA1C0157Cancelled Jun 4, 2018 · Sale reported, canceled · Built 1978N62252Ross Doyle B BOREDOM FIGHTER W 11 · S/N 54Cancelled May 31, 2018 · First renewal notice · Built 1994 · Mclearran William CN8103RBeech 95-B55 (T42A) · S/N TC-1260Cancelled May 31, 2018 · Sale reported, canceled · Built 1969N127JKKnell Jeff ASC SPIRIT · S/N 0004Cancelled May 30, 2018 · Sale reported, canceled · Built 2007N34AHDouglas SUPER R4D-8 · S/N 43360Cancelled May 30, 2018 · Sale reported, canceled · Built 1952N3739GConsolidated Vultee P4Y-2 · S/N 59819Cancelled May 30, 2018 · Sale reported, canceled · Built 1945N49044Cessna 152 · S/N 15281118Cancelled May 30, 2018 · Sale reported, canceledN9720ZVertol H21A · S/N 51-15260Cancelled May 21, 2018 · Revoked, canceled · Heli Crane CorpN711RFFonk THORP T-18 · S/N 514Cancelled May 3, 2018 · Sale reported, canceled · Built 1978N132DFAvimech International DRAGONFLY DF1 · S/N 0001Cancelled Apr 19, 2018 · Registration expired, pending cancellation · Avimech International AircraftN426ABAvimech Intl DRAGONFLY DF2S · S/N 0001Cancelled Apr 18, 2018 · Registration expired, pending cancellation · Avimech International Aircraft IncN213RZReddy J/Zones A EUROPA XS · S/N A213Cancelled Apr 12, 2018 · Reddy JohnN6166Lockheed 18-56 · S/N 2322Cancelled Mar 27, 2018 · Registration expired, pending cancellation · Magoffin John O JrN9434LAmerican AA-5 · S/N AA5-0234Cancelled Mar 23, 2018 · Revoked, canceled · Nigro EdwardN580UC3D Robotics SOLO · S/N S111A5501499Cancelled Mar 19, 2018 · First renewal notice · Auv LLC DBAN3737HErcoupe 415-C · S/N 4362Cancelled Mar 16, 2018 · Revoked, canceled · Built 1946 · Boss GloriaN50667Aerostar International RX 8 · S/N RX8-3373Cancelled Mar 14, 2018 · Registration expired, pending cancellation · Built 2003 · Norris Stephen WN292PMCessna T210L · S/N 21059839Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Built 1973 · Lemas Contreras ManuelN578DADJI INSPIRE 1 · S/N W13DCA22020643Cancelled Mar 13, 2018 · First renewal notice · Auv LLC DBAN226AVSteadidrone MAVRIK X8 · S/N 20150063MCancelled Mar 12, 2018 · Auv LLC DBAN23CZDean S Morgan DEAN COZY · S/N 108Cancelled Mar 12, 2018 · Registration expired, pending cancellation · Boyd James EN582ZSSteadidrone MAVRIK X8 · S/N 20140030MCancelled Mar 12, 2018 · First renewal notice · Auv LLCN711BXCessna 525 · S/N 525-0299Cancelled Mar 8, 2018 · Registration expired, pending cancellation · Built 1999 · Baker Donald LN834BBeech/Manley BEECH/MANLEY T-34B · S/N BG274MCancelled Mar 8, 2018 · Registration expired, pending cancellation · Manley Marvin LN8636ZCessna TP206C · S/N P206-0436Cancelled Mar 8, 2018 · Registration expired, pending cancellation · Built 1967 · Vroom David HN816DDouglas C-54E · S/N 44-9150Cancelled Mar 6, 2018 · Registration expired, pending cancellation · Built 1944 · Maricopa Aircraft IncN3162PPiper PA-23 · S/N 23-1094Cancelled Mar 5, 2018 · Registration expired, pending cancellation · Built 1957 · Prusiewiez MatgorzataN4858GDestiny Powered Parachutes NEON YELLOW DESTINY · S/N 1C0266Cancelled Mar 5, 2018 · Registration expired, pending cancellation · Gould James AN492FMFouga CM 170 MAGISTER · S/N 492Cancelled Mar 5, 2018 · Registration expired, pending cancellation · Built 1966 · Pima Air And Space MuseumN4523WWoods James Arthur SCORPION II · S/N 1Cancelled Mar 2, 2018 · Registration expired, pending cancellation · Carney Robert WN7135ZPiper PA-25-235 · S/N 25-2953Cancelled Mar 2, 2018 · Registration expired, pending cancellation · Built 1964 · Tucson Soaring Club IncN1731XCessna T210L · S/N 21060752Cancelled Feb 28, 2018 · Registration expired, pending cancellation · Built 1975 · Lopez JoseN715KBPiper PA-28-140 · S/N 28-26750Cancelled Feb 21, 2018 · Registration expired, pending cancellation · Built 1970 · Blume Kristopher TN574AZCGS HAWK CLASSIC · S/N HSSC-425-503-TRICancelled Feb 16, 2018 · Registration expired, pending cancellation · Built 1985 · Conger James RN555RKCessna T210L · S/N 21059997Cancelled Feb 15, 2018 · Registration expired, pending cancellation · Built 1973 · Araiza Fernando AntonioN761BPCessna T210M · S/N 21062128Cancelled Feb 15, 2018 · Sale reported, canceled · Built 1977N50228Cessna 150H · S/N 15069150Cancelled Feb 14, 2018 · Registration expired, pending cancellation · Built 1968 · Farris Scott WN96454Douglas C54D-DC · S/N 10864Cancelled Feb 12, 2018 · Registration expired, pending cancellation · Built 1942 · Maricopa Aircraft IncN24743Piper J3C-65 · S/N 3415Cancelled Feb 7, 2018 · Registration expired, pending cancellation · Built 1939 · Oliver Steven RN907ACCaudron 277 · S/N 7546/135Cancelled Jan 29, 2018 · Registration expired, pending cancellation · Portschi Dale LN8319VPiper PA-28-161 · S/N 28-8316024Cancelled Jan 26, 2018 · Registration expired, pending cancellation · Built 1982 · International Airline Training Academy IncN555HUBeech 95-A55 · S/N TC-464Cancelled Jan 25, 2018 · Registration expired, pending cancellation · Built 1963 · International Airline Training Academy IncN5076WPiper PA-28 · S/N 28-85Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Built 1961 · Adm Aero LLC
Back to Tucson, AZ