# Earlier aircraft under this name: War Department

A list on [War Department](https://openairdocs.org/faa-owner/WAR%20DEPARTMENT.md).

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

- [N15470](https://openairdocs.org/deregistered/N15470-1953-05-04.md): Cessna C-34 · S/N 309 · Cancelled May 4, 1953
- [N91086](https://openairdocs.org/deregistered/N91086-1947-09-11.md): Douglas C-54 · S/N 22162 · Cancelled Sep 11, 1947 · Dayton, OH
- [N14958](https://openairdocs.org/deregistered/N14958-1945-10-12.md): Lockheed ELECTRA 10-B · S/N 1036 · Cancelled Oct 12, 1945 · Exported to Brazil · Washington, DC
- [N2426](https://openairdocs.org/deregistered/N2426-1943-09-18.md): Stinson SR-10F · S/N 7-5835 · Cancelled Sep 18, 1943 · Built 1938 · Washington, DC
- [N13316](https://openairdocs.org/deregistered/N13316-1943-05-22.md): Boeing 247D · S/N 1697 · Cancelled May 22, 1943 · Built 1933 · Washington, DC
- [N13328](https://openairdocs.org/deregistered/N13328-1943-05-21.md): Boeing 247D · S/N 1709 · Cancelled May 21, 1943 · Built 1933 · Washington, DC
- [N17317](https://openairdocs.org/deregistered/N17317-1943-05-06.md): Douglas DC3 · S/N 1932 · Cancelled May 6, 1943 · Built 1937 · Washington, DC
- [N13719](https://openairdocs.org/deregistered/N13719-1943-05-04.md): Douglas DC2 · S/N 1245 · Cancelled May 4, 1943 · Xxxx, OK
- [N13716](https://openairdocs.org/deregistered/N13716-1943-03-22.md): Douglas DC2 · S/N 1242 · Cancelled Mar 22, 1943 · Xxxx, OK
- [N18038](https://openairdocs.org/deregistered/N18038-1943-01-07.md): Beech E17B · S/N 149 · Cancelled Jan 7, 1943
- [N15248](https://openairdocs.org/deregistered/N15248-1942-11-18.md): Waco YOC-1 · S/N 4330 · Cancelled Nov 18, 1942 · Built 1935 · Washington, DC
- [N16402](https://openairdocs.org/deregistered/N16402-1942-09-30.md): Cessna C-34 · S/N 321 · Cancelled Sep 30, 1942
- [N19951](https://openairdocs.org/deregistered/N19951-1942-08-31.md): Fairchild 71 · S/N 803 · Cancelled Aug 31, 1942 · Washington, DC
- [N6441](https://openairdocs.org/deregistered/N6441-1942-08-11.md): Cessna DC-6A · S/N 226 · Cancelled Aug 11, 1942
- [N22400](https://openairdocs.org/deregistered/N22400-1942-07-28.md): Howard DGA-12 · S/N 400 · Cancelled Jul 28, 1942 · Built 1939 · Washington, DC
- [N22401](https://openairdocs.org/deregistered/N22401-1942-07-28.md): Howard DGA-12 · S/N 401 · Cancelled Jul 28, 1942 · Built 1939 · Washington, DC
- [N400](https://openairdocs.org/deregistered/N400-1942-07-14.md): Beech D17R · S/N D17R-166 · Cancelled Jul 14, 1942 · Built 1937 · Washington, DC
- [N20790](https://openairdocs.org/deregistered/N20790-1942-06-30.md): Beech F17D · S/N 276 · Cancelled Jun 30, 1942 · Washington, DC
- [N633K](https://openairdocs.org/deregistered/N633K-1942-06-30.md): Cessna DC6B · S/N 219 · Cancelled Jun 30, 1942 · Washington, DC
- [N20960](https://openairdocs.org/deregistered/N20960-1942-05-22.md): Waco SRE · S/N 5082 · Cancelled May 22, 1942 · Built 1940 · Washington, DC
- [N18557](https://openairdocs.org/deregistered/N18557-1942-05-21.md): Beech E17B · S/N 159 · Cancelled May 21, 1942 · Built 1937 · Washington, DC
- [N13301](https://openairdocs.org/deregistered/N13301-undated-1662.md): Boeing 247D · S/N 1662 · Cancellation date not recorded · Built 1943 · Washington, DC
- [N17667](https://openairdocs.org/deregistered/N17667-undated.md): Spartan 7W · S/N 33 · Cancellation date not recorded · Built 1940 · Washington, DC

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```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 = 'WAR DEPARTMENT' OR list_contains(d.other_registrant_names, 'WAR DEPARTMENT')
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

This list as a web page: https://openairdocs.org/faa-owner/WAR%20DEPARTMENT/earlier

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.