Skip to content

Registered aircraft · 266

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 ('2072622')
  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 ('2072622')
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.

N208TCKissee Zachary Robert · Chugiak, AKBuilt 1976 · S/N 18052749 N253DFFort Greg R · Burien, WABuilt 1976 · S/N 18052686 N257LMSsb Aviation LLC · Wasilla, AKBuilt 1975 · S/N 18052548 N274MDDickenson Bruce E Trustee · Santa Paula, CABuilt 1975 · S/N 18052591 N275DMMaxfield Douglas R · Chico, CABuilt 1975 · S/N 18052558 N2936EHansen Mark A Trustee · Long Beach, CABuilt 1975 · S/N 18052562 N31803Mekker Mark S · Getzville, NYS/N 18052420 N31BBohon Todd R · Palmer, AKS/N 18052431 N321RBMessmore Micheal Henry · Toledo, WABuilt 1976 · S/N 18052677 N33748Mcgowan Daniel J · Springville, CAS/N 18052525 N34CFPayne James Michael · Twin Falls, IDBuilt 1974 · S/N 18052473 N393BThickstun Benjamin Tyler · Wasilla, AKBuilt 1973 · S/N 18052299 N398WWaffensmith Walter L Trustee · Golden Valley, MNBuilt 1973 · S/N 18052332 N4013Peters Joseph J · Brentwood, TNBuilt 1973 · S/N 18052326 N410CEBurggraf Sean Hj · Grand Rapids, MNS/N 18052477 N42025Stokes Clive V · Gilbert, AZBuilt 1972 · S/N 18052301 N42026Bains Jordan John W · Anchorage, AKBuilt 1972 · S/N 18052302 N42051Flying M Aviation Inc · Irondale, ALBuilt 1972 · S/N 18052305 N42055Klp Aeromotive LLC · Morriston, FLBuilt 1973 · S/N 18052306 N42084Acp Aviation LLC · Oakdale, LAS/N 18052309 N42094Mdn LLC · Park City, MTBuilt 1973 · S/N 18052311 N420SBWayne Daryl Hall II · Wasilla, AKS/N 18052313 N42100Chamberlain Scott Alan · Payson, AZBuilt 1973 · S/N 18052314 N42123Vandeusen Leon W III · Leslie, ARBuilt 1973 · S/N 18052320 N4212542125 LLC · Mercer Island, WAS/N 18052321 N42182Schaible John F · Palmerton, PABuilt 1973 · S/N 18052323 N42247Kratz Jeffrey B · Seattle, WABuilt 1973 · S/N 18052330 N42305Registered aircraftBuilt 1973 · S/N 18052339 N42359Lincoln Roger Trustee · Gildford, MTBuilt 1973 · S/N 18052343 N42376Johnson Lytle D · Anacortes, WABuilt 1973 · S/N 18052348 N4240142401 LLC · Hailey, IDBuilt 1973 · S/N 18052350 N42464Gunderson Gunnar Jr · Wrangell, AKBuilt 1973 · S/N 18052356 N42486Armstrong Kevin L · Corvallis, ORBuilt 1973 · S/N 18052357 N42526Stanley Gerald L · Littleton, COBuilt 1973 · S/N 18052359 N42536N B B S LLC · Kansas City, KSBuilt 1973 · S/N 18052360 N42589Haas Kile B · Monette, ARBuilt 1973 · S/N 18052365 N42610Meadows Marcus · Anchorage, AKS/N 18052366 N42700Van Matre Thomas A Jr · Mineola, TXBuilt 1973 · S/N 18052371 N42889Fuller Lawrence A · Wasilla, AKBuilt 1973 · S/N 18052382 N42916Nedwick Lars I · Girdwood, AKS/N 18052384 N42958Havasa Enterprises LLC · Sisters, ORBuilt 1973 · S/N 18052389 N42968Jelinek Spencer T · Erie, COBuilt 1973 · S/N 18052390 N4406RDe Nora Christian G · San Antonio, TXBuilt 1976 · S/N 18052670 N4580JBlakeslee Mark C · Kodiak, AKBuilt 1975 · S/N 180-52509 N46063Low Thomas A Trustee · Derry, NHBuilt 1973 · S/N 18052395 N46173Wieckowski Jan M · Grand Island, NYBuilt 1973 · S/N 18052404 N46295Mangham C H · Mineral Wells, TXBuilt 1973 · S/N 18052410 N46298Hodges Jay F · Fairbanks, AKBuilt 1974 · S/N 18052411 N46300Mason Steven O · Greenville, MEBuilt 1973 · S/N 18052413 N46317Mcvicker Andrew B · Erwinna, PABuilt 1974 · S/N 18052416

Back to Cessna 180J