# Registered aircraft: New Market, VA

A list on [New Market, VA](https://openairdocs.org/faa-place/VA/New%20Market.md).

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

- [N111MY](https://openairdocs.org/aircraft/N111MY.md): Piper PA-23-250 · S/N 27-7854092 · Built 1978 · Meshed Networx LLC
- [N19E](https://openairdocs.org/aircraft/N19E.md): Stinson SR-10F · S/N 5836 · Built 1955 · Leggett Ray M
- [N22VY](https://openairdocs.org/aircraft/N22VY.md): Robert J Coolbaugh COOLBAUGH-PIETENPOL · S/N 02BC · Built 2014 · Coolbaugh Robert J
- [N237WA](https://openairdocs.org/aircraft/N237WA.md): DJI AGRAS T40 · S/N 64TBL63002005C · Just Aerial Application LLC
- [N368QJ](https://openairdocs.org/aircraft/N368QJ.md): DJI AGRAS T50 · S/N 63MYBM4M00200BA · Just Aerial Application LLC
- [N39153](https://openairdocs.org/aircraft/N39153.md): Taylorcraft BC12-65 · S/N 3369 · Built 1942 · George Christopher K
- [N414MW](https://openairdocs.org/aircraft/N414MW.md): Cessna 414 · S/N 4140919 · Fly The Valley LLC
- [N501TJ](https://openairdocs.org/aircraft/N501TJ.md): DJI AGRAS T50 · S/N 8GHWN4C00127P7 · Just Aerial Application LLC
- [N524W](https://openairdocs.org/aircraft/N524W.md): Monocoupe 110 · S/N 6W12 · Coolbaugh Robert J
- [N543W](https://openairdocs.org/aircraft/N543W.md): Monocoupe 90 · S/N 562 · Built 1930 · Coolbaugh Robert J
- [N5598](https://openairdocs.org/aircraft/N5598.md): Bourdon KITTY HAWK · S/N 1 · Built 1928 · Coolbaugh Robert J
- [N6303](https://openairdocs.org/aircraft/N6303.md): North Fork Aero TS-1 · S/N A6303 · Coolbaugh Robert J
- [N7809](https://openairdocs.org/aircraft/N7809.md): Monocoupe 113 · S/N 248 · Coolbaugh Robert J
- [N84367](https://openairdocs.org/aircraft/N84367.md): Cessna 172K · S/N 17258442 · Built 1969 · Martin Arthur D
- [N84736](https://openairdocs.org/aircraft/N84736.md): Champion 7AC · S/N 7AC-3450 · Built 1946 · Martin Arthur D
- [N975M](https://openairdocs.org/aircraft/N975M.md): Viking Flying Boat KITTY HAWK B-8 · S/N 28 · Built 1931 · Coolbaugh Robert 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 = 'NEW MARKET'
ORDER BY g.n_number
```

This list as a web page: https://openairdocs.org/faa-place/VA/New%20Market/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, except the copies of manufacturers’ service documents, which belong to their rights holders.