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.

N98BVUSA Air LLC · Ruskin, FLBuilt 1974 · S/N 15075695N98DDReady Aim Flyer LLC · New Castle, DES/N 51709N98DXInternational Air Services Inc Trustee · Carson City, NVS/N 17272526N98EMGreen Tool & Die Co LLC · Honesdale, PABuilt 1968 · S/N 17256804N98GCGarcia Alexandra · Pompano Beach, FLBuilt 1968 · S/N 17257750N98GPHammack Philip Scott · Canton, MSS/N R18201593N98JBFlight1 Hsw LLC · Norwood, COBuilt 1965 · S/N 652N98PBFerry Services Corp · Cresson, TXBuilt 1977 · S/N 18503489N98SSSoutheastern Oklahoma State University · Durant, OKBuilt 1977 · S/N 15079353N98SWGankas Christopher · Ventura, CABuilt 1976 · S/N 177RG1090N98TCPositiv8 LLC · Wilmington, DEBuilt 1974 · S/N 18263411N98ZTSharp Paul A II · Apollo Beach, FLBuilt 1971 · S/N 17259956N9900BS & L Aviation LLC · Buhl, IDS/N 34300N9900GSkyline Agrinautics Inc · Osage, IABuilt 1970 · S/N 18800700N9900NRegistered aircraftBuilt 1975 · S/N 18052555N9900QBedsole Clinton Allen · Frisco, TXBuilt 1975 · S/N 17265844N9900THamlin Timothy B · Garden City, KSBuilt 1960 · S/N 53000N9901BNichols Patrick C · Fairview, NCBuilt 1957 · S/N 34301N9901EBas Part Sales LLC · Greeley, COBuilt 1975 · S/N 18263961N9901NTeets David J · Fairbanks, AKBuilt 1975 · S/N 18052556N9901VMinske Troy · Princeton, MNBuilt 1966 · S/N 18051753N9902EOtto Real Estate Investment Inc · Bakersfield, CABuilt 1975 · S/N 18263962N9902QBowers John E · Owasso, OKBuilt 1975 · S/N 17265846N9902VEuroaviation Inc Trustee · KematenBuilt 1966 · S/N 18051754N9903GCourtney Brooks Streetwise Inc · Avondale, AZFirst renewal noticeS/N A1500456N9903MRegistered aircraftBuilt 1976 · S/N 18264799N9903TRiddle John G · Townsend, MTBuilt 1960 · S/N 53003N9903VDwh Flight LLC · Spring, TXBuilt 1974 · S/N 17264552N99040Bradley Aircraft Company LLC · Columbus, INBuilt 1985 · S/N 17276395N99045Allen Michael R · Graham, NCBuilt 1985 · S/N 17276396N99048Bradley Aircraft Co · Columbus, INBuilt 1976 · S/N 17268367N9904HWingin It LLC · Marshall, MNBuilt 1981 · S/N 18268101N9904QStanford Jay J · Saint Marys, GABuilt 1975 · S/N 17265848N9904VStratus Aviation LLC DBA · Vacaville, CABuilt 1974 · S/N 17264553N9905AHottois Scott A · Whittemore, MIS/N 19265N9905ELf Flying LLC · Wellington, MOBuilt 1985 · S/N 18268469N9905HWhitaker Billy Dean Jr · Houston, TXBuilt 1981 · S/N 18268102N9905QCentral Air Service · Lewistown, MTBuilt 1975 · S/N 17265849N9906GNielson Donald L · Independence, ORBuilt 1973 · S/N A1500457N9906LRiseaero LLC · Florence, SCBuilt 1986 · S/N 17276647N9906MWhorton Darren · Nashville, TNBuilt 1976 · S/N 18264802N9906VStruempler Jed E · Anchorage, AKBuilt 1966 · S/N 18051758N9907AHuff Steven D · Lake Havasu City, AZBuilt 1950 · S/N 19267N9907BMalone Parachute Club Inc · Williston, VTBuilt 1957 · S/N 34307N9907CBlue Marlin LLC · Kalispell, MTBuilt 1978 · S/N R18200488N9907HMather Aviation LLC · Mather, CABuilt 1981 · S/N 18268103N9907QPlasco Designs Of Arkansas Inc · Texarkana, ARBuilt 1975 · S/N 17265851N9908AKelly Larry E · Currie, NCBuilt 1950 · S/N 19268N9908EAndrews Allen P · Longview, TXBuilt 1975 · S/N 18263968N9908GHarrison Jon Wittmeyer · Port Saint Lucie, FLBuilt 1973 · S/N A1500459
Back to AD 87-20-03 R2