# Registered aircraft: Bates City, MO

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

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

- [N116PG](https://openairdocs.org/aircraft/N116PG.md): Robinson Helicopter R22 BETA · S/N 3547 · Built 2004 · Unusual Attitudes LLC
- [N1209E](https://openairdocs.org/aircraft/N1209E.md): Aeronca 7AC · S/N 7AC-4766 · Built 1946 · Karaty Joseph
- [N1327](https://openairdocs.org/aircraft/N1327.md): Luscombe 8A · S/N 801 · Anderson Mark A
- [N1356K](https://openairdocs.org/aircraft/N1356K.md): Luscombe 8A · S/N 4083 · Anderson Andrew A
- [N1451K](https://openairdocs.org/aircraft/N1451K.md): Luscombe 8A · S/N 4178 · Anderson Mark A
- [N1521B](https://openairdocs.org/aircraft/N1521B.md): Luscombe 8E · S/N 6148 · Anderson Andrew A
- [N1639B](https://openairdocs.org/aircraft/N1639B.md): Luscombe 11A · S/N 11-145 · Anderson Mark A
- [N17741](https://openairdocs.org/aircraft/N17741.md): Waco ZKS-7 · S/N 4667 · Built 1937 · Anderson Andrew A
- [N1960A](https://openairdocs.org/aircraft/N1960A.md): Anderson Mark PIETENPOL SCOUT · S/N 3A · Built 2005 · Anderson Mark A
- [N1968K](https://openairdocs.org/aircraft/N1968K.md): Luscombe 8E · S/N 4695 · Anderson Mark A
- [N2015B](https://openairdocs.org/aircraft/N2015B.md): Luscombe 8A · S/N 6442 · Built 1954 · Anderson Mark A
- [N2212B](https://openairdocs.org/aircraft/N2212B.md): Luscombe 8F · S/N 6639 · Anderson Mark A
- [N236JP](https://openairdocs.org/aircraft/N236JP.md): Beech A36 · S/N E-211 · Built 1970 · Lauderdale Thomas J
- [N31485](https://openairdocs.org/aircraft/N31485.md): Robinson Helicopter R22 BETA · S/N 4088 · Built 2006 · Unusual Attitudes LLC
- [N39034](https://openairdocs.org/aircraft/N39034.md): Luscombe 8A · S/N 1795 · Anderson Mark A
- [N503RJ](https://openairdocs.org/aircraft/N503RJ.md): Powrachute AIRWOLF 912 · S/N A108ULS · Built 2009 · Thomas Jack E
- [N5143P](https://openairdocs.org/aircraft/N5143P.md): Piper PA-24-250 · S/N 24-159 · Built 1958 · Unusual Attitudes LLC
- [N599](https://openairdocs.org/aircraft/N599.md): Mckinney John P PIETENPOL AIRCAMPER · S/N 1989-1 · Built 1989 · Anderson Mark A
- [N688PD](https://openairdocs.org/aircraft/N688PD.md): Cirrus Design SR22 · S/N 2398 · Built 2007 · Unusual Attitudes LLC
- [N71586](https://openairdocs.org/aircraft/N71586.md): Luscombe 8A · S/N 3013 · Built 1946 · Anderson Mark A
- [N71983](https://openairdocs.org/aircraft/N71983.md): Silvaire LUSCOMBE 8A · S/N 3410 · Sale reported
- [N7463J](https://openairdocs.org/aircraft/N7463J.md): Piper PA-28R-180 · S/N 28R-30815 · Unusual Attitudes LLC
- [N81704](https://openairdocs.org/aircraft/N81704.md): Aeronca 7AC · S/N 7AC-323 · Built 1945 · Anderson Mark A
- [N8313Y](https://openairdocs.org/aircraft/N8313Y.md): Piper PA-30 · S/N 30-1452 · Built 1967 · Unusual Attitudes LLC
- [N85NR](https://openairdocs.org/aircraft/N85NR.md): Brunner-Winkle BIRD A · S/N 1040 · Anderson Mark A
- [N88CY](https://openairdocs.org/aircraft/N88CY.md): Huey-Smith MINIPLANE · S/N H1 · Anderson Mark
- [N94981](https://openairdocs.org/aircraft/N94981.md): Cessna T240 · S/N T24002042 · Built 2014 · Schatz Aviation LLC
- [N9932C](https://openairdocs.org/aircraft/N9932C.md): Luscombe 8F · S/N S-36 · Anderson Andrew A

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

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