Menominee, MI

Cancelled registrations · 124

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 = 'MI' AND d.registrant_city = 'MENOMINEE'
  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.

N827NEEnstrom 280FX · S/N 2148Cancelled Feb 12, 2018 · Exported to Pakistan · Built 2017 · Enstrom Helicopter CorporationN827PEEnstrom 280FX · S/N 2149Cancelled Feb 12, 2018 · Exported to Pakistan · Enstrom Helicopter CorporationN526HEnstrom F-28A · S/N 329Cancelled Jun 28, 2016 · Exported to Japan · Built 1976 · Enstrom Helicopter CorporationN180THEnstrom Helicopter TH-180 · S/N 10001Cancelled May 2, 2016 · Built 2015 · Enstrom Helicopter CorpN547BEEnstrom 280FX · S/N 2144Cancelled Oct 23, 2015 · Exported to Peru · Built 2015 · Enstrom Helicopter CorporationN547DCEnstrom 280FX · S/N 2145Cancelled Oct 23, 2015 · Exported to Peru · Enstrom Helicopter CorporationN520UEEnstrom Helicopter 480B · S/N 5198Cancelled Jul 31, 2015 · Exported to Venezuela · Built 2014 · Enstrom Helicopter CorporationN524YEEnstrom Helicopter 480B · S/N 5210Cancelled Jul 31, 2015 · Exported to Venezuela · Built 2014 · Enstrom Helicopter CorporationN525YEEnstrom Helicopter 480B · S/N 5208Cancelled Jul 31, 2015 · Exported to Venezuela · Built 2014 · Enstrom Helicopter CorporationN525ZCEnstrom Helicopter 480B · S/N 5209Cancelled Jul 31, 2015 · Exported to Venezuela · Built 2014 · Enstrom Helicopter CorporationN140JPEnstrom Helicopter 480B · S/N 5194Cancelled Jul 9, 2015 · Exported to Japan · Built 2014 · Enstrom Helicopter CorporationN156JPEnstrom Helicopter 480B · S/N 5200Cancelled Jul 8, 2015 · Exported to Japan · Built 2014 · Enstrom Helicopter CorporationN163JPEnstrom Helicopter 480B · S/N 5202Cancelled Jul 8, 2015 · Exported to Japan · Built 2014 · Enstrom Helicopter CorporationN165JPEnstrom Helicopter 480B · S/N 5203Cancelled Jul 8, 2015 · Exported to Japan · Built 2014 · Enstrom Helicopter CorporationN167JPEnstrom Helicopter 480B · S/N 5206Cancelled Jul 8, 2015 · Exported to Japan · Built 2014 · Enstrom Helicopter CorporationN490RNEnstrom Helicopter 480B · S/N 5175Cancelled Jul 8, 2015 · Exported to Japan · Built 2013 · Enstrom Helicopter CorporationN490SEEnstrom Helicopter 480B · S/N 5176Cancelled Jul 8, 2015 · Exported to Japan · Built 2013 · Enstrom Helicopter CorporationN490XNEnstrom Helicopter 480B · S/N 5179Cancelled Jul 8, 2015 · Exported to Japan · Enstrom Helicopter CorporationN490YDEnstrom Helicopter 480B · S/N 5180Cancelled Jul 8, 2015 · Exported to Japan · Built 2013 · Enstrom Helicopter CorporationN490ZEEnstrom Helicopter 480B · S/N 5181Cancelled Jul 8, 2015 · Exported to Japan · Built 2013 · Enstrom Helicopter CorporationN135JPEnstrom Helicopter 480B · S/N 5193Cancelled Jun 22, 2015 · Exported to Japan · Built 2014 · Enstrom Helicopter CorporationN148JPEnstrom Helicopter 480B · S/N 5196Cancelled Jun 22, 2015 · Exported to Japan · Built 2014 · Enstrom Helicopter CorporationN159JPEnstrom Helicopter 480B · S/N 5201Cancelled Jun 22, 2015 · Exported to Japan · Built 2014 · Enstrom Helicopter CorporationN170JPEnstrom Helicopter 480B · S/N 5195Cancelled Jun 22, 2015 · Exported to Japan · Built 2014 · Enstrom Helicopter CorporationN490UEEnstrom Helicopter 480B · S/N 5177Cancelled Jun 22, 2015 · Exported to Japan · Built 2013 · Enstrom Helicopter CorporationN491BEEnstrom Helicopter 480B · S/N 5182Cancelled Jun 22, 2015 · Exported to Japan · Built 2013 · Enstrom Helicopter CorporationN208RJEnstrom Helicopter 480B · S/N 5183Cancelled Dec 31, 2013 · Exported to China · Enstrom Helicopter CorporationN490QEEnstrom Helicopter 480B · S/N 5173Cancelled Aug 9, 2013 · Exported to Japan · Built 2013 · Enstrom Helicopter CorporationN490TEEnstrom Helicopter 480B · S/N 5174Cancelled Jul 26, 2013 · Exported to Japan · Enstrom Helicopter CorporationN62035Hunold Edward A CHALLENGER II · S/N 1343Cancelled Jul 11, 2012 · Registration expired · Built 1995 · Estebo Richard LN5699TEnstrom F-28C · S/N 496-2Cancelled Sep 14, 2005 · Built 1980 · Enstrom Helicopter CorpN86170Enstrom F-28F · S/N 1502Cancelled Sep 14, 2005 · Enstrom Helicopter CorpN8627XEnstrom Helicopter 480B · S/N 5081Cancelled Sep 13, 2005 · Exported to South Korea · Enstrom Helicopter CorpN695PEEnstrom 280FX · S/N 2115Cancelled Sep 12, 2005 · Exported to Georgia · Enstrom HelicopterN8631AEnstrom Helicopter 480 · S/N 5004Cancelled Aug 22, 2005 · Exported to Germany · Built 1994 · Enstrom Helicopter CorpN480PDEnstrom Helicopter 480B · S/N 5078Cancelled Mar 1, 2005 · Exported to South Africa · Enstrom Helicopter CorpN280FEnstrom Helicopter 480B · S/N 5058Cancelled Dec 16, 2003 · Enstrom Helicopter CorpN480FSEnstrom Helicopter 480B · S/N 5050Cancelled Feb 5, 2003 · Exported to Russia · Enstrom Helicopter CorporationN8629EEnstrom Helicopter 480 · S/N 5033Cancelled Oct 18, 2002 · Exported to Russia · Built 1998 · Enstrom Helicopter CorpN480ENEnstrom Helicopter 480 · S/N 5043Cancelled Aug 20, 2001 · Exported to Mexico · Enstrom Helicopter CorpN4466Enstrom F-28A · S/N 018Cancelled Mar 12, 1999 · Triennial form not returned · R J Enstrom CorpN28FREnstrom Helicopter TH-28 · S/N 3005Cancelled Jan 21, 1999 · Triennial form not returned · Enstrom Helicopter CorporationN8629AEnstrom Helicopter 480 · S/N 5023Cancelled Feb 18, 1998 · Enstrom Helicopter CorporationN8627QEnstrom 280FX · S/N 2021Cancelled Jan 6, 1998 · Exported to United Kingdom · Enstrom Helicopter CorpN40043Enstrom F-28 · S/N 003Cancelled Oct 9, 1997 · Triennial form not returned · Enstrom Corp R JN28WEEnstrom Helicopter TH-28 · S/N 3006Cancelled May 27, 1997 · Exported to China · Enstrom Helicopter CorporationN8631EEnstrom Helicopter TH-28 · S/N 3003Cancelled Apr 6, 1994 · Enstrom Helicopter CorpN4464Enstrom F-28C · S/N 016Cancelled Mar 22, 1994 · Exported to Slovenia · Enstrom Helicopter CorpN86246Enstrom 280FX · S/N 2062Cancelled Mar 22, 1994 · Exported to China · Enstrom Helicopter CorpN8625AEnstrom F-28F · S/N 759Cancelled Jun 17, 1991 · Exported to Italy · Enstrom Helicopter Corp
Back to Menominee, MI