# Earlier aircraft under this name: Department Of Commerce

A list on [Department Of Commerce](https://openairdocs.org/faa-owner/DEPARTMENT%20OF%20COMMERCE.md).

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

- [N765UC](https://openairdocs.org/deregistered/N765UC-2022-11-05.md): Aerial Imaging Solutionsllc APQ-18 · S/N 002 · Cancelled Nov 5, 2022 · Registration expired, pending cancellation · La Jolla, CA
- [N6584P](https://openairdocs.org/deregistered/N6584P-2022-06-04.md): Aerial Imaging Solutions APH-22 · S/N 017 · Cancelled Jun 4, 2022 · Registration expired, pending cancellation · La Jolla, CA
- [N658XC](https://openairdocs.org/deregistered/N658XC-2022-06-04.md): Aerial Imaging Solutions APH-22 · S/N 020 · Cancelled Jun 4, 2022 · Registration expired, pending cancellation · La Jolla, CA
- [N659CN](https://openairdocs.org/deregistered/N659CN-2022-06-04.md): Aerial Imaging Solutions APH-22 · S/N 018 · Cancelled Jun 4, 2022 · Registration expired, pending cancellation · La Jolla, CA
- [N659JA](https://openairdocs.org/deregistered/N659JA-2022-06-04.md): Aerial Imaging Solutions APH-22 · S/N 019 · Cancelled Jun 4, 2022 · Registration expired, pending cancellation · La Jolla, CA
- [N545HN](https://openairdocs.org/deregistered/N545HN-2022-02-05.md): Aerial Imaging Solutions APH-22 · S/N 008 · Cancelled Feb 5, 2022 · Registration expired, pending cancellation · La Jolla, CA
- [N581YB](https://openairdocs.org/deregistered/N581YB-2022-02-05.md): Aerial Imaging Solutionsllc APQ-18 · S/N 001 · Cancelled Feb 5, 2022 · Registration expired, pending cancellation · La Jolla, CA
- [N563SN](https://openairdocs.org/deregistered/N563SN-2021-10-02.md): Aerial Imaging Solutions APH-22 · S/N 009 · Cancelled Oct 2, 2021 · Registration expired, pending cancellation · La Jolla, CA
- [N5341D](https://openairdocs.org/deregistered/N5341D-2021-05-08.md): Aerovironment RQ-20A PUMA AE · S/N 1725 · Cancelled May 8, 2021 · Registration expired, pending cancellation · Lakeland, FL
- [N535VA](https://openairdocs.org/deregistered/N535VA-2021-05-08.md): Aerovironment RQ-20A PUMA AE · S/N 1724 · Cancelled May 8, 2021 · Registration expired, pending cancellation · Lakeland, FL
- [N535XA](https://openairdocs.org/deregistered/N535XA-2021-05-08.md): Aerovironment RQ-20A PUMA AE · S/N 1727 · Cancelled May 8, 2021 · Registration expired, pending cancellation · Lakeland, FL
- [N536JN](https://openairdocs.org/deregistered/N536JN-2021-05-08.md): Microdrones MD4-1000 · S/N 103 · Cancelled May 8, 2021 · Registration expired, pending cancellation · Lakeland, FL
- [N556AZ](https://openairdocs.org/deregistered/N556AZ-2018-10-23.md): Nasa Langley Research Center BEBOP DRONE #1 · S/N PH645337044 · Cancelled Oct 23, 2018 · Registration expired, pending cancellation · Gloucester, MA
- [N981](https://openairdocs.org/deregistered/N981-1995-07-25.md): Bell UH-1F · S/N 657936 · Cancelled Jul 25, 1995 · Administratively canceled · Rockville, MD
- [N223](https://openairdocs.org/deregistered/N223-1954-03-23.md): Stinson L-5G · S/N 76-3599 · Cancelled Mar 23, 1954 · Built 1945 · Washington, DC
- [N103](https://openairdocs.org/deregistered/N103-1952-07-10.md): Grumman JRF-5 · S/N B-110 · Cancelled Jul 10, 1952 · Washington, DC
- [N68](https://openairdocs.org/deregistered/N68-1951-01-29.md): Beech C18S · S/N 5659 · Cancelled Jan 29, 1951 · Washington, DC
- [N219](https://openairdocs.org/deregistered/N219-1950-10-31.md): Beech C18S · S/N 6063 · Cancelled Oct 31, 1950 · Built 1944 · Washington, DC
- [N55](https://openairdocs.org/deregistered/N55-1948-12-23.md): Beech C18S · S/N 521 · Cancelled Dec 23, 1948 · Oklahoma City, OK
- [N213](https://openairdocs.org/deregistered/N213-1948-08-27.md): Beech D17S · S/N 423 · Cancelled Aug 27, 1948 · Built 1942 · Washington, DC
- [N292](https://openairdocs.org/deregistered/N292-1948-07-15.md): North American SNJ-4 · S/N 9447 · Cancelled Jul 15, 1948 · Built 1942 · Washington25, DC
- [N387](https://openairdocs.org/deregistered/N387-1948-07-15.md): North American SNJ-4 · S/N 88-9561 · Cancelled Jul 15, 1948 · Washington, DC
- [N296](https://openairdocs.org/deregistered/N296-1948-07-14.md): North American SNJ-4 · S/N 889476 · Cancelled Jul 14, 1948 · Washington, DC
- [N279](https://openairdocs.org/deregistered/N279-1948-06-09.md): North American SNJ-4 · S/N 88-11229 · Cancelled Jun 9, 1948 · Built 1942 · Washington, DC
- [N280](https://openairdocs.org/deregistered/N280-1948-03-09.md): North American SNJ-4 · S/N 10773 · Cancelled Mar 9, 1948 · Washington Dc, DC
- [N63](https://openairdocs.org/deregistered/N63-1947-01-28.md): Beech D17S · S/N 4881 · Cancelled Jan 28, 1947 · Washington, DC
- [N729](https://openairdocs.org/deregistered/N729-1946-02-14.md): Luscombe 8A · S/N 1758 · Cancelled Feb 14, 1946 · Washington, DC
- [N183](https://openairdocs.org/deregistered/N183-1946-01-17.md): Waco UPF-7 · S/N 5602 · Cancelled Jan 17, 1946 · Washington, DC
- [N5](https://openairdocs.org/deregistered/N5-1945-10-30.md): Bellanca SKYROCKET F · S/N 805 · Cancelled Oct 30, 1945 · Washington, DC
- [N63](https://openairdocs.org/deregistered/N63-1937-01-01.md): Stinson SR-5E · S/N 9342-A · Cancelled Jan 1, 1937 · 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 = 'DEPARTMENT OF COMMERCE' OR list_contains(d.other_registrant_names, 'DEPARTMENT OF COMMERCE')
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

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