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.

N3162BHoulton Timbre R · Fairbanks, AKBuilt 1952 · S/N 25404 N3163BLewis Blake C · Columbia, MOBuilt 1952 · S/N 25405 N3164AAlstrom Ragnar O · Alakanuk, AKBuilt 1953 · S/N 25808 N3166AChamberlin Aviation LLC · East Wenatchee, WABuilt 1953 · S/N 25810 N3166BSteinman Barry L · Leo, INBuilt 1952 · S/N 25408 N3167AWells Mark L · Eads, TNBuilt 1953 · S/N 25811 N3167BCarelli Paul Anthony · Bonners Ferry, IDBuilt 1952 · S/N 25409 N3172BBeon Robert L · Belgrade, MES/N 25414 N3173BHaynes Stefen L · Homer, AKBuilt 1952 · S/N 25415 N3175BSmith Robert J · Easton, PABuilt 1952 · S/N 25417 N3176AHalbeisen Robert C · Fairbanks, AKBuilt 1953 · S/N 25820 N3179BLevin Lawrence E · North Pole, AKBuilt 1952 · S/N 25421 N317KGGouvin Gregory A · West Suffield, CTS/N 25282 N3180ARoss Ranch & Livestock Co · Jordan, MTBuilt 1953 · S/N 25824 N3184BCerisano Kevin · Trussville, ALBuilt 1952 · S/N 25426 N3185BThomas Coby M · Fairbanks, AKBuilt 1953 · S/N 25427 N3187BRitchie Robert E · Centennial, COBuilt 1953 · S/N 25429 N3188AReints Rydell J · Wasilla, AKBuilt 1953 · S/N 25832 N3190BThomas Peter G Trustee · Reno, NVBuilt 1953 · S/N 25432 N3191BMason Fred B · Waterford, OHBuilt 1952 · S/N 25433 N3192BKnutson David R · Girdwood, AKBuilt 1952 · S/N 25435 N3193AWeir Dale L · Kent, WABuilt 1953 · S/N 25837 N3195AHoward Neil B · Gorin, MOBuilt 1953 · S/N 25839 N3197BLavell Michael J · Blue Mounds, WIS/N 25440 N3198AAdams Peter B · Anchorage, AKBuilt 1953 · S/N 25842 N3198BHerman Timothy R · Presho, SDBuilt 1953 · S/N 25441 N3200CRegistered aircraftBuilt 1953 · S/N 25833 N3203ALowenstein Jeffrey · Juneau, AKBuilt 1953 · S/N 25847 N3205ARichards Peter C · Poughkeepsie, NYBuilt 1953 · S/N 25849 N3207AMarin Jeremy V · Gardnerville, NVS/N 25851 N3208AKreitel Cody James · Anchorage, AKBuilt 1953 · S/N 25852 N3211AFreeman Varel D · Ocala, FLBuilt 1953 · S/N 25855 N3215AHoffmeyer Scott D · Carson City, NVBuilt 1953 · S/N 25859 N3224ARoy Timothy R · Cottrellville, MIBuilt 1953 · S/N 25868 N3225ASantacroce Anthony M · Cedar Rapids, IABuilt 1953 · S/N 25869 N3231AStafford Robert H · Orlando, FLBuilt 1953 · S/N 25875 N3232AKnutson Daniel T · Lodi, WIBuilt 1953 · S/N 25876 N3233AWalser Kyle · Midwest City, OKBuilt 1953 · S/N 25877 N3234ARobold Andrew D · Redmond, ORBuilt 1953 · S/N 25878 N3241AAirway Science For Kids Inc · Portland, ORBuilt 1953 · S/N 25885 N3243AChristie Bruce W · Wasilla, AKBuilt 1953 · S/N 25887 N3244APrevail Aviation LLC · Hurley, WIBuilt 1953 · S/N 25888 N3245AMoseley Deborah M · Homer, AKBuilt 1953 · S/N 25889 N3252ABuddenberg Bradford C · Anchorage, AKBuilt 1953 · S/N 25896 N3259AHalle Michael P · Livingston, TXBuilt 1953 · S/N 25903 N3268USchafer Gerhard Walter · Fairbanks, AKS/N 20956 N3271AJohnson Jackson B · Wasilla, AKBuilt 1953 · S/N 25915 N3277ALandry Anthony H · Port Orchard, WABuilt 1953 · S/N 25921 N3283AHarrison Donald R · Lake Havasu City, AZBuilt 1953 · S/N 25927 N3287ASpetman Craig Warren · Overgaard, AZS/N 25931

Back to Cessna 170B