OpenAirDocs.org
AD 87-20-03 R2

Registered aircraft · 54,015

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.

N7445QPennino James B · Rancho Cucamonga, CABuilt 1972 · S/N 18261085N7445TKiss Sandor A Jr · Petaluma, CAS/N 47045N7445XMelott Matthew · Mesa, AZS/N 17247945N7446MHobson George A · Fairbanks, AKBuilt 1958 · S/N 55746N7446QAvco Patrol LLC · Lyndon, KSBuilt 1972 · S/N 18261086N7446TGot Wings LLC · Woodbury, NYBuilt 1959 · S/N 47046N7447NJc Flight Inc · Wilmington, DEBuilt 1966 · S/N F1720311N7447XBrewer Eric V · Alva, OKS/N 17247947N7448MCadwell David Earl · Windsor, COBuilt 1959 · S/N 55748N7448NCcx-2000-0111 LLC · Garberville, CABuilt 1977 · S/N U20603662N7448QWilkus Michael J · Mound, MNBuilt 1972 · S/N 18261088N7448XPeterson Bruce L · Williston, NDBuilt 1960 · S/N 17247948N7449EDabir-Ebrahimi Mike M · San Mateo, CABuilt 1960 · S/N 57149N7449GAvmajic LLC · Waterford, MIBuilt 1970 · S/N 17259149N744DPAviation Components Inc · Tarzana, CABuilt 1968 · S/N 18258929N744EFTango Alpha Sierra LLC · Austin, TXBuilt 1976 · S/N 18264796N744HRStefan William C · Lockwood, MOS/N R18201626N744MDeforest Shawn L · Lexington, NCBuilt 1978 · S/N 17270562N744NGEvans William H Jr · Gardendale, TXBuilt 1953 · S/N 30397N744RCastaneda Jose · Yakima, WABuilt 1974 · S/N 21060521N744WTwin Bridges Aviation LLC · Sheridan, MTS/N 33701N7450EFernald Greg · New River, AZBuilt 1960 · S/N 57150N7450GLewis Benjamin · Delano, MNBuilt 1970 · S/N 17259150N7450MJones Jeremy · Lampasas, TXS/N 55750N7451ETucker Charles M · White City, ORBuilt 1960 · S/N 57151N7451GPresto William R · Houston, PABuilt 1973 · S/N 15074660N7451XReady Aim Flyer LLC · New Castle, DES/N 17247951N7452AHill Nathaniel J · Goldendale, WABuilt 1956 · S/N 29552N7453ASwope Aviation Solutions LLC · Independence, MOBuilt 1956 · S/N 29553N7453EMuller Ronald V · Kansas City, MOBuilt 1960 · S/N 57153N7453GNorthwoods Flyer LLC · Jacksonville, FLBuilt 1970 · S/N 17259153N7453MHauser Casey L · Springfield, ORBuilt 1959 · S/N 55753N7453TEllis Wendell Kirk · Gakona, AKBuilt 1959 · S/N 47053N7453XMccoy Rileigh N · Conway, ARBuilt 1960 · S/N 17247953N7454AMoore Robert L · Anderson, CABuilt 1956 · S/N 29554N7454GDaniel Dewey R · Okeechobee, FLBuilt 1970 · S/N 17259154N7454MSteier Tim A · Salome, AZBuilt 1959 · S/N 55754N7454QHattieville Leasing LLC · Morrilton, ARBuilt 1972 · S/N 18261094N7455AApplied Products LLC · Grove, OKBuilt 1956 · S/N 29555N7455THowes Roger W · Hinckley, UTBuilt 1959 · S/N 47055N7455XAsher Jerry R · Speedwell, TNBuilt 1960 · S/N 17247955N7456TWalker Chad E · Denton, NCBuilt 1960 · S/N 47056N7456XHanson Devan D · Stephenville, TXBuilt 1960 · S/N 17247956N7457AHottenstein John C · Rifle, COS/N 29557N7457MThigpen Jacob T · Adkins, TXBuilt 1959 · S/N 55757N7457QThompson Erick O · South Jordan, UTBuilt 1972 · S/N 18261097N7457SDee Matt · Saint Petersburg, FLBuilt 1976 · S/N 18265195N7458ARegistration Pending · Waynesville, OHRegistration pendingBuilt 1956 · S/N 29558N7458FTorode John Q · Hunts Point, WABuilt 1976 · S/N 18052706N7458MMcgowin Barry · Sylacauga, ALBuilt 1958 · S/N 55758
Back to AD 87-20-03 R2