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.

N2265YHemann Dale F · Osage, IABuilt 1967 · S/N 17700065 N2267YCole Gary L · Richmond, TXBuilt 1967 · S/N 17700067 N2272YWilson Matthew C · Robinson, ILBuilt 1967 · S/N 17700072 N2284YBorn Daniel P · Lawrence, KSBuilt 1967 · S/N 17700084 N2285YKrid Cardinal LLC · Centerville, INBuilt 1967 · S/N 17700085 N2290YHerren Roger L · Clayton, ILBuilt 1967 · S/N 17700090 N2291YWyatt Gary D · Sun City West, AZBuilt 1967 · S/N 17700091 N2292YJess Lawrence A · Menomonie, WIBuilt 1967 · S/N 17700092 N2294YHeathfield William T · Plymouth, MIS/N 17700094 N2295YHutto Azel James III · Lexington, SCBuilt 1967 · S/N 17700095 N2297YKomulainen Daryl B · Clarksville, TNBuilt 1967 · S/N 17700097 N22SDGordon Scott K Trustee · Tucson, AZBuilt 1968 · S/N 17700892 N2305YOtt Nicholas D · Mobile, ALBuilt 1967 · S/N 17700105 N2306YEagle Sky Patrol Inc · Deadwood, SDS/N 17700106 N2308YAltman Richard A · Albuquerque, NMBuilt 1967 · S/N 17700108 N2316YWhitacre James P · Martinsburg, WVBuilt 1967 · S/N 17700116 N2328YRogue Air LLC · Miller, SDBuilt 1967 · S/N 17700128 N2332YAlbi Aero LLC · Denver, COBuilt 1967 · S/N 17700132 N2333YSkillman Flying Services LLC · Brookshire, TXS/N 17700133 N2339YGross Barbara J · Timber Lake, SDS/N 17700139 N2345YJackson Shaun K · Tyler, TXBuilt 1967 · S/N 17700145 N2347YProctor Keith E · Paint Lick, KYBuilt 1968 · S/N 17700147 N234PEDunn Linwood B · Franklin, TNBuilt 1968 · S/N 17701078 N2351YToes In The Sand LLC · Bentonville, ARBuilt 1967 · S/N 17700151 N2355YSchwarz Enterprises LLC · Huntington Beach, CABuilt 1967 · S/N 17700155 N2359YWadsworth Edwin Allen · Sarasota, FLBuilt 1967 · S/N 17700159 N2363YPlane Pro Aviation LLC · Shelby, NCBuilt 1967 · S/N 17700163 N2369YMischel John Patrick · Salyersville, KYBuilt 1967 · S/N 17700169 N2379YThelwell Llansley · Frisco, TXBuilt 1967 · S/N 17700179 N2384YArea-I Flying Club LLC · Atlanta, GAS/N 17700184 N2388YMay James E · Nashville, GABuilt 1967 · S/N 17700188 N2391YOleksyn Anthony · Fairport, NYBuilt 1967 · S/N 17700191 N2395YRice Dwight D · Loma Linda, CABuilt 1967 · S/N 17700195 N2396YAulbur Carl A · Martinsburg, MOBuilt 1967 · S/N 17700196 N2399YCarlson Carl E · Geneva, NYBuilt 1967 · S/N 17700199 N254KMFowler Michael J · Golden Valley, MNBuilt 1968 · S/N 17701076 N26TPGlobal Aerials Inc · Pembroke Pines, FLBuilt 1967 · S/N 17700144 N27JWGaither William W · Shallotte, NCS/N 17701148 N2801XJones Daniel L · Newton, ALBuilt 1967 · S/N 17700201 N2803XStamper Douglas H · Norfolk, VABuilt 1967 · S/N 17700203 N2809XGuckian Jim J · Riverdale, GABuilt 1967 · S/N 17700209 N280JGEdwards Jonathan S · Marysvale, UTBuilt 1968 · S/N 17700498 N2812XHarris Rodger C · Titusville, FLBuilt 1967 · S/N 17700212 N2816XCoats Christopher · Vinita, OKBuilt 1967 · S/N 17700216 N2819XPope Steven R · Gilbert, AZBuilt 1967 · S/N 17700219 N2820XJones Michael S · Fremont, WIS/N 17700220 N2822XPender Michael J · Marsing, IDBuilt 1967 · S/N 17700222 N2823XSpectron Aviation Inc · West Boylston, MAS/N 17700223 N2828XEagle Sky Patrol Inc · Deadwood, SDBuilt 1967 · S/N 17700228 N2829XHannam Michael J · Runnells, IABuilt 1967 · S/N 17700229

Back to Cessna 177