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.

N147JGCirrus Design SR20 · S/N 2177Cancelled May 13, 2013 · Exported to China · Built 2012 · Cirrus Design CorpN102NECirrus Design SR22T · S/N 0504Cancelled May 10, 2013 · Exported to Chile · Cirrus Design CorpN381ATCirrus Design SR22T · S/N 0503Cancelled May 10, 2013 · Exported to Chile · Cirrus Design CorpN62CUCirrus Design SR20 · S/N 2206Cancelled May 9, 2013 · Exported to China · Built 2013 · Cirrus Design CorpN63CUCirrus Design SR20 · S/N 2207Cancelled May 9, 2013 · Exported to China · Built 2013 · Cirrus Design CorpN65CUCirrus Design SR20 · S/N 2209Cancelled May 9, 2013 · Exported to China · Built 2013 · Cirrus Design CorpN67CUCirrus Design SR20 · S/N 2211Cancelled May 9, 2013 · Exported to China · Built 2013 · Cirrus Design CorpN68CUCirrus Design SR20 · S/N 2212Cancelled May 9, 2013 · Exported to China · Built 2013 · Cirrus Design CorpN69CUCirrus Design SR20 · S/N 2213Cancelled May 9, 2013 · Exported to China · Built 2013 · Cirrus Design CorpN736QHCessna R172K · S/N R1722701Cancelled May 7, 2013 · Registration expired, pending cancellation · Built 1977 · Carlson Raymond JN658DBeech C35 · S/N D-2926Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1951 · Foster Jeffrey AN6318UCessna U206G · S/N U20605421Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1979 · Minnesota Aircraft Sales IncN410BRCirrus Design SR22 · S/N 3924Cancelled Apr 17, 2013 · Exported to Brazil · Cirrus Design CorpN408BRCirrus Design SR22 · S/N 3922Cancelled Apr 9, 2013 · Exported to Brazil · Cirrus Design CorpN54CUCirrus Design SR20 · S/N 2200Cancelled Apr 5, 2013 · Exported to China · Built 2012 · Cirrus Design CorpN57CUCirrus Design SR20 · S/N 2201Cancelled Apr 5, 2013 · Exported to China · Built 2012 · Cirrus Design CorpN58CUCirrus Design SR20 · S/N 2202Cancelled Apr 5, 2013 · Exported to China · Built 2012 · Cirrus Design CorpN59CUCirrus Design SR20 · S/N 2203Cancelled Apr 5, 2013 · Exported to China · Built 2012 · Cirrus Design CorpN60CUCirrus Design SR20 · S/N 2204Cancelled Apr 5, 2013 · Exported to China · Built 2012 · Cirrus Design CorpN61CUCirrus Design SR20 · S/N 2205Cancelled Apr 5, 2013 · Exported to ChinaN415BRCirrus Design SR22 · S/N 3925Cancelled Apr 4, 2013 · Exported to Brazil · Cirrus Design CorpN411BRCirrus Design SR22 · S/N 3923Cancelled Mar 29, 2013 · Exported to Brazil · Cirrus Design CorpN403BRCirrus Design SR22 · S/N 3920Cancelled Mar 27, 2013 · Exported to Brazil · Cirrus Design CorpN405BRCirrus Design SR22 · S/N 3916Cancelled Mar 27, 2013 · Exported to Brazil · Cirrus Design CorpN406BRCirrus Design SR22 · S/N 3917Cancelled Mar 27, 2013 · Exported to Brazil · Cirrus Design CorpN404BRCirrus Design SR22 · S/N 3915Cancelled Mar 22, 2013 · Exported to Brazil · Cirrus Design CorpN407BRCirrus Design SR22 · S/N 3919Cancelled Mar 22, 2013 · Exported to Brazil · Cirrus Design CorpN592HSCirrus Design SR20 · S/N 2227Cancelled Mar 20, 2013 · Exported to Australia · Cirrus Design CorpN4580PPiper PA-23-250 · S/N 27-89Cancelled Mar 11, 2013 · Registration expired, pending cancellation · Built 1960 · Lake Superior CollegeN3785Beech A23 · S/N 23823Cancelled Mar 8, 2013 · Registration expired, pending cancellation · Built 1965 · Lake Superior CollegeN514CCStripling Clifford B QUICKIE · S/N 514Cancelled Feb 8, 2013 · Sale reported, canceled · Built 1988N47CUCirrus Design SR20 · S/N 2179Cancelled Dec 26, 2012 · Exported to China · Built 2012 · Cirrus Design CorpN49CUCirrus Design SR20 · S/N 2180Cancelled Dec 26, 2012 · Exported to China · Built 2012 · Cirrus Design CorpN51CUCirrus Design SR20 · S/N 2182Cancelled Dec 26, 2012 · Exported to China · Built 2012 · Cirrus Design CorpN52CUCirrus Design SR20 · S/N 2183Cancelled Dec 26, 2012 · Exported to China · Built 2012 · Cirrus Design CorpN53CUCirrus Design SR20 · S/N 2184Cancelled Dec 26, 2012 · Exported to China · Built 2012 · Cirrus Design CorpN888KSCessna A185F · S/N 18503905Cancelled Dec 18, 2012 · Registration expired, pending cancellation · Built 1979 · James Courtney 111 Law Office P AN149FRCirrus Design SR20 · S/N 2198Cancelled Dec 14, 2012 · Exported to France · Cirrus Design CorpN153FRCirrus Design SR20 · S/N 2215Cancelled Dec 14, 2012 · Exported to France · Cirrus Design CorpN891ZSCirrus Design SR22 · S/N 3891Cancelled Dec 13, 2012 · Exported to South Africa · Cirrus Design CorpN145FRCirrus Design SR22 · S/N 3884Cancelled Dec 3, 2012 · Exported to France · Cirrus Design CorpN148FRCirrus Design SR20 · S/N 2197Cancelled Dec 3, 2012 · Exported to France · Built 2012 · Cirrus Design CorpN150FRCirrus Design SR20 · S/N 2199Cancelled Dec 3, 2012 · Exported to France · Cirrus Design CorpN152FRCirrus Design SR20 · S/N 2214Cancelled Dec 3, 2012 · Exported to France · Cirrus Design CorpN890ZSCirrus Design SR22 · S/N 3890Cancelled Nov 26, 2012 · Exported to South Africa · Cirrus Design CorpN143FRCirrus Design SR22 · S/N 3881Cancelled Nov 21, 2012 · Exported to France · Cirrus Design CorpN140FRCirrus Design SR20 · S/N 2193Cancelled Nov 15, 2012 · Exported to France · Built 2012 · Cirrus Design CorpN142FRCirrus Design SR22 · S/N 3878Cancelled Nov 8, 2012 · Exported to France · Cirrus Design CorpN141FRCirrus Design SR22 · S/N 3877Cancelled Oct 31, 2012 · Exported to France · Cirrus Design CorpN147FRCirrus Design SR20 · S/N 2196Cancelled Oct 31, 2012 · Exported to France · Cirrus Design Corp
Back to Duluth, MN