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.

N804WMDJI PHANTOM 3 PROFESSION · S/N P77DCJ15010744Cancelled Feb 28, 2020 · Registration expired, pending cancellation · Flashcalc Digital Solutions LLCN6533XCessna 210 · S/N 57533Cancelled Feb 3, 2020 · Registration expired, pending cancellation · Built 1960 · Allen LanN9635TCessna 210 · S/N 57435Cancelled Feb 3, 2020 · Registration expired, pending cancellation · Built 1960 · Allen LanN857PPilatus P3-05 · S/N 495-44Cancelled Jan 6, 2020 · Registration expired, pending cancellation · Built 1959 · Downs Roland JN78175Globe GC-1B · S/N 2175Cancelled Dec 20, 2019 · Sale reported, canceled · Built 1946N4224WGeneral Motors FM-2 · S/N 16161Cancelled Dec 16, 2019 · Sale reported, canceledN780LWWorld Tech Toys PANTHER SPY · S/N 13023-02879Cancelled Dec 2, 2019 · Registration expired, pending cancellation · Williford James T SrN1116FCessna 172G · S/N 17254711Cancelled Oct 18, 2019 · Revoked, canceled · Built 1966 · Arizona Aircraft Rental IncN645KKDJI PHANTOM 3 PROFESSION · S/N 8016256Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Schiff KimberlyN23811Air Tractor AT-301 · S/N 301-0432Cancelled Oct 4, 2019 · Sale reported, canceled · Built 1982N48557Fairchild M-62A · S/N T41664Cancelled Sep 16, 2019 · Revoked, pending cancellation · Built 1941 · Hess Emory LN104FNGecko Air PANDORA · S/N FN-1Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Gecko Air LLCN5221VCessna 210L · S/N 21060865Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Mathews RobertN716XMDJI INSPIRE 1 · S/N W13DCK04050653Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Harvest Media MinistryN7186FCessna 150F · S/N 15063786Cancelled Sep 6, 2019 · Registration pending, canceled · Built 1966N824LGCanadair CF-5D · S/N 2024Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Fast Jets LLCN841LGCanadair CF-5D · S/N 2041Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Fast Jets LLCN85872Aeronca 11AC · S/N 11AC-297Cancelled Sep 6, 2019 · Revoked, canceled · Built 1946 · Southard Bob JN96572Taylorcraft BF · S/N 8872Cancelled Sep 6, 2019 · Revoked, canceled · Built 1946 · Stevens Charles EN133ABEnstrom 280 · S/N 1019Cancelled May 4, 2019 · Registration expired, pending cancellation · Koch Kenneth CN8115XCessna 172B · S/N 17248615Cancelled May 4, 2019 · Registration expired, pending cancellation · Tuohy Maureen EN5463MPrecision Drone PACESETTER · S/N DB000213Cancelled Apr 25, 2019 · Registration expired, pending cancellation · High Desert Agricultural Consulting LLCN477QBoeing B75N1 · S/N 75-1359Cancelled Apr 23, 2019 · Registration expired, pending cancellation · Built 1941 · Abrams Gary LN47982Piper PA-28-181 · S/N 28-7890165Cancelled Mar 29, 2019 · Built 1977 · Adil JunaidN31KLSukhoi SU-31 · S/N 05-02Cancelled Mar 20, 2019 · Exported to Lithuania · Built 2000 · Shepley Paul E JrN39032Luscombe 8A · S/N 1793Cancelled Mar 19, 2019 · Revoked, canceled · Built 1941 · Warren MartinN623GKDJI PHANTOM 3 ADVANCED · S/N P79DCG07020280Cancelled Mar 13, 2019 · Registration expired, pending cancellation · Dukes KentN73095Cessna 140 · S/N 10315Cancelled Mar 13, 2019 · Exported to Bolivia · Built 1946 · Villar Philip MN4594WRockwell International 112TC · S/N 13084Cancelled Mar 12, 2019 · Sale reported · Built 1976N666SNDJI INSPIRE 1 · S/N 0410077557Cancelled Mar 12, 2019 · Registration expired, pending cancellation · Tuohy AndrewN5661DDJI PHANTOM 3 PROFESSION · S/N P76DCD22010269Cancelled Mar 9, 2019 · Registration expired, pending cancellation · Dungey Kenneth NN520DVDJI PHANTOM 3 PROFESSION · S/N P76DCE18016665Cancelled Mar 4, 2019 · Registration expired, pending cancellation · Cundiff George M JrN78478Piper PA-12 · S/N 12-1989Cancelled Feb 19, 2019 · Revoked, canceled · Built 1947 · Pima Flyers IncN357AZSensefly EBEE · S/N EB-03-882Cancelled Feb 7, 2019 · Sale reported, canceledN8612TRdsh SPARROHAWK · S/N SH20040009KCancelled Feb 7, 2019 · Sale reported, canceled · Built 2004N6002QMooney M20E · S/N 860Cancelled Feb 5, 2019 · Second renewal notice · Built 1965 · Hoffman Westly James TrusteeN7079YPiper PA-30 · S/N 30-93Cancelled Jan 28, 2019 · Registration expired, pending cancellation · Built 1963 · Brekhus HartmanN588EPPrioria Robotics MAVERIC · S/N MV100-100202Cancelled Jan 15, 2019 · Registration expired, pending cancellation · Freeport Mcmoran IncN588FPPrioria Robotics MAVERIC · S/N MV100-100200Cancelled Jan 15, 2019 · Registration expired, pending cancellation · Freeport Mcmoran IncN588GPPrioria Robotics MAVERIC · S/N MV100-100201Cancelled Jan 15, 2019 · Registration expired, pending cancellation · Freeport - Mcmoran IncN563YMDJI INSPIRE 1 · S/N W13DCA12020709Cancelled Jan 7, 2019 · Registration expired, pending cancellation · Martz Dennis AndrewN65059Cameron Balloons US A-180 · S/N 6624Cancelled Dec 6, 2018 · Built 2011 · Wilbur Kevin MN7533WSensefly SWINGLET CAM · S/N SC-07-272Cancelled Oct 29, 2018 · Desert Archaeology IncN703SBoeing 737-2T4 · S/N 22529Cancelled Sep 25, 2018 · Exported to Canada · Built 1981 · Sierra Pacific Airlines IncN228AV3D Robotics SOLO · S/N S111A5702901Cancelled Sep 24, 2018 · First renewal notice · Auv LLC DBAN229AVDJI INSPIRE 1 · S/N W21ACI16011070Cancelled Sep 24, 2018 · First renewal notice · Auv LLC DBAN132AZUniversity Of Arizona AMT 200S · S/N A322215Cancelled Sep 13, 2018 · Registration expired, pending cancellation · University Of ArizonaN133AZUniversity Of Arizona AMT 200S · S/N A322216Cancelled Sep 13, 2018 · Registration expired, pending cancellation · University Of ArizonaN35084Quicksilver MX-2 · S/N 1133Cancelled Sep 13, 2018 · Registration expired, pending cancellation · Built 1988 · Skovan BethanyN342PHPiper PA-34-200 · S/N 34-7350114Cancelled Aug 10, 2018 · Registration expired, pending cancellation · Built 1973 · Lemas Contreras Manuel
Back to Tucson, AZ