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.

N3520CWallingford David P · Kenai, AKBuilt 1954 · S/N 26563 N3522DWaiwood Michael F · Strongsville, OHS/N 27065 N3523CRinio Tyson S · Ester, AKBuilt 1954 · S/N 26566 N3525CBrann Paul A · West Gardiner, MES/N 26568 N3526DBrooks Jason M · Eagle River, AKBuilt 1955 · S/N 27069 N3530DVande Sandt Lloyd A · Gildford, MTBuilt 1956 · S/N 27073 N3531CPlowman Benjamin W · Raleigh, NCBuilt 1954 · S/N 26574 N3532DUreneck Paul M · Gray, MEBuilt 1956 · S/N 27075 N3533CWestern North Carolina Air Museum · Hendersonville, NCBuilt 1954 · S/N 26576 N3534CHausback Brian Trustee · Sacramento, CABuilt 1955 · S/N 26577 N3534DWamsley Clayton O · Trimble, MOBuilt 1956 · S/N 27077 N3536DRush Ray A · Palmer, AKS/N 27079 N3537DGross Thomas E · Mooresville, NCBuilt 1956 · S/N 27080 N3538DConrad Daniel Robert · Sweet Home, ORS/N 27081 N3540DHardwick James Anthony · Pasadena, CABuilt 1956 · S/N 27083 N3542CRobertson Braxton Cecil · Selma, NCS/N 26585 N3543CMock Lurita M · Anderson, INBuilt 1954 · S/N 26586 N3544CAryana Arash · Livermore, CABuilt 1954 · S/N 26587 N3545DHudson Guy G · Chickaloon, AKS/N 27088 N3549CTappen Paul W · Delta Junction, AKS/N 26593 N3550CScott Mark A · Anchorage, AKS/N 26594 N3553CSavage Christopher H · Senaeca, SCBuilt 1954 · S/N 26597 N3554CHubert Pulley Car Sales Inc · Havelock, NCBuilt 1954 · S/N 26598 N3556DMarookian James R · Annandale, NJBuilt 1956 · S/N 27099 N3560CCarlson Michael W · Rockford, ILBuilt 1954 · S/N 26604 N3561CSand John C · Menomonie, WIBuilt 1954 · S/N 26605 N3564CMoe William A · Marysville, CABuilt 1954 · S/N 26608 N3565CBaumgartner Terry L · Lowell, MIBuilt 1954 · S/N 26609 N3565DJpn LLC · Park City, MTBuilt 1956 · S/N 27108 N3566CJones Barton F · Colorado Springs, COBuilt 1954 · S/N 26610 N3566DLucky Rose LLC · Brainerd, MNBuilt 1956 · S/N 27109 N3567CGrantham George F · Bush, LAS/N 26611 N3568CBourgoine Richard A · Conesus, NYBuilt 1954 · S/N 26612 N3570CKnutson Wayne R · Tioga, NDS/N 26614 N3571DSmith Brant C · Anchorage, AKS/N 27114 N3572CFrasca John A · Champaign, ILBuilt 1954 · S/N 26616 N3573DBohl Howard M Jr · Long Beach, CABuilt 1956 · S/N 27116 N3575DTufts Peter A · Bethel, CTBuilt 1956 · S/N 27118 N3576CRamaswamy Gautam · Clearwater, FLS/N 26620 N3576DVorpagel Stephen L · Readfield, MEBuilt 1956 · S/N 27119 N3577CCrystoff James J · Kodiak, AKBuilt 1954 · S/N 26621 N3579CA&J Aeronautics LLC · Nerstrand, MNS/N 26623 N3579DSchumacher Thad A · Wasilla, AKBuilt 1957 · S/N 27122 N3582CBenedict Larry D · Dexter, NMBuilt 1955 · S/N 26626 N3582DFrench Guy · Maple Valley, WABuilt 1956 · S/N 27125 N3584CSnyder Kathryn J · Sutherland, NEBuilt 1955 · S/N 26628 N3585CRachels Paul R · Tacna, AZBuilt 1955 · S/N 26629 N3589CPalmer Frederick W · Huntington Beach, CABuilt 1954 · S/N 26633 N3590CZwingmann Ken · Whittier, CABuilt 1955 · S/N 26634 N3591CSchlender Michael E · Clintonville, WIBuilt 1955 · S/N 26635

Back to Cessna 170B