# Cancelled registrations: Kingsport, TN

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

Cancelled aircraft registrations in Kingsport, TN.

- [N2544J](https://openairdocs.org/deregistered/N2544J-2023-02-04.md): Balloon Works FIREFLY 7-15 · S/N F7-816 · Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Thurman Joshua T
- [N230MG](https://openairdocs.org/deregistered/N230MG-2020-11-30.md): John A Brewer ELA AVIACION 10 ECLI · S/N 1014 · Cancelled Nov 30, 2020 · Second renewal notice · Aims Air LLC
- [N3956H](https://openairdocs.org/deregistered/N3956H-2020-11-18.md): Ercoupe 415-CD · S/N 4657 · Cancelled Nov 18, 2020 · Built 1947 · Summers James H
- [N754KM](https://openairdocs.org/deregistered/N754KM-2020-01-06.md): DJI INSPIRE 1 · S/N W13DCE15030432 · Cancelled Jan 6, 2020 · Registration expired, pending cancellation · Cumberland Marketing LLC
- [N2452](https://openairdocs.org/deregistered/N2452-2019-08-02.md): Dawson VOLKSPLANE · S/N 32842 · Cancelled Aug 2, 2019 · Revoked, canceled · Built 1970 · Dawson Ralph E
- [N3DA](https://openairdocs.org/deregistered/N3DA-2019-04-25.md): Raytheon A36 · S/N E3112 · Cancelled Apr 25, 2019 · Built 1997 · Airalley LLC
- [N1370](https://openairdocs.org/deregistered/N1370-2018-07-19.md): Baby Ace JR E · S/N 4251926 · Cancelled Jul 19, 2018 · Revoked, canceled · Clark James J
- [N729KW](https://openairdocs.org/deregistered/N729KW-2018-01-26.md): Work Kevin D CHALLENGER 1 · S/N 1298-B-0715 · Cancelled Jan 26, 2018 · Registration expired, pending cancellation · Built 1999 · Flanagan Gerald
- [N4432G](https://openairdocs.org/deregistered/N4432G-2018-01-23.md): Buckeye DREAM MACHINE · S/N 6007 · Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Built 2002 · Jones David L
- [N4301P](https://openairdocs.org/deregistered/N4301P-2017-06-20.md): Piper PA-23-160 · S/N 23-1802 · Cancelled Jun 20, 2017 · Registration expired, pending cancellation · Built 1959 · Cantley James B Jr
- [N2811A](https://openairdocs.org/deregistered/N2811A-2016-11-02.md): Nicely Vincent A MONI · S/N VN-3 · Cancelled Nov 2, 2016 · Built 2010 · Nicely Vincent A
- [N8233G](https://openairdocs.org/deregistered/N8233G-2016-11-02.md): Nicely Vincent A KOLB FIRESTAR II · S/N FS-424 · Cancelled Nov 2, 2016 · Built 1995 · Nicely Vincent A
- [N96828](https://openairdocs.org/deregistered/N96828-2015-04-30.md): Taylorcraft BC12-D1 · S/N 9128 · Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1946 · Stallard Harry E
- [N2166X](https://openairdocs.org/deregistered/N2166X-2013-09-25.md): Sanders Ronald G MAXAIR XP 503 · S/N RGS42843 · Cancelled Sep 25, 2013 · Registration expired, pending cancellation · Sanders Ronald G
- [N549SD](https://openairdocs.org/deregistered/N549SD-2013-08-05.md): Dennison Sammy K CGS HAWK · S/N H-6192-C · Cancelled Aug 5, 2013 · Registration expired, pending cancellation · Dennison Sammy K
- [N27MD](https://openairdocs.org/deregistered/N27MD-2013-06-11.md): Aero Commander 1121 · S/N 102 · Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Mason Dixon Lines Inc
- [N8702C](https://openairdocs.org/deregistered/N8702C-2013-05-15.md): Piper PA-22-135 · S/N 22-1350 · Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1953 · Varnadoe Theodore R Jr
- [N6311Q](https://openairdocs.org/deregistered/N6311Q-2011-05-09.md): Whittaker Gary S AVID MK IV · S/N 1576D · Cancelled May 9, 2011 · Exported to Canada · Built 1999 · Whittaker Gary S
- [N76TS](https://openairdocs.org/deregistered/N76TS-2011-01-06.md): Thunder & Colt Airborne Amer COLT 77A · S/N 2054 · Cancelled Jan 6, 2011 · Sale reported · Built 1991
- [N15218](https://openairdocs.org/deregistered/N15218-2010-03-03.md): Balloon Works FIREFLY 7-B · S/N 11063 · Cancelled Mar 3, 2010 · Triennial form not returned · Built 1981 · Flying Machine Company
- [N48898](https://openairdocs.org/deregistered/N48898-2007-12-14.md): Cessna 152 · S/N 15281038 · Cancelled Dec 14, 2007 · Exported to Philippines · Built 1977 · Campbell Bea Jr
- [N6378U](https://openairdocs.org/deregistered/N6378U-2006-07-10.md): Nicely Vincent A SONERAI II LST · S/N VN-2 · Cancelled Jul 10, 2006 · Triennial form not returned · Built 2001 · Nicely Vincent A
- [N31195](https://openairdocs.org/deregistered/N31195-2002-09-06.md): Summers KR-1 · S/N 1 · Cancelled Sep 6, 2002 · Triennial form not returned · Built 1976 · Summers James H
- [N9361J](https://openairdocs.org/deregistered/N9361J-2001-03-05.md): Piper PA-28-180 · S/N 28-3460 · Cancelled Mar 5, 2001 · Triennial form not returned · Cooper Kevin J
- [N7LH](https://openairdocs.org/deregistered/N7LH-1999-04-12.md): Hardee Leroy BENSEN B 80 · S/N 248133172 · Cancelled Apr 12, 1999 · Triennial form not returned · Hardee Leroy
- [N40297](https://openairdocs.org/deregistered/N40297-1997-10-14.md): Adams Balloon A55 · S/N 147 · Cancelled Oct 14, 1997 · Triennial form not returned · Tri-Cities Mazda Dealers
- [N19AM](https://openairdocs.org/deregistered/N19AM-1994-11-23.md): Morehead BENSEN B8M · S/N 40081 · Cancelled Nov 23, 1994 · Triennial form not returned · Morehead Arthur O
- [N447RG](https://openairdocs.org/deregistered/N447RG-1994-08-04.md): Galloway Ray D GROVER · S/N 84020 · Cancelled Aug 4, 1994 · Triennial form not returned · Galloway Ray D
- [N6523X](https://openairdocs.org/deregistered/N6523X-1993-10-27.md): Cessna 210 · S/N 57523 · Cancelled Oct 27, 1993 · Triennial form not returned · Grecol Aviation Inc
- [N444ME](https://openairdocs.org/deregistered/N444ME-1982-08-30.md): Piper PA-32R-300 · S/N 32R-7680220 · Cancelled Aug 30, 1982 · Built 1976 · Harris David L
- [N4407E](https://openairdocs.org/deregistered/N4407E-1982-02-05.md): Aeronca 7AC · S/N 7AC-7185 · Cancelled Feb 5, 1982 · Built 1948 · Sportwings Inc
- [N71757](https://openairdocs.org/deregistered/N71757-1982-01-04.md): Cessna 182M · S/N 18259742 · Cancelled Jan 4, 1982 · Skycrafters Inc
- [N7129A](https://openairdocs.org/deregistered/N7129A-1977-09-16.md): Cessna 172 · S/N 29229 · Cancelled Sep 16, 1977 · Bradley Larry H
- [N8312T](https://openairdocs.org/deregistered/N8312T-1975-06-09.md): Cessna 175C · S/N 17557012 · Cancelled Jun 9, 1975 · Poe Roy W
- [N60125](https://openairdocs.org/deregistered/N60125-1975-05-08.md): Cessna 150J · S/N 15070088 · Cancelled May 8, 1975 · Tri-City Aviation Inc
- [N57958](https://openairdocs.org/deregistered/N57958-1973-06-25.md): Boeing A75N1(PT17) · S/N 75-2253 · Cancelled Jun 25, 1973 · Baker Corbett E
- [N50119](https://openairdocs.org/deregistered/N50119-1971-12-03.md): Taylorcraft DCO-65 · S/N L-5471 · Cancelled Dec 3, 1971 · Phillips Thomas
- [N102C](https://openairdocs.org/deregistered/N102C-1970-12-29.md): Mooney M-18L · S/N 63 · Cancelled Dec 29, 1970 · Mason Don F
- [N20505](https://openairdocs.org/deregistered/N20505-1970-10-07.md): Taylorcraft A · S/N 506 · Cancelled Oct 7, 1970 · James O Dean
- [N288SE](https://openairdocs.org/deregistered/N288SE-1970-06-25.md): Douglas DC3A · S/N 2222 · Cancelled Jun 25, 1970 · Southeastern Aviation Inc
- [N18941](https://openairdocs.org/deregistered/N18941-1959-01-30.md): Douglas DC3A · S/N 2007 · Cancelled Jan 30, 1959 · Southeastern Aviation Inc
- [N52370](https://openairdocs.org/deregistered/N52370-1954-01-26.md): Consolidated Vultee BT-13A · S/N 5095 · Cancelled Jan 26, 1954 · Cleek John R
- [N49678](https://openairdocs.org/deregistered/N49678-1953-07-06.md): Boeing A75N1 · S/N 75-2049 · Cancelled Jul 6, 1953 · James N Camp
- [N52229](https://openairdocs.org/deregistered/N52229-1951-07-24.md): North American AT-6B · S/N 84-7788 · Cancelled Jul 24, 1951 · Built 1946 · Cleek John R
- [N46821](https://openairdocs.org/deregistered/N46821-1950-05-31.md): Taylorcraft DCO-65 · S/N 0-4295 · Cancelled May 31, 1950 · Hobbs J H
- [N38842](https://openairdocs.org/deregistered/N38842-1950-01-10.md): Piper J3L-65 · S/N 7329 · Cancelled Jan 10, 1950 · Built 1941 · Staton Ollis J
- [N88594](https://openairdocs.org/deregistered/N88594-1947-10-09.md): Piper J3C-65 · S/N 16220 · Cancelled Oct 9, 1947 · Kingsport Air Service Inc
- [N952W](https://openairdocs.org/deregistered/N952W-1937-06-01.md): Welch Orin OWX · S/N 1 · Cancelled Jun 1, 1937 · Houser Charles W
- [N5042](https://openairdocs.org/deregistered/N5042-1931-02-12.md): Waco 10 · S/N 1331 · Cancelled Feb 12, 1931 · Built 1928 · Dorsett Jack

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

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