Duluth, MN

Cancelled registrations · 826

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 = 'MN' AND d.registrant_city = 'DULUTH'
  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.

N318DGCirrus Design SR22T · S/N 1712Cancelled May 18, 2018 · Exported to United Kingdom · Cirrus Design CorpN113CNCirrus Design SR22 · S/N 3804Cancelled Apr 24, 2018 · Registration expired, pending cancellation · Built 2011 · Cirrus Design CorpN625DPCirrus Design SR22 · S/N 4625Cancelled Apr 24, 2018 · Exported to Czech Republic · Cirrus Design CorpN887SYCirrus Design SR20 · S/N 2331Cancelled Apr 13, 2018 · Exported to China · Built 2016 · Cirrus Design CorpN890SYCirrus Design SR20 · S/N 2335Cancelled Apr 13, 2018 · Exported to China · Built 2016 · Cirrus Design CorpN891SYCirrus Design SR20 · S/N 2336Cancelled Apr 13, 2018 · Exported to China · Built 2016 · Cirrus Design CorpN6552QAlon A2 · S/N A52Cancelled Apr 6, 2018 · Revoked, canceled · Built 1965 · Campers RentalsN653CStinson 108-3 · S/N 108-3653Cancelled Mar 28, 2018 · Registration expired, pending cancellation · Built 1947 · Guptill Gary LN155AWCirrus Design SR22 · S/N 4604Cancelled Mar 21, 2018 · Exported to Norway · Cirrus Design CorpN802DKCirrus Design SR22 · S/N 4046Cancelled Mar 20, 2018 · Registration expired, pending cancellation · Built 2014 · Cirrus Design CorpN680RFCirrus Design SR22T · S/N 1680Cancelled Mar 19, 2018 · Exported to United Kingdom · Cirrus Design CorpN165CSCirrus Design SR22T · S/N 1657Cancelled Mar 13, 2018 · Exported to Australia · Cirrus Design CorpN200SRCirrus Design SR20 · S/N 001Cancelled Mar 12, 2018 · Registration expired, pending cancellation · Built 1981 · Cirrus Design CorpN204CDCirrus Design SR20 · S/N 004Cancelled Mar 12, 2018 · Registration expired, pending cancellation · Built 1998 · Cirrus Design CorporationN6113PJ&J Ultralights/Mattakat DJ TUKAN · S/N 00470744408Cancelled Feb 15, 2018 · Registration expired, pending cancellation · Mattakat Daniel JN266CDCirrus Design SR22 · S/N 0435Cancelled Feb 12, 2018 · Registration expired, pending cancellation · Built 2002 · Cirrus Design CorpN173MBHeldegerg Designs BLUE HURON MARATHON · S/N HD03094MCancelled Feb 9, 2018 · Registration expired, pending cancellation · Built 2003 · Hanson Jay RN202CDCirrus Design SR20 · S/N 002Cancelled Feb 9, 2018 · Registration expired, pending cancellation · Built 1995 · Cirrus Design CorpN336AVCirrus Design SR22 · S/N 4336Cancelled Feb 6, 2018 · Exported to China · Built 2016 · Cirrus Design CorpN249AVCirrus Design SR20 · S/N 2312Cancelled Jan 5, 2018 · Exported to China · Built 2016 · Cirrus Design CorpN112TACirrus Design SR20 · S/N 2376Cancelled Jan 4, 2018 · Exported to Italy · Cirrus Design CorpN423RAKundel Donald W VANS RV 7A · S/N 71227Cancelled Jan 4, 2018 · Registration expired, pending cancellation · Built 2010 · Kundel Donald WN538GTCirrus Design SR22 · S/N 4538Cancelled Dec 28, 2017 · Exported to Brazil · Built 2017 · Cirrus Design CorpN503RSCirrus Design SR22T · S/N 1573Cancelled Dec 20, 2017 · Exported to Czech Republic · Built 2017 · Cirrus Design CorpN886SYCirrus Design SR20 · S/N 2329Cancelled Dec 4, 2017 · Exported to China · Built 2016 · Cirrus Design CorpN108CACirrus Design SR22T · S/N 1614Cancelled Nov 3, 2017 · Exported to Chile · Cirrus Design CorpN132CRCirrus Design SR22 · S/N 4502Cancelled Oct 13, 2017 · Exported to Zimbabwe · Built 2017 · Cirrus Design CorpN146CHCirrus Design SR22 · S/N 4515Cancelled Oct 10, 2017 · Exported to Switzerland · Cirrus Design CorpN147CHCirrus Design SR22 · S/N 4516Cancelled Oct 10, 2017 · Exported to Switzerland · Cirrus Design CorpN54GGCirrus Design SR20 · S/N 2342Cancelled Aug 11, 2017 · Exported to Australia · Built 2017 · Cirrus Design CorpN498CZCirrus Design SR22 · S/N 4498Cancelled Jul 31, 2017 · Exported to Czech Republic · Cirrus Design CorpN561PLCirrus Design SR22T · S/N 1561Cancelled Jul 27, 2017 · Exported to Germany · Cirrus Design CorpN999UBCirrus Design SR22T · S/N 1563Cancelled Jul 25, 2017 · Exported to Germany · Cirrus Design CorpN558AWCirrus Design SR22T · S/N 1558Cancelled Jul 24, 2017 · Exported to South Africa · Cirrus Design CorpN477EUCirrus Design SR22T · S/N 1477Cancelled Jul 14, 2017 · Exported to Czech Republic · Built 2017 · Cirrus Design CorpN986EKCirrus Design SR22 · S/N 4463Cancelled Jul 11, 2017 · Exported to United Arab Emirates · Built 2017 · Cirrus Design CorpN988EKCirrus Design SR22 · S/N 4464Cancelled Jul 11, 2017 · Exported to United Arab Emirates · Built 2017 · Cirrus Design CorpN400BRCirrus Design SR22 · S/N 4443Cancelled Jul 10, 2017 · Exported to Brazil · Built 2017 · Cirrus Design CorpN86905Lockheed T-33 · S/N 52-9622Cancelled Jul 7, 2017 · Registration expired, pending cancellation · Built 1952 · Lake Superior CollegeN538ABCirrus Design SR22T · S/N 1538Cancelled May 19, 2017 · Exported to Poland · Cirrus Design CorpN145DMRobinson Helicopter R44 II · S/N 11004Cancelled May 15, 2017 · Registration expired, pending cancellation · Built 2005 · Jauss Aviation IncN152PGCirrus Design SR22T · S/N 1523Cancelled May 4, 2017 · Exported to Poland · Cirrus Design CorpN245AVCirrus Design SR20 · S/N 2310Cancelled Mar 31, 2017 · Exported to China · Built 2016 · Cirrus Design CorpN880SYCirrus Design SR20 · S/N 2288Cancelled Feb 17, 2017 · Exported to China · Built 2015 · Cirrus Design CorpN883SYCirrus Design SR20 · S/N 2290Cancelled Feb 17, 2017 · Exported to China · Built 2015 · Cirrus Design CorpN452MBCirrus Design SR22T · S/N 1452Cancelled Nov 28, 2016 · Exported to Czech Republic · Cirrus Design CorpN402PPCirrus Design SR22T · S/N 1402Cancelled Nov 15, 2016 · Exported to Hungary · Built 2016 · Cirrus Design CorpN844ZKCirrus Design SR22T · S/N 1417Cancelled Oct 21, 2016 · Exported to Czech Republic · Built 2016 · Cirrus Design CorpN184SPCirrus Design SR22T · S/N 1448Cancelled Oct 19, 2016 · Exported to Sweden · Cirrus Design CorpN348DTCirrus Design SR22 · S/N 4348Cancelled Oct 4, 2016 · Exported to South Africa · Built 2016 · Cirrus Design Corp
Back to Duluth, MN