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.

N9908HKoch Vincent Karl · Canyon Lake, CABuilt 1981 · S/N 18268104N9908VDls Computer Services Inc · Lake In The Hills, ILBuilt 1977 · S/N R1722353N9909NMorgan Vernon E · Dillon, COS/N 21063250N9909QCk Aviation LLC · Charlestown, INBuilt 1975 · S/N 17265853N9909XMameli Tyler L · Williamson, GABuilt 1961 · S/N 185-0109N9909ZLake And Peninsula Airlines Inc · Port Alsworth, AKBuilt 1983 · S/N U20606740N990BFlight Academy LLC · Van Nuys, CABuilt 1978 · S/N 17272059N990CAJundi Adam · North Royalton, OHBuilt 1976 · S/N 15079158N990CKSaucier Christopher A · Marion, MTBuilt 1976 · S/N 18265006N990USimpson Reed · Marco Island, FLBuilt 1965 · S/N 21058690N990VPValenzuela Pedro · Douglas, AZBuilt 1979 · S/N U206-04673N990WPThomas Field Flying Club LLC · Holly Springs, MSBuilt 1973 · S/N 18262238N99100Sterling Flight Training LLC · Jacksonville, FLBuilt 1985 · S/N 172-76401N99104Dury Aviation Services Inc · De Soto, ILBuilt 1985 · S/N 17276403N9910ABach Jeremy · Camp Verde, AZS/N 19270N9910ESmoke Eagles Inc · Newport Beach, CABuilt 1975 · S/N 18263970N9910MSatran Paul C · Detroit Lakes, MNBuilt 1977 · S/N 21062089N9910NRunner Douglas A · Ashby, NEBuilt 1982 · S/N 18504370N9910QTevebaugh Dennis J · Elkhart, KSBuilt 1975 · S/N 17265854N9910XHower Loyal L · Moscow, IDBuilt 1961 · S/N 185-0110N9911ADaniels Bayce D · Anthony, NMS/N 19271N9911BGustafson Kim · Lake Stevens, WABuilt 1957 · S/N 34311N9911HDouglas Forest Protective Association · Roseburg, ORBuilt 1981 · S/N 18268107N9911QAeronautical Technical Service Inc · Collierville, TNS/N 17265855N9911VInternational Air Services Inc Trustee · Carson City, NVS/N 18051763N9911XDesolation Aviation LLC · Fort Worth, TXBuilt 1961 · S/N 185-0111N9912AEvans Alfred M Jr · Kingston, OKBuilt 1950 · S/N 19272N9912LCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1986 · S/N 17276648N9912NRegistered aircraftBuilt 1975 · S/N 18052567N9912QKd Aviation LLC · Sheridan, WYBuilt 1975 · S/N 17265856N9913EHobot LLC · Springdale, ARBuilt 1975 · S/N 18263973N9913GProtac Aviation LLC · San Diego, CAFirst renewal noticeBuilt 1973 · S/N A1500464N9913MVillapudua Ruben Ruiz · Phoenix, AZBuilt 1977 · S/N 21062090N9913VIsern Douglas J · Golden, COBuilt 1966 · S/N 18051765N99141Airgo Inc · Centralia, ILBuilt 1985 · S/N 17276409N9914ESimica Charles A · Marietta, GABuilt 1979 · S/N 17272288N9914GKunas Matthew · Akron, OHBuilt 1973 · S/N A1500465N9914LFlex Air Holdings Inc · Manhattan, KSBuilt 1986 · S/N 17276649N9914MLabra Victor David · Mesa, AZS/N 18264810N9914QVictor Aviators Inc · Kernersville, NCBuilt 1975 · S/N 17265858N9914VJennair LLC · Wilmington, DEBuilt 1966 · S/N 18051766N99157Hess Garrett J · Fullerton, CABuilt 1985 · S/N 17276412N9915AAbel Elliot A · Terre Haute, INBuilt 1950 · S/N 19275N9915BTaro Investment LLC · Doral, FLBuilt 1982 · S/N 172RG1078N9915HTj Aero LLC · Valencia, CABuilt 1981 · S/N 18268109N9915MBoone John G · Goleta, CABuilt 1976 · S/N 18264811N9915NKackley Floyd L · Grand Rapids, MNBuilt 1975 · S/N 18052570N9916Addison William S · Colorado Springs, COBuilt 1955 · S/N 31413N9916ESchult Jessica Elaine · Boise, IDBuilt 1975 · S/N 18263976N9916HSky Blue Adventures LLC · Boulder, COBuilt 1981 · S/N 18268110
Back to AD 87-20-03 R2