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.

N9932ZSilver Creek Aviation Services · Fort Worth, TXBuilt 1983 · S/N U20606753N99338Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 17276433N9933ATravelair Inc · Ocala, FLBuilt 1950 · S/N 19411N9933BHenkemeyer Joseph S · Cave Creek, AZBuilt 1957 · S/N 34333N9933MAlaska Aircraft Leasing LLC · Silverdale, WABuilt 1982 · S/N 20700750N9933TOrr Kory A · Hay Springs, NEBuilt 1960 · S/N 18253033N9933ZFreelance Air · Kennesaw, GABuilt 1983 · S/N U20606754N99341Jlinn Aviation Inc · Quinlan, TXBuilt 1985 · S/N 17276434N99344Global Tours & Travel Services LLC · Davie, FLS/N 17276435N99347Skywarrior Flight Training Inc · Pensacola, FLBuilt 1985 · S/N 17276436N9934BMasterson Kevin M · Eagle River, AKBuilt 1957 · S/N 34334N9934EStenger D James Trustee · Sonora, CABuilt 1975 · S/N 18263994N9934GDiorio Christopher J · Melba, IDBuilt 1973 · S/N A1500471N9934NAtkins Ricky K · Placerville, CABuilt 1975 · S/N 18052589N9934QDoupe Services LLC · Fort Myers, FLBuilt 1975 · S/N 17265878N9934VRuby Aviation LLC · Oak Creek, COBuilt 1966 · S/N 18051786N9934XLogue James · Fort Worth, TXBuilt 1975 · S/N 21060916N9934ZParagon Air Group · Fort Worth, TXBuilt 1983 · S/N U20606755N9935AMichael Monte E · Axtell, TXBuilt 1950 · S/N 19413N9935BCarpenter Willard D · Borrego Springs, CABuilt 1957 · S/N 34335N9935ERegistration Pending · Belington, WVRegistration pendingBuilt 1985 · S/N 18268474N9935HKahn Lawrence · Upper Lake, CABuilt 1981 · S/N 18268125N9935MFreshwater Adventures Inc · Dillingham, AKBuilt 1982 · S/N 20700751N9935NMeggers Roger D · Baker, MTBuilt 1975 · S/N 18052590N9935RUsda Aphis Ppq · Edinburg, TXBuilt 1986 · S/N U20606988N9935VD & S Aviation LLC · Wilmington, DEBuilt 1974 · S/N 17264562N9936QHunt Richard M · Columbus, OHBuilt 1975 · S/N 17265880N9936VLeading Edge Flight Academy LLC · Bend, ORBuilt 1974 · S/N 17264563N99377Barta Terry · Faribault, MNBuilt 1985 · S/N 17276439N9937AInternational Air Services Inc Trustee · Carson City, NVBuilt 1950 · S/N 19297N9937E7 And 7 LLC · Leon, IABuilt 1979 · S/N 17272293N9937QFosmo Richard E · Eatonville, WABuilt 1975 · S/N 17265881N9938NJohnson Scott A · Missoula, MTBuilt 1975 · S/N 18052593N9938TShope Brandon M · North Pole, AKFirst renewal noticeBuilt 1960 · S/N 18253038N9938ZSilver Creek Aviation Services · Fort Worth, TXBuilt 1983 · S/N U20606757N99396Flightline Air Service LLC · Pineville, LABuilt 1985 · S/N 17276441N9939HVawter Russell R Trustee · Nampa, IDBuilt 1981 · S/N 18268128N9939NSylvester Sean W · North Pole, AKS/N 18052594N9939VJackson Walter E · Wasilla, AKBuilt 1966 · S/N 18051791N9939XGrant Matthew D · Alvord, TXS/N 1850139N9939ZRiver Front Akn LLC · Anchorage, AKBuilt 1983 · S/N U20606758N993DWDeadstick Holdings LLC · Laguna Niguel, CABuilt 1963 · S/N 18255149N993GAUtopia Flyers LLC · Utopia, TXBuilt 1972 · S/N 18261152N993KTFirst Air Service LLC · Show Low, AZBuilt 1978 · S/N 18266450N993PPCc Bar Ranch LLC · Texarkana, TXBuilt 1975 · S/N U20602634N993SRThree S Ranch Inc · Blanca, COBuilt 1980 · S/N P21000477N9940ESaint Louis University · Saint Louis, MOBuilt 1975 · S/N 18264000N9940MSofinme LLC · Missoula, MTS/N U20604590N9940VSoco Aero Leasing LLC · Santa Rosa, CABuilt 1974 · S/N 17264566N9941BBrinkley Christian D · Minneapolis, MNBuilt 1957 · S/N 34341
Back to AD 87-20-03 R2