# Earlier aircraft under this name: Department Of The Army

A list on [Department Of The Army](https://openairdocs.org/faa-owner/DEPARTMENT%20OF%20THE%20ARMY.md).

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

- [N5382W](https://openairdocs.org/deregistered/N5382W-1999-12-08.md): Dehavilland DHC-7-102 · S/N 95 · Cancelled Dec 8, 1999 · United States Government, Berryville, VA
- [N95882](https://openairdocs.org/deregistered/N95882-1981-12-17.md): Hughes 269A · S/N 470701 · Cancelled Dec 17, 1981 · Lathrop, CA
- [N4220A](https://openairdocs.org/deregistered/N4220A-1981-01-20.md): Piper L-21A · S/N 18-894 · Cancelled Jan 20, 1981 · Fort Knox, KY
- [N6495](https://openairdocs.org/deregistered/N6495-1975-05-02.md): Cessna 305A · S/N 22739 · Cancelled May 2, 1975 · Lathrop, CA
- [N6479D](https://openairdocs.org/deregistered/N6479D-1971-02-02.md): Navion NAVION A · S/N 47-1322 · Cancelled Feb 2, 1971 · Fort Sill, OK
- [N7242C](https://openairdocs.org/deregistered/N7242C-1970-11-23.md): Navion NAVION A · S/N NAV4-1755 · Cancelled Nov 23, 1970 · Fort Huachuca, AZ
- [N815Z](https://openairdocs.org/deregistered/N815Z-1970-08-21.md): Hiller OH-5A · S/N 624208 · Cancelled Aug 21, 1970 · Washington, DC
- [N3970A](https://openairdocs.org/deregistered/N3970A-1970-07-13.md): Piper PA-18-125 · S/N 18-573 · Cancelled Jul 13, 1970
- [N3972A](https://openairdocs.org/deregistered/N3972A-1970-07-13.md): North American NAVION L-17C · S/N NAV41085 · Cancelled Jul 13, 1970 · Fort Eustis, VA
- [N4208A](https://openairdocs.org/deregistered/N4208A-1970-06-30.md): Ryan NAVION A · S/N NAV4-1651 · Cancelled Jun 30, 1970 · Fort Eustis, VA
- [N8379H](https://openairdocs.org/deregistered/N8379H-1970-06-30.md): Navion L-17B · S/N 48-953 · Cancelled Jun 30, 1970 · Ft Leavenworth, KS
- [N6739C](https://openairdocs.org/deregistered/N6739C-1970-06-18.md): Piper PA-18 · S/N 18-2131 · Cancelled Jun 18, 1970 · Lathrop, CA
- [N7602C](https://openairdocs.org/deregistered/N7602C-1965-12-03.md): Ryan NAVION A · S/N NAV-4-1451 · Cancelled Dec 3, 1965 · Albuquerque, NM
- [N4955B](https://openairdocs.org/deregistered/N4955B-1965-05-23.md): Beech D-50 · S/N DH-2 · Cancelled May 23, 1965 · Washington, DC
- [N6841C](https://openairdocs.org/deregistered/N6841C-1965-05-22.md): Piper PA-18 · S/N 18-886 · Cancelled May 22, 1965 · Albuquerque, NM
- [N6842C](https://openairdocs.org/deregistered/N6842C-1965-05-22.md): Piper PA-18 · S/N 18-898 · Cancelled May 22, 1965 · Albuquerque, NM
- [N9423H](https://openairdocs.org/deregistered/N9423H-1965-05-21.md): Cessna 195 · S/N 7804 · Cancelled May 21, 1965 · Fort Monmouth, NJ
- [N3971A](https://openairdocs.org/deregistered/N3971A-1965-05-20.md): Navion NAVION A · S/N 4-1086 · Cancelled May 20, 1965 · Built 1957 · Fort Eustis, VA
- [N2979C](https://openairdocs.org/deregistered/N2979C-1964-05-21.md): Navion NAVION A · S/N NAV-4-1757 · Cancelled May 21, 1964 · Fort Leavenworth, KS
- [N1763C](https://openairdocs.org/deregistered/N1763C-1960-11-08.md): Cessna 305A · S/N 51-12757 · Cancelled Nov 8, 1960 · Washington, DC
- [N1762C](https://openairdocs.org/deregistered/N1762C-1960-10-17.md): Cessna L-19A · S/N 51-12753 · Cancelled Oct 17, 1960 · Washington, DC
- [N6452D](https://openairdocs.org/deregistered/N6452D-1958-11-24.md): Piper PA-18 · S/N 18956 · Cancelled Nov 24, 1958
- [N4965B](https://openairdocs.org/deregistered/N4965B-1956-09-20.md): Beech D-50 · S/N DH-18 · Cancelled Sep 20, 1956 · 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 = 'DEPARTMENT OF THE ARMY' OR list_contains(d.other_registrant_names, 'DEPARTMENT OF THE ARMY')
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

This list as a web page: https://openairdocs.org/faa-owner/DEPARTMENT%20OF%20THE%20ARMY/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, except the copies of manufacturers’ service documents, which belong to their rights holders.
