Mooresville, IN
Registered aircraft · 20
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 = 'MOORESVILLE' 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 = 'MOORESVILLE' 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.
N1171HCooper Davy Lee EROS 200 · S/N 1698PN13HUAviat A-1 · S/N 1323N1758WBeech F33A · S/N CE-411N2091ESchweizer 269C · S/N S1837N229ESBeech 35-C33A · S/N CE-174N2421LCessna 172H · S/N 17255621N29804Taylorcraft BC12-65 · S/N 2652N447KFleet 2 · S/N 170N6798DBrantly B-2 · S/N 19N69732Fairchild M-62 · S/N T42-4127N7161KPiper PA-20 · S/N 20-682N72DEEkstrom Dave TWINSTARR · S/N 001N763LGPost THORP T-18 · S/N 460N7644WPiper PA-28-180 · S/N 28-1617N79576Cessna 172K · S/N 17258189N7982UCessna 172F · S/N 17251982N9146FHughes 369HS · S/N 830508SN914HHiney David A RV-6 · S/N 21325N972SBCirrus Design SR22T · S/N 1293N9997LGrumman American Avn. AA-1B · S/N AA1B-0297
Back to Mooresville, IN