Skip to content

Registered aircraft · 784

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

N4987DKemp William L · Ellsworth, MIS/N 51087 N4989DSwindle Jeffrey D · Lafayette, TNBuilt 1958 · S/N 51089 N4992DSkydive Cross Keys LLC · Williamstown, NJBuilt 1958 · S/N 51092 N4993DPoole Jason · Quanah, TXS/N 51093 N4998DWood Andrew A · Clifton Springs, NYBuilt 1958 · S/N 51098 N4999DMielke Martin W · Valley City, OHBuilt 1958 · S/N 51099 N4LTRegistered aircraftFirst renewal noticeBuilt 1957 · S/N 34686 N5001DTatter David W · Kingman, AZBuilt 1958 · S/N 51101 N5003DLawrence Richard D · Le Roy, NYBuilt 1958 · S/N 51103 N5006DClosson Luke E Jr · Valdosta, GABuilt 1958 · S/N 51106 N5008DDufriend Daren P · Payson, AZBuilt 1958 · S/N 51108 N5014DHall Matthew A · Coeur D Alene, IDBuilt 1958 · S/N 51114 N5016DCain Arthur W · Kenilworth, NJRegistration revokedBuilt 1958 · S/N 44720D N5017DGraham Thomas V · San Rafael, CAS/N 51117 N5019DNobel John C · Brandon, FLBuilt 1958 · S/N 51119 N5020DSpiro Paul M · Anchorage, AKBuilt 1958 · S/N 51120 N5022DSearey 806 LLC · Weirsdale, FLBuilt 1958 · S/N 51122 N5024DGordon Glen M · Corning, CABuilt 1958 · S/N 51124 N5026DRoss George W · Boise, IDS/N 51126 N5027DTucker Austin L · Spooner, WIBuilt 1958 · S/N 51127 N5028DSanders Jess E · Troy, MTBuilt 1958 · S/N 51128 N5029DUrban Cowboy Aviation LLC · Richland, NES/N 51129 N5036DPfeil Carl A · Mendocino, CABuilt 1958 · S/N 51136 N5037DC & R Leasing LLC · Fairbanks, AKBuilt 1958 · S/N 51137 N5039DUp Above Ak LLC · Wasilla, AKBuilt 1958 · S/N 51139 N5041D5041 Delta LLC · Three Forks, MTBuilt 1958 · S/N 51141 N5044DCarpenter Corey · Warden, WAS/N 51144 N5047DMarler Don T · Pocatello, IDBuilt 1958 · S/N 51147 N5051DVincent Wendal J · Geismar, LABuilt 1958 · S/N 51151 N5052DFertic Knute · Oklahoma City, OKBuilt 1958 · S/N 51152 N5053DRancho Equipment Leasing LLC · Brownsville, TXBuilt 1958 · S/N 51153 N5054DK&L Tech Inc · Adams, NEBuilt 1958 · S/N 51154 N5057DLatham Travis W · Round Rock, TXBuilt 1958 · S/N 51157 N5059DJk Aviations LLC · Yardley, PABuilt 1958 · S/N 51159 N5064DPershing Flying Club Inc · Lovelock, NVBuilt 1958 · S/N 51164 N5065DWharton Edwin Scott · Anchorage, AKBuilt 1958 · S/N 51165 N5066DCurry Timothy S · Salisbury, MDBuilt 1958 · S/N 51166 N5071DAcmx LLC · Cedar Rapids, IAS/N 51171 N5074DAhumada George · Palmer, AKBuilt 1958 · S/N 51174 N5077DPrentiss Zachary Callan · Grand Junction, COBuilt 1958 · S/N 51177 N507SDKnapp Jason D · Schenevus, NYBuilt 1958 · S/N 34950 N5080DJohnson Kenneth J · Red Bluff, CAS/N 51180 N5082DRegistered aircraftBuilt 1958 · S/N 51182 N5084DArrow LLC · Pateros, WABuilt 1958 · S/N 51184 N5085DHawkes Brian R · Hamilton, MTBuilt 1958 · S/N 51185 N5086DGillaspy Paul J · Orcutt, CABuilt 1958 · S/N 51186 N5087DPenz Johnathan D · Russian Mission, AKBuilt 1958 · S/N 51187 N5088DBaughman Jeffrey S · Keller, TXBuilt 1958 · S/N 51188 N5089DMorales Josh S · Anchorage, AKBuilt 1958 · S/N 51189 N5091DKuhn Chad · Boulder, WYBuilt 1958 · S/N 51191

Back to Cessna 182A