# Registered aircraft: Charlestown, IN

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

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

- [N174K](https://openairdocs.org/aircraft/N174K.md): Cessna 310N · S/N 310N-0143 · Built 1968 · Blueskies Aviation Services LLC
- [N210RP](https://openairdocs.org/aircraft/N210RP.md): Cessna P210N · S/N P21000014 · Registration pending · Built 1978
- [N2397A](https://openairdocs.org/aircraft/N2397A.md): Piper PA-38-112 · S/N 38-78A0668 · Kinkade Leslie D
- [N3166K](https://openairdocs.org/aircraft/N3166K.md): Phoenix SKY-TRIKE · S/N 5004 · Built 2004 · Turner Richard
- [N46EF](https://openairdocs.org/aircraft/N46EF.md): Cessna 182T · S/N 18280992 · Pringle Dan
- [N5006W](https://openairdocs.org/aircraft/N5006W.md): Piper PA-28 · S/N 28-7 · Built 1961 · Wright Stephan T
- [N5511M](https://openairdocs.org/aircraft/N5511M.md): Aero Commander 200D · S/N 382 · Built 1967 · Soodoo Mark A
- [N5821H](https://openairdocs.org/aircraft/N5821H.md): Piper PA-16 · S/N 16-437 · Fifer Lucas J Trustee
- [N70LG](https://openairdocs.org/aircraft/N70LG.md): Cubcrafters CC11-160 · S/N CC11-00245 · Built 2012 · Drysdale Donald J
- [N72HA](https://openairdocs.org/aircraft/N72HA.md): Raytheon HAWKER 800XP · S/N 258503 · Built 2000 · Mcn Aviation Partners LLC
- [N730JB](https://openairdocs.org/aircraft/N730JB.md): Joseph Barbera QUICKSILVER SPRINT 2 · S/N 63231 · Barbera Joseph A
- [N7855Z](https://openairdocs.org/aircraft/N7855Z.md): Cirrus Design SR22 · S/N 1629 · Built 2005 · Roskowski David
- [N815US](https://openairdocs.org/aircraft/N815US.md): George Stone KIT FOX MODEL 3 · S/N 815 · Stone George R
- [N8419H](https://openairdocs.org/aircraft/N8419H.md): Piper PA-28-181 · S/N 28-8190291 · Built 1981 · Hoke William Jr
- [N9909Q](https://openairdocs.org/aircraft/N9909Q.md): Cessna 172M · S/N 17265853 · Built 1975 · Ck Aviation LLC
- [N99928](https://openairdocs.org/aircraft/N99928.md): Ercoupe 415-C · S/N 2551 · Kinker Christopher C

## 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 = 'IN' AND g.registrant_city = 'CHARLESTOWN'
ORDER BY g.n_number
```

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