# Registered aircraft: Charles City, IA

A list on [Charles City, IA](https://openairdocs.org/faa-place/IA/Charles%20City.md).

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

- [N131LR](https://openairdocs.org/aircraft/N131LR.md): Piper PA-28-140 · S/N 28-7425258 · Built 1974 · Charles City Aeronautics Inc
- [N2122J](https://openairdocs.org/aircraft/N2122J.md): Piper PA-28-161 · S/N 28-7916199 · Built 1978 · Charles City Aeronautics Inc
- [N2760T](https://openairdocs.org/aircraft/N2760T.md): Destiny Powered Parachutes CHROME BLUE DESTINY · S/N 1BO166 · Built 2000 · Kober Chad B
- [N3053E](https://openairdocs.org/aircraft/N3053E.md): Piper PA-28-181 · S/N 28-7990186 · Built 1978 · Charles City Aeronautics Inc
- [N3089F](https://openairdocs.org/aircraft/N3089F.md): DJI AGRAS T40 · S/N 64TBL9C002005Q · Frascht Brady J
- [N41619](https://openairdocs.org/aircraft/N41619.md): Piper PA-28-151 · S/N 28-7415296 · Built 1974 · Charles City Aeronautics Inc
- [N431WT](https://openairdocs.org/aircraft/N431WT.md): DJI AGRAS T100 · S/N 1581F8ZLC25B4002GKT5 · Ca Enterprises LLC
- [N4361X](https://openairdocs.org/aircraft/N4361X.md): Piper PA-28-140 · S/N 28-7625020 · Built 1975 · Charles City Aeronautics Inc
- [N44526](https://openairdocs.org/aircraft/N44526.md): Piper PA-28-151 · S/N 28-7415658 · Built 1974 · Charles City Aeronautics Inc
- [N450KC](https://openairdocs.org/aircraft/N450KC.md): Piper PA-31-350 · S/N 31-7852092 · Built 1978 · Charles City Aeronautics Inc
- [N490XM](https://openairdocs.org/aircraft/N490XM.md): Talos Drones T60X · S/N 2104F7EZB251J0012PFN · Ca Enterprises LLC
- [N53918](https://openairdocs.org/aircraft/N53918.md): Bellanca 7ECA · S/N 1145-76 · Built 1976 · N53918 LLC
- [N53DP](https://openairdocs.org/aircraft/N53DP.md): Eavision EA-J150 · S/N JMZKJ150UAV602596016 · Frascht Drone Service LLC
- [N57DP](https://openairdocs.org/aircraft/N57DP.md): Eavision EA-J150 · S/N JMZKJ150UAV602595265 · Frascht Drone Service LLC
- [N59DP](https://openairdocs.org/aircraft/N59DP.md): Eavision EA-J150 · S/N JMZKJ150UAV602595231 · Frascht Drone Service LLC
- [N609SM](https://openairdocs.org/aircraft/N609SM.md): Cessna 525 · S/N 5250247 · Carlinda Lp
- [N612CF](https://openairdocs.org/aircraft/N612CF.md): Eavision EA-J150 · S/N JMZKJ150UAV602595055 · Frascht Drone Service LLC
- [N639RM](https://openairdocs.org/aircraft/N639RM.md): Mulcahy Roger F1 ROCKET · S/N YF001 · Built 2006 · Mulcahy Roger D
- [N6554C](https://openairdocs.org/aircraft/N6554C.md): Piper PA-28-181 · S/N 28-7890383 · Built 1978 · Charles City Aeronautics Inc
- [N7025H](https://openairdocs.org/aircraft/N7025H.md): Piper J3C-65 · S/N 20270 · Built 1946 · Charles City Aeronautics Inc
- [N7659F](https://openairdocs.org/aircraft/N7659F.md): Piper PA-28-151 · S/N 28-7715227 · Charles City Aeronautics Inc DBA
- [N8105L](https://openairdocs.org/aircraft/N8105L.md): Cessna 172H · S/N 17256305 · Iowa Skyhawk LLC
- [N81406](https://openairdocs.org/aircraft/N81406.md): Piper PA-28-236 · S/N 28-8211028 · Built 1982 · Dorgate LLC
- [N8292P](https://openairdocs.org/aircraft/N8292P.md): Piper PA-24-250 · S/N 24-3545 · Built 1963 · Charles City Aeronautics Inc
- [N8493F](https://openairdocs.org/aircraft/N8493F.md): Piper PA-28-151 · S/N 28-7715275 · Built 1976 · Charles City Aeronautics Inc
- [N9315J](https://openairdocs.org/aircraft/N9315J.md): Piper PA-28-180 · S/N 28-3425 · Built 1966 · Kruthoff Bret
- [N973DS](https://openairdocs.org/aircraft/N973DS.md): Schwieso Duaine PIETENPOL AIRCAMPER · S/N 1-C · Built 2004 · Miller Todd R
- [N984FF](https://openairdocs.org/aircraft/N984FF.md): DJI AGRAS T40 · S/N 64TBKBL002001P · Frascht Brady J

## 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 = 'IA' AND g.registrant_city = 'CHARLES CITY'
ORDER BY g.n_number
```

This list as a web page: https://openairdocs.org/faa-place/IA/Charles%20City/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.