# Registered aircraft: Ottawa, KS

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

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

- [N117TR](https://openairdocs.org/aircraft/N117TR.md): Crabtree Andrew J RV-7 · S/N 72201 · Built 2013 · Crabtree Andrew J
- [N2187J](https://openairdocs.org/aircraft/N2187J.md): Ulmer Charles STOL CH 701 · S/N 7-6670 · Registration pending
- [N23HF](https://openairdocs.org/aircraft/N23HF.md): Hunter Ferrell RANS S6 · S/N 1 · Built 2021 · Davidson Robert K
- [N317FS](https://openairdocs.org/aircraft/N317FS.md): DJI AGRAS T40 · S/N 1581F574B239100100J6 · Sundstrom Farms Inc
- [N327DF](https://openairdocs.org/aircraft/N327DF.md): Flager Daryl ACRO SPORT II · S/N 032748 · Built 2000 · Flager Daryl L
- [N3318K](https://openairdocs.org/aircraft/N3318K.md): Globe GC-1B · S/N 1311 · Mace Wade L
- [N3464K](https://openairdocs.org/aircraft/N3464K.md): Piper PA-28-140 · S/N 28-23567 · Built 1967 · Aviation Explorers Post 8000 Inc
- [N37139](https://openairdocs.org/aircraft/N37139.md): Ercoupe 415-C · S/N 106 · Built 1956 · Bowers Robert D
- [N3753N](https://openairdocs.org/aircraft/N3753N.md): Douglas DC3 · S/N 44-77272 · Reeder James T
- [N3796V](https://openairdocs.org/aircraft/N3796V.md): Cessna 140A · S/N 15217 · Built 1949 · Mace Wade L
- [N455DD](https://openairdocs.org/aircraft/N455DD.md): Duggan Danny L RV-6 · S/N 21455 · Built 1995 · Bailey Steven S
- [N6405P](https://openairdocs.org/aircraft/N6405P.md): Piper PA-24-250 · S/N 24-1515 · Built 1959 · Sundstrom Raymond C
- [N688RR](https://openairdocs.org/aircraft/N688RR.md): Ring Richard VELOCITY · S/N SRE056 · Booher Eddie R
- [N80884](https://openairdocs.org/aircraft/N80884.md): Cessna 172M · S/N 17266788 · Built 1976 · Rein W Clark
- [N8199U](https://openairdocs.org/aircraft/N8199U.md): Cessna 172F · S/N 17252099 · Reeder James T
- [N93413](https://openairdocs.org/aircraft/N93413.md): Ercoupe 415-C · S/N 736 · Built 1946 · Dodson Robert L

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

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