# Cancelled registrations: Blountville, TN

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

Cancelled aircraft registrations in Blountville, TN.

- [N3203C](https://openairdocs.org/deregistered/N3203C-2022-05-07.md): Beech E35 · S/N D-3876 · Cancelled May 7, 2022 · Registration expired, pending cancellation · Built 1954 · Northeast State Community College
- [N737RC](https://openairdocs.org/deregistered/N737RC-2019-09-04.md): Cessna 172N · S/N 17269607 · Cancelled Sep 4, 2019 · Registration expired, pending cancellation · Built 1977 · Advanced Flight Inc
- [N2GY](https://openairdocs.org/deregistered/N2GY-2018-03-13.md): Schempp-Hirth STANDARD CIRRUS · S/N 71 · Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Built 1970 · Godsey Frederick G
- [N5845E](https://openairdocs.org/deregistered/N5845E-2013-04-23.md): Cessna 150 · S/N 17345 · Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1959 · Lovelace Roy
- [N7412G](https://openairdocs.org/deregistered/N7412G-2012-10-22.md): Cessna 172K · S/N 17259112 · Cancelled Oct 22, 2012 · Registration expired · Built 1970 · Skycrafters Incorporated
- [N74WC](https://openairdocs.org/deregistered/N74WC-2011-06-08.md): Cessna 172M · S/N 17262555 · Cancelled Jun 8, 2011 · Third renewal notice · Built 1973 · Skycrafters Inc
- [N83RH](https://openairdocs.org/deregistered/N83RH-2008-10-24.md): Bell 206B · S/N 1246 · Cancelled Oct 24, 2008 · Exported to United Kingdom · Built 1972 · Apple International Inc
- [N206KH](https://openairdocs.org/deregistered/N206KH-2007-08-08.md): Bell 206L-3 · S/N 51519 · Cancelled Aug 8, 2007 · Exported to Poland · Built 1991 · Apple International Inc
- [N206LS](https://openairdocs.org/deregistered/N206LS-2007-02-05.md): Bell 206L-3 · S/N 51070 · Cancelled Feb 5, 2007 · Exported to United Kingdom · Built 1983 · Apple International Inc
- [N8592X](https://openairdocs.org/deregistered/N8592X-2007-01-30.md): Bell 206L-3 · S/N 51508 · Cancelled Jan 30, 2007 · Exported to Canada · Built 1991 · Apple International Inc
- [N2XT](https://openairdocs.org/deregistered/N2XT-2000-05-15.md): Piper PA-32R-300 · S/N 32R-7680108 · Cancelled May 15, 2000 · Triennial form not returned · Skycrafters Inc
- [N3187X](https://openairdocs.org/deregistered/N3187X-2000-05-11.md): Cessna 150G · S/N 15064587 · Cancelled May 11, 2000 · Advanced Flight Inc
- [N248](https://openairdocs.org/deregistered/N248-1998-10-01.md): Shaffer Charles A CGS HAWK · S/N HII028R · Cancelled Oct 1, 1998 · Triennial form not returned · Shaffer Charles A
- [N77MN](https://openairdocs.org/deregistered/N77MN-1981-05-28.md): Bell 206B · S/N 2168 · Cancelled May 28, 1981 · Exported to Canada · Edwards & Associates Inc
- [N67219](https://openairdocs.org/deregistered/N67219-1981-03-05.md): Bell 206B · S/N 420 · Cancelled Mar 5, 1981 · Exported to Canada · Aeronautical Accessories Inc
- [N42JC](https://openairdocs.org/deregistered/N42JC-1981-03-03.md): Bell Helicopter Textron 206B · S/N 2240 · Cancelled Mar 3, 1981 · Exported to Canada · Built 1977 · Edwards & Associates Inc
- [N10YB](https://openairdocs.org/deregistered/N10YB-1980-11-07.md): Bell 206B · S/N 1393 · Cancelled Nov 7, 1980 · Exported to Canada · Built 1974 · Edwards And Associates Inc
- [N49729](https://openairdocs.org/deregistered/N49729-1980-09-03.md): Bell 206L · S/N 45023 · Cancelled Sep 3, 1980 · Exported to Canada · Edwards & Associates Inc
- [N12SM](https://openairdocs.org/deregistered/N12SM-1980-08-13.md): Bell 206B · S/N 1571 · Cancelled Aug 13, 1980 · Exported to Canada · Built 1975 · Edwards And Associates Inc
- [N816JH](https://openairdocs.org/deregistered/N816JH-1980-07-15.md): Bell 206A · S/N 315 · Cancelled Jul 15, 1980 · Exported to Canada · Edwards & Associates Inc
- [N8679F](https://openairdocs.org/deregistered/N8679F-1980-01-04.md): Hughes Helicopters HUGHES 369D · S/N 870178D · Cancelled Jan 4, 1980 · Exported to New Zealand · Edwards & Associates Inc
- [N8110J](https://openairdocs.org/deregistered/N8110J-1980-01-03.md): Bell 206B · S/N 782 · Cancelled Jan 3, 1980 · Exported to Canada · Edwards & Associates Inc
- [N49629](https://openairdocs.org/deregistered/N49629-1979-10-26.md): Bell 206B · S/N 1790 · Cancelled Oct 26, 1979 · Exported to Canada · Built 1975 · Edwards And Associates Inc
- [N8628F](https://openairdocs.org/deregistered/N8628F-1979-10-15.md): Hughes Helicopters HUGHES 369D · S/N 670138D · Cancelled Oct 15, 1979 · Exported to New Zealand · Built 1977 · Edwards And Associates Inc
- [N7112J](https://openairdocs.org/deregistered/N7112J-1979-08-02.md): Bell 206B · S/N 620 · Cancelled Aug 2, 1979 · Exported to Canada · Built 1971
- [N16753](https://openairdocs.org/deregistered/N16753-1979-07-13.md): Bell 206B · S/N 2131 · Cancelled Jul 13, 1979 · Exported to Canada · Edwards And Associates Inc
- [N9958K](https://openairdocs.org/deregistered/N9958K-1979-06-22.md): Bell 206B · S/N 2032 · Cancelled Jun 22, 1979 · Built 1976 · Edwards And Associates Inc
- [N55EC](https://openairdocs.org/deregistered/N55EC-1979-06-21.md): Bell 206B · S/N 2071 · Cancelled Jun 21, 1979 · Exported to Canada · Edwards And Assoc Inc
- [N333WW](https://openairdocs.org/deregistered/N333WW-1979-04-10.md): Bell 206B · S/N 1824 · Cancelled Apr 10, 1979 · Exported to Canada · Built 1975 · Edwards & Associates Inc
- [N8358F](https://openairdocs.org/deregistered/N8358F-1979-03-30.md): Hughes Helicopters HUGHES 369D · S/N 170068D · Cancelled Mar 30, 1979 · Exported to Canada · Built 1977 · Edwards And Associates Inc
- [N76CF](https://openairdocs.org/deregistered/N76CF-1979-03-27.md): Bell 206B · S/N 2056 · Cancelled Mar 27, 1979 · Exported to Canada · Edwards & Associates Inc
- [N440AS](https://openairdocs.org/deregistered/N440AS-1979-02-23.md): Bell 206B · S/N 1617 · Cancelled Feb 23, 1979 · Exported to Canada · Edwards And Associates Inc
- [N49698](https://openairdocs.org/deregistered/N49698-1978-08-18.md): Bell 206B · S/N 1903 · Cancelled Aug 18, 1978 · Exported to Venezuela · Edwards And Associates Inc
- [N16795](https://openairdocs.org/deregistered/N16795-1978-07-21.md): Bell 206B · S/N 2196 · Cancelled Jul 21, 1978 · Exported to Canada · Edwards And Associates Inc
- [N3530T](https://openairdocs.org/deregistered/N3530T-1978-06-25.md): Bell 206B · S/N 383 · Cancelled Jun 25, 1978 · Exported to Canada · Edwards And Associates Inc Aviation Division

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

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