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.

N218LLCirrus Design SR22 · S/N 4380Cancelled Sep 23, 2016 · Exported to France · Cirrus Design CorpN388FACirrus Design SR22T · S/N 1388Cancelled Aug 24, 2016 · Exported to Chile · Cirrus Design CorpN788DRCirrus Design SR22T · S/N 1386Cancelled Jul 18, 2016 · Exported to United Kingdom · Cirrus Design CorpN326JSCirrus Design SR20 · S/N 2314Cancelled Apr 29, 2016 · Exported to South Africa · Built 2016 · Cirrus Design CorpN141MBCirrus Design SR22T · S/N 1262Cancelled Mar 9, 2016 · Exported to Germany · Cirrus Design CorpN143AFCirrus Design SR22T · S/N 1256Cancelled Feb 25, 2016 · Exported to Germany · Cirrus Design CorpN304FACirrus Design SR22 · S/N 4304Cancelled Feb 22, 2016 · Exported to France · Cirrus Design CorpN308FACirrus Design SR22 · S/N 4305Cancelled Feb 22, 2016 · Exported to France · Cirrus Design CorpN246GRCirrus Design SR22T · S/N 1246Cancelled Feb 19, 2016 · Exported to Luxembourg · Cirrus Design CorpN610BGCirrus Design SR22T · S/N 0518Cancelled Dec 9, 2015 · First renewal notice · Built 2013 · Cirrus Design CorpN426CZCirrus Design SR22 · S/N 4269Cancelled Nov 30, 2015 · Exported to Czech Republic · Cirrus Design CorpN229KTCirrus Design SR20 · S/N 2299Cancelled Nov 9, 2015 · Exported to South Korea · Cirrus Design CorpN7YTCirrus Design SR22 · S/N 4219Cancelled Nov 9, 2015 · Exported to Australia · Built 2015 · Cirrus Design CorpN9AHCirrus Design SR22T · S/N 1062Cancelled Oct 19, 2015 · Exported to France · Built 2015 · Cirrus Design CorpN244CYCirrus Design SR22 · S/N 4244Cancelled Sep 22, 2015 · Exported to United Kingdom · Cirrus Design CorpN318GMCirrus Design SR22T · S/N 1107Cancelled Sep 1, 2015 · Exported to Chile · Cirrus Design CorpN343GMCirrus Design SR22T · S/N 1108Cancelled Sep 1, 2015 · Exported to Chile · Cirrus Design CorpN423FACirrus Design SR22 · S/N 4235Cancelled Jul 31, 2015 · Exported to France · Cirrus Design CorpN247TQCirrus Design SR22 · S/N 4223Cancelled Jul 10, 2015 · Exported to Guatemala · Cirrus Design CorpN170TNCirrus Design SR22T · S/N 1070Cancelled Jul 6, 2015 · Exported to Channel Islands · Cirrus Design CorpN108LRCirrus Design SR22T · S/N 1069Cancelled Jul 1, 2015 · Exported to Germany · Cirrus Design CorpN9ZNCirrus Design SR22 · S/N 4177Cancelled Jun 24, 2015 · Exported to Australia · Built 2015 · Cirrus Design CorpN268JPCirrus Design SR20 · S/N 2268Cancelled Jun 23, 2015 · Exported to Japan · Built 2014 · Cirrus Design CorpN441PSCirrus Design SR22T · S/N 1044Cancelled May 19, 2015 · Exported to Czech Republic · Cirrus Design CorpN126JKCirrus Design SR22T · S/N 1033Cancelled May 15, 2015 · Exported to Switzerland · Cirrus Design CorpN3116JCessna 150G · S/N 15065816Cancelled May 5, 2015 · Registration expired, pending cancellation · Built 1966 · Ziegelmann Vernis E JrN324JMCirrus Design SR22 · S/N 3826Cancelled Apr 7, 2015 · Exported to China · Built 2012 · Cirrus Design CorpN322TGCirrus Design SR22T · S/N 0978Cancelled Mar 13, 2015 · Exported to Brazil · Built 2015 · Cirrus Design CorpN993PBCirrus Design SR22T · S/N 0993Cancelled Feb 27, 2015 · Exported to Czech Republic · Cirrus Design CorpN7YTCirrus Design SR22 · S/N 4164Cancelled Feb 25, 2015 · Cirrus Design CorpN936ESCirrus Design SR22T · S/N 0936Cancelled Feb 24, 2015 · Exported to Austria · Built 2014 · Cirrus Design CorpN719SDCirrus Design SR22T · S/N 0968Cancelled Feb 23, 2015 · Exported to Poland · Cirrus Design CorpN837EUCirrus Design SR22T · S/N 0837Cancelled Jan 27, 2015 · Exported to Germany · Built 2014 · Cirrus Design CorpN45KEMarino Mark RANS S-6S · S/N 06061749Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Built 2007 · Emberg KermitN3225XShaw Harold A EIPPER MX II · S/N 1055Cancelled Dec 2, 2014 · Registration expired, pending cancellation · Shaw Harold AN661RACirrus Design SR22 · S/N 4062Cancelled Nov 26, 2014 · Exported to Australia · Built 2014 · Cirrus Design CorpN56808Piper PA-28-140 · S/N 28-7425040Cancelled Oct 29, 2014 · Registration expired, pending cancellation · Built 1973 · Gee Loretta C DBAN117ZSCirrus Design SR22 · S/N 4117Cancelled Oct 20, 2014 · Exported to South Africa · Cirrus Design CorpN118PWCirrus Design SR22 · S/N 4135Cancelled Oct 20, 2014 · Exported to United Kingdom · Cirrus Design CorpN825SLCirrus Design SR22T · S/N 0825Cancelled Oct 7, 2014 · Exported to Slovenia · Built 2014 · Cirrus Design CorpN318DKCirrus Design SR22 · S/N 4107Cancelled Oct 1, 2014 · Exported to South Africa · Built 2014 · Cirrus Design CorpN1881TCirrus Design SR22T · S/N 0867Cancelled Sep 12, 2014 · Exported to Poland · Cirrus Design CorpN502HJCirrus Design SR20 · S/N 2269Cancelled Sep 8, 2014 · Exported to Germany · Cirrus Design CorpN107LLCirrus Design SR22T · S/N 0808Cancelled Sep 3, 2014 · Exported to South Africa · Cirrus Design CorpN139DWCirrus Design SR20 · S/N 2259Cancelled Sep 2, 2014 · Exported to South Africa · Built 2014 · Cirrus Design CorpN267KTCirrus Design SR20 · S/N 2267Cancelled Aug 29, 2014 · Exported to South Korea · Cirrus Design CorpN265KTCirrus Design SR20 · S/N 2265Cancelled Aug 27, 2014 · Exported to South Korea · Cirrus Design CorpN59BSCirrus Design SR22T · S/N 0804Cancelled Jun 25, 2014 · Exported to Germany · Cirrus Design CorpN2823KCessna 180K · S/N 18053090Cancelled Jun 5, 2014 · Exported to Canada · Northern Minnesota Aero Marine IncN760CZCirrus Design SR22T · S/N 0765Cancelled May 19, 2014 · Exported to Czech Republic · Cirrus Design Corp
Back to Duluth, MN