Skip to content

Registered aircraft · 617

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

N5489TDunn Scott · Warren, OHBuilt 1964 · S/N 17251389 N5491TAlpha Mike LLC · Stoughton, MABuilt 1964 · S/N 17251391 N5492TCollins Terry D · Maynardville, TNBuilt 1964 · S/N 17251392 N5498TSale Reported · Lewes, DESale reportedS/N 17251398 N5500TOhair Ronald L · Pasco, WABuilt 1964 · S/N 17251400 N5502TMartin William G · Mc Clellandtown, PABuilt 1964 · S/N 17251402 N5503TAivia Aviation LLC · Estes Park, COBuilt 1964 · S/N 17251403 N5504TLam Pak To · El Monte, CABuilt 1964 · S/N 17251404 N5505XDuff Trent H · Warrenton, MOBuilt 1964 · S/N 17251188 N5506TMorgan Ronnie · Keller, TXBuilt 1964 · S/N 17251406 N5507TBlue Feathers Corp · Newark, DEBuilt 1964 · S/N 17251407 N5508TCashmere Origins LLC · Denham Springs, LABuilt 1964 · S/N 17251408 N5509THampsch Jeremy D · Hauser, IDBuilt 1964 · S/N 17251409 N5510TStover Aviation LLC · New Braunfels, TXBuilt 1964 · S/N 17251410 N5511TFreedom Aviation LLC · Mascoutah, ILBuilt 1964 · S/N 17251411 N5512TSmith Miles Kent · Las Vegas, NVBuilt 1964 · S/N 17251412 N5513TMast Jonathan W · Delta, COBuilt 1964 · S/N 17251413 N5515TCahill John Joseph Jr · Sebring, FLBuilt 1964 · S/N 17251415 N5516TBasley Reed M · Lanexa, VABuilt 1964 · S/N 17251416 N5519THatcher John · Rathdrum, IDS/N 17251419 N5520TChayo Elinor · New York, NYBuilt 1964 · S/N 17251420 N5525TDavis Ronnie L · Okmulgee, OKBuilt 1964 · S/N 17251425 N5529TCornell James R · Winston Salem, NCBuilt 1964 · S/N 17251429 N5531TLegault Marcus · Frazier Park, CABuilt 1964 · S/N 17251431 N5533TChapman Alan T · Cottage Grove, MNBuilt 1964 · S/N 17251433 N5538T172 Fayette Inc · La Grange, TXBuilt 1964 · S/N 17251438 N5541TYoungstown Flight School Inc · Youngstown, OHBuilt 1964 · S/N 17251441 N5546TMeigs Craig · Jasper, ALS/N 17251446 N5547TGoodyear Ron L · Leo, INBuilt 1964 · S/N 17251447 N5550TCirrus Five LLC · Merritt, NCBuilt 1964 · S/N 17251450 N5551TBailey Robert S · Temecula, CAS/N 17251451 N5553TVan Kleek Steve D · Milford, IABuilt 1964 · S/N 17251453 N5554TBmtc Aircraft LLC · Salem, ORS/N 17251454 N5557TCefalu Thomas R · Louisville, MSBuilt 1964 · S/N 17251457 N5558THills Holding · Newark, DEBuilt 1964 · S/N 17251458 N5559TVance Douglas E · Cleveland, GAS/N 17251459 N555GWHart Stephen M · Southampton, NJBuilt 1964 · S/N 17251353 N5560TThomas Brian D · Corning, IABuilt 1964 · S/N 17251460 N5561THinson Jonathon E · Yarmouth, MEBuilt 1964 · S/N 17251461 N5562TBolles Jared R · Helena, MTS/N 17251462 N5563TPridgeon Rodger · Vero Beach, FLBuilt 1964 · S/N 17251463 N5564THammer Michael · Redwood Falls, MNBuilt 1964 · S/N 17251464 N5571TRegistered aircraftBuilt 1964 · S/N 17251471 N5572TAburto Lorenzo · Soldotna, AKBuilt 1964 · S/N 17251472 N5575TRobins Tommy Jared · Bakersfield, CABuilt 1964 · S/N 17251475 N5580TRedden Joe A · Dawson Springs, KYBuilt 1964 · S/N 17251480 N5583TJanke Sean · Gallup, NMBuilt 1964 · S/N 17251483 N5584TJellison Michael R · Marysville, WAS/N 17251484 N5586TBravo Aviation Services LLC · Jasper, TXBuilt 1964 · S/N 17251486 N5587TAnderson Clint V · Clinton, MTBuilt 1964 · S/N 17251487

Back to Cessna 172E