Skip to content

Registered aircraft · 486

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

N9799HFriehe Berend · Moses Lake, WABuilt 1981 · S/N 18268033 N9802HPatterson Aubrey III · Saltillo, MSBuilt 1981 · S/N 18268034 N9803HCoburn Alan B · Plantation, FLBuilt 1981 · S/N 18268035 N9806EMccullough John D · Maize, KSBuilt 1985 · S/N 18268448 N9807HMid Eastern Specialties Ltd · Wilmington, DEBuilt 1981 · S/N 18268037 N9808HThiel Av LLC · Lewistown, MTBuilt 1981 · S/N 18268038 N9809HHumphries Steve J · Raleigh, NCBuilt 1981 · S/N 18268039 N9810HLoos Gregory S · Boscobel, WIBuilt 1981 · S/N 18268040 N9813HDowney Corp · Cornwall, VTS/N 18268042 N9815HAnderson Joseph Richard · Lewiston, IDBuilt 1981 · S/N 18268044 N9816EArizona Air Salvage · Phoenix, AZBuilt 1985 · S/N 18268450 N9817HBurcham Timothy Scott · Encinitas, CABuilt 1981 · S/N 18268046 N9818HFowler Raymond E · Smyrna, GABuilt 1981 · S/N 18268047 N9819HStanley Aero Club Gastonia Inc · Belmont, NCBuilt 1981 · S/N 18268048 N9820HSeghieri Richard T · Santa Rosa, CABuilt 1981 · S/N 18268049 N9821HDowning Darrell W · Drakesville, IABuilt 1981 · S/N 18268050 N9822HPetsche Tim E · Meridian, IDBuilt 1981 · S/N 18268051 N9824HClimb LLC · Kalispell, MTS/N 18268052 N9829HWright Steven · Shelbyville, TNBuilt 1981 · S/N 18268054 N9833HMccool Air Service Inc · Mc Cool Junction, NEBuilt 1981 · S/N 18268055 N9836HDouglas County Land Title Co · Douglasville, GABuilt 1981 · S/N 18268057 N9837HChristmas Aviation LLC · Pace, FLBuilt 1981 · S/N 18268058 N9840ABrentco Aerial Patrol Inc · Canton, OHBuilt 1984 · S/N 18268409 N9841HItd Services LLC · Clarendon, TXS/N 18268062 N9842HStewart John D · Slatington, PABuilt 1981 · S/N 18268063 N9843HAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1981 · S/N 18268064 N9844EKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1985 · S/N 18268453 N9845HAaa Sales LLC · Apple Valley, MNBuilt 1981 · S/N 18268065 N9846AMannen Gregory Charles II · Warren, ORBuilt 1984 · S/N 18268415 N9848HBrekke Ryan S · Edmore, NDBuilt 1981 · S/N 18268067 N9849HSouthwest Plane Holdings LLC · Kalispell, MTBuilt 1981 · S/N 18268068 N9851HCivil Air Patrol Inc · Montgomery, ALBuilt 1981 · S/N 18268070 N9853HMiles Alexander Bevans · Columbia, SCBuilt 1982 · S/N 18268072 N985GWPavlik John · Portland, ORBuilt 1985 · S/N 18268535 N9863EBlankinship Guy · Jackson, MSFirst renewal noticeBuilt 1985 · S/N 18268456 N9863HFrost R Edward · Winchester, ILS/N 18268079 N9869HFoxtrot Alliance LLC · Southlake, TXBuilt 1981 · S/N 18268082 N9870ETts Calif LLC · Red Bluff, CABuilt 1985 · S/N 18268457 N9872EMckoane Christina Elizabeth · Vail, COBuilt 1985 · S/N 18268458 N9873EFiedler Andrew T · Houston, TXBuilt 1985 · S/N 18268459 N9877EKa Flying LLC · Dalhart, TXBuilt 1985 · S/N 18268460 N9877HCowden William H Jr · Kerrville, TXBuilt 1981 · S/N 18268087 N9879EMy Way Aviation LLC · Weston, FLBuilt 1985 · S/N 18268461 N9883HRegistration Pending · Franklin, TXRegistration pendingBuilt 1981 · S/N 18268090 N9890ECivil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 18268465 N9890HDe Rico Nicolas · Tracy, CABuilt 1981 · S/N 18268094 N9893HBain Aviation Inc · Weiser, IDBuilt 1981 · S/N 18268095 N9895ETurnkey Aviation LLC · North Las Vegas, NVBuilt 1985 · S/N 18268467 N9896HHilltop Aviation LLC · Rowlesburg, WVBuilt 1981 · S/N 18268097 N9899HCrimson Aircraft Sales LLC · Tuscumbia, ALBuilt 1981 · S/N 18268098

Back to Cessna 182R