Skip to content

Registered aircraft · 1,805

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

N7050AMccollum Devin S · Flagstaff, AZS/N 29150 N7051TWeems James M · Paris, TXS/N 46651 N7052THurst Jon M · Paw Paw, MIBuilt 1959 · S/N 46652 N7053APearsall Timothy R · Rexford, NYBuilt 1956 · S/N 29153 N7054AOtt Rex A · Burlington, IABuilt 1956 · S/N 29154 N7056THeinke John R · Paradise, CABuilt 1958 · S/N 46656 N7059AWebster Mark Lawrence · Frankston, TXBuilt 1956 · S/N 29159 N7059TBrommer Roger A · Lino Lakes, MNBuilt 1959 · S/N 46659 N7060AWalker Jonathan S · Council Bluffs, IABuilt 1956 · S/N 29160 N7062TJardd Inc · Lorain, OHBuilt 1959 · S/N 46662 N7063ASexton Forest · Eagle Point, ORBuilt 1956 · S/N 29163 N7063TMorris Coady C · Russell, KSS/N 46663 N7064ASelby Joshua F · Condon, ORBuilt 1956 · S/N 29164 N7065AJahnke Michael D · Wichita, KSBuilt 1956 · S/N 29165 N7065TRegistered aircraftBuilt 1959 · S/N 46665 N7066ANewton Consulting & Engineering Inc · Tucson, AZBuilt 1956 · S/N 29166 N7067AWhitemire Jospeh A · Soddy Daisy, TNBuilt 1956 · S/N 29167 N7067TSmith Roy Harold · Whiteville, NCBuilt 1959 · S/N 46667 N7068AMcdonald Ronald B · Arcadia, FLBuilt 1956 · S/N 29168 N7069THovey Terry W · Rogue River, ORBuilt 1959 · S/N 46669 N7071AFieldman Gregory S · Olympia, WABuilt 1956 · S/N 29171 N7072ABig R Of Greeley · Greeley, COS/N 29172 N7072TFlaugher P Diane · Beloit, WIBuilt 1959 · S/N 46672 N7074AFogg Morgan T · Pierce, COBuilt 1956 · S/N 29174 N7074TNielson Dean A · Inchelium, WABuilt 1959 · S/N 46674 N7075AStonebrink Arnold · Payson, AZS/N 29175 N7076TLuebke Harold W Jr · Stuttgart, ARBuilt 1959 · S/N 46676 N7079ADerbe LLC · Durham, NCBuilt 1956 · S/N 29179 N7080ARedmon Michael P · Canal Winchester, OHBuilt 1956 · S/N 29180 N7080TKingdom Planes LLC · Decatur, TXBuilt 1959 · S/N 46680 N7081ASeibert Edwin M · Swansea, SCBuilt 1956 · S/N 29181 N7081TYanez Manuel R · Calexico, CAS/N 46681 N7082TGarrett Kasey L · Wilder, IDS/N 46682 N7084ABaldwin Glen R · Culdesac, IDS/N 29184 N7084THeitkamp Douglas C · Barney, NDS/N 46684 N7085TKelley Geoffrey A · Wichita, KSBuilt 1959 · S/N 46685 N7086ATugmon Danny Lee · Locust Grove, OKBuilt 1956 · S/N 29186 N7087TLakelands Flyers LLC · Greenwood, SCS/N 46687 N7089ARuotsi Tony M · Beaver Island, MIBuilt 1956 · S/N 29189 N7091ASears Rusty M · Alma, GAS/N 29191 N7091TJensen William Robert · Zephyrhills, FLFirst renewal noticeBuilt 1959 · S/N 46691 N7093AValle Daniel J · Canton, MIBuilt 1956 · S/N 29193 N7095TCurrence Brian J · Rock Hill, SCS/N 46695 N7096AWhite Lee A · Columbus, OHS/N 29196 N7099TDls Aviation LLC · Missoula, MTBuilt 1959 · S/N 46699 N70RSStriplin James R Jr · Hartford, ALBuilt 1959 · S/N 46470 N7100ANoel Roberto Vallejo LLC · Orem, UTS/N 29200 N7100TDillman Robert F · Suffolk, VABuilt 1959 · S/N 46700 N7101AChickasha Wings Inc · Chickasha, OKBuilt 1956 · S/N 29201 N7101TLee Terry R · Little Canada, MNS/N 46701

Back to Cessna 172