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.

N169AMMargitan Allan R · Nine Mile Falls, WAS/N 28943N169DPAdrenaline Inc · Chambersburg, PAS/N 34979N169ECFirst Eclipse Limited · Richmond, VABuilt 1980 · S/N 172RG0515N169FLBlue Moon Holding Co LLC · Boca Raton, FLS/N 17700047N169FTHolmstrom Darrell D Trustee · Anchorage, AKBuilt 1956 · S/N 32389N169HCButterfly Wings Of Miami LLC · Miramar, FLBuilt 1973 · S/N 17262693N169JABixby & Sons LLC · Vale, ORBuilt 1964 · S/N 18256004N169JMBravo Alpha LLC · Driggs, IDBuilt 1978 · S/N P21000169N169JWPatterson Matthew D · Knoxville, TNBuilt 1968 · S/N 17700360N169KD182 Flight Corp · Bronx, NYBuilt 1979 · S/N 18267456N169NMaxfield Douglas · Chico, CABuilt 1962 · S/N 18051138N169NESouth Coast Aviation Inc · North Bend, ORS/N 17275794N169PGHarty Joshua · Strasburg, COS/N T210-0423N169PPOrtiz Peter · El Paso, TXBuilt 1985 · S/N 18268444N169TFStewart Scott A · Anchorage, AKS/N 185-0383N169WCGlobal Aircraft Trust Inc Trustee · Cheyenne, WYBuilt 1963 · S/N 15060082N16AHendrix Aviation LLC · Benton, ARBuilt 1978 · S/N R18200405N16AJA&J Air Sales Inc · San Antonio, TXS/N 28531N16AXKing Austin · Abilene, TXBuilt 1980 · S/N 21064101N16CJRoyale Air Service Inc · Fort Myers, FLS/N U20602501N16DBDivan Richard W · Wautoma, WIBuilt 1969 · S/N 17258618N16EDSimply Living LLC · Fort Myers, FLBuilt 1985 · S/N 172RG1189N16EFAnything Aviation LLC · Fort Lauderdale, FLBuilt 1977 · S/N 15280441N16EKCenterline Holdings LLC · Belgrade, MTBuilt 1975 · S/N 17265927N16FHodge Justin Eugene · White Sands, NMBuilt 1956 · S/N 28327N16GBWester Lawrence Cale · Star, IDBuilt 1973 · S/N U20602075N16GPDeckload Aviation LLC · Kodiak, AKS/N U20604467N16HTAviation Specialties Unlimited Inc · Boise, IDBuilt 1964 · S/N 2060134N16KFFournier Louis W · Fort Worth, TXBuilt 1965 · S/N 15061619N16KNIgwt Holding LLC · Richardson, TXBuilt 1965 · S/N 17253986N16MMGoff Bruce J · Williamstown, MABuilt 1981 · S/N 18268045N16MSEnergy Transfer Aviation LLC · Spring, TXBuilt 1979 · S/N 18267267N16PFTurbine Financial Group LLC · Ogden, UTS/N R1722771N16RRAustin Donald E · Ripley, MSBuilt 1979 · S/N 15283120N16SBZabel Victor R · Albuquerque, NMBuilt 1956 · S/N 29272N16SHDickinson James C · Haslet, TXBuilt 1972 · S/N 15073404N16VCStallion Leasing LLC · Louisville, KYBuilt 1976 · S/N 17267939N16VVLaughlin R C Jr · Boerne, TXBuilt 1967 · S/N R1720058N16WLLivingston Patricia R · Wasilla, AKS/N 17256545N16ZAVisser Johannes Christoffel · Reno, NVBuilt 1980 · S/N 21063807N170Schaffer Grant B · Springfield, ORBuilt 1952 · S/N 25122N17001Shields David A · Saylorsburg, PAS/N 15073572N17004Depietro Shelley Jo · Olympia, WABuilt 1972 · S/N 15073575N17009Wight John I · Anchorage, AKBuilt 1972 · S/N 15073578N1700CKrause Kade G · Jackson, MTBuilt 1953 · S/N 30400N1700DJohnson Robert Kenneth · Monte Rio, CABuilt 1951 · S/N 20143N1700MDeltahawk Engines Inc · Racine, WIBuilt 1970 · S/N 33701300N1700QAtkinson Jonathan E · Chapmansboro, TNBuilt 1971 · S/N 15073000N1701Rolston Charles W · Shoreview, MNBuilt 1964 · S/N 17252418N17014Alcorn Paul W · Bay City, MIS/N 15073581
Back to AD 87-20-03 R2