# Registered aircraft: Memphis, MO

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

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

- [N2199U](https://openairdocs.org/aircraft/N2199U.md): Cessna A188A · S/N 18800799 · Wood James DBA
- [N244LA](https://openairdocs.org/aircraft/N244LA.md): Air Tractor AT-602 · S/N 602-1244 · Built 2014 · Woodline Aviation LLC
- [N26109](https://openairdocs.org/aircraft/N26109.md): Piper J3C-65 · S/N 4046 · Built 1939 · Martin Devon R
- [N26868](https://openairdocs.org/aircraft/N26868.md): Piper J3C-65 · S/N 4252 · Built 1941 · Musser Alvin M Jr
- [N4412Q](https://openairdocs.org/aircraft/N4412Q.md): Cessna A188A · S/N 18800812 · Built 1971 · Woods Flying Service LLC
- [N446SD](https://openairdocs.org/aircraft/N446SD.md): Gteex Revolution INDEPENDENCE 19 · S/N 212985300C6F4 · Superior Drone LLC
- [N4627H](https://openairdocs.org/aircraft/N4627H.md): Piper PA-17 · S/N 17-42 · Built 1948 · Martin Devon R
- [N5738B](https://openairdocs.org/aircraft/N5738B.md): Pheasant H-10 · S/N 118 · Built 2004 · Scotland County Historical Society
- [N602DA](https://openairdocs.org/aircraft/N602DA.md): Air Tractor AT-602 · S/N 602-1230 · Built 2013 · Woodline Aviation LLC
- [N6385H](https://openairdocs.org/aircraft/N6385H.md): Bellanca 17-30 · S/N 30104 · Eds Used Machinery LLC
- [N6408E](https://openairdocs.org/aircraft/N6408E.md): Cessna 172 · S/N 46508 · Built 1959 · Morgan Lloyd J
- [N6970X](https://openairdocs.org/aircraft/N6970X.md): Cessna 172B · S/N 17247870 · Built 1960 · 4 Generation Aviation LLC
- [N7014U](https://openairdocs.org/aircraft/N7014U.md): Powrachute PEGASUS · S/N A264 PEG · Built 2003 · Howard Dennis V
- [N75298](https://openairdocs.org/aircraft/N75298.md): Piper PA-32R-300 · S/N 32R-7680287 · Registration pending
- [N83282](https://openairdocs.org/aircraft/N83282.md): Aeronca 7AC · S/N 7AC1949 · Registration revoked · Built 1946 · Orton Edson
- [N8530N](https://openairdocs.org/aircraft/N8530N.md): Piper PA-28-235 · S/N 28-11329 · Built 1969 · Good Curvin M
- [N95376](https://openairdocs.org/aircraft/N95376.md): Piper PA-28-140 · S/N 28-25905 · Built 1969 · Team K Outfitters LLC
- [N9841M](https://openairdocs.org/aircraft/N9841M.md): Maule M-4C · S/N 3C · Built 1966 · Musser Alvin M 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 = 'MO' AND g.registrant_city = 'MEMPHIS'
ORDER BY g.n_number
```

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