# Registered aircraft: Rose Hill, KS

A list on [Rose Hill, KS](https://openairdocs.org/faa-place/KS/Rose%20Hill.md).

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

- [N102JT](https://openairdocs.org/aircraft/N102JT.md): Taylor Jeffrey Loren THORP S-18 · S/N 190 · Built 1997 · Brady George K
- [N107AZ](https://openairdocs.org/aircraft/N107AZ.md): Sharp-Rans S12 · S/N 0493394 · Built 2007 · Fitzgerald Brian J
- [N1189E](https://openairdocs.org/aircraft/N1189E.md): Aeronca 7BCM · S/N 7BCM-4746 · Built 1946 · Robert William F II
- [N124LG](https://openairdocs.org/aircraft/N124LG.md): Payne David N HORIZON 1 · S/N H046 · Clark Ricky R
- [N12GM](https://openairdocs.org/aircraft/N12GM.md): May George F JR KITFOX MODEL III · S/N 1034 · Built 2001 · Clark Ricky R
- [N195RE](https://openairdocs.org/aircraft/N195RE.md): Cessna 195B · S/N 7934 · Built 1952 · Ramey Robert L
- [N19900](https://openairdocs.org/aircraft/N19900.md): Cessna 172M · S/N 17260847 · Built 1972 · Mcwhorter Christopher W
- [N21075](https://openairdocs.org/aircraft/N21075.md): Aeronca KCA · S/N KCA-47 · Built 1950 · Towner Jeffery D
- [N2524L](https://openairdocs.org/aircraft/N2524L.md): Cessna 172H · S/N 17255724 · Built 1966 · Graham Jacob W
- [N277S](https://openairdocs.org/aircraft/N277S.md): Smith Jimmie A SONERAI IIL · S/N 00193 · Smith Jimmie A Trustee
- [N2834M](https://openairdocs.org/aircraft/N2834M.md): Michael R Snow RV-4 · S/N 2834 · Built 2023 · Tower Financial Strategies Corp
- [N2951J](https://openairdocs.org/aircraft/N2951J.md): Cessna 150G · S/N 15065751 · Built 1966 · Johnston Robert G
- [N2958S](https://openairdocs.org/aircraft/N2958S.md): Smith Jimmie A RV-6 · S/N 23600 · Built 1998 · Smith Jimmie A Trustee
- [N29TS](https://openairdocs.org/aircraft/N29TS.md): Snedeker Frank E THORP T-18C · S/N 1037-C49 · Built 1990 · Brady George K
- [N320ED](https://openairdocs.org/aircraft/N320ED.md): Dalbec Edward D LANCAIR 320 · S/N 1288 · Oday Shane C
- [N379GS](https://openairdocs.org/aircraft/N379GS.md): Strausheim George Glenn RV-4 · S/N 2098 · Smith Adam
- [N4259V](https://openairdocs.org/aircraft/N4259V.md): Cessna 170 · S/N 18615 · Kurt Robert F
- [N67884](https://openairdocs.org/aircraft/N67884.md): Boeing A75N1(PT17) · S/N 75-2505 · Snow Michael R DBA
- [N6792S](https://openairdocs.org/aircraft/N6792S.md): Cessna 150H · S/N 15067592 · Built 1967 · Johnston Robert G
- [N6944N](https://openairdocs.org/aircraft/N6944N.md): Mooney M-20G · S/N 680153 · Yates Gary Douglas
- [N7125G](https://openairdocs.org/aircraft/N7125G.md): Cessna 172K · S/N 17258825 · First renewal notice · Built 1969 · Bohannan Joshua S
- [N770CG](https://openairdocs.org/aircraft/N770CG.md): Gantzer Charles G PIETENPOL AIR CAMPER · S/N 001 · Gantzer Charles G
- [N8675D](https://openairdocs.org/aircraft/N8675D.md): Dodds Kimball Dean MARK II · S/N M2-212 · Mcclure Milo D
- [N8804R](https://openairdocs.org/aircraft/N8804R.md): Bellanca 14-19-3 · S/N 4156 · Built 1959 · Gouldsmith Marlene S
- [N8922J](https://openairdocs.org/aircraft/N8922J.md): Piper PA-28-180 · S/N 28-2939 · Built 1965 · Towner Jeffery D

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

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