OpenAirDocs.org
War Department

Earlier aircraft under this name · 23

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 = 'WAR DEPARTMENT' OR list_contains(d.other_registrant_names, 'WAR DEPARTMENT')
  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.

N15470Cessna C-34 · S/N 309Cancelled May 4, 1953N91086Douglas C-54 · S/N 22162Cancelled Sep 11, 1947 · Dayton, OHN14958Lockheed ELECTRA 10-B · S/N 1036Cancelled Oct 12, 1945 · Exported to Brazil · Washington, DCN2426Stinson SR-10F · S/N 7-5835Cancelled Sep 18, 1943 · Built 1938 · Washington, DCN13316Boeing 247D · S/N 1697Cancelled May 22, 1943 · Built 1933 · Washington, DCN13328Boeing 247D · S/N 1709Cancelled May 21, 1943 · Built 1933 · Washington, DCN17317Douglas DC3 · S/N 1932Cancelled May 6, 1943 · Built 1937 · Washington, DCN13719Douglas DC2 · S/N 1245Cancelled May 4, 1943 · Xxxx, OKN13716Douglas DC2 · S/N 1242Cancelled Mar 22, 1943 · Xxxx, OKN18038Beech E17B · S/N 149Cancelled Jan 7, 1943N15248Waco YOC-1 · S/N 4330Cancelled Nov 18, 1942 · Built 1935 · Washington, DCN16402Cessna C-34 · S/N 321Cancelled Sep 30, 1942N19951Fairchild 71 · S/N 803Cancelled Aug 31, 1942 · Washington, DCN6441Cessna DC-6A · S/N 226Cancelled Aug 11, 1942N22400Howard DGA-12 · S/N 400Cancelled Jul 28, 1942 · Built 1939 · Washington, DCN22401Howard DGA-12 · S/N 401Cancelled Jul 28, 1942 · Built 1939 · Washington, DCN400Beech D17R · S/N D17R-166Cancelled Jul 14, 1942 · Built 1937 · Washington, DCN20790Beech F17D · S/N 276Cancelled Jun 30, 1942 · Washington, DCN633KCessna DC6B · S/N 219Cancelled Jun 30, 1942 · Washington, DCN20960Waco SRE · S/N 5082Cancelled May 22, 1942 · Built 1940 · Washington, DCN18557Beech E17B · S/N 159Cancelled May 21, 1942 · Built 1937 · Washington, DCN13301Boeing 247D · S/N 1662Cancellation date not recorded · Built 1943 · Washington, DCN17667Spartan 7W · S/N 33Cancellation date not recorded · Built 1940 · Washington, DC
Back to War Department