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.

N9135MHall John Douglas · Zachary, LABuilt 1976 · S/N 18264695N9135XTingley Thomas A · Groveland, CAFirst renewal noticeBuilt 1961 · S/N 18253535N9136CLanier Scott R · Fairbanks, AKBuilt 1954 · S/N 31235N9136GFredenburg Kenneth D Trustee · Gilroy, CABuilt 1971 · S/N 18260676N9136TMarble Jere D · Dayton, NVBuilt 1959 · S/N 50636N913769-Six Inc · Zortman, MTBuilt 1973 · S/N 18261990N91377Webster Marc · Glendale, CABuilt 1973 · S/N 18261991N9137BMeyer David E · Olathe, KSBuilt 1958 · S/N 36737N9137CKingdom Air Corp · Sutton, AKBuilt 1954 · S/N 31236N9137GGulf Coast Helicopters Inc · Pearland, TXBuilt 1971 · S/N 18260677N9137HPilots Flying School LLC · Englishtown, NJBuilt 1975 · S/N 17265966N9137MRiverside Pilots Inc · Riverside, CABuilt 1976 · S/N 18264697N9138GTlc Flying Inc · Colfax, WABuilt 1973 · S/N 18801390N9138HMojo Flight Group LLC · Gainesville, GABuilt 1975 · S/N 17265967N9138RDuricka Richard · Spokane, WAS/N 52063N9138TKnopp Steven L · Camano Island, WABuilt 1959 · S/N 50638N9138XVictor Valley College · Victorville, CABuilt 1961 · S/N 18253538N91390Walters Leif C · Wasilla, AKBuilt 1969 · S/N 18052060N91393Boniek Martin J · Glennallen, AKBuilt 1969 · S/N 18052063N91394Mckay John B · Wenatchee, WABuilt 1969 · S/N 18052064N91397Lucero Andrew R · Duluth, MNBuilt 1969 · S/N 18052067N91399Copper River Airmotive LLC · Copper Center, AKBuilt 1969 · S/N 18052069N9139BFikes Richard Glen III · Flint, TXS/N 36739N9139CA F S Inc · Grants Pass, ORS/N R18200416N913DHWarren Rodney L · Hobbs, NMBuilt 1968 · S/N 18259017N913NTCorrao David A · Reno, NVBuilt 1979 · S/N 18267268N913SEHill Capital Leasing LLC · Phoenix, AZBuilt 1978 · S/N P21000038N913TAChristiansen Aviation LLC · Wilmington, DEBuilt 1981 · S/N 15285317N91406Wimmer Luke R · Rogers, TXS/N 18261997N9140BBunney Jared · Spokane Valley, WAS/N 36740N9140RGilliland Allen N · King Salmon, AKBuilt 1960 · S/N 30207N9140ULegore William G · Windsor, WIBuilt 1976 · S/N 15078091N91415Hangar R LLC · Irvington, ALBuilt 1973 · S/N 18261999N9141ABarinaga Charles J · West Richland, WABuilt 1949 · S/N 18902N9141BBurnham Gary · Helper, UTBuilt 1958 · S/N 36741N9141CWeir Jimmy S · Anchorage, AKBuilt 1954 · S/N 31240N9141MSkyview Aviation LLC · Tracy, CABuilt 1976 · S/N 18264699N9141XFowler-Carpenter Shirley · San Antonio, TXBuilt 1961 · S/N 18253541N91427Curry Phillip S · Seal Beach, CABuilt 1973 · S/N 18262000N9142CIndiana Aviation Inc · Nicktown, PABuilt 1978 · S/N R18200417N9142GRegistered aircraftBuilt 1971 · S/N 18260682N9142TLjungkvist Kristian · Ashland, ORBuilt 1959 · S/N 50642N91430N91430 LLC · San Antonio, TXBuilt 1969 · S/N 18052080N91439Mod Flying LLC · Elkhorn, NEBuilt 1969 · S/N 18052085N9143ACacka David A · Klamath Falls, ORBuilt 1949 · S/N 18904N9143USherer Preston A · Watertown, WIBuilt 1976 · S/N 15078094N9144BMason Matthew L · Lincoln, ILBuilt 1958 · S/N 36744N9144GZimmerman Paul B · Haswell, COBuilt 1971 · S/N 18260684N9144MRobertson James D · Liberty, MOBuilt 1977 · S/N 21062065N9144XWinsome Ag Services LLC · Johnson, KSBuilt 1961 · S/N 18253544
Back to AD 87-20-03 R2