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.

N58467Schaefer Leonard · Oak Dale, PABuilt 1973 · S/N 18262081 N58469Caj Holdings LLC · College Station, TXBuilt 1973 · S/N 18262083 N58470Kraiger Rockne C Trustee · Galesburg, MIBuilt 1973 · S/N 18262084 N58472West Central Construction LLC · Indian Valley, IDBuilt 1973 · S/N 18262086 N58483Thaxton James T · Mcminnville, TNBuilt 1973 · S/N 18262093 N58484Centurion Enterprises Inc · Lake Elmo, MNBuilt 1973 · S/N 18262094 N58488Gillies Ken G · Stockton, CABuilt 1973 · S/N 18262097 N58496Gubran Robert S · Monterey Park, CABuilt 1973 · S/N 18262103 N58498Wooding William W · Anacortes, WABuilt 1973 · S/N 18262104 N584AFAda Forestry Division · Malvern, ARBuilt 1972 · S/N 18261153 N58504P S C Flyers · Cardiff By The Sea, CABuilt 1973 · S/N 18262107 N58505Pike Medical Inc · Chillicothe, OHBuilt 1973 · S/N 18262108 N58506Krume Eric R · Castle Rock, WABuilt 1973 · S/N 18262109 N58515Cowan Michael A · Buckeye, AZBuilt 1973 · S/N 18262115 N58517Walthers Michael L · Portland, ORBuilt 1973 · S/N 18262116 N58518N58518 Flying Club LLC · Vancouver, WABuilt 1973 · S/N 18262117 N58522Ryan Donald E · Fort Payne, ALBuilt 1973 · S/N 18262119 N58546Satara Inc · Frisco, TXBuilt 1973 · S/N 18262130 N58548Khbp LLC · Donnelly, IDBuilt 1973 · S/N 18262132 N58549Sale Reported · Rio Rico, AZSale reported, canceledBuilt 1973 · S/N 18262133 N58554Mocking Bird Aviation LLC · Hanover, PAS/N 18262137 N58558Long William E · Old Town, FLBuilt 1973 · S/N 18262139 N58560N58560 LLC · Zionsville, INBuilt 1973 · S/N 18262140 N58580Trgn LLC · Charleston, WVBuilt 1973 · S/N 18262153 N58582Hunsaker Joshua James · Turner, ORBuilt 1973 · S/N 18262154 N58583Triesch Charles · Houston, TXBuilt 1973 · S/N 18262155 N58586Bullock Gary L · Saint Regis, MTBuilt 1973 · S/N 18262158 N58591Blue Skies Aero Club · Redmond, WABuilt 1973 · S/N 18262162 N58593North Kern Aviation Inc · Wasco, CABuilt 1973 · S/N 18262164 N58597Smith John N · Martinsville, INBuilt 1973 · S/N 18262167 N585BBStrickland Tracy · Driggs, IDBuilt 1973 · S/N 18262136 N585DBCoppeta Alfred J · Altoona, PABuilt 1973 · S/N 18262120 N58601Baker Ranches Inc · Baker, NVBuilt 1973 · S/N 18262169 N58602Leatherwood Aviation LLC - Rs N58602 · College Station, TXBuilt 1973 · S/N 18262170 N58607Pendlebury David A · Pittsboro, NCS/N 18262172 N5860JMcclain Kevin D · Westminster, CABuilt 1975 · S/N 18263567 N58620Ries Farms LLC · Hastings, MNBuilt 1973 · S/N 18262179 N58624Hoefer Bradley W · Steamboat Springs, COFirst renewal noticeBuilt 1973 · S/N 18262182 N58626Rainbow Flight Inc · Felda, FLBuilt 1973 · S/N 18262184 N58628Alste LLC · Seattle, WABuilt 1973 · S/N 18262186 N5862JChase Benjamin A · West Chesterfield, NHBuilt 1975 · S/N 18263569 N58631Strickler Hayden B · Euclid, MNS/N 18262188 N58633Trisha Parker Real Estate Inc · Port Angeles, WAS/N 18262190 N58634Poutre Robert P · Osceola, WIBuilt 1973 · S/N 18262191 N58635Decourley Claudette · San Diego, CABuilt 1973 · S/N 18262192 N58636Adventist World Aviation Inc · Wilson, NCBuilt 1973 · S/N 18262193 N58641Goodell Scott W · Humboldt, IAS/N 18262198 N58645Bishop Chuck W · Gilbert, AZBuilt 1973 · S/N 18262201 N58646Capper Flying Club Inc · Lancaster, CABuilt 1973 · S/N 18262202 N58650Orwosky Jeff · Sulphur Springs, TXBuilt 1973 · S/N 18262205

Back to Cessna 182P