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.

N2622VLaird Charles · Adelanto, CAS/N 18132 N2623VPlane Fun Inc Tr Trustee · Snellville, GABuilt 1948 · S/N 18133 N2624VRice Robert · Trout Creek, MTBuilt 1948 · S/N 18134 N2634VClanton Leslie G · Yazoo City, MSFirst renewal noticeBuilt 1948 · S/N 18144 N2635VLaycock Justin D · Johnson City, TNS/N 18145 N2636VMclaughlin Nathaniel D · Clayton, CABuilt 1958 · S/N 18146 N2645VPapp Adam · Raleigh, NCBuilt 1948 · S/N 18155 N2646VEsslinger David F · Zionsville, INBuilt 1948 · S/N 18156 N2649VStedingh Donald M · Anchorage, AKBuilt 1948 · S/N 18159 N2656VMccurdy James Rodney · Statesville, NCS/N 18166 N2658VGriffin Robert L · Warren, OHBuilt 1948 · S/N 18168 N2661VParker Alan A · Visalia, CABuilt 1948 · S/N 18171 N2663VGuthrie Michael E · North Highlands, CABuilt 1948 · S/N 18173 N2666VWalden James F · Willcox, AZBuilt 1948 · S/N 18364 N2667VPfunke Mark E · Chester, NJBuilt 1948 · S/N 18177 N2668VPlane Fun Inc Tr Trustee · Snellville, GABuilt 1948 · S/N 18178 N2669VMartin Brian J · Grayslake, ILBuilt 1948 · S/N 18179 N2670VRetro Air LLC · Seattle, WABuilt 1948 · S/N 18180 N2675VHartis Christopher · Newman Lake, WABuilt 1948 · S/N 18185 N2682VVogen Jeffrey L · Newark, ILBuilt 1948 · S/N 18193 N2686VMoore Steven L · Glasgow, KYBuilt 1948 · S/N 18196 N2689VFoster Stephen R · Stockton, CAS/N 18199 N2696VHall Cody G · Coeur D Alene, IDBuilt 1948 · S/N 18206 N2767DReal World Strategic LLC · Reno, NVBuilt 1952 · S/N 25309 N2801CMurphy Ronald D · San Jose, CABuilt 1954 · S/N 26344 N3236ALibby Stephen Trustee · Anchorage, AKBuilt 1953 · S/N 25880 N3412DBerens Brian T · Homer, AKBuilt 1955 · S/N 26955 N3474CLeroux Todd Carl · Palmer, AKBuilt 1954 · S/N 26517 N3482CLacewell Matthew K · Chugiak, AKFirst renewal noticeBuilt 1954 · S/N 26525 N3802VBrink Gregory P · Joseph, ORS/N 18723 N3804VIhlenfeldt Richard W · Forest Lake, MNBuilt 1948 · S/N 18662 N3805VN3805v LLC · Aubrey, TXBuilt 1948 · S/N 18663 N3813VTailwheelin LLC · Richland, WABuilt 1948 · S/N 18671 N3815VKovac James M · Muskego, WIBuilt 1948 · S/N 18673 N3816VStevens Scott D · Corsicana, TXS/N 18674 N3823VTollefson Jason C · Zillah, WAS/N 18681 N3827VRobotti Mark E · Lindstrom, MNBuilt 1948 · S/N 18685 N3828VCoon Paul R · Benge, WABuilt 1948 · S/N 18686 N3833VWicks Mark A · Bethel, PABuilt 1948 · S/N 18691 N3835VJones Scott L · Hilliard, OHBuilt 1957 · S/N 18693 N3900VMays Kevin E · West Liberty, KYBuilt 1948 · S/N 18210 N3903VMiller Charles G · Anchorage, AKBuilt 1948 · S/N 18213 N3907VSortland Mitchell Kent · Parkersburg, IABuilt 1948 · S/N 18217 N3908VKaiser Jimmy · Lake Park, MNBuilt 1948 · S/N 18218 N3911VMckenzie James A · Corvallis, ORS/N 18221 N3914VBodnar Axel R · Wasilla, AKBuilt 1948 · S/N 18224 N3916VHorn Bradley P · Waterloo, ILS/N 18226 N3919VBishop Zachary Ryan · Stewartstown, NHS/N 18229 N3922VWilson Wesley R · Soldotna, AKBuilt 1948 · S/N 18232 N3923VBabin Kenneth L · Sandpoint, IDBuilt 1948 · S/N 18233

Back to Cessna 170