Registered aircraft · 16

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

Query with SQL

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 = 'PELHAM' ORDER BY g.n_number

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 = 'PELHAM'
  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 = 'PELHAM'
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.

N115NGDiamond Aircraft Ind DA 40 NG · S/N 40.NC179Iveyation LLC N12520Cessna 172M · S/N 17262036Built 1973 · Soucy Roland J N30157Cessna 177 · S/N 17701086Registration pendingBuilt 1968 N310TGCessna 310K · S/N 310K0035Built 1966 · Hupper Clifford E N350YRBeech V35B · S/N D-10383Built 1982 · Silverman Kenneth N4PDBellanca 7GCBC · S/N 689-74Built 1974 · Steck Paul D N51646Air Creation BUGGY 582 SL · S/N T99018Built 1999 · Hirsch Douglas R N6059MStinson 108-3 · S/N 108-4059Built 1947 · Steck Paul D N6386HPiper J3C-65 · S/N 19562Built 1946 · Steck Linda R N733CUCessna 172N · S/N 17268198Built 1976 · Coleman Michael F N84242Aeronca 7AC · S/N 7AC-2934Built 1946 · Steck Paul D N8696DPiper PA-18 · S/N 18-6306Built 1958 · Dupuis Raymond F Jr N90164Cessna 140 · S/N 9229Built 1946 · Boutwell Nathan G N9171CCessna R182 · S/N R18200435Built 1978 · Cartright Eugene N94718Airborne Windsports PTY EDGE XT-582-L · S/N XT582 022Built 2006 · Hirsch Douglas R N9793HCessna 182R · S/N 18268028Built 1981 · Yarmo Robert P

Back to Pelham, NH