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.

N4930ACapra Cory · Forest Lake, MNBuilt 1956 · S/N 32327 N4932ALegas David S · Phoenix, AZBuilt 1956 · S/N 32329 N4934AYellowstone Overflight Inc · Belgrade, MTBuilt 1956 · S/N 32331 N4935AVucetic Miroslav · Coral Springs, FLBuilt 1956 · S/N 32332 N4936AAnderson Dennis G · Eagle River, AKBuilt 1956 · S/N 32333 N4940ASims Charles A · Chugiak, AKBuilt 1956 · S/N 32337 N4942AChapman Peter E · Placerville, CABuilt 1956 · S/N 32339 N4945AIverson Randy · Winnemucca, NVBuilt 1956 · S/N 32342 N4947AGleiter David W · Overland Park, KSBuilt 1956 · S/N 32344 N4953AOlson Andrew P · Garfield, WABuilt 1956 · S/N 32350 N4961AGunson Robert S · Star, IDBuilt 1956 · S/N 32358 N4964AThree Sisters Capital LLC · Visalia, CABuilt 1956 · S/N 32361 N4968AD&B Aircraft Leasing LLC · Anchorage, AKBuilt 1956 · S/N 32365 N4970ANervino David J · Hilmar, CABuilt 1956 · S/N 32367 N4971ATruman Sparks Aviation LLC · Wink, TXBuilt 1956 · S/N 32368 N4972AHighsmith Alfred C · Burgaw, NCBuilt 1956 · S/N 32369 N4979ARothacker Aviation LLC · Chester Springs, PAS/N 32376 N4981ALeseman Kelly · Anchorage, AKBuilt 1956 · S/N 32378 N4990AHalunen Arlie J III · Seattle, WAS/N 32387 N4993ABaker Brandon Heath · Almyra, ARS/N 32390 N4994ARose Carey V · Colville, WABuilt 1956 · S/N 32391 N4998AWright Transport Inc · Colfax, INBuilt 1956 · S/N 32395 N49JTBell Steven M · Wasilla, AKBuilt 1954 · S/N 30834 N50008Osowski Wes A · Kodiak, AKS/N 32478 N5006EPainter Harold R · Anchorage, AKBuilt 1958 · S/N 50306 N500DGraham Douglas R · Palmer, AKS/N 31460 N505LMKennicott Wilderness Air LLC · Glennallen, AKS/N 31267 N510FMckeen Charles Dale · Howard Lake, MNBuilt 1956 · S/N 32451 N511MHZeringue Amanda E · Southern Pines, NCS/N 30510 N518VKingsley Kiman J · Miller, MOBuilt 1956 · S/N 32429 N51CVMarotta Daniel C · Tijeras, NMBuilt 1980 · S/N 18053160 N51ESBurton Donald O · Mooresville, NCBuilt 1955 · S/N 31839 N524RKAustin Air Cruises LLC · Dripping Springs, TXBuilt 1955 · S/N 31491 N529PHSilveraire LLC · Forest Lake, MNBuilt 1955 · S/N 31324 N5329DMeketa Ann M · La Vernia, TXBuilt 1958 · S/N 50227 N53ESSpooner Brent · Fulshear, TXS/N 30053 N540RTMorgan Stanley L · Nome, AKS/N 52-118 N541JKKubik James T · Beach City, TXBuilt 1954 · S/N 31166 N54AFSpohnholz Randy K · Anchorage, AKBuilt 1954 · S/N 30943 N54SDJerry W And Barbara J Smith Family Land Lllp · Blanca, COBuilt 1954 · S/N 31162 N55180Craig Warren J · Ellerbe, NCBuilt 1955 · S/N 31639 N551DSFreeburg Farms Inc · Worley, IDBuilt 1955 · S/N 31289 N5543ASelf Defense Of New England LLC DBA · Bedford, NHBuilt 1956 · S/N 32660 N5547VDahl Demar · Deeth, NVS/N 32054 N55DLHill Brock E · Palouse, WABuilt 1955 · S/N 31362 N55NSBrown Nelson S · Auburn, WABuilt 1955 · S/N 31469 N56180Gosney Don L · Bayfield, COBuilt 1955 · S/N 32165 N561ATSheets Jeff M · Salmon, IDBuilt 1956 · S/N 32403 N567BHKingsley Kiman J · Miller, MOS/N 32272 N56MTAvex Holdings Heli Inc · Lewes, DES/N 32562

Back to Cessna 180