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.

N91415Hangar R LLC · Irvington, ALBuilt 1973 · S/N 18261999 N9141MSkyview Aviation LLC · Tracy, CABuilt 1976 · S/N 18264699 N91427Curry Phillip S · Seal Beach, CABuilt 1973 · S/N 18262000 N91451Pettus Const Inc · Dallas, GABuilt 1973 · S/N 18262004 N91484Scovel Simeon Edwin · Ontario, CABuilt 1973 · S/N 18262006 N91489Dan River Aero Club Inc · Jonesville, NCBuilt 1973 · S/N 18262008 N9148MBlackhole Inc · Round Rock, TXBuilt 1976 · S/N 18264702 N9151MMcatee Kevin Patrick Trustee · Ventura, CABuilt 1976 · S/N 18264703 N9154MUpupnaway LLC · Concord, NCBuilt 1976 · S/N 18264705 N9155MMain Line Flying Association Inc · Blue Bell, PABuilt 1976 · S/N 18264706 N9156MJolliff Richard · Brady, TXBuilt 1976 · S/N 18264707 N916DFGasmire Charles · Frisco, TXBuilt 1975 · S/N 18264026 N9171MCarbon 182 LLC · Montgomery, TXBuilt 1976 · S/N 18264717 N9172MWebster Lyle H · Wichita, KSBuilt 1976 · S/N 18264718 N9175MStrahm Loren · Holtville, CABuilt 1976 · S/N 18264720 N9176MGuadagnola Vincent J · Spring, TXBuilt 1976 · S/N 18264721 N9178MSafe Flow Aviation LLC · Houston, TXBuilt 1976 · S/N 18264723 N9179MDaybreak Aviation LLC · Wellington, ALBuilt 1976 · S/N 18264724 N917AMWhitley Steven G Trustee · Clearwater, FLBuilt 1975 · S/N 18263707 N9180MHaynes Thomas E · Avon Park, FLS/N 18264725 N9181MBain Justin K · Telluride, COBuilt 1976 · S/N 18264726 N9182MNielsen Jeffery Stephen · Ashland, ORBuilt 1976 · S/N 18264727 N9183MSouthern Aerobatics Inc · Boynton Beach, FLBuilt 1976 · S/N 18264728 N9185MGoddard Aircraft Club Inc · Crofton, MDBuilt 1976 · S/N 18264730 N9189MFinnegan Patrick T · West Lafayette, INS/N 18264733 N9190MBgm Aero Inc · North Zulch, TXBuilt 1976 · S/N 18264734 N9199MBlue Sky Flyers Inc · Greeley, COBuilt 1976 · S/N 18264739 N91DJNola Knewbees LLC · New Orleans, LABuilt 1974 · S/N 18262605 N9203GStohr Jeffry M · Aberdeen, SDBuilt 1974 · S/N 18263392 N922RASchubert Brothers Aviation Inc · Canandaigua, NYBuilt 1973 · S/N 18262609 N923JLdk Associates LLC · Colorado Springs, COBuilt 1975 · S/N 18264138 N9243FCig Aviation LLC · Littleton, COS/N 18261925 N9287GCook Lynn H · Highland, UTBuilt 1971 · S/N 18260827 N9288GPupkar Stephen B · Brookeville, MDS/N 18260828 N9289GBolands North Inc · Binghamton, NYBuilt 1971 · S/N 18260829 N9290GPhillips Richard L · Vienna, OHBuilt 1971 · S/N 18260830 N9296GGreen Daniel C · Cedar Hill, TNBuilt 1971 · S/N 18260836 N9298GA&A Aviation LLC · Mountain Brk, ALS/N 18260838 N9303GBenson Steve J · Keenesburg, COBuilt 1971 · S/N 18260843 N9306GPaiva Rafael R · College Station, TXBuilt 1971 · S/N 18260846 N9307GSchwaderer Delbert L · Stevensville, MTBuilt 1971 · S/N 18260847 N9308GBoilermaker-Warrior Express LLC · Grosse Pointe, MIBuilt 1971 · S/N 18260848 N9309GHagle Terry A · Niceville, FLBuilt 1971 · S/N 18260849 N9310GBaldwin James C · Fruita, COBuilt 1971 · S/N 18260850 N9311GSooter Craig · Blue Ridge, TXBuilt 1971 · S/N 18260851 N9312GYoung Robert S IV · Abilene, TXBuilt 1971 · S/N 18260852 N9314GPeerbolte John K · Highland, INBuilt 1971 · S/N 18260854 N931EMClackamas County Sheriffs Office · Oregon City, ORBuilt 1975 · S/N 18263643 N9320GChiles Farms LLC · Hooper, COBuilt 1971 · S/N 18260860 N9321GFontana Michael A · Kirkwood, MOS/N 18260861

Back to Cessna 182P