Skip to content

Registered aircraft · 722

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 ('2072420')
  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 ('2072420')
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.

N3988LWind Walker LLC · Tucson, AZBuilt 1966 · S/N 17254157 N3989LCivico Royce S · Arlington, WABuilt 1966 · S/N 17254158 N3992LAnderson Curt W · Independence, ORBuilt 1966 · S/N 17254161 N3995LLee Valerie A · Newville, ALBuilt 1966 · S/N 17254164 N3998LKansas Copters & Wings Inc · Augusta, KSBuilt 1966 · S/N 17254167 N3999LMorris Jeffrey A · Lake Delton, WIS/N 17254168 N39JJStag Aviation LLC · Tomball, TXBuilt 1966 · S/N 17254265 N4106LHackens Bryan Jay · New Underwood, SDBuilt 1966 · S/N 17254175 N4107LRobitaille Charles · Stephenville, TXS/N 17254176 N4108LCriss Mark · Eaton Rapids, MIBuilt 1966 · S/N 17254177 N4109LMarrian Jason · Westtown, NYBuilt 1966 · S/N 17254178 N4110LNeu Aviation LLC · Benton, LABuilt 1966 · S/N 17254179 N4114LLarson Lynn R · Casselton, NDBuilt 1966 · S/N 17254183 N4115LPierce Michael W · Leitchfield, KYBuilt 1966 · S/N 17254184 N4116LHubbard Matt · Phoenix, AZBuilt 1966 · S/N 17254185 N4117LPatrick Milan Jr · Shinnston, WVBuilt 1966 · S/N 17254186 N4118LUan Venture Partners LLC · Odessa, FLBuilt 1966 · S/N 17254187 N4119LSugar Aircraft LLC · Oak Harbor, WAS/N 17254188 N4125LEvans Samuel F · Selma, ALS/N 17254194 N4126LBritton Jeff J · Forest Falls, CABuilt 1966 · S/N 17254195 N4127LHoldt Farms Inc · Elgin, NEBuilt 1966 · S/N 17254196 N4129LIrwin Kristin L · Emporia, KSS/N 17254198 N4134LMountain View Aviation Inc · Cedar Bluff, VABuilt 1966 · S/N 17254203 N4135LHudson Kimmine · Erie, COBuilt 1966 · S/N 17254204 N4136LDickerson Richard L · Fort Worth, TXBuilt 1966 · S/N 17254205 N4141LPeder Richard A · Sequim, WABuilt 1966 · S/N 17254210 N4142LSegura Michelle Marie · Dallas, TXBuilt 1966 · S/N 17254211 N4149LRegistration Pending · Bryan, OHRegistration pendingS/N 17254218 N4150LBlankenship Daniel S · Paso Robles, CABuilt 1966 · S/N 17254219 N4151LPardun Phillip R · Mason City, IABuilt 1966 · S/N 17254220 N4152LLambert Robert · Paoli, INBuilt 1966 · S/N 17254221 N4156LZimmer Marc R · Moses Lake, WABuilt 1966 · S/N 17254225 N4159LGrassetti Raymond J · Monson, MABuilt 1966 · S/N 17254228 N4161LBruner Harvey L · Latexo, TXBuilt 1966 · S/N 17254230 N4163LLeitzman Robert A · Tucson, AZBuilt 1966 · S/N 17254232 N4164LDerwin Diversified Inc · Santa Paula, CABuilt 1966 · S/N 17254233 N4166LWarbelows Air Ventures · Fairbanks, AKBuilt 1966 · S/N 17254235 N4168LRoberts James E · Golconda, ILBuilt 1966 · S/N 17254237 N4171LFleeman Danny W · Manila, ARBuilt 1966 · S/N 17254240 N4175LColangelo Frank · New Preston, CTBuilt 1966 · S/N 17254244 N4179LMorristown Flying Service Inc · Talbott, TNBuilt 1966 · S/N 17254248 N4180LMcginn Robert W · Marion, NCBuilt 1966 · S/N 17254249 N4184LKleman Connie F · West Bend, WIBuilt 1966 · S/N 17254253 N4186LG2g Aviation LLC · Wray, COBuilt 1966 · S/N 17254255 N4188LHlr Aviation LLC · Swan Lake, NYBuilt 1966 · S/N 17254257 N4190LLutz Winfield G · Leeper, PAS/N 17254259 N4191LKelsey James R Sr · La Plata, MOS/N 17254260 N4193LJaybird Flight LLC · Mesa, AZBuilt 1966 · S/N 17254262 N4199LSarkisian Arthur · Woodstock, GABuilt 1966 · S/N 17254268 N4200LDewey Michael C · Deer Island, ORBuilt 1966 · S/N 17254269

Back to Cessna 172G