# Earlier aircraft under this name: United States Navy

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

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

- [N7367N](https://openairdocs.org/deregistered/N7367N-2022-09-03.md): DJI INSPIRE 1 · S/N W13DCL21061412 · Cancelled Sep 3, 2022 · Registration expired, pending cancellation · Usn-Ncis, San Diego, CA
- [N599AU](https://openairdocs.org/deregistered/N599AU-2022-06-04.md): DJI INSPIRE 1 · S/N W13DCG08040246 · Cancelled Jun 4, 2022 · Registration expired, pending cancellation · Usn-Ncis, San Diego, CA
- [N5472U](https://openairdocs.org/deregistered/N5472U-2021-10-23.md): DJI PHANTOM 2 · S/N PH645456887 · Cancelled Oct 23, 2021 · Registration expired, pending cancellation · San Diego, CA
- [N527QN](https://openairdocs.org/deregistered/N527QN-2021-01-30.md): United States Navy-Naval Crimi PHANTOM 2 · S/N PH636139292 · Cancelled Jan 30, 2021 · Registration expired, pending cancellation · San Diego, CA
- [N4028Y](https://openairdocs.org/deregistered/N4028Y-2018-01-18.md): Beech D-45 · S/N BG-276 · Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Built 1956 · Willow Grove, PA
- [N20783](https://openairdocs.org/deregistered/N20783-2013-10-29.md): Beech D-45 · S/N BG-73 · Cancelled Oct 29, 2013 · Registration expired, pending cancellation · Built 1955 · Oak Harbor, WA
- [N9980Q](https://openairdocs.org/deregistered/N9980Q-2013-10-28.md): Beech T-34B · S/N BG-377 · Cancelled Oct 28, 2013 · Registration expired, pending cancellation · Built 1957 · Kansas City, MO
- [N4989E](https://openairdocs.org/deregistered/N4989E-2013-08-15.md): Vulcoon S-60 · S/N S-60-101 · Cancelled Aug 15, 2013 · Registration expired, pending cancellation · Built 1965 · China Lake, CA
- [N2782D](https://openairdocs.org/deregistered/N2782D-2013-06-13.md): Raven S55A · S/N S55A-1072 · Cancelled Jun 13, 2013 · Registration expired, pending cancellation · Built 1985 · China Lake, CA
- [N27814](https://openairdocs.org/deregistered/N27814-2013-04-25.md): Raven Industries S77A · S/N S77A-114 · Cancelled Apr 25, 2013 · Registration expired, pending cancellation · Built 1985 · China Lake, CA
- [N4028A](https://openairdocs.org/deregistered/N4028A-2012-11-15.md): Beech D-45 · S/N BG-297 · Cancelled Nov 15, 2012 · Registration expired, pending cancellation · Built 1961 · Willow Grove, PA
- [N85993](https://openairdocs.org/deregistered/N85993-2009-07-21.md): Beech D-45 · S/N BG-92 · Cancelled Jul 21, 2009 · Triennial form not returned · Built 1955 · Kansas City, MO
- [N9775Q](https://openairdocs.org/deregistered/N9775Q-2004-08-27.md): Beech T42 · S/N 65-12694 · Cancelled Aug 27, 2004 · Triennial form not returned · Built 1965 · Nas Jacksonville, FL
- [N172LS](https://openairdocs.org/deregistered/N172LS-1994-02-10.md): Cessna 172N · S/N 17270248 · Cancelled Feb 10, 1994 · Triennial form not returned · Oak Harbor, WA
- [N54339](https://openairdocs.org/deregistered/N54339-1992-01-17.md): Beech 95-B55 (T42A) · S/N TF63 · Cancelled Jan 17, 1992 · Moffett Filed, CA
- [N6367T](https://openairdocs.org/deregistered/N6367T-1984-07-16.md): Beech D-45 (T-34B) · S/N BG-290 · Cancelled Jul 16, 1984 · New York, NY
- [N7945C](https://openairdocs.org/deregistered/N7945C-1981-10-26.md): Beech T-34B · S/N BG301 · Cancelled Oct 26, 1981 · San Diego, CA
- [N114RA](https://openairdocs.org/deregistered/N114RA-1981-10-15.md): Dehavilland BEAVER DHC-2 MK.1 · S/N 1346 · Cancelled Oct 15, 1981 · Administratively canceled · San Diego, CA
- [N46939](https://openairdocs.org/deregistered/N46939-1981-05-06.md): Beech T-34B · S/N BG266 · Cancelled May 6, 1981 · Grand Prairie, TX
- [N116MD](https://openairdocs.org/deregistered/N116MD-1979-04-20.md): Douglas A-4B · S/N 11370 · Cancelled Apr 20, 1979
- [N905MD](https://openairdocs.org/deregistered/N905MD-1979-04-19.md): Douglas A-4B · S/N 11967 · Cancelled Apr 19, 1979 · Long Beach, CA
- [N96081](https://openairdocs.org/deregistered/N96081-1978-03-27.md): Beech T-34B · S/N 140746 · Cancelled Mar 27, 1978
- [N12427](https://openairdocs.org/deregistered/N12427-1976-05-28.md): Beech D-45 (T-34B) · S/N BG-356 · Cancelled May 28, 1976 · Built 1957 · Seattle, WA
- [N16603](https://openairdocs.org/deregistered/N16603-1976-05-13.md): Beech JRB-4 · S/N 90533 · Cancelled May 13, 1976 · San Francisco, CA
- [N74891](https://openairdocs.org/deregistered/N74891-1971-02-10.md): Beech D-45 · S/N BG-126 · Cancelled Feb 10, 1971 · Norfolk, VA
- [N41283](https://openairdocs.org/deregistered/N41283-1948-09-13.md): Piper J3C-65 · S/N 7929 · Cancelled Sep 13, 1948 · Built 1941 · 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 NAVY' OR list_contains(d.other_registrant_names, 'UNITED STATES NAVY')
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

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