# Registered aircraft: Strasburg, VA

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

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

- [N1039K](https://openairdocs.org/aircraft/N1039K.md): Mooney M20J · S/N 24-3110 · Morris Eric K
- [N210DA](https://openairdocs.org/aircraft/N210DA.md): Beech 58 · S/N TH-1067 · Built 1979 · Stroemsvik Kristian
- [N2501M](https://openairdocs.org/aircraft/N2501M.md): Piper PA-23-250 · S/N 27-7954068 · Schwietz Thomas E Jr
- [N3074R](https://openairdocs.org/aircraft/N3074R.md): Piper PA-28R-200 · S/N 28R-35635 · Schwietz Thomas E
- [N311GP](https://openairdocs.org/aircraft/N311GP.md): Price Garry S SR PIETENPOL AIR CAMPER · S/N PIET-1930-94 · Phillips Brett D
- [N322U](https://openairdocs.org/aircraft/N322U.md): Beech 35-C33 · S/N CD-1063 · Built 1966 · Wright Gregory A
- [N3675M](https://openairdocs.org/aircraft/N3675M.md): Piper PA-12 · S/N 12-2625 · Schwietz Thomas
- [N3804M](https://openairdocs.org/aircraft/N3804M.md): Beech 58P · S/N TJ-328 · Built 1981 · Glenmont Air LLC
- [N4083Q](https://openairdocs.org/aircraft/N4083Q.md): Piper PA-28-140 · S/N 28-7725235 · Stroemsvik Kristian
- [N421NG](https://openairdocs.org/aircraft/N421NG.md): Cessna 421C · S/N 421C0129 · First renewal notice · Ultimate Airparts LLC
- [N42902](https://openairdocs.org/aircraft/N42902.md): Piper J3C-65 · S/N 15237 · Built 1945 · Phillips Brett D
- [N48322](https://openairdocs.org/aircraft/N48322.md): Cessna R172E · S/N R172-0213 · Stroemsvik Kristian
- [N5737W](https://openairdocs.org/aircraft/N5737W.md): Piper PA-28-150 · S/N 28-1426 · Built 1963 · Ultimate Airparts LLC
- [N5922Y](https://openairdocs.org/aircraft/N5922Y.md): Piper PA-23-250 · S/N 27-3080 · Built 1965 · Ultimate Air Parts LLC
- [N700YS](https://openairdocs.org/aircraft/N700YS.md): John D Dimascio SUPER SPORT · S/N 001 · Built 2016 · Schwietz Thomas E
- [N738PH](https://openairdocs.org/aircraft/N738PH.md): Cessna 172N · S/N 17270127 · Built 1977 · Stroemsvik Kristian
- [N8214X](https://openairdocs.org/aircraft/N8214X.md): Cessna 172B · S/N 17248714 · Built 1961 · Stroemsvik Kristian
- [N8799S](https://openairdocs.org/aircraft/N8799S.md): Cessna 150F · S/N 15062099 · Stroemsvik Kristian
- [N9131H](https://openairdocs.org/aircraft/N9131H.md): Cessna 172M · S/N 17265962 · Stroemsuik Kristian
- [N9372Q](https://openairdocs.org/aircraft/N9372Q.md): Beech G33 · S/N CD-1272 · Built 1972 · Ultimate Airparts LLC
- [N9421E](https://openairdocs.org/aircraft/N9421E.md): Cessna 172N · S/N 17272257 · Built 1979 · Stroemsvik Kristian
- [N97652](https://openairdocs.org/aircraft/N97652.md): Stinson 108 · S/N 108652 · Built 1946 · Hockman James C

## 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 = 'STRASBURG'
ORDER BY g.n_number
```

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