Skip to content

Registered aircraft · 1,177

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

N3131DLeggett Brandon L · Gatesville, TXFirst renewal noticeS/N 31929 N3134DHanson Parry B · Eagle Creek, ORBuilt 1955 · S/N 31932 N3135CVeech Shawn M · Big Lake, AKBuilt 1954 · S/N 30934 N3135DSkycavu Inc · Hi Rls Mtn Pk, NMNon-citizen corporation, flight hours not reportedBuilt 1955 · S/N 31933 N3136CPark Avenue Group Inc · Stuart, FLBuilt 1954 · S/N 30935 N3137CKlausler Thomas W · Lakeville, MNBuilt 1954 · S/N 30936 N3139DGuichard Lawrence · Spokane, WABuilt 1955 · S/N 31937 N313DQIler Elden · Van Nuys, CAS/N 32533 N3140CAthens William A · Missoula, MTBuilt 1954 · S/N 30939 N3141DNelson Donald W · Aurora, COBuilt 1955 · S/N 31939 N3142CItm Electronics Inc · Greenleaf, IDBuilt 1954 · S/N 30941 N3147CSchlutz Ivan F · Longmont, COBuilt 1954 · S/N 30946 N3148CFreund Timothy P · Mesa, AZBuilt 1954 · S/N 30947 N3150DTransmountain Aviation Inc · Kasilof, AKBuilt 1955 · S/N 31948 N3151DVan Aero LLC · Dover, DEBuilt 1955 · S/N 31949 N3153CCulver Marc D · Anchorage, AKBuilt 1954 · S/N 30952 N3153DN3153d LLC · Middletown, DEBuilt 1955 · S/N 31951 N3154CMitchell Barry C · Sagle, IDBuilt 1954 · S/N 30953 N3154DJohnson Daniel P · Pardeeville, WIS/N 31952 N3155CNolan Michael William Jr · Silver Spring, MDBuilt 1954 · S/N 30954 N3155DNervino Blake · Turlock, CABuilt 1955 · S/N 31953 N3156CMarshall Robert L · Pine River, MNBuilt 1954 · S/N 30955 N3161CFinzer Melvern K · Naperville, ILBuilt 1954 · S/N 30960 N3162DMarks Daniel A · Portersville, PABuilt 1955 · S/N 31960 N3164DCallahan Robert D · Mesa, AZBuilt 1955 · S/N 31962 N3166CPersinger Paul W · Wasilla, AKBuilt 1954 · S/N 30965 N3167DOrtlip Stephen A · Kenbridge, VABuilt 1955 · S/N 31965 N3168CRegistration Pending · Anchorage, AKRegistration pendingS/N 30967 N3168DBovee John W Or · San Diego, CABuilt 1955 · S/N 31966 N3171CLand Sea & Air Inc · North Mankato, MNBuilt 1954 · S/N 30970 N3171DJohnson Donald B · Lino Lakes, MNBuilt 1955 · S/N 31969 N3173CMcgaha Justin L · Hooker, OKS/N 30972 N3174DRegistered aircraftBuilt 1955 · S/N 31972 N3175CClay Jason I · Imperial Beach, CABuilt 1954 · S/N 30974 N3176CYoung Thomas O · Battle Ground, WABuilt 1954 · S/N 30975 N3178DSager Kenneth A · Hummelstown, PABuilt 1955 · S/N 31976 N3179CWoods Kevin M · Spokane, WABuilt 1954 · S/N 30978 N3179DPreiss James M Trustee · Poplar Grove, ILBuilt 1955 · S/N 31977 N3180DKleimer Steve · Bozeman, MTBuilt 1955 · S/N 31978 N3181CFour Boys Aviation LLC · Madison, MSFirst renewal noticeBuilt 1954 · S/N 30980 N3182DHanft Thomas A · Oakhurst, CABuilt 1955 · S/N 31980 N3183DT2k Aircraft · Austin, TXBuilt 1955 · S/N 31981 N3184DRitchie Rex W · Lopez Island, WABuilt 1955 · S/N 31982 N3185DMorgan Douglas C · Anchorage, AKBuilt 1955 · S/N 31983 N3186DSutton Aircraft Salvage LLC · Palmer, AKBuilt 1955 · S/N 31984 N3187CHemm Colby L · Newcastle, CABuilt 1954 · S/N 30986 N3189CSmith David J · Duluth, MNBuilt 1954 · S/N 30988 N3190DDooyema Eric · Spokane, WABuilt 1955 · S/N 31988 N3191CVaneau Phillip M · Wasilla, AKBuilt 1954 · S/N 30990 N3193DOrth Henry J · Wasilla, AKBuilt 1955 · S/N 31991

Back to Cessna 180