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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N1314DCessna 170A · S/N 19890N1770TPiper PA-28-140 · S/N 28-7125385N210BBCessna TR182 · S/N R18201430N2288LBeech 58P · S/N TJ-70N2510ZBellanca 8GCBC · S/N 256-77N2891YPiper PA-32-300 · S/N 32-7940185N3247Schempp-Hirth STANDARD CIRRUS · S/N 17N330KRPiper PA-22-150 · S/N 22-4152N35411Cessna 172I · S/N 17256755N38553Piper PA-28-181 · S/N 28-7790563N3870SCessna 172E · S/N 17251070N429BGBurkhart Grob Flugzeugbau G103 TWIN ASTIR · S/N 3737N4428YPiper PA-25-235 · S/N 25-4053N4615YPiper PA-18-150 · S/N 18-8936N47452Piper PA-28-181 · S/N 28-7890077N4873YPiper PA-25-260 · S/N 25-4675N51168Cessna 150J · S/N 15069810N53065Cessna 172P · S/N 17274676N536CMAmerican Champion 8KCAB · S/N 1202-2022N6577NBellanca 14-19 · S/N 2030N6597NBellanca 14-19 · S/N 2050N731UAPiper PA-25-235 · S/N 25-7405687N82619Piper PA-18-150 · S/N 18-7909019N8456LCessna 172I · S/N 17256656N8BRReeves William F CHRISTEN EAGLE II · S/N WR 1N9200UCessna 150M · S/N 15078151N9548RBeech K35 · S/N D-6110
Back to Freetown, IN