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.

N7712UGolding James M · Diamond Springs, CABuilt 1964 · S/N 17251712 N7713UDavisson Paul V · Jupiter, FLBuilt 1964 · S/N 17251713 N7714UKimbrell Quentin · Cape Girardeau, MOS/N 17251714 N7715UFenton Dale R · New Bern, NCBuilt 1964 · S/N 17251715 N7716UOpportune Entity LLC · Sanger, TXBuilt 1964 · S/N 17251716 N7717UGreen Castle Aero Club Ltd · Oxford, IABuilt 1964 · S/N 17251717 N7718URenninger Dustin L · Mc Veytown, PAS/N 17251718 N7722UBeebout Shawn C · Milroy, MNBuilt 1964 · S/N 17251722 N7723UAdams David C · Westford, MABuilt 1964 · S/N 17251723 N7725UCvz-Vivace LLC · Fort Worth, TXBuilt 1964 · S/N 17251725 N7727UWingtip Aviation LLC · Amarillo, TXBuilt 1964 · S/N 17251727 N7728UKropp Richard G · North Creek, NYBuilt 1964 · S/N 17251728 N7729UBlough Lynn M · Pittsburgh, PABuilt 1964 · S/N 17251729 N7731UMd Aviation Inc · Sioux Falls, SDBuilt 1964 · S/N 17251731 N7733UGutlon Richard S · Durham, NCBuilt 1964 · S/N 17251733 N7736UWatson Marshall · Sublette, KSS/N 17251736 N7737UMast Elroy T · Crawford, MSBuilt 1964 · S/N 17251737 N7738UGibson Nathaniel A · Cross Lanes, WVBuilt 1964 · S/N 17251738 N7744UArnold David L · Portland, ORBuilt 1964 · S/N 17251744 N7745UHodges Charles E · Grain Valley, MOBuilt 1964 · S/N 17251745 N7747UCoastal Zoom LLC · Davenport, FLBuilt 1964 · S/N 17251747 N7749UN833tx LLC · Little Rock, ARBuilt 1964 · S/N 17251749 N7750UCoke Hartwell F · Quinton, VABuilt 1964 · S/N 17251750 N7753UAmyx Hiram R · Liberty, TXBuilt 1964 · S/N 17251753 N7757UTruitt Seth L · Cynthiana, KYBuilt 1964 · S/N 17251757 N7759UButts Alex D · Douglassville, PABuilt 1964 · S/N 17251759 N7760UScott Timothy E · West Danville, VTBuilt 1964 · S/N 17251760 N7770UBrown Michael E · Miramar, FLBuilt 1964 · S/N 17251770 N7771BBeam Thomas W · Paw Paw, MIBuilt 1964 · S/N 17251607 N7771UPryor Isaac L · Charlotte, NCBuilt 1964 · S/N 17251771 N7772UKiger Aviation LLC · Corvallis, ORBuilt 1964 · S/N 17251772 N7773UWitsberger Kelly R · Newburg, MOBuilt 1964 · S/N 17251773 N7778UAngel Del Mar LLC · Park City, UTBuilt 1964 · S/N 17251778 N7781UKerslake Alex J · Ellensburg, WABuilt 1964 · S/N 17251781 N7783UEppich Glen M · Kingman, AZBuilt 1964 · S/N 17251783 N7785UTwo Farmers LLC · Dumas, ARS/N 17251785 N7786UWooton Donald Wayne · Houston, TXFirst renewal noticeBuilt 1964 · S/N 17251786 N7787USageser Scott · Carmi, ILS/N 17251787 N7788UHoffmeyer Scott D · Carson City, NVBuilt 1964 · S/N 17251788 N7789UViolette David A · Medway, MEBuilt 1964 · S/N 17251789 N7790UPlane Fun Inc Tr Trustee · Snellville, GABuilt 1964 · S/N 17251790 N7791UHall Richard C Jr · Benton, KYFirst renewal noticeBuilt 1964 · S/N 17251791 N7792UOso Air LLC · Missoula, MTS/N 17251792 N7798USmythe Carl D · Tulsa, OKBuilt 1964 · S/N 17251798 N7800URipplinger Max · Santa Clara, UTBuilt 1964 · S/N 17251800 N7803UBishop John D · Phoenix, AZBuilt 1964 · S/N 17251803 N7809UHigh Planes Aviation LLC · Waseca, MNFirst renewal noticeBuilt 1964 · S/N 17251809 N7810URasch Hellmut G · Tomball, TXS/N 17251810 N7812UPs Aviation Inc · Granada, MNS/N 17251812 N7820UMorris Aviation LLC · Spring Hill, TNBuilt 1964 · S/N 17251820

Back to Cessna 172E