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.

N2852CBrenneman James M · Carrboro, NCBuilt 1954 · S/N 26395 N2854CHazen Alan L · Rifle, COBuilt 1954 · S/N 26397 N2855CItoi Timotheus Y · Yona, GUBuilt 1954 · S/N 26398 N2856CGermaine David R · West Orange, NJBuilt 1954 · S/N 26399 N2857CHackamore Equipment LLC · Prairie City, SDBuilt 1954 · S/N 26400 N2859CWalston Glenn P · Fairbanks, AKBuilt 1954 · S/N 26402 N2864CRegistration Pending · Bloomington, ILRegistration pending, pending cancellationBuilt 1954 · S/N 26407 N2867CPlatt Ranch Inc · Kim, COBuilt 1954 · S/N 26410 N2868CWhiteley David N · Graham, TXBuilt 1954 · S/N 26411 N2873CHart John E · West Yellowstone, MTBuilt 1954 · S/N 26416 N2874CLarson Ivan · Parker, AZBuilt 1954 · S/N 26417 N2877CCarlson John R · Plainfield, WIBuilt 1954 · S/N 26420 N2878CGullion Joshua A · Weldona, COBuilt 1954 · S/N 26421 N2880CBuchert Allen C · Grand Rapids, MNBuilt 1954 · S/N 26423 N2881CCompton Steven · Anchorage, AKBuilt 1954 · S/N 26424 N2884CKuehn Wilton H III · Turtle Lake, NDBuilt 1954 · S/N 26427 N2885CCassee Udo · Anchorage, AKBuilt 1954 · S/N 26428 N2886CParks Walter G · Chugiak, AKBuilt 1954 · S/N 26429 N2887CKris Noone Air LLC · Wilmington, DEBuilt 1954 · S/N 26430 N2889CStowell Ronald A · Westminster, COBuilt 1954 · S/N 26432 N2890CSpenchen Holdings LLC · Arnaudville, LAS/N 26433 N2891COconnell Edward P · Killingworth, CTBuilt 1954 · S/N 26434 N2892CPatrick John A · Los Molinos, CABuilt 1954 · S/N 26435 N2899CMattison Mathew J · Amberg, WIBuilt 1954 · S/N 26442 N2901DMaples Jeffrey · Wilmington, DEBuilt 1955 · S/N 26844 N2902DRoss Charles E · Tuscola, TXBuilt 1955 · S/N 26845 N2904DBeckens Scott A · Sodus, NYBuilt 1955 · S/N 26847 N2906DKennedy Ken · Lubbock, TXBuilt 1955 · S/N 26849 N2909DPainter Kelly A · Cantwell, AKBuilt 1955 · S/N 26852 N2910DDomke Daniel Carl · Anchorage, AKS/N 26857 N2912DSatanta Flying Service Inc · Satanta, KSS/N 26855 N2913DSale Reported · Nome, AKSale reportedS/N 26856 N2915DUlrich Craig T · Albany, ORS/N 26858 N2916DWatkins Brad D · Roseburg, ORBuilt 1955 · S/N 26859 N2917DYoung Michael E · Munroe Falls, OHBuilt 1955 · S/N 26860 N2920DYarbrough Deborah C · Somerville, TNBuilt 1955 · S/N 26863 N2921DErlandson Lloyd V · Hilmar, CABuilt 1955 · S/N 26864 N2923DHurd Nathan A · Lisbon Falls, MEBuilt 1955 · S/N 26866 N2928DMatheny Kimberly D · Washington, WVS/N 26871 N2929NPekkala Ross F · Palmer, AKS/N 25545 N2930DGuerin Stephen · Lyme, NHBuilt 1955 · S/N 26873 N2932DDont Make Things Difficult LLC · Downers Grove, ILS/N 26875 N2934DHennis Jess L · Cottonwood, IDBuilt 1955 · S/N 26877 N2935DMorris Mark A · Westlake, TXBuilt 1955 · S/N 26878 N2936DKrish Air LLC · Louisville, KYBuilt 1955 · S/N 26879 N2937DCoffman Robert P · Bigfork, MTBuilt 1954 · S/N 26880 N2939DHarold Robert E · Fairbanks, AKBuilt 1955 · S/N 26882 N2940DRoesbery Charles J Jr · Cordova, AKBuilt 1955 · S/N 26883 N2942DBeasley William J Jr · Spring Hill, TNBuilt 1955 · S/N 26885 N2944DWeaver Brian J · Livingston, TXBuilt 1955 · S/N 26887

Back to Cessna 170B