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.

N79324Cochrane William R · Paso Robles, CAFirst renewal noticeBuilt 1973 · S/N 18261814 N79408Voorhees Charles Kirker · Tappahannock, VABuilt 1973 · S/N 18261816 N79424Mccutchan Anthony L · Collinsville, OKBuilt 1973 · S/N 18261818 N79439Asm Aviators LLC · Racine, WIBuilt 1973 · S/N 18261820 N79459Resort Region Flying Club LLC · Kalispell, MTBuilt 1973 · S/N 18261821 N79463Riley Richard G Jr · New Brighton, PABuilt 1973 · S/N 18261825 N79467Horschel Duane D · Springville, NYBuilt 1973 · S/N 18261828 N79522729 Air LLC · Las Vegas, NVBuilt 1973 · S/N 18261832 N79585Valley Forge Aviators LLC · King Of Prussia, PABuilt 1973 · S/N 18261836 N79586Booth James L · Fort Collins, COBuilt 1973 · S/N 18261837 N79589Aqua Irrigation Technologies LLC · Parma, IDBuilt 1973 · S/N 18261838 N79590Corrigan Michael D · Hondo, TXBuilt 1973 · S/N 18261839 N79598Keck Shawn M · Santa Cruz, CAS/N 18261840 N7969JPegasus Air Ventures LLC · Macedon, NYBuilt 1976 · S/N 18264871 N797CJSteim Joseph M · Shirley, MABuilt 1975 · S/N 18263827 N79882Webbs Wildlife Consultants LLC · Park City, MTBuilt 1973 · S/N 18261841 N79927Tiger Field Aviation LLC · Lake Butler, FLS/N 18261846 N79933Ajr Rentals LLC · Mulino, ORBuilt 1973 · S/N 18261847 N79958Gilbert Paul Russell · Dothan, ALBuilt 1973 · S/N 18261850 N799HLNevison Shane · Lebanon, MEBuilt 1974 · S/N 18262733 N7HRCessna 182p N7hr LLC · Homer, AKBuilt 1975 · S/N 18264253 N7REMid Tex Controls Inc · Krum, TXBuilt 1975 · S/N 18264434 N7TTWright Gregory B DBA · Amarillo, TXBuilt 1973 · S/N 18262408 N7YXOc Aviators LLC · Troy, TNBuilt 1976 · S/N 18264894 N800JKWingjet Aviation LLC · Howard City, MIBuilt 1975 · S/N 18263593 N800JWImperial Valley Flight Training LLC · Calexico, CABuilt 1973 · S/N 18262541 N8031QDonihoo Phillip D · Oklahoma City, OKBuilt 1974 · S/N 18262872 N8045Mcclure Richard A · Edna, TXS/N 18262046 N8048MWilson Curtis E · Townsend, GABuilt 1976 · S/N 18264532 N804CAAshley Nostalgia · Midlothian, TXBuilt 1974 · S/N 18262942 N8058MMaxfield Aviation LLC · Seattle, WABuilt 1976 · S/N 18264534 N8065MStoll Albert G · Healdsburg, CABuilt 1976 · S/N 18264536 N8102MShannon Michael E · Richland, WAS/N 18264540 N8104MMakati 121 LLC · Las Vegas, NVBuilt 1976 · S/N 18264541 N8105MSudworks Aviation LLC · Ardmore, OKBuilt 1976 · S/N 18264542 N8125MDobson Air Enterprise LLC · College Station, TXBuilt 1976 · S/N 18264543 N8128MSchwartz Donald G · Elroy, WIBuilt 1976 · S/N 18264544 N812KKKerscher Helen A · Los Lunas, NMBuilt 1974 · S/N 18262759 N812PLCirrusair LLC · Missoula, MTBuilt 1975 · S/N 18263781 N8136MTakeair LLC · Incline Village, NVBuilt 1976 · S/N 18264546 N8149MMcinnish John · Tallassee, ALBuilt 1976 · S/N 18264547 N814JHOcean Ave LLC · Mound House, NVS/N 18264821 N815GKN114jr LLC · Parrish, FLBuilt 1973 · S/N 18262599 N8185GJohnston John Lane · Houston, TXBuilt 1974 · S/N 18263337 N8187MMoose Eddy · Tyler, TXBuilt 1976 · S/N 18264556 N8189GBeebe Brad A · Clinton, MOBuilt 1974 · S/N 18263341 N8191GGroce James D · Portland, ORS/N 18263343 N8196MEmry Kent · Salem, ORBuilt 1976 · S/N 18264560 N8197GDeason Warren Douglas · Marietta, GABuilt 1974 · S/N 18263349 N8199QTb Aviation LLC · Waukee, IABuilt 1975 · S/N 18263870

Back to Cessna 182P