# Registered aircraft: Coffeyville, KS

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

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

- [N171TC](https://openairdocs.org/aircraft/N171TC.md): Cory T L KB-2 · S/N TC-6 · Built 1995 · Coffeyville Aviation Heritage Inc
- [N2149K](https://openairdocs.org/aircraft/N2149K.md): Luscombe 8A · S/N 4876 · Built 1947 · Vowell Greg
- [N22678](https://openairdocs.org/aircraft/N22678.md): Funk B · S/N 5 · Built 1939 · Coffeyville Aviation Heritage Inc
- [N24137](https://openairdocs.org/aircraft/N24137.md): Mcclish FUNK B · S/N 63 · Built 1940 · Keith III Harry E
- [N3157Q](https://openairdocs.org/aircraft/N3157Q.md): Cessna 182K · S/N 18258157 · Built 1967 · Vowell Gregory
- [N36526](https://openairdocs.org/aircraft/N36526.md): Aeronca 65-CA · S/N CA-16221 · Rupert Nicholas L
- [N4392V](https://openairdocs.org/aircraft/N4392V.md): Cessna 195A · S/N 7343 · First renewal notice · Built 1949 · Keith Harry E III
- [N467TF](https://openairdocs.org/aircraft/N467TF.md): Fish Tim STARDUSTER · S/N 1 · Built 1995 · Harts Joel D
- [N51210](https://openairdocs.org/aircraft/N51210.md): Powrachute PEGASUS · S/N A-015PEG · Built 2002 · Osborn Robert G
- [N54603](https://openairdocs.org/aircraft/N54603.md): Boeing A75N1(PT17) · S/N 75-1090 · Keith Harry E III
- [N60614](https://openairdocs.org/aircraft/N60614.md): Cessna 150J · S/N 15070446 · Built 1969 · Hendryx Alec B
- [N6GM](https://openairdocs.org/aircraft/N6GM.md): Mccardle Guy D KR-2 · S/N 198325219-1 · Built 1984 · Loomis Steven Luke
- [N777PJ](https://openairdocs.org/aircraft/N777PJ.md): Jordan/Porter ACRO SPORT I · S/N 001 · Harts Joel D
- [N78915](https://openairdocs.org/aircraft/N78915.md): Mooney M20C · S/N 1944 · Built 1961 · Hendryx Alec B
- [N886MD](https://openairdocs.org/aircraft/N886MD.md): Navion NAVION A · S/N NAV-4-486 · Reardon Pat L
- [N88TF](https://openairdocs.org/aircraft/N88TF.md): Fothergill PITTS S-1S · S/N 69 · Built 1969 · Harts Joel D
- [N94CW](https://openairdocs.org/aircraft/N94CW.md): Waterbury Craig A WATERBURY SKYBOLT · S/N 013 · Harts Joel D
- [N9600S](https://openairdocs.org/aircraft/N9600S.md): Champion 7GCBC · S/N 2 · Built 1966 · Hargrove Tom R

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

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