# Registered aircraft: Pembroke, NH

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

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

- [N1994W](https://openairdocs.org/aircraft/N1994W.md): Heldeberg Designs BLUE HERON MARATHON · S/N HD 04132 M · Built 2004 · Young Richard A
- [N2162W](https://openairdocs.org/aircraft/N2162W.md): Cessna T206H · S/N T20608439 · Built 2004 · Helicopter Applicators LLC
- [N24208](https://openairdocs.org/aircraft/N24208.md): Lavertu Darcy M EXCALIBUR · S/N 123102 · Built 2004 · Young Richard A
- [N25GH](https://openairdocs.org/aircraft/N25GH.md): Bell Helicopter Textron 206L-1 · S/N 45755 · Built 1982 · Jbi South Leasing LLC
- [N2611](https://openairdocs.org/aircraft/N2611.md): Bell Helicopter Textron 206L-1 · S/N 45417 · Built 1980 · Jbi South Leasing LLC
- [N306PH](https://openairdocs.org/aircraft/N306PH.md): Bell Helicopter Textron 206L-1 · S/N 45411 · Finish Line Aviation LLC
- [N407JB](https://openairdocs.org/aircraft/N407JB.md): Bell 407 · S/N 53250 · Built 1998 · Aerodyne LLC
- [N4242F](https://openairdocs.org/aircraft/N4242F.md): Cessna 172 · S/N 46142 · Built 1958 · Chronis Marc D
- [N444JB](https://openairdocs.org/aircraft/N444JB.md): Bell OH-58A · S/N 71-20362 · Built 1971 · Air First LLC
- [N447JB](https://openairdocs.org/aircraft/N447JB.md): Bell Helicopter Textron 206L-1 · S/N 45415 · Built 1980 · Jbi South Leasing LLC
- [N56757](https://openairdocs.org/aircraft/N56757.md): Bell 206-L4 · S/N 52072 · Built 1994 · Jbi South Leasing LLC
- [N57441](https://openairdocs.org/aircraft/N57441.md): Bell Helicopter Textron 206L-1 · S/N 45438 · Built 1980 · Jbi South Leasing LLC
- [N72045](https://openairdocs.org/aircraft/N72045.md): Beech F33A · S/N CE-1042 · Built 1984 · Pembroke Flyers LLC
- [N800JB](https://openairdocs.org/aircraft/N800JB.md): Bell 206B · S/N 2832 · Built 1979 · Helicopter Applicators LLC
- [N801JB](https://openairdocs.org/aircraft/N801JB.md): Bell 206B · S/N 2697 · Built 1979 · Newwest LLC
- [N802JB](https://openairdocs.org/aircraft/N802JB.md): Garlick Helicopters OH-58A+ · S/N 71-20851 · Built 1971 · Horizon Helicopters LLC
- [N846SH](https://openairdocs.org/aircraft/N846SH.md): Leading Edge Aerial Tech PV40X · S/N 11429 · Joe Brigham Inc DBA
- [N868JB](https://openairdocs.org/aircraft/N868JB.md): Bell 206B · S/N 4534 · Built 2000 · Horizon Helicopter LLC

## 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 = 'PEMBROKE'
ORDER BY g.n_number
```

This list as a web page: https://openairdocs.org/faa-place/NH/Pembroke/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.
