# Earlier aircraft under this name: Unknown

A list on [Unknown](https://openairdocs.org/faa-owner/UNKNOWN.md).

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

- [N1269H](https://openairdocs.org/deregistered/N1269H-2018-09-14.md): Aeronca 15AC · S/N 15AC-280 · Cancelled Sep 14, 2018 · Revoked, canceled · Built 1948 · White House Sttn, NJ
- [N40601](https://openairdocs.org/deregistered/N40601-2018-01-18.md): Piper PA-23-250 · S/N 27-7405346 · Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Built 1974 · Oklahoma City, OK
- [N8187Z](https://openairdocs.org/deregistered/N8187Z-1991-10-09.md): Lockheed P2V-7 · S/N 147566 · Cancelled Oct 9, 1991 · Exported to Australia
- [N1387J](https://openairdocs.org/deregistered/N1387J-1991-01-18.md): Hastings Francis H AEROSPORT QUAIL · S/N Q547169410 · Cancelled Jan 18, 1991 · Xxx, OK
- [N3431G](https://openairdocs.org/deregistered/N3431G-1980-01-14.md): Consolidated Vultee P4Y-2 · S/N 66313 · Cancelled Jan 14, 1980 · Xxx, OK
- [N3304U](https://openairdocs.org/deregistered/N3304U-1975-01-20.md): Cessna 182F · S/N 18254704 · Cancelled Jan 20, 1975 · Xxx, OK
- [N45621](https://openairdocs.org/deregistered/N45621-1963-09-27.md): Snow 600-S2C · S/N 600-1184C · Cancelled Sep 27, 1963 · Exported to Jamaica · Xxx, OK
- [N3716H](https://openairdocs.org/deregistered/N3716H-1955-03-15.md): Engineering & Research 415-C · S/N 4341 · Cancelled Mar 15, 1955 · Built 1946 · Xxx, OK
- [N2990H](https://openairdocs.org/deregistered/N2990H-1949-08-25.md): Engineering & Research ERCOUPE 415-C · S/N 3615 · Cancelled Aug 25, 1949 · Built 1946 · Xxx, OK
- [N34924](https://openairdocs.org/deregistered/N34924-1948-09-09.md): Nelson BB-1 · S/N 508 · Cancelled Sep 9, 1948 · Xxx, OK
- [N34902](https://openairdocs.org/deregistered/N34902-1948-08-17.md): Lockheed 18-08 · S/N 2088 · Cancelled Aug 17, 1948 · Xxx, OK
- [N34903](https://openairdocs.org/deregistered/N34903-1948-08-17-2084.md): Lockheed 18-40 · S/N 2084 · Cancelled Aug 17, 1948 · Exported to Canada · Xxxx, OK
- [N34903](https://openairdocs.org/deregistered/N34903-1948-08-17-2098.md): Lockheed 18-08 · S/N 2098 · Cancelled Aug 17, 1948 · Exported to Canada · Xxx, OK
- [N34905](https://openairdocs.org/deregistered/N34905-1948-08-17.md): Lockheed 18-08 · S/N 2100 · Cancelled Aug 17, 1948 · Xxx, OK
- [N3707](https://openairdocs.org/deregistered/N3707-1948-03-12.md): Stinson SB-1 · S/N B-103 · Cancelled Mar 12, 1948 · Xxx, OK
- [N5567](https://openairdocs.org/deregistered/N5567-1948-03-12.md): Swallow SWALLOW · S/N 944 · Cancelled Mar 12, 1948 · Xxx, OK
- [N5576](https://openairdocs.org/deregistered/N5576-1948-03-12.md): Fairchild Airplane Mfg FC-2 · S/N 97 · Cancelled Mar 12, 1948 · Xxx, OK
- [N5597](https://openairdocs.org/deregistered/N5597-1948-03-12.md): Advance WACO 10 · S/N 1247 · Cancelled Mar 12, 1948 · Xxx, OK
- [N33K](https://openairdocs.org/deregistered/N33K-1948-01-19.md): White NEW STANDARD D-25A · S/N 201 · Cancelled Jan 19, 1948 · Xxx, OK
- [N3453H](https://openairdocs.org/deregistered/N3453H-1947-12-22.md): Ercoupe 415-C · S/N 4078 · Cancelled Dec 22, 1947 · Xxx, OK
- [N5590](https://openairdocs.org/deregistered/N5590-undated.md): Command-Aire 3C-3 · S/N 504 · Cancellation date not recorded · Xxx, 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 = 'UNKNOWN' OR list_contains(d.other_registrant_names, 'UNKNOWN')
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

This list as a web page: https://openairdocs.org/faa-owner/UNKNOWN/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.
