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.

N7448XPeterson Bruce L · Williston, NDBuilt 1960 · S/N 17247948 N7451XReady Aim Flyer LLC · New Castle, DES/N 17247951 N7453XMccoy Rileigh N · Conway, ARBuilt 1960 · S/N 17247953 N7455XAsher Jerry R · Speedwell, TNBuilt 1960 · S/N 17247955 N7456XHanson Devan D · Stephenville, TXBuilt 1960 · S/N 17247956 N7459XMccormick Gary E · Fairbanks, AKBuilt 1960 · S/N 17247959 N7461XIsert Brian · Melba, IDBuilt 1960 · S/N 17247961 N7462XSheehan Michael · Canton, GABuilt 1960 · S/N 17247962 N7463XGillespie William G · Antioch, CABuilt 1960 · S/N 17247963 N7464XYluv1 LLC · Orlando, FLBuilt 1960 · S/N 17247964 N7465XTaylor Brian · Anchorage, AKBuilt 1960 · S/N 17247965 N7467XLorentzen Ross H · Washburn, NDBuilt 1960 · S/N 17247967 N7468XHarris David Shane · Kilgore, TXS/N 17247968 N7473XMundschau David L · Waukesha, WIBuilt 1960 · S/N 17247973 N7475XPanepinto Lane P · Lafitte, LABuilt 1960 · S/N 17247975 N7477XBindea Bogdan Andrei · Charlottesville, VAS/N 17247977 N7479XLanger Joseph H · Blairsville, GAS/N 17247979 N7480XFoster Ricardo E · Lutz, FLBuilt 1960 · S/N 17247980 N7482XWilliams John R · Maquoketa, IABuilt 1960 · S/N 17247982 N7483XDoerr David B · Verdon, NEBuilt 1960 · S/N 17247983 N7484XHoulton Timbre R · Fairbanks, AKBuilt 1960 · S/N 17247984 N7485XEngland Robert C · Zanesville, OHBuilt 1960 · S/N 17247985 N7490XDawson Ejay J · Eveleth, MNBuilt 1960 · S/N 17247990 N7495XIsch Philip D · Geneva, INBuilt 1960 · S/N 17247995 N7496XAbove All Aviation Inc · Santa Barbara, CABuilt 1960 · S/N 17247996 N7497XTrinciante Fernando S · Thief River Falls, MNBuilt 1960 · S/N 17247997 N7499XVintage Aircraft Ltd · Hortonville, WIBuilt 1960 · S/N 17247999 N7502XSnyder Mitchell R · Collierville, TNBuilt 1960 · S/N 17248002 N7503XLamb Barry · Moran, KSBuilt 1960 · S/N 17248003 N7504XMilnor Aviation Inc · Milnor, NDBuilt 1960 · S/N 17248004 N7505XCrumpacker John E · Timberville, VABuilt 1960 · S/N 17248005 N7506XRenquist John H · Valley Center, CABuilt 1960 · S/N 17248006 N7508XBain Sterling C Jr · Alexandria, LABuilt 1960 · S/N 17248008 N7509XRussell Adam · Easton, MEBuilt 1960 · S/N 17248009 N7510XSeifert Ross W · Pelican Rapids, MNBuilt 1960 · S/N 17248010 N7513XN7513x LLC · Cottonwood, CABuilt 1960 · S/N 17248013 N7514XBrown Thomas · Austin, TXS/N 17248014 N7515XSnap Aviation LLC · Athens, PABuilt 1960 · S/N 17248015 N7517XHalley Dan R · Avery, TXBuilt 1960 · S/N 17248017 N7519XSouthern Moulding Acquisition LLC · Marietta, GABuilt 1960 · S/N 17248019 N7520XSunwave Land LLC · Big Spring, TXBuilt 1960 · S/N 17248020 N7521XWainwright Donald W · Live Oak, FLS/N 17248021 N7522XZitterkopf Gary N · Casper, WYBuilt 1960 · S/N 17248022 N7526XWeickum Lee A · Monroe, ORBuilt 1960 · S/N 17248026 N7527XRankin Scott W · Kansas City, MOBuilt 1960 · S/N 17248027 N7528XJewell Burton Connor Jacob · Pensacola, FLBuilt 1960 · S/N 17248028 N7529XBrown Anthony W · Sacramento, KYS/N 17248029 N7532XRoy John L · Edmonds, WABuilt 1960 · S/N 17248032 N7533XRegistration Pending · Lincoln, NDRegistration pendingBuilt 1960 · S/N 17248033 N7535XLilley Jeffery L · Buffalo, MOBuilt 1960 · S/N 17248035

Back to Cessna 172B