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.

N7717TGully Samuel Lee · Noxapater, MSBuilt 1960 · S/N 47317 N7719TRushton George Emery · Clinton, MIS/N 47319 N7721TBourdon Alain · West Springfield, MABuilt 1960 · S/N 47321 N7722TPfc Aviation Repair Inc · Wallingford, CTS/N 47322 N7731TNash Leslie W · Bentonia, MSBuilt 1960 · S/N 47331 N7733TSiu Ena · Reno, NVS/N 47333 N7742THelmuth Allen · Powell Butte, ORBuilt 1960 · S/N 47342 N7746TWilson Steven C · Raleigh, NCBuilt 1960 · S/N 47346 N7751TBehl Nathan S · Lewistown, MTBuilt 1960 · S/N 47351 N7753THollis Scott C · Sumpter, ORBuilt 1960 · S/N 47353 N7757THarris Seth · Ellensburg, WABuilt 1960 · S/N 47357 N7758TWorringer Richard G · Tower, MNBuilt 1960 · S/N 47358 N7759TMartin Douglas A · Bartlett, ILBuilt 1960 · S/N 47359 N7762TLisle Rachel C · New Enterprise, PABuilt 1960 · S/N 47362 N7763TWood Pro Ventures LLC · Justiceburg, TXBuilt 1960 · S/N 47363 N7765TWhisman Marc K · Long Beach, CABuilt 1960 · S/N 47365 N7766TGourley Steven E · Unionville, MOBuilt 1960 · S/N 47366 N7767TVisscher Paul J · Madison, GABuilt 1960 · S/N 47367 N7769TWhiskey Tango Foxtrot Aviation LLC · Bemidji, MNBuilt 1960 · S/N 47369 N7770TShinn William D · Milton, WABuilt 1960 · S/N 47370 N7771TBailey Bradley E · Phoenix, AZBuilt 1960 · S/N 47371 N7773TBennett Kevin S · Bay City, ORBuilt 1960 · S/N 47373 N7775TSheaffer Hayden L · Lititz, PABuilt 1960 · S/N 47375 N7781TChouinard Shawn A · Collinsville, OKBuilt 1960 · S/N 47381 N7782THicks Thomas H · Conway, ARS/N 47382 N7784TJustonemore LLC · Fayetteville, ARBuilt 1960 · S/N 47384 N7790TAviation Trade Inc · Castroville, TXBuilt 1960 · S/N 47390 N7791TVintage Aero Aviation LLC · Baldwin Park, CABuilt 1960 · S/N 47391 N7792TFrench Rodney A · Warsaw, INBuilt 1960 · S/N 47392 N7795TJim Air Inc · Wilmington, DEBuilt 1960 · S/N 47395 N7797TDanforth Lawrence P · Flushing, MIBuilt 1960 · S/N 47397 N7798TCessna Aces LLC · Metairie, LABuilt 1960 · S/N 47398 N7800TNorth Texas Aeronautics LLC · Burleson, TXBuilt 1960 · S/N 47400 N7805TSanford William M · Olalla, WABuilt 1960 · S/N 47405 N7808TMckay H Samuel · Barnwell, SCBuilt 1960 · S/N 47408 N7811THoke Cylus G · Culver, ORBuilt 1960 · S/N 47411 N7821TCameron Michael Shelley · Reno, NVBuilt 1960 · S/N 47421 N7827TToler Gary P · San Clemente, CAS/N 47427 N7828TBunde Konstantine E · Goldendale, WABuilt 1960 · S/N 47428 N7829TDampier William · Greenwood, INBuilt 1960 · S/N 47429 N7830TWalker Homes LLC · Stratford, OKBuilt 1960 · S/N 47430 N7832TN7832t LLC · Wilmington, DEBuilt 1960 · S/N 47432 N7833TJohnson Spring M · Wortham, TXBuilt 1960 · S/N 47433 N7834TYturri David P · Marble Falls, TXBuilt 1960 · S/N 47434 N7835TRound Engine Aero · Nashville, MIBuilt 1960 · S/N 47435 N7841TMannon Jason L · Fontana, WIBuilt 1960 · S/N 47441 N7842TRmb Helicopters LLC · Factoryville, PABuilt 1960 · S/N 47442 N7844TRegistration Pending · Saint Matthews, SCRegistration pendingBuilt 1960 · S/N 47444 N7845TOrr Dorthy L · Santa Paula, CABuilt 1960 · S/N 47445 N7849TMyers Stanley · Portland, ORBuilt 1960 · S/N 47449

Back to Cessna 172A