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.

N180XZGengenbach Joseph G · Livingston, TXBuilt 1964 · S/N 18051449 N180YHRobb Jon D · Alma, MIS/N 18051597 N1818Fulton Ricky L · Alex, OKS/N 18051551 N181XLHis Wings Air Service Inc · Hyder, AKBuilt 1966 · S/N 18051670 N18698Lumpkin Larry T · Ocala, FLBuilt 1969 · S/N 18052076 N189WHBonafide Investments LLC · Dover, DEBuilt 1969 · S/N 18052059 N196ABrennemann Brian L · Hyannis, NES/N 18051868 N205NDThompson Shane E · Warroad, MNBuilt 1966 · S/N 18051744 N2171ZMcmillan Seth W · Fairbanks, AKBuilt 1970 · S/N 18052136 N2404FDe Vries James S · Pacific, MOS/N 18051604 N2408FDawson Brent A · Dillingham, AKS/N 18051608 N2415FTrutschel Steven R · Waynesville, OHBuilt 1965 · S/N 18051615 N2419FMartinez Rudy J · Wasilla, AKBuilt 1965 · S/N 18051619 N2421FDeckload Aviation LLC · Kodiak, AKBuilt 1965 · S/N 18051621 N2423FSwalling Paul C · Anchorage, AKBuilt 1965 · S/N 18051623 N2430FTopaz LLC · Anchorage, AKBuilt 1965 · S/N 18051630 N2434FHanson Inc · Kalispell, MTS/N 18051634 N2435FBas Part Sales LLC · Greeley, COS/N 180-51635 N2437FKuersten Robert S · Middleton, WIBuilt 1965 · S/N 18051637 N2448FFlynn Charles P · Anchorage, AKBuilt 1965 · S/N 18051648 N2449FBoccuti Salvatore A · Ambler, PABuilt 1966 · S/N 18051650 N2451FMontana Rose 185 LLC · Cornwall, VTBuilt 1965 · S/N 18051652 N2452FPesicka Theodore J · Hermiston, ORBuilt 1966 · S/N 18051654 N2453FSooter Shem · Juneau, AKBuilt 1966 · S/N 18051655 N2460FRead Colin L · Plattsburgh, NYBuilt 1966 · S/N 18051662 N2467FTherkelsen Robert D · Burlington, WABuilt 1966 · S/N 18051669 N2472FParr Crawford B · Anchorage, AKBuilt 1966 · S/N 18051674 N2478FSchad Paul E · Gainesville, TXBuilt 1966 · S/N 18051680 N2483FMiller Clinton J · Traverse City, MIBuilt 1966 · S/N 18051685 N2484FJones William Ransom · Anchorage, AKBuilt 1966 · S/N 18051686 N2495FKalbfleisch George R · Dry Ridge, KYBuilt 1966 · S/N 18051697 N2496FKrissman Ryan · Gallup, NMS/N 18051695 N2498FTaylor Andrew A · Ketchikan, AKBuilt 1966 · S/N 18051700 N249MDMorrison William F · Athol, IDBuilt 1965 · S/N 18051501 N2672MSchmoll Aviation LLC · Sterling, AKBuilt 1966 · S/N 18051729 N26PRSoule Clauson D · Cooperstown, NYBuilt 1966 · S/N 18051614 N2700XElias Daniel Dean · Springfield, NHBuilt 1965 · S/N 18051500 N2704XChumchal Kelly R · Wharton, TXBuilt 1965 · S/N 18051504 N2705XShallow David M · Salmon, IDBuilt 1965 · S/N 18051505 N2709XCmvii LLC · Chugiak, AKBuilt 1965 · S/N 18051509 N2710XReinhart Richard A · Cook, MNBuilt 1965 · S/N 18051510 N2716XShaw Brandon L · Juneau, AKBuilt 1965 · S/N 18051516 N2718XPoirier Theodore N · Biddeford, MEBuilt 1965 · S/N 18051518 N2720XStubbs John C · Bangor, MEBuilt 1965 · S/N 18051520 N2722XRearden Michael B · Homer, AKBuilt 1965 · S/N 18051522 N2728XUsda Forest Service Fepp · Trenton, NJBuilt 1965 · S/N 18051528 N2730XSmith Daniel E · Anchorage, AKBuilt 1965 · S/N 18051530 N27339Rice John G · Craig, AKBuilt 1970 · S/N 18052140 N2736XMehling Michael R · Fairview, MTBuilt 1965 · S/N 18051536 N2737XFly-By Aviation Services LLC · Colorado Springs, COBuilt 1965 · S/N 18051537

Back to Cessna 180H