# Cancelled registrations: Danville, VA

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

Cancelled aircraft registrations in Danville, VA.

- [N2300Q](https://openairdocs.org/deregistered/N2300Q-2020-05-08.md): Beech 23 · S/N M-371 · Cancelled May 8, 2020 · Revoked, canceled · Built 1963 · Dowdy John L Jr
- [N98550](https://openairdocs.org/deregistered/N98550-2020-01-10.md): Piper J3C-65 · S/N 18763 · Cancelled Jan 10, 2020 · Sale reported, canceled
- [N208AU](https://openairdocs.org/deregistered/N208AU-2015-10-14.md): Liberty Aerospace XL-2 · S/N 0114 · Cancelled Oct 14, 2015 · Built 2008 · Averett University Of Danville Va
- [N9089N](https://openairdocs.org/deregistered/N9089N-2014-05-21.md): Piper PA-28-161 · S/N 2816003 · Cancelled May 21, 2014 · Built 1986 · General Aviation Inc
- [N29ET](https://openairdocs.org/deregistered/N29ET-2000-06-01.md): Thomas Emory M MINI 500 · S/N ET3-0124 · Cancelled Jun 1, 2000 · Triennial form not returned · Thomas Emory M
- [N428ET](https://openairdocs.org/deregistered/N428ET-1998-09-02.md): Thomas Emory M RW133 · S/N ET2 · Cancelled Sep 2, 1998 · Triennial form not returned · Thomas Emory M
- [N2426A](https://openairdocs.org/deregistered/N2426A-1997-02-18.md): Piper PA-38-112 · S/N 3878A0682 · Cancelled Feb 18, 1997 · Triennial form not returned · General Aviation Inc
- [N25693](https://openairdocs.org/deregistered/N25693-1992-05-07.md): Piper PA-38-112 · S/N 3881A0056 · Cancelled May 7, 1992 · Triennial form not returned · General Aviation Inc
- [N56863](https://openairdocs.org/deregistered/N56863-1992-02-14.md): Piper PA-28R-200 · S/N 28R7435051 · Cancelled Feb 14, 1992 · Triennial form not returned · Amt Enterprises
- [N739QP](https://openairdocs.org/deregistered/N739QP-1991-07-22.md): Cessna 172N · S/N 17270723 · Cancelled Jul 22, 1991 · Exported to Germany · Fleming Thomas W
- [N873DB](https://openairdocs.org/deregistered/N873DB-1991-04-25.md): Beech 200 · S/N BB315 · Cancelled Apr 25, 1991 · Exported to Zimbabwe · Dibrell Brothers Incorporated
- [N43905](https://openairdocs.org/deregistered/N43905-1991-04-10.md): Piper PA-28-161 · S/N 288516043 · Cancelled Apr 10, 1991 · Triennial form not returned · General Aviation Inc
- [N8781V](https://openairdocs.org/deregistered/N8781V-1984-02-22.md): Bellanca 17-30A · S/N 30321 · Cancelled Feb 22, 1984 · Administratively canceled · Donelson Martin Jr
- [N64289](https://openairdocs.org/deregistered/N64289-1981-09-19.md): Bell 47G-3B-1 · S/N 3668 · Cancelled Sep 19, 1981 · City Civil Defense
- [N3629N](https://openairdocs.org/deregistered/N3629N-1970-12-07.md): Piper J-3 · S/N 22882 · Cancelled Dec 7, 1970 · Chester H Hosey
- [N2727A](https://openairdocs.org/deregistered/N2727A-1960-05-24.md): Stinson SR-10J · S/N 3-5827 · Cancelled May 24, 1960 · Built 1938 · Baker Corporation
- [N1676P](https://openairdocs.org/deregistered/N1676P-1959-04-27.md): Piper PA-18A · S/N 18-3805 · Cancelled Apr 27, 1959 · Smith Joseph Jones
- [N2725A](https://openairdocs.org/deregistered/N2725A-1957-01-09.md): Piper J3C-65 · S/N 8361 · Cancelled Jan 9, 1957 · General Aviation Inc
- [N55066](https://openairdocs.org/deregistered/N55066-1955-10-11.md): Boeing A75 · S/N 75217 · Cancelled Oct 11, 1955 · Danville Flying Service Inc
- [N94108](https://openairdocs.org/deregistered/N94108-1951-11-02.md): Engineering & Research 415-C · S/N 1431 · Cancelled Nov 2, 1951 · Richardson J C Jr
- [N3257H](https://openairdocs.org/deregistered/N3257H-1951-01-15.md): Engineering & Research ERCOUPE 415-C · S/N 3882 · Cancelled Jan 15, 1951 · Built 1946 · Danville Flying Service Inc
- [N34833](https://openairdocs.org/deregistered/N34833-1948-08-17.md): Rearwin 175 · S/N 1559 · Cancelled Aug 17, 1948 · Built 1941 · Swicegoodh. Frank
- [N8766](https://openairdocs.org/deregistered/N8766-1948-04-01.md): Swallow TP · S/N 166 · Cancelled Apr 1, 1948 · Miller Edward Howe Jr
- [N88572](https://openairdocs.org/deregistered/N88572-1947-09-11.md): Piper J3C-65 · S/N 16197 · Cancelled Sep 11, 1947 · Southern Airways Of Danville Inc
- [N163E](https://openairdocs.org/deregistered/N163E-1940-01-14.md): Curtiss-Robertson ROBIN · S/N 76 · Cancelled Jan 14, 1940 · Southern Airways Of Danville Inc
- [N10880](https://openairdocs.org/deregistered/N10880-1936-09-22.md): Stinson JR. S · S/N 8051 · Cancelled Sep 22, 1936 · Built 1931 · Southern Airways Of Danville Inc
- [N9047](https://openairdocs.org/deregistered/N9047-1936-09-15.md): Travel Air 2000 · S/N 848 · Cancelled Sep 15, 1936 · Built 1929 · Camden S W Jr
- [N5244](https://openairdocs.org/deregistered/N5244-1931-01-05.md): A V Roe AVRO BIPLANE · S/N 1257 · Cancelled Jan 5, 1931 · Moser W A

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

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