Skip to content

Registered aircraft · 272

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

N4048VThomas Kevin C · Spokane, WABuilt 1948 · S/N 18377 N4050VDussetschleger Lynn Albert · Luling, TXBuilt 1948 · S/N 18381 N4054VHunsberger Colin T · Palmer, AKBuilt 1948 · S/N 18386 N4055VWayman Tim · Santa Rosa, CAS/N 18387 N4063VInternational Air Services Inc Trustee · Carson City, NVBuilt 1948 · S/N 18395 N4064VCapouch Rosemary E · Medaryville, INBuilt 1948 · S/N 18396 N4066VWeis Patrick A · Cornelius, ORBuilt 1948 · S/N 18398 N4067VBas Part Sales LLC · Greeley, COBuilt 1948 · S/N 18399 N4070VWomack Jimmy R · Webb, ALBuilt 1948 · S/N 18402 N4072VHauenstein Edgar D · Holden, MOBuilt 1948 · S/N 18404 N4073VBryant Dorothy A · Arlington, SDBuilt 1948 · S/N 18405 N4079VGovednik Frank J · Nipomo, CABuilt 1948 · S/N 18411 N4085VGeorge Daniel W · Reynoldsburg, OHBuilt 1948 · S/N 18417 N4087VYakima 65 N Flying Club · Yakima, WABuilt 1948 · S/N 18419 N4089VIhlenfeld Mark A · Owatonna, MNBuilt 1948 · S/N 18421 N4094VGoodwin Jefferson J · Dolan Springs, AZS/N 18426 N4098VQualitair LLC Trustee · MichelstadtBuilt 1948 · S/N 18430 N4104VDavis Lawrence R · Kent, OHBuilt 1948 · S/N 18436 N4111VJohnston Daniel T · Cambridge, OHBuilt 1948 · S/N 18443 N4112VButterfield Colin · Wellesley, MABuilt 1948 · S/N 18444 N4113VHare Charles W · Leaf River, ILS/N 18445 N4129VStoddart Ranches Inc · Jordan Valley, ORBuilt 1948 · S/N 18461 N4134VBelgau Robert J · Fort Pierce, FLBuilt 1948 · S/N 18466 N4136VGauntt Chep R · Goodyear, AZBuilt 1948 · S/N 18468 N4140VDirigo Aerospace Solutions LLC · Sumner, MEBuilt 1948 · S/N 18472 N4143VRegistered aircraftBuilt 1948 · S/N 18475 N4144VLadage Terry L · Champaign, ILBuilt 1948 · S/N 18622 N4149VBush Brett C · Cody, WYBuilt 1948 · S/N 18481 N4150VDorsey Christopher · Round Rock, TXBuilt 1948 · S/N 18482 N4151VRisner Rick · Vernon, TXS/N 18483 N4152VBrewer Samuel T · Wasilla, AKS/N 18484 N4153VBenoit Bob W · Hot Springs, ARBuilt 1963 · S/N 18485 N4154VWindsock Capital LLC · Bertram, TXS/N 18486 N4155VBeavert Curt E · Murfreesboro, ARBuilt 1948 · S/N 18487 N4157VMoran Charles L Jr · Fresno, CABuilt 1948 · S/N 18489 N4162VUntiet Steven R · Homer, AKBuilt 1950 · S/N 18494 N4163VRoot Shane G · Dighton, KSBuilt 1948 · S/N 18495 N4164VRowe Dennis A · Vandergrift, PABuilt 1948 · S/N 18497 N4165VHagen Curt L · Sullivan, WIBuilt 1948 · S/N 18498 N4166VFreitas Anthony F · Canby, ORBuilt 1948 · S/N 18499 N4168VLehr F Mark · Placitas, NMBuilt 1948 · S/N 18501 N4172VMd Aero LLC · Somerton, AZBuilt 1948 · S/N 18505 N4173VLohmeier George A · Indianapolis, INBuilt 1948 · S/N 18506 N4178VVan Dyke Robert L · Foley, ALBuilt 1948 · S/N 18511 N4179VSchmidt David · Brooksville, MSBuilt 1948 · S/N 18512 N4182VCoulter Robert Allen · Granger, INBuilt 1948 · S/N 18515 N4185VHuff James L · Mars Hill, NCBuilt 1948 · S/N 18518 N4186VJohnson David E · Rock Island, ILBuilt 1948 · S/N 18519 N4188VNtn3n LLC · Titusville, FLBuilt 1948 · S/N 18521 N4189VEastman Gregory L · Pueblo, COS/N 18522

Back to Cessna 170