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.

N3070AMacvey Troy R · Oxford, OHBuilt 1953 · S/N 25714 N3072AKinter Christopher A · Kodiak, AKBuilt 1953 · S/N 25716 N3073AHarder William J · Anchorage, AKBuilt 1953 · S/N 25717 N3077ATony Flies Inc · Sparta, NCS/N 25721 N3082ACatamount Aviation Inc · Marshfield, VTBuilt 1953 · S/N 25726 N3083AWheeler Paul E · Clayton, NMBuilt 1953 · S/N 25727 N3085AMerriman Joel W · North Pole, AKBuilt 1953 · S/N 25729 N3087ATaildragger Hq LLC · Melrose, FLBuilt 1953 · S/N 25731 N3091APeltier Eric M · North Pole, AKBuilt 1953 · S/N 25735 N3092ARainey Dennis D · Altus, OKBuilt 1953 · S/N 25736 N3093ASantana Paul D · Mont Vernon, NHS/N 25737 N3095AWaters Daniel J · Trion, GABuilt 1953 · S/N 25739 N3097ADc Aero LLC · Ramona, CAS/N 25741 N3098AWillford George A · Waterville, OHBuilt 1953 · S/N 25742 N3099AOlivieri Damian L · Monument, COBuilt 1953 · S/N 25743 N3101ACosta Felipe R · Charlotte, NCBuilt 1953 · S/N 25745 N3106BRegistered aircraftBuilt 1952 · S/N 25348 N3107ATindall Michael E · Wahpeton, IABuilt 1953 · S/N 25751 N3112BParslow Wayne · Puyallup, WABuilt 1952 · S/N 25354 N3115BKegley Gary L · Perrin, TXBuilt 1952 · S/N 25357 N3116ASchanche Carsten H · Marstons Mills, MABuilt 1953 · S/N 25760 N3119AMouw Trea C · Chino, CABuilt 1953 · S/N 25763 N3120BRustad Scott K · Minot, NDBuilt 1952 · S/N 25362 N3122AJohns William D · Lodi, CABuilt 1953 · S/N 25766 N3124AWolstenholme Robert · Line Lexington, PABuilt 1953 · S/N 25768 N3126ALutz Adam R · Kodiak, AKBuilt 1953 · S/N 25770 N3133AProppe Karl H · Needham, MAS/N 25777 N3133BLeighton Robert L · Mattituck, NYBuilt 1952 · S/N 25375 N3134APierce Harmon A · Fenton, MIBuilt 1953 · S/N 25778 N3134BGauger William A · Mesa, AZBuilt 1952 · S/N 25376 N3135AFlynn Sean M · Casselton, NDBuilt 1953 · S/N 25779 N3136AOrvin Sanden Inc · Wyndmere, NDBuilt 1953 · S/N 25780 N3136BEasley Brennan M · Wasilla, AKBuilt 1952 · S/N 25378 N3137BNorrick Daniel A · Mounds View, MNBuilt 1952 · S/N 25379 N3140ASzablowski Walter · Riegelsville, PABuilt 1953 · S/N 25784 N3141AHoppe Joel A · Mankato, MNBuilt 1953 · S/N 25785 N3141BGoettemoeller Matthew W · Oldtown, IDBuilt 1952 · S/N 25383 N3142AKrueger Robert C · Glenburn, MEBuilt 1953 · S/N 25786 N3143ASkyline Holdings LLC · Big Lake, AKBuilt 1953 · S/N 25787 N3149AOlson Karl D · Fairbanks, AKBuilt 1953 · S/N 25793 N314BWCooper Matthew A · Seattle, WABuilt 1952 · S/N 25389 N3151ADavis William G · Mercer, MEBuilt 1953 · S/N 25795 N3153ALea Robert W · Minter City, MSBuilt 1953 · S/N 25797 N3154BRegistration Pending · Turner, MTRegistration pending, pending cancellationBuilt 1952 · S/N 25396 N3156ANorth American Aero LLC · Madison, NEBuilt 1953 · S/N 25800 N3157AToyon Properties LLC Series N3157a · Waco, TXBuilt 1953 · S/N 25801 N3158BFischer Gregory · Willow, AKBuilt 1952 · S/N 25400 N3159ARichards Lyle · San Diego, CABuilt 1953 · S/N 25803 N3160ABarnes Donald W · Sunriver, ORBuilt 1953 · S/N 25804 N3161BEisele Grant · Gresham, ORBuilt 1952 · S/N 25403

Back to Cessna 170B