Skip to content

Registered aircraft · 413

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

N7651XHappy Landings Aviation LLC · Maple, NCS/N 17248151 N7655XMedical Surgical Clinic LLC · Fort Scott, KSBuilt 1960 · S/N 17248155 N7656XMiranda Maria J · Santa Maria, CABuilt 1960 · S/N 17248156 N7657XGordon Christopher R · Moose Pass, AKBuilt 1960 · S/N 17248157 N7660XAdams John S · Roselle, ILBuilt 1960 · S/N 17248160 N7665XAvz Aviation.Inc · Knoxville, TNS/N 17248165 N7666XSidaras Al · Salado, TXBuilt 1960 · S/N 17248166 N7667XMatthews Thomas A · Belvidere, NJBuilt 1960 · S/N 17248167 N7668XEkerberg Mark J · Newton, KSBuilt 1960 · S/N 17248168 N7670XLohrke James W · Converse, TXBuilt 1960 · S/N 17248170 N7671XBernsen Timothy Stephen · Devine, TXS/N 17248171 N7672XFlying Couch LLC · Orleans, MABuilt 1961 · S/N 17248172 N7673XDunham Randy C DBA · Lawton, OKBuilt 1960 · S/N 17248173 N7675XEstes Jerry L · Lewisville, ARBuilt 1960 · S/N 17248175 N7678XSandstone Point Cattle Co LLC · Seguin, TXBuilt 1960 · S/N 17248178 N7682XRosenlof Dean F · Tempe, AZBuilt 1961 · S/N 17248182 N7687XMost Ronald · Apple Valley, CABuilt 1961 · S/N 17248187 N7688XMauldin Gary · Navajo Dam, NMBuilt 1960 · S/N 17248188 N7690XNeu Aviation LLC · Benton, LABuilt 1960 · S/N 17248190 N7691XAndrade Nelson J · Redwood City, CABuilt 1960 · S/N 17248191 N7692XJohnson Kevin D · Eldorado, KSS/N 17248192 N7697XDecker Sidney R · San Marcos, TXBuilt 1961 · S/N 17248197 N7700XRule Paul Crane Trustee · Wapato, WABuilt 1961 · S/N 17248200 N7704XStark Linda L · Arroyo Grande, CABuilt 1960 · S/N 17248204 N7706XAircaft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1960 · S/N 17248206 N7710XGraves Robert D · Elberton, GABuilt 1960 · S/N 17248210 N7714XLenhardt Edward J · Green Lane, PABuilt 1961 · S/N 17248214 N7720XJeter Thomas L · South Padre Island, TXBuilt 1960 · S/N 17248220 N7722XLeasure Everett D · Joliet, ILBuilt 1960 · S/N 17248222 N7724XJohnson Randy G · Collinsville, OKBuilt 1960 · S/N 17248224 N7726XTop Profile Management LLC · Somis, CABuilt 1960 · S/N 17248226 N7732XLinstad Daniel E · Canby, ORBuilt 1960 · S/N 17248232 N7734XNelson Daniel J · Ladd, ILBuilt 1961 · S/N 17248234 N7736XSutton Aircraft Salvage LLC · Palmer, AKBuilt 1960 · S/N 17248236 N7738XSutter William R · Hobart, WAS/N 17248238 N7740XAnderson Vance K · Eugene, ORBuilt 1960 · S/N 17248240 N7742XMoore John W · Blue Earth, MNS/N 17248242 N7746XHennings Noran E · Des Moines, WABuilt 1961 · S/N 17248246 N7750XBurklund Joel H · Minneapolis, MNS/N 17248250 N7752XCassell Peter B Jr · Stonewall, LABuilt 1961 · S/N 17248252 N7754XKendall David · Ferndale, CABuilt 1960 · S/N 17248254 N7756XSkelton Air LLC · Lewiston, IDBuilt 1960 · S/N 17248256 N7758XHewitt Chad R · Vernonia, ORS/N 17248258 N7762XRodriguez Bruno · Crestview, FLBuilt 1961 · S/N 17248262 N7764XMalcolm Ward A · Moorefield, WVBuilt 1960 · S/N 17248264 N7772XPremier Air Inc · Raceland, LABuilt 1961 · S/N 17248272 N7776XVista I Inc · Smithville, OHBuilt 1961 · S/N 17248276 N7780XRegistration Pending · Meridian, IDRegistration pendingS/N 17248280 N7781XPeraro Thomas A · Brighton, COS/N 17248281 N7782XBoucher Roberta Ann · Fredericksburg, VABuilt 1961 · S/N 17248282

Back to Cessna 172B