# Earlier aircraft under this name: U S Air Force

A list on [U S Air Force](https://openairdocs.org/faa-owner/U%20S%20AIR%20FORCE.md).

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

- [N5157F](https://openairdocs.org/deregistered/N5157F-2013-07-08.md): Cessna 172F · S/N 17253016 · Cancelled Jul 8, 2013 · Third renewal notice · Randolph Afb, TX
- [N2125U](https://openairdocs.org/deregistered/N2125U-2011-08-09.md): Cessna 208B · S/N 208B1309 · Cancelled Aug 9, 2011 · Exported to Iraq · Built 2008 · Dayton, OH
- [N7878N](https://openairdocs.org/deregistered/N7878N-2002-07-26.md): Cessna R172E · S/N R172-0269 · Cancelled Jul 26, 2002 · Triennial form not returned · Built 1967 · Patrick Afb, FL
- [N7894N](https://openairdocs.org/deregistered/N7894N-1998-04-01.md): Cessna R172E · S/N R1720285 · Cancelled Apr 1, 1998 · Triennial form not returned · San Antonio, TX
- [N7904N](https://openairdocs.org/deregistered/N7904N-1997-07-24.md): Cessna R172E · S/N R1720295 · Cancelled Jul 24, 1997 · Triennial form not returned · Usaf Academy, CO
- [N5254Q](https://openairdocs.org/deregistered/N5254Q-1981-12-23.md): Cessna 150L · S/N 15073154 · Cancelled Dec 23, 1981 · Barksdale Afb, LA
- [N4981N](https://openairdocs.org/deregistered/N4981N-1974-08-02.md): Beech A45 · S/N 53-4094 · Cancelled Aug 2, 1974 · Built 1955 · Alexandria, LA
- [N4963R](https://openairdocs.org/deregistered/N4963R-1974-05-07.md): Cessna 172H · S/N 17256317 · Cancelled May 7, 1974 · Randolph Afb, TX
- [N5145F](https://openairdocs.org/deregistered/N5145F-1974-04-26.md): Cessna 172F · S/N 17252968 · Cancelled Apr 26, 1974 · Exported to Chile · Randolph Afb, TX
- [N5146F](https://openairdocs.org/deregistered/N5146F-1974-04-26.md): Cessna 172F · S/N 17252972 · Cancelled Apr 26, 1974 · Exported to Chile · Randolph Afb, TX
- [N7992A](https://openairdocs.org/deregistered/N7992A-1970-11-18.md): Beech A45 · S/N G-787 · Cancelled Nov 18, 1970 · Perrin Afb, TX
- [N5105F](https://openairdocs.org/deregistered/N5105F-1970-07-06.md): Cessna 172F · S/N 17252688 · Cancelled Jul 6, 1970 · Washington, DC
- [N5106F](https://openairdocs.org/deregistered/N5106F-1970-07-06.md): Cessna 172F · S/N 17252701 · Cancelled Jul 6, 1970 · Washington, DC
- [N5348S](https://openairdocs.org/deregistered/N5348S-1967-08-18.md): Cessna 337A · S/N 337-0448 · Cancelled Aug 18, 1967 · Built 1966 · Washington, DC
- [N61290](https://openairdocs.org/deregistered/N61290-1966-06-08.md): Beech A45 · S/N 3471 · Cancelled Jun 8, 1966 · Richards Gebaur Af, MO
- [N6282C](https://openairdocs.org/deregistered/N6282C-1965-07-12.md): Piper PA-18 · S/N 18-943 · Cancelled Jul 12, 1965 · Colorado Springs, CO
- [N6512D](https://openairdocs.org/deregistered/N6512D-1965-07-12.md): Beech A45 (T-34A) · S/N 34-133 · Cancelled Jul 12, 1965 · Benton, PA
- [N6451D](https://openairdocs.org/deregistered/N6451D-1965-06-11.md): Beech A45 (T-34A) · S/N 34-72 · Cancelled Jun 11, 1965 · Shaw Afb, SC
- [N10574](https://openairdocs.org/deregistered/N10574-1965-05-25.md): Beech A45 · S/N G-41 · Cancelled May 25, 1965 · Mobile, AL
- [N2528B](https://openairdocs.org/deregistered/N2528B-1965-05-25.md): Piper PA-18 · S/N 18-911 · Cancelled May 25, 1965 · Enid, OK
- [N6854D](https://openairdocs.org/deregistered/N6854D-1965-05-25.md): Dehavilland DHC-2 · S/N 1158 · Cancelled May 25, 1965 · Lincoln, NE
- [N73864](https://openairdocs.org/deregistered/N73864-1965-05-22.md): Dehavilland DHC-2 MK 1 · S/N 1275 · Cancelled May 22, 1965 · Wichita Falls, TX
- [N10594](https://openairdocs.org/deregistered/N10594-1965-05-21.md): Piper L-21 · S/N 18-936 · Cancelled May 21, 1965 · San Antonio, TX
- [N63491](https://openairdocs.org/deregistered/N63491-1965-05-20.md): Beech A45 · S/N G-131 · Cancelled May 20, 1965 · Reno, NV
- [N2941C](https://openairdocs.org/deregistered/N2941C-1965-05-19.md): Beech T-34A · S/N 53-4101A · Cancelled May 19, 1965 · Mt Clemens, MI
- [N10302](https://openairdocs.org/deregistered/N10302-1965-05-18.md): Navion L-17C · S/N 47-1316 · Cancelled May 18, 1965 · Built 1957 · Loring Afb, ME
- [N90910](https://openairdocs.org/deregistered/N90910-1964-01-07.md): Douglas C-54G · S/N 35984 · Cancelled Jan 7, 1964 · Washington, DC
- [N8067E](https://openairdocs.org/deregistered/N8067E-1962-11-15.md): Dehavilland BEAVER DHC-2 MK.1 · S/N 1289 · Cancelled Nov 15, 1962 · Randolph Afb, TX
- [N7706B](https://openairdocs.org/deregistered/N7706B-1961-12-14.md): Beech A45 (T-34A) · S/N G-92 · Cancelled Dec 14, 1961 · Smyrna, TN
- [N9907E](https://openairdocs.org/deregistered/N9907E-1957-03-28.md): Lockheed 749A-79 · S/N 749-2602 · Cancelled Mar 28, 1957 · New York, NY
- [N88951](https://openairdocs.org/deregistered/N88951-1954-05-13.md): Douglas C54G-DC · S/N 35987 · Cancelled May 13, 1954 · New York, NY
- [N88952](https://openairdocs.org/deregistered/N88952-1954-05-13.md): Douglas C54G-DC · S/N 35998 · Cancelled May 13, 1954 · New York, NY

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

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