# Cancelled registrations: Piney Flats, TN

A list on [Piney Flats, TN](https://openairdocs.org/faa-place/TN/Piney%20Flats.md).

Cancelled aircraft registrations in Piney Flats, TN.

- [N16BS](https://openairdocs.org/deregistered/N16BS-2021-01-09.md): Cessna 170B · S/N 26028 · Cancelled Jan 9, 2021 · Registration expired, pending cancellation · Built 1953 · Carrier Aviation LLC
- [N6068E](https://openairdocs.org/deregistered/N6068E-2018-06-08.md): Buckeye DREAM MACHINE · S/N 4332 · Cancelled Jun 8, 2018 · Registration expired, pending cancellation · Built 1998 · Cavness Raymond L
- [N9247H](https://openairdocs.org/deregistered/N9247H-2017-07-19.md): Bell UH-1H · S/N 69-15729 · Cancelled Jul 19, 2017 · Registration expired, pending cancellation · Aeronautical Accessories Inc
- [N92514](https://openairdocs.org/deregistered/N92514-2017-07-18.md): Bell UH-1H · S/N 71-20221 · Cancelled Jul 18, 2017 · Registration expired, pending cancellation · Aeronautical Accessories Inc
- [N42294](https://openairdocs.org/deregistered/N42294-2017-07-10.md): Bell UH-1H · S/N 69-15175 · Cancelled Jul 10, 2017 · Registration expired, pending cancellation · Aeronautical Accessories Inc
- [N9249U](https://openairdocs.org/deregistered/N9249U-2017-06-19.md): Bell UH-1H · S/N 70-16292 · Cancelled Jun 19, 2017 · Registration expired, pending cancellation · Aeronautical Accessories Inc
- [N2017H](https://openairdocs.org/deregistered/N2017H-2015-04-24.md): Engineering & Research ERCOUPE 415-C · S/N 2640 · Cancelled Apr 24, 2015 · Registration expired, pending cancellation · Built 1946 · Hawes Kenneth D
- [N1804K](https://openairdocs.org/deregistered/N1804K-2014-09-10.md): Silvaire LUSCOMBE 8E · S/N 4531 · Cancelled Sep 10, 2014 · Registration expired, pending cancellation · Built 1946 · Hawes Kenneth D
- [N430LL](https://openairdocs.org/deregistered/N430LL-2011-12-20.md): Bell 430 · S/N 49081 · Cancelled Dec 20, 2011 · Exported to Nigeria · Built 2001 · Bell Helicopter Textron Inc
- [N337EA](https://openairdocs.org/deregistered/N337EA-2011-11-15.md): Bell Helicopter Textron 206B · S/N 4662 · Cancelled Nov 15, 2011 · Exported to Argentina · Bell Helicopter Textron Inc
- [N55NN](https://openairdocs.org/deregistered/N55NN-2011-11-15.md): Bell 206B · S/N 4489 · Cancelled Nov 15, 2011 · Exported to Argentina · Built 1998 · Bell Helicopter Textron Inc
- [N427TE](https://openairdocs.org/deregistered/N427TE-2009-05-28.md): Bell Helicopter Textron Canada 427 · S/N 56071 · Cancelled May 28, 2009 · Exported to Nigeria · Built 2008 · Edwards & Associates Inc
- [N408BH](https://openairdocs.org/deregistered/N408BH-2008-08-20.md): Bell Helicopter Textron Canada 206B · S/N 4650 · Cancelled Aug 20, 2008 · Exported to Jamaica · Built 2008 · Edwards & Associates Inc
- [N1048G](https://openairdocs.org/deregistered/N1048G-2007-12-05.md): Bell UH-1H · S/N 69-15217 · Cancelled Dec 5, 2007 · Aeronautical Accessories Inc
- [N47HP](https://openairdocs.org/deregistered/N47HP-2007-12-01.md): Bell UH-1H · S/N 74-22469 · Cancelled Dec 1, 2007 · Aeronautical Accessories Inc
- [N70830](https://openairdocs.org/deregistered/N70830-2007-11-20.md): Bell Helicopter Textron Canada 430 · S/N 49113 · Cancelled Nov 20, 2007 · Exported to Angola · Built 2005 · Edwards & Associates Inc
- [N960WB](https://openairdocs.org/deregistered/N960WB-2007-08-01.md): Bell 407 · S/N 53757 · Cancelled Aug 1, 2007 · Exported to Mexico · Edwards & Associates Inc
- [N8010J](https://openairdocs.org/deregistered/N8010J-2007-03-29.md): Bell 427 · S/N 56056 · Cancelled Mar 29, 2007 · Exported to Croatia · Built 2006 · Edwards & Associates Inc
- [N120AJ](https://openairdocs.org/deregistered/N120AJ-1999-12-28.md): Beech 200 · S/N BB-1144 · Cancelled Dec 28, 1999 · Exported to Denmark · Lynn Air Inc
- [N16844](https://openairdocs.org/deregistered/N16844-1999-05-05.md): Bell 206L · S/N 45131 · Cancelled May 5, 1999 · Exported to Canada · Edwards And Associates
- [N58188](https://openairdocs.org/deregistered/N58188-1998-07-17.md): Hughes 269C · S/N 380675 · Cancelled Jul 17, 1998 · Exported to Canada · Edwards And Associates Inc
- [N94CA](https://openairdocs.org/deregistered/N94CA-1997-11-10.md): Bell 206B · S/N 2398 · Cancelled Nov 10, 1997 · Exported to United Kingdom · Edwards And Associates Inc
- [N16751](https://openairdocs.org/deregistered/N16751-1997-05-09.md): Bell 206L · S/N 45092 · Cancelled May 9, 1997 · Exported to Canada · Edwards And Associates Inc
- [N59554](https://openairdocs.org/deregistered/N59554-1995-09-21.md): Bell 206B · S/N 1401 · Cancelled Sep 21, 1995 · Exported to United Kingdom · Edwards And Associates Inc

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

This list as a web page: https://openairdocs.org/faa-place/TN/Piney%20Flats/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, except the copies of manufacturers’ service documents, which belong to their rights holders.
