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.

N8033AColagross Levi · Beaverton, ORBuilt 1952 · S/N 20885 N8037ALongacre Christopher W · Chugiak, AKBuilt 1952 · S/N 20889 N8039AKenefick Christopher K · Rosamond, CABuilt 1952 · S/N 20891 N8045ASalter James M · Crested Butte, COBuilt 1952 · S/N 20897 N8048AWilson Earl William · Rockford, ILBuilt 1952 · S/N 20900 N8051AB C Aviation LLC · Ketchum, IDBuilt 1952 · S/N 20903 N8053AAero Aviation LLC · Summit, MSBuilt 1952 · S/N 20905 N8054ABarsamian Aaron · Sterling, AKBuilt 1952 · S/N 20906 N8057AP P & J LLC · Gillette, WYBuilt 1952 · S/N 20909 N8063ACarleton Jeffrey S · Palmer, AKBuilt 1952 · S/N 20915 N8071AVintage Aircraft Sales LLC · Radnor, OHBuilt 1952 · S/N 20923 N8072AWhitson Gerry B · Taylorsville, KYBuilt 1952 · S/N 20924 N8073ABrumbaugh David R · Meeker, COBuilt 1952 · S/N 20925 N8074AEshelman Douglas W · Franklin, TNBuilt 1952 · S/N 20926 N8075AParrett Lincoln S · Fairbanks, AKBuilt 1952 · S/N 20927 N8077ADaly William J · Minnesota Lake, MNBuilt 1952 · S/N 20929 N8078ALeonard Willis Thomas · Vacaville, CABuilt 1952 · S/N 20930 N8079ARegistered aircraftBuilt 1952 · S/N 20931 N8081ACorn Michael Lee · Wilmington, NCBuilt 1952 · S/N 20933 N8084ARegistration Pending · Madison, NHRegistration pendingBuilt 1952 · S/N 20936 N8086ANievin Garrett P · Ashburn, VABuilt 1952 · S/N 20938 N8087ARichards Vincent C · Deland, FLBuilt 1952 · S/N 20939 N8091AHonrud Joseph C · Cal Nev Ari, NVBuilt 1952 · S/N 20943 N8098AGann Clifton T · Guthrie, OKBuilt 1952 · S/N 20950 N80CAThomson Ian W · Anchorage, AKBuilt 1952 · S/N 20301 N8102ABuck Randall J · Greenfield, INFirst renewal noticeS/N 20954 N8103ACronk Kenneth B · Woodrow, COBuilt 1952 · S/N 20955 N8107AE=Mc2 LLC · Prescott Valley, AZBuilt 1952 · S/N 20959 N8108ACraig Benjamin C · Wasilla, AKBuilt 1952 · S/N 20960 N8109AWatkins Brian · Bowling Green, KYBuilt 1952 · S/N 20961 N8113AEllis Jeffrey C · Davis, ILBuilt 1952 · S/N 20965 N8117AJago River Holdings LLC · Fairbanks, AKBuilt 1952 · S/N 20969 N8119AHuling Lawrence K · Wasilla, AKBuilt 1952 · S/N 20971 N8120AGladden David G · Wasilla, AKBuilt 1952 · S/N 20972 N8122APerkins Christopher R · Brackettville, TXBuilt 1952 · S/N 20974 N8123AEgmond Aircraft LLC · Lewes, DEBuilt 1952 · S/N 20975 N8126TBergland John Edward · Santa Monica, CABuilt 1952 · S/N 20952 N8132AProell Eric R · Fairbanks, AKBuilt 1952 · S/N 20984 N8136ARedman Thomas F · Talkeetna, AKBuilt 1952 · S/N 20988 N8138ANelson Richard W · Edna, TXBuilt 1952 · S/N 20990 N813MDHanks Thomas M · Carlsbad, CABuilt 1953 · S/N 25957 N8142AKiel Donald G · Whitelaw, WIBuilt 1952 · S/N 20994 N8143ALiimatainen William J · Monroe, WIBuilt 1952 · S/N 20995 N8145AAllen John Jay · Bloomington, ILBuilt 1952 · S/N 20997 N8151AHayes James R · Sonora, CABuilt 1952 · S/N 25003 N8152AMattoon Michael · Santa Fe, NMBuilt 1952 · S/N 25004 N8153AKaulback Joseph F · Andover, CTS/N 25005 N8156AReetz Duane W · Clintonville, WIBuilt 1952 · S/N 25008 N8157ARidge Bryan T Trustee · San Diego, CABuilt 1952 · S/N 25009 N8161ABuck Robert O · Waterbury Center, VTFirst renewal noticeBuilt 1952 · S/N 25013

Back to Cessna 170B