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.

N7801KBurley Richard A · Fairbanks, AKBuilt 1976 · S/N 18052735 N7802KMagliacano Metal Worx Inc · La Cygne, KSBuilt 1976 · S/N 18052736 N7803KBales Ranch Inc · Otter, MTS/N 18052737 N7806KWilson David J · Palmer, AKS/N 18052740 N7807KSutton Aircraft Salvage LLC · Palmer, AKS/N 18052741 N7808KRegistration Pending · Fort Collins, CORegistration pendingBuilt 1976 · S/N 18052742 N7809KAdamson Bradley R · Cody, NEBuilt 1976 · S/N 18052743 N7810KBecker Michael A · La Grande, ORBuilt 1976 · S/N 18052744 N7819KCollins Brian D · Middlebury, VTBuilt 1976 · S/N 18052753 N781MCOster Kenneth W · Coarsegold, CABuilt 1975 · S/N 18052631 N7821KFlood John · Bozeman, MTBuilt 1976 · S/N 18052755 N7822KStahl Richard J · Gainesville, TXBuilt 1976 · S/N 18052756 N7827KTvc Fliers LLC · Traverse City, MIBuilt 1976 · S/N 18052761 N7828KMader James Jay · Lino Lakes, MNBuilt 1976 · S/N 18052763 N7830KColberg Sigurd E · Palmer, AKBuilt 1976 · S/N 18052764 N7834KSautner Steve · Anchorage, AKBuilt 1976 · S/N 18052768 N79TCBear Cat Air LLC · Gun Barrel City, TXBuilt 1974 · S/N 18052479 N7MLPuchner Christopher C · Ester, AKBuilt 1973 · S/N 18052296 N8000YConklin Matthew J · Boise, IDBuilt 1973 · S/N 18052391 N8GJGutierrez Sergio E · Pharr, TXBuilt 1974 · S/N 18052536 N904BPPlane Fun Inc Tr Trustee · Snellville, GABuilt 1975 · S/N 18052595 N91245Delmonte Paul R · Mountain Green, UTBuilt 1974 · S/N 18052464 N95BWAgwerx Aviation Inc · Mapleton, IABuilt 1976 · S/N 18052727 N9788GSnowden Robert W · Mason, TXBuilt 1973 · S/N 18052288 N9789GWetherbee Steve R · Pollock, SDBuilt 1973 · S/N 180-52289 N9794GCherry James J · Woodside, CABuilt 1972 · S/N 18052294 N9797GPowers Burton L · Anchorage, AKS/N 18052297 N9798GJantz Merle Trustee · North Pole, AKBuilt 1972 · S/N 18052298 N9900NRegistered aircraftBuilt 1975 · S/N 18052555 N9901NTeets David J · Fairbanks, AKBuilt 1975 · S/N 18052556 N9912NRegistered aircraftBuilt 1975 · S/N 18052567 N9915NKackley Floyd L · Grand Rapids, MNBuilt 1975 · S/N 18052570 N9917NThunderbird LLC · Tacoma, WABuilt 1975 · S/N 18052572 N9918NCalef Jere R Trustee · Mojave, CABuilt 1975 · S/N 18052573 N9921NHauxwell Bryan · Mccook, NEBuilt 1975 · S/N 18052576 N9922NRobert N Shadduck LLC · Boulder, MTS/N 18052577 N9923NMontana Capital Holdings LLC · Missoula, MTS/N 18052578 N9924NMulcaire Jess · Camp Verde, AZBuilt 1975 · S/N 18052579 N9925NHarrod James · Birchwood, MNBuilt 1975 · S/N 18052580 N9929NBarnes Stewart A Trustee · Wasilla, AKBuilt 1975 · S/N 18052584 N9932NGetz Keith · Murfreesboro, TNBuilt 1975 · S/N 18052587 N9934NAtkins Ricky K · Placerville, CABuilt 1975 · S/N 18052589 N9935NMeggers Roger D · Baker, MTBuilt 1975 · S/N 18052590 N9938NJohnson Scott A · Missoula, MTBuilt 1975 · S/N 18052593 N9939NSylvester Sean W · North Pole, AKS/N 18052594 N9944NJungclaus Karl F · Piedmont, SDBuilt 1975 · S/N 18052599 N9949NFox Heather J · Bettles Field, AKBuilt 1975 · S/N 18052604 N9950NRegistration Pending · Petersburg, AKRegistration pending, pending cancellationS/N 18052605 N9951NAckerman Dennis W · Anchorage, AKBuilt 1975 · S/N 18052606 N9954NWhitmer Lyle E · Fairbanks, AKBuilt 1975 · S/N 18052609

Back to Cessna 180J