# Earlier aircraft under this name: United States Of America

A list on [United States Of America](https://openairdocs.org/faa-owner/UNITED%20STATES%20OF%20AMERICA.md).

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

- [N455AE](https://openairdocs.org/deregistered/N455AE-2024-07-02.md): Eurocopter AS 350 B2 · S/N 3509 · Cancelled Jul 2, 2024 · Exported to Canada · Washington, DC
- [N910SF](https://openairdocs.org/deregistered/N910SF-2018-01-29.md): Mcdonnell Douglas DC-10-10 · S/N 46524 · Cancelled Jan 29, 2018 · Registration expired, pending cancellation · Built 1972 · Van Nuys, CA
- [N58022](https://openairdocs.org/deregistered/N58022-2015-04-30.md): Beech B200C · S/N BL-88 · Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Washington, DC
- [N5803F](https://openairdocs.org/deregistered/N5803F-2015-04-30.md): Beech B200C · S/N BL-105 · Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Washington, DC
- [N58009](https://openairdocs.org/deregistered/N58009-2014-12-18.md): Beech B200C · S/N BL-83 · Cancelled Dec 18, 2014 · Registration expired, pending cancellation · Washington, DC
- [N5819T](https://openairdocs.org/deregistered/N5819T-2014-12-17.md): Beech B200C · S/N BL-106 · Cancelled Dec 17, 2014 · Registration expired, pending cancellation · Washington, DC
- [N932ML](https://openairdocs.org/deregistered/N932ML-2013-10-28.md): Douglas DC-9-31 · S/N 47547 · Cancelled Oct 28, 2013 · Registration expired, pending cancellation · Built 1971 · China Lake, CA
- [N400BY](https://openairdocs.org/deregistered/N400BY-2005-07-12.md): Gates Learjet 35A · S/N 535 · Cancelled Jul 12, 2005 · Second triennial mailing, no response · Built 1984 · Wright Patterson, OH
- [N3099D](https://openairdocs.org/deregistered/N3099D-1993-08-25.md): Ayres S2R-T65 · S/N T652X · Cancelled Aug 25, 1993 · Triennial form not returned · Washington, DC
- [N3099F](https://openairdocs.org/deregistered/N3099F-1993-08-25.md): Ayres S2R-T65 · S/N T653X · Cancelled Aug 25, 1993 · Triennial form not returned · Washington, DC
- [N3099M](https://openairdocs.org/deregistered/N3099M-1993-08-25.md): Ayres S2R-T65 · S/N T651X · Cancelled Aug 25, 1993 · Triennial form not returned · Washington, DC
- [N4999G](https://openairdocs.org/deregistered/N4999G-1981-07-01.md): North American T-39A · S/N 59-2869 · Cancelled Jul 1, 1981 · Washington, DC
- [N2295V](https://openairdocs.org/deregistered/N2295V-1979-02-12.md): North American T-39A · S/N 592868 · Cancelled Feb 12, 1979 · Washington, DC
- [N88946](https://openairdocs.org/deregistered/N88946-1954-06-04.md): Douglas C54G-DC · S/N 36069 · Cancelled Jun 4, 1954 · New Your 17, NY
- [N88948](https://openairdocs.org/deregistered/N88948-1954-06-04.md): Douglas C54G-DC · S/N 36043 · Cancelled Jun 4, 1954
- [N88953](https://openairdocs.org/deregistered/N88953-1954-06-04.md): Douglas C54G-DC · S/N 35990 · Cancelled Jun 4, 1954 · Washington, DC
- [N88954](https://openairdocs.org/deregistered/N88954-1954-06-04.md): Douglas C54G-DC · S/N 36070 · Cancelled Jun 4, 1954 · Washington, DC
- [N88955](https://openairdocs.org/deregistered/N88955-1954-06-04.md): Douglas C54G-DC · S/N 36039 · Cancelled Jun 4, 1954 · Washington, DC
- [N88958](https://openairdocs.org/deregistered/N88958-1954-06-04.md): Douglas C54-DC · S/N 36073 · Cancelled Jun 4, 1954 · Washington, DC
- [N88959](https://openairdocs.org/deregistered/N88959-1954-06-04.md): Douglas C54G-DC · S/N 36053 · Cancelled Jun 4, 1954 · Built 1945 · Washington, DC
- [N1645M](https://openairdocs.org/deregistered/N1645M-1952-02-21.md): Boeing E75 · S/N 75-8797 · Cancelled Feb 21, 1952
- [N702](https://openairdocs.org/deregistered/N702-1951-08-14.md): Grumman J4F-2 · S/N 1320 · Cancelled Aug 14, 1951 · Chicago, IL
- [N79066](https://openairdocs.org/deregistered/N79066-1948-10-25.md): Douglas C54G-DC · S/N 36052 · Cancelled Oct 25, 1948 · Washington, DC
- [N5577](https://openairdocs.org/deregistered/N5577-1948-03-31.md): Ford 4-AT-B · S/N 23 · Cancelled Mar 31, 1948 · Los Angeles, CA
- [N702](https://openairdocs.org/deregistered/N702-1948-03-31.md): Grumman G-44 · S/N 1350 · Cancelled Mar 31, 1948 · Chicago, IL
- [N90914](https://openairdocs.org/deregistered/N90914-1947-06-12.md): Douglas C-54G · S/N 36007 · Cancelled Jun 12, 1947 · Washington, DC
- [N19410](https://openairdocs.org/deregistered/N19410-1942-01-01.md): Commonwealth REARWIN 6000M · S/N 306 · Cancelled Jan 1, 1942 · Built 1938 · None, OK

## 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 OF AMERICA' OR list_contains(d.other_registrant_names, 'UNITED STATES OF AMERICA')
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

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