# Cancelled registrations: Ernul, NC

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

Cancelled aircraft registrations in Ernul, NC.

- [N8397U](https://openairdocs.org/deregistered/N8397U-2018-01-09.md): Cessna 150M · S/N 15077932 · Cancelled Jan 9, 2018 · Registration expired, pending cancellation · Built 1976 · Air New Bern Inc
- [N66280](https://openairdocs.org/deregistered/N66280-2018-01-08.md): Cessna 150M · S/N 15075973 · Cancelled Jan 8, 2018 · Registration expired, pending cancellation · Built 1974 · Air New Bern Inc
- [N737JV](https://openairdocs.org/deregistered/N737JV-2018-01-08.md): Cessna 172N · S/N 17269461 · Cancelled Jan 8, 2018 · Registration expired, pending cancellation · Built 1977 · Air New Bern Inc
- [N63513](https://openairdocs.org/deregistered/N63513-2018-01-05.md): Cessna 150M · S/N 15077361 · Cancelled Jan 5, 2018 · Registration expired, pending cancellation · Built 1975 · Air New Bern Inc
- [N4208P](https://openairdocs.org/deregistered/N4208P-2018-01-04.md): Piper PA-23-160 · S/N 23-1699 · Cancelled Jan 4, 2018 · Registration expired, pending cancellation · Built 1959 · Air New Bern Inc
- [N4225P](https://openairdocs.org/deregistered/N4225P-2018-01-04.md): Piper PA-23-160 · S/N 23-1721 · Cancelled Jan 4, 2018 · Registration expired, pending cancellation · Built 1959 · Air New Bern Inc
- [N7573D](https://openairdocs.org/deregistered/N7573D-2017-10-26.md): Cessna 172N · S/N 17272924 · Cancelled Oct 26, 2017 · Registration expired, pending cancellation · Built 1979 · Air New Bern Inc
- [N4455P](https://openairdocs.org/deregistered/N4455P-2015-04-30.md): Piper PA-23 · S/N 23-1972 · Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1961 · Air New Bern Inc
- [N9308U](https://openairdocs.org/deregistered/N9308U-2014-11-24.md): Cessna 150M · S/N 15078258 · Cancelled Nov 24, 2014 · Registration expired, pending cancellation · Built 1976 · Proctor Paul F
- [N19529](https://openairdocs.org/deregistered/N19529-2014-09-10.md): Cessna 150L · S/N 15074474 · Cancelled Sep 10, 2014 · Registration expired, pending cancellation · Built 1973 · Air New Bern Inc
- [N1310U](https://openairdocs.org/deregistered/N1310U-2014-09-03.md): Piper PA-23-160 · S/N 23-1695 · Cancelled Sep 3, 2014 · Registration expired, pending cancellation · Built 1959 · Air New Bern Inc
- [N1494E](https://openairdocs.org/deregistered/N1494E-2013-10-25.md): Cessna 172N · S/N 17271023 · Cancelled Oct 25, 2013 · Registration expired, pending cancellation · Built 1978 · Air New Bern Inc
- [N88076](https://openairdocs.org/deregistered/N88076-2013-09-12.md): Bellanca 7KCAB · S/N 463-74 · Cancelled Sep 12, 2013 · Registration expired, pending cancellation · Built 1974 · Air New Bern Inc
- [N6194G](https://openairdocs.org/deregistered/N6194G-2013-08-19.md): Cessna 150K · S/N 15071694 · Cancelled Aug 19, 2013 · Registration expired, pending cancellation · Built 1969 · Air New Bern Inc
- [N6484K](https://openairdocs.org/deregistered/N6484K-2013-08-19.md): Cessna 150M · S/N 15077724 · Cancelled Aug 19, 2013 · Registration expired, pending cancellation · Built 1975 · Air New Bern Inc
- [N4368P](https://openairdocs.org/deregistered/N4368P-2012-11-21.md): Piper PA-23-160 · S/N 23-1868 · Cancelled Nov 21, 2012 · Registration expired, pending cancellation · Built 1959 · Proctor Paul F

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

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