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.

N2773DHattaway Gene · Double Oak, TXBuilt 1952 · S/N 25315 N2774DOutbound Aero LLC · Kiowa, COBuilt 1952 · S/N 25316 N2776DAtiyeh Aziz Matthew · Aumsville, ORS/N 25318 N2778DBaker Julius W · Anchorage, AKBuilt 1952 · S/N 25320 N2779DLumley Carol J · Eagle River, WIBuilt 1952 · S/N 25321 N2780CWheeler Russell E · Roxbury, CTBuilt 1954 · S/N 26324 N2780DChythlook Joseph L · Dillingham, AKS/N 25322 N2781CRoark Collin P · Franktown, COBuilt 1954 · S/N 26325 N2781LEllis Grover Dale Jr · Sanford, NCS/N 19266 N2782CGideon William W · Dayton, OHBuilt 1954 · S/N 26326 N2786COttolini Alexander C · College Grove, TNBuilt 1954 · S/N 26330 N2789CRegistered aircraftBuilt 1954 · S/N 26333 N2790DRegistered aircraftBuilt 1952 · S/N 25332 N2792CBerg Timothy J · Fairbanks, AKBuilt 1954 · S/N 26336 N2794DBrown Rayford K · Temple, TXBuilt 1952 · S/N 25336 N2795CCales Jack R · Edisto, SCBuilt 1954 · S/N 26339 N2796DFrance Gregory G · Alta Loma, CABuilt 1952 · S/N 25338 N2797DEberhart Wayne Willis · Amboy, MNBuilt 1952 · S/N 25339 N2799CTaylor James L · Lowell, ARBuilt 1954 · S/N 26343 N279MCMagic Carpet LLC · Wilmington, DEBuilt 1954 · S/N 26331 N2800CLinares Francisco E · Miami, FLBuilt 1954 · S/N 26590 N2802CHarris Timothy T · Belvidere, ILBuilt 1954 · S/N 26345 N2803CGrant Alison J · Rocklin, CAS/N 26346 N2805CYakubisin Jeffrey · Beach City, OHBuilt 1954 · S/N 26348 N2806CWells Nick M · Holdrege, NES/N 26349 N2809CNixon Ross M · Hillsboro, ORBuilt 1954 · S/N 26352 N2811CBeyer James C · Fayetteville, TNBuilt 1954 · S/N 26354 N2812CSmallwood Nathan M · Ellicott City, MDS/N 26355 N2813CFray Jonathan C · Wasilla, AKBuilt 1954 · S/N 26356 N2814CStone Robert D · Anchorage, AKBuilt 1954 · S/N 26357 N2815CCooper David A · Mc Kittrick, CAS/N 26358 N2818CSchmidt Wolf E · Anchorage, AKBuilt 1954 · S/N 26361 N2819CLanis Scott E · North Pole, AKBuilt 1954 · S/N 26362 N2822CNeverman Walter M · Albany, WIBuilt 1954 · S/N 26365 N2823CJones Adam · Fairbanks, AKBuilt 1954 · S/N 26366 N2824CReilly Richard J · St Paul, MNBuilt 1954 · S/N 26367 N2825CSouza Clifford A · Pattersonville, NYBuilt 1954 · S/N 26368 N2826CSolstice Joshua A · Anchorage, AKS/N 26369 N2831CMohar Fred B Jr · Turner, MTBuilt 1954 · S/N 26374 N2832CVandehei Linda I · Fairbanks, AKBuilt 1954 · S/N 26375 N2835CTroutman Charles W · Prineville, ORFirst renewal noticeBuilt 1954 · S/N 26378 N2837CPerris Valley Skydiving School Inc · Perris, CABuilt 1954 · S/N 26380 N2839CRegistered aircraftBuilt 1954 · S/N 26382 N2841CMonckton Geary S · Alvin, TXBuilt 1954 · S/N 26384 N2842CCollins Michael P · Ballwin, MOBuilt 1954 · S/N 26385 N2843CPacific Coast Air Museum · Santa Rosa, CAFirst renewal noticeS/N 26386 N2845COsterhout Joshua C · Prineville, ORS/N 26388 N2846CBranstner August M · Taft, CABuilt 1954 · S/N 26389 N2848CBenedict Michael T · Anchorage, AKBuilt 1954 · S/N 26391 N2850CToxvard Ludvig E III · Pueblo, COBuilt 1954 · S/N 26393

Back to Cessna 170B