# Cancelled registrations: Salem, VA

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

Cancelled aircraft registrations in Salem, VA.

- [N249](https://openairdocs.org/deregistered/N249-2022-12-31.md): Barrows Robert E RB-3 · S/N 195677 · Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Mullins Jerry W
- [N2187P](https://openairdocs.org/deregistered/N2187P-2021-10-07.md): Bell 206B · S/N 3499 · Cancelled Oct 7, 2021 · Exported to Sri Lanka · Built 1981 · Summit Helicopters Inc
- [N701DS](https://openairdocs.org/deregistered/N701DS-2019-05-06.md): Small Douglas A LONG EZ · S/N 2091-L · Cancelled May 6, 2019 · Registration expired, pending cancellation · Built 1998 · Crowder Allen W
- [N122AL](https://openairdocs.org/deregistered/N122AL-2018-06-08.md): Bellanca 17-31A · S/N 32-92 · Cancelled Jun 8, 2018 · Registration expired, pending cancellation · Built 1972 · Mullins Jerry W
- [N1170E](https://openairdocs.org/deregistered/N1170E-2017-02-04.md): Aeronca 7AC · S/N 7AC-4726 · Cancelled Feb 4, 2017 · Revoked, canceled · Built 1946 · Minter Edward J
- [N7641D](https://openairdocs.org/deregistered/N7641D-2015-05-11.md): Piper PA-22-150 · S/N 22-5350 · Cancelled May 11, 2015 · Registration expired, pending cancellation · Built 1957 · Hancock Randall
- [N8096B](https://openairdocs.org/deregistered/N8096B-2015-05-04.md): Tomelty Joseph P 532 ELITE · S/N JT532ACE · Cancelled May 4, 2015 · Registration expired, pending cancellation · Tomelty Joseph P
- [N6857N](https://openairdocs.org/deregistered/N6857N-2013-11-12.md): Mooney M20C · S/N 680139 · Cancelled Nov 12, 2013 · Revoked, canceled · Built 1968 · Anthony Lee S
- [N55BR](https://openairdocs.org/deregistered/N55BR-2013-11-08.md): Let L-23 SUPER BLANIK · S/N 928001 · Cancelled Nov 8, 2013 · Registration expired, pending cancellation · Built 1992 · Blue Ridge Soaring Society
- [N99795](https://openairdocs.org/deregistered/N99795-2013-07-30.md): Engineering & Research ERCOUPE 415-C · S/N 2418 · Cancelled Jul 30, 2013 · Sale reported, canceled · Built 1946
- [N7176X](https://openairdocs.org/deregistered/N7176X-2013-02-20.md): Cessna 150A · S/N 15059276 · Cancelled Feb 20, 2013 · Sale reported, canceled · Built 1961
- [N3663E](https://openairdocs.org/deregistered/N3663E-2011-07-06.md): Aeronca 7BCM · S/N 7AC-6978 · Cancelled Jul 6, 2011 · Revoked, canceled · Built 1947 · Minter Edward J
- [N28940](https://openairdocs.org/deregistered/N28940-2001-08-07.md): Aerostar International RX-7 · S/N RX7-3030 · Cancelled Aug 7, 2001 · Triennial form not returned · Mcdaniel Edgar Clinton
- [N5652B](https://openairdocs.org/deregistered/N5652B-1976-05-25.md): Cessna 182 · S/N 33652 · Cancelled May 25, 1976 · Ed Marshall Insurance Ltd
- [N5484U](https://openairdocs.org/deregistered/N5484U-1972-02-01.md): Beech 95-C55 · S/N TE421 · Cancelled Feb 1, 1972 · Cliff Manufacturing Co
- [N2424P](https://openairdocs.org/deregistered/N2424P-1971-06-22.md): Piper PA-22 · S/N 22-2795 · Cancelled Jun 22, 1971 · Exported to Canada · Martin Frank L/Anderson Ray
- [N60609](https://openairdocs.org/deregistered/N60609-1971-05-03.md): Taylorcraft DCO-65 · S/N L-5590 · Cancelled May 3, 1971 · Hicks K S Jr - Lindamood G W
- [N62108](https://openairdocs.org/deregistered/N62108-1955-10-25.md): Consolidated Vultee BT-13A · S/N 5681 · Cancelled Oct 25, 1955 · Thomas Hugh Edward

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

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