Skip to content

Registered aircraft · 353

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

N35638Newberry Ernest B Jr · Crawfordville, FLBuilt 1968 · S/N 17256879 N35639Sandwich Hawk LLC · Newark, ILS/N 17256880 N35644Pratt Sanders · Renton, WABuilt 1968 · S/N 17256882 N35651Schubnell Ryan A · Avondale Estates, GAS/N 17256884 N35653Fitzgerald Bryan L · Craig, AKBuilt 1968 · S/N 17256886 N35656Hew Llp · Beresford, SDBuilt 1968 · S/N 17256888 N35662Warbington Michael L · Enid, OKS/N 17256890 N35665Imes Rusty J · Greenacres, WAS/N 17256893 N35667Gamby John E · Chadron, NEBuilt 1968 · S/N 17256895 N35668Schwartz Brenda A · San Angelo, TXBuilt 1968 · S/N 17256896 N35669Selkirk Seaplanes LLC · Hayden, IDBuilt 1968 · S/N 17256897 N35672Leaseair LLC · Wilmington, DEBuilt 1968 · S/N 17256898 N35673Knutson Ronald J · Tacoma, WABuilt 1968 · S/N 17256899 N35675Scholand Gregory J · West Ossipee, NHBuilt 1968 · S/N 17256900 N35678Trone Gary L · Taylorville, ILBuilt 1968 · S/N 17256903 N35680Pilot Studio LLC · Sabana Seca, PRS/N 17256905 N35683Dmac Aircraft LLC · Savannah, GABuilt 1968 · S/N 17256906 N35690Mcauliffe Pat · Collegeville, PABuilt 1968 · S/N 17256911 N35696Beisel Johnathan · Owasso, OKS/N 17256914 N35700Sutton Aircraft Salvage LLC · Palmer, AKBuilt 1968 · S/N 17256916 N35701Mcha Aviation LLC · Vinita, OKBuilt 1968 · S/N 17256917 N35707Pray Aviation Inc · Augusta, KSBuilt 1968 · S/N 17256921 N35711Pumphrey Robert B Jr · Saint Paris, OHBuilt 1968 · S/N 17256925 N35712Mw Flying LLC · Sanford, NCBuilt 1968 · S/N 17256926 N3571335713 LLC · Kitty Hawk, NCBuilt 1968 · S/N 17256927 N35714Skyhawk Rising LLC · Manchester, IAFirst renewal noticeS/N 17256928 N35715Kindblade Aeronautics LLC · Casper, WYBuilt 1968 · S/N 17256929 N35716Ward Seth W · Demorest, GABuilt 1968 · S/N 17256930 N35719Jensen Greg D · Omaha, NEBuilt 1968 · S/N 17256932 N35725Kling Jonathan N · Ruther Glen, VABuilt 1968 · S/N 17256936 N35726Jh Aero LLC · Little Rock, ARS/N 17256937 N35728Gone Broke LLC · Fairhope, ALBuilt 1968 · S/N 17256939 N35730Miner Jay G · Seattle, WABuilt 1968 · S/N 17256940 N35731Registration Pending · Carthage, NCRegistration pendingBuilt 1968 · S/N 17256941 N35735Gaston Brothers Excavating Inc · Seattle, WAS/N 17256943 N35738Plane Life LLC · Wilmington, DEBuilt 1968 · S/N 17256944 N35741Covelli Scott · Spicewood, TXBuilt 1968 · S/N 17256945 N35744Noland Farms Inc · Blue Mound, ILBuilt 1968 · S/N 17256947 N35746Hoard David L · Germantown, TNBuilt 1968 · S/N 17256948 N35748Price Stanley C · Grapevine, TXBuilt 1968 · S/N 17256950 N35749Pashley John F · Johnstown, NYBuilt 1968 · S/N 17256951 N35751Bas Part Sales LLC · Greeley, COBuilt 1968 · S/N 17256953 N35752Radcliffe Ronald W · Juneau, AKS/N 17256954 N35753Gipson Aviation LLC · Beach City, TXS/N 17256955 N35760Johnson Harry D Jr · Unalakleet, AKS/N 17256957 N35763Woodson Marcus S · Waxahachie, TXBuilt 1968 · S/N 17256958 N35770Ccb Flyers LLC · Waco, TXBuilt 1968 · S/N 17256959 N35779Syrang Aero Club Inc · Cato, NYFirst renewal noticeBuilt 1968 · S/N 17256961 N35788Glennon Christopher M · Villa Park, ILBuilt 1968 · S/N 17256962 N35790Integrity Aviation Inc · Worthington, MNBuilt 1968 · S/N 17256963

Back to Cessna 172I