Skip to content

Registered aircraft · 435

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

N7602TColeman David R · Limerick, MEBuilt 1959 · S/N 47202 N7603TMurphy Brian K · La Crosse, WIFirst renewal noticeS/N 47203 N7604TWestern Nebraska Technical College · Scottsbluff, NEBuilt 1960 · S/N 47204 N7606TFord Edsel W · Mustang, OKBuilt 1959 · S/N 47206 N7607TVantine Willard W III · Lexington, SCBuilt 1959 · S/N 47207 N7609THall Donald P · Anacortes, WABuilt 1959 · S/N 47209 N7610TDines Stephen R · Monument, COBuilt 1965 · S/N 47210 N7612TBabcock Douglas O · Chesterton, INBuilt 1960 · S/N 47212 N7615TN Maple LLC · Kalispell, MTS/N 47215 N7621TScheetz Wayne E · Center Point, IABuilt 1960 · S/N 47221 N7622TFuhrman Chad L · Manchester, TNBuilt 1960 · S/N 47222 N7623TMooney Micheal E · Auburn, INBuilt 1960 · S/N 47223 N7624TAir & Opportunity Aviation LLC · Yorktown, VABuilt 1960 · S/N 47224 N7626TKoch Suzanne Elizabeth · Battle Ground, WABuilt 1960 · S/N 47226 N7629TBork Joseph L · Masier, ORS/N 47229 N7636TN7636t LLC · Farmdale, OHBuilt 1960 · S/N 47236 N7638TEaglet Flight Operations Lp · Fort Worth, TXBuilt 1960 · S/N 47238 N7639TCaldwell Perrin L · Batesville, MSBuilt 1960 · S/N 47239 N7640TAloway Shaquetta S · Cleveland, OHS/N 47240 N7642TLuthi Mark P · Rome, GABuilt 1960 · S/N 47242 N7647THolmen Roger A · Carlsbad, NMS/N 47247 N7648TAppel Jacob · Redfield, SDS/N 47248 N7649TScott Steve W · Antioch, CAS/N 47249 N7655TMorrell Nathaniel A · Pelham, GABuilt 1960 · S/N 47255 N7657TGuarno Adam C · Milton, FLBuilt 1960 · S/N 47257 N7659TKano Yoshio W · Barrington, ILBuilt 1960 · S/N 47259 N7662TTriana David · Goose Creek, SCBuilt 1960 · S/N 47262 N7663TTc Flight LLC · Lincoln, NES/N 47263 N7667THembree Roy C Jr · Covington, GABuilt 1960 · S/N 47267 N7668THoff Stephen R · Wilson, WYBuilt 1960 · S/N 47268 N7673TDunning Steve G · Assaria, KSBuilt 1960 · S/N 47273 N7674TDugger Robert F · Ashville, ALBuilt 1960 · S/N 47274 N7675TClegg Peter M · Grace, IDS/N 47275 N7676TNickerson David W · East New Market, MDBuilt 1960 · S/N 47276 N767RAClear Prop Aero Inc · Webster, MNBuilt 1959 · S/N 47078 N7683TCleary Michael A · Folsom, CABuilt 1960 · S/N 47283 N7688TRodgers Bruce W · Pine Bluff, ARBuilt 1960 · S/N 47288 N7689TMcclatchey Steven C · Linn Grove, IABuilt 1960 · S/N 47289 N7690TFranwick Industries LLC · Westbrook, CTBuilt 1960 · S/N 47290 N7691TDewitt Dennis M · Collinsville, ALBuilt 1960 · S/N 47291 N7693TButler Richard A · Gatesville, TXFirst renewal noticeBuilt 1960 · S/N 47293 N7694THeaps John J · Dunlap, IABuilt 1960 · S/N 47294 N7697TElliott Jason Rex · Brawley, CABuilt 1960 · S/N 47297 N7698TGerman Jamison K · Greenville, MIBuilt 1960 · S/N 47298 N7699TThomas Ag Aerial Inc · Thomas, OKBuilt 1960 · S/N 47299 N7702TNablo Dustin · Haddam Neck, CTS/N 47302 N7707TAmerican Petro Inc · Ball Ground, GABuilt 1960 · S/N 47307 N7710TMorton David W · Brady, TXBuilt 1960 · S/N 47310 N7711TBaker Eddy · Waynesville, ILBuilt 1960 · S/N 47311 N7713THatton Daniel R · Portland, ORS/N 47313

Back to Cessna 172A