Skip to content

Registered aircraft · 446

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

N3332TWilliams Darryl L · Medina, OHS/N 17700632 N3334TBaumann Keith A · Fairfield, ILBuilt 1967 · S/N 17700634 N3339FRegistered aircraftN-number assigned, not yet registeredS/N 17700600 N3339TBritt And Ashley Kieffer Farms · Weiner, ARS/N 17700639 N3341TWatson Dennis R · Fort Worth, TXBuilt 1967 · S/N 17700641 N3343TMcclellan Dabney B · Centerburg, OHBuilt 1967 · S/N 17700643 N3345TJefts Donald R · Scotia, NYBuilt 1967 · S/N 17700645 N3351TTaylor Gail L · Red Bluff, CAS/N 17700651 N3353TDwinell Jeffrey C · Granby, MABuilt 1967 · S/N 17700653 N3356TCarlin Joseph A Jr · Rapid City, SDS/N 17700656 N3357THigh West Aero LLC · Broadus, MTBuilt 1967 · S/N 17700657 N3359TDuquette Robert R · Elfrida, AZS/N 17700659 N3361TPew Aaron · Mesa, AZS/N 17700661 N3362TMain Cynthia M · Richmond, TXFirst renewal noticeBuilt 1967 · S/N 17700662 N3364THigh Mesa Aviation LLC · Naturita, COBuilt 1967 · S/N 17700664 N3368TTuley Richard L · Marietta, GARegistration revokedBuilt 1967 · S/N 17700668 N3369TBauer Charles · Graceville, MNS/N 17700669 N3371TSale Reported · Sanderson, TXSale reported, pending cancellationBuilt 1967 · S/N 17700671 N3374TLazy Eight LLC · Kalispell, MTS/N 17700674 N3383TBerkstresser John A · Ellijay, GABuilt 1967 · S/N 17700683 N3387TWarner Stephen DBA · Pleasantville, PABuilt 1967 · S/N 17700687 N3388TKing Eric J · Zillah, WABuilt 1967 · S/N 17700688 N3390TTucker Lon R · East Peoria, ILBuilt 1967 · S/N 17700690 N3391TCardinal Wings LLC · Middletown, DEBuilt 1968 · S/N 17700691 N3393TWilcox Russell J · Salinas, CABuilt 1967 · S/N 17700693 N3394TPekrul Eric C · Frankfort, MIBuilt 1968 · S/N 17700694 N3397TMckinney Adrian R · Mineral Wells, TXBuilt 1967 · S/N 17700697 N3404THaik Kevin Jerome · Ozark, MOS/N 17700704 N3405FGo Up High LLC · Grafton, WIBuilt 1967 · S/N 17700602 N3408TSpectron Aviation Inc · West Boylston, MAS/N 17700708 N3410TPeterson Barry · Sausalito, CABuilt 1967 · S/N 17700710 N3411TSouthern Aero LLC · Theodore, ALBuilt 1967 · S/N 17700711 N3412TC177knotclub LLC · Springfield, ILBuilt 1967 · S/N 17700712 N3414TKkk Services Inc · Saint Charles, MOBuilt 1967 · S/N 17700714 N3422TMangon Ronald A · Petaluma, CABuilt 1967 · S/N 17700722 N3423TCardinal Aviation LLC · Springdale, ARBuilt 1967 · S/N 17700723 N3424TWiggains David · Canyon, TXBuilt 1968 · S/N 17700724 N3427TRodgers Julia D · Orem, UTS/N 17700727 N3428TBroken Arrow Crop Insurance Inc · Perryton, TXFirst renewal noticeBuilt 1968 · S/N 17700728 N342JBCentral Ohio Flyers Association · Columbus, OHBuilt 1968 · S/N 17701033 N3430TMeador Phillips H · Lexington, KYBuilt 1968 · S/N 17700730 N3436FChinik James G · Jacksonville Beach, FLBuilt 1967 · S/N 17700604 N3437TRoberts John M · Mansfield, MOBuilt 1968 · S/N 17700737 N3444THunter David Frederick · Peachtree City, GABuilt 1968 · S/N 17700744 N3445TNelson Stephen A · Milaca, MNBuilt 1968 · S/N 17700745 N3446TR & B Air LLC · Clayton, MOBuilt 1968 · S/N 17700746 N3447TLocander Paul · Olney, MDBuilt 1968 · S/N 17700747 N3449THedrick Bill E · Kilgore, TXBuilt 1968 · S/N 17700749 N3451TMichael W Maciol Md · Pelham, NYBuilt 1968 · S/N 17700751 N3452TKordus Robert A · Union Grove, WIS/N 17700752

Back to Cessna 177