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.

N543ARHoffman Elliott R · Bethel, AKS/N 20704 N5562AWiley Calvin B · Summer Shade, KYS/N 20315 N5593MWeaver Carl W · Halstead, KSS/N 26967 N55LHL H Aviation LLC · Clanton, ALBuilt 1955 · S/N 26927 N561FEffenberger Anthony J · Mankato, MNBuilt 1955 · S/N 26678 N5949VElkhorn Creek Aviation 3 LLC · Georgetown, KYBuilt 1954 · S/N 20920 N5954VBown Leah R · Belgrade, NEBuilt 1954 · S/N 26405 N595DLieberg Craig · Clear Lake, MNS/N 20747 N60660Nichols William · Wild Rose, WIS/N 26868 N6095VCessna 170b LLC · Eagle River, AKS/N 20724 N60PEMagliacano Matthew J · Cleveland, MOFirst renewal noticeBuilt 1952 · S/N 20799 N611CKovalesky James · Clayton, NCBuilt 1955 · S/N 26895 N621BKMy170b LLC · Everett, WAS/N 20819 N624JACobb Jason L · Lancaster, OHS/N 25500 N625WEHarger Aviation LLC · Richmond, TXBuilt 1952 · S/N 20283 N6267CTholl Robert E · Morristown, NJBuilt 1952 · S/N 20490 N65DGDeschweinitz Christian R · Anchorage, AKBuilt 1954 · S/N 26210 N6847DPietron Spraying Inc · Larimore, NDBuilt 1952 · S/N 25196 N688PAJoe P Fassio · Union, WABuilt 1953 · S/N 25535 N6942HW Lance Orr · Gig Harbor, WABuilt 1952 · S/N 20329 N6946CRegistration Pending · Fairbanks, AKRegistration pending, canceledBuilt 1953 · S/N 25522 N707REHamm Mark W · Eagle River, AKBuilt 1952 · S/N 20389 N714EYStevens Matthew S · Penn Yan, NYBuilt 1953 · S/N 25668 N726AMRegistered aircraftBuilt 1953 · S/N 26009 N7272KPearson Zachary B · Hayden, IDBuilt 1952 · S/N 20412 N727ZTeam Alaska LLC · Anchorage, AKBuilt 1953 · S/N 25542 N72RRoam Airlines LLC · Eugene, ORBuilt 1952 · S/N 20904 N737WFMainero Tanner R · Chehalis, WABuilt 1952 · S/N 25346 N74036Pallen William T · Fargo, NDS/N 25506 N74887Mroz Kaitlin J · Haslet, TXBuilt 1953 · S/N 25853 N751LSSimpson Simpson Inc · Castana, IABuilt 1954 · S/N 26462 N769MFielding Floyd M · Owasso, OKS/N 26962 N7760CSosa Leonardo Correa Luna · Stillwater, MNS/N 20520 N7836KKennedy Brent Robert · Anchorage, AKBuilt 1952 · S/N 20631 N796WTTaildragger LLC · Blackfoot, IDBuilt 1955 · S/N 26813 N8000ABonnette William A · Gill, MABuilt 1952 · S/N 20852 N8004ABernhardt Michael J · North Branch, MNBuilt 1952 · S/N 20856 N8005AWalker Aviation LLC · Big Timber, MTBuilt 1952 · S/N 20857 N8009AMiles Austin B · Bend, ORBuilt 1952 · S/N 20861 N8010ATaylor Michael A · Pipestone, MNBuilt 1952 · S/N 20862 N8013ATrade Winds Aviation Holdings LLC · Lewes, DEBuilt 1952 · S/N 20865 N8014AMcdaniel Leigh W · Orland, CABuilt 1952 · S/N 20866 N8016APak Holdings LLC · Anchorage, AKBuilt 1952 · S/N 20868 N8017ABue Brian G · Palmer, AKBuilt 1952 · S/N 20869 N8018AConley Ronald Dean Trustee · Lamoille, NVBuilt 1952 · S/N 20870 N8019AOlson Kenneth L · Raymond, WABuilt 1952 · S/N 20871 N8020AOakleaf Dan L · Hartford, SDBuilt 1952 · S/N 20872 N8022ABackus John · Norton Shores, MIBuilt 1952 · S/N 20874 N8027AWoodbury William L · Smithwick, SDBuilt 1952 · S/N 20879 N8031AJims Aviation LLC · Fairfield, IABuilt 1952 · S/N 20883

Back to Cessna 170B