Skip to content

Registered aircraft · 1,025

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

N84097Argoudelis Michael · Kalamazoo, MIS/N 17258331 N84104Morris Daniel B · Ankeny, IABuilt 1969 · S/N 17258334 N84105Jost Jared D · Hillsboro, KSS/N 17258335 N84108Bramblett John S · Russellville, ARBuilt 1969 · S/N 17258337 N84114Miami Seaplane Tours Inc · Miami, FLBuilt 1969 · S/N 17258339 N84117Mendez Arturo · Addison, ILBuilt 1969 · S/N 17258340 N84122Millican Marc J · Anchorage, AKBuilt 1969 · S/N 17258342 N84125Koenig Aircraft Restoration Inc · Loranger, LABuilt 1969 · S/N 17258343 N84129Petschow Kenneth W · Upland, CABuilt 1969 · S/N 17258344 N84130Gutierrez Sergio E · Pharr, TXBuilt 1969 · S/N 17258345 N84133Registration Pending · Bowman, NDRegistration pendingS/N 17258347 N84140Kaiser Joe E · Anchorage, AKBuilt 1969 · S/N 17258351 N84141Registration Pending · Mansfield, OHRegistration pendingBuilt 1969 · S/N 17258352 N84143Jones Donald T · Barrigada, GUS/N 17258353 N84146Stone Air LLC · Carrollton, GABuilt 1969 · S/N 17258354 N84147Cox James O II · Shady Shores, TXBuilt 1969 · S/N 17258355 N84151Sanders George W · Cloverdale, INBuilt 1969 · S/N 17258358 N84153Spirit Air Inc · Salmon, IDBuilt 1969 · S/N 17258360 N84162Crosswind Aviation Of Oklahoma LLC · Stillwater, OKBuilt 1969 · S/N 17258362 N84169Roach Gene T · Frankfort, KYS/N 17258363 N84170Follmer Todd F · Dunwoody, GABuilt 1969 · S/N 17258364 N84183Chickadee Aviation LLC · Burr Ridge, ILBuilt 1969 · S/N 17258368 N84185Harrison Gene R · Pendleton, ORS/N 17258348 N84186Gould George Jr · Bryantville, MABuilt 1969 · S/N 17258369 N84190Frs & Craig Llp · Byron, GABuilt 1969 · S/N 17258371 N84193Smirnov Alexei · Fair Lawn, NJBuilt 1969 · S/N 17258372 N84194Ultra Aviation LLC · Cedar Bluff, VABuilt 1969 · S/N 17258373 N84195Norcal Flight Center LLC · Lincoln, CABuilt 1969 · S/N 17258374 N84210Pm Jets LLC · Ashland, OHBuilt 1969 · S/N 17258380 N84214Planefully Obvious LLC · Oshkosh, WIBuilt 1969 · S/N 17258382 N84221Mcknight Michael D · Marietta, GABuilt 1969 · S/N 17258384 N84224Cordes Jeffrey A · Happy Valley, ORBuilt 1969 · S/N 17258386 N84225Executive Flight Institute LLC · Murrieta, CABuilt 1969 · S/N 17258387 N84226Jackson County Aviation LLC · Sneads, FLBuilt 1969 · S/N 17258388 N84229Langenbahn Theodore John · Schoharie, NYBuilt 1969 · S/N 17258389 N84234Mazelg Aviation LLC · Bartow, FLBuilt 1969 · S/N 17258390 N84243Sjoberg Donald E · Poteau, OKBuilt 1969 · S/N 17258393 N84250Wick James R · Canon City, COBuilt 1969 · S/N 17258395 N84256Registered aircraftBuilt 1969 · S/N 17258396 N84265West Gerald Lee · Two Harbors, MNBuilt 1969 · S/N 17258399 N84267Shields Debra M · York, SCBuilt 1969 · S/N 17258400 N84271Anderson Operations LLC · Fallon, NVBuilt 1969 · S/N 17258402 N84275Rodriguez Norberto R · Inwood, NYBuilt 1969 · S/N 17258404 N84278Ap Air LLC · Wilmington, NCBuilt 1969 · S/N 17258405 N84289Angelov Ruslan P · Mount Prospect, ILS/N 17258410 N84293Nwa Flyers LLC · Missoula, MTBuilt 1969 · S/N 17258411 N84299Phoenix Aviation Holdings LLC · Crystal Beach, FLS/N 17258413 N842RBLowcountry Flight LLC · Johns Island, SCBuilt 1969 · S/N 17258377 N84309Mcgee David · West Monroe, LABuilt 1969 · S/N 17258417 N84316Smith Jimmy C · Plano, TXBuilt 1969 · S/N 17258419

Back to Cessna 172K