Skip to content

National Ballooning 858

Registered aircraft · 48

Aircraft of this model in the FAA registry, by N-number.

Query with SQL

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN ('6113320')
  ORDER BY 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 n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('6113320')
ORDER BY 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.

N2003HAlbin David H · Rio Rancho, NMBuilt 2000 · S/N 135 N2004CNutting Rob H · Ackworth, IABuilt 2000 · S/N 136 N2006YHastie Todd B · Fleming Island, FLBuilt 2000 · S/N 134 N20081Hartson Jason R · Pella, IABuilt 2001 · S/N 139 N2008NNollen Ronald Cjr · Hartland, WIBuilt 2001 · S/N 138 N2330SDegattis Colin · Sandia Park, NMBuilt 2006 · S/N 155 N30191Kinser Aviation LLC · Guthrie, OKBuilt 2006 · S/N 156 N3049YPhilkill Steven · Milford, NJBuilt 2005 · S/N 154 N3052PClemons Louise E DBA · Truro, IABuilt 2005 · S/N 153 N3064RWalker David C · Laclede, MOBuilt 2006 · S/N 158 N31784Ballooning Adventures LLC · Ackworth, IAS/N 176 N31802Grote Matthew R · Rio Rancho, NMBuilt 2007 · S/N 161 N31804Clark Scott R · Phoenix, AZBuilt 2013 · S/N 171 N3180KScharke Philip J · Colorado Springs, COS/N 173 N31816Passing With Flying Colors Inc · Tyndall, SDS/N 172 N31817Campbell Danny D · Pleasant Hill, IABuilt 2015 · S/N 174 N3181HMartens Eric A · Indianola, IABuilt 2011 · S/N 170 N3181NGrote Matthew · Rio Rancho, NMBuilt 2008 · S/N 164 N3181PSmith Eric M · Centralia, ILBuilt 2010 · S/N 169 N3181YKing Jeremy W · Indianola, IAS/N 167 N31820Lacroix Steven D · Omaha, NEBuilt 2010 · S/N 166 N3182AWood Bruce L · Basalt, COS/N 168 N3182BEdgerton Scott L · Indianola, IABuilt 2022 · S/N 178 N3182CBertsch Christine R · Indianola, IABuilt 2008 · S/N 163 N3182MSonger Braydon · Ottumwa, IABuilt 2007 · S/N 160 N3183ADakota Apple Partnership · Minot, NDBuilt 2007 · S/N 162 N3183BHastie Todd B · Fleming Island, FLS/N 177 N3183UKing Jeremy W · Indianola, IABuilt 2023 · S/N 179 N3219VScharke Philip J · Colorado Springs, COS/N 107 N551DHSilver Lining Ballooning LLC · Prairie Grove, ARBuilt 2014 · S/N 175 N7000HNational Ballooning Ltd · Winterset, IAS/N 126 N7003LNess Christopher J · Rosemount, MNS/N 127 N7004NCampbell Danny D · Pleasant Hill, IABuilt 1997 · S/N 128 N70050Clark David R · Kent, OHBuilt 1997 · S/N 129 N70061Blue Darren K · Gilbert, AZBuilt 2000 · S/N 131 N7006JUhlir Tammy Lea · Maplewood, MNS/N 130 N72704King Jeremy W · Indianola, IAS/N 114 N7271FHartson Jason R · Pella, IAS/N 118 N9000NStone Jessica V · West Des Moines, IABuilt 2002 · S/N 143 N90027Davis Jason Russell · Milo, IAS/N 144 N9002XSmith William J · Storm Lake, IABuilt 2003 · S/N 147 N90050King Jeremy W · Indianola, IABuilt 2004 · S/N 150 N9005ELoving Jason R · Ottumwa, IABuilt 2003 · S/N 146 N9005QMains Andrew C · Bondurant, IABuilt 2005 · S/N 151 N9006UBennett Brian L · Agency, IABuilt 2004 · S/N 149 N9009KJones Michael A · Omaha, NEBuilt 2002 · S/N 140 N9010XMartens Eric A · Indianola, IABuilt 2004 · S/N 148 N9011UGarvie Richard F · Minneola, FLS/N 152

Back to National Ballooning 858