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.

N9442Winger Aviation LLC · Palatine, ILBuilt 1973 · S/N 177RG0324N94429Wisconsin Aviation Inc · Watertown, WIBuilt 1982 · S/N 15285669N9442RPauly Jeff D · Watkins, MNBuilt 1978 · S/N R18200706N9443CRvest Management LLC · Boulder City, NVBuilt 1955 · S/N 31841N9443HAllport Bruce E · North Hollywood, CABuilt 1975 · S/N 17266156N9443LTdz Aircraft Holdings LLC · Dover, DES/N 17276558N94447Flightime LLC · Stuyvesant, NYBuilt 1982 · S/N 15285673N9444BWallitner Aviation Inc · Renton, WAS/N 55244N9444HPrestige Worldwide Aerospace LLC · Panama City, FLBuilt 1975 · S/N 17266157N9444MTriple Four Mike LLC · Sand Springs, OKBuilt 1977 · S/N 21062076N9444UB2w Corporation · Winona, MNBuilt 1976 · S/N 15078392N9445CSchaller Lee W · New Athens, ILBuilt 1955 · S/N 31843N9445DTriple Fes LLC · San Antonio, TXBuilt 1984 · S/N 172RG1165N9445HBrown Max K · Cushing, OKBuilt 1975 · S/N 17266158N9445MSky Masters Aviation Inc · Laguna Hills, CAS/N 18264761N9445THale Tom · Browns Valley, CABuilt 1960 · S/N 57245N9446CAlaskan Luxury Cruises LLC · Willow, AKS/N 31844N9446GStringfellow Regan M · Boerne, TXS/N U20601646N9446NSkywagon LLC · Goochland, VABuilt 1981 · S/N 18504358N9446UTepper Jesse J · New York, NYBuilt 1976 · S/N 15078394N9447HLang Julia A · Greensburg, PABuilt 1975 · S/N 17266159N9447LAirplane And Drone Flight Instruction LLC · Orlando, FLBuilt 1986 · S/N 17276559N9447MWings Aircraft LLC · New Richmond, WIS/N 18264763N9447XKaminski Thomas E · Green Bay, WIBuilt 1985 · S/N 18268529N9448CAero Marine Inc · Westland, MIBuilt 1955 · S/N 31846N9448MSoto Eduard D Trustee · Somers, MTBuilt 1976 · S/N 18264764N9448UValley View Farming Inc · Halsey, ORFirst renewal noticeS/N 15078396N9449BLeaders Bob O · Clear Lake, MNBuilt 1958 · S/N 55249N9449XBelk Pritchard Properties LLC · Broken Arrow, OKBuilt 1961 · S/N 21057749N944CBCalifornia Baptist University · Riverside, CABuilt 1973 · S/N 17262402N944DHSouth Delta Aviation Inc · West Helena, ARBuilt 1981 · S/N P21000712N944JHHiggins James R · Camargo, ILBuilt 1973 · S/N 18262033N944PMGasper Air Spray Inc · Crookston, MNFirst renewal noticeBuilt 1983 · S/N 18268344N944RRancifer Rodney M · Lithonia, GABuilt 1970 · S/N 17258933N944WBSchultz Jason G · Crowley, LABuilt 1979 · S/N 18266811N94500Training Planes LLC · Tampa, FLBuilt 1983 · S/N 15285692N94505Riverside Flight Center Inc · Tulsa, OKBuilt 1983 · S/N 15285696N9450DSharabi Avinoam · Las Vegas, NVS/N 172RG1166N9450EAivcon Inc · Charlevoix, MIBuilt 1984 · S/N 18268412N9450XDavila R · Runge, TXS/N 21057750N94513Hampden Aviation Services Inc · Northampton, MABuilt 1983 · S/N 15285702N9451MSnow Jeffrey J · Mechanicsburg, PABuilt 1976 · S/N 18264766N9451UPilot Pros Inc · Miami, FLBuilt 1976 · S/N 15078399N9451XRegistered aircraftS/N 21057751N94527Kamer Joseph P · Topeka, KSBuilt 1978 · S/N 18266428N94528Daedalus Flight School Inc · P. FokaiaS/N 15285705N94529Clary Daryl · Moorestown, NJBuilt 1978 · S/N 18266430N9452EDew Jason L · Krum, TXBuilt 1979 · S/N 17272268N9452GStokes Letta J · Chugiak, AKBuilt 1971 · S/N U20601652N9452HFreeland Thomas W · Early, TXBuilt 1975 · S/N 17266162
Back to AD 87-20-03 R2