Skip to content

Registered aircraft · 1,300

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 ('2072306', '2072307')
  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 ('2072306', '2072307')
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.

N1913CFerry Theodore D · Bellevue, WABuilt 1953 · S/N 26058 N1915CPiavis Michael G · Emmitsburg, MDBuilt 1953 · S/N 26060 N1916CRegistration Pending · Los Angeles, CARegistration pendingBuilt 1953 · S/N 26061 N1917CKoebel Colin M · Clarendon Hills, ILBuilt 1953 · S/N 26062 N1919CGrandy Tim M · Marion, MIBuilt 1953 · S/N 26064 N1921CRay William H · Lawrenceburg, TNS/N 26066 N1928CLafon Daniel L · League City, TXS/N 26073 N1929CWyborny Wendell R · Cypress, TXBuilt 1953 · S/N 26074 N1930CChidekel Philip M · Chadds Ford, PABuilt 1953 · S/N 26075 N1932CSchone Aviation LLC · Albert Lea, MNBuilt 1953 · S/N 26077 N1934COber John · Candor, NYBuilt 1953 · S/N 26079 N1936CLalomia Vincent · Montclair, NJBuilt 1953 · S/N 26081 N1937CJensen Deleigh S · Dell Rapids, SDBuilt 1953 · S/N 26082 N1942CPfister Robert T · Stuart, FLBuilt 1953 · S/N 26087 N1943CLacey Miles H · Valley Springs, SDBuilt 1953 · S/N 26088 N1944C1944 Charli LLC · Bristol, CTBuilt 1953 · S/N 26089 N1945CWassman Dennis B · Moraga, CABuilt 1953 · S/N 26090 N1946CRegistered aircraftBuilt 1953 · S/N 26091 N1947CWillingham Emma J · Grantville, GABuilt 1953 · S/N 26092 N1949CBailey John Perry · Eagle River, AKS/N 26094 N1953AHarejh Ltd Holdings LLC · Seymour, TNBuilt 1953 · S/N 25582 N1953EKiley Timothy P · Loudon, NHBuilt 1953 · S/N 26003 N1954CBowler Robert I · Anchorage, AKBuilt 1953 · S/N 26099 N1955CLathrop Richard C Trustee · Anchorage, AKBuilt 1953 · S/N 26100 N1956CGreen J L Jr · Greenville, TXBuilt 1953 · S/N 26101 N1961CAeroslat4 LLC · Lewes, DEBuilt 1953 · S/N 26106 N1963CVan Rhede Van Der Kloot Kristin L · Charlotte, VTBuilt 1953 · S/N 26108 N1965CHouseholder Troy D · Bridgeport, WVBuilt 1954 · S/N 26110 N1967CRobinson Lee A · Arlington, TNBuilt 1953 · S/N 26112 N1968CPoor Ronald D · Oak Ridge, TNS/N 26113 N1970JZarinnia Jonathan C · Delavan, WIBuilt 1952 · S/N 20684 N1976CHarmon Ricky A · Worland, WYBuilt 1953 · S/N 26121 N1977CBerquam Paul · Rosamond, CABuilt 1953 · S/N 26122 N1978CMyers Boyd Brent · Tazewell, TNBuilt 1953 · S/N 26123 N1980CHaight Benjamin C Trustee · Juneau, AKBuilt 1953 · S/N 26125 N1981CMcmillan Mark A II · Franklin, TXBuilt 1954 · S/N 26126 N1987CHopkins Daniel E · Austin, TXFirst renewal noticeBuilt 1953 · S/N 26132 N1988CGompert Andrew B · Burwell, NEBuilt 1954 · S/N 26133 N1989CBilton Nicholas J · Bozeman, MTBuilt 1953 · S/N 26134 N1993CSpencer John S · Indian, AKBuilt 1953 · S/N 26138 N1995CBorror Timothy A · Wshngtn Ct Hs, OHBuilt 1954 · S/N 26140 N1996CGoodwin James A · Greeley, COBuilt 1953 · S/N 26141 N1997CTravelaire Service Inc · Pueblo, COBuilt 1954 · S/N 26142 N1999CArnzen Shawn P · Anchorage, AKBuilt 1953 · S/N 26039 N207ECCianchette Eric · Falmouth, MEBuilt 1952 · S/N 25328 N20CFFried Stephen · Plymouth, MAS/N 26217 N2115DRaykowski Michael J · Lake Elmo, MNBuilt 1979 · S/N 26630 N2201DPoage James A · Fairbanks, AKBuilt 1952 · S/N 20353 N2207DGrosshandler Kevin · Palmer, AKBuilt 1952 · S/N 20359 N2209DMaas Michael H · Mendota, ILBuilt 1952 · S/N 20361

Back to Cessna 170B