# Cancelled registrations: Franklin, NC

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

Cancelled aircraft registrations in Franklin, NC.

- [N55217](https://openairdocs.org/deregistered/N55217-2023-02-04.md): Holderread Terrence C STINGER · S/N 0135 · Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Built 1996 · Pritz Phillip J
- [N300LA](https://openairdocs.org/deregistered/N300LA-2022-11-05.md): IV Go LANCAIR IV · S/N 223 · Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Built 1996 · IV Go
- [N80056](https://openairdocs.org/deregistered/N80056-2021-10-07.md): Cessna 421B · S/N 421B-0654 · Cancelled Oct 7, 2021 · Duotech Services Inc
- [N716TJ](https://openairdocs.org/deregistered/N716TJ-2018-03-05.md): Tony/Janet Shuler JUST ACFT HIGHLANDER · S/N JA225-12-10 · Cancelled Mar 5, 2018 · Registration expired, pending cancellation · Built 2011 · Jess LLC
- [N28140](https://openairdocs.org/deregistered/N28140-2015-05-20.md): Bellanca 17-30A · S/N 80-30980 · Cancelled May 20, 2015 · Registration expired, pending cancellation · Built 1980 · Marion Paul Inc
- [N235UV](https://openairdocs.org/deregistered/N235UV-2015-04-30.md): Cessna 411 · S/N 4110052 · Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1965 · Obrien William J
- [N112PM](https://openairdocs.org/deregistered/N112PM-2013-11-01.md): Pongracz John M NIEUPORT 11 · S/N 012 · Cancelled Nov 1, 2013 · Registration expired, pending cancellation · Built 2004 · Drummond William I
- [N32446](https://openairdocs.org/deregistered/N32446-2012-09-10.md): Piper PA-32-300 · S/N 32-7540041 · Cancelled Sep 10, 2012 · Sale reported, canceled · Built 1974
- [N1744J](https://openairdocs.org/deregistered/N1744J-2012-08-10.md): Piper PA-28-140 · S/N 28-24160 · Cancelled Aug 10, 2012 · Registration expired, pending cancellation · Built 1968 · J Star Inc
- [N4176R](https://openairdocs.org/deregistered/N4176R-2012-06-07.md): Piper PA-32-300 · S/N 32-40499 · Cancelled Jun 7, 2012 · Revoked, canceled · Built 1968 · Gregory Walter C
- [N21423](https://openairdocs.org/deregistered/N21423-2011-08-16.md): Piper PA-32RT-300T · S/N 32R-7887205 · Cancelled Aug 16, 2011 · First renewal notice · Built 1978 · O'Neill Damien
- [N6303A](https://openairdocs.org/deregistered/N6303A-1999-01-28.md): Piper PA-38-112 · S/N 38-78A0374 · Cancelled Jan 28, 1999 · Triennial form not returned · Cribbs William L
- [N97LW](https://openairdocs.org/deregistered/N97LW-1991-04-29.md): Piper PA-23-250 · S/N 277405288 · Cancelled Apr 29, 1991 · Triennial form not returned · Sparrowhawk Inc
- [N46681](https://openairdocs.org/deregistered/N46681-1971-01-19.md): Aeronca 0-58A · S/N 058B-7042 · Cancelled Jan 19, 1971 · Bob Phillips
- [N80852](https://openairdocs.org/deregistered/N80852-1970-06-24.md): Globe GC-1B · S/N 255 · Cancelled Jun 24, 1970 · Mcsween G R
- [N3160K](https://openairdocs.org/deregistered/N3160K-1957-11-29.md): Mooney M-18L · S/N 4 · Cancelled Nov 29, 1957 · Phillips William

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

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