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.
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
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.
N5018FMcdonnell Douglas Helicopter AH-64DHA · S/N 03-1029N5214SMcdonnell Douglas Heli 369FF · S/N 0082FFN52176Mcdonnell Douglas Heli 369FF · S/N 0088FFN5018THughes Helicopters HUGHES 369D · S/N 611008DN5002LMcdonnell Douglas AH64DHS · S/N 03-1021N52257Mcdonnell Douglas Heli 369FF · S/N 0101FFN1098GHughes Helicopters HUGHES 369D · S/N 310914DN5021TMcdonnell Douglas Helicopter AH-64DHA · S/N 03-1031N9883JMcdonnell Douglas AH64DJP · S/N 02-0002N9505FHughes 269C · S/N 300016N1090NHughes 269C · S/N 611062N1095NHughes Helicopters HUGHES 369D · S/N 310925DN10974Hughes Helicopters HUGHES 369D · S/N 310919DN1607LMcdonnell Douglas Helicopter 369E · S/N 0360EN5009LMcdonnell Douglas Helicopter AH-64DHA · S/N 03-1024N5014LMcdonnell Douglas Helicopter AH-64DHA · S/N 03-1025N50161Mcdonnell Douglas Helicopter AH-64DHA · S/N 03-1026N50165Mcdonnell Douglas Helicopter AH-64DHA · S/N 03-1027N50173Mcdonnell Douglas Helicopter AH-64DHA · S/N 03-1028N5018KMcdonnell Douglas Helicopter AH-64DHA · S/N 03-1030N50220Mcdonnell Douglas Helicopter AH-64DHA · S/N 03-1032N5214WMcdonnell Douglas Heli 369FF · S/N 0083FFN58328Hughes 269C · S/N 1090842N9037FHughes 369HM · S/N 520214MN9208ZMcdonnell Douglas Heli 369FF · S/N 0125FFN9219GMcdonnell Douglas WAH-64 · S/N ZJ166N92004Mcdonnell Douglas Heli 369FF · S/N 0124FFN9204DMcdonnell Douglas Helicopter 600N · S/N RN004N9208JMcdonnell Douglas Heli 369FF · S/N 0120FFN92264Mcdonnell Douglas Heli 369FF · S/N 0126FFN92266Mcdonnell Douglas Heli 369FF · S/N 0128FFN92275Mcdonnell Douglas Heli 369FF · S/N 0127FFN5112UHughes Helicopters HUGHES 369D · S/N 911085DN9234PMcdonnell Douglas Helicopter MD 900 · S/N 90000056N9202LMcdonnell Douglas Helicopter 600N · S/N RN002N9238TMcdonnell Douglas Helicopter MD 900 · S/N 90000057N9209GMcdonnell Douglas Helicopter 369E · S/N 0539EN9232KMcdonnell Douglas Helicopter 369E · S/N 0538EN92237Mcdonnell Douglas Helicopter MD 900 · S/N 90000053N9235MMcdonnell Douglas Helicopter MD 900 · S/N 90000055N684FMcdonnell Douglas Helicopter 369E · S/N 0491EN91637Mcdonnell Douglas Helicopter MD 900 · S/N 90000033N9173QMcdonnell Douglas Heli 369FF · S/N 0122FFN9198NMcdonnell Douglas Heli 369FF · S/N 0123FFN9198RMcdonnell Douglas Helicopter MD 900 · S/N 90000035N9198YMcdonnell Douglas Helicopter MD 900 · S/N 90000036N9203PMcdonnell Douglas Helicopter MD 900 · S/N 90000043N9132NMcdonnell Douglas Helicopter MD 900 · S/N 90000032N52078Mcdonnell Douglas Helicopter 500N · S/N LN061N52319Mcdonnell Douglas Helicopter 500N · S/N LN076
Back to Mcdonnell Douglas Helicopter Co