# Registered aircraft: Midland, VA

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

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

- [N1413A](https://openairdocs.org/aircraft/N1413A.md): Bellanca 14-13-2 · S/N 1532 · Built 1947 · King John D
- [N1670G](https://openairdocs.org/aircraft/N1670G.md): Champion 7GCBC · S/N 137 · Built 1968 · King John D
- [N17774](https://openairdocs.org/aircraft/N17774.md): Aeronca K · S/N K-42 · Built 1937 · King John D
- [N185V](https://openairdocs.org/aircraft/N185V.md): Waco UPF-7 · S/N 5604 · Built 1941 · King John D
- [N2291](https://openairdocs.org/aircraft/N2291.md): Waco UPF-7 · S/N 5312 · Built 1939 · King John D
- [N2707A](https://openairdocs.org/aircraft/N2707A.md): Piper J3C-65 · S/N 44-80780 · Built 1944 · Denning Joel
- [N30551](https://openairdocs.org/aircraft/N30551.md): Piper J3C-65 · S/N 4925 · Built 1946 · King John D
- [N3WA](https://openairdocs.org/aircraft/N3WA.md): Wag-Aero CUBY SPORT TRAINER · S/N 1 · Built 1975 · Lebaron Timothy J
- [N52652](https://openairdocs.org/aircraft/N52652.md): Boeing A75N1(PT17) · S/N 75-4328 · Built 1942 · United Balloon Ventures LLC
- [N61478](https://openairdocs.org/aircraft/N61478.md): Phantom Aeronautics PHANTOM X 1 · S/N 012996024 · Built 1997 · King John D
- [N6222L](https://openairdocs.org/aircraft/N6222L.md): Padelt B/King J P-90 · S/N 64425 · Built 1999 · King John D
- [N6843G](https://openairdocs.org/aircraft/N6843G.md): Cessna 150L · S/N 15072343 · Tracey Corp
- [N70080](https://openairdocs.org/aircraft/N70080.md): Balloon Works FIREFLY 7-15 · S/N F7-1059 · Built 1998 · King John D
- [N74228](https://openairdocs.org/aircraft/N74228.md): Bellanca 14-13 · S/N 1341 · Built 1946 · King John D
- [N75665](https://openairdocs.org/aircraft/N75665.md): Boeing E75N1 · S/N 75-8556 · Built 1943 · King John E
- [N81825](https://openairdocs.org/aircraft/N81825.md): Aeronca 7AC · S/N 7AC-448 · Built 1945 · King Daniel A
- [N856RG](https://openairdocs.org/aircraft/N856RG.md): Gray Richard D VANS RV6 · S/N 60028 · Haldenwanger Ryan W
- [N8694](https://openairdocs.org/aircraft/N8694.md): Semco Balloon T · S/N SEM60 · Built 1972 · King John D
- [N945H](https://openairdocs.org/aircraft/N945H.md): Waco BSO · S/N A-144 · Built 1929 · King John D
- [N9581S](https://openairdocs.org/aircraft/N9581S.md): Champion 7ECA · S/N 192 · Built 1966 · King John D

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

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