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.

N55242Hills Holding · Newark, DEBuilt 1981 · S/N 17275142N55246Kadena Aero Club · Apo, APBuilt 1981 · S/N 17275143N5524SStellon Eugene A Jr · Burlington, CTBuilt 1980 · S/N R18201594N55250Colorado Aircraft Corp · Watkins, COBuilt 1981 · S/N 17275144N55256Notam Aviation LLC · Portage Des Sioux, MOBuilt 1981 · S/N 17275146N5525HStewarts Aircraft Service Inc · Waynesville, OHBuilt 1979 · S/N 15284114N5525TDavis Ronnie L · Okmulgee, OKBuilt 1964 · S/N 17251425N5525USheriffs Department · Oakland, CABuilt 1979 · S/N U20605311N55264Ace Aircraft Leasing Inc · Nazareth, PABuilt 1981 · S/N 17275147N5526BDoelger Parker · Norwood, NYBuilt 1956 · S/N 33526N5526RQualitair LLC Trustee · MichelstadtS/N 172RG0070N5527AMokiy LLC · Aurora, ORBuilt 1985 · S/N P21000861N5527BAdrenaline Inc · Chambersburg, PAS/N 33527N5527CMetzka Andrew J · Chillicothe, ILBuilt 1950 · S/N 19574N5527GFly Around Alaska LLC · Palmer, AKBuilt 1969 · S/N 15071027N5527RSchultz David M · East Gull Lake, MNBuilt 1965 · S/N 17253106N5527SSilver State Aero Group LLC · Discovery Bay, CABuilt 1980 · S/N R18201595N5528AWarden Hutterian Brethren · Warden, WAS/N 21063482N5528CBaum Jeffrey C · Sheridan, WYBuilt 1950 · S/N 19575N5528GRick Aviation Inc · Newport News, VABuilt 1969 · S/N 15071028N5528RVroom Brian D · Tucson, AZS/N 172RG0071N5528SCenturion N761lu LLC · Mukilteo, WABuilt 1980 · S/N R18201596N55291Riverside Flight Academy LLC · Riverside, CABuilt 1981 · S/N 17275152N55299Trego/Dugan Aviation Of Grand Island Inc · Grand Island, NEBuilt 1981 · S/N 17275154N5529CHaralson Stephen K Trustee · Claremore, OKBuilt 1950 · S/N 19576N5529GSmoot Jeremy D · Fort Wayne, INS/N 15071029N5529NTime 2 Fly LLC · Conroe, TXBuilt 1980 · S/N 18267771N5529RCarlson Scott M · Sycamore, ILBuilt 1965 · S/N 17253109N5529SBreaking Wind Aviation LLC · Brainerd, MNBuilt 1980 · S/N R18201597N5529TCornell James R · Winston Salem, NCBuilt 1964 · S/N 17251429N5529VCandlestick Aviation Services LLC · Lewes, DEBuilt 1984 · S/N T30300303N552KKing Monte L · Kerrville, TXBuilt 1973 · S/N 177RG0367N552RAGuzman Jose D · Arecibo, PRBuilt 1972 · S/N 15074066N552RWWelch Richard L · Tazewell, TNBuilt 1977 · S/N 18265691N552RYYoreck Robert J Jr · Clarksville, TNBuilt 1965 · S/N 17253073N5530BInternational Air Services Inc Trustee · Carson City, NVBuilt 1956 · S/N 33231N5530ERovey Land & Cattle Co · Parker, AZBuilt 1979 · S/N 18503989N5530RHarris Marilyn L · Hugoton, KSBuilt 1965 · S/N 17253110N5531ASouther Field Aviation Inc · Americus, GAS/N 21063484N5531BNighthawk N8231g LLC · Granite Bay, CAS/N 33531N5531HXin Han Aviation LLC · Atwater, CABuilt 1979 · S/N 15284118N5531MPeterson Jay O · Las Vegas, NVBuilt 1980 · S/N 15284606N5531RAbraham Philip L · Amery, WIBuilt 1965 · S/N 17253111N5531TLegault Marcus · Frazier Park, CABuilt 1964 · S/N 17251431N55320Dragon Flight Training Academy LLC · Pembroke Pines, FLBuilt 1981 · S/N 17275157N55325Hater Michael A · Cincinnati, OHBuilt 1981 · S/N 17275158N5532NTriple L Aviation LLC · Loveland, COFirst renewal noticeBuilt 1980 · S/N 18267774N5532RGreco Anthony · Walworth, WIBuilt 1965 · S/N 17253113N5532SAks Aviation LLC · Arroyo Grande, CABuilt 1980 · S/N R18201598N55332Reed Matthew A · Burnsville, MNBuilt 1975 · S/N 15076850
Back to AD 87-20-03 R2