# Registered aircraft: Staunton, VA

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

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

- [N119DS](https://openairdocs.org/aircraft/N119DS.md): Cessna A185F · S/N 18503735 · Built 1979 · Deltasierra LLC
- [N136KF](https://openairdocs.org/aircraft/N136KF.md): Textron B300 · S/N FL-1036 · Built 2016 · Fisher Auto Parts Inc
- [N1658A](https://openairdocs.org/aircraft/N1658A.md): Cessna 182Q · S/N 18266315 · Built 1978 · Applied Trails Research LLC
- [N210KA](https://openairdocs.org/aircraft/N210KA.md): Cessna T210N · S/N 21063902 · Built 1980 · Kgs Aviation LLC
- [N242TA](https://openairdocs.org/aircraft/N242TA.md): Costruzioni Aeronautiche Tecna P2008 · S/N 068 · Built 2012 · Levy Robert
- [N320BA](https://openairdocs.org/aircraft/N320BA.md): Aerotechnik L13 SE VIVAT · S/N 970529 · Built 1997 · Root Franklin L
- [N36AS](https://openairdocs.org/aircraft/N36AS.md): Beech A36 · S/N E-1009 · Built 1977 · Moore Brothers Company Inc
- [N40592](https://openairdocs.org/aircraft/N40592.md): Piper PA-23-250 · S/N 27-7405337 · Built 1974 · Rml Aircraft Inc
- [N4740](https://openairdocs.org/aircraft/N4740.md): Curtiss JN-4 · S/N 1321 · Built 1918 · Root Franklin L
- [N48HM](https://openairdocs.org/aircraft/N48HM.md): Honda HA-420 · S/N 42000113 · Built 2018 · Augusta Aviation LLC
- [N525DP](https://openairdocs.org/aircraft/N525DP.md): Cessna 525 · S/N 525-0318 · Built 1999 · Elk Factoring LLC DBA
- [N5856T](https://openairdocs.org/aircraft/N5856T.md): DJI AGRAS T50 · S/N 1581F6BUB2332001007Z · Trinity Ag Drone LLC
- [N7577T](https://openairdocs.org/aircraft/N7577T.md): Cessna 172A · S/N 47177 · Built 1959 · Root Franklin L
- [N787DK](https://openairdocs.org/aircraft/N787DK.md): Raytheon B300 · S/N FL159 · Blue Skies 4 LLC
- [N793HA](https://openairdocs.org/aircraft/N793HA.md): DJI INSPIRE 1 · S/N W130CK4051880 · Augusta Cooperative Farm Bureau
- [N855RP](https://openairdocs.org/aircraft/N855RP.md): Rainbow Sky Reach BUSHCAT · S/N CH251C · Built 2024 · Pence Robert G
- [N95GW](https://openairdocs.org/aircraft/N95GW.md): Walters Gary W RV6 · S/N 21373 · Built 1995 · Skypirate Aviation LLC
- [N9806X](https://openairdocs.org/aircraft/N9806X.md): Cessna 185 · S/N 185-0006 · Built 1961 · Welliver Charles Kimmel Jr

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

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