Skip to content

Registered aircraft · 513

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

N1482DSiebe Carl F · Anchorage, AKBuilt 1951 · S/N 20065 N1483DFlying Plane LLC · Bartow, FLBuilt 1951 · S/N 20086 N1489DAce Hole Flying Club LLC · Spokane, WABuilt 1951 · S/N 20091 N1490DCole Daniel G · Pittsburgh, PAS/N 20092 N1492DLevin Amanda L Trustee · Prairie Du Sac, WIBuilt 1951 · S/N 20094 N1493DJobe Waylen Mark · Eugene, MOBuilt 1951 · S/N 20095 N1494DFuller Scott M · Edinburg, TXBuilt 1951 · S/N 20096 N14CPWheels Floats Skids And Skis LLC · Brooklyn, MIS/N 19721 N1607DMiko Aviation LLC · Santee, CAS/N 20249 N1616DCorbin Sarah R · Anchorage, AKFirst renewal noticeBuilt 1951 · S/N 20258 N1618DJutting Anthony C · Fruitland, IDS/N 20260 N1619DVintage Pacific Aviator LLC · Redondo Beach, CABuilt 1951 · S/N 20261 N1621DPease Rex A · Grand Haven, MIBuilt 1951 · S/N 20263 N166LJWilcoxen Paul · Wichita, KSS/N 18756 N167Palmer Michael · Crystal Lake, ILBuilt 1950 · S/N 19225 N1700DJohnson Robert Kenneth · Monte Rio, CABuilt 1951 · S/N 20143 N1704DSykes Gregory P · Arlington, WABuilt 1951 · S/N 20147 N1705DSchultz Jeffrey J · Wasilla, AKBuilt 1951 · S/N 20148 N1706DMaser Matt P · Junction City, ORBuilt 1952 · S/N 20149 N1707DMorse David M · Kernersville, NCBuilt 1951 · S/N 20150 N170AWyrick Randall D · Fairland, OKBuilt 1987 · S/N 19374 N170AGHuber David C · Victoria, TXBuilt 1949 · S/N 18975 N170ASBowe Rick J Trustee · Chippewa Falls, WIBuilt 1950 · S/N 19824 N170DWarr Victor L · Star, IDBuilt 1951 · S/N 20194 N170DFWilliams John S · Cleveland, TXBuilt 1950 · S/N 19519 N170DWBelden George B · Sonoma, CABuilt 1949 · S/N 19154 N170ETPalmatier Harry C III · Volant, PAS/N 19641 N170GAOtey Neil F · White Bear Lake, MNBuilt 1951 · S/N 19948 N170GCWiley Calvin B · Summer Shade, KYBuilt 1950 · S/N 19442 N170KMMarlow Properties LLC - Marlow Aviation LLC Series · Knoxville, TNBuilt 1949 · S/N 19166 N170MBCoffman Richard A II · Hernando, MSBuilt 1950 · S/N 19203 N170PBFancher Scott · Granite Falls, WABuilt 1950 · S/N 19800 N170PSMcgavock Edward A · Columbus, WIBuilt 1951 · S/N 20152 N170PTSabos Anthony J · Bolingbrook, ILBuilt 1950 · S/N 19300 N170PYYates James H · Edmond, OKBuilt 1951 · S/N 19949 N170RSWilson Benjamin A · Shawnee, KSBuilt 1950 · S/N 19611 N170TCGammelin Robert · Alta, WYBuilt 1949 · S/N 19183 N170TPNorthrop John · Fairfield, CAFirst renewal noticeBuilt 1950 · S/N 19609 N170WSSikorski Bradley · Colorado Springs, COBuilt 1950 · S/N 19490 N1712DRichter Ty G · Buffalo, SDBuilt 1951 · S/N 20155 N1714DBellenir Michael A · Mastic Beach, NYBuilt 1951 · S/N 20157 N1715DPulley Richard A · Chugiak, AKBuilt 1951 · S/N 20158 N1718DSwe3 LLC · Seattle, WABuilt 1951 · S/N 20161 N1720DDriver Jonathan S · Oakland Park, FLBuilt 1951 · S/N 20163 N1725DBeisheim Carrie E · Fort Calhoun, NEBuilt 1951 · S/N 20168 N1727DHall L Robert · La Verne, CAS/N 20170 N1730DKeith R Layne · Oklahoma City, OKS/N 20173 N1733DCessna 170 LLC · Idaho Falls, IDBuilt 1951 · S/N 20176 N1735DOxford Glenn H · Fredericksburg, VAS/N 20178 N1736DHoffman Drew A · Churubusco, INBuilt 1951 · S/N 20179

Back to Cessna 170A