OpenAirDocs.org
AD 87-20-03 R2

Registered aircraft · 54,017

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:87-20-03-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:87-20-03-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.

N400HXTevis David James · Colorado Springs, COBuilt 1964 · S/N 21058352N400JGParsons David E · Panama City Beach, FLBuilt 1969 · S/N 17701347N400KClydesdale Asset Management LLC · Park City, UTBuilt 1979 · S/N 18503889N400LDreher Steve · Bettendorf, IABuilt 1967 · S/N 17700278N400LAPacific Fleet Aviation LLC · Rochester, NYS/N 17274388N400NAAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N R18201890N400SJLockeby Aviation LLC · Norman, ARBuilt 1978 · S/N R1722876N400SKCappello Dave A · Cottonwood, CABuilt 1967 · S/N 17256077N4010FLarsen Harry A · The Dalles, ORBuilt 1958 · S/N 36910N4010UPorter Christopher · Pinnacle, NCBuilt 1965 · S/N 15061410N4010VSale Reported · Saint Joseph, MOSale reportedBuilt 1948 · S/N 18329N4011DSkydive Inc · Eagle Creek, ORBuilt 1957 · S/N 34711N4011FMiller Kerry N · Owensville, MOBuilt 1958 · S/N 36911N4011UGreene Pete M · Pembroke Pines, FLBuilt 1965 · S/N 15061411N4011VDeal Michael R · Elko, NVBuilt 1948 · S/N 18330N4012DEdgren Erik J · Oskaloosa, IABuilt 1957 · S/N 34712N4012UMorris Donna L · Yelm, WABuilt 1965 · S/N 15061412N4012VBaker Air Service Inc · Baker, MTBuilt 1948 · S/N 18331N4013Peters Joseph J · Brentwood, TNBuilt 1973 · S/N 18052326N4013JMacomber Daniel · Chehalis, WABuilt 1966 · S/N 15065313N4013ULetourneau University · Longview, TXBuilt 1965 · S/N 15061413N4013VBaldwin John D · Sisters, ORBuilt 1948 · S/N 18332N4014FMaxification LLC · Lavonia, GABuilt 1958 · S/N 36914N4014YFogglifter LLC · Mccall, IDS/N 185-0214N4015DCotten Randy · Belgrade, MTBuilt 1957 · S/N 34715N4016DBates Michael B · Medford, ORBuilt 1957 · S/N 34716N4016UThompson Don E · Long Beach, CABuilt 1965 · S/N 15061416N4017VSimpson James H · Craig, COBuilt 1948 · S/N 18336N4017Y17y LLC · Parma, IDBuilt 1961 · S/N 185-0217N40184Stoots David A · Fairbanks, AKBuilt 1958 · S/N 55245N4018DUnderhill Clinton T · Yuma, AZS/N 34718N4019JPowell Edward H · Potsdam, NYBuilt 1966 · S/N 15065319N4019UWeeks Lindell M · Kingston, NHBuilt 1965 · S/N 15061419N4019VEastman Gregory L · Pueblo, COBuilt 1948 · S/N 18338N4019YWitt William A · Ennis, MTBuilt 1961 · S/N 185-0219N401DSalsola Logistics LLC · Douglas, WYBuilt 1977 · S/N 18503517N401DTKairos Holdings LLC · Huntsville, ALBuilt 1981 · S/N 17275165N401FEasley Daniel W · Wasilla, AKBuilt 1953 · S/N 26115N401GTCastillo Giovanny G · Brodheadsville, PABuilt 1966 · S/N 17255188N401HXThree Forks Flying Club Inc · Three Forks, MTFirst renewal noticeBuilt 1974 · S/N 17263490N401LSEl Paso Aero Inc · El Paso, TXBuilt 1982 · S/N 17275784N401MPFriend Ships · Lake Charles, LABuilt 1979 · S/N P21000280N401NKLoya Christopher Nmi · Houston, TXS/N R172-0229N401SSN401ss LLC · Arvada, COBuilt 1976 · S/N 18265067N401SUWright Air Service Inc · Fairbanks, AKBuilt 1975 · S/N U20602932N401WCNakochna River Resort LLC · Willow, AKS/N 18502235N4020FBarnard David P · Delmar, NYBuilt 1958 · S/N 36920N4020VDanielson Bradley M · Pelkie, MIBuilt 1975 · S/N 15076680N4021Nighthawk N8231g LLC · Pompano Beach, FLBuilt 1979 · S/N 17272149N4021D21d LLC · West Henrietta, NYBuilt 1957 · S/N 34721
Back to AD 87-20-03 R2