Skip to content

Registered aircraft · 843

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

N34099Nehrbass Daniel · Santa Ana, CABuilt 1971 · S/N 17701639 N34101Aldrich Andrew J · Soulsbyville, CABuilt 1971 · S/N 17701641 N34102Jaquez Marlene D · Baton Rouge, LABuilt 1971 · S/N 17701642 N34104Mcgowan Glenn R · Poplar Grove, ILBuilt 1971 · S/N 17701644 N34106Bellmann Carl W · Bryan, OHBuilt 1971 · S/N 17701646 N34108Pierce Andrew · Littleton, NCBuilt 1971 · S/N 17701647 N34121Downey Colin T · Jupiter, FLBuilt 1971 · S/N 17701650 N34122Cardinal Flying Club LLC · Saint Helens, ORBuilt 1971 · S/N 17701651 N34125Quinones Horacio Adan Gil · Palmdale, CABuilt 1971 · S/N 17701652 N34129Shook Mitchell M · Vidalia, GABuilt 1971 · S/N 17701653 N34133Geneva Lakes Flying LLC · Bristol, WIBuilt 1971 · S/N 17701654 N34138Wheat Michael D · Wichita Falls, TXBuilt 1971 · S/N 17701656 N34139Registered aircraftBuilt 1971 · S/N 17701657 N34146Aegis Aero LLC · Vancleave, MSBuilt 1971 · S/N 17701664 N34147Ferguson Claudia K Trustee · Orange, CABuilt 1971 · S/N 17701665 N34148Rupp Gregory J · Deltona, FLS/N 17701666 N34149Juniper Ventures LLC · Missoula, MTBuilt 1971 · S/N 17701667 N34150Mcalindon Timothy E · Arlington, MABuilt 1971 · S/N 17701668 N34153Furness Donald Craig · Pottsboro, TXBuilt 1972 · S/N 17701671 N34154Sepko Joseph M III · Carrollton, TXBuilt 1971 · S/N 17701672 N34156King Gregory J · Friday Harbor, WABuilt 1971 · S/N 17701674 N34162Bowie Kwame James · Fort Lauderdale, FLBuilt 1972 · S/N 17701680 N34163Middleton Aviation Associates LLC · Madison, WIBuilt 1971 · S/N 17701681 N34164Quintal Anthony L · Imperial Beach, CABuilt 1971 · S/N 17701682 N34166Seamster Gregory L · Ephrata, PABuilt 1971 · S/N 17701684 N34167Nichols Kevin R · Chesterfield, MOBuilt 1971 · S/N 17701685 N34191Cliff Air LLC · Canandaigua, NYBuilt 1971 · S/N 17701689 N34193Hurley William James III · Abingdon, ILBuilt 1971 · S/N 17701691 N34197Sellars Kenneth · Loudon, TNBuilt 1972 · S/N 17701695 N341PBPpb Aviation Management · Wading River, NYBuilt 1971 · S/N 17701661 N34202Srs Aurora LLC · Saint Germain, WIBuilt 1972 · S/N 17701700 N34206Jason Air Inc · Arlington, TNBuilt 1972 · S/N 17701704 N34209Friesen Chevrolet Inc · Sutton, NEBuilt 1972 · S/N 17701707 N34223Strother Brenda J · Kenai, AKBuilt 1972 · S/N 17701715 N34225Dexter Paul J · Orange, MABuilt 1972 · S/N 17701717 N34227Neiser David R · Napavine, WABuilt 1972 · S/N 17701719 N34228Thomas Andrew J · Brownsburg, INBuilt 1972 · S/N 17701720 N34229Winchester Creek Aviation LLC · Waynesville, NCBuilt 1972 · S/N 17701721 N34231Anderson Roger Q · Manassas, VABuilt 1972 · S/N 17701723 N34232Nowacki James R · Brighton, MIBuilt 1972 · S/N 17701724 N34233Stimpson Shawn S · Blackfoot, IDS/N 17701725 N34235Nefc Inc · North Andover, MABuilt 1972 · S/N 17701726 N34241Lewis Mark · Ellisville, MOS/N 17701728 N34242Cherokee Pilots LLC · Royersford, PABuilt 1972 · S/N 17701729 N34244Eliel F John · Sequim, WABuilt 1972 · S/N 17701731 N34248Lucia Arthur H · Blacksburg, VABuilt 1972 · S/N 17701732 N3424CHarris Wayne H · Altamont, TNBuilt 1972 · S/N 17701727 N34250Sierra Lima Aviation LLC · Riverton, UTBuilt 1972 · S/N 17701734 N34258Urias Alejandro R · Mcallen, TXBuilt 1972 · S/N 17701737 N34259Sharp Kenneth M · Pueblo, COBuilt 1972 · S/N 17701738

Back to Cessna 177B