Skip to content

Registered aircraft · 363

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

N1405YImrich Thomas S · Mercer Island, WABuilt 1961 · S/N 17249105 N1408YShawver Aviation LLC · Knoxville, IABuilt 1961 · S/N 17249108 N1410YMolohan Ronald M · Elk Grove, CABuilt 1961 · S/N 17249110 N1413YSooter Craig A · Sedgwick, KSBuilt 1961 · S/N 17249113 N1416YOrefice Anthony C · Clio, MIBuilt 1961 · S/N 17249116 N1423YStanger Eric R · Fernley, NVBuilt 1961 · S/N 17249123 N1426YIsmailyan Andre · Canoga Park, CABuilt 1961 · S/N 17249126 N1427YSpark 1 Aviation LLC · Wichita, KSFirst renewal noticeBuilt 1961 · S/N 17249127 N1429YSemmig Jeffrey C · Oceanside, CABuilt 1961 · S/N 17249129 N1430YSuess Matthew G · Rock City, ILBuilt 1961 · S/N 17249130 N1432YAll Sports Aviation LLC · Cocolalla, IDBuilt 1961 · S/N 17249132 N1434YSky Hawk Partners LLC · Lugoff, SCBuilt 1961 · S/N 17249134 N1435YZipprich Robert A · Jacksonville, ILBuilt 1962 · S/N 17249135 N1438YDr Luis S Navarro Pllc · Edinburg, TXS/N 17249138 N1439YGrace Aviation LLC · Fort Myers, FLBuilt 1962 · S/N 17249139 N143BBN62689 Inc · Middletown, DES/N 17249516 N1444YHiggins Derrick G · Arbyrd, MOBuilt 1962 · S/N 17249144 N1445YSwartz Steven L · Nashville, TNBuilt 1962 · S/N 17249145 N1446YWise Ron · Napoleon, OHBuilt 1962 · S/N 17249146 N1450YMalmkar Shannon T · Grant, NEBuilt 1962 · S/N 17249150 N1452YBuranen Mark · Wilmington, DEBuilt 1962 · S/N 17249152 N1453YNava Henry · Santa Ana, CABuilt 1962 · S/N 17249153 N1454YPendergrass Curt E · Saint Petersburg, FLBuilt 1962 · S/N 17249154 N1455YHelm Richard A · Buckeye, AZS/N 17249155 N1456YLeonardi William J · Jamesport, NYBuilt 1962 · S/N 17249156 N1458YTln Aviation LLC · Stanwood, WABuilt 1962 · S/N 17249158 N1459YBriere Mark E · Mims, FLBuilt 1962 · S/N 17249159 N1461YKarpov Vladimir · Raymond, NES/N 17249161 N1473YPetty James F · Crandall, GABuilt 1962 · S/N 17249173 N1475YAbe Lincoln Flyers Inc · Lincoln, ILBuilt 1962 · S/N 17249175 N1476YHamilton Gene A · Saegertown, PABuilt 1962 · S/N 17249176 N1478YCunningham Richard E · Lafayette, CABuilt 1962 · S/N 17249178 N1481YPoole Timothy W · Lyons, GABuilt 1962 · S/N 17249181 N1482YSamuelian Jenna A · Tehachapi, CABuilt 1962 · S/N 17249182 N1484YHarrison Dennis N · New London, MOS/N 17249184 N1486YPost Greg · Fort Scott, KSBuilt 1962 · S/N 17249186 N1491YBullard Thomas Eugene Trustee · Midlothian, TXBuilt 1962 · S/N 17249191 N1496YHoward Paul D · Gordon, TXS/N 17249196 N1497YHall Robert D · Prince-Frederick, MDBuilt 1962 · S/N 17249197 N1499YHockenberry Randall L · Cape Coral, FLBuilt 1962 · S/N 17249199 N1501YStreeter Christopher D · Vinita, OKBuilt 1962 · S/N 17249201 N1506YVaughn Jeffery Page · Shenandoah, VAS/N 17249206 N1510YEegle Corps Inc · Wilmington, DEBuilt 1962 · S/N 17249210 N1519YHarrison Michael R · Woodbine, MDBuilt 1962 · S/N 17249219 N1520YScott Thomas A Jr · Lawrenceburg, TNBuilt 1962 · S/N 17249220 N1522YKinard Phillip · Tuscaloosa, ALBuilt 1962 · S/N 17249222 N1523YRegional Air Inc · Lawton, OKS/N 17249223 N1527YEshman Daniel J Jr · Bryan, OHS/N 17249227 N1528YTexoma Aero Club · Denison, TXBuilt 1962 · S/N 17249228 N1529YBirge Darrell W · Linden, INS/N 17249229

Back to Cessna 172C