OpenAirDocs.org
AD 87-20-03 R2

Registered aircraft · 54,019

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.

N1898XScott Ayer Interests LLC · Phoenix, AZBuilt 1982 · S/N R18201898N1898ZSmart Robbie A · Wasilla, AKBuilt 1962 · S/N 205-0098N1899CBarron Jon M · Perry, MOBuilt 1953 · S/N 26044N1899MLoki Adventures LLC · Norwood, COBuilt 1975 · S/N 18264472N1899QAlvord Jeffrey C · Tucker, GABuilt 1972 · S/N 177RG0299N1899SBuon Volo LLC · Queen Creek, AZBuilt 1971 · S/N 177RG0045N1899ZLarlee Coleman R · Millbrook, ALBuilt 1962 · S/N 2050099N189CFRascher Lawrence · Pacific, MOS/N 18255465N189DCWorthan Gary T Trustee · Storm Lake, IABuilt 1976 · S/N 177RG0927N189ERMustang Sally Aviation LLC · Camden, SCBuilt 1974 · S/N 15076412N189JAPapillon Airways Inc · Kirkland, WABuilt 1969 · S/N 18259569N189PSchwartz Stephen R · Goldthwaite, TXBuilt 1950 · S/N 7488N189SElfdog Aviation LLC · New Franken, WIBuilt 1960 · S/N 52778N189WMatta Figueroa Eduardo · Chapman, KSBuilt 1967 · S/N 17255907N189WHBonafide Investments LLC · Dover, DEBuilt 1969 · S/N 18052059N18ADEzs Flyers LLC · Bonduel, WIBuilt 1972 · S/N 18261116N18CDDorman Richard E · Mesa, WABuilt 1964 · S/N 18051402N18CLAkro Attitudes Inc · Boynton Beach, FLS/N 52838N18DADye Paul C · Mcneal, AZBuilt 1977 · S/N 18503439N18DMRachal Randolph B · Taft, TXBuilt 1969 · S/N 18259374N18EBAll American Aviation LLC · East Helena, MTBuilt 1974 · S/N 17264188N18FAFisher Russell D · Vacaville, CAS/N 15061212N18FGShapiro David Ely · Brookhaven, GABuilt 1974 · S/N 17264233N18HBBuermann Henry · Brookfield, VTS/N 30912N18HRJ & R Aviation LLC · Hamilton, OHBuilt 1967 · S/N 17256269N18HTTobler Niccolo Sunny · Anchorage, AKS/N 15282364N18JAJahawk Leasing LLC · Sugar Grove, ILBuilt 1980 · S/N 17274513N18JLKlapmeier Alan · Iron River, WIBuilt 1974 · S/N P337-0165N18KKKhalil Kal Mohamed · Bedford, TXBuilt 1970 · S/N 15072224N18NFR D Aviation LLC · Phoenixville, PABuilt 1967 · S/N 21058903N18NJTennessee Dept Of Saftey & Homeland Security · Nashville, TNBuilt 1978 · S/N R18200178N18NSGilberto Alfonso · Washington, NCBuilt 1978 · S/N R1723066N18PBStogner Terry W · Lamesa, TXBuilt 1967 · S/N 18258216N18PWPhenix LLC · Dayton, WABuilt 1963 · S/N 21058192N18SBTroy Motz Construction Inc · Lincolnton, NCBuilt 1978 · S/N 18266338N18STYoung Shawna Hodges · Turlock, CABuilt 1973 · S/N 17261795N18TBCarlson Herb Trustee · Dana Point, CABuilt 1981 · S/N 18267978N18TKMcpherson Kathrynne Alexine Trustee · Twin Falls, IDBuilt 1961 · S/N 18253360N18TLCarey Nicolas J · Rosamond, CAS/N 18259225N18WLMiller Christopher M · Centreville, VABuilt 1981 · S/N 18053178N18YZHightower Ronny · Blanchard, OKBuilt 1975 · S/N 15076721N18ZPPierce Lestley R · Henderson, NVS/N 18263562N19004N19004 LLC · Bend, ORBuilt 1972 · S/N 15074084N19005Riddell Scott A · Winchester, KYBuilt 1972 · S/N 15074085N1900UBismarck Aero Center · Bismarck, NDBuilt 1979 · S/N 17273162N1900XAtkinson Ron D · Myrtle Creek, ORBuilt 1965 · S/N 18256000N19011Kraus Tahj · Sarasota, FLS/N 15074090N19015Jackson David W · El Cajon, CABuilt 1972 · S/N 15074093N19018Dills Donald Edward · Tunnel Hill, GABuilt 1972 · S/N 15074096N1901XBuehler Jon R Trustee · Scott City, KSBuilt 1965 · S/N 18256001
Back to AD 87-20-03 R2