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.

N3793SWilt Richard A · Piseco, NYBuilt 1963 · S/N 17250993 N3795SMil2atp Inc · Pikeville, NCBuilt 1964 · S/N 17250995 N3796SSale Reported · Munford, TNSale reportedBuilt 1963 · S/N 17250996 N3798ST4 Enterprises LLC · Kalispell, MTFirst renewal noticeS/N 17250998 N3800SThompson Troy L · Limon, COBuilt 1963 · S/N 17251000 N3803SReid Aviation LLC · Boise, IDBuilt 1963 · S/N 17251003 N3804SSilvers Morris · Burnsville, NCS/N 17251004 N3805SWenk Mark J · Lakewood, PABuilt 1963 · S/N 17251005 N3809SPhillippi Victor L · Broadus, MTBuilt 1963 · S/N 17251009 N3810SGrant Sidney Tucker · La Porte, TXBuilt 1963 · S/N 17251010 N3811SFuist Richard A · Lake City, FLBuilt 1963 · S/N 17251011 N3813SHughes Todd R · Rocky Ford, COS/N 17251013 N3814SRegistered aircraftBuilt 1963 · S/N 17251014 N3815SRickard Hudson · Cleveland, OHBuilt 1963 · S/N 51015 N3817SLake Kris E · Wasilla, AKBuilt 1963 · S/N 17251017 N3820SSchrader Jerome · Rocklin, CABuilt 1964 · S/N 17251020 N3823SBurbank David E · Oak Harbor, WABuilt 1963 · S/N 17251023 N3824SPhelps Aero Co LLC · Salem, ORBuilt 1963 · S/N 17251024 N3826SLamal Thomas K · Fairbanks, AKBuilt 1963 · S/N 17251026 N3829SHagler Bennett J · San Carlos, CABuilt 1963 · S/N 17251029 N3830SWin Win Aviation Inc · Wake Forest, NCBuilt 1963 · S/N 17251030 N3833SBoehm Shannon Lynn · Mandan, NDBuilt 1963 · S/N 17251033 N3835SMorgan Leon O · Eagle River, AKS/N 17251035 N3836SDavis Michael W · Medicine Lodge, KSBuilt 1963 · S/N 17251036 N3842SKrahn Nicholas D · Oak Creek, WIBuilt 1963 · S/N 17251042 N3850SFoss Sterling D · Basin, WYBuilt 1963 · S/N 17251050 N3856SSobie David M · Nome, AKS/N 17251056 N3858SDearman Daniel R Sr · Cottonwood, CABuilt 1963 · S/N 17251058 N3859SFlorance Robert L · Fort Worth, TXBuilt 1963 · S/N 17251059 N3863SRegistration Pending · Walker, MNRegistration pending, pending cancellationBuilt 1963 · S/N 17251063 N3865SIndy Air Sales LLC · Anderson, INBuilt 1963 · S/N 17251065 N3866SKnutson Steven O · Wickenburg, AZBuilt 1963 · S/N 17251066 N3867SMakee Markus J · Painesville, OHBuilt 1964 · S/N 17251067 N3870SCherryhill Aviation Inc · Freetown, INBuilt 1963 · S/N 17251070 N3872SNeu Aviation LLC · Benton, LABuilt 1963 · S/N 17251072 N3875SFlying M Enterprises · Loomis, NEBuilt 1963 · S/N 17251075 N3876SMustoe William J Jr · Summersville, WVBuilt 1963 · S/N 17251076 N3878SSkyhawk172 LLC · Gainesville, TXBuilt 1963 · S/N 17251078 N3881SWynja Loreen Dee · Riverside, CABuilt 1963 · S/N 17251081 N3882SNichols Troy · Clinton, ARBuilt 1963 · S/N 17251082 N3883SBruns Scott A · Brodhead, WIBuilt 1964 · S/N 17251083 N3884SHawley Michael C · Hampton, NHBuilt 1963 · S/N 17251084 N3885SLewis Kyle P · Shelbyville, KYBuilt 1964 · S/N 17251085 N3892SState Technical College Of Missouri · Linn, MOS/N 17251092 N3895SPrins Kylee S · Eden, SDBuilt 1963 · S/N 17251095 N3896SFishsaildiveeat LLC · North Miami Beach, FLBuilt 1963 · S/N 17251096 N3897SMartin Neil T · Peoria Heights, ILBuilt 1964 · S/N 17251097 N3898SHangar 20 Flying Club LLC · Climax, MIS/N 17251098 N3900SCrowe Tim · Winchester, KYBuilt 1964 · S/N 17251100 N3901SEggett Glade · Brigham City, UTBuilt 1963 · S/N 17251101

Back to Cessna 172E