# Cancelled registrations: Maryville, TN

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

Cancelled aircraft registrations in Maryville, TN.

- [N92449](https://openairdocs.org/deregistered/N92449-2023-02-04.md): Piper J3C-65 · S/N 16917 · Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Built 1946 · Lowery Glen
- [N676LB](https://openairdocs.org/deregistered/N676LB-2020-12-08.md): Lindstrand Balloons 90A · S/N 5066 · Cancelled Dec 8, 2020 · Registration expired, pending cancellation · Built 1998 · Davis Steven M
- [N9676W](https://openairdocs.org/deregistered/N9676W-2020-08-02.md): Piper PA-28-140 · S/N 28-23142 · Cancelled Aug 2, 2020 · Registration expired, pending cancellation · Built 1967 · Childress Ronald D
- [N46689](https://openairdocs.org/deregistered/N46689-2020-02-28.md): Taylorcraft DC-65 · S/N 5093 · Cancelled Feb 28, 2020 · Revoked, canceled · Built 1943 · Cutshaw James E
- [N101TN](https://openairdocs.org/deregistered/N101TN-2019-11-29.md): DJI INSPIRE 1 · S/N W13DCD25030296 · Cancelled Nov 29, 2019 · Registration expired, pending cancellation · Atmos Productions LLC
- [N3517L](https://openairdocs.org/deregistered/N3517L-2018-02-15.md): Cessna 150F · S/N 15062317 · Cancelled Feb 15, 2018 · Sale reported, canceled · Built 1965
- [N43046](https://openairdocs.org/deregistered/N43046-2018-01-19.md): Kolb MK II · S/N M2-121 · Cancelled Jan 19, 2018 · Registration expired, pending cancellation · Built 1989 · Roth Jerry D
- [N56796](https://openairdocs.org/deregistered/N56796-2018-01-10.md): Piper PA-28-140 · S/N 28-7425037 · Cancelled Jan 10, 2018 · Registration expired, pending cancellation · Built 1973 · Hunt James W
- [N7169Y](https://openairdocs.org/deregistered/N7169Y-2017-09-26.md): Piper PA-30 · S/N 30-190 · Cancelled Sep 26, 2017 · Registration expired, pending cancellation · Built 1963 · Mckevitz Peter M
- [N8890G](https://openairdocs.org/deregistered/N8890G-2017-07-19.md): Cessna 150F · S/N 15062990 · Cancelled Jul 19, 2017 · Registration expired, pending cancellation · Built 1966 · Harris Dan C
- [N9823W](https://openairdocs.org/deregistered/N9823W-2017-04-26.md): Brian Delamater VANS RV-7 · S/N 73435 · Cancelled Apr 26, 2017 · Exported to United Kingdom · Delamater Brian
- [N8693B](https://openairdocs.org/deregistered/N8693B-2014-12-22.md): Cessna 172 · S/N 36393 · Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Built 1957 · Cash Jimmy W
- [N5001E](https://openairdocs.org/deregistered/N5001E-2013-07-15.md): Willocks Russell Clay HI MAX · S/N 0094 · Cancelled Jul 15, 2013 · Registration expired, pending cancellation · Willocks Russell Clay
- [N1439B](https://openairdocs.org/deregistered/N1439B-2013-07-09.md): Luscombe 8A · S/N 6066 · Cancelled Jul 9, 2013 · Registration expired, pending cancellation · Built 1948 · Shope Z Conley Jr
- [N8486T](https://openairdocs.org/deregistered/N8486T-2013-05-14.md): Cessna 182C · S/N 52386 · Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1959 · Conner Willard R
- [N6775](https://openairdocs.org/deregistered/N6775-2013-05-02.md): Owens SCORPION TOO · S/N WH0-77 · Cancelled May 2, 2013 · Registration expired, pending cancellation · Ferguson Jerry E
- [N6312K](https://openairdocs.org/deregistered/N6312K-2013-04-29.md): Cessna 150M · S/N 15077639 · Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1975 · East Tennessee Pilots Club Inc
- [N5482S](https://openairdocs.org/deregistered/N5482S-2013-01-30.md): Cessna 337B · S/N 337-0582 · Cancelled Jan 30, 2013 · Sale reported, canceled · Built 1966
- [N51941](https://openairdocs.org/deregistered/N51941-2010-05-28.md): Aeronca 7AC · S/N 7AC-690 · Cancelled May 28, 2010 · Triennial form not returned · Delozier Roger E
- [N736SF](https://openairdocs.org/deregistered/N736SF-2007-08-21.md): Cessna R172K · S/N R1722747 · Cancelled Aug 21, 2007 · Exported to Bolivia · Built 1977 · Stone David L II
- [N122GW](https://openairdocs.org/deregistered/N122GW-2005-12-28.md): Sharman SCHREDER RS15 · S/N 30 · Cancelled Dec 28, 2005 · Exported to Canada · Built 1974 · Wackerhagen Garry L
- [N704QN](https://openairdocs.org/deregistered/N704QN-1992-09-21.md): Cessna 150M · S/N 15078791 · Cancelled Sep 21, 1992 · Triennial form not returned · East Tennessee Pilots Club Inc
- [N416EW](https://openairdocs.org/deregistered/N416EW-1992-06-11.md): Wood 1 · S/N 1 · Cancelled Jun 11, 1992 · East Tennessee Pilots Club Inc
- [N9348U](https://openairdocs.org/deregistered/N9348U-1991-03-14.md): Cessna 150M · S/N 15078297 · Cancelled Mar 14, 1991 · Triennial form not returned · East Tennessee Pilots Club Inc
- [N2317Y](https://openairdocs.org/deregistered/N2317Y-1984-07-13.md): Cessna 177 · S/N 17700117 · Cancelled Jul 13, 1984 · Administratively canceled · Harder Ralph N
- [N6111F](https://openairdocs.org/deregistered/N6111F-1977-01-04.md): Cessna 210H · S/N 21059011 · Cancelled Jan 4, 1977 · Self Glenn F
- [N98991](https://openairdocs.org/deregistered/N98991-1973-05-24.md): Piper PA-12 · S/N 12-349 · Cancelled May 24, 1973 · East Tenn. Pilots Association Inc
- [N9122B](https://openairdocs.org/deregistered/N9122B-1969-01-21.md): Cessna 172 · S/N 36722 · Cancelled Jan 21, 1969 · Smith Ronald M
- [N20807](https://openairdocs.org/deregistered/N20807-1948-05-18.md): Piper J-3 · S/N 2107 · Cancelled May 18, 1948 · Bowler Thomas A & Ruth Evans Bowler
- [N11471](https://openairdocs.org/deregistered/N11471-1948-04-07.md): Waco QDC · S/N 3515 · Cancelled Apr 7, 1948 · Caylor Melvin M Et Al

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

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