Skip to content

Enstrom Helicopter Corporation

Earlier aircraft under this name · 44

Cancelled registrations that named this owner when they ended, newest first.

Query with SQL

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_name = 'ENSTROM HELICOPTER CORPORATION' OR list_contains(d.other_registrant_names, 'ENSTROM HELICOPTER CORPORATION') ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

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_name = 'ENSTROM HELICOPTER CORPORATION' OR list_contains(d.other_registrant_names, 'ENSTROM HELICOPTER CORPORATION')
  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.

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_name = 'ENSTROM HELICOPTER CORPORATION' OR list_contains(d.other_registrant_names, 'ENSTROM HELICOPTER CORPORATION')
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N832ADEnstrom Helicopter 480B · S/N 5242Cancelled Aug 16, 2018 · Exported to Czech Republic · Built 2018 · Menominee, MI N832CZEnstrom Helicopter 480B · S/N 5243Cancelled Aug 16, 2018 · Exported to Czech Republic · Built 2018 · Menominee, MI N829GYEnstrom Helicopter 480B · S/N 5240Cancelled Jun 13, 2018 · Exported to Czech Republic · Built 2018 · Menominee, MI N829JKEnstrom Helicopter 480B · S/N 5241Cancelled Jun 13, 2018 · Exported to Czech Republic · Built 2018 · Menominee, MI N841GHEnstrom Helicopter 280FX · S/N 2152Cancelled May 23, 2018 · Exported to Pakistan · Built 2018 · Menominee, MI N842YEEnstrom Helicopter 280FX · S/N 2156Cancelled May 23, 2018 · Exported to Pakistan · Menominee, MI N841HXEnstrom Helicopter 280FX · S/N 2153Cancelled May 21, 2018 · Exported to Pakistan · Built 2018 · Menominee, MI N842UMEnstrom Helicopter 280FX · S/N 2154Cancelled May 21, 2018 · Exported to Pakistan · Menominee, MI N842VEEnstrom Helicopter 280FX · S/N 2155Cancelled May 21, 2018 · Exported to Pakistan · Menominee, MI N5696EEnstrom 280L · S/N 2001Cancelled Mar 14, 2018 · Built 1978 · Menominee, MI N829QHEnstrom 280FX · S/N 2151Cancelled Feb 15, 2018 · Exported to Pakistan · Built 2017 · Menominee, MI N829TWEnstrom 280FX · S/N 2150Cancelled Feb 15, 2018 · Exported to Pakistan · Built 2018 · Menominee, MI N827NEEnstrom 280FX · S/N 2148Cancelled Feb 12, 2018 · Exported to Pakistan · Built 2017 · Menominee, MI N827PEEnstrom 280FX · S/N 2149Cancelled Feb 12, 2018 · Exported to Pakistan · Menominee, MI N526HEnstrom F-28A · S/N 329Cancelled Jun 28, 2016 · Exported to Japan · Built 1976 · Menominee, MI N547BEEnstrom 280FX · S/N 2144Cancelled Oct 23, 2015 · Exported to Peru · Built 2015 · Menominee, MI N547DCEnstrom 280FX · S/N 2145Cancelled Oct 23, 2015 · Exported to Peru · Menominee, MI N520UEEnstrom Helicopter 480B · S/N 5198Cancelled Jul 31, 2015 · Exported to Venezuela · Built 2014 · Menominee, MI N524YEEnstrom Helicopter 480B · S/N 5210Cancelled Jul 31, 2015 · Exported to Venezuela · Built 2014 · Menominee, MI N525YEEnstrom Helicopter 480B · S/N 5208Cancelled Jul 31, 2015 · Exported to Venezuela · Built 2014 · Menominee, MI N525ZCEnstrom Helicopter 480B · S/N 5209Cancelled Jul 31, 2015 · Exported to Venezuela · Built 2014 · Menominee, MI N140JPEnstrom Helicopter 480B · S/N 5194Cancelled Jul 9, 2015 · Exported to Japan · Built 2014 · Menominee, MI N156JPEnstrom Helicopter 480B · S/N 5200Cancelled Jul 8, 2015 · Exported to Japan · Built 2014 · Menominee, MI N163JPEnstrom Helicopter 480B · S/N 5202Cancelled Jul 8, 2015 · Exported to Japan · Built 2014 · Menominee, MI N165JPEnstrom Helicopter 480B · S/N 5203Cancelled Jul 8, 2015 · Exported to Japan · Built 2014 · Menominee, MI N167JPEnstrom Helicopter 480B · S/N 5206Cancelled Jul 8, 2015 · Exported to Japan · Built 2014 · Menominee, MI N490RNEnstrom Helicopter 480B · S/N 5175Cancelled Jul 8, 2015 · Exported to Japan · Built 2013 · Menominee, MI N490SEEnstrom Helicopter 480B · S/N 5176Cancelled Jul 8, 2015 · Exported to Japan · Built 2013 · Menominee, MI N490XNEnstrom Helicopter 480B · S/N 5179Cancelled Jul 8, 2015 · Exported to Japan · Menominee, MI N490YDEnstrom Helicopter 480B · S/N 5180Cancelled Jul 8, 2015 · Exported to Japan · Built 2013 · Menominee, MI N490ZEEnstrom Helicopter 480B · S/N 5181Cancelled Jul 8, 2015 · Exported to Japan · Built 2013 · Menominee, MI N135JPEnstrom Helicopter 480B · S/N 5193Cancelled Jun 22, 2015 · Exported to Japan · Built 2014 · Menominee, MI N148JPEnstrom Helicopter 480B · S/N 5196Cancelled Jun 22, 2015 · Exported to Japan · Built 2014 · Menominee, MI N159JPEnstrom Helicopter 480B · S/N 5201Cancelled Jun 22, 2015 · Exported to Japan · Built 2014 · Menominee, MI N170JPEnstrom Helicopter 480B · S/N 5195Cancelled Jun 22, 2015 · Exported to Japan · Built 2014 · Menominee, MI N490UEEnstrom Helicopter 480B · S/N 5177Cancelled Jun 22, 2015 · Exported to Japan · Built 2013 · Menominee, MI N491BEEnstrom Helicopter 480B · S/N 5182Cancelled Jun 22, 2015 · Exported to Japan · Built 2013 · Menominee, MI N208RJEnstrom Helicopter 480B · S/N 5183Cancelled Dec 31, 2013 · Exported to China · Menominee, MI N490QEEnstrom Helicopter 480B · S/N 5173Cancelled Aug 9, 2013 · Exported to Japan · Built 2013 · Menominee, MI N490TEEnstrom Helicopter 480B · S/N 5174Cancelled Jul 26, 2013 · Exported to Japan · Menominee, MI N480FSEnstrom Helicopter 480B · S/N 5050Cancelled Feb 5, 2003 · Exported to Russia · Menominee, MI N28FREnstrom Helicopter TH-28 · S/N 3005Cancelled Jan 21, 1999 · Triennial form not returned · Menominee, MI N8629AEnstrom Helicopter 480 · S/N 5023Cancelled Feb 18, 1998 · Menominee, MI N28WEEnstrom Helicopter TH-28 · S/N 3006Cancelled May 27, 1997 · Exported to China · Menominee, MI

Back to Enstrom Helicopter Corporation