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.

N2538DHanley Olan B II · Bellevue, WABuilt 1952 · S/N 20690 N2541CBartelli Stephen J · Wasilla, AKBuilt 1954 · S/N 26185 N2542CPapa Bravo LLC · Decatur, ALBuilt 1954 · S/N 26186 N2543CCarroll Arthur G Trustee · Eagle Lake, MEBuilt 1954 · S/N 26187 N2544DBouvier Ryan B · Granby, MABuilt 1952 · S/N 20696 N2545DEvans Shane B · Carbondale, COBuilt 1952 · S/N 20697 N2546CRaby Byrd J · Normandy, TNBuilt 1954 · S/N 26190 N2546DWhitfield Robert O Jr · Hurdle Mills, NCS/N 20698 N2548DIbarra Rivera Christian · Boca Raton, FLBuilt 1952 · S/N 20700 N2551CRobertson Tia M · Acworth, GABuilt 1954 · S/N 26195 N2551DLast Frontier Tailwheel LLC · Anchorage, AKBuilt 1952 · S/N 20703 N2553CSwanson Lonnie L · Delta Junction, AKBuilt 1954 · S/N 26197 N2553DJohnson Nathaniel D · Attalla, ALBuilt 1952 · S/N 20705 N2554CWard Wilbur B · Swannanoa, NCS/N 26198 N2555CLatham David C · Weld, MEBuilt 1954 · S/N 26199 N2557CJmte Aviation LLC · Appleton, WIBuilt 1954 · S/N 26201 N2557DFullerton John R · Fairbanks, AKFirst renewal noticeS/N 20709 N2558DClayton Alfred T Jr · Anchorage, AKBuilt 1952 · S/N 20710 N255PAAndresen Paul S · Chandler, AZBuilt 1955 · S/N 26735 N2562DWalker Garrett J · Anchorage, AKBuilt 1952 · S/N 20714 N2565CFolgner Robert E · Dana Point, CARegistration revokedBuilt 1954 · S/N 26209 N2566CJohnson James K · Sandy Valley, NVBuilt 1954 · S/N 26207 N2567DHaasl Glen D · Chugiak, AKBuilt 1952 · S/N 20719 N2571CLane Steven A · Rockwood, MEBuilt 1952 · S/N 26215 N2571DLiebsch Greg A · Gilbert, AZBuilt 1952 · S/N 20723 N2574DDumm Wesley J · Kodiak, AKBuilt 1952 · S/N 20726 N2575DBurgess William S · Anchorage, AKBuilt 1952 · S/N 20727 N2576CFlying R LLC · Fruitdale, SDBuilt 1954 · S/N 26220 N2576DMarshall Jerry J · Parker, AZBuilt 1952 · S/N 20728 N2578CPayne Megan T · Anchorage, AKFirst renewal noticeBuilt 1954 · S/N 26222 N2578DKnuths Kristian Jacob · North Pole, AKBuilt 1952 · S/N 20730 N2580DPlace Ashley K · Bradenton, FLBuilt 1952 · S/N 20732 N2581DMccullugh Jordon T · Idaho Falls, IDBuilt 1952 · S/N 20733 N2582DFriesen Gary J · Mariposa, CABuilt 1952 · S/N 20734 N2583CWarner Mitchel K · Kodiak, AKS/N 26227 N2584CMoreman Wiley E · Willcox, AZBuilt 1954 · S/N 26228 N2585CGillum Colton M · Ontario, ORBuilt 1954 · S/N 26229 N2590DJenkins Richard E · Grants Pass, ORBuilt 1952 · S/N 20742 N2591DRootvik Dennis L · College Place, WAS/N 20743 N2592DSweet Warner Sr · Wakefield, RIBuilt 1952 · S/N 20744 N2594DSwift John P · Enfield, CTBuilt 1952 · S/N 20746 N2597CWintersteller Oliver · Brighton, MIBuilt 1954 · S/N 26241 N2597DFly48north LLC · Lynden, WABuilt 1952 · S/N 20749 N2598CMorris Thomas B · Imlay City, MIBuilt 1954 · S/N 26242 N2599CHoneysett Robert E Jr · Wasilla, AKS/N 26243 N2599DSmith Michael E · Willits, CABuilt 1952 · S/N 20751 N2600DJudge Eli A · Whitefish, MTBuilt 1952 · S/N 20752 N2601DHerrmann Mark D · Dillingham, AKS/N 20753 N2602DAllen Matt · Bullhead City, AZS/N 20754 N2604DO4dflys LLC · Enterprise, ORBuilt 1952 · S/N 20756

Back to Cessna 170B