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.

N8163ABarker Donna J · Connersville, INS/N 25015 N8164ASpurlock Daniel C · Harrogate, TNBuilt 1952 · S/N 25016 N8168ADuell Levi D · Kodiak, AKBuilt 1952 · S/N 25020 N8169AVetterli Gary R · Monroe, WIBuilt 1952 · S/N 25021 N8170QMerkes Dennis R · Soldotna, AKBuilt 1952 · S/N 25412 N8172AWood Thomas A · Salome, AZBuilt 1952 · S/N 25024 N8175AFoster Mike D · Fairbanks, AKBuilt 1952 · S/N 25027 N8176AThom Jacob D · Wasilla, AKS/N 25028 N8180ANipp Michael P · Nampa, IDBuilt 1952 · S/N 25032 N8183ARegistered aircraftBuilt 1952 · S/N 25035 N8189AEight Niner Alpha LLC · Eagle, IDBuilt 1952 · S/N 25041 N8193AEllis David L · Springville, INS/N 25045 N8194AUnable Direct LLC · Kalispell, MTBuilt 1952 · S/N 25046 N8196AAlford James C · Kodiak, AKBuilt 1952 · S/N 25048 N8199AMilani Bryan L · Medford, ORBuilt 1952 · S/N 25051 N8202AWeaver Savannah N · Fortson, GABuilt 1952 · S/N 25054 N8203AVista Aviation Services LLC · Boone, IABuilt 1952 · S/N 25055 N8206AWalker Jack A · Klamath Falls, ORBuilt 1952 · S/N 25058 N8210AArdmore Aviation LLC · Novelty, OHBuilt 1952 · S/N 25062 N8212AScarboro Thomas E · North Pole, AKBuilt 1952 · S/N 25064 N8214ARozycki Seth · Little Falls, MNBuilt 1952 · S/N 25066 N8216ADates Lauren C · Red Creek, NYBuilt 1952 · S/N 25068 N8219AElder Joel M · Scott City, KSBuilt 1952 · S/N 25071 N8223ASmith Mathias N · Weiser, IDS/N 25075 N8224ESudano Richard L · Cordova, AKBuilt 1959 · S/N 26656 N8225AFast Track Aircraft LLC · Oxford, MSBuilt 1952 · S/N 25077 N8227AJin Jin Aviation LLC · Anchorage, AKBuilt 1952 · S/N 25079 N822WEWalker James E · East Jordan, MIS/N 25874 N8236ASchoettmer Thomas C · Greensburg, INBuilt 1956 · S/N 25088 N8238AMoore Terrance J · Tacoma, WABuilt 1952 · S/N 25090 N8244AMiles Robert A · Maupin, ORBuilt 1952 · S/N 25096 N8245AAdriatic Holdings LLC · Cheyenne, WYBuilt 1952 · S/N 25097 N8248AEllis John D · Hodgenville, KYBuilt 1952 · S/N 25100 N8250ARyan Craig M · Corona Del Mar, CAS/N 25102 N8251AJulius William C · Julesburg, COS/N 25103 N8252ADuane Peters · Anchorage, AKBuilt 1952 · S/N 25104 N8254ABerna Glen F · Pulaski, WIBuilt 1952 · S/N 25106 N8256ACharlestream David · Eagle River, AKBuilt 1952 · S/N 25108 N8267AWendt Clayton L · Lino Lakes, MNS/N 25119 N8268AVelligan Gary S · Granada Hills, CABuilt 1952 · S/N 25120 N8271AGraybeal Jason W · Ocala, FLBuilt 1952 · S/N 25123 N8273DDemuth John L · Juneau, AKBuilt 1953 · S/N 25377 N8274AOhler Michael Jr · West Richland, WABuilt 1952 · S/N 25126 N8279AHadley Harold C · Parma, IDBuilt 1952 · S/N 25131 N8285AReim Sanford E · Fort Myers, FLBuilt 1952 · S/N 25137 N8287ALindholm Stanley D Trustee · Lucas, TXBuilt 1952 · S/N 25139 N8291AScott William M · Spring Hill, FLBuilt 1952 · S/N 25143 N8292ADeforest Dennis L · Hamilton, INBuilt 1952 · S/N 25144 N8293AMcgreevy Stephen P · Poplar Grove, ILBuilt 1952 · S/N 25145 N8295AHairston Marvin A · Peck, IDBuilt 1952 · S/N 25147

Back to Cessna 170B