# Cancelled registrations: Clarksburg, WV

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

Cancelled aircraft registrations in Clarksburg, WV.

- [N6470G](https://openairdocs.org/deregistered/N6470G-2022-11-30.md): Cessna 150K · S/N 15071970 · Cancelled Nov 30, 2022 · Upton Nicholas D
- [N875RK](https://openairdocs.org/deregistered/N875RK-2013-09-17.md): Kimble Charles R SKY HAWK · S/N 87-5 · Cancelled Sep 17, 2013 · Registration expired, pending cancellation · Kimble Ron
- [N370RA](https://openairdocs.org/deregistered/N370RA-2013-08-06.md): S.O.C.A.T.A. MS RALLYE 235C · S/N 13233 · Cancelled Aug 6, 2013 · Sale reported, canceled · Built 1979
- [N68BF](https://openairdocs.org/deregistered/N68BF-2013-07-11.md): S.O.C.A.T.A. MS894A · S/N 12028 · Cancelled Jul 11, 2013 · Sale reported, canceled · Built 1973
- [N78519](https://openairdocs.org/deregistered/N78519-1971-02-24.md): Piper J3C-65 · S/N 22984 · Cancelled Feb 24, 1971 · Pickens J Keith Etal
- [N74809](https://openairdocs.org/deregistered/N74809-1970-12-01.md): Piper PA-18A · S/N 18-7356 · Cancelled Dec 1, 1970 · Fleet Rental Leasing Corp
- [N5486W](https://openairdocs.org/deregistered/N5486W-1970-09-03.md): Piper PA-28-160 · S/N 28-570 · Cancelled Sep 3, 1970 · Fleet Rental Leasing Corp
- [N4766B](https://openairdocs.org/deregistered/N4766B-1965-10-07.md): Cessna 180 · S/N 31664 · Cancelled Oct 7, 1965 · Exported to Belize · Built 1955 · Fleet Rental Leasing Corp
- [N6735T](https://openairdocs.org/deregistered/N6735T-1965-09-14.md): Cessna 310D · S/N 39035 · Cancelled Sep 14, 1965 · Aeromech Inc
- [N9627R](https://openairdocs.org/deregistered/N9627R-1965-04-29.md): Beech M35 · S/N D-6502 · Cancelled Apr 29, 1965 · Sheffer R K
- [N844K](https://openairdocs.org/deregistered/N844K-1965-04-28.md): Beech E18S · S/N BA207 · Cancelled Apr 28, 1965 · Hope Natural Gas Co
- [N8820R](https://openairdocs.org/deregistered/N8820R-1965-01-21.md): Bellanca 14-19-3 · S/N 4172 · Cancelled Jan 21, 1965 · Fleet Rental Leasing Corp
- [N3487P](https://openairdocs.org/deregistered/N3487P-1964-02-18.md): Piper PA-23-160 · S/N 23-1461 · Cancelled Feb 18, 1964 · Fleet Rental Leasing Corp
- [N2107M](https://openairdocs.org/deregistered/N2107M-1955-01-14.md): Piper J3C-65 · S/N 20891 · Cancelled Jan 14, 1955 · West Virginia Air Service Inc
- [N52940](https://openairdocs.org/deregistered/N52940-1951-01-09.md): Douglas DC3C-S1C3G · S/N 4551 · Cancelled Jan 9, 1951 · Exported to Venezuela · Built 1946 · Daft Henry
- [N51956](https://openairdocs.org/deregistered/N51956-1949-12-09.md): Aeronca 0-58B · S/N 12413 · Cancelled Dec 9, 1949 · Built 1945 · The Four Club
- [N30172](https://openairdocs.org/deregistered/N30172-1948-08-10.md): Waco UPF-7 · S/N 5569 · Cancelled Aug 10, 1948 · West Virginia Air Service Inc
- [N930M](https://openairdocs.org/deregistered/N930M-1931-11-24.md): Moth 60-GM · S/N 129 · Cancelled Nov 24, 1931 · Built 1930 · Clarksburg Airways 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 = 'CLARKSBURG'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

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