# Cancelled registrations: Fairmont, WV

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

Cancelled aircraft registrations in Fairmont, WV.

- [N30791](https://openairdocs.org/deregistered/N30791-2017-10-28.md): Piper J5A · S/N 5260 · Cancelled Oct 28, 2017 · Revoked, canceled · Built 1940 · Morgan John E
- [N94126](https://openairdocs.org/deregistered/N94126-2017-03-21.md): Cessna 152 · S/N 15285602 · Cancelled Mar 21, 2017 · Registration expired, pending cancellation · Built 1982 · Hubbard James E
- [N35DS](https://openairdocs.org/deregistered/N35DS-2017-03-10.md): Dehavilland MK-35 · S/N A79-635 · Cancelled Mar 10, 2017 · Registration expired, pending cancellation · Built 1958 · Country Club Invest & Devel Co Inc
- [N7203E](https://openairdocs.org/deregistered/N7203E-2017-02-06.md): Beech F33A · S/N CE-1041 · Cancelled Feb 6, 2017 · Third renewal notice · Built 1984 · Parks Barry W
- [N527SR](https://openairdocs.org/deregistered/N527SR-2013-09-13.md): Beech 95-B55 (T42A) · S/N TC-2334 · Cancelled Sep 13, 2013 · Registration expired, pending cancellation · Built 1980 · Triwood Inc
- [N53FC](https://openairdocs.org/deregistered/N53FC-2013-06-27.md): Cessna 180A · S/N 50312 · Cancelled Jun 27, 2013 · Sale reported, canceled · Built 1958
- [N5665](https://openairdocs.org/deregistered/N5665-2013-05-23.md): Akers SKY FLY CA65-2 · S/N 6110 · Cancelled May 23, 2013 · Sale reported, pending cancellation · Built 1973
- [N9576W](https://openairdocs.org/deregistered/N9576W-2013-05-23.md): Piper PA-28-140 · S/N 28-23016 · Cancelled May 23, 2013 · Registration expired, pending cancellation · Built 1967 · Parks Edgar F
- [N62727](https://openairdocs.org/deregistered/N62727-2013-04-29.md): Piper PA-23-250 · S/N 27-7654178 · Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1976 · Spencer Hugh K
- [N5844X](https://openairdocs.org/deregistered/N5844X-2013-04-23.md): Cessna 310F · S/N 310-0144 · Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1961 · Airborne Inc
- [N14921](https://openairdocs.org/deregistered/N14921-2012-08-01.md): Nichols SPEZIO DAL-1 · S/N HN235 · Cancelled Aug 1, 2012 · Registration expired, pending cancellation · Built 1975 · Demastus Russell A
- [N905PS](https://openairdocs.org/deregistered/N905PS-2010-08-13.md): Cessna 150J · S/N 15070712 · Cancelled Aug 13, 2010 · Exported to Argentina · Built 1969 · Mcrobie David A
- [N392G](https://openairdocs.org/deregistered/N392G-2009-12-18.md): Orwig George T ACRO SPORT II · S/N 392 · Cancelled Dec 18, 2009 · Triennial form not returned · Orwig George T
- [N400LP](https://openairdocs.org/deregistered/N400LP-1999-04-01.md): Aero Commander 680V · S/N 1697-74 · Cancelled Apr 1, 1999 · Triennial form not returned · Country Club Investment & Dev Co Inc
- [N7028F](https://openairdocs.org/deregistered/N7028F-1996-08-14.md): Aero Commander 1121A · S/N 131 · Cancelled Aug 14, 1996 · Triennial form not returned · Fairmont State College
- [N44533](https://openairdocs.org/deregistered/N44533-1993-10-15.md): Archibald John W TERATORN TIERRA II · S/N 3449718 · Cancelled Oct 15, 1993 · Triennial form not returned · Browning James P
- [N9726Y](https://openairdocs.org/deregistered/N9726Y-1991-04-10.md): Beech P35 · S/N D7125 · Cancelled Apr 10, 1991 · Triennial form not returned · T & T Machine Co
- [N1895A](https://openairdocs.org/deregistered/N1895A-1973-10-01.md): Beech D55 · S/N TE-743 · Cancelled Oct 1, 1973 · Built 1969 · Interstate Engineers & Constructors Inc
- [N97023](https://openairdocs.org/deregistered/N97023-1955-12-09.md): Stinson 108-1 · S/N 108-1023 · Cancelled Dec 9, 1955 · Built 1946 · Nunnally W O
- [N52137](https://openairdocs.org/deregistered/N52137-1955-07-11.md): Pitts SPECIAL · S/N 7 · Cancelled Jul 11, 1955 · Morgan Pauline
- [N92021](https://openairdocs.org/deregistered/N92021-1949-05-10.md): Piper J3C-65 · S/N 16454 · Cancelled May 10, 1949 · Thompson Harry D
- [N93256](https://openairdocs.org/deregistered/N93256-1949-05-04.md): Commonwealth 185 · S/N 1819 · Cancelled May 4, 1949 · Mountaineer Air Service 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 = 'WV' AND d.registrant_city = 'FAIRMONT'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

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