# Registered aircraft: Grain Valley, MO

A list on [Grain Valley, MO](https://openairdocs.org/faa-place/MO/Grain%20Valley.md).

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

- [N1228](https://openairdocs.org/aircraft/N1228.md): Piper PA-46-310P · S/N 4608092 · Built 1987 · Hodges Farms LLC
- [N14AD](https://openairdocs.org/aircraft/N14AD.md): Lynch William J STARDUSTER TOO SA300 · S/N 1354 · Built 1985 · Simcic Tony R
- [N1530J](https://openairdocs.org/aircraft/N1530J.md): Piper PA-28-140 · S/N 28-23929 · Built 1967 · Country Club Mortgage LLC
- [N21S](https://openairdocs.org/aircraft/N21S.md): Schweitzer Jerome RV6 · S/N 22114 · Built 1995 · Country Club Mortgage LLC
- [N2528P](https://openairdocs.org/aircraft/N2528P.md): Consolidated Aeronautics LAKE LA-4 · S/N 865 · Skypros East Kansas City
- [N255ET](https://openairdocs.org/aircraft/N255ET.md): Carbon Cub 5X CCX-1865 · S/N CCX-1865-0015 · Built 2016 · Jonkman Matthew
- [N28536](https://openairdocs.org/aircraft/N28536.md): Grumman American Avn. AA-5B · S/N AA5B0665 · Country Club Mortgage LLC
- [N2974P](https://openairdocs.org/aircraft/N2974P.md): Piper PA-22-150 · S/N 22-3249 · Built 1955 · Miller Daniel F
- [N3056D](https://openairdocs.org/aircraft/N3056D.md): Piper PA-32RT-300T · S/N 32R7987060 · Applied Aviation LLC
- [N505EJ](https://openairdocs.org/aircraft/N505EJ.md): CGS HAWK ARROW II · S/N A001 · Built 2007 · Akins Terral S
- [N526E](https://openairdocs.org/aircraft/N526E.md): Mooney M20K · S/N 250714 · Built 1982 · On Target Ammunition LLC
- [N564QL](https://openairdocs.org/aircraft/N564QL.md): Cessna 150J · S/N 15070570 · Built 1969 · Simcic Kathryn C
- [N5770V](https://openairdocs.org/aircraft/N5770V.md): Beech A23-24 · S/N MA-25 · Built 1966 · Akins Terral S
- [N64081](https://openairdocs.org/aircraft/N64081.md): Cessna 172M · S/N 17265004 · Built 1975 · Burrows Donna M Trustee
- [N64431](https://openairdocs.org/aircraft/N64431.md): Cessna 172M · S/N 17265221 · Built 1975 · Coordinated Flight Training LLC
- [N6673E](https://openairdocs.org/aircraft/N6673E.md): Cessna 175 · S/N 56173 · Built 1959 · Miller Daniel F
- [N7745U](https://openairdocs.org/aircraft/N7745U.md): Cessna 172E · S/N 17251745 · Built 1964 · Hodges Charles E
- [N881HC](https://openairdocs.org/aircraft/N881HC.md): Akins Terral S MOSQUITO AIR · S/N 0001 · Built 2015 · Akins Terral S
- [N945KM](https://openairdocs.org/aircraft/N945KM.md): Cessna 152 · S/N 15280816 · Built 1977 · Skypros East Kansas City
- [N970MR](https://openairdocs.org/aircraft/N970MR.md): Cessna 210L · S/N 21059904 · Global 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 = 'GRAIN VALLEY'
ORDER BY g.n_number
```

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