Skip to content

Registered aircraft · 722

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

N4204LMarquis Kim R · Poplar Bluff, MOBuilt 1966 · S/N 17254273 N4205LKay Bennie L · Brigham City, UTBuilt 1966 · S/N 17254274 N4207LGlaude Jason T · Scarborough, MEBuilt 1966 · S/N 17254276 N4208LHowell Jerry C · Deatsville, ALBuilt 1966 · S/N 17254277 N4213LBuenrostro Paul · Burney, CAS/N 17254282 N4216LN4216l LLC · Kapolei, HIBuilt 1966 · S/N 17254285 N4218LWengs Enterprises Inc · Tustin, CABuilt 1966 · S/N 17254287 N4220LDelordzia Mark · Columbia, NJBuilt 1966 · S/N 17254289 N4221LSchram Ted K · Mukwonago, WIBuilt 1966 · S/N 17254290 N4222LRtd Aviation LLC · Hillsborough, NJS/N 17254291 N4223LWolinski David T · Algonquin, ILBuilt 1966 · S/N 17254292 N4225L100straight LLC · San Angelo, TXBuilt 1966 · S/N 17254294 N4226LMcpherson Charles C III · Delhi, LABuilt 1966 · S/N 17254295 N4227LJohnson Wayne · Broken Arrow, OKBuilt 1966 · S/N 17254296 N4231LSeaplanes R Fun Inc · Moneta, VABuilt 1966 · S/N 17254300 N4233LTulsa Technology Center School District No 18 · Tulsa, OKBuilt 1966 · S/N 17254302 N4235LReiter Trevor D · Minot, NDBuilt 1966 · S/N 17254304 N4236LPierce Russell A · San Antonio, TXBuilt 1966 · S/N 17254305 N4241LAshland Flyers LLC · Bayfield, WIBuilt 1966 · S/N 17254310 N4242LHannon Douglas L · Yakima, WABuilt 1966 · S/N 17254311 N4243LNorth Central Marketing Inc · Cranston, RIBuilt 1966 · S/N 17254312 N4245LAero Missions Inc · Sylacauga, ALBuilt 1966 · S/N 17254314 N4249LKraus Gary L · Holbrook, PABuilt 1966 · S/N 17254318 N4250LKnight Aire LLC · Simpsonville, SCBuilt 1966 · S/N 17254319 N4252LStephani Timothy M · White Lake, WIBuilt 1966 · S/N 17254321 N4256LStewart Stephanie J · Lakeland, GABuilt 1966 · S/N 17254325 N4259LBrown Lawrence D · Memphis, TNBuilt 1966 · S/N 17254328 N4260LTrueman Jeffrey A · Clear, AKBuilt 1966 · S/N 17254329 N4261LCochrane Warren H Jr · Carabaset Vly, MEBuilt 1966 · S/N 17254330 N4263LCox Dennis J · Beach City, TXBuilt 1966 · S/N 17254332 N4264LMcguckin Michael C · Mesa, AZBuilt 1966 · S/N 17254333 N4265L1515 Aviation LLC · Burleson, TXBuilt 1966 · S/N 17254334 N4269LBussey Stuart · Lafayette, CABuilt 1966 · S/N 17254338 N4270LDavenport Sam · Gail, TXBuilt 1966 · S/N 17254339 N4271LRoberts David W · Arden, NCS/N 17254340 N4272LStechbart Kurt E · Glendora, CABuilt 1966 · S/N 17254341 N4275LBarney Jared L · Tully, NYBuilt 1966 · S/N 17254344 N4280LShellbourne Aviation LLC · Ormond Beach, FLBuilt 1966 · S/N 17254349 N4281LKiger Aviation LLC · Corvallis, ORBuilt 1966 · S/N 17254350 N4291LRappa Giovanni · Hampton, VABuilt 1966 · S/N 17254360 N4293LO'Hop Robert D · Jones, OKBuilt 1966 · S/N 17254362 N4295LBravo Aviation LLC · Rexburg, IDBuilt 1966 · S/N 17254364 N4296LBreidenbach Todd J · Sabin, MNBuilt 1966 · S/N 17254365 N4302LSenn Steve E · Burwell, NEBuilt 1966 · S/N 17254371 N4303LArtic'S Air Academy LLC · Palmer, AKBuilt 1966 · S/N 17254372 N4305LLavin Renaye K · Wasilla, AKS/N 17254374 N4306LGrandinetti Robert L · Fayetteville, NYS/N 17254375 N4308LKim Jingu · Mount Prospect, ILBuilt 1966 · S/N 17254377 N4309LWallace Leroy C · Wshngtn Ct Hs, OHBuilt 1966 · S/N 17254378 N4310LMckenzie Donovan G · East Northport, NYBuilt 1966 · S/N 17254379

Back to Cessna 172G