Eden Prairie, MN

Cancelled registrations · 78

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 = 'EDEN PRAIRIE'
  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.

N2193WBeech B19 · S/N MB-699Cancelled Apr 11, 2003 · Second triennial mailing, no response · Built 1974 · Flying Cloud Avn Of Eden Prairie IncN23644Cessna T206H · S/N T20608143Cancelled Apr 1, 2003 · Exported to Canada · Built 1999 · Modern Aero Inc DBAN310DECessna 310N · S/N 310N-0182Cancelled Jan 27, 2003 · Triennial form not returned · Built 1968 · Windsor Aviation IncN7185CRobinson Helicopter R22 BETA · S/N 3033Cancelled Jun 26, 2002 · Exported to Australia · Built 2000 · Rw Systems IncN621KEBeech G18S · S/N BA-556Cancelled May 23, 2002 · Triennial form not returned · Built 1960 · Beech TransportationN100BEBeech A100 · S/N B221Cancelled Nov 5, 1998 · Beech Transportation IncN221BPScaled Composites 158-8 · S/N 001Cancelled Jul 9, 1998 · Triennial form not returned · Bob Pond Racing IncN900TTBeech A36 · S/N E2347Cancelled Dec 11, 1997 · Exported to Germany · Modern Aero IncN8628AEnstrom 280FX · S/N 2069Cancelled Jan 16, 1996 · Exported to Mexico · Beech Transportation Inc DBAN47GXBell 47G-2 · S/N 50Cancelled Mar 22, 1995 · Exported to Costa RicaN3045YPiper PA-34-200T · S/N 347970194Cancelled Mar 16, 1995 · Exported to Mexico · Modern Aero Inc DBAN4060ZBalloon Works FIREFLY 7 · S/N 7979Cancelled Jan 15, 1993 · Starkey Laboratories IncN5172MBeech C23 · S/N M2046Cancelled Sep 15, 1992 · Triennial form not returned · General Aviation Services IncN5174WPiper PA-28-160 · S/N 28205Cancelled Aug 20, 1992 · General Aviation Services IncN67338Cessna 152 · S/N 15281766Cancelled Jun 3, 1991 · Triennial form not returned · Asi Aero Services IncN6472SCessna 150H · S/N 15067272Cancelled Feb 25, 1986 · Peterson Marlin M DBA Marlin Peterson & AssociatesN6957RBeech B19 · S/N MB-747Cancelled Sep 29, 1983 · C & R Aircraft Sales IncN6973RBeech B19 · S/N MB-750Cancelled Sep 29, 1983 · Built 1974 · G R Aircraft Sales IncN101CUBeech 95-C55 · S/N TE-22Cancelled Apr 15, 1982 · Administratively canceled · G & R Aircraft Sales IncN1480GBeech P35 · S/N D-6927Cancelled Feb 13, 1976 · G & R Aviation IncN8244CPiper PA-28R-200 · S/N 28R-7635138Cancelled Feb 9, 1976 · Exported to Canada · Thunderbird Aviation IncN88296Bellanca 7KCAB · S/N 478-74Cancelled Aug 28, 1975 · Exported to Canada · G & R Aviation IncN5834SBeech S35 · S/N D7733Cancelled Jul 12, 1974 · Mid Continent Airways IncN182TCCessna 182P · S/N 18261027Cancelled May 29, 1973 · Flight Training Center IncN6525GCessna 150L · S/N 15072025Cancelled May 25, 1973 · Exported to Canada · Flight Training Cloud DriveN23285Cessna 150H · S/N 15068849Cancelled May 24, 1973 · Exported to Canada · Flight Training Center IncN4566FCessna 185 · S/N 185-1073Cancelled Dec 19, 1968 · Exported to Canada · Built 1966 · Executive Aero IncN5125UCessna 206 · S/N 2060125Cancelled May 23, 1968 · Exported to Canada · Executive Aero Inc
Back to Eden Prairie, MN