# Registered aircraft: Hesston, KS

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

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

- [N1050T](https://openairdocs.org/aircraft/N1050T.md): Beech A36 · S/N E-881 · Built 1976 · Thrash Scott
- [N121K](https://openairdocs.org/aircraft/N121K.md): Keim Midget Mustang M-1 · S/N 334 · Built 1972 · Swartzendruber Brett
- [N1702H](https://openairdocs.org/aircraft/N1702H.md): Piper PA-28-181 · S/N 28-7790336 · Built 1977 · Hesston College
- [N217HC](https://openairdocs.org/aircraft/N217HC.md): Piper PA-30 · S/N 30-166 · Built 1963 · Swartzendruber Brett E
- [N231CG](https://openairdocs.org/aircraft/N231CG.md): Mooney M20K · S/N 25-0131 · Built 1979 · Thrash Scott H
- [N295JJ](https://openairdocs.org/aircraft/N295JJ.md): Elliott Jimmy F VANS RV-9A · S/N 92215 · Built 2024 · Elliott Jimmy F
- [N38852](https://openairdocs.org/aircraft/N38852.md): Piper PA-28-181 · S/N 28-7790601 · Built 1977 · Hesston College
- [N43742](https://openairdocs.org/aircraft/N43742.md): Piper PA-28-181 · S/N 28-8490108 · Built 1984 · Hesston College
- [N551T](https://openairdocs.org/aircraft/N551T.md): Beech V35B · S/N D-10013 · Built 1977 · N551t LLC
- [N6161G](https://openairdocs.org/aircraft/N6161G.md): Cessna 150K · S/N 15071661 · Built 1969 · Gough James L
- [N616J](https://openairdocs.org/aircraft/N616J.md): Cassutt Racer II · S/N JC-502 · Built 1965 · Swartzendruber Brett
- [N65CS](https://openairdocs.org/aircraft/N65CS.md): Beech 65 · S/N LC-82 · Challans Robert F
- [N761CC](https://openairdocs.org/aircraft/N761CC.md): Piper PA-28-181 · S/N 28-7690288 · Built 1976 · Hesston College Aviation
- [N7LY](https://openairdocs.org/aircraft/N7LY.md): Glasflugel MOSQUITO · S/N 47 · Built 1977 · Brown Kevin Z
- [N8262K](https://openairdocs.org/aircraft/N8262K.md): Piper PA-28-181 · S/N 28-8290165 · Built 1982 · Hesston College
- [N866CT](https://openairdocs.org/aircraft/N866CT.md): William J Argue PEGAZAIR 100 · S/N 930866 · Built 2000 · Thrash Scott H
- [N89932](https://openairdocs.org/aircraft/N89932.md): Cessna 140 · S/N 8984 · Swartzendruber Brett

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

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