Skip to content

Registered aircraft · 2,099

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

N1798MWalker Steven C · Lake Havasu City, AZBuilt 1975 · S/N 18264451 N17BHFoster Brian J · Mancelona, MIBuilt 1972 · S/N 18261384 N1803MWhitfield Edward · Mcpherson, KSBuilt 1975 · S/N 18264454 N18182Samaha Fadi · Point Roberts, WABuilt 1975 · S/N 18263913 N181ATNazario Rafael · Delray Beach, FLBuilt 1973 · S/N 18262686 N1820KBergstrom Aircraft Inc · Pasco, WABuilt 1975 · S/N 182-64092 N1822CBrouwer Aviation LLC · Kalamazoo, MIBuilt 1974 · S/N 18262981 N1823AKearns Adam · Portland, ORBuilt 1972 · S/N 18260858 N182AFLuther Charles R · Spring Branch, TXBuilt 1972 · S/N 182-60996 N182AGShort Michael · Gibraltar, MIS/N 18262401 N182AVWilson Robert A · Lopez Island, WABuilt 1975 · S/N 18264161 N182BBBaker Prop LLC · New Castle, NHBuilt 1975 · S/N 675 N182BCAnthony R Cory · Starkville, MSBuilt 1976 · S/N 18265071 N182BMZoller Air LLC · Parker, COBuilt 1974 · S/N 18262868 N182BTFagan Michael S · Simi Valley, CABuilt 1975 · S/N 18264234 N182BVLovato Terry Scott · Oxnard, CABuilt 1975 · S/N 18263665 N182CHToma Services LLC · Maurice, LABuilt 1972 · S/N 18260999 N182CQWirth Bobby L · Spicewood, TXBuilt 1973 · S/N 18261701 N182CUAlabama Law Enforcement Agency · Montgomery, ALBuilt 1974 · S/N 18263334 N182CXBearcat Aviation Services LLC · Prescott, AZS/N 18262882 N182DJPreston Robert H · Canton, OHBuilt 1973 · S/N 18262129 N182DLLow Richard H · Hernando, FLBuilt 1976 · S/N 18264512 N182DMCourser Tony C · Escondido, CABuilt 1974 · S/N 18262783 N182DTMonogram Aviation Services LLC · Coeur D Alene, IDBuilt 1975 · S/N 18263797 N182EFMission Flight · El Monte, CABuilt 1972 · S/N 18261392 N182EPLamm William D · Harrogate, TNBuilt 1976 · S/N 18265061 N182EWTesk Aviation LLC · Steele, MOBuilt 1976 · S/N 18264841 N182FAMyers Douglas J Trustee · Laurel, MTBuilt 1973 · S/N 18262274 N182FPTennessee Seaplane Company LLC · Knoxville, TNBuilt 1976 · S/N 18265008 N182FSSmall Adam P · Hampden, MEBuilt 1975 · S/N 18263652 N182GBHeem Jeremy Allen · Iowa Falls, IAS/N 18262833 N182HLBelles Flyers Inc · Wilmington, OHBuilt 1973 · S/N 18261843 N182HRHotel Romeo L L C · Ketchum, IDBuilt 1972 · S/N 18261150 N182HSBurris Frank · Gold Beach, ORBuilt 1973 · S/N 18262701 N182JKUrban Larry D · Conroe, TXBuilt 1975 · S/N 18263595 N182JPClass Five Enterprises Inc · Hailey, IDBuilt 1974 · S/N 18263017 N182KACrowbar Aviation LLC · Kellseyville, CABuilt 1973 · S/N 18261682 N182KEAlpine Desert Aviation LLC · Flagstaff, AZBuilt 1975 · S/N 18263657 N182KKSimonson Gale J · Loring, MTBuilt 1971 · S/N 182-60944 N182KWWaage Matthew L · Elkhart Lake, WIBuilt 1974 · S/N 18262889 N182LESuperior Machine Works Inc · Kingsburg, CABuilt 1975 · S/N 18263959 N182LFAie Inc · Murrieta, CABuilt 1973 · S/N 18262352 N182LNYarbro Christopher L · Poplar Bluff, MOBuilt 1976 · S/N 18265048 N182LVGloris Robert J · Lago Vista, TXBuilt 1973 · S/N 18262150 N182LWLoken Rodney R · Northwood, IABuilt 1972 · S/N 18261255 N182LXWave Aero Technology LLC · Rockledge, FLS/N 18262627 N182MBHeartland Airplanes LLC · Olathe, KSS/N 18264405 N182MFCoeur LLC · Coeur D Alene, IDBuilt 1973 · S/N 18262210 N182MKTruitt John H · Pittsburg, TXBuilt 1975 · S/N 18263541 N182NMKozy Mark A · Placerville, CABuilt 1975 · S/N 18263782

Back to Cessna 182P