# Earlier aircraft under this name: United States Government

A list on [United States Government](https://openairdocs.org/faa-owner/UNITED%20STATES%20GOVERNMENT.md).

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

- [N765MG](https://openairdocs.org/deregistered/N765MG-2022-07-30.md): Dehavilland DHC-7-102 · S/N 65 · Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Built 1982 · Fort Belvoir, VA
- [N875RS](https://openairdocs.org/deregistered/N875RS-2017-09-08.md): Douglas EA3B · S/N 144865 · Cancelled Sep 8, 2017 · Registration expired, pending cancellation · Built 1960 · Van Nuys, CA
- [N572HA](https://openairdocs.org/deregistered/N572HA-2017-07-18.md): Douglas ERA-3B · S/N 144841 · Cancelled Jul 18, 2017 · Registration expired, pending cancellation · Van Nuys, CA
- [N877RS](https://openairdocs.org/deregistered/N877RS-2017-06-22.md): Douglas NTA3B · S/N 144867 · Cancelled Jun 22, 2017 · Registration expired, pending cancellation · Built 1960 · Van Nuys, CA
- [N876RS](https://openairdocs.org/deregistered/N876RS-2017-04-18.md): Douglas NRA3B · S/N 142667 · Cancelled Apr 18, 2017 · Registration expired, pending cancellation · Built 1960 · Van Nuys, CA
- [N878RS](https://openairdocs.org/deregistered/N878RS-2017-04-04.md): Douglas NRA3B · S/N 144825 · Cancelled Apr 4, 2017 · Registration expired, pending cancellation · Built 1959 · Van Nuys, CA
- [N15YC](https://openairdocs.org/deregistered/N15YC-2017-03-10.md): Mcdonnell Douglas YC-15 · S/N 72-01875 · Cancelled Mar 10, 2017 · Registration expired, pending cancellation · Built 1972 · Long Beach, CA
- [N163TB](https://openairdocs.org/deregistered/N163TB-2015-05-05.md): Douglas ERA-3B · S/N 142668 · Cancelled May 5, 2015 · Registration expired, pending cancellation · Van Nuys, CA
- [N215YC](https://openairdocs.org/deregistered/N215YC-2012-11-13.md): Mcdonnell Douglas YC-15 · S/N 72-08176 · Cancelled Nov 13, 2012 · Registration expired, pending cancellation · Long Beach, CA
- [N66000](https://openairdocs.org/deregistered/N66000-2012-08-10.md): Beech A200 · S/N BC-66 · Cancelled Aug 10, 2012 · Registration expired, pending cancellation · Bluemont, VA
- [N874RS](https://openairdocs.org/deregistered/N874RS-2011-05-11.md): Douglas EA3B · S/N 146454 · Cancelled May 11, 2011 · Third renewal notice · Built 1960 · Van Nuys, CA
- [N162TB](https://openairdocs.org/deregistered/N162TB-2011-05-10.md): Douglas ERA-3B · S/N 144832 · Cancelled May 10, 2011 · Triennial form not returned · Van Nuys, CA
- [N571HA](https://openairdocs.org/deregistered/N571HA-2011-05-10.md): Douglas RA-3B · S/N 144843 · Cancelled May 10, 2011 · Triennial form not returned · Van Nuys, CA
- [N573HA](https://openairdocs.org/deregistered/N573HA-2011-05-10.md): Douglas ERA-3B · S/N 144838 · Cancelled May 10, 2011 · Triennial form not returned · Van Nuys, CA
- [N870RS](https://openairdocs.org/deregistered/N870RS-2011-05-10.md): Douglas TA-3B · S/N 144856 · Cancelled May 10, 2011 · Triennial form not returned · Van Nuys, CA
- [N879RS](https://openairdocs.org/deregistered/N879RS-2011-05-10.md): Douglas TA-3B · S/N 144858 · Cancelled May 10, 2011 · First renewal notice · Built 1959 · Van Nuys, CA
- [N208MD](https://openairdocs.org/deregistered/N208MD-2003-03-27.md): Mcdonnell Douglas F/A 18C · S/N 165219 · Cancelled Mar 27, 2003 · Triennial form not returned · Hazelwood, MO
- [N5382W](https://openairdocs.org/deregistered/N5382W-1999-12-08.md): Dehavilland DHC-7-102 · S/N 95 · Cancelled Dec 8, 1999 · Berryville, VA
- [N547HA](https://openairdocs.org/deregistered/N547HA-1998-09-16.md): Douglas ERA-3B · S/N 144846 · Cancelled Sep 16, 1998 · Triennial form not returned · Van Nuys, CA
- [N208MD](https://openairdocs.org/deregistered/N208MD-1997-12-23.md): Mcdonnell Douglas F/A 18C · S/N 164726 · Cancelled Dec 23, 1997 · Saint Louis, MO
- [N208MD](https://openairdocs.org/deregistered/N208MD-1997-08-28.md): Mcdonnell Douglas F/A 18C · S/N 165208 · Cancelled Aug 28, 1997 · Saint Louis, MO
- [N23SH](https://openairdocs.org/deregistered/N23SH-1976-05-17.md): Bell H13G · S/N 52-7797 · Cancelled May 17, 1976 · Detroit, MI
- [N19929](https://openairdocs.org/deregistered/N19929-1950-09-08-42-102642.md): Boeing B-17G · S/N 42-102642 · Cancelled Sep 8, 1950 · Washington, DC
- [N309](https://openairdocs.org/deregistered/N309-1948-07-14.md): North American SNJ-4 · S/N 9742 · Cancelled Jul 14, 1948 · Built 1942 · Washington, DC
- [N1801](https://openairdocs.org/deregistered/N1801-1948-06-03.md): Grumman G-44A · S/N 37738 · Cancelled Jun 3, 1948 · Built 1945 · Washington 25, DC
- [N277](https://openairdocs.org/deregistered/N277-1948-04-20.md): North American SNJ-4 · S/N 10167 · Cancelled Apr 20, 1948 · Washington, DC
- [N291](https://openairdocs.org/deregistered/N291-1948-04-20.md): North American SNJ-4 · S/N 88-9401 · Cancelled Apr 20, 1948 · Washington, DC
- [N246](https://openairdocs.org/deregistered/N246-1948-03-04.md): Waco SRE · S/N 5090 · Cancelled Mar 4, 1948 · Built 1916 · Washington, DC
- [N7](https://openairdocs.org/deregistered/N7-1947-03-18.md): Beech C18S · S/N 507 · Cancelled Mar 18, 1947 · Washington, DC
- [N391](https://openairdocs.org/deregistered/N391-1947-02-07.md): Beech C18S · S/N 6025 · Cancelled Feb 7, 1947 · Washington, DC
- [N348](https://openairdocs.org/deregistered/N348-1947-01-28.md): North American SNJ-4 · S/N 10267 · Cancelled Jan 28, 1947 · Washington, DC
- [N73](https://openairdocs.org/deregistered/N73-1947-01-28.md): Beech 18S · S/N 364 · Cancelled Jan 28, 1947 · Washington, DC
- [N133](https://openairdocs.org/deregistered/N133-1946-11-07.md): Beech D17S · S/N 415 · Cancelled Nov 7, 1946 · Built 1940 · Washington, DC
- [N18643](https://openairdocs.org/deregistered/N18643-1945-05-09.md): Consolidatedvultee Acft 108 · S/N 42-63780 · Cancelled May 9, 1945 · Washington, DC
- [N37194](https://openairdocs.org/deregistered/N37194-1945-04-15.md): Douglas UNKNOWN DOUGLAS · S/N 42-107447 · Cancelled Apr 15, 1945 · Washington, DC
- [N37719](https://openairdocs.org/deregistered/N37719-1945-04-13.md): Douglas C-54 · S/N 42-107449 · Cancelled Apr 13, 1945 · Washington, DC
- [N19936](https://openairdocs.org/deregistered/N19936-1945-02-10.md): Consolidated C-87 · S/N 42-62787 · Cancelled Feb 10, 1945 · Washington, DC
- [N18618](https://openairdocs.org/deregistered/N18618-1944-11-07.md): Consolidated C-87 · S/N 43-30619 · Cancelled Nov 7, 1944 · Washington, DC
- [N15558](https://openairdocs.org/deregistered/N15558-1944-10-02.md): Consolidated B-24D · S/N 41-23721 · Cancelled Oct 2, 1944
- [N18638](https://openairdocs.org/deregistered/N18638-undated.md): Consolidated C-87 · S/N 43-30625 · Cancellation date not recorded · Washington, DC
- [N18639](https://openairdocs.org/deregistered/N18639-undated.md): Douglas C-47 · S/N 4118492 · Cancellation date not recorded
- [N19135](https://openairdocs.org/deregistered/N19135-undated.md): Consolidated C-87 · S/N 43-30618 · Cancellation date not recorded · Built 1944 · Washington, DC
- [N19136](https://openairdocs.org/deregistered/N19136-undated.md): Consolidated C-87 · S/N 44-39212 · Cancellation date not recorded · Built 1944 · Washington, DC
- [N19943](https://openairdocs.org/deregistered/N19943-undated.md): Douglas C-47A · S/N 43-47971 · Cancellation date not recorded · 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 = 'UNITED STATES GOVERNMENT' OR list_contains(d.other_registrant_names, 'UNITED STATES GOVERNMENT')
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

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