# Cancelled registrations: Lenoir, NC

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

Cancelled aircraft registrations in Lenoir, NC.

- [N337CT](https://openairdocs.org/deregistered/N337CT-2020-10-31.md): Coffey Arthur M RAF 2000 · S/N 245427766-2 · Cancelled Oct 31, 2020 · Registration expired, pending cancellation · Built 1997 · Coffey Arthur M
- [N43576](https://openairdocs.org/deregistered/N43576-2019-03-02.md): Piper PA-32-300 · S/N 32-7440135 · Cancelled Mar 2, 2019 · Registration expired, pending cancellation · Built 1974 · Worsley John F II
- [N92744](https://openairdocs.org/deregistered/N92744-2019-02-26.md): Golden Circle Air T-BIRD II · S/N 28434 · Cancelled Feb 26, 2019 · Registration expired, pending cancellation · Built 2001 · Proffit Ben R
- [N3085V](https://openairdocs.org/deregistered/N3085V-2018-01-03.md): Beech 35 · S/N D-501 · Cancelled Jan 3, 2018 · Registration expired, pending cancellation · Built 1947 · Moore Freddie H
- [N700HB](https://openairdocs.org/deregistered/N700HB-2017-12-07.md): Cessna 414 · S/N 414-0935 · Cancelled Dec 7, 2017 · Lucky7 Air LLC
- [N1870H](https://openairdocs.org/deregistered/N1870H-2016-09-12.md): Cessna 310C · S/N 35970 · Cancelled Sep 12, 2016 · Revoked, canceled · Built 1959 · Bergsma Brothers
- [N12184](https://openairdocs.org/deregistered/N12184-2016-09-06.md): Cessna 172M · S/N 17261868 · Cancelled Sep 6, 2016 · Built 1973 · Lenoir Aviation Club Inc
- [N9202U](https://openairdocs.org/deregistered/N9202U-2005-12-30.md): Cessna 150M · S/N 15078153 · Cancelled Dec 30, 2005 · Triennial form not returned · Built 1976 · Lenoir Aviation Club
- [N332DD](https://openairdocs.org/deregistered/N332DD-1998-11-16.md): Piper PA-32-300 · S/N 327840072 · Cancelled Nov 16, 1998 · Second triennial mailing, no response · Keller Sam
- [N39533](https://openairdocs.org/deregistered/N39533-1996-04-30.md): Piper PA-28-161 · S/N 287816667 · Cancelled Apr 30, 1996 · Exported to Malaysia · Blue Ridge Aviation Inc
- [N6897L](https://openairdocs.org/deregistered/N6897L-1986-03-13.md): Piper AEROSTAR 602P · S/N 62P-0932-8165055 · Cancelled Mar 13, 1986 · Buss Automation Inc
- [N42242](https://openairdocs.org/deregistered/N42242-1957-04-04.md): Piper J3C-65 · S/N 14492 · Cancelled Apr 4, 1957 · Lenoir Aviation Club Inc
- [N4347M](https://openairdocs.org/deregistered/N4347M-1957-02-15.md): Piper PA-12 · S/N 12-3285 · Cancelled Feb 15, 1957 · Sisk Jr H C & J I Smith
- [N586M](https://openairdocs.org/deregistered/N586M-1948-02-17.md): Moth 60-GM · S/N 87 · Cancelled Feb 17, 1948 · Built 1929 · Terrell Flying Service / Terrell John W
- [N17059](https://openairdocs.org/deregistered/N17059-1943-07-28.md): Cessna C-37 · S/N 342 · Cancelled Jul 28, 1943 · Crowell Herbert Oliver
- [N170M](https://openairdocs.org/deregistered/N170M-1941-10-15.md): New Standard D-29A · S/N 1024 · Cancelled Oct 15, 1941 · Built 1929 · Terrell John Willis
- [N20046](https://openairdocs.org/deregistered/N20046-1940-01-25.md): Taylor J-2 · S/N 1846 · Cancelled Jan 25, 1940 · Built 1937 · Michael William E
- [N15019](https://openairdocs.org/deregistered/N15019-1936-07-18.md): Taylor E-2 · S/N 181 · Cancelled Jul 18, 1936 · Built 1935 · Terrell John W

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

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