Moultonborough, NH
Registered aircraft · 33
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 = 'NH' AND g.registrant_city = 'MOULTONBOROUGH' 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 = 'NH' AND g.registrant_city = 'MOULTONBOROUGH' 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.
N118WHCirrus Design SR22 · S/N 4914N15559Piper PA-28-140 · S/N 28-7325098N15691Bellanca 14-9 · S/N 1006N19105Fairchild 24 G · S/N 2970N204TVRobinson Helicopter R44 II · S/N 10723N2143VCessna 140 · S/N 14370N242PLLeon Pesche SEAWIND 3000 · S/N 085Non-citizen corporation, flight hours not reportedN291RPCessna 172P · S/N 17274327N347BAIcon A5 · S/N 00148N454BHHirschfield Robert J HIRSCHFIELD SPNT1000 · S/N 000703N455BHRobert J Hirschfield SEAREY LSX · S/N 1LK602CN4876MPiper PA-11 · S/N 11-394N532SRProgressive Aerodyne SEAREY LSA · S/N 1025N5865SBeech 35-C33 · S/N CD-828N619BHRobert J Hirschfield SAFARI 400 HELICOPTR · S/N 61830N620TDCirrus Design SR22 · S/N 10759N6285TCessna 150E · S/N 15060985N642BAIcon A5 · S/N 00218N6795HPiper J3C-65 · S/N 20012N704HRCessna 150M · S/N 15078628N71SJAir Creation GTE582 S · S/N T00027N7234WPiper PA-28-180 · S/N 28-1053N73TSPiper PA-28-181 · S/N 28-8590064N757JVPiper PA-18-135 · S/N 18-4038N808BJVans RV-12IS · S/N 12139N816WRPiper PA-18-150 · S/N 18-8309017N8502EChampion 7GC · S/N 7GC-71N9384LAmerican AA-1A · S/N AA1A-0084N94043Ercoupe 415-C · S/N 1366N95175Taylorcraft BC12-D · S/N 9575N96636Taylorcraft BC12-D · S/N 8936N9855ACessna 195A · S/N 7548N99799Beech H-18 · S/N BA-758
Back to Moultonborough, NH