# Cancelled registrations: Smyrna, GA

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

Cancelled aircraft registrations in Smyrna, GA.

- [N8235K](https://openairdocs.org/deregistered/N8235K-2019-10-21.md): Stinson 108-1 · S/N 108-1235 · Cancelled Oct 21, 2019 · Revoked, canceled · Built 1946 · Pefco Inc
- [N606ZD](https://openairdocs.org/deregistered/N606ZD-2019-04-19.md): Sensefly EXOM · S/N EX-01-09196 · Cancelled Apr 19, 2019 · Registration expired, pending cancellation · Dobbins Rick
- [N557ZD](https://openairdocs.org/deregistered/N557ZD-2018-10-23.md): DJI PHANTOM 2 · S/N 100016167 · Cancelled Oct 23, 2018 · Registration expired, pending cancellation · Dobbins Co
- [N37168](https://openairdocs.org/deregistered/N37168-2018-05-17.md): Cessna 404 · S/N 404-0130 · Cancelled May 17, 2018 · Revoked, canceled · Built 1977 · Wilcox Robert
- [N99915](https://openairdocs.org/deregistered/N99915-2017-11-21.md): Engineering & Research ERCOUPE 415-C · S/N 2538 · Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Gregory John
- [N620JY](https://openairdocs.org/deregistered/N620JY-2017-10-31.md): Young Jerry E 601 HDJ · S/N 6-5814J · Cancelled Oct 31, 2017 · Registration expired, pending cancellation · Young Jerry E
- [N22176](https://openairdocs.org/deregistered/N22176-2017-10-28.md): Aeronca 50-C · S/N C2809 · Cancelled Oct 28, 2017 · Revoked, canceled · Built 1939 · Smith Carroll
- [N99834](https://openairdocs.org/deregistered/N99834-2017-02-14.md): Ercoupe 415-C · S/N 2457 · Cancelled Feb 14, 2017 · Revoked, canceled · Built 1946 · Bobbitt Phillip L
- [N9111R](https://openairdocs.org/deregistered/N9111R-2014-11-24.md): Huff Cougar COUGAR · S/N 1 · Cancelled Nov 24, 2014 · Registration expired, pending cancellation · Built 1960 · Blaker Charles F
- [N56JG](https://openairdocs.org/deregistered/N56JG-2014-10-29.md): Piper PA-24-260 · S/N 24-4201 · Cancelled Oct 29, 2014 · Registration expired, pending cancellation · Built 1965 · Stinner Brian
- [N21ML](https://openairdocs.org/deregistered/N21ML-2013-07-30.md): Piper PA-23-250 · S/N 27-7554134 · Cancelled Jul 30, 2013 · Registration expired, pending cancellation · Built 1975 · Harris Robert L
- [N431T](https://openairdocs.org/deregistered/N431T-2013-07-10.md): Beech 35-A33 · S/N CD-287 · Cancelled Jul 10, 2013 · Sale reported, canceled · Built 1961
- [N99748](https://openairdocs.org/deregistered/N99748-2013-05-31.md): Ercoupe 415-C · S/N 2371 · Cancelled May 31, 2013 · Registration expired, pending cancellation · Built 1946 · Osteen Claude I
- [N7685K](https://openairdocs.org/deregistered/N7685K-2013-05-09.md): Piper PA-20 · S/N 20-507 · Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1950 · Lowery Jerry W
- [N4731V](https://openairdocs.org/deregistered/N4731V-2012-11-27.md): Bellanca 17-30 · S/N 30064 · Cancelled Nov 27, 2012 · Sale reported, canceled · Built 1967
- [N23110](https://openairdocs.org/deregistered/N23110-2009-07-14.md): Piper J3C-65 · S/N 2895 · Cancelled Jul 14, 2009 · Registration revoked · Built 1939 · Bell Jack R
- [N124U](https://openairdocs.org/deregistered/N124U-2002-03-07.md): Greathouse Harold E RAND ROBINSON KR-2S · S/N 7554 · Cancelled Mar 7, 2002 · Triennial form not returned · Built 1995 · Greathouse Harold E
- [N237B](https://openairdocs.org/deregistered/N237B-1997-01-21.md): Glasflugel MOSQUITO · S/N 53 · Cancelled Jan 21, 1997 · Triennial form not returned · Neffinger James W
- [N57313](https://openairdocs.org/deregistered/N57313-1995-07-26.md): Piper PA-28R-200 · S/N 28R7435078 · Cancelled Jul 26, 1995 · Second triennial mailing, no response · Johnson A Sheppard III
- [N9767K](https://openairdocs.org/deregistered/N9767K-1994-03-02.md): Stinson 108-2 · S/N 1082767 · Cancelled Mar 2, 1994 · Triennial form not returned · Williamson Stephen J
- [N792G](https://openairdocs.org/deregistered/N792G-1994-01-10.md): Burkhart Grob Flugzeugbau G102 CLUB ASTIR IIIB · S/N 5629CB · Cancelled Jan 10, 1994
- [N2249L](https://openairdocs.org/deregistered/N2249L-1993-02-19.md): Beech C24R · S/N MC461 · Cancelled Feb 19, 1993 · Triennial form not returned · Mark C Pope Associates
- [N215FA](https://openairdocs.org/deregistered/N215FA-1982-10-22.md): Hughes Helicopters HUGHES 369D · S/N 1100859D · Cancelled Oct 22, 1982 · Exported to Colombia · Built 1981 · Amortegui Carlos
- [N9BW](https://openairdocs.org/deregistered/N9BW-1981-10-15.md): Beech C23 · S/N M-1426 · Cancelled Oct 15, 1981 · Carroll Alton F
- [N37972](https://openairdocs.org/deregistered/N37972-1976-05-20.md): Piper J4E · S/N 4-1510 · Cancelled May 20, 1976 · Built 1941 · Marietta Air Rescue Squadron Inc
- [N1181K](https://openairdocs.org/deregistered/N1181K-1974-12-31.md): Luscombe 8E · S/N 3908 · Cancelled Dec 31, 1974 · Pierce Robert N
- [N7039T](https://openairdocs.org/deregistered/N7039T-1971-07-14.md): Cessna 172 · S/N 46639 · Cancelled Jul 14, 1971 · Transway Inc
- [N7631P](https://openairdocs.org/deregistered/N7631P-1970-06-26.md): Piper PA-24-250 · S/N 24-2841 · Cancelled Jun 26, 1970 · Dixie Enterminators 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 = 'GA' AND d.registrant_city = 'SMYRNA'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

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