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.

N180TNJensen Arden T Jr · Auburn, WABuilt 1956 · S/N 32260 N180TPLayson Aviation LLC · Spring Lake, MIBuilt 1955 · S/N 31522 N180TW180 Tw LLC · Rexburg, IDS/N 32371 N180UFBrown Bryan L · Greenwood, ARBuilt 1953 · S/N 30331 N180VWTwo LLC · South Paris, MEBuilt 1955 · S/N 32005 N180WAHelland Gregory A · Wayzata, MNS/N 30754 N180WBSchroder Robert D · Buckeye, AZS/N 31159 N180WDRegistered aircraftBuilt 1953 · S/N 30203 N180WLMerker Christopher R · Lewistown, MTBuilt 1953 · S/N 30520 N180WSBiloff Neil L · Milton Freewater, ORBuilt 1954 · S/N 31771 N180WWMyers Dale C · King Salmon, AKBuilt 1955 · S/N 31963 N180WYTorgerson Co LLC · Almena, WIBuilt 1955 · S/N 31437 N180XPAnders Jack H · Bend, ORBuilt 1956 · S/N 32494 N180XRBank Of Utah Trustee · Salt Lake City, UTBuilt 1954 · S/N 30743 N180ZHenderson Ag Service Inc · Osceola, ARBuilt 1954 · S/N 30828 N180ZRLundell Don C · Los Altos, CABuilt 1955 · S/N 31662 N181JMMccloy John S · Lakeland, FLBuilt 1953 · S/N 30145 N181NWitt Robert A · Anchorage, AKBuilt 1956 · S/N 32416 N181STWagontrainer LLC · Kalispell, MTBuilt 1954 · S/N 30997 N184TMYates Christopher R · Huntington Beach, CABuilt 1956 · S/N 32302 N18HBBuermann Henry · Brookfield, VTS/N 30912 N1953CHanafi Robert A · Wellton, AZBuilt 1953 · S/N 30502 N1956JAdamson George R · Calhan, COBuilt 1956 · S/N 32571 N1983CRivera Carlos A · Morriston, FLBuilt 1955 · S/N 31572 N19TWDougherty Peter I · Orchard Park, NYBuilt 1953 · S/N 30119 N1ZTHolman Daniel P · Eagle River, AKBuilt 1954 · S/N 31597 N202SMyers Jon D · Montrose, COBuilt 1956 · S/N 32355 N207NEHylton Kyler E · Palmer, AKBuilt 1954 · S/N 31030 N20BRYork Stanley A · Leetonia, OHBuilt 1955 · S/N 31563 N2110ZNordick Brett A · Glyndon, MNBuilt 1963 · S/N 18051210 N2123NKangas Brian Alfred · Houghton, MIBuilt 1955 · S/N 31815 N214EPShumway Edwin · Tekonsha, MIBuilt 1956 · S/N 32485 N217MMiles Manderson L · Lewiston, IDBuilt 1954 · S/N 31292 N21TNNavar Thomas R Jr · El Paso, TXS/N 31685 N21YCp Aviation Inc · Santa Paula, CABuilt 1954 · S/N 30837 N2204CPainter Creek Lodge Inc · El Rito, NMBuilt 1953 · S/N 30504 N2206CPatton Mark A · Aurora, COBuilt 1953 · S/N 30506 N2207CDurden Dewitt D · Spanish Fort, ALBuilt 1953 · S/N 30507 N2213CTruffer Martin · Fairbanks, AKBuilt 1953 · S/N 30513 N2214CMarks Richard J IV · Norway, MEBuilt 1953 · S/N 30514 N2216CAero Mark Inc · Idaho Falls, IDBuilt 1953 · S/N 30516 N2218CMart Gary A · Bend, ORS/N 30518 N2219CCarder Kent E · Lakeville, MNBuilt 1953 · S/N 30519 N2221CCts Aviation Inc · Galesburg, MIBuilt 1953 · S/N 30521 N2223CElston Josh A · Sterling, AKBuilt 1953 · S/N 30523 N2229CYleski LLC · Bozeman, MTBuilt 1953 · S/N 30529 N222AKChambers Samuel S · Salmon, IDBuilt 1953 · S/N 30097 N222SBFuglestad Jon T · Anchorage, AKBuilt 1953 · S/N 30360 N2230CHendricks Construction LLC · Phoenix, AZS/N 30530 N2238CGorham Wendy J · Grand Rapids, MNBuilt 1953 · S/N 30538

Back to Cessna 180