Skip to content

Registered aircraft · 366

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

N709Frey Robert Henry Jr · Keller, TXBuilt 1966 · S/N 18051694 N71ERClapp William H · Mountain View, MOBuilt 1968 · S/N 180-51965 N71JHJacks Air Serv Inc · Greenville, MEBuilt 1966 · S/N 18051678 N723CSFinch Dennis G Jr · Long Prairie, MNS/N 18051897 N73BTDragging Tails LLC · Colbert, GABuilt 1965 · S/N 18051606 N741MWatts Scott E · Auke Bay, AKBuilt 1965 · S/N 18051639 N74LJZaczkowski Paul S · Tok, AKBuilt 1966 · S/N 18051755 N74MGRegistered aircraftBuilt 1965 · S/N 18051632 N75FBPhillips Brandon S · Susanville, CABuilt 1966 · S/N 18051707 N75VAPfingsten Thomas H · Peachtree City, GABuilt 1968 · S/N 18051936 N76LJNelson Flyers Inc · Louise, TXBuilt 1966 · S/N 18051764 N779TMHilpert Robert M · Chapmansboro, TNS/N 18052271 N77AVHodge Dominic V · Anchorage, AKBuilt 1965 · S/N 18051556 N7901VBoeder Bradley M · Lakewood, WABuilt 1966 · S/N 18051801 N7904VKlinkmueller Kurt · North Pole, AKS/N 18051804 N7910VReifel Christopher · Eagle River, AKS/N 18051810 N7911VBig Bend Community College · Moses Lake, WABuilt 1966 · S/N 18051811 N7914VTerry James R · Glenwood Springs, COBuilt 1966 · S/N 18051814 N7925VBobcat Scout LLC · Whitefish, MTBuilt 1966 · S/N 18051825 N7926VDoerstling Alexander Wolfgang · Waco, TXBuilt 1967 · S/N 18051826 N7928VCamp Harper LLC · Houston, TXBuilt 1967 · S/N 18051828 N7929VWatsabaugh Byron D · Gillette, WYBuilt 1967 · S/N 18051829 N7930VHague Neil C · Wichita, KSBuilt 1967 · S/N 18051830 N7933VBarnes Joseph W · Pittsfield, MEBuilt 1967 · S/N 18051833 N7936VFarrey Michael J · Mason, NHBuilt 1967 · S/N 18051836 N7937VSage Charles M Jr · Wasilla, AKBuilt 1967 · S/N 18051837 N7938VHayton James B · Sedro Woolley, WABuilt 1967 · S/N 18051838 N7939VRuhl Daniel J · Bend, ORBuilt 1967 · S/N 18051839 N7942VKing Air Inc · Naknek, AKBuilt 1967 · S/N 18051842 N7945VN7945v LLC · Wilmington, DEBuilt 1967 · S/N 18051845 N7953VRegistered aircraftBuilt 1967 · S/N 18051853 N7955VHancock Glenn · Jackson, GABuilt 1967 · S/N 18051855 N7958VColbern Matthew · Anchorage, AKBuilt 1967 · S/N 18051858 N7964VNorris John R · Anchorage, AKBuilt 1967 · S/N 18051864 N7971VDossenback Kelly · Folsom, CABuilt 1967 · S/N 18051871 N7973VRickman Allen K · Absarokee, MTBuilt 1967 · S/N 18051873 N7978VSlinger LLC · Laramie, WYBuilt 1967 · S/N 18051878 N7987VCozad Rebecca G F Trustee · Talkeetna, AKBuilt 1967 · S/N 18051887 N7990VSutton Aircraft Salvage LLC · Palmer, AKS/N 18051890 N7CTDenney Michael J · South Lake Tahoe, CABuilt 1965 · S/N 18051616 N8060ZMason Michael · Anchorage, AKBuilt 1968 · S/N 18051992 N8202VCebulski Barry A · Fairbanks, AKBuilt 1966 · S/N 18051704 N8206VRegistration Pending · Wasilla, AKRegistration pendingBuilt 1966 · S/N 18051708 N8208VSamalon William S Trustee · Juneau, AKBuilt 1966 · S/N 18051710 N8213VRiver City Real Estate LLC · Otis, MEBuilt 1966 · S/N 18051715 N8221VBorror Bryce C · Grants Pass, ORBuilt 1966 · S/N 18051723 N8233VHewitt Alan E · Federal Way, WABuilt 1966 · S/N 18051735 N8241VAlsworth Glen R · Port Alsworth, AKBuilt 1966 · S/N 18051743 N8245VFarnsworth James A · Sandy Valley, NVBuilt 1966 · S/N 18051747 N8249VSutton Aircraft Salvage LLC · Palmer, AKBuilt 1966 · S/N 18051751

Back to Cessna 180H