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.

N3674SWiegand Gary E · Carmel Valley, CABuilt 1963 · S/N 17250874 N3678RCarl Aviation LLC · Lake Havasu City, AZBuilt 1964 · S/N 17251566 N3678SMartone Douglas K · Windham, CTBuilt 1963 · S/N 17250878 N3680SLubonovic Thomas M · New Carlisle, OHBuilt 1963 · S/N 17250880 N3682SPederstuen Ricky L · Hudson, WIBuilt 1963 · S/N 17250882 N3685SGarrison Randy L · Queen City, TXBuilt 1963 · S/N 17250885 N3686SBurg David J · Oroville, CABuilt 1963 · S/N 17250886 N3691SBogan Jeremy · Rusk, TXS/N 17250891 N3692SBrown Wesley B · Sparks, NVBuilt 1963 · S/N 17250892 N3693SChianese Anthony · Wylie, TXBuilt 1963 · S/N 17250893 N3694SJstream Lc · Sheridan, WYBuilt 1963 · S/N 17250894 N3695SZavada Michael S · Morris, MNBuilt 1963 · S/N 17250895 N3697SRossi Michael · Big Pine, CABuilt 1963 · S/N 17250897 N3700SMusket Air LLC · Page, AZBuilt 1963 · S/N 17250900 N3702SWhite Edward H · Waco, KYS/N 17250902 N3703SDavis William F · Oak City, NCBuilt 1963 · S/N 17250903 N3705SGra Flying Club LLC · Bay City, MIBuilt 1963 · S/N 17250905 N3708SPalmer Christopher · Soddy Daisy, TNS/N 17250908 N3715SBruton Alexander C · Swansboro, NCBuilt 1963 · S/N 17250915 N3720SWaddell Stephen Tyler · Summerville, SCBuilt 1963 · S/N 17250920 N3725SBraeuer Gregory · North Pole, AKBuilt 1963 · S/N 17250925 N3726SStratos Holdings LLC · Moses Lake, WABuilt 1963 · S/N 17250926 N3727SHolloway Dwight W · Ward, ARBuilt 1963 · S/N 17250927 N3731SHerzfeld-Van Dyke Holly A · Conway, ARBuilt 1963 · S/N 17250931 N3732SMccague Kelly M · Las Cruces, NMBuilt 1963 · S/N 17250932 N3733SBrn Technical Inc · Boca Raton, FLBuilt 1963 · S/N 17250933 N3735SBeucler Brian G · Sandown, NHFirst renewal noticeBuilt 1963 · S/N 17250935 N3740SGarnsey Zene P · Schuylerville, NYBuilt 1963 · S/N 17250940 N3742SHand Jerry A · Nacogdoches, TXBuilt 1963 · S/N 17250942 N3745SKondel Eugene F · Owosso, MIBuilt 1963 · S/N 17250945 N3747SToland Wesley H · Warrenton, ORBuilt 1963 · S/N 17250947 N3748SGeminiair Inc · Davis, CABuilt 1963 · S/N 17250948 N3752SHutchins Mary Ellen · Front Royal, VABuilt 1963 · S/N 17250952 N3757SWiller Sebastian · Calhoun, GABuilt 1963 · S/N 17250957 N3758SMorris Philip N · Edgewood, NMBuilt 1963 · S/N 17250958 N3759SBudd Stephen C · Lake City, FLBuilt 1963 · S/N 17250959 N3760SPorter Charles T III · Seymour, TXBuilt 1963 · S/N 17250960 N3761SBucks Flight Academy LLC · Cashion, OKBuilt 1963 · S/N 17250961 N3763SGriffn Jared · Sheridan, ARBuilt 1963 · S/N 17250963 N3764SKarashchuk Yaroslav P · Georgetown, KYS/N 17250964 N3767SDickehut Donna · Cloverdale, INBuilt 1963 · S/N 17250967 N3772SThree Strands LLC · Colorado Springs, COBuilt 1963 · S/N 17250972 N3773SFielden Donald J · Bartow, FLBuilt 1963 · S/N 17250973 N3779SShawver Aviation LLC · Knoxville, IABuilt 1963 · S/N 17250979 N3782SBarnd Dennis Allen · Manchester, OHBuilt 1963 · S/N 17250982 N3783SBradley Electrical Plumbing & Heating LLC · Carson City, NVBuilt 1963 · S/N 17250983 N3788SMampel Gregory · New Port Richey, FLBuilt 1963 · S/N 17250988 N3789SSchilz Michael T · Townsend, WIFirst renewal noticeS/N 17250989 N378AAUnderwood Bruce D · Woodruff, WIBuilt 1963 · S/N 17250969 N3792SOld Blue Aviation Inc · Mayodan, NCS/N 17250992

Back to Cessna 172E