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.

N8299AStevenson James W · Oregon, WIBuilt 1952 · S/N 25151 N8300AChapa Jana K · Corpus Christi, TXBuilt 1952 · S/N 25152 N8301AFrazer Wendy J · Meridian, IDBuilt 1952 · S/N 25153 N8303AMiller A Barry · Lincoln, ILBuilt 1952 · S/N 25155 N8304AWehner John P · Malone, WIS/N 25156 N8307ASweetnam G Leslie · Woodstock, CTBuilt 1952 · S/N 25159 N8308APrice Jerry A · Joiner, ARBuilt 1952 · S/N 25160 N8310ARodabaugh Ernest R IV · Greenfield, INBuilt 1952 · S/N 25162 N8314AMagliacano Matthew J · Bucyrus, KSBuilt 1952 · S/N 25166 N8317ASpivey Kenneth R Jr · Vestavia, ALBuilt 1952 · S/N 25169 N8319AWhitney Bill · Anacortes, WABuilt 1952 · S/N 25171 N8322AFlack James R Trustee · Loudonville, OHBuilt 1952 · S/N 25174 N8325ASutton Aircraft Salvage LLC · Palmer, AKS/N 25177 N8326ARacoon Aviation LLC · San Antonio, TXBuilt 1952 · S/N 25178 N8329A170 Adventures LLC · Hermosa Beach, CABuilt 1952 · S/N 25181 N8330AKoliadko Joseph I · Luray, VAS/N 25182 N8335AHaack Forrest · Wasilla, AKS/N 25187 N8336ANicholson Scott V · Kalamazoo, MIFirst renewal noticeBuilt 1952 · S/N 25188 N8338AWoodbury Forest P · Clarksville, TNBuilt 1952 · S/N 25190 N8340AWeyers William C · Grimes, IABuilt 1952 · S/N 25192 N8348AKelly David M · Issaquah, WAS/N 25200 N8349ASudtell Chad S · Wasilla, AKS/N 25201 N8350APhillabaum Stephen D · Deer Park, WABuilt 1952 · S/N 25202 N8352AWood Jeremy D · Girdwood, AKBuilt 1952 · S/N 25204 N8356AClinard Larry L · Escanaba, MIS/N 25208 N8357AMcclellan Richard G · Poplar Grove, ILBuilt 1952 · S/N 25209 N8359AWoosley Kenneth D · Rumsey, KYBuilt 1952 · S/N 25211 N8361ABenton Paul N · Manhattan, KSBuilt 1952 · S/N 25213 N8365AHauptman George J · Halfway, ORBuilt 1952 · S/N 25217 N8366ACyr Gregory A · Augusta, MES/N 25218 N8367AAnderson Arthur L · Fitzgerald, GABuilt 1952 · S/N 25219 N8368AOwens John P · Deland, FLBuilt 1952 · S/N 25220 N8373AMcginn Robert W · Marion, NCBuilt 1952 · S/N 25225 N8374AChilds Donald R · Wasilla, AKBuilt 1952 · S/N 25226 N8379ADedominicis Anthony J · Oneonta, NYBuilt 1952 · S/N 25231 N8380ALynch Henry D · Hebron, NHBuilt 1952 · S/N 25232 N8386ATwo Flyers LLC · Wilmington, DEBuilt 1952 · S/N 25238 N8388AHamm Simon P · Denali, AKBuilt 1953 · S/N 25240 N856DRSchreiber Ryan S · Winter Garden, FLBuilt 1955 · S/N 26739 N87045Newton Greg R · Powell, WYBuilt 1953 · S/N 25588 N880MTKibler John · Kalispell, MTBuilt 1952 · S/N 20805 N8NTDegerlund Elmer · Fairbanks, AKBuilt 1953 · S/N 25841 N915SCI P M Ministries · Dufur, ORBuilt 1954 · S/N 26131 N9217AAlumitank Inc · Harvard, ILBuilt 1955 · S/N 26619 N9267ABrown Craig A · Airway Heights, WABuilt 1949 · S/N 19028 N9276ABrandon Airways LLC · Bakersfield, CABuilt 1949 · S/N 19037 N9277Lynn William S · Jackson, MSBuilt 1953 · S/N 25964 N94GVSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1954 · S/N 26528 N94VWCamp Harper LLC · Houston, TXBuilt 1955 · S/N 26791 N992EZLarge Jon D · Wasilla, AKBuilt 1953 · S/N 25905

Back to Cessna 170B