# Registered aircraft: Troy, KS

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

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

- [N11028](https://openairdocs.org/aircraft/N11028.md): Champion 7ECA · S/N 7ECA-14 · Built 1964 · Rush Casey K
- [N117RM](https://openairdocs.org/aircraft/N117RM.md): DJI AGRAS T40 · S/N 1581F574B2363001012E · Rm Precision Ag LLC
- [N199RW](https://openairdocs.org/aircraft/N199RW.md): Wright Richard Eugene EAA B1-PLANE P-1 · S/N REW-01 · Built 1991 · Rush Casey K
- [N224FN](https://openairdocs.org/aircraft/N224FN.md): Charles Martel SPORTSMAN 2 + 2 · S/N CM-1 · Rush Wayne A
- [N34796](https://openairdocs.org/aircraft/N34796.md): Cessna 177B · S/N 17702007 · Built 1973 · Masters David R
- [N50EF](https://openairdocs.org/aircraft/N50EF.md): DJI AGRAS T40 · S/N 1581F574B23730010219 · Elevated Farming LLC
- [N52EF](https://openairdocs.org/aircraft/N52EF.md): DJI AGRAS T40 · S/N 1581F574B239800100A8 · Elevated Farming LLC
- [N6101W](https://openairdocs.org/aircraft/N6101W.md): Piper PA-28-140 · S/N 28-20115 · Built 1964 · Studer Joseph D
- [N654QM](https://openairdocs.org/aircraft/N654QM.md): DJI AGRAS T50 · S/N 1581F6BUB252B001648P · Rm Precision Ag LLC
- [N654TM](https://openairdocs.org/aircraft/N654TM.md): DJI AGRAS T50 · S/N 1581F6BUB252J00119G1 · Rm Precision Ag LLC
- [N6924W](https://openairdocs.org/aircraft/N6924W.md): Piper PA-28-140 · S/N 28-21098 · Built 1965 · Alpha 3 LLC
- [N839JF](https://openairdocs.org/aircraft/N839JF.md): Xag P150 · S/N 18632FPEG8223508M74K5 · Rm Precision Ag LLC
- [N840JF](https://openairdocs.org/aircraft/N840JF.md): DJI AGRAS T40 · S/N 1581F574B237W0010174 · Rm Precision Ag LLC
- [N9074G](https://openairdocs.org/aircraft/N9074G.md): Cessna 182N · S/N 18260614 · Built 1971 · Rush Wayne A
- [N920XX](https://openairdocs.org/aircraft/N920XX.md): DJI AGRAS T40 · S/N 1581F574B22850010237 · Grable Ryan A
- [N9586W](https://openairdocs.org/aircraft/N9586W.md): Piper PA-28-140 · S/N 28-23032 · Built 1967 · Alpha 3 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 = 'KS' AND g.registrant_city = 'TROY'
ORDER BY g.n_number
```

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