# Cancelled registrations: Somerset, KY

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

Cancelled aircraft registrations in Somerset, KY.

- [N7910Y](https://openairdocs.org/deregistered/N7910Y-2022-12-13.md): Piper PA-30 · S/N 30-999 · Cancelled Dec 13, 2022 · Registration pending, canceled · Built 1966
- [N674VP](https://openairdocs.org/deregistered/N674VP-2022-07-02.md): Robert James Patton CESSNA 152 · S/N RJP-1 · Cancelled Jul 2, 2022 · Registration expired, pending cancellation · Patton Robert J
- [N251PD](https://openairdocs.org/deregistered/N251PD-2021-10-30.md): DJI PHANTOM 3 PROFESSION · S/N P76DCF28017418 · Cancelled Oct 30, 2021 · Registration expired, pending cancellation · City Of Somerset
- [N1405](https://openairdocs.org/deregistered/N1405-2020-08-02.md): Bell OH-58A · S/N 71-20514 · Cancelled Aug 2, 2020 · Registration expired, pending cancellation · Pulaski County Sheriffs Department
- [N2717M](https://openairdocs.org/deregistered/N2717M-2020-06-12.md): Piper PA-12 · S/N 12-1132 · Cancelled Jun 12, 2020 · Revoked, canceled · Built 1946 · Mckinney Howard L
- [N1533](https://openairdocs.org/deregistered/N1533-2019-10-15.md): Bell OH-58C · S/N 70-15353 · Cancelled Oct 15, 2019 · Pulaski County Sheriffs Department
- [N3371W](https://openairdocs.org/deregistered/N3371W-2018-12-01.md): Piper PA-32-260 · S/N 32-217 · Cancelled Dec 1, 2018 · Registration expired, pending cancellation · Built 1965 · Foster Scott Thomas
- [N24563](https://openairdocs.org/deregistered/N24563-2018-03-12.md): Piper PA-38-112 · S/N 38-79A1132 · Cancelled Mar 12, 2018 · Registration expired, pending cancellation · Built 1979 · Dustin The Wind Aviation LLC
- [N257CQ](https://openairdocs.org/deregistered/N257CQ-2018-03-01.md): Beech C90 · S/N LJ-1419 · Cancelled Mar 1, 2018 · Registration expired, pending cancellation · Built 1995 · Absher Air LLC
- [N241Z](https://openairdocs.org/deregistered/N241Z-2015-05-20.md): Richard Green Brantley STOL CH 701 · S/N 001 · Cancelled May 20, 2015 · Sale reported, canceled · Built 2013
- [N41400](https://openairdocs.org/deregistered/N41400-2013-07-11.md): Piper PA-28-151 · S/N 28-7415201 · Cancelled Jul 11, 2013 · Sale reported, canceled · Built 1974
- [N9495C](https://openairdocs.org/deregistered/N9495C-2013-06-27.md): Piper PA-34-200T · S/N 34-7870192 · Cancelled Jun 27, 2013 · Sale reported, canceled · Built 1978
- [N2311S](https://openairdocs.org/deregistered/N2311S-2013-06-11.md): Barnett Kenneth HP-18 · S/N 91 · Cancelled Jun 11, 2013 · Sale reported, canceled · Built 1979
- [N9688V](https://openairdocs.org/deregistered/N9688V-2013-03-21.md): Cessna 172M · S/N 17264467 · Cancelled Mar 21, 2013 · Sale reported, canceled · Built 1974
- [N88CQ](https://openairdocs.org/deregistered/N88CQ-2013-03-11.md): Piper PA-31P · S/N 31P-7300156 · Cancelled Mar 11, 2013 · Sale reported, canceled · Built 1973
- [N7749R](https://openairdocs.org/deregistered/N7749R-2012-12-28.md): Beech D55 · S/N TE-647 · Cancelled Dec 28, 2012 · Sale reported, pending cancellation · Built 1968
- [N4725B](https://openairdocs.org/deregistered/N4725B-2012-11-27.md): Cessna 152 · S/N 15283599 · Cancelled Nov 27, 2012 · Sale reported, canceled · Built 1979
- [N600JW](https://openairdocs.org/deregistered/N600JW-2012-11-07.md): Wright J David MINI 500 · S/N 1780 · Cancelled Nov 7, 2012 · Sale reported, canceled · Built 1999
- [N1007H](https://openairdocs.org/deregistered/N1007H-2012-09-06.md): Cessna 210 · S/N 57028 · Cancelled Sep 6, 2012 · Registration pending, canceled · Built 1959
- [N1415](https://openairdocs.org/deregistered/N1415-2011-03-07.md): Bernier B-8M · S/N PB1 · Cancelled Mar 7, 2011 · Sale reported, pending cancellation · Built 1978
- [N179DM](https://openairdocs.org/deregistered/N179DM-2002-11-07.md): Morris David RAF2000 · S/N 400-96-8701-1 · Cancelled Nov 7, 2002 · Triennial form not returned · Built 1997 · Morris David M
- [N29308](https://openairdocs.org/deregistered/N29308-1997-10-10.md): Cessna 177 · S/N 17700804 · Cancelled Oct 10, 1997 · Triennial form not returned · Cumberland Welders Supply Co Inc
- [N112DB](https://openairdocs.org/deregistered/N112DB-1992-02-11.md): Baldwin Don ACRO SPORT I · S/N 58 · Cancelled Feb 11, 1992 · Triennial form not returned · Baldwin Don E
- [N4896B](https://openairdocs.org/deregistered/N4896B-1982-07-02.md): Cessna 152 · S/N 15283696 · Cancelled Jul 2, 1982 · Exported to Germany · Built 1979 · Somerset Flying Service Inc
- [N1712V](https://openairdocs.org/deregistered/N1712V-1977-09-07.md): Cessna 172M · S/N 17263720 · Cancelled Sep 7, 1977 · Exported to Canada · Somerset Flying Service Inc
- [N92R](https://openairdocs.org/deregistered/N92R-1976-05-27.md): Mcginnis CHINK REDHEAD · S/N 1 · Cancelled May 27, 1976 · Somerset State Ve Tech School
- [N6598S](https://openairdocs.org/deregistered/N6598S-1976-05-26.md): Cessna 150H · S/N 15067398 · Cancelled May 26, 1976 · Somerset Area Vocational School
- [N51289](https://openairdocs.org/deregistered/N51289-1976-05-24.md): Cessna 150 · S/N 15069899 · Cancelled May 24, 1976 · Somerset Area Vocational School
- [N2893Y](https://openairdocs.org/deregistered/N2893Y-1976-05-18.md): Cessna 182E · S/N 18253893 · Cancelled May 18, 1976 · Somerset Area Vocational School
- [N22346](https://openairdocs.org/deregistered/N22346-1976-05-17.md): Cessna 150H · S/N 15068227 · Cancelled May 17, 1976 · Somerset Area Vocational School
- [N22930](https://openairdocs.org/deregistered/N22930-1976-05-17.md): Cessna 150H · S/N 15068623 · Cancelled May 17, 1976 · Somerset Area Vocational School State Dept Of Ed
- [N23301](https://openairdocs.org/deregistered/N23301-1976-05-17.md): Cessna 150H · S/N 15068859 · Cancelled May 17, 1976 · Somerset Area Vocational School
- [N41757](https://openairdocs.org/deregistered/N41757-1974-05-07.md): Hiller OH-23B · S/N 51-16182 · Cancelled May 7, 1974 · Built 1951 · Somerset Area Vocational School
- [N43676](https://openairdocs.org/deregistered/N43676-1974-05-07.md): Hiller OH-23C · S/N 54-862 · Cancelled May 7, 1974 · Built 1954 · Somerset Area Vocational School
- [N8055](https://openairdocs.org/deregistered/N8055-1972-06-21.md): North American F-86 · S/N 53-1361 · Cancelled Jun 21, 1972 · Somerset Area Vocational School
- [N3368M](https://openairdocs.org/deregistered/N3368M-1971-07-22.md): Piper PA-12 · S/N 12-2217 · Cancelled Jul 22, 1971 · Boss Ed
- [N1454E](https://openairdocs.org/deregistered/N1454E-1971-07-14.md): Champion 7BCM · S/N 7AC-5017 · Cancelled Jul 14, 1971 · Boss Edd
- [N78443](https://openairdocs.org/deregistered/N78443-1971-04-01.md): Piper PA-12 · S/N 12-1955 · Cancelled Apr 1, 1971 · Mayfield Vincent J
- [N8005](https://openairdocs.org/deregistered/N8005-1971-04-01.md): Grumman HU 16E · S/N 1313 · Cancelled Apr 1, 1971 · Sommerset Arear Vocational School
- [N3428E](https://openairdocs.org/deregistered/N3428E-1955-03-15.md): Aeronca 11AC · S/N 11AC-1741 · Cancelled Mar 15, 1955 · Roy Guffy
- [N1199E](https://openairdocs.org/deregistered/N1199E-1951-10-04.md): Aeronca 7AC · S/N 7AC-4756 · Cancelled Oct 4, 1951 · Taylor Victor
- [N33454](https://openairdocs.org/deregistered/N33454-1950-03-13.md): Piper J3F-65 · S/N 5964 · Cancelled Mar 13, 1950 · Frank Newell
- [N71685](https://openairdocs.org/deregistered/N71685-1949-12-08.md): Luscombe 8A · S/N 3112 · Cancelled Dec 8, 1949 · Built 1949 · Burke Allan
- [N4508](https://openairdocs.org/deregistered/N4508-1948-07-13.md): Waco GXE · S/N 1368 · Cancelled Jul 13, 1948 · Somerset Flying Club

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

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