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.

N9468XBg Family Lp · Edinburg, TXS/N 21057768N94691Brentco Aerial Patrol Inc · Canton, OHBuilt 1978 · S/N 18266491N94698Corsa Exotics Inc · South El Monte, CABuilt 1978 · S/N 18266492N9469EParker Duane E · Louisville, KYBuilt 1979 · S/N 17272273N9469GGolf Tango Air Racing LLC · Ephrata, WABuilt 1971 · S/N U20601669N9469HAirplanes And Attitude LLC · Mckinney, TXBuilt 1975 · S/N 17266170N9469UBrennecke Matthew L · Tulsa, OKBuilt 1976 · S/N 15078417N9469XMurdoch Nathan B · Nehawka, NEBuilt 1961 · S/N 21057769N9469ZEly John E · Prosser, WAS/N 33940N946ACNaples Air Center Inc · Naples, FLBuilt 1985 · S/N 15286018N946ASA2g International LLC · San Juan Capo, CAS/N 33701851N946CHCritchfield Flying Service LLC · Rupert, IDBuilt 1977 · S/N 17269021N946PKPrado Mike · Sugar Land, TXBuilt 1980 · S/N R1723339N946SFSnohomish Flying Service Inc · Snohomish, WABuilt 1978 · S/N 15282353N946SMEntrekin David C · Ridgeland, MSBuilt 1982 · S/N 17275870N94709South Georgia Technical College · Americus, GABuilt 1978 · S/N 18266496N9470CLauer William A · Mercer, WIBuilt 1955 · S/N 31686N9470GDrean Gary T · Rancho Santa Fe, CABuilt 1971 · S/N U20601670N9470MJanes Dwayne O · Edmond, OKBuilt 1970 · S/N 21059370N9470XPerry Edward Glen · Brigham City, UTS/N 21057770N94713Thompson Robert M · Nevada, MOBuilt 1978 · S/N 18266497N94714Wright Aero Inc · Saint Cloud, MNBuilt 1983 · S/N 15285771N9471NBas Part Sales LLC · Greeley, COBuilt 1981 · S/N 18504362N9471XVincent Equipment LLC · Grand Junction, COBuilt 1961 · S/N 21057771N9472BGrundy James W · West Greenwich, RIS/N 55272N9472ECivil Air Patrol Inc · Maxwell Afb, ALBuilt 1984 · S/N 18268417N9472HMulder Terry A · Appleton, WIBuilt 1976 · S/N 17266171N9472MValentine Kurt J · Apple Valley, MNBuilt 1970 · S/N 21059372N9472NHuang Sophie M · Newcastle, WABuilt 1981 · S/N 18504363N9472TWilliams Chad R · Jamestown, INBuilt 1960 · S/N 57272N9473BMulholland Thomas C Trustee · Orange Cove, CABuilt 1958 · S/N 55273N9473CWild America Aviation And Holding Co LLC · Wilmington, DEBuilt 1955 · S/N 31871N9473MOpie Milton J III · White Lake, MIBuilt 1970 · S/N 21059373N9474BDiehl Greg · Angola, INBuilt 1981 · S/N 172RG0833N9474CAndrews David L · Redvale, COBuilt 1955 · S/N 31872N9474TWalker James O · Lovell, WYBuilt 1960 · S/N 57274N9474UMay Randall T · Maquon, ILBuilt 1976 · S/N 15078422N9474XKronner Prototypes Inc · Roseburg, ORFirst renewal noticeBuilt 1961 · S/N 21057774N94751Ishawooa Air LLC · Cody, WYBuilt 1978 · S/N 18266500N94753Thornton Shawn Wayne · Cheyenne, WYBuilt 1978 · S/N 18266502N94757Deters John Lloyd · Spring Grove, MNBuilt 1978 · S/N 18266504N9475CGlover Street Investors LLC · Winthrop, WABuilt 1955 · S/N 31873N9475EBerzinis Wayne T · Windham, MEBuilt 1979 · S/N 17272275N9475MRyan Air Inc · Anchorage, AKBuilt 1981 · S/N 20700695N9475RVon Imhof Rudi F · Anchorage, AKBuilt 1985 · S/N U20606872N9475UGerlach Brett C · American Fork, UTBuilt 1976 · S/N 15078423N94768Indian River Flying Club Inc · Rockledge, FLBuilt 1983 · S/N 15285782N9476BHigher Calling LLC · Johnstown, COBuilt 1958 · S/N 55276N9476CZulu Echo Assets LLC · Port Washington, NYBuilt 1982 · S/N T30300179N9476HHelicopter Partners Inc · Wellington, FLBuilt 1975 · S/N 17266172
Back to AD 87-20-03 R2