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.

N570DSSmith David A · Evergreen, COBuilt 1955 · S/N 32573 N57180Homo Holdings LLC · Kalispell, MTBuilt 1956 · S/N 32673 N57HKell Thomas G · Anchorage, AKBuilt 1958 · S/N 50286 N5900MBucher Burton W · North Chicago, ILBuilt 1956 · S/N 32330 N6000LDoherty Douglas E · Nome, AKBuilt 1955 · S/N 31877 N6153RSummers Don · Moose Lake, MNBuilt 1955 · S/N 31820 N61LCochran Robert Michael · Marathon, NYBuilt 1956 · S/N 32578 N6207MFranklin Dirk W · Beaumont, TXBuilt 1954 · S/N 30640 N6225QElkinton Dusty Lee · Moundville, MOBuilt 1955 · S/N 31957 N6268RYouvan Ian · Pittsburg, KSS/N 31418 N626RPWhitaker Jesse G · Anchorage, AKBuilt 1955 · S/N 31659 N63XYRegistered aircraftS/N 31651 N6427XBuck Timothy A · Howland, MEBuilt 1960 · S/N 18050927 N6500ASwartz Walter J · Hadley, MABuilt 1957 · S/N 32397 N6503ABrown Paul N · Eustace, TXBuilt 1956 · S/N 32400 N6505AKenmonth Craig M · Fairbanks, AKBuilt 1956 · S/N 32402 N651DRCreative Art And Design LLC · Arvada, COBuilt 1955 · S/N 31369 N6521AWiplinger Robert D · Inver Grove, MNBuilt 1956 · S/N 32418 N6522AHubbard Robert L · Anchorage, AKBuilt 1956 · S/N 32419 N6527ALivingston Thaddeus A Trustee · Chugiak, AKBuilt 1956 · S/N 32424 N6540AEyler Stuart L · Oceanside, CABuilt 1956 · S/N 32437 N6545AWunrow Steven M · River Falls, WIS/N 32442 N6546AHayden Susan R · North Pole, AKBuilt 1956 · S/N 32443 N65477Nistler Joseph C · Helena, MTS/N 18050637 N6548ANebesky William E · Anchorage, AKBuilt 1956 · S/N 32445 N6551AGlynn Kathy G · Queenstown, MDBuilt 1956 · S/N 32448 N6555ADensmore James E Jr · Colorado Springs, COBuilt 1956 · S/N 32452 N655SWIverson Michael D · Lino Lakes, MNBuilt 1955 · S/N 31887 N655WBGrecor LLC · Ashville, ALBuilt 1955 · S/N 31908 N6560AN6560a LLC · Saint Albans, MEBuilt 1956 · S/N 32457 N6567ABlue Star Gas Fleet Services Co · Santa Rosa, CABuilt 1956 · S/N 32464 N6569ABallard Scott K · Collierville, TNBuilt 1956 · S/N 32466 N6570AKunz Ethan · Ashland, ORBuilt 1956 · S/N 32467 N6575AWhitmore Alex · Terlingua, TXBuilt 1956 · S/N 32472 N6577ANafus Gifford William · Palmer, AKBuilt 1956 · S/N 32474 N6580AHelleloid Kristen L · Intl Falls, MNBuilt 1956 · S/N 32477 N6582AN6582a Leasing Service LLC · Wasilla, AKBuilt 1956 · S/N 32479 N6584AWildman Air LLC · Mckinney, TXBuilt 1956 · S/N 32481 N6587ADuncan William K · Collierville, TNBuilt 1956 · S/N 32484 N6609CTailwinds 23 LLC · Plymouth, MIS/N 30157 N67FPeterson Mark J · Flagstaff, AZBuilt 1953 · S/N 30343 N68PXDavis Ronald L Jr · Soldotna, AKBuilt 1954 · S/N 30859 N7036UN7036u LLC · West Palm Beach, FLBuilt 1955 · S/N 31621 N7082SBills Jack M · Naples, FLS/N 32499 N708MTThibodeau Michael L · Joseph, ORS/N 32014 N70KYSurfside Seaplane Training LLC · Lino Lakes, MNBuilt 1953 · S/N 30094 N71TFFreund Timothy P · Goddard, KSBuilt 1956 · S/N 32587 N727DGMarsh David G · Bluffdale, UTBuilt 1955 · S/N 31710 N727SGCarbaugh Nicholas · Seattle, WAS/N 30405 N73LT302 LLC · Anchorage, AKBuilt 1957 · S/N 32823

Back to Cessna 180