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.

N9311GSooter Craig · Blue Ridge, TXBuilt 1971 · S/N 18260851N9311TCrouse John A · Sterling, AKBuilt 1960 · S/N 50811N9311XLink Lance L · Concordia, KSBuilt 1961 · S/N 18253711N93124Pavco Inc · Gig Harbor, WABuilt 1981 · S/N 15285409N93127Dunn W Eric · Lake Wylie, SCBuilt 1981 · S/N 15285411N93128High Plains Aero Consulting Inc · Pampa, TXBuilt 1974 · S/N 21060273N93129Klca Inc · Warsaw, INS/N 21060274N9312ARudisel Kenneth J · Williamsburg, MIBuilt 1949 · S/N 7367N9312GYoung Robert S IV · Abilene, TXBuilt 1971 · S/N 18260852N9312XLewan William F · Naperville, ILBuilt 1962 · S/N 18253712N93135Shannon Frances W · Clarksdale, MSBuilt 1974 · S/N 21060278N9313BAirplanes And Helicopters Of Oregon LLC · Sisters, ORBuilt 1980 · S/N 172RG0788N9313DSteneker Siardus L · Vashon, WABuilt 1983 · S/N 172RG1117N9313GSchwend Brian · Forsyth, MTBuilt 1973 · S/N 18801450N9313HFlying Ten Flying Club · Phoenix, AZBuilt 1975 · S/N 17266081N9313XSjb Farms LLC · Albany, ORS/N 18268484N93142Geoffrion Curt J · Kenai, AKS/N 15285415N9314CThielker Mark Robert · Bellaire, TXBuilt 1955 · S/N 31712N9314EHall Kenneth B · Merritt Island, FLBuilt 1979 · S/N 17272220N9314GPeerbolte John K · Highland, INBuilt 1971 · S/N 18260854N9314HAzevedo Bradley J · San Francisco, CABuilt 1981 · S/N 18267931N9314XFortney Rick · Mc Alpin, FLBuilt 1985 · S/N 18268485N93154H & H Aviation Enterprises LLC · Fairfield, OHBuilt 1981 · S/N 15285422N93157Haley Mitchell P · Big Lake, MNBuilt 1974 · S/N 21060285N9315BVan Horne Robert E · Centralia, ILBuilt 1958 · S/N 55115N9315C15charlie LLC · Soldotna, AKBuilt 1955 · S/N 31713N9315DZoviv Michael · Hollywood, FLBuilt 1982 · S/N 172RG1118N9315ESmith Mark S · Cornville, AZS/N 17272221N9315RChase Steven J · Aubrey, TXBuilt 1978 · S/N R18200686N9315UGilbreath Brent · Arlington, TXBuilt 1976 · S/N 15078265N9315XBowen Floyd Eugene Jr Trustee · Bend, ORBuilt 1985 · S/N 18268486N93166Kelly William W · Springfield, ORBuilt 1981 · S/N 15285428N9316BKnutson Wayne R · Thompson, NDS/N 55116N9316URoadrunner Bus LLC · Weston, NEBuilt 1976 · S/N 15078266N9316XZilberberg Tamir · North Hollywood, CABuilt 1985 · S/N 18268487N9317Avignati West LLC · Santa Barbara, CABuilt 1977 · S/N 18265663N9317ACunningham Kenneth R · Lawton, OKBuilt 1949 · S/N 7396N9317CSixus LLC · Fairfax, VABuilt 1955 · S/N 31715N9317EBrothers Brian · Columbus, OHBuilt 1984 · S/N 18268394N9317MWestwind Aviation Inc · Phoenix, AZBuilt 1980 · S/N 20700680N9317RLloyd William E Jr · Clinton, TNBuilt 1979 · S/N R18200687N9317WBruton Paul R · El Campo, TXBuilt 1986 · S/N U20607018N9317XMoonshine Energy LLC · Midland, TXBuilt 1961 · S/N 18253717N93183Frost John David Trustee · Anchorage, AKBuilt 1976 · S/N 18503190N93186Bates Byron B · Ethel, WABuilt 1974 · S/N 21060299N93189Hoppner Theodore · Fairbanks, AKS/N 18503194N9318ASmith Michael Todd · Edgerton, MOBuilt 1949 · S/N 7397N9318BAnderson Daniel R · Venus, TXS/N 172RG0790N9318UWhite David A · Omaha, ARS/N 15078268N9318XTopnotch Aero Inc · Austin, TXBuilt 1962 · S/N 18253718
Back to AD 87-20-03 R2