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.

N1989XCirrus Design SR22T · S/N 1993Cancelled Oct 21, 2019 · Exported to Malta · Cirrus Design CorpN509GWCirrus Design SR20 · S/N 2509Cancelled Sep 25, 2019 · Exported to Guernsey · Cirrus Design CorpN318LMCirrus Design SR22T · S/N 1912Cancelled Sep 10, 2019 · Exported to Germany · Built 2019 · Cirrus Design CorpN194MDCirrus Design SR22T · S/N 1949Cancelled Aug 13, 2019 · Exported to Poland · Cirrus Design CorpN123GZCirrus Design SF50 · S/N 0120Cancelled Aug 9, 2019 · Exported to Guernsey · Cirrus Design CorpN389CDCirrus Design SR22 · S/N 1306Cancelled Aug 5, 2019 · Sale reported, canceled · Built 2005N944CZCirrus Design SR22T · S/N 1944Cancelled Jul 29, 2019 · Exported to Czech Republic · Cirrus Design CorpN246MSCirrus Design SR20 · S/N 2501Cancelled Jul 25, 2019 · Exported to Germany · Cirrus Design CorpN194JFCirrus Design SR22T · S/N 1942Cancelled Jul 16, 2019 · Exported to Mexico · Cirrus Design CorpN761CMCirrus Design SR22 · S/N 4761Cancelled Jun 5, 2019 · Exported to Australia · Built 2019 · Cirrus Design CorpN420ESCirrus Design SR22T · S/N 1915Cancelled Jun 3, 2019 · Exported to Germany · Cirrus Design CorpN39ARCirrus Design SR22T · S/N 1886Cancelled May 28, 2019 · Exported to Poland · Cirrus Design CorpN460BKCirrus Design SR22 · S/N 4602Cancelled May 24, 2019 · Exported to South Africa · Built 2018 · Cirrus Design CorpN191NBCirrus Design SR22T · S/N 1911Cancelled May 20, 2019 · Exported to France · Cirrus Design CorpN477HRCirrus Design SR22 · S/N 4772Cancelled May 10, 2019 · Exported to Zimbabwe · Cirrus Design CorpN150CACirrus Design SR22 · S/N 4751Cancelled Apr 25, 2019 · Exported to Slovenia · Cirrus Design CorpN1430Cirrus Design SR22 · S/N 4742Cancelled Apr 24, 2019 · Exported to Australia · Built 2019 · Cirrus Design CorpN222LUCirrus Design SR22 · S/N 4658Cancelled Apr 23, 2019 · Exported to China · Built 2018 · Cirrus Design CorpN846JDCirrus Design SR22T · S/N 1846Cancelled Apr 17, 2019 · Exported to Denmark · Cirrus Design CorpN763MSCirrus Design SR22 · S/N 4763Cancelled Apr 4, 2019 · Exported to Germany · Cirrus Design CorpN825EHCirrus Design SR22T · S/N 1883Cancelled Apr 4, 2019 · Exported to Germany · Cirrus Design CorpN261PCirrus Design SR22 · S/N 4580Cancelled Mar 20, 2019 · Exported to South Africa · Built 2017 · Cirrus Design CorpN5431DDJI PHANTOM 3 PROFESSION · S/N P77DCF27011416Cancelled Mar 12, 2019 · Registration expired, pending cancellation · Ohara Dennis MN6903XCessna 172B · S/N 17247803Cancelled Mar 12, 2019 · Registration expired, pending cancellation · Built 1960 · Smith David JN526MTCirrus Design SR22 · S/N 4643Cancelled Mar 5, 2019 · Exported to Japan · Built 2018 · Cirrus Design CorpN871EBCirrus Design SR22T · S/N 1871Cancelled Feb 28, 2019 · Exported to Germany · Cirrus Design CorpN203ARCirrus Design SR22 · S/N 4525Cancelled Feb 11, 2019 · Exported to South Africa · Built 2017 · Cirrus Design CorpN5431XDJI PHANTOM 3 PROFESSION · S/N P76DCD23010215Cancelled Feb 2, 2019 · Registration expired, pending cancellation · O'Hara Dennis MN837VCCirrus Design SR22T · S/N 1837Cancelled Jan 28, 2019 · Exported to Germany · Cirrus Design CorpN712KHCirrus Design SR22 · S/N 4712Cancelled Jan 24, 2019 · Exported to South Africa · Built 2018 · Cirrus Design CorpN338SYCirrus Design SR22T · S/N 1796Cancelled Jan 2, 2019 · Exported to Poland · Built 2018 · Cirrus Design CorpN794MGCirrus Design SR22T · S/N 1794Cancelled Nov 28, 2018 · Exported to Austria · Built 2018 · Cirrus Design CorpN266MLCirrus Design SR22T · S/N 1803Cancelled Nov 7, 2018 · Exported to Germany · Cirrus Design CorpN456CPCirrus Design SR22 · S/N 4682Cancelled Nov 7, 2018 · Exported to Australia · Built 2018 · Cirrus Design CorpN1801HCirrus Design SR22T · S/N 1801Cancelled Oct 23, 2018 · Exported to Czech Republic · Cirrus Design CorpN228SYCirrus Design SR22 · S/N 4651Cancelled Oct 23, 2018 · Exported to Australia · Built 2018 · Cirrus Design CorpN695JLCirrus Design SR22 · S/N 4695Cancelled Oct 4, 2018 · Exported to Argentina · Cirrus Design CorpN460SDCirrus Design SR20 · S/N 2454Cancelled Aug 29, 2018 · Exported to Germany · Cirrus Design CorpN677CZCirrus Design SR22 · S/N 4677Cancelled Aug 27, 2018 · Exported to Czech Republic · Cirrus Design CorpN32SCCirrus Design SR22 · S/N 4681Cancelled Aug 21, 2018 · Exported to Australia · Cirrus Design CorpN515MCCirrus Design SR22 · S/N 4657Cancelled Aug 13, 2018 · Exported to Poland · Cirrus Design CorpN656GHCirrus Design SR22 · S/N 4656Cancelled Aug 13, 2018 · Exported to Germany · Cirrus Design CorpN218NDCirrus Design SR22T · S/N 1688Cancelled Jul 30, 2018 · Exported to Switzerland · Built 2018 · Cirrus Design CorpN131JPCirrus Design SR20 · S/N 2450Cancelled Jul 24, 2018 · Exported to Poland · Cirrus Design CorpN247AVCirrus Design SR20 · S/N 2311Cancelled Jul 19, 2018 · Exported to China · Built 2016 · Cirrus Design CorpN251AVCirrus Design SR20 · S/N 2313Cancelled Jul 19, 2018 · Exported to China · Built 2016 · Cirrus Design CorpN280CJCirrus Jet SJX · S/N 0001Cancelled Jun 8, 2018 · Registration expired, pending cancellation · Built 2008 · Cirrus Jet CoN496DBCirrus Design SR22 · S/N 4496Cancelled Jun 5, 2018 · Exported to South Africa · Built 2017 · Cirrus Design CorpN714LDCirrus Design SR22T · S/N 1714Cancelled Jun 1, 2018 · Exported to United Kingdom · Cirrus Design CorpN732MSCirrus Design SR22T · S/N 1732Cancelled May 31, 2018 · Exported to Germany · Cirrus Design Corp
Back to Duluth, MN