# Cancelled registrations: Rome, GA

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

Cancelled aircraft registrations in Rome, GA.

- [N9257Y](https://openairdocs.org/deregistered/N9257Y-2022-11-05.md): Beech A23 · S/N M-889 · Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Built 1965 · Rogers Hans
- [N87400](https://openairdocs.org/deregistered/N87400-2022-07-30.md): Engineering & Research ERCOUPE 415-C · S/N 573 · Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Jarrett Larry E
- [N40249](https://openairdocs.org/deregistered/N40249-2022-06-04.md): Piper PA-23-250 · S/N 27-7305055 · Cancelled Jun 4, 2022 · Registration expired, pending cancellation · Built 1973 · Turner James P Jr
- [N22480](https://openairdocs.org/deregistered/N22480-2020-04-03.md): Aeronca 65-C · S/N C4319 · Cancelled Apr 3, 2020 · Revoked, canceled · Built 1939 · Gray Winfred B
- [N8103S](https://openairdocs.org/deregistered/N8103S-2019-01-28.md): Cessna 150F · S/N 15061703 · Cancelled Jan 28, 2019 · Revoked, canceled · Built 1965 · Aviation Ltd
- [N565XS](https://openairdocs.org/deregistered/N565XS-2019-01-08.md): DJI PHANTOM 2 · S/N PT645196829 · Cancelled Jan 8, 2019 · Registration expired, pending cancellation · Spectrum Education LLC
- [N566ZE](https://openairdocs.org/deregistered/N566ZE-2019-01-08.md): DJI PHANTOM 2 · S/N PT645158735 · Cancelled Jan 8, 2019 · Registration expired, pending cancellation · Spectrum Education LLC
- [N1147E](https://openairdocs.org/deregistered/N1147E-2018-03-19.md): Aeronca 7AC · S/N 7AC-4703 · Cancelled Mar 19, 2018 · Registration expired, pending cancellation · Built 1946 · Toole Eben H
- [N75289](https://openairdocs.org/deregistered/N75289-2018-01-26.md): Trick Trikes STORM · S/N 1116 · Cancelled Jan 26, 2018 · Registration expired, pending cancellation · Built 2000 · Jones Greg J
- [N130WR](https://openairdocs.org/deregistered/N130WR-2017-06-19.md): Cessna 150J · S/N 15070424 · Cancelled Jun 19, 2017 · Registration expired, pending cancellation · Davis Jim W
- [N555TN](https://openairdocs.org/deregistered/N555TN-2017-02-06.md): Easterwood Mark W RV-6A · S/N 23623 · Cancelled Feb 6, 2017 · Second renewal notice · Built 2011 · Easterwood Mark W
- [N9500Y](https://openairdocs.org/deregistered/N9500Y-2015-12-22.md): Beech B95A · S/N TD-508 · Cancelled Dec 22, 2015 · Third renewal notice · Built 1962 · Lowden Howard J
- [N777WZ](https://openairdocs.org/deregistered/N777WZ-2015-05-21.md): W Z Air CONTINENTAL CRUISER · S/N 002 · Cancelled May 21, 2015 · Sale reported, canceled · Built 2005
- [N12NF](https://openairdocs.org/deregistered/N12NF-2014-09-03.md): Cessna 150H · S/N 15067222 · Cancelled Sep 3, 2014 · Registration expired, pending cancellation · Built 1967 · Three River Air Svc Inc
- [N5334F](https://openairdocs.org/deregistered/N5334F-2013-09-30.md): Piper PA-28-151 · S/N 28-7715101 · Cancelled Sep 30, 2013 · Registration expired, pending cancellation · Built 1976 · Northwest Georgia Aviation Inc
- [N4637X](https://openairdocs.org/deregistered/N4637X-2013-08-27.md): Cessna 150G · S/N 15064687 · Cancelled Aug 27, 2013 · Sale reported, canceled · Built 1966
- [N97SS](https://openairdocs.org/deregistered/N97SS-2013-08-08.md): Maule MXT-7-180A · S/N 21014C · Cancelled Aug 8, 2013 · Sale reported, canceled · Built 1997
- [N76RE](https://openairdocs.org/deregistered/N76RE-2013-06-11.md): Stansell Glenn RALLY 3A · S/N 25062 · Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Built 1983 · Tri State Ultra Flight Inc
- [N98117](https://openairdocs.org/deregistered/N98117-2013-05-30.md): Piper PA-28-140 · S/N 28-26053 · Cancelled May 30, 2013 · Registration expired, pending cancellation · Built 1969 · Georgia Cherokee Airshares 1 LLC
- [N91SM](https://openairdocs.org/deregistered/N91SM-2013-05-17.md): Piper PA-28-151 · S/N 28-7515345 · Cancelled May 17, 2013 · Registration expired, pending cancellation · Built 1975 · Northwest Georgia Aviation Inc
- [N8115F](https://openairdocs.org/deregistered/N8115F-2013-05-13.md): Cessna 150F · S/N 15064215 · Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1966 · Popham Kent W
- [N5324R](https://openairdocs.org/deregistered/N5324R-2013-04-09.md): Cessna 172F · S/N 17252849 · Cancelled Apr 9, 2013 · Registration expired, pending cancellation · Built 1965 · Popham Kent W
- [N91FM](https://openairdocs.org/deregistered/N91FM-2013-03-25.md): Piper PA-28-140 · S/N 28-23116 · Cancelled Mar 25, 2013 · Sale reported, canceled · Built 1967
- [N41846](https://openairdocs.org/deregistered/N41846-2012-06-07.md): Fairchild 24R-9 · S/N R40424 · Cancelled Jun 7, 2012 · Revoked, canceled · Built 1941 · Stroop Robert C Jr
- [N3199L](https://openairdocs.org/deregistered/N3199L-2012-03-12.md): Cessna 310J · S/N 310J0199 · Cancelled Mar 12, 2012 · Sale reported, pending cancellation · Built 1965
- [N824AB](https://openairdocs.org/deregistered/N824AB-2008-06-25.md): Piper PA-31-325 · S/N 31-7812044 · Cancelled Jun 25, 2008 · Exported to Canada · Built 1977 · Group Holdings Riddle Inc
- [N22L](https://openairdocs.org/deregistered/N22L-2007-05-02.md): Cessna 195 · S/N 7961 · Cancelled May 2, 2007 · Triennial form not returned · Built 1952 · Tillman Gary E
- [N28KB](https://openairdocs.org/deregistered/N28KB-2003-12-06.md): Russell John B KOLB SLINGSHOT · S/N SS009 · Cancelled Dec 6, 2003 · Triennial form not returned · Built 1998 · Russell John B
- [N2906J](https://openairdocs.org/deregistered/N2906J-1997-12-06.md): Cessna 150G · S/N 15065706 · Cancelled Dec 6, 1997 · Triennial form not returned · Magruder Dudley B Jr
- [N7166](https://openairdocs.org/deregistered/N7166-1970-09-03.md): Bensen B-8M · S/N 716 · Cancelled Sep 3, 1970 · Built 1967 · Holloway Lee C
- [N65831](https://openairdocs.org/deregistered/N65831-1956-03-14.md): Consolidated Vultee SNV-2 · S/N 79-1469 · Cancelled Mar 14, 1956 · Built 1944 · Stroop R C
- [N1275A](https://openairdocs.org/deregistered/N1275A-1954-10-06.md): Piper PA-18 · S/N 18-1075 · Cancelled Oct 6, 1954 · Holland Harry
- [N55546](https://openairdocs.org/deregistered/N55546-1954-08-16.md): Boeing A75N1 · S/N 75-2753 · Cancelled Aug 16, 1954 · Woods Joe B & C J Wilson
- [N55320](https://openairdocs.org/deregistered/N55320-1951-11-29.md): Boeing A75N1 · S/N 75-2096 · Cancelled Nov 29, 1951 · Joe Barry Woods
- [N330M](https://openairdocs.org/deregistered/N330M-1951-08-16.md): Mooney M-18C · S/N 211 · Cancelled Aug 16, 1951 · Built 1950 · Swart James W
- [N46774](https://openairdocs.org/deregistered/N46774-1951-08-01.md): Fairchild M-62A · S/N 7383AE · Cancelled Aug 1, 1951 · Climer Clyde H
- [N90349](https://openairdocs.org/deregistered/N90349-1951-07-25.md): Temco GC-1B · S/N 363 · Cancelled Jul 25, 1951 · Tanner Murdock
- [N9975A](https://openairdocs.org/deregistered/N9975A-1951-05-07.md): Cessna 170A · S/N 19335 · Cancelled May 7, 1951 · Sharpe Julian R
- [N32478](https://openairdocs.org/deregistered/N32478-1946-08-23.md): Culver LCA · S/N 210 · Cancelled Aug 23, 1946 · Built 1941 · Holland Harry D
- [N628E](https://openairdocs.org/deregistered/N628E-1939-05-15.md): American Eagle 101 · S/N 365 · Cancelled May 15, 1939 · Mcburnette Dave
- [N884Y](https://openairdocs.org/deregistered/N884Y-1939-01-15.md): Southern AIR BOSS · S/N 6 · Cancelled Jan 15, 1939 · Harry C Clair
- [N115](https://openairdocs.org/deregistered/N115-1938-05-25.md): Thomas Morse S4C · S/N 4334 · Cancelled May 25, 1938 · Stroop R C
- [N4066](https://openairdocs.org/deregistered/N4066-1935-03-01.md): Dehavillandaircraft 6 · S/N 1011 · Cancelled Mar 1, 1935 · Stroop R C

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

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