# Earlier aircraft under this name: Adams John C L

A list on [Adams John C L](https://openairdocs.org/faa-owner/ADAMS%20JOHN%20C%20L.md).

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

- [N5655P](https://openairdocs.org/deregistered/N5655P-1966-04-11.md): Piper PA-24-250 · S/N 24-726 · Cancelled Apr 11, 1966 · San Angelo, TX
- [N4840H](https://openairdocs.org/deregistered/N4840H-1955-05-09.md): Piper PA-17 · S/N 17-137 · Cancelled May 9, 1955 · Exported to Panama · San Angelo, TX
- [N4541H](https://openairdocs.org/deregistered/N4541H-1955-02-04.md): Piper PA-15 · S/N 15-314 · Cancelled Feb 4, 1955 · Exported to Panama · San Angelo, TX
- [N3331B](https://openairdocs.org/deregistered/N3331B-1954-06-22.md): Piper PA-22-135 · S/N 22-2146 · Cancelled Jun 22, 1954 · Exported to Panama · Fort Worth, TX
- [N2324A](https://openairdocs.org/deregistered/N2324A-1953-04-21.md): Piper PA-18 · S/N 18-1899 · Cancelled Apr 21, 1953 · Exported to Panama · Philadelphia, PA
- [N6889K](https://openairdocs.org/deregistered/N6889K-1950-05-12.md): Piper PA-16 · S/N 16-733 · Cancelled May 12, 1950 · Panama City
- [N5339H](https://openairdocs.org/deregistered/N5339H-1949-10-18.md): Piper PA-16 · S/N 16-146 · Cancelled Oct 18, 1949 · Exported to Panama · Panama City
- [N4826H](https://openairdocs.org/deregistered/N4826H-1949-05-09.md): Piper PA-17 · S/N 17-123 · Cancelled May 9, 1949 · Exported to Costa Rica · Philadelphia, PA
- [N4922H](https://openairdocs.org/deregistered/N4922H-1949-05-09.md): Piper PA-11 · S/N 11-789 · Cancelled May 9, 1949 · Exported to Costa Rica · Philadelphia, PA
- [N6618K](https://openairdocs.org/deregistered/N6618K-1948-08-12.md): Republic RC-3 · S/N 891 · Cancelled Aug 12, 1948 · Exported to Panama · Philadelphia, PA
- [N1543N](https://openairdocs.org/deregistered/N1543N-1948-04-02.md): Piper J3C-65 · S/N 23075 · Cancelled Apr 2, 1948 · Built 1947 · Atlantic City, NJ
- [N92734](https://openairdocs.org/deregistered/N92734-1947-04-19.md): Piper PA-12 · S/N 12-171 · Cancelled Apr 19, 1947 · Atlantic City, NJ
- [N92726](https://openairdocs.org/deregistered/N92726-1947-04-16.md): Piper PA-12 · S/N 12-162 · Cancelled Apr 16, 1947 · Exported to Panama · Atlantic City, NJ
- [N98108](https://openairdocs.org/deregistered/N98108-1947-04-16.md): Piper J3C-65 · S/N 18267 · Cancelled Apr 16, 1947 · Atlantic City, NJ
- [N98113](https://openairdocs.org/deregistered/N98113-1947-04-16.md): Piper J3C-65 · S/N 18262 · Cancelled Apr 16, 1947 · Atlantic City, NJ
- [N98130](https://openairdocs.org/deregistered/N98130-1947-04-16.md): Piper J3C-65 · S/N 18285 · Cancelled Apr 16, 1947 · Atlantic City, NJ
- [N98151](https://openairdocs.org/deregistered/N98151-1947-04-16.md): Piper J3C-65 · S/N 18312 · Cancelled Apr 16, 1947 · Atlantic City, NJ
- [N98167](https://openairdocs.org/deregistered/N98167-1947-04-16.md): Piper J3C-65 · S/N 18328 · Cancelled Apr 16, 1947 · Atlantic City, NJ

## 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 = 'ADAMS JOHN C L' OR list_contains(d.other_registrant_names, 'ADAMS JOHN C L')
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

This list as a web page: https://openairdocs.org/faa-owner/ADAMS%20JOHN%20C%20L/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.