Skip to content

Registered aircraft · 722

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

N3771LFlying Bs LLC · Midlothian, TXBuilt 1966 · S/N 17253940 N3774LKarr Stacy A · Hogansville, GABuilt 1965 · S/N 17253943 N3775LLee Michael Min · Dayton, OHBuilt 1965 · S/N 17253944 N3776LStramel Bert Jon · Colby, KSBuilt 1965 · S/N 17253945 N3780LCropper Ryan Devon · Anchorage, AKBuilt 1965 · S/N 17253949 N3781LCarmel Aviation Inc · Boise, IDBuilt 1965 · S/N 17253950 N3782LAbraham Curtis L · Byron, WYBuilt 1965 · S/N 17253951 N3785LReeves Laina M · Sammamish, WABuilt 1965 · S/N 17253954 N3786LClercqzubli Daniel De J · Antioch, TNBuilt 1966 · S/N 17253955 N3788LStrano Ralphael · Linden, NJBuilt 1965 · S/N 17253957 N3790LStandiford Keith P · Carmel, CABuilt 1965 · S/N 17253959 N3791LPowell County Flying Club Inc · Owingsville, KYBuilt 1965 · S/N 17253960 N3792LBreinlinger Eric · Charlton, MABuilt 1965 · S/N 17253961 N3793LWarner Gary Dean Trustee · Cotter, ARBuilt 1965 · S/N 17253962 N3794LSearcy Moto-Air Inc · Searcy, ARBuilt 1965 · S/N 17253963 N3795LCisneros Adrian · Riverside, CAS/N 17253964 N37LFWalter Cheri L · Hampshire, ILBuilt 1966 · S/N 17254460 N3801LSouth Mark B · Eastanollee, GAS/N 17253970 N3802LHill Herman J · Corvallis, MTBuilt 1965 · S/N 17253971 N3803LHanna R Brian · Tallahassee, FLBuilt 1965 · S/N 17253972 N3804LAeroelite Solutions LLC · Kalispell, MTBuilt 1965 · S/N 17253973 N3805LVelasquez Veronica R · San Antonio, TXBuilt 1965 · S/N 17253974 N3808LGreensburg Jeanette Airport Administration · Jeannette, PAS/N 17253977 N3809LSale Reported · Oak Harbor, WASale reportedS/N 17253978 N380LAPounders Brent · Prosper, TXS/N 17253570 N3812LAune Todd A · Harlingen, TXBuilt 1966 · S/N 17253981 N3813LBuyak David W · New Hartford, CTBuilt 1965 · S/N 17253982 N3815LCordova Tomy · Hastings, MIBuilt 1965 · S/N 17253984 N3819LRay Aviation LLC · Burkett, TXBuilt 1965 · S/N 17253988 N3821LSky Bryce Flying Club LLC · Basye, VABuilt 1965 · S/N 17253990 N3824LNewhart Manfred A · Boulder, COBuilt 1965 · S/N 17253993 N3829LMustang Aviation LLC · Waterville, MEBuilt 1965 · S/N 17253998 N3832LArnold Jonah Jr · Milledgeville, GABuilt 1966 · S/N 17254001 N3834LZoltak Aviation LLC · Perry, GABuilt 1965 · S/N 17254003 N3837LMountain Town Flying LLC · Hammondsport, NYBuilt 1965 · S/N 17254006 N3838LBerry Charles J · Shreveport, LABuilt 1965 · S/N 17254007 N3840LMikha Marvin · Nampa, IDS/N 17254009 N3841LFisher John J · Middlefield, OHBuilt 1965 · S/N 17254010 N3842LKraupie Del Ray · Bridgeport, NES/N 17254011 N3846LElicker Sheldon L · Auburn, CABuilt 1966 · S/N 17254015 N3848LHarrod Group Inc · Ellaville, GABuilt 1966 · S/N 17254017 N3852LMountain Wings LLC · Salem, WVBuilt 1965 · S/N 17254021 N3856LSimmons Brandon M · Sylacauga, ALS/N 17254025 N3859LBourke Michael T · Adams, WIBuilt 1965 · S/N 17254028 N3860LLake Area Technical College · Watertown, SDBuilt 1965 · S/N 17254029 N3861LSeverson Marshall G · Anchorage, AKBuilt 1966 · S/N 17254030 N3862LSainsbury James L · Milton, WIBuilt 1965 · S/N 17254031 N3865LRibeiro Marcos Felix · Okeechobee, FLS/N 17254034 N3866LLamb Daniel A · Cheyenne, WYBuilt 1966 · S/N 17254035 N3867LDorsey Levi Rondall · Demorest, GABuilt 1965 · S/N 17254036

Back to Cessna 172G