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.

N3252TFugfugosh Mahdi A · Castro Valley, CABuilt 1967 · S/N 17700552N3253SCobb Darrell V · Corsicana, TXBuilt 1964 · S/N 18255753N3253VWilliams Cecil R · Clarksville, TNBuilt 1974 · S/N 15076443N3254CCoon Vernon Ray · Atmore, ALBuilt 1967 · S/N 17256156N3254JCarreiro Myriah L · Candia, NHBuilt 1966 · S/N 15065954N3254LSelby Thomas A · Fenton, MIBuilt 1967 · S/N 17256154N3254SAllen John C · Austerlitz, NYBuilt 1964 · S/N 18255754N3254UWright Ronald J · Olympia, WABuilt 1963 · S/N 18254654N3254VRegistration Pending · Bolivar, MORegistration pendingBuilt 1974 · S/N 15076444N3255DAzul Aviation Inc · Fort Worth, TXS/N 32053N3255LPatton Steven W · Fayetteville, ARS/N 17256155N3255QCorona Edgar O · Grants Pass, ORBuilt 1979 · S/N 15283871N3256JMyers Benny R · Wasilla, AKBuilt 1966 · S/N 15065956N3256TWoodfill Kyle · Lake Jackson, TXBuilt 1967 · S/N 17700556N3256YCowden Mark T · Kerrville, TXBuilt 1962 · S/N 18254256N3257DAlaska Dall Sheep Guides LLC · Anchorage, AKBuilt 1955 · S/N 32055N3257EFlycarolina LLC · Concord, NCBuilt 1978 · S/N 17271482N3257LBeene Jerry · Bulverde, TXBuilt 1967 · S/N 17256157N3257SFelton Frank B III · Thorndale, TXBuilt 1964 · S/N 18255757N3257YGilbert Donald L Jr · Ligonier, PABuilt 1962 · S/N 18254257N3258SRockwood Spa LLC · Houston, MOBuilt 1964 · S/N 18255758N3258VBoard Of Trustees Of Western Michigan University · Battle Creek, MIBuilt 1974 · S/N 15076445N3258YByra Paula A · Pagosa Springs, COS/N 18254258N3259AHalle Michael P · Livingston, TXBuilt 1953 · S/N 25903N3259DLutes Stacy J · Mooresville, NCBuilt 1955 · S/N 32057N3259JPreflight Aviation Inc · Oregon, WIBuilt 1966 · S/N 15065959N3259RGlobal Marc Aire Inc · Dallas, TXBuilt 1973 · S/N U20602215N3259UMoore Christopher · Canton, PABuilt 1963 · S/N 18254659N3259VMaynard Richard L · Vilonia, ARBuilt 1974 · S/N 15076446N3259YGrantham William Edward · Doerun, GAS/N 18254259N325DDQuick Michael D · Middletown, CAS/N 21062748N325JSAbbott Bruce E · Seal Beach, CABuilt 1978 · S/N 15281288N325RPN325rp Corp · Willow Spring, NCBuilt 1985 · S/N P21000848N325UKilo Fox Aviation LLC · Saint Joseph, MIBuilt 1974 · S/N 15076531N326Nardi Greg · Missoula, MTS/N P33700238N3260LHerring Rhett H · College Station, TXBuilt 1967 · S/N 17256160N3260SAbner Aviation LLC · Advance, NCS/N 18255760N3260YOneal Gary · Springdale, ARBuilt 1962 · S/N 18254260N3261DCastorina John Salvatore · Anthem, AZBuilt 1955 · S/N 32059N3261SBig Island Gravity LLC · Kapaau, HIS/N 18255761N3262JBlock Oliver L · Nashville, TNS/N 15065962N3262LKd3262 LLC · Downers Grove, ILBuilt 1967 · S/N 17256162N3262SIlair LLC · Manassas, VABuilt 1964 · S/N 18255762N3263JCorrigan Air Center LLC · Hondo, TXS/N 18803623N3263LSale Reported · Arcata, CASale reportedBuilt 1967 · S/N 17256163N3263SBynum Albert L · Gadsden, ALBuilt 1964 · S/N 18255763N3264JB&K Used Auto & Equipment Llp · Fountain Run, KYBuilt 1966 · S/N 15065964N3264TVan Iderstyne Richard D · Jekyll Island, GABuilt 1967 · S/N 17700564N3265DMiller Matthew S · Washougal, WABuilt 1955 · S/N 32063N3265ETa Brand LLC · Middletown, DEBuilt 1978 · S/N 17271483
Back to AD 87-20-03 R2