Skip to content

Registered aircraft · 465

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

N739JHEfinger John · Cresson, TXBuilt 1979 · S/N R18201000 N739VHChristopherson Kevin · Casper, WYBuilt 1979 · S/N R18201010 N7426SDanick Mechanical Inc · Nicolaus, CABuilt 1981 · S/N R18201711 N7560SBeatty David · Hollister, CABuilt 1981 · S/N R18201712 N7567MGabbard Michael · Jupiter, FLBuilt 1979 · S/N R18200900 N756ALLange Robert Brandt · Newport Beach, CABuilt 1979 · S/N R18201023 N756CCBrown Travis J · Lincoln, ALS/N R18201035 N756CKMckee Jay Russell · Baggs, WYBuilt 1979 · S/N R18201038 N756CXCahill Brian H · Valley Center, CABuilt 1979 · S/N R18201042 N756CZRegistered aircraftBuilt 1979 · S/N R18201043 N756EVOyarzo Benjamin C · Cascade, IDBuilt 1979 · S/N R18201056 N756EZBear Branch Hedeen LLC · Meridian, IDBuilt 1979 · S/N R18201058 N756FCSunny Aviation Investments Inc · San Francisco, CABuilt 1979 · S/N R18201059 N756FZM And S 182 LLC · Torrance, CAS/N R18201069 N756GEAbraham Curtis L · Byron, WYBuilt 1979 · S/N R18201071 N756GLLawrence Cyril Leonard · Merced, CABuilt 1979 · S/N R18201073 N756GZGlasow Zachary · Klamath Falls, ORBuilt 1979 · S/N R18201075 N756HVGmlc Investors LLC · Santa Rosa, CAS/N R18201078 N756JBRocky Mountain Great Planes LLC · Loveland, COBuilt 1979 · S/N R18201080 N756JLN756jl LLC · Virginia Beach, VABuilt 1979 · S/N R18201082 N756JPHjs Aviation LLC · Fort Collins, COBuilt 1979 · S/N R18201083 N756JSRedline Engineering Inc · Greenwood, CABuilt 1979 · S/N R18201085 N756JYLadnier Ronald R · Lone Tree, COBuilt 1979 · S/N R18201088 N756KQTorgerson Kristofer · Knoxville, TNS/N R18201094 N756KSSmart Ray · Burbank, CABuilt 1979 · S/N R18201096 N756KVBeckert Richard D · Lake Stevens, WABuilt 1979 · S/N R18201097 N756LQC2c Investments LLC · St George, UTBuilt 1979 · S/N R18201102 N756NPAmerican Financial Services Inc · Las Vegas, NVBuilt 1979 · S/N R18201119 N756NYKempton Larry G · Grand Junction, COS/N R18201122 N756RNCrossbrook LLC · Willoughby, OHBuilt 1979 · S/N R18201137 N756RPWayman Keith M · Longmont, COBuilt 1979 · S/N R18201138 N756RVDobson Thomas J · Los Alamos, NMBuilt 1979 · S/N R18201141 N756RWAir America Trading LLC · Phoenix, AZBuilt 1979 · S/N R18201142 N756SENotus LLC · Winfield, KSBuilt 1979 · S/N R18201143 N756SWSale Reported · Basom, NYSale reportedBuilt 1979 · S/N R18201148 N756TCHazelrigg Geoffreya · Chalfont, PABuilt 1979 · S/N R18201149 N756TLMichael Maiden LLC · Sandy, ORS/N R18201151 N756TUMehr David L Trustee · Mesa, AZBuilt 1979 · S/N R18201154 N756UBSayer Wayne · Bishop, CABuilt 1979 · S/N R18201156 N756UCJohnsen Ronald R · Des Moines, IAFirst renewal noticeBuilt 1979 · S/N R18201157 N756UE756ue LLC · Kalispell, MTS/N R18201158 N756UHMiller Justin · Big Sky, MTBuilt 1979 · S/N R18201159 N756VEMac Air Consulting LLC · Mesa, AZS/N R18201164 N756VPBurris W Tim · Tucson, AZBuilt 1979 · S/N R18201168 N756VSMystery Air LLC · Walker, LABuilt 1979 · S/N R18201169 N756WEJames F Barnes · Laguna Niguel, CABuilt 1979 · S/N R18201176 N756WVMr Cake LLC · Missoula, MTBuilt 1979 · S/N R18201180 N756WWLockwood William A · Okanogan, WABuilt 1979 · S/N R18201181 N756XFWeaver Michael L · Leawood, KSBuilt 1979 · S/N R18201183 N756XMYounan Dalour · San Diego, CABuilt 1979 · S/N R18201186

Back to Cessna TR182