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.

N597TTTerrell David R · Smithville, TNBuilt 1969 · S/N 17701403 N621PWSkyten Flying Club Inc · Orefield, PABuilt 1976 · S/N 17702461 N6259RBreletic John C Jr · Ellijay, GABuilt 1975 · S/N 17702236 N633DAAviation Systems And Service LLC · Mounds, OKBuilt 1974 · S/N 17702214 N664AKWarren John · Homer, AKBuilt 1975 · S/N 17702148 N666MMLawson Robert W · Tacoma, WABuilt 1971 · S/N 17701633 N679JTAdventure Aviation Sales Inc · Jeffersonville, INBuilt 1976 · S/N 17702428 N67JMEck Gary A · Osceola, INBuilt 1973 · S/N 17701940 N67MMSingh Ravinder · Happy Valley, ORBuilt 1975 · S/N 17702269 N6WADue North Aviation LLC · League City, TXBuilt 1971 · S/N 17701676 N700PJShort Stephen A · Lake Placid, NYBuilt 1977 · S/N 17702628 N707DRRichardson Douglas · Goodlettsville, TNBuilt 1970 · S/N 17701458 N711RNGoldsmith Donald E Jr · Brandywine, MDBuilt 1973 · S/N 17702010 N7136XArchangel Michael Flyers Inc · Princeville, HIS/N 17702290 N717NARegistered aircraftBuilt 1972 · S/N 17701760 N723SBFreeman-Benson Bjorn N · Portland, ORS/N 17701786 N726AJStarr Alan D · Senoia, GABuilt 1969 · S/N 17701378 N72727Hice Michael D · Cookeville, TNBuilt 1971 · S/N 177-01678 N727DCCalianno David · Spring Hill, FLBuilt 1974 · S/N 17702086 N736LBSkyraider Aero Club · Spokane, WABuilt 1972 · S/N 17701825 N74DPRegistered aircraftBuilt 1974 · S/N 17702150 N75ALTeebagy Steven C · Wellington, FLBuilt 1973 · S/N 17701927 N76HSDelgrosso Dennis W · Saranac, NYBuilt 1977 · S/N 17702642 N76JKKrajewski Jason · Portland, ORBuilt 1976 · S/N 177-02435 N7736LSimmons David · Fremont, NEBuilt 1976 · S/N 17702603 N778RDKilo Golf Aviation LLC · St Simons Island, GABuilt 1976 · S/N 17702550 N812THSuss Charles H · Woodford, VTBuilt 1971 · S/N 17701615 N81LWCloud Seven LLC · Fort Pierce, FLBuilt 1976 · S/N 17702455 N829PJMidwestern Twang Communications LLC · Evanston, ILBuilt 1970 · S/N 17701534 N82HABeller Ronald D · Morehead, KYBuilt 1976 · S/N 17702401 N888VMDaniels Michael R · Mc Donald, PABuilt 1973 · S/N 17702021 N8YQHartlieb Gordon Wesley · Anchorage, AKBuilt 1972 · S/N 17701718 N916CLDolphin Sales Inc · Wilkes Barre, PABuilt 1975 · S/N 17702273 N917GJHawdon Neil John · Federal Way, WAS/N 17702703 N9342RCampbell Gene H · Baytown, TXBuilt 1978 · S/N 17702752 N959AGGrant Altin C · Tahlequah, OKBuilt 1973 · S/N 17701952 N96177B2 Cpr Plus Inc · Bermuda Dunes, CABuilt 1970 · S/N 17701543 N9842ESopko Michael C · Bonita, CABuilt 1975 · S/N 17702328 N999HRPage Edward C · Thornhurst, PABuilt 1975 · S/N 17702359 N999PAGoodwin William S · Sequim, WABuilt 1969 · S/N 17701392 N99NAPozzi Andrew E · Crescent City, CABuilt 1977 · S/N 17702697 N99PXCeo Flight Inc · Arlington Heights, ILS/N 17702149 N9FRDonaldson Thomas M · Granbury, TXBuilt 1977 · S/N 17702666

Back to Cessna 177B