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.

N3157THollrah Kenneth R · Enid, OKBuilt 1967 · S/N 17700457 N3159TLown Alfred L · Elkhorn, NEBuilt 1967 · S/N 17700459 N3164TOverflight LLC · Harahan, LABuilt 1967 · S/N 17700464 N3169TOwen James D · Fort Lauderdale, FLBuilt 1967 · S/N 17700469 N3171TVanlandingham Michael E · Oxnard, CABuilt 1967 · S/N 17700471 N3177Duvall John M III · Cincinnati, OHBuilt 1967 · S/N 17700660 N3177TCain James W · Big Rapids, MIBuilt 1967 · S/N 17700477 N3178TAdvantage Aviation Services LLC · South Saint Paul, MNS/N 17700478 N3181TDuck Donald S · Edwardsburg, MIBuilt 1967 · S/N 17700481 N3188TRucinski Edward A · Climax, NCS/N 17700488 N3192THawley James W · Waddell, AZBuilt 1967 · S/N 17700492 N3196TNicholson Perry R · Merlin, ORBuilt 1968 · S/N 17700496 N3197TMundle Jeffrey A · Ashland, ORBuilt 1967 · S/N 17700497 N3199TMortgage Experts LLC · Homestead, FLBuilt 1967 · S/N 17700499 N3212TRichmond Timothy R · Deland, FLBuilt 1967 · S/N 17700512 N3214TJohnson Hugh S · Rochester, NYBuilt 1967 · S/N 17700514 N3215TMcgee Debra L · Tuscola, TXBuilt 1967 · S/N 17700515 N3216TWss Aviation Inc · Jerseyville, ILBuilt 1967 · S/N 17700516 N3218TShepherd Darren · Shepherdsville, KYBuilt 1967 · S/N 17700518 N3230TLsao LLC · Shelbyville, ILBuilt 1967 · S/N 17700530 N3231TGouse Frederick Earl II · Waxahachie, TXBuilt 1967 · S/N 17700531 N3240TFrena John A · Pittsburgh, PABuilt 1967 · S/N 17700540 N3241TMaggart Daniel J · Winchester, ILBuilt 1967 · S/N 17700541 N3242TSt Clair Ronnie M · Cochise, AZBuilt 1967 · S/N 17700542 N3244TCaicedo Oscar E · Garner, NCS/N 17700544 N3246TFears Edwin G III · Trafalgar, INBuilt 1967 · S/N 17700546 N3247TBeeda Mark A · West Palm Beach, FLBuilt 1967 · S/N 17700547 N3252TFugfugosh Mahdi A · Castro Valley, CABuilt 1967 · S/N 17700552 N3256TWoodfill Kyle · Lake Jackson, TXBuilt 1967 · S/N 17700556 N3264TVan Iderstyne Richard D · Jekyll Island, GABuilt 1967 · S/N 17700564 N3268KRegistered aircraftBuilt 1968 · S/N 17700519 N3268TKawsara Sabah M · Fort Worth, TXBuilt 1967 · S/N 17700568 N3272TSonoras John G Jr · Newport, MIBuilt 1967 · S/N 17700572 N3273TSommers Bradley D · Robinson, KSBuilt 1967 · S/N 17700573 N3274TRinkle Michael G · Sussex, NJBuilt 1967 · S/N 17700574 N3282TCavu Aircraft Sales & Management Inc · Olyphant, PABuilt 1967 · S/N 17700582 N3292TCelestial Kinetics Flight Academy LLC · Waupaca, WIBuilt 1967 · S/N 17700592 N3294TWolniansky Peter W · Ocean Grove, NJS/N 17700594 N3297TBurgdorf Dale A · Plano, TXBuilt 1967 · S/N 17700597 N3298T515 Aviation LLC · Dexter, IABuilt 1967 · S/N 17700598 N3299TSale Reported · Daytona Beach, FLSale reported, canceledBuilt 1967 · S/N 17700599 N3310TFly448 LLC · Wausau, WIBuilt 1968 · S/N 17700045 N3311TSchulze Tom L · Smithville, MOBuilt 1967 · S/N 17700611 N3315TLovelady William K · Grapevine, TXBuilt 1967 · S/N 17700615 N3317TGay Don A DBA · Garfield, GABuilt 1967 · S/N 17700617 N3318TPipeair LLC · Vancouver, WABuilt 1967 · S/N 17700618 N3321TWilks Donald Leon · Flat Rock, ALBuilt 1967 · S/N 17700621 N3323TDeese James K Jr · Charlotte, NCS/N 17700623 N3326TGallman Doug M · Port Orange, FLBuilt 1967 · S/N 17700626 N3327TFriedl Robert Stephen Jr · Mammoth Lakes, CAS/N 17700627

Back to Cessna 177