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.

N9188CVail Jeffrey J · Rexburg, IDS/N 31287 N9189CJastram Benjamin C · Lafayette, LABuilt 1954 · S/N 31288 N9191CBash Dennis W Jr · Wasilla, AKBuilt 1954 · S/N 31290 N9192CBellamy Mark A · Freeville, NYBuilt 1955 · S/N 31291 N9197CWood Steven · Morgan, UTBuilt 1954 · S/N 31296 N9198CSmith Rickey J · Port Saint Joe, FLBuilt 1954 · S/N 31297 N9202TLander David W · Gilroy, CABuilt 1959 · S/N 50702 N9203CSamuel James F · Port Byron, NYS/N 31302 N9206CFontenot Mitchell · Kalispell, MTBuilt 1955 · S/N 31305 N9207CRadford Kathleen E · Anchorage, AKS/N 31306 N9208CKinzie Hon K · Anchorage, AKBuilt 1954 · S/N 31307 N9209CTuckfield Brent M · Monroe, WAS/N 31308 N9213CGriffith Thomas J · Watertown, MNBuilt 1955 · S/N 31312 N9214CSchumacher Gregory L · Anchorage, AKS/N 31313 N9215CIrlbeck Joshua W · Northfield, MNBuilt 1954 · S/N 31314 N9219COtt Tucker Kyle · Belgrade, MTBuilt 1955 · S/N 31318 N9221CCruson Michelle E · Ontario, ORBuilt 1955 · S/N 31320 N9230CHayden Daniel · North Pole, AKBuilt 1955 · S/N 31329 N9232CIrwin Richard C · Bedias, TXBuilt 1955 · S/N 31331 N9233CMcgrew Robin L · El Cajon, CABuilt 1955 · S/N 31332 N9240CMcbeth Seth C · South Salt Lake, UTBuilt 1955 · S/N 31339 N9241CBaranek Brian Patrick · Nikiski, AKBuilt 1955 · S/N 31340 N9246CReynolds Cody P · Sun City, CABuilt 1955 · S/N 31345 N9248CRegistered aircraftBuilt 1955 · S/N 31347 N9252CBartels Aaron J · Brenham, TXBuilt 1955 · S/N 31351 N9259CHauser Linda L · Ulysses, KSBuilt 1955 · S/N 31358 N9260CWilson Benjamin W · Carrollton, TXBuilt 1955 · S/N 31359 N9265CComerford John W · Pagosa Springs, COBuilt 1955 · S/N 31364 N9269TAlsworth Leon R · Port Alsworth, AKBuilt 1960 · S/N 50769 N9271CSowder Douglas A · Spokane, WABuilt 1955 · S/N 31370 N9277CIrwin Phillip R · Parker, COBuilt 1955 · S/N 31376 N9286CQueen City Flying LLC · Helena, MTBuilt 1955 · S/N 31385 N9288CChase Michael D · Albuquerque, NMBuilt 1955 · S/N 31387 N9291CMadland Patrick S · Anchorage, AKBuilt 1955 · S/N 31390 N9293CHayes Dennis Paul · Des Moines, IABuilt 1955 · S/N 31392 N9294CBoulder Valley Aviation Inc · Boulder, COS/N 31393 N9295CLesmeister Dean J · Kindred, NDBuilt 1955 · S/N 31394 N9296CDinstel Delbert F · Park City, MTBuilt 1955 · S/N 31395 N929FRacoon Aviation LLC · San Antonio, TXBuilt 1953 · S/N 30188 N92CPSlattery Richard E · Fountain Valley, CABuilt 1953 · S/N 30019 N9303TBaxter Patrick L · Frisco, COS/N 50803 N9305CLinn Michael A · Nisswa, MNBuilt 1955 · S/N 31703 N9306CKoehrer Ernie · Palmer, AKBuilt 1955 · S/N 31704 N9307CJrs Buena Vida LLC · College Station, TXBuilt 1955 · S/N 31705 N9308CCameron Thomas J · Stanchfield, MNBuilt 1955 · S/N 31706 N9314CThielker Mark Robert · Bellaire, TXBuilt 1955 · S/N 31712 N9315C15charlie LLC · Soldotna, AKBuilt 1955 · S/N 31713 N9317CSixus LLC · Fairfax, VABuilt 1955 · S/N 31715 N9320CRiley Coda L · Beaumont, TXBuilt 1955 · S/N 31718 N9324CWillig Zachary · Angola, INBuilt 1955 · S/N 31722

Back to Cessna 180