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.

N842WBGiesbrecht Nolan R · Burns, ORBuilt 1958 · S/N 36665 N8448XPritchard Jason T · Blaine, WAS/N 46615 N84JK Diamond K Guest Ranch LLC · Republic, WABuilt 1958 · S/N 46010 N8502BSims Hollow M · Lithonia, GABuilt 1957 · S/N 36202 N8505BGreen James S · Slaton, TXS/N 36205 N8506BTierney Garrett J · Manorville, NYBuilt 1957 · S/N 36206 N8508BCc Motors LLC · Redding, CABuilt 1957 · S/N 36208 N8509BLafleur Joel A · Garden Valley, IDBuilt 1957 · S/N 36209 N8513BFisher Steven B · Kuna, IDS/N 36213 N8516BEdson David V · Ionia, IABuilt 1957 · S/N 36216 N8520BCook Mike R · Rye, COBuilt 1957 · S/N 36220 N8521BHiebert Isaac G · Hachita, NMBuilt 1957 · S/N 36221 N8524BBecker Robert A · Santa Rosa, CABuilt 1957 · S/N 36224 N8526BMallory John C · Fairbanks, AKBuilt 1957 · S/N 36226 N8527BWeber Randy J · Homer, AKS/N 36227 N8528BReiber Robert F · Riverside, CABuilt 1957 · S/N 36228 N8529BBlakely Jerry C · Winona, MSBuilt 1957 · S/N 36229 N8533BBungert Heidi J · Inver Grove, MNBuilt 1957 · S/N 36233 N8543BKilo Aviation LLC · East Peoria, ILBuilt 1957 · S/N 36243 N8544BPatry Aeronautical Institute · Kalispell, MTS/N 36244 N8545BEdwards Jess W · Carson City, NVS/N 36245 N8546BGray Brian D · Kermit, TXS/N 36246 N8548BGodbout Kevin · South Hadley, MAS/N 36248 N8549BPhaneuf Dave · Adams, TNBuilt 1957 · S/N 36249 N8552BTenney Curtis J · Sevierville, TNBuilt 1957 · S/N 36252 N8553BVaught Ralph S · Star Valley, AZBuilt 1957 · S/N 36253 N8554BSummers Kim C · Winnemucca, NVBuilt 1957 · S/N 36254 N8555BThompson Greg M · Rigby, IDBuilt 1957 · S/N 36255 N8556BKendig Dustin Zarah · Portland, ORBuilt 1957 · S/N 36256 N8558BWilliams Ralph J · Essex Junction, VTBuilt 1957 · S/N 36258 N8564BKarpe Kendall K · Plymouth, MNBuilt 1957 · S/N 36264 N8565BQuill James M · Granby, MABuilt 1957 · S/N 36265 N8569BSpraches Edward J · Franklin, NCS/N 36269 N8570BPilot Coaches LLC · Little Falls, MNS/N 36270 N8576BRomeo Delta Inc · Elsie, MIBuilt 1957 · S/N 36276 N8580BB&R Aircraft LLC · Wadsworth, OHBuilt 1958 · S/N 36280 N8582BHousley William M · Jasper, ALS/N 36282 N8587BDorsey Tony A · Anchorage, AKBuilt 1958 · S/N 36287 N8589BHansen Aviation LLC · Savannah, GABuilt 1957 · S/N 36289 N8591BTechnical Education Services Inc T/A · Virginia Beach, VABuilt 1957 · S/N 36291 N8592BCalvert John · Tybee Island, GABuilt 1957 · S/N 36292 N8593BAndys Auto Sales LLC · Caroline, WIBuilt 1957 · S/N 36293 N8594BBeyer Jeffrey R · Slinger, WIBuilt 1957 · S/N 36294 N8599BPruett Mike A · Springdale, ARBuilt 1958 · S/N 36299 N8600BGold Daniel A · North Pole, AKBuilt 1957 · S/N 36300 N8601BKorta Stephen E · Poplar Grove, ILS/N 36301 N8602BShannon Terrence M · Kuna, IDBuilt 1957 · S/N 36302 N8603BBrown Benjamin J · Kasilof, AKBuilt 1957 · S/N 36303 N8604BPlesich Nicholas J · Point Roberts, WAFirst renewal noticeS/N 36304 N8606BShayne Mark S · Arlington, WABuilt 1957 · S/N 36306

Back to Cessna 172