# Registered aircraft: Smithville, MO

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

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

- [N14957](https://openairdocs.org/aircraft/N14957.md): Ryan Aeronautical ST-A · S/N 113 · Built 1935 · Barber Fred L
- [N222BC](https://openairdocs.org/aircraft/N222BC.md): Cowden William Morris VANS RV-8 · S/N 80457 · Built 2003 · Wilcox Robbie C
- [N281X](https://openairdocs.org/aircraft/N281X.md): Murphy Thomas M RV8 · S/N 002 · Built 2015 · Selanders Jay N
- [N3311T](https://openairdocs.org/aircraft/N3311T.md): Cessna 177 · S/N 17700611 · Built 1967 · Schulze Tom L
- [N345MP](https://openairdocs.org/aircraft/N345MP.md): Bausch Wayne A RV-4 · S/N 306WB · Peterson Michael A
- [N3979K](https://openairdocs.org/aircraft/N3979K.md): Piper PA-28-140 · S/N 28-23866 · Built 1967 · Grams Terry
- [N44408](https://openairdocs.org/aircraft/N44408.md): Taylorcraft BC12-D1 · S/N 10208 · Built 1946 · Fisher Steve S
- [N4529E](https://openairdocs.org/aircraft/N4529E.md): Aeronca 7DC · S/N 7DC-136 · Built 1948 · Long Tuggin D
- [N454WB](https://openairdocs.org/aircraft/N454WB.md): Steven S Fisher SUPERSTOL · S/N JA296-04-13 · Parks Doug G
- [N527T](https://openairdocs.org/aircraft/N527T.md): Beech 95-B55 (T42A) · S/N TC-576 · Built 1964 · Flying H Enterprises LLC
- [N55HQ](https://openairdocs.org/aircraft/N55HQ.md): Mooney M20E · S/N 743 · Built 1965 · Herndon Colton R
- [N570T](https://openairdocs.org/aircraft/N570T.md): Beech N35 · S/N D-6747 · Built 1961 · Wilcox Robbie Craig
- [N6903A](https://openairdocs.org/aircraft/N6903A.md): Cessna 172 · S/N 29003 · Built 1956 · Fisher Joe S
- [N74615](https://openairdocs.org/aircraft/N74615.md): Grumman American Avn. AA-5B · S/N AA5B-0286 · Built 1976 · Fehner Beverly A
- [N75ZX](https://openairdocs.org/aircraft/N75ZX.md): Young Jimmy ZENITH 750 · S/N 75-7861 · Built 2012 · Wilcox Robbie C
- [N808SQ](https://openairdocs.org/aircraft/N808SQ.md): Raytheon 390 · S/N RB78 · Built 2003 · Final Approach Investments LLC
- [N8248U](https://openairdocs.org/aircraft/N8248U.md): Cessna 172F · S/N 17252148 · Built 1964 · Robison Wm Lee
- [N86555](https://openairdocs.org/aircraft/N86555.md): Ryan Aeronautical ST-A · S/N 111 · Barber Fred L

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

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