# Registered aircraft: Spotsylvania, VA

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

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

- [N1170G](https://openairdocs.org/aircraft/N1170G.md): Mooney M20J · S/N 24-1315 · Built 1982 · Stephansky John J Jr
- [N128JF](https://openairdocs.org/aircraft/N128JF.md): Cirrus Design SR20 · S/N 1316 · Built 2003 · Floyd Stephen M
- [N1935Y](https://openairdocs.org/aircraft/N1935Y.md): Mooney M20E · S/N 289 · Built 1964 · Hodges William L Jr
- [N201DF](https://openairdocs.org/aircraft/N201DF.md): Mooney M20J · S/N 24-0061 · Built 1976 · Flying Fox LLC
- [N2303D](https://openairdocs.org/aircraft/N2303D.md): Cessna 170B · S/N 20455 · Built 1952 · Demar Aviation LLC
- [N236HP](https://openairdocs.org/aircraft/N236HP.md): Beech A36 · S/N E2399 · Built 1987 · Proctor John M
- [N246VA](https://openairdocs.org/aircraft/N246VA.md): Brascher H M/Booth D C RV-8A · S/N 81121 · Built 2003 · Brascher Harry M
- [N302DL](https://openairdocs.org/aircraft/N302DL.md): DJI AGRAS T50 · S/N 1581F6BUB24B4001KK68 · Dutcher Land Management LLC
- [N30301](https://openairdocs.org/aircraft/N30301.md): Beech 35-B33 · S/N CD-450 · Built 1962 · Brown Gregory R
- [N32HB](https://openairdocs.org/aircraft/N32HB.md): Piper PA-18-150 · S/N 18-7509046 · Beals Thomas
- [N3671A](https://openairdocs.org/aircraft/N3671A.md): Vans RV-12 · S/N 120482 · Built 2020 · Burke Stephen N
- [N36E](https://openairdocs.org/aircraft/N36E.md): Beech A36 · S/N E-1455 · Built 1979 · Beals Thomas H
- [N409TT](https://openairdocs.org/aircraft/N409TT.md): Cessna LC42-550FG · S/N 421020 · Built 2009 · Mad Dog Air LLC
- [N4307Y](https://openairdocs.org/aircraft/N4307Y.md): Piper PA-32R-301 · S/N 32R-8313022 · Built 1983 · Shoulder Solutions LLC
- [N509FA](https://openairdocs.org/aircraft/N509FA.md): Talos Drones T60X · S/N 2104F7EZW255Q00121Y3 · Cedar Lane Farm Va LLC
- [N542LD](https://openairdocs.org/aircraft/N542LD.md): DJI AGRAS T50 · S/N 1581F6BUB24B60014FVP · Dutcher Land Management LLC
- [N555NG](https://openairdocs.org/aircraft/N555NG.md): Ryan NAVION A · S/N NAV-4-1829 · Built 1949 · Pattillo Jon S
- [N5633Q](https://openairdocs.org/aircraft/N5633Q.md): Mooney M20C · S/N 3015 · Built 1965 · Keene John D
- [N5798V](https://openairdocs.org/aircraft/N5798V.md): Beech A23-19 · S/N MB-58 · Built 1966 · Harlow Daniel E
- [N719LM](https://openairdocs.org/aircraft/N719LM.md): Cirrus Design SR22 · S/N 0590 · Purcell Daniel G
- [N81DG](https://openairdocs.org/aircraft/N81DG.md): Piper PA-28-180 · S/N 28-4579 · Built 1967 · Rae Seth R
- [N8206K](https://openairdocs.org/aircraft/N8206K.md): Stinson 108-1 · S/N 108-1206 · Built 1946 · Johnson Brett C
- [N849CF](https://openairdocs.org/aircraft/N849CF.md): Cessna T182T · S/N T18208149 · Built 2002 · Ellison David B
- [N896AM](https://openairdocs.org/aircraft/N896AM.md): Diamond Aircraft Ind DA 40 · S/N 40.896 · Built 2008 · Erikson Diversified Industries Inc
- [N92005](https://openairdocs.org/aircraft/N92005.md): Piper J3C-65 · S/N 16438 · Built 1946 · Sikkema Brian J

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
WHERE g.registrant_state = 'VA' AND g.registrant_city = 'SPOTSYLVANIA'
ORDER BY g.n_number
```

This list as a web page: https://openairdocs.org/faa-place/VA/Spotsylvania/aircraft

---
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.