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.

N76BRKarban Edward W · Valley City, OHBuilt 1976 · S/N 18265107 N76CNDensity Altitude LLC · Colorado Springs, COBuilt 1976 · S/N 18264634 N76HCHp Premier Solutions LLC · Lakeland, TNS/N 18262234 N76RCN76rc LLC · Buckeye, AZS/N 18264691 N76RFWeiman David W R · Oregon, WIBuilt 1976 · S/N 18264735 N7700HBrensing Steve E · Stafford, KSBuilt 1972 · S/N 18261304 N77185Carter Danny · Baxley, GABuilt 1973 · S/N 18261744 N771KCAkin John · Highland, CABuilt 1975 · S/N 18264033 N7722FSmall Tony D · Welch, OKBuilt 1972 · S/N 18261560 N772CGBarefoot Brendan · Four Oaks, NCBuilt 1973 · S/N 18261964 N773DSHotchkiss Anita E · Cody, WYBuilt 1973 · S/N 18262402 N7746GMissionaire · Temple, TXBuilt 1974 · S/N 18263328 N774JA&A Airlines LLC · New Boston, NHBuilt 1974 · S/N 18262887 N774MCDe Camargo Marcelo A · Richmond, TXBuilt 1976 · S/N 18264897 N777HKPremiere Aviation LLC · Evansville, INBuilt 1976 · S/N 18265047 N778EMHorizon Dreams LLC · Homer, GABuilt 1975 · S/N 18263821 N77LCWright Aviation LLC · Sugar Land, TXBuilt 1973 · S/N 18262333 N77TDBeavin Robert A · Wilton Manors, FLBuilt 1976 · S/N 18264747 N77VMBadger Ray · Baker City, ORBuilt 1975 · S/N 18264121 N7806LRegistered aircraftBuilt 1976 · S/N 18264966 N78091Stumberg Richard Kirk · Pottsboro, TXBuilt 1973 · S/N 18261747 N78092Sale Reported · Prescott Valley, AZSale reported, pending cancellationBuilt 1973 · S/N 18261748 N78098Fahrenkamp Russell E · Parker, AZS/N 18261749 N78102Sonoma County Land Company Inc · Santa Rosa, CABuilt 1973 · S/N 18261751 N78115Cm3 LLC · North Las Vegas, NVBuilt 1973 · S/N 18261753 N78133Dancing Buffalo LLC · Shreveport, LABuilt 1973 · S/N 18261755 N7813NOtoole Kevin H · Logandale, NVBuilt 1974 · S/N 18263290 N7826GSeabold Todd J · Craig, COBuilt 1974 · S/N 18263329 N782DGLasalle Investments LLC · Tucson, AZBuilt 1975 · S/N 18263557 N78340Mcclellen Andrew C · Dallas, TXBuilt 1973 · S/N 18261760 N78415Griffith Richard A · College Station, TXBuilt 1973 · S/N 18261763 N78522Jb522 LLC · Pflugerville, TXBuilt 1973 · S/N 18261768 N78556B&T Venutres LLC · Duncan, OKBuilt 1973 · S/N 18261769 N78607Jones John E Jr · Metter, GABuilt 1973 · S/N 18261774 N78720Sale Reported · Greeley, COSale reportedBuilt 1973 · S/N 18261776 N78737Meyer Rex · Harmon, ILBuilt 1973 · S/N 18261778 N78801Stone William · Lexington, KYBuilt 1973 · S/N 18261785 N78PCBombach James · Katy, TXBuilt 1976 · S/N 18264893 N78RRWilkinson William H · Anchorage, AKBuilt 1973 · S/N 18261689 N79074Arrol Keith C · Fairfield, CABuilt 1973 · S/N 18261790 N79107Rosequist Christopher Conrad Trustee · Moyie Springs, IDBuilt 1973 · S/N 18261795 N79128Hawkins Jeffery D · Mandeville, LABuilt 1973 · S/N 18261799 N79140Cho Jong Hoon · Rch Palos Vrd, CAS/N 18261801 N79180Elk Enterprises Ltd · Colorado Springs, COBuilt 1973 · S/N 18261804 N79182Gmk Aviation LLC · Brighton, MIBuilt 1973 · S/N 18261805 N7918NRhv Flyers Inc · San Jose, CABuilt 1974 · S/N 18263292 N79253Shipe Jacqueline M · Louisville, TNBuilt 1973 · S/N 18261807 N79297Bas Part Sales LLC · Greeley, COBuilt 1973 · S/N 18261810 N7929GJenkins Joseph J Jr · Matthews, NCBuilt 1974 · S/N 18263330 N79317Bailey James C II · Drummond Island, MIBuilt 1973 · S/N 18261812

Back to Cessna 182P