# Registered aircraft: Rogersville, MO

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

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

- [N111CG](https://openairdocs.org/aircraft/N111CG.md): Starduster Too SA300 · S/N 147 · Built 1969 · Pegasus Aviation LLC
- [N1657Y](https://openairdocs.org/aircraft/N1657Y.md): Cessna 172C · S/N 17249357 · Built 1962 · Pegasus Aviation LLC
- [N23151](https://openairdocs.org/aircraft/N23151.md): Piper J3C-65 · S/N 2932 · Built 1939 · Winsors Wings LLC
- [N2801L](https://openairdocs.org/aircraft/N2801L.md): Cirrus Design SR22 · S/N 4475 · Built 2017 · Av8sgf LLC
- [N285EU](https://openairdocs.org/aircraft/N285EU.md): DJI AGRAS T40 · S/N 5X5BLHF0020FJ1 · M3 Hilltop Ranch Co LLC
- [N313GB](https://openairdocs.org/aircraft/N313GB.md): Cessna T210M · S/N 21061986 · Built 1977 · Burnett Gregory C
- [N338WS](https://openairdocs.org/aircraft/N338WS.md): Cessna T206H · S/N T20608828 · Built 2008 · Winsors Wings LLC
- [N400PG](https://openairdocs.org/aircraft/N400PG.md): Cub Crafters CC11-100 · S/N CC11-00014 · Built 2007 · Gwennap Josh A
- [N40TB](https://openairdocs.org/aircraft/N40TB.md): Mooney M20M · S/N 27-0232 · Built 1997 · Towe Wyley
- [N4694R](https://openairdocs.org/aircraft/N4694R.md): Piper PA-28-140 · S/N 28-21457 · Built 1966 · Kent Adam
- [N4908](https://openairdocs.org/aircraft/N4908.md): Beech P35 · S/N D-7014 · Built 1962 · Ballew Jackie C
- [N4915V](https://openairdocs.org/aircraft/N4915V.md): Bellanca 17-30 · S/N 30139 · Pegasus Aviation LLC
- [N500AS](https://openairdocs.org/aircraft/N500AS.md): Ea Vision EA J100 · S/N EAVUAV502585819 · Pasture Pilot Agro Works LLC
- [N701HV](https://openairdocs.org/aircraft/N701HV.md): Lee Ronald E RL 701 · S/N RL27907381 · Built 2005 · Pegasus Aviation LLC
- [N7JE](https://openairdocs.org/aircraft/N7JE.md): Piper PA-30 · S/N 30-1618 · Sale reported, pending cancellation · Built 1967
- [N8675T](https://openairdocs.org/aircraft/N8675T.md): Cessna 182C · S/N 52575 · Built 1960 · Wakefield Bradley E
- [N8737](https://openairdocs.org/aircraft/N8737.md): Powrachute PEGASUS · S/N A206PEG · Built 2003 · Braillier Steve
- [N9215K](https://openairdocs.org/aircraft/N9215K.md): Stinson 108-1 · S/N 108-2215 · Built 1947 · Wiegand Guy R
- [N9470K](https://openairdocs.org/aircraft/N9470K.md): Stinson 108-2 · S/N 108-2470 · Built 1947 · Aan LLC
- [N951GA](https://openairdocs.org/aircraft/N951GA.md): Pascoe Eugene F EAA BIPLANE · S/N P-2-12825 · Built 2018 · Pegasus Aviation LLC

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

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