Registered aircraft · 18

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

N1994WHeldeberg Designs BLUE HERON MARATHON · S/N HD 04132 MBuilt 2004 · Young Richard A N2162WCessna T206H · S/N T20608439Built 2004 · Helicopter Applicators LLC N24208Lavertu Darcy M EXCALIBUR · S/N 123102Built 2004 · Young Richard A N25GHBell Helicopter Textron 206L-1 · S/N 45755Built 1982 · Jbi South Leasing LLC N2611Bell Helicopter Textron 206L-1 · S/N 45417Built 1980 · Jbi South Leasing LLC N306PHBell Helicopter Textron 206L-1 · S/N 45411Finish Line Aviation LLC N407JBBell 407 · S/N 53250Built 1998 · Aerodyne LLC N4242FCessna 172 · S/N 46142Built 1958 · Chronis Marc D N444JBBell OH-58A · S/N 71-20362Built 1971 · Air First LLC N447JBBell Helicopter Textron 206L-1 · S/N 45415Built 1980 · Jbi South Leasing LLC N56757Bell 206-L4 · S/N 52072Built 1994 · Jbi South Leasing LLC N57441Bell Helicopter Textron 206L-1 · S/N 45438Built 1980 · Jbi South Leasing LLC N72045Beech F33A · S/N CE-1042Built 1984 · Pembroke Flyers LLC N800JBBell 206B · S/N 2832Built 1979 · Helicopter Applicators LLC N801JBBell 206B · S/N 2697Built 1979 · Newwest LLC N802JBGarlick Helicopters OH-58A+ · S/N 71-20851Built 1971 · Horizon Helicopters LLC N846SHLeading Edge Aerial Tech PV40X · S/N 11429Joe Brigham Inc DBA N868JBBell 206B · S/N 4534Built 2000 · Horizon Helicopter LLC

Back to Pembroke, NH