# Registered aircraft: Gardner, KS

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

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

- [N17947](https://openairdocs.org/aircraft/N17947.md): Schweizer SGS 1-26E · S/N 547 · Built 1973 · Kc Eagles Soaring Club
- [N1822K](https://openairdocs.org/aircraft/N1822K.md): Luscombe 8E · S/N 4549 · Built 1946 · Sipple Ronald W Jr
- [N230JM](https://openairdocs.org/aircraft/N230JM.md): Maxwell Jack A PITTS S-1T · S/N 1 · Ostmeyer John
- [N26270](https://openairdocs.org/aircraft/N26270.md): Grumman American Avn. AA-5A · S/N AA5A0498 · Cochran Donald E
- [N26282](https://openairdocs.org/aircraft/N26282.md): Grumman American Avn. AA-5A · S/N AA5A0504 · Hubbard John D
- [N274SS](https://openairdocs.org/aircraft/N274SS.md): DJI AGRAS T100 · S/N APEDNEM00100PB · Sprayer Specialties Inc
- [N278M](https://openairdocs.org/aircraft/N278M.md): Beech 58 · S/N TH-1105 · Built 1980 · Reid Stephen M
- [N28312](https://openairdocs.org/aircraft/N28312.md): Interstate S-1A · S/N 4 · Built 1941 · Mattson Joshua C
- [N30295](https://openairdocs.org/aircraft/N30295.md): Piper J3C-65 · S/N 4770 · Built 1940 · Sipple Ronald W Jr
- [N3173V](https://openairdocs.org/aircraft/N3173V.md): Beech 35 · S/N D607 · Built 1947 · Lae Media Group LLC
- [N31JP](https://openairdocs.org/aircraft/N31JP.md): Piper PA-22-150 · S/N 22-3913 · Built 1956 · Ostmeyer John M
- [N434SS](https://openairdocs.org/aircraft/N434SS.md): DJI AGRAS T50 · S/N 1581F6BUB233R00101AW · Sprayer Specialties Inc
- [N5781C](https://openairdocs.org/aircraft/N5781C.md): Cessna 170A · S/N 19735 · Built 1950 · Sipple Ronald W Jr
- [N733GK](https://openairdocs.org/aircraft/N733GK.md): Cessna 172N · S/N 17268283 · Built 1976 · Hearn Richard J
- [N7704P](https://openairdocs.org/aircraft/N7704P.md): Piper PA-24-250 · S/N 24-2916 · Built 1961 · Dolin Irving M
- [N78051](https://openairdocs.org/aircraft/N78051.md): Globe GC-1B · S/N 2051 · Sipple Ronald W Jr
- [N79PR](https://openairdocs.org/aircraft/N79PR.md): Beech V35B · S/N D-9138 · Built 1970 · Hutchinson Andrew J
- [N805SB](https://openairdocs.org/aircraft/N805SB.md): Let BLANIK L-13 · S/N 026805 · Built 1976 · Kc Eagles Soaring Club
- [N8323J](https://openairdocs.org/aircraft/N8323J.md): Cessna 150G · S/N 15066223 · Built 1967 · Kc Eagles Soaring Club
- [N8511A](https://openairdocs.org/aircraft/N8511A.md): Beech A35 · S/N D-1933 · Built 1949 · Sipple Ronald W Jr
- [N88109](https://openairdocs.org/aircraft/N88109.md): Piper J3C-65 · S/N 15718 · Built 1946 · Klemp Randall D
- [N8883](https://openairdocs.org/aircraft/N8883.md): Bellanca 7ECA · S/N 932-73 · Built 1973 · Harris James H
- [N9515M](https://openairdocs.org/aircraft/N9515M.md): Mooney M20F · S/N 670092 · Built 1966 · Reid Stephen M
- [N9943A](https://openairdocs.org/aircraft/N9943A.md): Cessna 170A · S/N 19303 · Built 1950 · Sipple Ronald W 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 = 'KS' AND g.registrant_city = 'GARDNER'
ORDER BY g.n_number
```

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