OpenAirDocs.org
Portsmouth, NH

Registered aircraft · 126

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

N112AAAero Commander 500-B · S/N 1436-153Built 1964 · Nestor RichardN113KKCirrus Design SR22 · S/N 4724Built 2018 · Kns Air LLCN1141VPiper J3C-65 · S/N 10490Built 1943 · Hampton Flying Services LLCN118AFPilatus PC-12/47G · S/N 3118Aebersold Comer IrelandN11TCompagnie Daher TBM 700 · S/N 1609Built 2025 · Carlisle Capital CorpN124VAVans RV-12IS · S/N 12193Built 2025 · Chi Aerospace IncN12559Cessna 172M · S/N 17262072Built 1973 · Hampton Flying Services LLCN125GCAlpha Aviation Manufacturing L R2160 · S/N 160A-07011Built 2007 · Chi Aerospace IncN126AFPilatus PC-24 · S/N 126Built 2019 · Rigi IncN131AFPilatus PC-12/47E · S/N 2131Built 2021 · Manufacturers And Traders Trust CoN1355FCessna 172N · S/N 17272998Built 1979 · Chi Aerospace IncN1438NPiper J3C-65 · S/N 22966Built 1947 · Mee Dennis MN1459VCessna 172M · S/N 17263596Registration pendingBuilt 1974N147AFPilatus PC-12/47E · S/N 2147Built 2021 · Shields CorpN147CJDassault FALCON 2000EX · S/N 147Built 2008 · Carlisle Capital CorpN154AFPilatus PC-24 · S/N 154Built 2019 · Rigi IncN158AFPilatus PC-24 · S/N 158Built 2019 · Rigi IncN159HTextron 525C · S/N 525C0195Built 2015 · Lkw IncN166AFPilatus PC-12/47E · S/N 2166Built 2022 · Geiger Holdings IncN172AFPilatus PC-12/47E · S/N 2172Built 2022 · Dynasty Flight LLCN172MLCessna 172M · S/N 17261580Built 1973 · Hampton Flying Services LLCN185GLCessna A185E · S/N 185-1152Built 1967 · Lukas GregoryN189AFPilatus PC-12/47E · S/N 2189Built 2022 · Rmz LLCN206AFPilatus PC-12/47E · S/N 2206Built 2022 · Gpfp LLCN21KHPilatus PC-24 · S/N 569Built 2025 · Live Free And Fly Nh LLCN221TPiper PA-18 105 · S/N 18-2335Built 1953 · Mee Dennis MN223KHTextron 208B · S/N 208B5621Built 2021 · Airprop IncN225AFPilatus PC-24 · S/N 225Built 2021 · Sandell Scott DN226AFPilatus PC-12/47E · S/N 2226Built 2022 · Taylor - Smartt LLCN235AFPilatus PC-12/47E · S/N 2235Built 2022 · J3b LLCN243VAVans RV-12 · S/N 12018Chi Aerospace IncN251AFPilatus PC-24 · S/N 251Built 2021 · Csmc Holdings IncN266VAVans RV-12 · S/N 12041Built 2014 · Chi Aerospace IncN269AFPilatus PC-24 · S/N 269Built 2022 · Rigi IncN270AFPilatus PC-12/47E · S/N 2270Built 2023 · Rigi IncN271VAVans RV-12 · S/N 12053Built 2015 · Chi Aerospace IncN282AFPilatus PC-24 · S/N 282Built 2022 · Stuart Hyundai LLCN283AFPilatus PC-12/47E · S/N 2283Built 2023 · J3b LLCN288AFPilatus PC-12/47E · S/N 2288Built 2023 · Mod-Pac CorpN292AFPilatus PC-24 · S/N 292Built 2023 · Jdwh LLCN294AFPilatus PC-24 · S/N 294Built 2022 · Schwartz Eric SN299AFPilatus PC-24 · S/N 299Built 2023 · Rigi IncN3023KPiper PA-28RT-201 · S/N 28R-7918022Built 1978 · Vx Parts LLCN311VAVans RV-12 · S/N 12074Built 2017 · 08i Aerospace IncN313NRCirrus Design SR22 · S/N 10209Built 2024 · Dawn Patrol LLCN320AFPilatus PC-12/47E · S/N 2320Rigi IncN325AFPilatus PC-12/47E · S/N 2325Built 2023 · Silverback Advisory LLCN335WSDJI MAVIC 2 PRO · S/N 163CJ4DR0A7QGXVital Design LLCN348AFPilatus PC-12/47E · S/N 2348Built 2023 · Kirkland Messina IncN3519VCessna 150M · S/N 15076533Built 1974 · Vanderpool Kenneth J
Back to Portsmouth, NH