# Cancelled registrations: Clinton, NC

A list on [Clinton, NC](https://openairdocs.org/faa-place/NC/Clinton.md).

Cancelled aircraft registrations in Clinton, NC.

- [N26878](https://openairdocs.org/deregistered/N26878-2023-05-06.md): Piper J4A · S/N 4-933 · Cancelled May 6, 2023 · Sale reported, canceled · Built 1940
- [N41082](https://openairdocs.org/deregistered/N41082-2023-01-14.md): Piper J3C-65 · S/N 7726 · Cancelled Jan 14, 2023 · Sale reported, canceled · Built 1941
- [N2517P](https://openairdocs.org/deregistered/N2517P-2020-10-03.md): Mclamb Daniel B N-3-PUP · S/N 1 · Cancelled Oct 3, 2020 · Registration expired, pending cancellation · Built 2007 · Mclamb Daniel B
- [N7025S](https://openairdocs.org/deregistered/N7025S-2017-07-18.md): Cessna 150H · S/N 15067725 · Cancelled Jul 18, 2017 · Registration expired, pending cancellation · Built 1967 · Hobbs Elwood F
- [N658V](https://openairdocs.org/deregistered/N658V-2014-11-12.md): Beech M35 · S/N D-6319 · Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1960 · Clinton Flying Service Inc
- [N157DB](https://openairdocs.org/deregistered/N157DB-2013-12-02.md): Burgess David E ISON MINIMAX · S/N 2521P · Cancelled Dec 2, 2013 · Third renewal notice · Built 2005 · Merritt Don E
- [N37638](https://openairdocs.org/deregistered/N37638-2013-10-29.md): Parsons Walter E CASSUTT II M · S/N 198 · Cancelled Oct 29, 2013 · Registration expired, pending cancellation · Parsons Walter E
- [N95884](https://openairdocs.org/deregistered/N95884-2013-03-20.md): Taylorcraft BC12-D · S/N 8184 · Cancelled Mar 20, 2013 · Sale reported, canceled · Built 1946
- [N5717](https://openairdocs.org/deregistered/N5717-2013-02-01.md): Pitts Special S-1C · S/N 1 · Cancelled Feb 1, 2013 · Sale reported, canceled · Built 1975
- [N4069B](https://openairdocs.org/deregistered/N4069B-1992-08-13.md): Balloon Works FIREFLY 7 · S/N 10087 · Cancelled Aug 13, 1992 · Triennial form not returned · Held Louis E Jr
- [N92785](https://openairdocs.org/deregistered/N92785-1991-11-19.md): Cessna 182N · S/N 18260354 · Cancelled Nov 19, 1991 · Triennial form not returned · Barwick Hugh B Jr
- [N206JB](https://openairdocs.org/deregistered/N206JB-1991-03-28.md): Bradshaw Jimmie/Jerry QUICKIE 200 · S/N 2060 · Cancelled Mar 28, 1991 · Triennial form not returned · Bradshaw Jimmie R
- [N1811R](https://openairdocs.org/deregistered/N1811R-1982-07-22.md): Cessna R182 · S/N R18200570 · Cancelled Jul 22, 1982 · Administratively canceled · Kennedy Aaron E Jr
- [N30JL](https://openairdocs.org/deregistered/N30JL-1976-07-21.md): Lowers R2 · S/N 11-69 · Cancelled Jul 21, 1976 · Built 1970 · Lowers Jack
- [N72836](https://openairdocs.org/deregistered/N72836-1974-10-01.md): Cessna 140 · S/N 10025 · Cancelled Oct 1, 1974 · Lowers Jack
- [N66LM](https://openairdocs.org/deregistered/N66LM-1972-06-15.md): Lowers Minges L & M SPECIAL · S/N 4-71 · Cancelled Jun 15, 1972 · Jack Lowers And Richard Minges Jr
- [N8038X](https://openairdocs.org/deregistered/N8038X-1971-03-17.md): Cessna 172B · S/N 17248538 · Cancelled Mar 17, 1971 · Clinton Flying Service Inc
- [N4736C](https://openairdocs.org/deregistered/N4736C-1971-01-12.md): Piper J3C-65 · S/N 4979 MOD · Cancelled Jan 12, 1971 · Jack Lowers
- [N70684](https://openairdocs.org/deregistered/N70684-1971-01-04.md): Piper J3C-65 · S/N 17704 · Cancelled Jan 4, 1971 · Lowers Jack
- [N42425](https://openairdocs.org/deregistered/N42425-1970-09-03.md): Piper J3C-65 · S/N 14687 · Cancelled Sep 3, 1970 · Lowers Jack
- [N9751E](https://openairdocs.org/deregistered/N9751E-1947-10-09.md): Aeronca 11AC · S/N 11AC-1394 · Cancelled Oct 9, 1947 · Built 1946 · Gale S M

## 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_state = 'NC' AND d.registrant_city = 'CLINTON'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

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