# Registered aircraft: Rogersville, TN

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

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

- [N177C](https://openairdocs.org/aircraft/N177C.md): Stinson 108-2 · S/N 108-3177 · Built 1947 · Smith Happy E
- [N182ZZ](https://openairdocs.org/aircraft/N182ZZ.md): Cessna 182L · S/N 18258564 · Built 1967 · Burke Paul A
- [N19140](https://openairdocs.org/aircraft/N19140.md): Fairchild 24 G · S/N 2988 · Built 1937 · Smith Happy
- [N20619](https://openairdocs.org/aircraft/N20619.md): Fairchild 24R-9 · S/N 300 · Built 1939 · Smith Happy E
- [N25183](https://openairdocs.org/aircraft/N25183.md): Fairchild 24W-41A · S/N W40-107 · Built 1940 · Smith Happy E
- [N2969H](https://openairdocs.org/aircraft/N2969H.md): Engineering & Research 415-C · S/N 3594 · Built 1946 · Caswell Michael W
- [N319UA](https://openairdocs.org/aircraft/N319UA.md): Costruzioni Aeronautiche Tecna P2004 BRAVO · S/N 126 · Registration pending · Built 2008
- [N3689H](https://openairdocs.org/aircraft/N3689H.md): Ercoupe 415-C · S/N 4314 · Built 1946 · O Handley Hugh Jr
- [N39CW](https://openairdocs.org/aircraft/N39CW.md): Windham Charles R RV-9 · S/N 91447 · Built 2012 · Windham Charles R
- [N5050A](https://openairdocs.org/aircraft/N5050A.md): Cessna 172 · S/N 28050 · Built 1955 · Campbell Barry A
- [N70487](https://openairdocs.org/aircraft/N70487.md): Cessna A185F · S/N 18502190 · Built 1973 · Picazo Daniel M
- [N7227Y](https://openairdocs.org/aircraft/N7227Y.md): Piper PA-30 · S/N 30-250 · Clearview Aerial Solutions LLC
- [N7375P](https://openairdocs.org/aircraft/N7375P.md): Piper PA-24 · S/N 24-2556 · Built 1961 · Smith Happy E
- [N77667](https://openairdocs.org/aircraft/N77667.md): Fairchild 24W-46 · S/N W46367 · Built 1947 · Smith Happy E
- [N79888](https://openairdocs.org/aircraft/N79888.md): Cessna 172K · S/N 17258223 · Built 1969 · Smith Happy E
- [N928WA](https://openairdocs.org/aircraft/N928WA.md): Piper PA-28-181 · S/N 28-7790142 · Built 1976 · Chapman Martha P
- [N9752E](https://openairdocs.org/aircraft/N9752E.md): Aeronca 11AC · S/N 11AC-1398 · Built 1946 · Smith Happy E

## 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 = 'TN' AND g.registrant_city = 'ROGERSVILLE'
ORDER BY g.n_number
```

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