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.

N100LDPenning Jeffrey D · Clear Lake, IABuilt 1968 · S/N 17700990 N104AFNance David B · Quinton, VABuilt 1967 · S/N 17700238 N117MMMelton Charlie W · Grand Saline, TXBuilt 1968 · S/N 17700872 N121ECN121ecfllyers LLC · South Jordan, UTBuilt 1967 · S/N 17700036 N1269RThompson Steve E · Port Angeles, WABuilt 1968 · S/N 17700625 N141JGCardinal 1jg LLC · Bakersfield, CABuilt 1968 · S/N 17700930 N147MLPatton Andrew Joseph · Andrews, INBuilt 1968 · S/N 17701000 N169FLBlue Moon Holding Co LLC · Boca Raton, FLS/N 17700047 N169JWPatterson Matthew D · Knoxville, TNBuilt 1968 · S/N 17700360 N177ASManning Bryan E · Northport, ALBuilt 1968 · S/N 17700967 N177CCHoel Martin J · Waterloo, IABuilt 1967 · S/N 17700654 N177CVZinkel Gregory S · Leander, TXS/N 17700640 N177DKKeen David S · Amherst, NHBuilt 1967 · S/N 17700567 N177EBDodd Lisa · Sandpoint, IDBuilt 1967 · S/N 17700562 N177FGMancini Joseph · Alpine, CABuilt 1968 · S/N 17700817 N177HLLuken Henry G III · Chattanooga, TNS/N 17701106 N177MHHicks Charles Jr · Big Bear Lake, CABuilt 1967 · S/N 17700302 N177NWDebusk Eric M · Columbus, INBuilt 1968 · S/N 17701097 N177PZRobinson James T · Cohutta, GABuilt 1968 · S/N 17700773 N177RLM&G Air Service LLC · Wilmington, DEBuilt 1968 · S/N 17701109 N177RPUSA Premier Repair & Services Inc · Sacramento, CABuilt 1968 · S/N 17700763 N177SKHartwig Lonnie D · Edgeley, NDBuilt 1968 · S/N 17701038 N177VAnglin Robert · Rochester, MNBuilt 1967 · S/N 17700406 N177VAAerial Specialties Inc · Decatur, TXBuilt 1968 · S/N 17700881 N177XPHills Denver L · Show Low, AZS/N 17700953 N212TMSchuldt Scott A · North Little Rock, ARBuilt 1968 · S/N 17701004 N2201YInternational Air Services Inc Trustee · Carson City, NVBuilt 1967 · S/N 17700001 N2204YEagle Sky Patrol Inc · Deadwood, SDS/N 17700004 N2206YSanders Andrew · Livingston, MTBuilt 1967 · S/N 17700006 N2211YGayle Randall K · Houston, TXBuilt 1967 · S/N 17700011 N2212YSteffy Richard L · Annville, PABuilt 1967 · S/N 17700012 N2214YRegistration Pending · Tampa, FLRegistration pendingBuilt 1967 · S/N 17700014 N2218YDoran Jeffrey T · Westerville, OHS/N 17700018 N2221YThomas Raymond N · Springfield, SDBuilt 1967 · S/N 17700021 N2223YReynolds David Keith · Bastrop, LABuilt 1967 · S/N 17700023 N2226YRamjattan Enarl A · Harahan, LABuilt 1967 · S/N 17700026 N2227YAdam Lewis W · Chiefland, FLBuilt 1967 · S/N 17700027 N2238YFerrara Edmond · La Puente, CABuilt 1967 · S/N 17700038 N2243YReeves Adrianna M · New Carlisle, INBuilt 1967 · S/N 17700043 N2244YHaberer Mark M · Elbow Lake, MNBuilt 1967 · S/N 17700044 N2246YHixon Craig D · Sayre, OKBuilt 1967 · S/N 17700046 N2248YDavis Christopher S · Halls, TNBuilt 1967 · S/N 17700048 N2249YBlake Bernie E · Troy, NCBuilt 1967 · S/N 17700049 N2252YMeisch Robert L · Crystal, MNBuilt 1967 · S/N 17700052 N2253YAviation 2000 Inc · Fort Mill, SCBuilt 1967 · S/N 17700053 N2258YConnor Thomas M · Great Falls, MTBuilt 1967 · S/N 17700058 N2260YReich Bruce D · Red Oak, IABuilt 1967 · S/N 17700060 N2261YKemper Dennis R · Carmichael, CABuilt 1967 · S/N 17700061 N2262YRegistered aircraftBuilt 1967 · S/N 17700062 N2263YMejia Mauricio · South Gate, CABuilt 1967 · S/N 17700063

Back to Cessna 177