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.

N3650CTotty Michael N · Gainesville, MOBuilt 1954 · S/N 31148 N3653CDomingquez Clara · Anchorage, AKBuilt 1954 · S/N 31151 N3654CRose Hugh S · Fairbanks, AKBuilt 1954 · S/N 31152 N3655CViavant Toby S · Ester, AKBuilt 1954 · S/N 31153 N3659CWhite Paul S · Clarksville, TNBuilt 1954 · S/N 31158 N3661CAas LLC · Ovid, MIBuilt 1954 · S/N 31160 N3668CN3668c L L C · Depauw, INBuilt 1954 · S/N 31167 N3675CBergstrom Dean A · Watertown, CTBuilt 1954 · S/N 31174 N3676CBoyce Walter Doug · Palmer, AKS/N 31175 N3680CBindon Phil E · Wasilla, AKFirst renewal noticeBuilt 1954 · S/N 31179 N3682CKiger Lance B · Prairieville, LAS/N 31181 N3686CSedwick William R · Anchorage, AKBuilt 1954 · S/N 31185 N3688CDiedrich Steve A · Sandpoint, IDBuilt 1954 · S/N 31187 N3692CDevil Dusters Inc · Artesia, NMS/N 31191 N3698CTomlinson John J · Kent, WABuilt 1954 · S/N 31197 N36SBWollenberg Jeffrey · Concrete, WABuilt 1956 · S/N 32271 N372VUPerry Robert P · Chelan, WABuilt 1955 · S/N 31428 N37EFProctor John · Rosebud, TXS/N 31006 N3852CWilson Kirk B · Glennallen, AKBuilt 1954 · S/N 31000 N3854CAnderson Clint T · Corsicana, TXBuilt 1954 · S/N 31002 N3859CSweet Phillips R · Laguna Beach, CABuilt 1954 · S/N 31007 N3861CBuben Michael · Chandler, AZBuilt 1954 · S/N 31009 N3866CProfessional Pilots Inc · Lowell, INBuilt 1954 · S/N 31014 N3867CKrmo Aviation LLC · Duluth, MNFirst renewal noticeBuilt 1954 · S/N 31015 N3880CGreer Glenn M · Eugene, ORBuilt 1954 · S/N 31028 N3888CBoyce Clayton · Lake Village, INBuilt 1954 · S/N 31036 N389Donalds Flying Service Inc · Pantego, NCBuilt 1953 · S/N 30085 N3890CBrandt Robert C · Schaumburg, ILBuilt 1954 · S/N 31038 N3891CStaple K Aviation LLC · Queen Creek, AZBuilt 1954 · S/N 31039 N3893CCravens Robert A · Bend, ORBuilt 1954 · S/N 31041 N3894CWatson Philip D · Wheatland, INBuilt 1954 · S/N 31042 N3897CKing Bruce J · Waldport, ORBuilt 1954 · S/N 31045 N3934BMahoney Andrew R · Fairbanks, AKBuilt 1954 · S/N 30148 N396TCG/A Enterprise LLC · Elizabeth, COBuilt 1956 · S/N 32501 N399FFieldgrove Matt L · Somerton, AZBuilt 1955 · S/N 31478 N3AQSinnott-Simonis Lyle · Girdwood, AKBuilt 1955 · S/N 31744 N408RStone Aviation LLC · Cusick, WABuilt 1954 · S/N 31149 N40LTNilsson Winston · Merrill, ORBuilt 1953 · S/N 30527 N40WABergstedt Yvonne · Anchorage, AKBuilt 1956 · S/N 32588 N40WTPritchett Thomas A · Covington, GABuilt 1953 · S/N 30324 N41CHLaperle Brian D · Colebrook, NHBuilt 1956 · S/N 32319 N420ZSmoking Joe'S Terps Co · Wasilla, AKS/N 30665 N422RTCarter Ted J · Bigfork, MTS/N 18052795 N432BAAnderson Jerry J · Vacaville, CABuilt 1956 · S/N 32279 N432DBDepcinski Travis A · Fairbanks, AKBuilt 1956 · S/N 32410 N43SLSudtell Chad S · Wasilla, AKBuilt 1954 · S/N 31611 N441NAHendry Rickey W · Apple Springs, TXBuilt 1955 · S/N 32198 N4500BStartin Brandon Lee · Spokane, WABuilt 1955 · S/N 31399 N4502BAshcraft Dustin William · Anchorage, AKBuilt 1955 · S/N 31401 N4509BTrompeter Mark S · Intl Falls, MNBuilt 1955 · S/N 31408

Back to Cessna 180