Skip to content

Registered aircraft · 617

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

N3902SGooding Flying Club · Gooding, IDBuilt 1963 · S/N 17251102 N3903SAt Aero LLC · Wilmington, DEBuilt 1963 · S/N 17251103 N3904SLambert Aviation Service LLC · Washington, PABuilt 1963 · S/N 17251104 N3907SWilliamson Henry H · Conway, SCBuilt 1964 · S/N 17251107 N3909SManer Lawrence L II · Lexington, SCBuilt 1964 · S/N 17251109 N3910SBenzing Blaine L · Caledonia, MNBuilt 1963 · S/N 17251110 N3912SWalters Gregory · Neodesha, KSS/N 17251112 N3914SMdz Aviation LLC · Orlando, FLBuilt 1964 · S/N 17251114 N3916SSchmitt Rudy · Brookshire, TXBuilt 1964 · S/N 17251116 N3917SScantling Jason H · Bangs, TXBuilt 1963 · S/N 17251117 N3922SWilson Michael K · Medicine Lodge, KSBuilt 1964 · S/N 17251122 N3925SWilcox Ralph G · Owensboro, KYBuilt 1964 · S/N 17251125 N3926SO'Brien Michael A · Alamo, CABuilt 1964 · S/N 17251126 N3927SJensen Allen S · Atlanta, GABuilt 1963 · S/N 17251127 N3930SHoperich Benjamin J · Galena, OHBuilt 1963 · S/N 17251130 N3933SFrontline Aviation LLC · Blackshear, GABuilt 1963 · S/N 17251133 N3935SFallbrook Flight Academy LLC · Fallbrook, CABuilt 1963 · S/N 17251135 N3939SDream Big Aviation LLC · Mount Juliet, TNBuilt 1963 · S/N 17251139 N3940SPrincess Air Inc · Pocahontas, IABuilt 1964 · S/N 17251140 N39420Shehee Derek J · Prattville, ALS/N R-1720002 N3942SCromley Amanda J · Lewisburg, PABuilt 1964 · S/N 17251142 N3944Avra Valley Flyers LLC · Gilbert, AZBuilt 1964 · S/N 17251510 N3945SStrickland Jason R · Tollhouse, CAS/N 17251145 N3946SDepoy Lowell K · Salem, INBuilt 1964 · S/N 17251146 N3948SDykstra Johnny R · Sioux Falls, SDBuilt 1964 · S/N 17251148 N3949SColler Sauntee C · Kadoka, SDBuilt 1964 · S/N 17251149 N3950SBlue Sky Aviation Adventures LLC · St George, UTS/N 17251150 N3952STorres Jeremy · Cranston, RIBuilt 1964 · S/N 17251152 N3953SLex Air LLC · Corona, CABuilt 1964 · S/N 17251153 N3954SCochran Kevin R Trustee · Dayton, OHBuilt 1964 · S/N 17251154 N3955SZilz Tammy S · Saint Peters, MOBuilt 1964 · S/N 17251155 N3956SEndsley Terry G · Wilkeson, WAS/N 17251156 N3957SSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1964 · S/N 17251157 N3959SAljuboori Ghassan A · Clackamas, ORBuilt 1964 · S/N 17251159 N3963SWagner Matthew W · Hinckley, OHBuilt 1964 · S/N 17251163 N3964SHartwig Scott N · De Soto, ILBuilt 1964 · S/N 17251164 N3965SJepsen William R Trustee · Heppner, ORFirst renewal noticeBuilt 1964 · S/N 17251165 N3966SCulp Charles L · Baytown, TXBuilt 1964 · S/N 17251166 N3968SMcnally James J · Neligh, NEBuilt 1964 · S/N 17251168 N3970SStockman David L · Eldon, MOBuilt 1964 · S/N 17251170 N3973SSchwanz William D · Presque Isle, WIBuilt 1964 · S/N 17251173 N3975SRegistration Pending · Columbia Falls, MTRegistration pendingBuilt 1964 · S/N 17251175 N3976SHamrick Steven G · Pahrump, NVBuilt 1964 · S/N 17251176 N3977SRegistration Pending · Augusta, KSRegistration pendingBuilt 1964 · S/N 17251177 N3978SRowlett Charles · Fallbrook, CABuilt 1964 · S/N 17251178 N3980SThompson Richard L · Friday Harbor, WAS/N 17251180 N3983SPatterson Richard A · Clinton, SCBuilt 1964 · S/N 17251183 N3984SGreeson Gary D · Winchester, TNBuilt 1964 · S/N 17251184 N3989SPaul Kassel Corp · Poway, CABuilt 1964 · S/N 17251189 N3991SSoaring Comets LLC · Camarillo, CABuilt 1964 · S/N 17251191

Back to Cessna 172E