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.

N91844Brandt Kurtis L · Susanville, CABuilt 1969 · S/N 18259929N91845Broderick Donald S · S San Fran, CABuilt 1969 · S/N 18259930N91846Bas Part Sales LLC · Greeley, COBuilt 1969 · S/N 18259931N91848Mike Alpha Mike LLC · Lafayette, LABuilt 1967 · S/N 15067491N9184CMclean Samuel A · Yelm, WABuilt 1954 · S/N 31283N9184KRuggiero George J · Whitney Point, NYS/N U206-0425N91852Kennon Wesley F · Doniphan, MOS/N 18259934N9185HFlyit LLC · Washougal, WABuilt 1975 · S/N 17265999N9185MGoddard Aircraft Club Inc · Crofton, MDBuilt 1976 · S/N 18264730N9185TJones Justin · Wasilla, AKBuilt 1960 · S/N 50685N9185UChristopher P Riley · Everett, WABuilt 1976 · S/N 15078136N91860Ransom Bob · Pasco, WABuilt 1969 · S/N 18259937N91862Aire Services LLC · Barrigada, GUBuilt 1973 · S/N 17261519N91866Weldon Jeffrey A · Anacortes, WABuilt 1969 · S/N 18259939N91868V12 Enterprises LLC · Niceville, FLBuilt 1969 · S/N 18259940N9186AGaylord Hangars LLC · Gaylord, MIBuilt 1949 · S/N 18947N9186HWicked Wings Aviation LLC · Dover, DEBuilt 1981 · S/N 18267926N9186TEpi Technologies Inc · Antioch, ILBuilt 1977 · S/N 21062227N9186USmith John Dial Jr · Lexington, SCBuilt 1976 · S/N 15078137N9187AKandarian Jordi · Cundiyo, NMBuilt 1949 · S/N 18948N9187BEbrahim Ahmed E · Onalaska, TXBuilt 1958 · S/N 36787N9187CKd3262 LLC · Downers Grove, ILBuilt 1978 · S/N R18200439N9187RMih LLC · Birmingham, ALBuilt 1978 · S/N R18200666N9188CVail Jeffrey J · Rexburg, IDS/N 31287N9188GAircraft Management Services Inc · Milton, FLBuilt 1979 · S/N 17273625N9188KGallion David B · Michigan City, INBuilt 1968 · S/N 18259164N9188MSturgis Jason A DBA · Talkeetna, AKBuilt 1970 · S/N U20601588N9189AHoulton Timbre Ross · Fairbanks, AKBuilt 1949 · S/N 18950N9189BSale Reported · Litchfield, MNSale reportedBuilt 1958 · S/N 36789N9189CJastram Benjamin C · Lafayette, LABuilt 1954 · S/N 31288N9189HPendergrass Aviation Inc · Demopolis, ALBuilt 1975 · S/N 17266002N9189MFinnegan Patrick T · West Lafayette, INS/N 18264733N918CTBlinn Gilbert Trustee · Eastsound, WABuilt 1968 · S/N 18259387N918FAWestways Aviation LLC · El Cajon, CABuilt 1981 · S/N 17274981N918PMMathews Roy · Bay Shore, NYBuilt 1980 · S/N 172RG0602N918UGriffith Aviation Inc · Griffith, INBuilt 1981 · S/N 15285441N918VAVolatus Aerospace US Corp · Syracuse, NYS/N 17274912N918VPVanderpool Robert W · Red Devil, AKS/N 17266379N918VTChannel Islands Aviation Inc · Camarillo, CAS/N 17275241N91900Lewis Jeery K · Cocolalla, IDBuilt 1969 · S/N 18259942N91907Skierka Christopher · Browning, MTBuilt 1969 · S/N 18259947N9190CDickamore Chris E · Lewiston, IDBuilt 1962 · S/N 18051202N9190MBgm Aero Inc · North Zulch, TXBuilt 1976 · S/N 18264734N91912Champagne Estates Inc · Wilmington, DEBuilt 1969 · S/N 18259949N91916Hanson Larry G · Seattle, WABuilt 1969 · S/N 18259950N91917Fairchild Chad E · Logandale, NVBuilt 1969 · S/N 18259951N91919Anderson Aerial Spraying Service Inc · Canby, MNS/N 18802053TN9191ARupert Judson L · West Milton, PABuilt 1950 · S/N 19366N9191BE & D Aviation Sales LLC · Sainte Genevieve, MOBuilt 1958 · S/N 36791N9191CBash Dennis W Jr · Wasilla, AKBuilt 1954 · S/N 31290
Back to AD 87-20-03 R2