# Cancelled registrations: South Charleston, WV

A list on [South Charleston, WV](https://openairdocs.org/faa-place/WV/South%20Charleston.md).

Cancelled aircraft registrations in South Charleston, WV.

- [N43230](https://openairdocs.org/deregistered/N43230-2022-07-26.md): Rans S-5 COYOTE 1 · S/N 93198 · Cancelled Jul 26, 2022 · Registration expired, pending cancellation · Boyd Philip M
- [N2549C](https://openairdocs.org/deregistered/N2549C-2021-04-03.md): Shirley Bret K TUKAN · S/N BS0001 · Cancelled Apr 3, 2021 · Registration expired, pending cancellation · Built 2002 · Fields Anthony D
- [N46697](https://openairdocs.org/deregistered/N46697-2020-02-28.md): Interstate S-1B1 · S/N 13 · Cancelled Feb 28, 2020 · Revoked, canceled · Built 1942 · Collins Willard M Lt
- [N8961D](https://openairdocs.org/deregistered/N8961D-2018-03-19.md): Piper PA-22-160 · S/N 22-6125 · Cancelled Mar 19, 2018 · Registration expired, pending cancellation · Built 1958 · Vintage Air LLC
- [N6238S](https://openairdocs.org/deregistered/N6238S-2013-08-05.md): Cessna 150G · S/N 15067038 · Cancelled Aug 5, 2013 · Revoked, canceled · Built 1967 · Mallory B F
- [N21GT](https://openairdocs.org/deregistered/N21GT-2013-07-30.md): Starduster SA-100 · S/N GTG-1 · Cancelled Jul 30, 2013 · Registration expired, pending cancellation · Built 1977 · Worley Hilda F
- [N88025](https://openairdocs.org/deregistered/N88025-2011-06-29.md): Piper J3C-65 · S/N 15645 · Cancelled Jun 29, 2011 · First renewal notice · Built 1961 · Whaley Clayton L
- [N79SP](https://openairdocs.org/deregistered/N79SP-1997-03-25.md): Bell Helicopter Textron 206L-1 · S/N 45540 · Cancelled Mar 25, 1997 · West Virginia State Police
- [N12921](https://openairdocs.org/deregistered/N12921-1992-10-07.md): Cessna 172M · S/N 17262373 · Cancelled Oct 7, 1992 · Triennial form not returned · Mallory Benjamin F
- [N7583H](https://openairdocs.org/deregistered/N7583H-1982-11-05.md): Piper PA-12 · S/N 12-456 · Cancelled Nov 5, 1982 · Mallory Benjamin F
- [N27JK](https://openairdocs.org/deregistered/N27JK-1982-09-21.md): Karr KR-2 · S/N 13650715 · Cancelled Sep 21, 1982 · Built 1981 · Karr Darwin J
- [N2094A](https://openairdocs.org/deregistered/N2094A-1967-10-06.md): Aeronca 7BCM · S/N 7BCM-387 · Cancelled Oct 6, 1967 · Civil Air Patrol Inc
- [N6733M](https://openairdocs.org/deregistered/N6733M-1965-12-22.md): Stinson 108-3 · S/N 108-4733 · Cancelled Dec 22, 1965 · Spring Hill Flying Club Inc
- [N46218](https://openairdocs.org/deregistered/N46218-1959-09-15.md): Ryan Aeronautical ST3KR · S/N 1368 · Cancelled Sep 15, 1959 · Built 1944 · Baria Richard A & Baria Frank O Jr
- [N51970](https://openairdocs.org/deregistered/N51970-1955-12-05.md): Consolidated Vultee BT-13B · S/N 79-478 · Cancelled Dec 5, 1955 · Built 1943 · Darrah James S
- [N75145](https://openairdocs.org/deregistered/N75145-1955-10-24.md): Consolidated Vultee BT-13A · S/N 5989 · Cancelled Oct 24, 1955 · Richard M Dobie
- [N29227](https://openairdocs.org/deregistered/N29227-1955-10-21.md): Aeronca 65-TC · S/N C2790T · Cancelled Oct 21, 1955 · Built 1940 · Hodges William S
- [N83707](https://openairdocs.org/deregistered/N83707-1951-02-27.md): Aeronca 7AC · S/N 7AC-2385 · Cancelled Feb 27, 1951 · Maiscott Edgar G Jr
- [N96829](https://openairdocs.org/deregistered/N96829-1951-02-16.md): Taylorcraft BC12-D · S/N 9129 · Cancelled Feb 16, 1951 · Built 1946 · Weikle Marcus L
- [N5250M](https://openairdocs.org/deregistered/N5250M-1951-01-02.md): Taylorcraft BC12-D · S/N 10550 · Cancelled Jan 2, 1951 · Built 1947 · Weikle Marcus L
- [N39736](https://openairdocs.org/deregistered/N39736-1949-08-05.md): Waco UPF-7 · S/N 5869 · Cancelled Aug 5, 1949 · Darrah James S
- [N20773](https://openairdocs.org/deregistered/N20773-1943-04-19.md): Beech F17D · S/N 311 · Cancelled Apr 19, 1943 · Built 1939 · Barium Reduction Corporation
- [N13121](https://openairdocs.org/deregistered/N13121-1933-02-11.md): Gilmore-Heath SUPER PARASOL · S/N 1 · Cancelled Feb 11, 1933 · Gilmore C B
- [N84799](https://openairdocs.org/deregistered/N84799-undated.md): Aeronca 7AC-CONV · S/N 7AC-3512 · Cancellation date not recorded · Built 1946 · Snodgrass Carl

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

This list as a web page: https://openairdocs.org/faa-place/WV/South%20Charleston/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, except the copies of manufacturers’ service documents, which belong to their rights holders.
