Skip to content

Douglas Aircraft Co Inc

Earlier aircraft under this name · 43

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

N223YDouglas DC-1 · S/N 1137Cancelled Apr 28, 2022 · Santa Monica, CA N9612ZDouglas DC-8F-54 · S/N 45653Cancelled Feb 14, 1963 · Exported to Canada · Long Beach, CA N9611ZDouglas DC-8-51 · S/N 45652Cancelled Dec 12, 1962 · Exported to Mexico · Long Beach, CA N9607ZDouglas DC-8-53 · S/N 45607Cancelled Aug 23, 1962 · Exported to Philippines · Santa Monica, CA N9608ZDouglas DC-8-53 · S/N 45608Cancelled May 10, 1962 · Exported to Netherlands · Long Beach, CA N8611Douglas DC-8-21 · S/N 45432Cancelled Nov 30, 1960 · Exported to Mexico · Santa Monica, CA N70CDouglas DC-7C · S/N 44872Cancelled Jun 27, 1957 · Exported to Brazil · Santa Monica, CA N8000HDouglas 1015 · S/N 43113Cancelled Oct 12, 1950 · Santa Monica, CA N16019Douglas DC3 · S/N 1557Cancelled Jul 13, 1950 · Santa Monica, CA N10203Douglas DC-4 · S/N 42918Cancelled Aug 15, 1947 · Exported to Australia · Santa Monica, CA N34980Douglas DC3-G202A · S/N 42976Cancelled May 1, 1946 · Exported to Denmark · Santa Monica, CA N34982Douglas DC3D-R-1830-90C · S/N 42978Cancelled May 1, 1946 · Exported to Switzerland · Santa Monica, CA N34981Douglas DC3D-R-1830-90C · S/N 42977Cancelled Mar 26, 1946 · Exported to Belgium · Santa Monica, CA N34983Douglas DC3D-R-1830-90C · S/N 42979Cancelled Mar 26, 1946 · Exported to Brazil · Santa Monica, CA N30027Douglas DC-3A-S1C3G · S/N 4980Cancelled Jul 3, 1942 · Santa Monica, CA N30032Douglas DC3-G202A · S/N 6334Cancelled Jul 3, 1942 · Santa Monica, CA N34953Douglas DC-3A-S1C3G · S/N 6346Cancelled Jul 2, 1942 · Santa Monica, CA N34954Douglas DC-3A-S1C3G · S/N 6347Cancelled Jul 2, 1942 · Santa Monica, CA N34955Douglas DC-3A-S1C3G · S/N 6348Cancelled Jul 2, 1942 · Santa Monica, CA N34958Douglas DC-3A-S1C3G · S/N 6351Cancelled Jul 2, 1942 · Santa Monica, CA N34972Douglas DC3-G202A · S/N 4995Cancelled Jul 2, 1942 · Santa Monica, CA N33630Douglas DST-G202A · S/N 4136Cancelled Apr 29, 1941 · Santa Monica, CA N1952Douglas DC3-G202A · S/N 1Cancelled Feb 6, 1941 · Santa Monica, CA N1954Douglas DC3-G202A · S/N 3298Cancelled Feb 6, 1941 · Santa Monica, CA N1955Douglas DC3-G202A · S/N 3299Cancelled Feb 6, 1941 · Built 1940 · Santa Monica, CA N25697Douglas DC3-G102A · S/N 4083Cancelled Jan 31, 1941 · Santa Monica, CA N28386Douglas DC3-G202A · S/N 4094Cancelled Jan 31, 1941 · Santa Monica, CA N33620Douglas DC3-G202A · S/N 4802Cancelled Jan 31, 1941 · Santa Monica, CA N33626Douglas DC3-G202A · S/N 4803Cancelled Jan 31, 1941 · Santa Monica, CA N33627Douglas DC3-G202A · S/N 4804Cancelled Jan 31, 1941 · Santa Monica, CA N33628Douglas DC3-G202A · S/N 4805Cancelled Jan 31, 1941 · Santa Monica, CA N33635Douglas DC3-G202A · S/N 4141Cancelled Jan 31, 1941 · Santa Monica, CA N33636Douglas DC3-G202A · S/N 4142Cancelled Jan 31, 1941 · Santa Monica, CA N33637Douglas DC3-G202A · S/N 4143Cancelled Jan 31, 1941 N34962Douglas DC3-G102 · S/N 3289Cancelled Jan 31, 1941 · Santa Monica, CA N18100Douglas DC-4 · S/N 1601Cancelled Oct 14, 1939 · Exported to Japan · Santa Monica, CA N145WDouglas DOLPHIN 8 · S/N 1-A-703Cancelled Feb 15, 1934 · Santa Monica, CA N13718Douglas DC2 · S/N 1244Cancellation date not recorded · Built 1934 · Santa Monica, CA N14925Douglas DC2 · S/N 1411Cancellation date not recorded · Built 1935 · Santa Monica, CA N14949Douglas DC2 · S/N 1413Cancellation date not recorded · Built 1935 · Santa Monica, CA N30004Douglas DC-3A-S1C3G · S/N 4173Cancellation date not recorded · Santa Monica, CA N33659Douglas DC-3A-S1C3G · S/N 4981Cancellation date not recorded · Built 1943 N33684Douglas DC-3A-S1C3G · S/N 4963Cancellation date not recorded

Back to Douglas Aircraft Co Inc