# Cancelled registrations: Martinsville, VA

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

Cancelled aircraft registrations in Martinsville, VA.

- [N319TA](https://openairdocs.org/deregistered/N319TA-2021-05-08.md): Costruzioni Aeronautiche Tecna P2004 BRAVO · S/N 125 · Cancelled May 8, 2021 · Registration expired, pending cancellation · Built 2008 · Mid-Atlantic Air Ventures Inc
- [N115TE](https://openairdocs.org/deregistered/N115TE-2021-01-30.md): Costruzioni Aeronautiche Tecna P92 EAGLET · S/N 1215 · Cancelled Jan 30, 2021 · Registration expired, pending cancellation · Built 2008 · Mid Atlantic Air Ventures Inc
- [N1064A](https://openairdocs.org/deregistered/N1064A-2013-07-29.md): Adams Balloon A55 · S/N 066 · Cancelled Jul 29, 2013 · Registration expired, pending cancellation · Built 1980 · Simmons Richard Morgan Jr
- [N6221H](https://openairdocs.org/deregistered/N6221H-2011-01-31.md): Smith Michael H MHS-100A · S/N 0809538850-1 · Cancelled Jan 31, 2011 · Triennial form not returned · Smith Michael H
- [N968D](https://openairdocs.org/deregistered/N968D-2009-09-17.md): Stinson 108-2 · S/N 108-2968 · Cancelled Sep 17, 2009 · Registration revoked · Built 1947 · Koumparakis George
- [N1185P](https://openairdocs.org/deregistered/N1185P-2009-06-25.md): Piper PA-23 · S/N 23-199 · Cancelled Jun 25, 2009 · Registration revoked · Built 1955 · Koumparakis George S
- [N5347J](https://openairdocs.org/deregistered/N5347J-2007-04-11.md): Cessna 172N · S/N 17273761 · Cancelled Apr 11, 2007 · Triennial form not returned · Heart Of Virginia Aviation
- [N63799](https://openairdocs.org/deregistered/N63799-2005-05-12.md): Smith Steve D SMITH GYRO-1 · S/N 223-94-9527-1 · Cancelled May 12, 2005 · Triennial form not returned · Built 1999 · Smith Steve D
- [N17HA](https://openairdocs.org/deregistered/N17HA-2001-12-12.md): Bell 206B · S/N 2003 · Cancelled Dec 12, 2001 · Exported to Canada · Built 1976 · Hussey W Lee II
- [N15728](https://openairdocs.org/deregistered/N15728-1997-02-19.md): Aeronca LB · S/N 2004 · Cancelled Feb 19, 1997 · Triennial form not returned · Lester Morton W
- [N16294](https://openairdocs.org/deregistered/N16294-1997-02-19.md): Aeronca LB · S/N 2032 · Cancelled Feb 19, 1997 · Triennial form not returned · Lester Morton W
- [N6360S](https://openairdocs.org/deregistered/N6360S-1991-06-10.md): Cessna 150G · S/N 15067160 · Cancelled Jun 10, 1991 · Triennial form not returned · Allen Carroll J
- [N107LH](https://openairdocs.org/deregistered/N107LH-1991-03-22.md): Hussey Les ROTORWAY EXEC · S/N 225945484 · Cancelled Mar 22, 1991 · Triennial form not returned · Hussey Les
- [N9054V](https://openairdocs.org/deregistered/N9054V-1981-09-14.md): Willwerth Clarence C VARIEZE · S/N 656 · Cancelled Sep 14, 1981 · Clarence C Willwerth Jr
- [N2391H](https://openairdocs.org/deregistered/N2391H-1965-05-19.md): Ercoupe 415-C · S/N 3016 · Cancelled May 19, 1965 · Built 1946 · Sutton J P Et Al
- [N838C](https://openairdocs.org/deregistered/N838C-1965-05-18.md): Stinson 108-3 · S/N 108-3838 · Cancelled May 18, 1965 · Fisher Lawrence D Jr
- [N46957](https://openairdocs.org/deregistered/N46957-1948-10-04.md): Piper J3C-65 · S/N 10437 · Cancelled Oct 4, 1948 · Virginia Aircraft Sales Co Inc
- [N9121H](https://openairdocs.org/deregistered/N9121H-1948-04-29.md): Stinson VULTEE V-77 · S/N 77-15 · Cancelled Apr 29, 1948 · Turner R C
- [N9122H](https://openairdocs.org/deregistered/N9122H-1948-04-29.md): Stinson AT-19 · S/N 77-32 · Cancelled Apr 29, 1948 · Turner R J
- [N36091](https://openairdocs.org/deregistered/N36091-1943-08-12.md): Taylorcraft BL-65 · S/N 3058 · Cancelled Aug 12, 1943 · Built 1939 · Covington John Glen
- [N21048](https://openairdocs.org/deregistered/N21048-1941-11-24.md): Aeronca KCA · S/N KCA-25 · Cancelled Nov 24, 1941 · Mitchell George D

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

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