Skip to content

Mcdonnell Douglas Corp

Earlier aircraft under this name · 35

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

N50287MLB 002 · S/N 008Cancelled May 10, 2011 · Triennial form not returned · Saint Louis, MO N5029YMLB 002 · S/N 009Cancelled May 10, 2011 · Triennial form not returned · Saint Louis, MO N5040YMLB 003 · S/N 0050Cancelled May 10, 2011 · Triennial form not returned · Saint Louis, MO N5040ZBoeing PMTD · S/N 1Cancelled May 10, 2011 · Triennial form not returned · Berkeley, MO N50430MLB 003 · S/N 0040Cancelled May 10, 2011 · Triennial form not returned · Saint Louis, MO N5061VInsitu Group SCANEAGLE A-15 EO · S/N 06-188Cancelled May 10, 2011 · Boeing Co, Berkeley, MO N1003GMcdonnell Douglas DC-9-81(MD-81) · S/N 48050Cancelled Jul 30, 1993 · Triennial form not returned · Long Beach, CA N3340LDouglas DC-9-32 · S/N 47276Cancelled Apr 23, 1993 · Exported to Nigeria · Long Beach, CA N539MDDouglas DC-9-33F · S/N 47565Cancelled Nov 28, 1990 · Long Beach, CA N536MDMcdonnell Douglas DC-9-33F · S/N 47496Cancelled Nov 5, 1990 · Long Beach, CA N538MDMcdonnell Douglas DC-9-33F · S/N 47545Cancelled Jul 13, 1990 · Long Beach, CA N508MDDouglas DC-9-32 · S/N 47477Cancelled Jan 23, 1986 · Long Beach, CA N59TMcdonnell Douglas DC-9-32F · S/N 47041Cancelled Oct 9, 1984 · Yuma, AZ N504MDDouglas DC-9-32 · S/N 47468Cancelled Jan 26, 1984 · Exported to United Kingdom · Yuma, AZ N907DCDouglas DC-9-33F · S/N 47476Cancelled Sep 24, 1983 · Administratively canceled · Yuma, AZ N3302LDouglas DC-9-14 · S/N 45697Cancelled Jul 7, 1981 · Built 1965 · Long Beach, CA N8714QMcdonnell Douglas DC-9-51 · S/N 47773Cancelled Nov 24, 1980 · Exported to Finland · Yuma, AZ N1002GMcdonnell Douglas DC-9-81(MD-81) · S/N 48001Cancelled Nov 5, 1980 · Built 1979 · Yuma, AZ N8713QMcdonnell Douglas DC-9-51 · S/N 47772Cancelled Apr 2, 1980 · Exported to Finland · Yuma, AZ N153AFDouglas DC-8-54 · S/N 45682Cancelled Dec 20, 1978 · Exported to Italy · Built 1965 · Tulsa, OK N65358Mcdonnell Douglas DC-9-15 · S/N 47048Cancelled Apr 7, 1978 · Exported to United Kingdom · Yuma, AZ N5879XDouglas DC-8F-54 · S/N 45879Cancelled Mar 2, 1978 · Exported to United Kingdom · Yuma, AZ N8707QMcdonnell-Douglas DC-10-30 · S/N 46959Cancelled Mar 2, 1977 · Exported to Thailand · Yuma, AZ N54638Mcdonnell Douglas DC-9-30 · S/N 47649Cancelled Mar 4, 1976 · Exported to Yugoslavia · Yuma, AZ N8701QMcdonnell Douglas DC-9-32 · S/N 47650Cancelled May 28, 1975 · Exported to Mexico · Long Beach, CA N54646Douglas DC-10-30F · S/N 46952Cancelled Feb 26, 1975 · Exported to Netherlands · Yuma, AZ N54634Mcdonnell-Douglas DC-10-30 · S/N 47887Cancelled Nov 25, 1974 · Exported to Thailand · Yuma, AZ N54635Mcdonnell Douglas DC-9-30 · S/N 47600Cancelled Mar 19, 1974 · Exported to Italy · Yuma, AZ N54637Mcdonnell-Douglas DC-10-30 · S/N 46931Cancelled Mar 4, 1974 · Exported to Pakistan · Yuma, AZ N1350UMcdonnell-Douglas DC-10-30 · S/N 46851Cancelled Mar 20, 1973 · Exported to France · Yuma, AZ N1337UMcdonnell Douglas DC-10-10 · S/N 46704Cancelled Dec 14, 1972 · Exported to Turkey · Built 1972 · Yuma, AZ N902HDouglas DC9-15 · S/N 45724Cancelled Mar 2, 1972 · Exported to Italy · Long Beach, CA N13614Douglas DC-9-14 · S/N 45713Cancelled Feb 19, 1971 · Exported to Finland · Built 1966 · Long Beach, CA N1792UDouglas DC-9-14 · S/N 45712Cancelled Feb 16, 1971 · Exported to Finland · Built 1965 · Long Beach, CA N1790UDouglas DC9-15 · S/N 45785Cancelled Aug 28, 1970 · Exported to Mexico · Built 1966 · Long Beach, CA

Back to Mcdonnell Douglas Corp