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.

N2393CKocon Tyler · Puyallup, WABuilt 1954 · S/N 30693 N239TRosman Patrick R · Creston, WABuilt 1955 · S/N 31775 N239WMPlane Fun Inc Tr (Trustee) · Snellville, GABuilt 1953 · S/N 30383 N2400CFloyd William W · Anchorage, AKBuilt 1954 · S/N 30700 N2404CWatts Noah D · San Antonio, TXS/N 30704 N2406CRopps Spraying Service Inc · Pasco, WABuilt 1954 · S/N 30706 N2408CDoughnut Wings Aviation LLC · Lewes, DEBuilt 1955 · S/N 30708 N2409YLow Go Flyers Inc · Jonesville, LABuilt 1955 · S/N 31967 N2410CChasin Tails Inc · Gouldsboro, MEBuilt 1954 · S/N 30710 N2411CMacadams Christopher L · Bloomington, MNS/N 30714 N2412CRigid Oilfield Services LLC · El Reno, OKS/N 30712 N2416CTa Ritchey LLC · Batavia, OHBuilt 1954 · S/N 30716 N2417CW & K Aviation LLC · Omro, WIS/N 30717 N2418CBlythe Anne T · Paso Robles, CABuilt 1954 · S/N 30718 N2421CGeisler Mark · Dallas, TXBuilt 1954 · S/N 30721 N24227Styer Michael J · Amarillo, TXBuilt 1955 · S/N 31504 N2428CRegistered aircraftBuilt 1954 · S/N 30728 N2432CFreed Richard H · Watervliet, MIBuilt 1954 · S/N 30732 N2434CGoad Graham L · Mcminnville, ORBuilt 1954 · S/N 30734 N2436CHawk Unlimited LLC · Kalispell, MTS/N 30736 N2437CFogleman Brian L · Stonewall, LAS/N 30737 N2442CRoberts Calvin · Bluebell, UTBuilt 1954 · S/N 30742 N2446CGolike Timothy R · Anchorage, AKBuilt 1954 · S/N 30746 N2447CLevya Kevin S · Wilbur, WAS/N 30747 N2451CWilliams Marc Alomzo · Fallon, NVBuilt 1954 · S/N 30751 N2453CFoster Steven W · Big Lake, AKBuilt 1954 · S/N 30753 N2458CGant Dallas C Jr · Wickenburg, AZBuilt 1954 · S/N 30758 N2459CAkchak Air LLC · Leeds, UTS/N 30759 N2465CToal Timothy R · Milan, ILBuilt 1954 · S/N 30765 N2468CHatley Ralph A · Eagle Creek, ORBuilt 1954 · S/N 30768 N246LSJohnson Mark · Macon, MSS/N 32185 N2470CMcclymond Tyler L · Grand Junction, COS/N 30770 N2471CCavjet LLC · Bonham, TXBuilt 1954 · S/N 30771 N2473CLewis Eddy L · Cortez, COBuilt 1954 · S/N 30773 N2475CHansen Curtis · Merrimack, NHBuilt 1954 · S/N 30775 N2476CBrown Jack P · Anchorage, AKBuilt 1954 · S/N 30776 N2479CTo The Wind LLC · Salmon, IDBuilt 1954 · S/N 30779 N2481CPippert Jim · Dysart, IABuilt 1954 · S/N 30781 N2482CMiller Richard W · Bellingham, WABuilt 1954 · S/N 30782 N2484CLejeune Aerial Applications LLC · Basile, LABuilt 1954 · S/N 30784 N2486CArmstrong Patrick Trustee · Bishop, CABuilt 1954 · S/N 30786 N2489CRegistered aircraftBuilt 1954 · S/N 30789 N2492CTjossem Martin O · Paullina, IABuilt 1954 · S/N 30792 N2493CBallard Bradley J · Youngsville, NCBuilt 1954 · S/N 30793 N24GCGreene County Sports Parachute · Loretto, KYBuilt 1954 · S/N 31163 N252KCPatton Steven W · Fayetteville, ARS/N 30964 N253RRRoland Ronald W Trustee · Mckinney, TXBuilt 1953 · S/N 30253 N25FCBlumhagen Ryan M · Drake, NDBuilt 1955 · S/N 31520 N261DRSafeflite Aviation LLC · Glenwood, IAS/N 31114 N2648YSw Aviation Services Inc · Queen Creek, AZBuilt 1955 · S/N 31676

Back to Cessna 180