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.

N34709Neal Randall C · Lincoln City, ORBuilt 1973 · S/N 17701948 N34710Warden Leonard D · Anacortes, WABuilt 1973 · S/N 17701949 N34717Schwenker Richard L · Maquoketa, IABuilt 1973 · S/N 17701955 N34720Bulls Eye Trading LLC · Bethany, MOBuilt 1973 · S/N 17701957 N34723Pulliam Donald Edward · Wake Forest, NCBuilt 1973 · S/N 17701960 N34727Valley Fliers Flying Club · Auburn, WABuilt 1973 · S/N 17701962 N34728Deleon Joseph M · Saint Petersburg, FLBuilt 1973 · S/N 17701963 N34729Registered aircraftBuilt 1973 · S/N 17701964 N34731Edenhoffer Peter J · Paris, TXBuilt 1973 · S/N 17701965 N34732Kohles Terrance · Portsmouth, IABuilt 1973 · S/N 17701966 N34735Stramer Todd Personal Representative · Hazelton, NDBuilt 1973 · S/N 17701968 N34737Seareylife LLC · Orlando, FLBuilt 1973 · S/N 17701969 N34739Flying Pterodactyl LLC · Sarasota, FLBuilt 1973 · S/N 17701971 N34743Rogers Ronald · Olney, TXFirst renewal noticeBuilt 1973 · S/N 17701972 N34749Hardy Camden L · Seattle, WABuilt 1973 · S/N 17701975 N347513218t Inc · Omaha, NEBuilt 1973 · S/N 17701977 N34753Vanhook Enterprises Inc · West Somerset, KYBuilt 1973 · S/N 17701979 N34756Devereaux Christopher L · Raleigh, NCBuilt 1973 · S/N 17701982 N34757James David C · Redlands, CABuilt 1973 · S/N 17701983 N34758Vaccaro Glen J · Trinidad, COBuilt 1973 · S/N 17701984 N34759Steckbeck Richard James · Enid, OKBuilt 1973 · S/N 17701985 N34760Abrahamson Allen G · Frisco, TXBuilt 1973 · S/N 17701986 N34761Griffin Jeremiah L · Titus, ALBuilt 1973 · S/N 17701987 N34762Cadamore Brian S · Cabot, PABuilt 1973 · S/N 17701988 N34764York Aviators LLC · York, PABuilt 1973 · S/N 17701990 N34766Robbins Paul A · Nacogdoches, TXS/N 17701991 N34767Tschida Thomas R · Mendota Heights, MNBuilt 1973 · S/N 17701992 N34770Gustin Brian K · Camdenton, MOBuilt 1973 · S/N 17701994 N34772Mlaskoch Air LLC · Willow River, MNBuilt 1973 · S/N 17701996 N34774Dunn Gregory Scott · Wooster, OHBuilt 1973 · S/N 17701998 N34777Trautmann Glenn K · Highlands Ranch, COBuilt 1973 · S/N 17702000 N34787Baker Herman L · Austin, TXBuilt 1973 · S/N 17702003 N34794Schmidt Gary L · Afton, MNBuilt 1973 · S/N 17702005 N34795Fox Business Advisors LLC · Mesa, AZBuilt 1974 · S/N 17702006 N34796Masters David R · Troy, KSBuilt 1973 · S/N 17702007 N34808Barber Jeffrey A · Blaine, MNBuilt 1973 · S/N 17702016 N34809Grassmyer Richard M · Salem, INBuilt 1973 · S/N 17702017 N34813Max Gs LLC · Wilmington, DEBuilt 1973 · S/N 17702020 N34816Clark Tal O · Hudson, COBuilt 1973 · S/N 17702022 N34818Rosenberger Mark W · West Columbia, SCBuilt 1973 · S/N 17702023 N34821Gibbs Keith L · Eaton Rapids, MIBuilt 1973 · S/N 17702025 N34823Eight Twenty Three LLC · Santa Barbara, CABuilt 1973 · S/N 17702026 N34829Woods Roderick D · Collierville, TNBuilt 1974 · S/N 17702029 N34830Airworx LLC · Gotha, FLBuilt 1973 · S/N 17702030 N34833Dallman Bruce D · Terre Haute, INBuilt 1973 · S/N 17702032 N34835Saddleback Enterprises LLC · Newport Beach, CABuilt 1973 · S/N 17702033 N34843Radler Glenn E · Livingston, NJBuilt 1973 · S/N 17702037 N34845Ccf Ventures Inc · Bangor, MES/N 17702039 N34847Hanna David G · Imperial, NEBuilt 1973 · S/N 17702041 N34850Axs Sourcing It LLC · Chugiak, AKBuilt 1973 · S/N 17702044

Back to Cessna 177B