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.

N3458DMarquardt Paul M · Rhinelander, WIBuilt 1955 · S/N 27001 N3462CGivens Benjamin T · Ruffin, SCBuilt 1954 · S/N 26505 N3462DKudner Donald T · Maumee, OHS/N 27005 N3463DBrown Theodore A · Trivoli, ILBuilt 1955 · S/N 27006 N3464COlson Donald C · Golovin, AKS/N 26507 N3465DGold Prop Aviation LLC · Auburndale, FLS/N 27008 N3466DSmith George L · Watervliet, MIBuilt 1955 · S/N 27009 N3467CShaw Brian W · Bemidji, MNS/N 26510 N3467DNorth Lake Air LLC · Lindstrom, MNBuilt 1955 · S/N 27010 N3469CSoroka Stephen W · Eagle River, AKBuilt 1954 · S/N 26512 N3470CMoorhead Equipment LLC · Belton, SCBuilt 1954 · S/N 26513 N3472CTotal Tailwheel LLC · Weston, MABuilt 1954 · S/N 26515 N3472DHill Kevin James · Aurora, MNS/N 27015 N3476CDitzler Kevin J · Kirkland, WABuilt 1954 · S/N 26519 N3477CAir Speed Development LLC · Helena, MTBuilt 1954 · S/N 26520 N3478CSchumacher Brent A · Inchelium, WAS/N 26521 N3479DGeier Harry J · Huntington Beach, CABuilt 1955 · S/N 27022 N3480CEffenberger Anthony J · Mankato, MNBuilt 1954 · S/N 26523 N3481DDavis Tyler M · Moreland, GABuilt 1955 · S/N 27024 N3482DKrumins Arvids · Wichita, KSBuilt 1955 · S/N 27025 N3483CBorreson Michele R · Reno, NVBuilt 1954 · S/N 26526 N3486CZachary Maydole · Fairbanks, AKBuilt 1954 · S/N 26529 N3487CWhitten Chris K · Alton, MOBuilt 1954 · S/N 26530 N3487DSowles John W · North Yarmouth, MEBuilt 1955 · S/N 27030 N3488CBaker Dean C · Cave Creek, AZBuilt 1954 · S/N 26531 N3488DSugarloaf Aviation LLC · Carrabassett Vly, MES/N 27031 N3489CBurward-Hoy Trevor · Cupertino, CABuilt 1954 · S/N 26532 N3491CNorth Sound Aviation Inc · Sedro Woolley, WABuilt 1954 · S/N 26534 N3492CPiscoya Thomas G · Anchorage, AKBuilt 1954 · S/N 26535 N3493CLumland Properties LLC · Winchester, VAS/N 26536 N3495DBruck Solomon A · Van Nuys, CABuilt 1955 · S/N 27038 N3496DBengtson David M · Van Alstyne, TXBuilt 1955 · S/N 27039 N3497CDavids Robert A · Angels Camp, CABuilt 1955 · S/N 26540 N3497DBeckman Steven J · Parker, COBuilt 1955 · S/N 27040 N3498CBowen Miles C · Brighton, MIBuilt 1955 · S/N 26541 N3498DHeitz John W · Manvel, TXBuilt 1955 · S/N 27041 N3499DSnell Robert B · La Vernia, TXBuilt 1955 · S/N 27042 N3500CWilder Levi J · Anchorage, AKBuilt 1954 · S/N 26543 N3500DBlazejewski Tyler P · Palmer, AKS/N 27043 N3501COlson Alan D · Oak Run, CABuilt 1954 · S/N 26544 N3502DCianchette Eric L · Falmouth, MEBuilt 1955 · S/N 27045 N3505CFry Ravi M · Darby, MTS/N 26548 N3509CRollman Thomas Jaeger Trustee · Eagle River, AKBuilt 1954 · S/N 26552 N3510DSkywagon Aero LLC · Wilmington, DEBuilt 1955 · S/N 27053 N3511CNoll Richard J · Lehighton, PABuilt 1954 · S/N 26554 N3514CKown William B · Hamilton, ALS/N 26557 N3516DBickford Timothy · Limington, MES/N 27059 N3517CAnderson Robert A · Dove Creek, COBuilt 1954 · S/N 26560 N3517DStrange Willam H · Lewiston, IDBuilt 1955 · S/N 27060 N3519DLebold Mary Ann · Hubbard, ORBuilt 1955 · S/N 27062

Back to Cessna 170B