OpenAirDocs.org
Charles City, IA

Registered aircraft · 28

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

Query with SQL
duckdb -csv -c "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"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

N131LRPiper PA-28-140 · S/N 28-7425258Built 1974 · Charles City Aeronautics IncN2122JPiper PA-28-161 · S/N 28-7916199Built 1978 · Charles City Aeronautics IncN2760TDestiny Powered Parachutes CHROME BLUE DESTINY · S/N 1BO166Built 2000 · Kober Chad BN3053EPiper PA-28-181 · S/N 28-7990186Built 1978 · Charles City Aeronautics IncN3089FDJI AGRAS T40 · S/N 64TBL9C002005QFrascht Brady JN41619Piper PA-28-151 · S/N 28-7415296Built 1974 · Charles City Aeronautics IncN431WTDJI AGRAS T100 · S/N 1581F8ZLC25B4002GKT5Ca Enterprises LLCN4361XPiper PA-28-140 · S/N 28-7625020Built 1975 · Charles City Aeronautics IncN44526Piper PA-28-151 · S/N 28-7415658Built 1974 · Charles City Aeronautics IncN450KCPiper PA-31-350 · S/N 31-7852092Built 1978 · Charles City Aeronautics IncN490XMTalos Drones T60X · S/N 2104F7EZB251J0012PFNCa Enterprises LLCN53918Bellanca 7ECA · S/N 1145-76Built 1976 · N53918 LLCN53DPEavision EA-J150 · S/N JMZKJ150UAV602596016Frascht Drone Service LLCN57DPEavision EA-J150 · S/N JMZKJ150UAV602595265Frascht Drone Service LLCN59DPEavision EA-J150 · S/N JMZKJ150UAV602595231Frascht Drone Service LLCN609SMCessna 525 · S/N 5250247Carlinda LpN612CFEavision EA-J150 · S/N JMZKJ150UAV602595055Frascht Drone Service LLCN639RMMulcahy Roger F1 ROCKET · S/N YF001Built 2006 · Mulcahy Roger DN6554CPiper PA-28-181 · S/N 28-7890383Built 1978 · Charles City Aeronautics IncN7025HPiper J3C-65 · S/N 20270Built 1946 · Charles City Aeronautics IncN7659FPiper PA-28-151 · S/N 28-7715227Charles City Aeronautics Inc DBAN8105LCessna 172H · S/N 17256305Iowa Skyhawk LLCN81406Piper PA-28-236 · S/N 28-8211028Built 1982 · Dorgate LLCN8292PPiper PA-24-250 · S/N 24-3545Built 1963 · Charles City Aeronautics IncN8493FPiper PA-28-151 · S/N 28-7715275Built 1976 · Charles City Aeronautics IncN9315JPiper PA-28-180 · S/N 28-3425Built 1966 · Kruthoff BretN973DSSchwieso Duaine PIETENPOL AIRCAMPER · S/N 1-CBuilt 2004 · Miller Todd RN984FFDJI AGRAS T40 · S/N 64TBKBL002001PFrascht Brady J
Back to Charles City, IA