# Earlier aircraft under this name: U S Army

A list on [U S Army](https://openairdocs.org/faa-owner/U%20S%20ARMY.md).

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

- [N1284B](https://openairdocs.org/deregistered/N1284B-2024-09-10.md): Textron B300 · S/N FL-1284 · Cancelled Sep 10, 2024 · Exported to Sri Lanka · Built 2022 · Redstone Arsenal, AL
- [N736TL](https://openairdocs.org/deregistered/N736TL-2024-02-15.md): Textron 208B · S/N 208B5736 · Cancelled Feb 15, 2024 · Exported to Dominican Republic · Built 2023 · Redstone Arsenal, AL
- [N62220](https://openairdocs.org/deregistered/N62220-1985-12-23.md): Cessna 172 · S/N R172-0186 · Cancelled Dec 23, 1985 · Fort Knox, KY
- [N65104](https://openairdocs.org/deregistered/N65104-1984-05-24.md): Cessna R172E · S/N R-172-0064 · Cancelled May 24, 1984 · Ft Wainwright, AK
- [N48249](https://openairdocs.org/deregistered/N48249-1983-08-11.md): Cessna R172E · S/N R172-0166 · Cancelled Aug 11, 1983 · Built 1966 · Fort Lewis, WA
- [N4293A](https://openairdocs.org/deregistered/N4293A-1981-05-06.md): Piper L-21A · S/N 18-896 · Cancelled May 6, 1981 · Built 1958 · Watervilet, NY
- [N73532](https://openairdocs.org/deregistered/N73532-1981-04-02.md): Cessna R172E · S/N R172-0098 · Cancelled Apr 2, 1981 · Texarkana, TX
- [N12987](https://openairdocs.org/deregistered/N12987-1976-06-21.md): Cessna R172E · S/N R-172-0139 · Cancelled Jun 21, 1976 · Ft Hood, TX
- [N10556](https://openairdocs.org/deregistered/N10556-1975-07-23.md): Piper PA-18 · S/N 18-922 · Cancelled Jul 23, 1975 · Fort Rucker, AL
- [N12988](https://openairdocs.org/deregistered/N12988-1975-05-07.md): Cessna 305E · S/N 23961 · Cancelled May 7, 1975 · Ft Hood, TX
- [N1401Z](https://openairdocs.org/deregistered/N1401Z-1974-03-01.md): Beech C-45H · S/N 52-10651 · Cancelled Mar 1, 1974 · Fort Wainwright, AK
- [N5561A](https://openairdocs.org/deregistered/N5561A-1973-06-25.md): Piper L-21A · S/N 18-889 · Cancelled Jun 25, 1973 · West Point, NY
- [N8378H](https://openairdocs.org/deregistered/N8378H-1972-08-23.md): Piper PA-18-125 · S/N 18-935 · Cancelled Aug 23, 1972 · Fort Riley, KS
- [N4076A](https://openairdocs.org/deregistered/N4076A-1971-01-18.md): Piper PA-19 · S/N 18-2115 · Cancelled Jan 18, 1971 · Columbus, OH
- [N6721C](https://openairdocs.org/deregistered/N6721C-1970-10-06.md): Piper PA-18 · S/N 18-862 · Cancelled Oct 6, 1970
- [N4267A](https://openairdocs.org/deregistered/N4267A-1970-06-30.md): Piper PA-19 · S/N 18-2109 · Cancelled Jun 30, 1970 · West Point, NY
- [N7607C](https://openairdocs.org/deregistered/N7607C-1970-06-27.md): Cessna 195 · S/N 7811 · Cancelled Jun 27, 1970 · White Sands Missil, NM
- [N6527D](https://openairdocs.org/deregistered/N6527D-1970-06-22.md): Cessna 195 · S/N 7817 · Cancelled Jun 22, 1970 · Staten Island, NY
- [N10131](https://openairdocs.org/deregistered/N10131-1968-10-21.md): Piper PA-18 · S/N 18-883 · Cancelled Oct 21, 1968 · Fort Devens, MA
- [N7984A](https://openairdocs.org/deregistered/N7984A-1965-11-08.md): Piper PA-18 · S/N 18-952 · Cancelled Nov 8, 1965 · Ft Sill, OK
- [N5418V](https://openairdocs.org/deregistered/N5418V-1965-05-20.md): Ryan NAVION A · S/N NAV-4-413 · Cancelled May 20, 1965 · Lathrop, CA
- [N7710B](https://openairdocs.org/deregistered/N7710B-1961-06-19.md): Ryan NAVION · S/N NAV-4-1732 · Cancelled Jun 19, 1961 · Clarksville, TN
- [N95420](https://openairdocs.org/deregistered/N95420-1954-05-13.md): Douglas C-54G · S/N 36078 · Cancelled May 13, 1954

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

This list as a web page: https://openairdocs.org/faa-owner/U%20S%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.