# Registered aircraft: Pelham, NH

A list on [Pelham, NH](https://openairdocs.org/faa-place/NH/Pelham.md).

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

- [N115NG](https://openairdocs.org/aircraft/N115NG.md): Diamond Aircraft Ind DA 40 NG · S/N 40.NC179 · Iveyation LLC
- [N12520](https://openairdocs.org/aircraft/N12520.md): Cessna 172M · S/N 17262036 · Built 1973 · Soucy Roland J
- [N30157](https://openairdocs.org/aircraft/N30157.md): Cessna 177 · S/N 17701086 · Registration pending · Built 1968
- [N310TG](https://openairdocs.org/aircraft/N310TG.md): Cessna 310K · S/N 310K0035 · Built 1966 · Hupper Clifford E
- [N350YR](https://openairdocs.org/aircraft/N350YR.md): Beech V35B · S/N D-10383 · Built 1982 · Silverman Kenneth
- [N4PD](https://openairdocs.org/aircraft/N4PD.md): Bellanca 7GCBC · S/N 689-74 · Built 1974 · Steck Paul D
- [N51646](https://openairdocs.org/aircraft/N51646.md): Air Creation BUGGY 582 SL · S/N T99018 · Built 1999 · Hirsch Douglas R
- [N6059M](https://openairdocs.org/aircraft/N6059M.md): Stinson 108-3 · S/N 108-4059 · Built 1947 · Steck Paul D
- [N6386H](https://openairdocs.org/aircraft/N6386H.md): Piper J3C-65 · S/N 19562 · Built 1946 · Steck Linda R
- [N733CU](https://openairdocs.org/aircraft/N733CU.md): Cessna 172N · S/N 17268198 · Built 1976 · Coleman Michael F
- [N84242](https://openairdocs.org/aircraft/N84242.md): Aeronca 7AC · S/N 7AC-2934 · Built 1946 · Steck Paul D
- [N8696D](https://openairdocs.org/aircraft/N8696D.md): Piper PA-18 · S/N 18-6306 · Built 1958 · Dupuis Raymond F Jr
- [N90164](https://openairdocs.org/aircraft/N90164.md): Cessna 140 · S/N 9229 · Built 1946 · Boutwell Nathan G
- [N9171C](https://openairdocs.org/aircraft/N9171C.md): Cessna R182 · S/N R18200435 · Built 1978 · Cartright Eugene
- [N94718](https://openairdocs.org/aircraft/N94718.md): Airborne Windsports PTY EDGE XT-582-L · S/N XT582 022 · Built 2006 · Hirsch Douglas R
- [N9793H](https://openairdocs.org/aircraft/N9793H.md): Cessna 182R · S/N 18268028 · Built 1981 · Yarmo Robert P

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```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
```

This list as a web page: https://openairdocs.org/faa-place/NH/Pelham/aircraft

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.
