OpenAirDocs.org
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.

N7496MMcmurray Patrick T · Brush Prairie, WABuilt 1959 · S/N 55796N7496XAbove All Aviation Inc · Santa Barbara, CABuilt 1960 · S/N 17247996N7497AJohnson Kurt W · Jordan, MNBuilt 1956 · S/N 29597N7497EDunford David R · Maryville, TNBuilt 1960 · S/N 57197N7497TLeffler Greg L · Zion Crossroads, VABuilt 1959 · S/N 47097N7497XTrinciante Fernando S · Thief River Falls, MNBuilt 1960 · S/N 17247997N7498ATorrey Robert S · Anchorage, AKBuilt 1957 · S/N 29598N7498TLala Princy · Deltona, FLBuilt 1959 · S/N 47098N7499ADurousseau Joseph Harry Trustee · Sparks, NVBuilt 1957 · S/N 29599N7499CHillsboro Flying Club · Hillsboro, ORBuilt 1981 · S/N 17274992N7499TWright Donald E · Greensboro, NCBuilt 1959 · S/N 47099N7499XVintage Aircraft Ltd · Hortonville, WIBuilt 1960 · S/N 17247999N749KPKalinin Partners LLC · Juneau, AKBuilt 1980 · S/N U20605554N749RVTime Machine LLC · Kailua Kona, HIS/N U20603480N749SPNew York State Police · Latham, NYBuilt 1986 · S/N U20606957N74ALDavis Tessie · Buckeye, AZBuilt 1974 · S/N 15075510N74CPersonal Aviation Inc · Poway, CABuilt 1978 · S/N 17270368N74CFWincar Air LLC · Doniphan, NEBuilt 1974 · S/N 18502557N74CGTrainor Thomas P · Fairbanks, AKBuilt 1974 · S/N 18052403N74CLWarner Thomas E · Beloit, OHBuilt 1959 · S/N 51632N74DFRegistered aircraftS/N 18502474N74DMT C Rian Association LLC · Grove, OKBuilt 1973 · S/N 17262699N74DPRegistered aircraftBuilt 1974 · S/N 17702150N74ERSimplifly LLC · Mesa, AZBuilt 1977 · S/N 17269502N74ESValiair Ltd Co Trustee · Casper, WYBuilt 1979 · S/N P21000279N74GTKnick Robert J · Eugene, ORBuilt 1969 · S/N 15070302N74JHAuermann John E · New Smyrna Beach, FLBuilt 1967 · S/N 337-0740N74JPGulf Coast Helicopters Inc · Pearland, TXBuilt 1974 · S/N 17263356N74JSHoots Husky LLC · Helena, MTBuilt 1980 · S/N 18504139N74KWWilling Kenneth Allen · Grasston, MNS/N 15063752N74LCommunity And Faith Initiatives · Phoenix, AZBuilt 1977 · S/N 33701814N74LCLee County Sheriffs Office · Ft Myers, FLBuilt 1972 · S/N 21059755N74LJZaczkowski Paul S · Tok, AKBuilt 1966 · S/N 18051755N74MBRoland Cary T · Moscow, KSBuilt 1971 · S/N 18260789N74MGRegistered aircraftBuilt 1965 · S/N 18051632N74MKBunn Joseph D · Hugo, OKBuilt 1974 · S/N 18262919N74MMFief Ron C · Creede, COBuilt 1974 · S/N 21060375N74PESkycrafters Incorporated · Johnson City, TNBuilt 1973 · S/N 17262191N74PPBunnell Randy D · Blakesburg, IABuilt 1968 · S/N 17700928N74PSOrion Works Inc · Denali Park, AKBuilt 1973 · S/N U20601894N74RMGrimes Taylor · Odessa, TXBuilt 1976 · S/N 21061694N74SESoutheast Wood Inc · Montgomery, ALBuilt 1979 · S/N R1723104N74SMYellow Airplane LLC · Columbus, NEBuilt 1979 · S/N 18267216N74SSPelletier Kevin C · Williamsport, MDBuilt 1974 · S/N 177RG0530N74TPN92341 LLC · Bonner, MTBuilt 1979 · S/N 18267156N74TWWichmann Gregory Scott · Las Vegas, NVBuilt 1980 · S/N 18504043N74UAnderson Ray L · Auburn, CAFirst renewal noticeBuilt 1977 · S/N 15079197N74VTStorsteen Erik M · Gardena, CABuilt 1974 · S/N 18262982N750Culver Marc D · Anchorage, AKBuilt 1958 · S/N 50347N7500MRoat Todd J · Rio, WIS/N 55800
Back to AD 87-20-03 R2