# Cancelled registrations: Martinsburg, WV

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

Cancelled aircraft registrations in Martinsburg, WV.

- [N38407](https://openairdocs.org/deregistered/N38407-2021-07-31.md): Piper J5A · S/N 5-958 · Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Built 1941 · Grove Myrna S
- [N5957R](https://openairdocs.org/deregistered/N5957R-2020-11-06.md): Cessna 172G · S/N 17253626 · Cancelled Nov 6, 2020 · First renewal notice · Built 1965 · Pikeside Flying Club Inc
- [N476HS](https://openairdocs.org/deregistered/N476HS-2018-02-16.md): Piper PA-31-310 · S/N 31-633 · Cancelled Feb 16, 2018 · Registration expired, pending cancellation · Built 1970 · Air Photographics Inc
- [N6561X](https://openairdocs.org/deregistered/N6561X-2017-03-07.md): Tiger AG-5B · S/N 10252 · Cancelled Mar 7, 2017 · Registration expired, pending cancellation · Tiger Aircraft Corporation
- [N379KK](https://openairdocs.org/deregistered/N379KK-2017-01-26.md): Lecuyer Dan DOMINATOR · S/N 001 · Cancelled Jan 26, 2017 · Built 2005 · King Kevin W
- [N9888Q](https://openairdocs.org/deregistered/N9888Q-2015-05-11.md): Cessna 172M · S/N 17265832 · Cancelled May 11, 2015 · Registration expired, pending cancellation · Built 1975 · Buckman Robert F
- [N2523X](https://openairdocs.org/deregistered/N2523X-2007-11-28.md): Cessna P206 · S/N P206-0023 · Cancelled Nov 28, 2007 · Exported to Mexico · Built 1964 · Air Photographics Inc
- [N2815T](https://openairdocs.org/deregistered/N2815T-1995-05-11.md): Piper PA-28R-200 · S/N 28R7235138 · Cancelled May 11, 1995 · Triennial form not returned · Rosage Lawrence R
- [N9760P](https://openairdocs.org/deregistered/N9760P-1992-04-01.md): Piper PA-25-260 · S/N 257556070 · Cancelled Apr 1, 1992 · Exported to Mexico · Tri-State Aero Inc
- [N6562F](https://openairdocs.org/deregistered/N6562F-1985-06-13.md): Cessna 150F · S/N 15063162 · Cancelled Jun 13, 1985 · Hovermale Herbert M
- [N4824Z](https://openairdocs.org/deregistered/N4824Z-1975-04-23.md): Piper PA-22-108 · S/N 22-8396 · Cancelled Apr 23, 1975 · Exported to Canada · Miller Gary L
- [N9299B](https://openairdocs.org/deregistered/N9299B-1974-10-23.md): Cessna 175 · S/N 55099 · Cancelled Oct 23, 1974 · East Coast Flying Service Inc
- [N72247](https://openairdocs.org/deregistered/N72247-1965-05-25.md): Cessna 140 · S/N 9421 · Cancelled May 25, 1965 · Exported to Iceland · Howard Aircraft
- [N83325](https://openairdocs.org/deregistered/N83325-1964-08-05.md): Aeronca 7AC · S/N 7AC-1992 · Cancelled Aug 5, 1964 · Exported to Canada · Barney C William
- [N3674C](https://openairdocs.org/deregistered/N3674C-1963-12-09.md): Cessna 180 · S/N 31173 · Cancelled Dec 9, 1963 · East Coast Flying Service Inc
- [N121T](https://openairdocs.org/deregistered/N121T-1960-08-03.md): Piper PA-18 · S/N 18-2235 · Cancelled Aug 3, 1960 · Civil Air Patrol
- [N2093A](https://openairdocs.org/deregistered/N2093A-1960-04-26.md): Aeronca L-16A · S/N 7BCM-132 · Cancelled Apr 26, 1960 · Civil Airl Patrol West Virginia Wing
- [N45913](https://openairdocs.org/deregistered/N45913-1956-11-07.md): Luscombe 8A · S/N 2440 · Cancelled Nov 7, 1956 · Pinder H J
- [N60600](https://openairdocs.org/deregistered/N60600-1956-02-15.md): Fairchild M-62A · S/N T43-5622 · Cancelled Feb 15, 1956 · Ruppenthal Paul Meadford
- [N33B](https://openairdocs.org/deregistered/N33B-1955-10-07.md): Bolton XB1 · S/N 1 · Cancelled Oct 7, 1955 · Martinsburg Aircraft Service Inc
- [N2575H](https://openairdocs.org/deregistered/N2575H-1951-11-21.md): Ercoupe 415-C · S/N 3200 · Cancelled Nov 21, 1951 · Built 1946 · Martinsburg Flying Service
- [N38313](https://openairdocs.org/deregistered/N38313-1951-11-05.md): Piper J3L-65 · S/N 6925 · Cancelled Nov 5, 1951 · Evans R B
- [N3897N](https://openairdocs.org/deregistered/N3897N-1950-01-30.md): Beech 35 · S/N D-1142 · Cancelled Jan 30, 1950 · Martinsburg Flying Service Inc
- [N51717](https://openairdocs.org/deregistered/N51717-1948-12-02.md): Fairchild M-62A · S/N T43-5313 · Cancelled Dec 2, 1948 · Frank T Mcqueen
- [N38804](https://openairdocs.org/deregistered/N38804-1947-10-16.md): Piper J3L-65 · S/N 7281 · Cancelled Oct 16, 1947 · Built 1941 · Ruppenthal P M

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

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