# Cancelled registrations: Mechanicsville, VA

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

Cancelled aircraft registrations in Mechanicsville, VA.

- [N7231L](https://openairdocs.org/deregistered/N7231L-2024-01-27.md): Lester Robert F PULSAR · S/N 298 · Cancelled Jan 27, 2024 · Sale reported, canceled · Built 1997
- [N8511L](https://openairdocs.org/deregistered/N8511L-2023-09-27.md): Eagle Balloons C-7 · S/N E877111 · Cancelled Sep 27, 2023 · Rosenbaum Henry D
- [N83712](https://openairdocs.org/deregistered/N83712-2023-03-04.md): Turney-Castaneda SONERAI II · S/N 1 · Cancelled Mar 4, 2023 · Registration expired, pending cancellation · Built 1982 · Auerbach David C
- [N5109P](https://openairdocs.org/deregistered/N5109P-2022-07-07.md): Piper PA-24-250 · S/N 24-119 · Cancelled Jul 7, 2022 · Built 1958 · Smith Evan B
- [N7291L](https://openairdocs.org/deregistered/N7291L-2022-05-23.md): Grumman American Avn. AA-5 · S/N AA5-0291 · Cancelled May 23, 2022 · Registration pending, canceled · Built 1972
- [N50F](https://openairdocs.org/deregistered/N50F-2021-07-31.md): Driggers Quillan E TITAN TORNADO · S/N 175 · Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Built 1999 · Myers Merlin Wayne
- [N412RM](https://openairdocs.org/deregistered/N412RM-2020-05-01.md): Myers Merlin Wayne SKYRANGER II · S/N 2000 · Cancelled May 1, 2020 · Registration expired, pending cancellation · Myers Merlin Wayne
- [N1442L](https://openairdocs.org/deregistered/N1442L-2019-03-20.md): Beech A23 · S/N M-836 · Cancelled Mar 20, 2019 · Registration expired · Built 1965 · Savage David B
- [N3709C](https://openairdocs.org/deregistered/N3709C-2017-07-20.md): Stinson L-5E · S/N 4302 · Cancelled Jul 20, 2017 · Registration expired, pending cancellation · Wharton M B
- [N6119H](https://openairdocs.org/deregistered/N6119H-2017-07-06.md): Eppa/Quicksilver MXL · S/N 001 · Cancelled Jul 6, 2017 · Registration expired, pending cancellation · Built 1983 · Mccardle Christy L
- [N86DR](https://openairdocs.org/deregistered/N86DR-2017-06-01.md): Bellanca 17-30A · S/N 74-30690 · Cancelled Jun 1, 2017 · Registration expired, pending cancellation · Built 1974 · St Clair David F
- [N142TC](https://openairdocs.org/deregistered/N142TC-2015-05-04.md): Thunder & Colt Airborne Amer AX7-77 S1 · S/N 1947USA · Cancelled May 4, 2015 · Registration expired, pending cancellation · Built 1991 · Rosenbaum Henry D
- [N755TS](https://openairdocs.org/deregistered/N755TS-2013-09-11.md): Simmons William T GLASTAR · S/N 5798 · Cancelled Sep 11, 2013 · Registration expired, pending cancellation · Simmons William T
- [N3707C](https://openairdocs.org/deregistered/N3707C-2012-11-08.md): Stinson L-5E · S/N 3858 · Cancelled Nov 8, 2012 · Registration expired, pending cancellation · Built 1960 · Wharton M B
- [N70447](https://openairdocs.org/deregistered/N70447-2012-08-10.md): North American T-28C · S/N BU#140607 · Cancelled Aug 10, 2012 · Registration pending, canceled · Built 1958
- [N138M](https://openairdocs.org/deregistered/N138M-2010-03-26.md): Stanley Gary TITAN TORNADO · S/N D94582COHK0099 · Cancelled Mar 26, 2010 · Exported to Australia · Built 1995 · Myers Merlin W
- [N177WM](https://openairdocs.org/deregistered/N177WM-2010-03-26.md): Titan TORNADO · S/N D92503SOHK0044 · Cancelled Mar 26, 2010 · Exported to Australia · Built 1994 · Myers Merlin Wayne
- [N38431](https://openairdocs.org/deregistered/N38431-2008-09-04.md): Piper PA-34-200T · S/N 34-7770304 · Cancelled Sep 4, 2008 · Exported to Canada · Built 1977 · Stoneman Gp DBA
- [N4117B](https://openairdocs.org/deregistered/N4117B-2003-10-01.md): Aero Commander 520 · S/N 520-18 · Cancelled Oct 1, 2003 · Triennial form not returned · Built 1952 · Wright Michael E
- [N581BC](https://openairdocs.org/deregistered/N581BC-2000-05-12.md): Beech 58TC · S/N TK-125 · Cancelled May 12, 2000 · Stoneman Gregory P
- [N28713](https://openairdocs.org/deregistered/N28713-1992-09-24.md): Luscombe 8A · S/N 1474 · Cancelled Sep 24, 1992 · Exported to United Kingdom · Seiler Scott S
- [N2297Z](https://openairdocs.org/deregistered/N2297Z-1984-10-25.md): Ness A K VOLMER VJ22 · S/N N1S1 · Cancelled Oct 25, 1984 · Administratively canceled · Sterling William C
- [N943Z](https://openairdocs.org/deregistered/N943Z-1965-02-06.md): Benson B-8 · S/N L-B 2018 · Cancelled Feb 6, 1965 · Branch Thomas H

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

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