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.

N2341DWeniger Gregory M · Burrton, KSBuilt 1952 · S/N 20493 N2343DShannon Jon M · Conroe, TXBuilt 1952 · S/N 20495 N2344DGough William N · Vancouver, WAS/N 20496 N2345DTravelaire Service Inc · Pueblo, COBuilt 1952 · S/N 20497 N2345VEder Samuel A · Fayetteville, NCS/N 25056 N2346DSasser Bradley B · Cumming, GABuilt 1952 · S/N 20498 N2348DNorthern Aviation LLC · Palmer, AKBuilt 1955 · S/N 20500 N2349DFedorka Paul R Trustee · Soldotna, AKBuilt 1952 · S/N 20501 N2351DPernic David R · Stoughton, WIBuilt 1952 · S/N 20503 N2352DOptima Aviation LLC DBA · Lewisville, TXBuilt 1952 · S/N 20504 N2353DJensen Carl V · Raleigh, NCBuilt 1952 · S/N 20505 N2354DRegistered aircraftBuilt 1952 · S/N 20506 N2355DWest Coast Aerosport Inc · Dove Canyon, CAS/N 20507 N2356DKirsipuu Paul W · Voluntown, CTBuilt 1952 · S/N 20508 N2358DStofer William · Warsaw, INS/N 20510 N2363DCross John P · Houston, TXBuilt 1952 · S/N 20515 N2366DSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1952 · S/N 20518 N2367DBushey Abel · Barnet, VTBuilt 1952 · S/N 20519 N2369DAbbott Dylan L · Lompoc, CAS/N 20521 N2370DPoeppelman Philip W · Versailles, OHBuilt 1952 · S/N 20522 N2372DTucker Matthew T · Dillingham, AKS/N 20524 N2375DGauntt Chep · Goodyear, AZBuilt 1952 · S/N 20527 N2379DMoore Orville G · Hays, KSBuilt 1952 · S/N 20531 N2380DKovalchik Janet N Trustee · Kernersville, NCBuilt 1952 · S/N 20532 N2381DShryock Jennifer M · King Salmon, AKS/N 20533 N2385DHurst Gerald W · Bigfork, MTBuilt 1952 · S/N 20537 N2386DTitan Aero LLC · Wilmington, DEBuilt 1952 · S/N 20538 N2390DNorman James C · Laguna Niguel, CABuilt 1952 · S/N 20542 N2393DSoares Manuel J · Wasilla, AKBuilt 1952 · S/N 20545 N2394DRegistration Pending · Fort Ripley, MNRegistration pendingBuilt 1952 · S/N 20546 N2396DClark Patrick L · Kenai, AKS/N 20548 N2397DQuast George Walter · Hutchinson, MNBuilt 1952 · S/N 20549 N2398DHenkelmann David H · Janesville, WIBuilt 1952 · S/N 20550 N2399DAllison Clay M · San Angelo, TXBuilt 1952 · S/N 20551 N23JFSimba Air LLC · Mt Juliet, TNBuilt 1955 · S/N 26778 N2400DCrummett James F · Redding, CABuilt 1952 · S/N 20552 N2407RMyers William J · Colfax, WABuilt 1955 · S/N 26784 N2410DWeaver James C · Boise, IDFirst renewal noticeBuilt 1952 · S/N 20562 N2411DBinsky Lawrence A · Bexley, OHS/N 20563 N2414DSmith Nathias N · Weiser, IDS/N 20566 N2418DRogers Colin · Nevada City, CABuilt 1952 · S/N 20570 N2419DHansen Michael C · Roseville, CABuilt 1952 · S/N 20571 N2420DThomas Ryan J · Anchorage, AKBuilt 1952 · S/N 20572 N2423DWatkins Veronica J Trustee · Sparks, NVBuilt 1952 · S/N 20575 N2426DPalmer Bryon · Fall City, WABuilt 1952 · S/N 20578 N2430DDonahue Michael W · Sidney, MTBuilt 1952 · S/N 20582 N2431DHanson Willow L · Nome, AKBuilt 1952 · S/N 20583 N2434DHess Joel M · Allenwood, PABuilt 1952 · S/N 20586 N2435DThibodeau Dean U · North Pole, AKBuilt 1952 · S/N 20587 N2436DSutton Aircraft Salvage LLC · Palmer, AKS/N 20588

Back to Cessna 170B