Skip to content

Registered aircraft · 513

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 ('2072304')
  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 ('2072304')
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.

N5588CManchester Stephen D · Raynham, MABuilt 1950 · S/N 19642 N5592CGrah David B · Bishop, CABuilt 1950 · S/N 19821 N5596CPatterson Morgan B · Yuma, AZBuilt 1950 · S/N 19650 N5597CAom Aircraft LLC · Wilmington, DEBuilt 1950 · S/N 19651 N5599CBenien Dennis A · Napoleon, OHBuilt 1950 · S/N 19653 N56GCziraky Michael T · Brookhaven, PABuilt 1949 · S/N 19099 N5706CWhetstone Ronald · Bryant, INBuilt 1950 · S/N 19660 N5707CTeufel Gregory W · Lake Stevens, WABuilt 1950 · S/N 19661 N5708CFrazee John F · Fabius, NYBuilt 1950 · S/N 19662 N5709CLindsey Robert J · Baldwinsville, NYBuilt 1950 · S/N 19663 N5711CBrian Murray J · Pekin, ILBuilt 1950 · S/N 19665 N5712CFenton Jonathan B · Oregon City, ORBuilt 1950 · S/N 19666 N5713CWheaton Laramie · Iola, TXBuilt 1950 · S/N 19667 N5720CWienk Cody · Bellevue, NES/N 19826 N5722CNeumann John F · Walden, NYBuilt 1950 · S/N 19676 N5723CMid Pacific Aero Services LLC · Wahiawa, HIBuilt 1951 · S/N 19677 N5724CRegistered aircraftS/N 19827 N5726CPurcell Kim L · Placerville, CABuilt 1950 · S/N 19680 N5731CSmith Michael E · Willits, CABuilt 1951 · S/N 19685 N5732CHoulton Timbre R · Fairbanks, AKBuilt 1950 · S/N 19686 N5733CDuea Michael J · Savage, MNBuilt 1950 · S/N 19687 N5738CRegistration Pending · Sioux Falls, SDRegistration pendingBuilt 1950 · S/N 19692 N5739CHellie Andrew B · College Place, WABuilt 1950 · S/N 19693 N5745CShriver Michael C · Caledonia, ILBuilt 1950 · S/N 19699 N5746CHince Ambrose · East Troy, WIBuilt 1950 · S/N 19700 N5748CRigos George N · Whistler BcNon-citizen corporation, flight hours not reportedBuilt 1950 · S/N 19702 N5752CNoyes Jeffery A · Bridgeport, TXBuilt 1950 · S/N 19706 N5756CFly48north LLC · Lynden, WABuilt 1950 · S/N 19710 N5758CFour Mound LLC · Kennewick, WABuilt 1952 · S/N 19712 N5760CHenson Robert H Jr · Lanark, ILBuilt 1950 · S/N 19714 N5762CColescott Zachary · Cleveland, TNBuilt 1950 · S/N 19716 N5765CFinnegan John J · North Fort Myers, FLBuilt 1950 · S/N 19719 N5766CMacgregor David A Jr · Naples, FLBuilt 1950 · S/N 19720 N5768CJones Gary A · Huron, SDBuilt 1950 · S/N 19722 N5776CBuchanan William A · Snohomish, WABuilt 1950 · S/N 19730 N5777CZola Harry · Wasilla, AKS/N 19731 N5781CSipple Ronald W Jr · Gardner, KSBuilt 1950 · S/N 19735 N5782COsborne Don R · Fairbury, NEBuilt 1950 · S/N 19736 N5786CCarr Rebecca N · Willow, AKFirst renewal noticeBuilt 1950 · S/N 19740 N5789CHeineken Chad H · Fairbanks, AKBuilt 1950 · S/N 19743 N5790CThompson Dan L · Fargo, NDBuilt 1950 · S/N 19744 N5792CCampbell Peter R · Edgewater, FLBuilt 1950 · S/N 19746 N5793CDobyns Jesse · Ethel, WABuilt 1951 · S/N 19837 N5795CHancock James T · South Saint Paul, MNBuilt 1950 · S/N 19839 N5796CJohnson Terry A · Idaho Falls, IDBuilt 1950 · S/N 19750 N5797CNorris Terry F · Rockford, ILBuilt 1950 · S/N 19751 N5799CLewellen Donnie J · Friona, TXBuilt 1950 · S/N 19753 N5LPMeeks Trevor · Vineburg, CABuilt 1950 · S/N 19695 N60CHCutler Scott D · Tumwater, WABuilt 1950 · S/N 19535 N6477CRains David O · El Paso, TXS/N 19304

Back to Cessna 170A