Freetown, IN

Registered aircraft · 27

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 = 'IN' AND g.registrant_city = 'FREETOWN'
  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.

N1314DCessna 170A · S/N 19890Built 1951 · Bartels Lance RN1770TPiper PA-28-140 · S/N 28-7125385Built 1971 · Cherryhill Aviation IncN210BBCessna TR182 · S/N R18201430Built 1979 · Cherry Hill Aviation C182 LLCN2288LBeech 58P · S/N TJ-70Cherryhill Aviation IncN2510ZBellanca 8GCBC · S/N 256-77Built 1977 · Cherry Hill Aviation IncN2891YPiper PA-32-300 · S/N 32-7940185Cherry Hill Aviation IncN3247Schempp-Hirth STANDARD CIRRUS · S/N 17Built 1970 · Bartels Lance RN330KRPiper PA-22-150 · S/N 22-4152Built 1956 · Cherry Hill Aviation IncN35411Cessna 172I · S/N 17256755Built 1968 · Cherry Hill Aviation IncN38553Piper PA-28-181 · S/N 28-7790563Built 1977 · Cherry Hill Aviation IncN3870SCessna 172E · S/N 17251070Built 1963 · Cherryhill Aviation IncN429BGBurkhart Grob Flugzeugbau G103 TWIN ASTIR · S/N 3737Built 1982 · Cherryhill Flying Club LLCN4428YPiper PA-25-235 · S/N 25-4053Cherry Hill Aviation IncN4615YPiper PA-18-150 · S/N 18-8936Cherry Hill Flying Club LLCN47452Piper PA-28-181 · S/N 28-7890077Built 1977 · Cherry Hill Aviation IncN4873YPiper PA-25-260 · S/N 25-4675Built 1968 · Cherry Hill Aviation IncN51168Cessna 150J · S/N 15069810Built 1968 · Cherry Hill Aviation C182 LLCN53065Cessna 172P · S/N 17274676Built 1981 · Cherry Hill Aviation LLCN536CMAmerican Champion 8KCAB · S/N 1202-2022Built 2022 · Cherry Hill Aviation IncN6577NBellanca 14-19 · S/N 2030Built 1950 · Bartels Lance RN6597NBellanca 14-19 · S/N 2050Built 1950 · Cherry Hill Aviation IncN731UAPiper PA-25-235 · S/N 25-7405687Cherry Hill Aviation IncN82619Piper PA-18-150 · S/N 18-7909019Built 1978 · Cherry Hill Aviation IncN8456LCessna 172I · S/N 17256656Built 1968 · Cherryhill Aviation IncN8BRReeves William F CHRISTEN EAGLE II · S/N WR 1Built 1995 · Cherry Hill Flying Club LLCN9200UCessna 150M · S/N 15078151Built 1976 · Cherry Hill Aviation IncN9548RBeech K35 · S/N D-6110Built 1959 · Cherry Hill Aviation Inc
Back to Freetown, IN