# Cancelled registrations: Havelock, NC

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

Cancelled aircraft registrations in Havelock, NC.

- [N19292](https://openairdocs.org/deregistered/N19292-2018-03-21.md): Cessna 150L · S/N 15074310 · Cancelled Mar 21, 2018 · Registration expired, pending cancellation · Built 1973 · Knelson Jan Eric
- [N99415](https://openairdocs.org/deregistered/N99415-2017-11-21.md): Engineering & Research ERCOUPE 415-C · S/N 2038 · Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Smith Richard W
- [N7801](https://openairdocs.org/deregistered/N7801-2017-02-04.md): Rose-Knight Twister BI-PLANE · S/N 29429 · Cancelled Feb 4, 2017 · Revoked, canceled · Built 1970 · Jones William T
- [N1918N](https://openairdocs.org/deregistered/N1918N-2015-10-06.md): Davis Christopher A EARLY BIRD JENNY · S/N CADEBJ001 · Cancelled Oct 6, 2015 · Third renewal notice · Built 1999 · Davis Christopher A
- [N9181X](https://openairdocs.org/deregistered/N9181X-2015-05-11.md): Forsythe Lance L CHALLANGER I · S/N 0588B0248 · Cancelled May 11, 2015 · Registration expired, pending cancellation · Built 1989 · Forsythe Lance L
- [N37866](https://openairdocs.org/deregistered/N37866-2014-12-17.md): Garriques BENSEN B-8M · S/N BWH-1 · Cancelled Dec 17, 2014 · Registration expired, pending cancellation · Built 1977 · Newhaus Jerrel E
- [N4673H](https://openairdocs.org/deregistered/N4673H-2012-12-11.md): Piper PA-17 · S/N 17-76 · Cancelled Dec 11, 2012 · Registration expired, pending cancellation · Built 1948 · Landess Rm
- [N6957W](https://openairdocs.org/deregistered/N6957W-2011-08-08.md): Piper PA-28-140 · S/N 28-21149 · Cancelled Aug 8, 2011 · Revoked, pending cancellation · Built 1965 · Jerrys Sweet Shop
- [N319JM](https://openairdocs.org/deregistered/N319JM-1995-06-27.md): Christen Industries PITTS S-2B · S/N 5213 · Cancelled Jun 27, 1995 · Exported to France · Burgin Joe C III
- [N60448](https://openairdocs.org/deregistered/N60448-1980-09-22.md): Cessna 150J · S/N 15070315 · Cancelled Sep 22, 1980 · Cherry Point Marine Aero Club
- [N1195H](https://openairdocs.org/deregistered/N1195H-1975-12-04.md): Aeronca 15AC · S/N 15AC-207 · Cancelled Dec 4, 1975 · Exported to Canada · Meath Anthony R & Linda Meath
- [N3294](https://openairdocs.org/deregistered/N3294-1975-04-08.md): Leak BENSEN B-8M · S/N 445 · Cancelled Apr 8, 1975 · Leak Robert J
- [N51269](https://openairdocs.org/deregistered/N51269-1971-03-19.md): Cessna 150J · S/N 15069884 · Cancelled Mar 19, 1971 · Cherry Point Aero Club Inc
- [N6229M](https://openairdocs.org/deregistered/N6229M-1965-05-20.md): Stinson 108-3 · S/N 108-4229 · Cancelled May 20, 1965 · Eugene C Lambright
- [N49690](https://openairdocs.org/deregistered/N49690-1948-11-09.md): Boeing A75N1 · S/N 75-4451 · Cancelled Nov 9, 1948 · Charles M Vellines
- [N222K](https://openairdocs.org/deregistered/N222K-1929-10-31.md): Arrow Aircraft & Motors ARROW SPORT · S/N 421 · Cancelled Oct 31, 1929 · Arrow Aircraft & Motor Corp

## 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 = 'HAVELOCK'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

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