OpenAirDocs.org
AD 81-18-04 R2

Registered aircraft · 81,733

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
  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.

N5172WOcala Aviation Services Inc · Ocala, FLBuilt 2002 · S/N 172S9043N5172XO'Daniel Mike · Elkhorn, NEBuilt 1969 · S/N 679N5172ZTurner William J · Twentynine Palms, CABuilt 1961 · S/N 22-8836N51732Imsar LLC · Springville, UTBuilt 2002 · S/N 18281088N51735Styer David B · Milton Freewater, ORBuilt 1978 · S/N 1139N5173LDevries Pat DBA · Germansville, PABuilt 1967 · S/N 28-3994N5173PColorado Aviation Group LLC · Colorado Springs, COS/N 24-192N5173SDamore Joseph · Ingleside, ILBuilt 1970 · S/N 28-7105027N5173TMorris Dennie R · North Fort Myers, FLBuilt 1966 · S/N 545N5173VEastern Kentucky University · Richmond, KYBuilt 2002 · S/N 172S9046N5173XInabnit Michael S · Colville, WABuilt 1969 · S/N 680N5173ZSvenningse Joshua J · Menomonie, WIBuilt 1961 · S/N 22-8837N51748Planenutz LLC · Deland, FLBuilt 1980 · S/N 17274342N5174AWells Lavar W · Hanksville, UTBuilt 1956 · S/N 28174N5174BSky Associates Inc · Jupiter, FLBuilt 1979 · S/N 15283790N5174EBlue Sky Pilots Inc · Salem, ORBuilt 1978 · S/N 17271752N5174HFlying Finn Enterprises LLC · Wilmington, DEBuilt 1975 · S/N 17265360N5174LVentura Robert E · Ventura, CAS/N 28-4459N5174SKatzakian Trevor T · Lodi, CABuilt 1970 · S/N 28-7105028N5174TMarnoch Kenneth S Trustee · Canyon Country, CAS/N 163N5174ZSale Reported · Spearfish, SDSale reportedBuilt 1961 · S/N 22-8838N51757Spencer John S · Indian, AKBuilt 1978 · S/N 423N51758Enstrom Instruction LLC · Newark, DEBuilt 1978 · S/N 435N5175DSlug Air LLC · White Salmon, WABuilt 1966 · S/N 18-8438N5175EWinston Jacob · Granbury, TXBuilt 1978 · S/N 17271753N5175PSbkr LLC · Greenville, PABuilt 2002 · S/N 18281155N5175SBlu Skye Distribution Inc · Mount Holly, NCBuilt 1970 · S/N 28-7105029N5175TMcclain Timothy J · Tucson, AZBuilt 1966 · S/N 147N5175YLutz Aviation LLC · Perkinsville, VTBuilt 2002 · S/N 172S9050N51768Stocker Concrete Co · Gnadenhutten, OHBuilt 1978 · S/N 446N51769Arizona Skies Aviation LLC · Scottsdale, AZS/N 443N5176HBoyer Christopher A · Anchorage, AKBuilt 1948 · S/N 14-196N5176LMilliner Greg A · Kokomo, INBuilt 1967 · S/N 28-4462N5176RRight Rudder Flight Training LLC · La Verne, CABuilt 1979 · S/N 172RG0044N5176SNora Jet LLC · Granbury, TXS/N 28-7105030N5176TScott Judson M · Wasilla, AKBuilt 1967 · S/N 153N5176VVangorder Donna · Greenwood, ARS/N 172RG0459N51770Lrh Equipment LLC · Pendleton, ORS/N 445N51778Medical Evacuation Disaster Intervention Corps · Springdale, ARS/N 451-2N5177FPray Aviation Inc · Augusta, KSBuilt 1976 · S/N 28-7715096N5177HPomeroy Cattle Ranch LLC · Kalispell, MTBuilt 1975 · S/N 17265361N5177PLi Steven Y · Warren, NJBuilt 1958 · S/N 24-197N5177TJensen Larry F · Millington, MIBuilt 1967 · S/N 219N5177WBuffham Daniel L · Meridian, IDBuilt 1961 · S/N 28-212N5177XAdams John L · Carmi, ILBuilt 1969 · S/N 683N51782Ranger Lumber Corp · Springfield, MABuilt 2002 · S/N 18281096N51784Winingar Thomas M · Brock, TXBuilt 2002 · S/N 18281097N51785Photos Unlimited · Rancho Cordova, CABuilt 2002 · S/N 18281098N51787Holder Michael T · Whitesburg, GABuilt 1980 · S/N 1172N51788Rhoads Timothy C · Logan, NMBuilt 1978 · S/N 452-2
Back to AD 81-18-04 R2