Mcdonnell Douglas Helicopter Co

Earlier aircraft under this name · 84

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

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

N5018FMcdonnell Douglas Helicopter AH-64DHA · S/N 03-1029Cancelled Aug 29, 2012 · Exported to Greece · Built 2007 · Mesa, AZN5214SMcdonnell Douglas Heli 369FF · S/N 0082FFCancelled Aug 2, 2012 · Exported to Mexico · Built 1992 · Mesa, AZN52176Mcdonnell Douglas Heli 369FF · S/N 0088FFCancelled Jul 16, 2012 · Exported to Mexico · Built 1992 · Mesa, AZN5018THughes Helicopters HUGHES 369D · S/N 611008DCancelled Jul 5, 2012 · Exported to Honduras · Built 1981 · Mesa, AZN5002LMcdonnell Douglas AH64DHS · S/N 03-1021Cancelled Jun 29, 2012 · Exported to Greece · Built 2006 · Mesa, AZN52257Mcdonnell Douglas Heli 369FF · S/N 0101FFCancelled Jun 29, 2012 · Exported to Chile · Built 1994 · Mesa, AZN1098GHughes Helicopters HUGHES 369D · S/N 310914DCancelled Jun 28, 2012 · Expired dealer · Built 1981 · Mesa, AZN5021TMcdonnell Douglas Helicopter AH-64DHA · S/N 03-1031Cancelled Jun 28, 2012 · Exported to Greece · Built 2007 · Mesa, AZN9883JMcdonnell Douglas AH64DJP · S/N 02-0002Cancelled Jun 28, 2012 · Exported to Japan · Built 2005 · Mesa, AZN9505FHughes 269C · S/N 300016Cancelled Jun 25, 2012 · Expired dealer · Built 1970 · Mesa, AZN1090NHughes 269C · S/N 611062Cancelled May 31, 2012 · Expired dealer · Built 1981 · Mesa, AZN1095NHughes Helicopters HUGHES 369D · S/N 310925DCancelled May 31, 2012 · Expired dealer · Built 1981 · Mesa, AZN10974Hughes Helicopters HUGHES 369D · S/N 310919DCancelled May 31, 2012 · Expired dealer · Built 1981 · Mesa, AZN1607LMcdonnell Douglas Helicopter 369E · S/N 0360ECancelled May 31, 2012 · Expired dealer · Mesa, AZN5009LMcdonnell Douglas Helicopter AH-64DHA · S/N 03-1024Cancelled May 31, 2012 · Expired dealer · Built 2006 · Mesa, AZN5014LMcdonnell Douglas Helicopter AH-64DHA · S/N 03-1025Cancelled May 31, 2012 · Expired dealer · Built 2006 · Mesa, AZN50161Mcdonnell Douglas Helicopter AH-64DHA · S/N 03-1026Cancelled May 31, 2012 · Expired dealer · Built 2006 · Mesa, AZN50165Mcdonnell Douglas Helicopter AH-64DHA · S/N 03-1027Cancelled May 31, 2012 · Expired dealer · Built 2006 · Mesa, AZN50173Mcdonnell Douglas Helicopter AH-64DHA · S/N 03-1028Cancelled May 31, 2012 · Expired dealer · Built 2006 · Mesa, AZN5018KMcdonnell Douglas Helicopter AH-64DHA · S/N 03-1030Cancelled May 31, 2012 · Expired dealer · Built 2007 · Mesa, AZN50220Mcdonnell Douglas Helicopter AH-64DHA · S/N 03-1032Cancelled May 31, 2012 · Expired dealer · Built 2007 · Mesa, AZN5214WMcdonnell Douglas Heli 369FF · S/N 0083FFCancelled May 31, 2012 · Expired dealer · Built 1992 · Mesa, AZN58328Hughes 269C · S/N 1090842Cancelled Feb 6, 2008 · Built 1979 · Mesa, AZN9037FHughes 369HM · S/N 520214MCancelled Nov 26, 2007 · Built 1972 · Mesa, AZN9208ZMcdonnell Douglas Heli 369FF · S/N 0125FFCancelled Dec 14, 2005 · Exported to Chile · Built 1997 · Mesa, AZN9219GMcdonnell Douglas WAH-64 · S/N ZJ166Cancelled Dec 14, 2005 · Built 1999 · Mesa, AZN92004Mcdonnell Douglas Heli 369FF · S/N 0124FFCancelled Dec 13, 2005 · Exported to Chile · Built 1997 · Mesa, AZN9204DMcdonnell Douglas Helicopter 600N · S/N RN004Cancelled Dec 13, 2005 · Built 1996 · Mesa, AZN9208JMcdonnell Douglas Heli 369FF · S/N 0120FFCancelled Dec 13, 2005 · Exported to Chile · Built 1997 · Mesa, AZN92264Mcdonnell Douglas Heli 369FF · S/N 0126FFCancelled Dec 13, 2005 · Exported to Chile · Built 1997 · Mesa, AZN92266Mcdonnell Douglas Heli 369FF · S/N 0128FFCancelled Dec 13, 2005 · Exported to Chile · Built 1997 · Mesa, AZN92275Mcdonnell Douglas Heli 369FF · S/N 0127FFCancelled Dec 13, 2005 · Exported to Chile · Built 1997 · Mesa, AZN5112UHughes Helicopters HUGHES 369D · S/N 911085DCancelled May 22, 2002 · Mesa, AZN9234PMcdonnell Douglas Helicopter MD 900 · S/N 90000056Cancelled Oct 9, 1998 · Exported to United Kingdom · Mesa, AZN9202LMcdonnell Douglas Helicopter 600N · S/N RN002Cancelled Aug 31, 1998 · Mesa, AZN9238TMcdonnell Douglas Helicopter MD 900 · S/N 90000057Cancelled Aug 26, 1998 · Exported to United Kingdom · Mesa, AZN9209GMcdonnell Douglas Helicopter 369E · S/N 0539ECancelled Jul 24, 1998 · Exported to Japan · Mesa, AZN9232KMcdonnell Douglas Helicopter 369E · S/N 0538ECancelled Jun 24, 1998 · Exported to Japan · Mesa, AZN92237Mcdonnell Douglas Helicopter MD 900 · S/N 90000053Cancelled Jun 5, 1998 · Exported to United Kingdom · Mesa, AZN9235MMcdonnell Douglas Helicopter MD 900 · S/N 90000055Cancelled May 19, 1998 · Exported to Japan · Mesa, AZN684FMcdonnell Douglas Helicopter 369E · S/N 0491ECancelled Apr 24, 1998 · Exported to United Kingdom · Mesa, AZN91637Mcdonnell Douglas Helicopter MD 900 · S/N 90000033Cancelled Dec 23, 1997 · Exported to Germany · Mesa, AZN9173QMcdonnell Douglas Heli 369FF · S/N 0122FFCancelled May 1, 1997 · Exported to Mexico · Mesa, AZN9198NMcdonnell Douglas Heli 369FF · S/N 0123FFCancelled May 1, 1997 · Exported to Mexico · Mesa, AZN9198RMcdonnell Douglas Helicopter MD 900 · S/N 90000035Cancelled Feb 12, 1997 · Exported to Mexico · Mesa, AZN9198YMcdonnell Douglas Helicopter MD 900 · S/N 90000036Cancelled Dec 20, 1996 · Exported to Germany · Mesa, AZN9203PMcdonnell Douglas Helicopter MD 900 · S/N 90000043Cancelled Oct 10, 1996 · Exported to Venezuela · Mesa, AZN9132NMcdonnell Douglas Helicopter MD 900 · S/N 90000032Cancelled Mar 28, 1996 · Exported to South Korea · Mesa, AZN52078Mcdonnell Douglas Helicopter 500N · S/N LN061Cancelled Mar 14, 1996 · Exported to Hong Kong · Mesa, AZN52319Mcdonnell Douglas Helicopter 500N · S/N LN076Cancelled Dec 15, 1995 · Exported to Germany · Mesa, AZ
Back to Mcdonnell Douglas Helicopter Co