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.

N9329CWoodcock Tanner E · Red Lodge, MTBuilt 1955 · S/N 31727 N9330CAircraft Structural Repair Inc · Hamilton, MTBuilt 1955 · S/N 31728 N9331CLodato Zack · Wenatchee, WAS/N 31729 N93330Burden John C · Decatur, TXBuilt 1955 · S/N 31731 N9335CKoeritz Steven R · Anchorage, AKBuilt 1955 · S/N 31733 N9336CLarson Lynn R · Casselton, NDBuilt 1955 · S/N 31734 N9340CWolfe Donald E · T Or C, NMBuilt 1955 · S/N 31738 N9344CPage James S · Avoca, TXBuilt 1955 · S/N 31742 N9345CBunting Gordon E · Bend, ORBuilt 1955 · S/N 31743 N9350CCloud Dancer Inc · Berlin, MDBuilt 1955 · S/N 31748 N9352CSage Blue LLC · Yakima, WABuilt 1955 · S/N 31750 N9354CSmith Richard M · Stanwood, WABuilt 1955 · S/N 31752 N9355CGrobbelaar Warren · Naples, FLBuilt 1955 · S/N 31753 N9359CAero Sport Craft LLC · Havre De Grace, MDS/N 31757 N9361CHaverly Maynard L · Renton, WABuilt 1955 · S/N 31759 N9366CSkydance Inc · Knoxville, TNBuilt 1955 · S/N 31764 N9368CRadtke Edward P · Clarkston, WABuilt 1955 · S/N 31766 N9369CEastland Aviation Inc · Midland, TXBuilt 1955 · S/N 31767 N9370CQuackenbushalan B DBA · California City, CAFirst renewal noticeBuilt 1955 · S/N 31768 N9376CNicholas Adam Ferraro · Benson, AZBuilt 1955 · S/N 31774 N9379CWestern Pilot Service Inc · Phoenix, AZBuilt 1955 · S/N 31777 N9383CLewis Allen R · Anchorage, AKBuilt 1955 · S/N 31781 N9386CRizzo Marco L · San Luis Obispo, CABuilt 1955 · S/N 31784 N9389CLawrence Blake C · Monument, ORBuilt 1955 · S/N 31787 N9393CStover Shawn · Placerville, CAS/N 31791 N9394CRhr Management Inc · Bancroft, WIBuilt 1955 · S/N 31792 N9398CHolden Daniel N · Anacortes, WABuilt 1955 · S/N 31796 N9399CHansen Sean J · Anchorage, AKBuilt 1955 · S/N 31797 N9402CMontgomery Robert L · Port Angeles, WABuilt 1955 · S/N 31800 N9403CDobson Michael W · Konawa, OKBuilt 1955 · S/N 31801 N9404CBergh Gene H · Roberts, WIFirst renewal noticeBuilt 1955 · S/N 31802 N9405CRamsower Charles M · Parma, IDBuilt 1955 · S/N 31803 N9407CTyrrell Richard E · Central, AKBuilt 1955 · S/N 31805 N9413CRegistered aircraftBuilt 1955 · S/N 31811 N9414CPohland William C · Anchorage, AKBuilt 1955 · S/N 31812 N9418CWilliams Steven C · Anchorage, AKBuilt 1955 · S/N 31816 N9420CMccarroll Donald J · Villa Park, CABuilt 1955 · S/N 31818 N9425CInternational Air Services Inc Trustee · Carson City, NVBuilt 1955 · S/N 31823 N9426CBenson Fred B · Cle Elum, WABuilt 1955 · S/N 31824 N9428CJones Kathleen W · Springfield, ORBuilt 1955 · S/N 31826 N9429CLanham Rex E Jr · Boise, IDBuilt 1955 · S/N 31827 N9430CRoberts Creek Holdings LLC · Bakersfield, CABuilt 1955 · S/N 31828 N9432CTexas Co Title Inc · Kalispell, MTS/N 31830 N9435CBackcountry Adventures LLC · Big Lake, AKBuilt 1955 · S/N 31833 N9438CKrupinski Floyd M · Chugiak, AKBuilt 1955 · S/N 31836 N9439CYellowstone Overflight Inc · Belgrade, MTBuilt 1955 · S/N 31837 N9443CRvest Management LLC · Boulder City, NVBuilt 1955 · S/N 31841 N9445CSchaller Lee W · New Athens, ILBuilt 1955 · S/N 31843 N9446CAlaskan Luxury Cruises LLC · Willow, AKS/N 31844 N9448CAero Marine Inc · Westland, MIBuilt 1955 · S/N 31846

Back to Cessna 180