# Cancelled registrations: Sandston, VA

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

Cancelled aircraft registrations in Sandston, VA.

- [N2447](https://openairdocs.org/deregistered/N2447-2020-08-02.md): Jett-Eaa Biplane P-1 · S/N 001 · Cancelled Aug 2, 2020 · Registration expired, pending cancellation · Built 1970 · Weaver Chad E
- [N45807](https://openairdocs.org/deregistered/N45807-2020-06-12.md): Silvaire LUSCOMBE 8A · S/N 2334 · Cancelled Jun 12, 2020 · Revoked, canceled · Built 1946 · Morris Alvie E
- [N108S](https://openairdocs.org/deregistered/N108S-2019-11-29.md): Orloff-Geist SPEZIO SPORT DAL-1 · S/N 314 · Cancelled Nov 29, 2019 · Registration expired, pending cancellation · Built 1976 · Clarke Robert E
- [N665WB](https://openairdocs.org/deregistered/N665WB-2015-05-15.md): Dehavilland CHIPMUNK 22A · S/N C1-0113 · Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1955 · Tomlinson Robert L
- [N866JS](https://openairdocs.org/deregistered/N866JS-2014-11-20.md): Learjet 23 · S/N 23-018 · Cancelled Nov 20, 2014 · Registration expired, pending cancellation · Built 1965 · Sills J Kennedy
- [N1407V](https://openairdocs.org/deregistered/N1407V-2013-11-12.md): Cessna 172M · S/N 17263552 · Cancelled Nov 12, 2013 · Registration expired, pending cancellation · Built 1974 · Commonwealth Jet Service Inc
- [N6446X](https://openairdocs.org/deregistered/N6446X-2013-04-29.md): Cessna U206G · S/N U20605891 · Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1980 · John Erickson Assocs Inc
- [N828BA](https://openairdocs.org/deregistered/N828BA-2010-04-21.md): Bell 206B · S/N 3426 · Cancelled Apr 21, 2010 · Triennial form not returned · Built 1981 · Heloair
- [N9209U](https://openairdocs.org/deregistered/N9209U-2009-09-15.md): Cessna 150M · S/N 15078160 · Cancelled Sep 15, 2009 · Registration revoked · Built 1976 · Sills Sales & Service Inc
- [N3107V](https://openairdocs.org/deregistered/N3107V-1999-01-28.md): Cessna R172K · S/N R1722239 · Cancelled Jan 28, 1999 · Triennial form not returned · Martinair Inc
- [N525MA](https://openairdocs.org/deregistered/N525MA-1994-11-17.md): Mitsubishi MU-2B-26 · S/N 340 · Cancelled Nov 17, 1994 · Second triennial mailing, no response · Commonwealth Jet Service Inc
- [N4433E](https://openairdocs.org/deregistered/N4433E-1984-12-12.md): Piper PA-38-112 · S/N 38-78A0601 · Cancelled Dec 12, 1984 · Built 1978 · Aero Industries Inc
- [N36739](https://openairdocs.org/deregistered/N36739-1982-11-16.md): Piper PA-28R-201 · S/N 28R-7837289 · Cancelled Nov 16, 1982 · Built 1978 · Aero Industries Inc
- [N43594](https://openairdocs.org/deregistered/N43594-1980-08-05.md): Piper PA-28-151 · S/N 28-7415533 · Cancelled Aug 5, 1980 · Built 1974 · Aero Industries Inc
- [N55403](https://openairdocs.org/deregistered/N55403-1980-08-01.md): Piper PA-28-140 · S/N 287325396 · Cancelled Aug 1, 1980 · Aero Industries Inc
- [N5806G](https://openairdocs.org/deregistered/N5806G-1977-07-12.md): Cessna 150K · S/N 150-71306 · Cancelled Jul 12, 1977 · Archer Kenneth L
- [N5199B](https://openairdocs.org/deregistered/N5199B-1975-05-08.md): Bell 47J · S/N 1733 · Cancelled May 8, 1975 · Hawthorne Aviation Inc
- [N3593X](https://openairdocs.org/deregistered/N3593X-1973-10-30.md): Mooney M-20G · S/N 680162 · Cancelled Oct 30, 1973 · Richmond Aviation Inc
- [N6597Q](https://openairdocs.org/deregistered/N6597Q-1972-02-23.md): Alon A2 · S/N A-97 · Cancelled Feb 23, 1972 · Richmond Aviation Inc
- [N4199P](https://openairdocs.org/deregistered/N4199P-1968-04-22.md): Piper PA-23-160 · S/N 23-1688 · Cancelled Apr 22, 1968 · Aero Industries
- [N5146W](https://openairdocs.org/deregistered/N5146W-1968-04-22.md): Piper PA-28-160 · S/N 28-177 · Cancelled Apr 22, 1968 · Aero Industries
- [N71842](https://openairdocs.org/deregistered/N71842-1967-12-06.md): Luscombe 8A · S/N 3269 · Cancelled Dec 6, 1967 · Exported to Canada · Hamm Herman
- [N4257A](https://openairdocs.org/deregistered/N4257A-1967-04-14.md): Beech C-45H · S/N AF-659 · Cancelled Apr 14, 1967 · Virginia Wing Civil Air Patrol
- [N2040A](https://openairdocs.org/deregistered/N2040A-1967-03-13.md): Piper J-3C · S/N 543 · Cancelled Mar 13, 1967 · Virginia Wing Civil Air Patrol
- [N1479V](https://openairdocs.org/deregistered/N1479V-1963-11-19.md): Piper J3C-65 · S/N 12943 · Cancelled Nov 19, 1963 · Civil Air Patrol Inc
- [N4246A](https://openairdocs.org/deregistered/N4246A-1963-11-19.md): Ryan NAVION · S/N NAV4-1632 · Cancelled Nov 19, 1963 · Civil Air Patrol Virginia Wing
- [N6811H](https://openairdocs.org/deregistered/N6811H-1962-03-06.md): Piper J3C-65 · S/N 20024 · Cancelled Mar 6, 1962 · Civil Air Patrol Of Virginia Inc
- [N1352V](https://openairdocs.org/deregistered/N1352V-1955-10-05.md): Piper L-4J · S/N 13962 · Cancelled Oct 5, 1955 · Civil Air Patrol Virginia Wing
- [N1220M](https://openairdocs.org/deregistered/N1220M-1951-02-12.md): Boeing E75 · S/N 75-8176 · Cancelled Feb 12, 1951 · Built 1943 · Civil Air Patrol Of Va Inc

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

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