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.

N59CKSig Properties LLC · Helena, ARFirst renewal noticeBuilt 1972 · S/N 18261416N59JFJpf Holdings LLC · Wilmington, DEBuilt 1977 · S/N R1722325N59KHKrause Wesley A · Big Bear City, CABuilt 1972 · S/N 18261378N59KMMatthews Casey D · Fort Worth, TXBuilt 1959 · S/N 50503N59MJSweatt Greg · Cochise, AZBuilt 1970 · S/N 18260369N59MPPilch Michael Joseph · Sheridan, WYBuilt 1959 · S/N 50624N59PGStone Aviation Holdings LLC · Myrtle Beach, SCBuilt 1971 · S/N 17260347N59VLKelley Aircraft LLC · Weyers Cave, VABuilt 1971 · S/N 17259905N59WAAdventist World Aviation Inc · Wilson, NCBuilt 1975 · S/N U20602958N59XPCobb John M · Fayetteville, TNBuilt 1977 · S/N R1722015N59YYBay Richard P · West Jordan, UTBuilt 1960 · S/N 56429N5AKHackler Tara Cole · Bend, ORBuilt 1977 · S/N 17268768N5BNMountain Air Inc · Quincy, CABuilt 1973 · S/N 15075144N5BWThompson Aubrey C · Wilmington, NCBuilt 1968 · S/N 15069426N5CMBramall Buster I · Waxahachie, TXBuilt 1973 · S/N 17262655N5CYKawasaki Clyde H · Carson City, NVS/N P337-0083N5DJMyers Bradley J · Madisonville, KYBuilt 1974 · S/N 21060399N5DTFive Delta Tango LLC · Tucson, AZBuilt 1970 · S/N 15071977N5EA310 LLC · Conover, NCBuilt 1975 · S/N U20602711N5EJJones Eric M · Southbridge, MAS/N 177RG0167N5ERMill Direct Textiles LLC · Rollinsford, NHBuilt 1982 · S/N T30300137N5FBRichers David M · Thornton, COBuilt 1966 · S/N 17255431N5GAActon Steve · Reno, NVS/N P21000189N5GSOllman Matthew P · Poplar Grove, ILS/N 33721N5HRRay Tanner Motors Inc · Phoenix, AZFirst renewal noticeBuilt 1980 · S/N 18267523N5HVOppegard Nicholas D · Eagle River, AKBuilt 1958 · S/N 55366N5JPWard Russell S · Kingman, AZS/N 15065872N5JTTj Air Holdings Inc Trustee · Wilmington, DEBuilt 1972 · S/N 33701468N5KRHana Like II LLC · Kailua Kona, HIBuilt 1979 · S/N P3370335N5KVAdara Aircraft LLC · Burleson, TXS/N P3370338N5LPMeeks Trevor · Vineburg, CABuilt 1950 · S/N 19695N5LQCollignon William A Jr · Muscle Shoals, ALBuilt 1969 · S/N 33701202N5LSE&K Aero LLC · Friendswood, TXBuilt 1969 · S/N 18259862N5NHower James A · Horseshoe Bay, TXBuilt 1949 · S/N 7356N5PCKeck Kevin W Trustee · Meridian, IDBuilt 1977 · S/N 18265656N5PTMunson George R · Westhampton, MABuilt 1972 · S/N 17260628N5QUnusual Attitudes LLC · Thomas, OKBuilt 1982 · S/N 18268247N5RBBanasik Associates Inc · Columbus, OHBuilt 1976 · S/N 177RG0968N5RWToms Ronald C · Lena, LABuilt 1970 · S/N 17259649N5RZBbz Consulting LLC · Cody, WYBuilt 1974 · S/N 33701554N5SCGarrett John R II · Waxhaw, NCS/N 18261939N5SUFlorida Skymaster LLC · Cape Coral, FLBuilt 1969 · S/N 337-1134N5VAVirginia Department Of Aviation · Richmond, VABuilt 1976 · S/N U20603223N5VEMurphee Koby T · Spirit Lake, IDBuilt 1976 · S/N 18264950N5YXRed Arrow Aviation LLC · Santa Teresa, NMBuilt 1981 · S/N 17275266N5ZBBlue Aviation Inc · Venice, FLFirst renewal noticeBuilt 1972 · S/N 18261631N5ZXPush Pull LLC · Lewes, DEBuilt 1977 · S/N P3370273N5ZZLeirer Von O · Los Gatos, CABuilt 1977 · S/N 18265840N60002Kirmeyer Dana L · Calhoun City, MSBuilt 1968 · S/N 15069998N6000ARichards John M · Oregon City, ORBuilt 1956 · S/N 28600
Back to AD 87-20-03 R2