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.

N735YVSmith Gary L Sr · Monrovia, MDBuilt 1977 · S/N 18265799N735YWKershner William C · Sewanee, TNBuilt 1977 · S/N 18265800N735YXKrm Aviation LLC · Dahlonega, GABuilt 1977 · S/N 18265801N735YYR & B Aviation LLC · Rogers, ARBuilt 1977 · S/N 18265802N735YZChism Benjamin H · Elk City, KSBuilt 1977 · S/N 18265803N735ZAHine Butler · Los Altos, CABuilt 1977 · S/N 18265804N735ZBCarroll Robert Douglas Jr · Moab, UTS/N 18265805N735ZDLansink Ronald L Trustee · Danbury, IABuilt 1977 · S/N 18265807N735ZFKatsinis James N · AthensNon-citizen corporation, flight hours not reportedS/N 18265809N735ZHWonder Lake Flying Club Inc · Wonder Lake, ILBuilt 1977 · S/N 18265811N735ZKFine Frank E · Oakdale, CAS/N 18265813N735ZNBerquist Harold J · Loveland, COBuilt 1977 · S/N 18265816N735ZPThornton Allan F · Norfolk, VABuilt 1977 · S/N 18265817N735ZQDc Marketing LLC · Collierville, TNS/N 18265818N735ZT3d Aircraft A California Corp · Simi Valley, CABuilt 1977 · S/N 18265821N735ZVWilhelm James S · Tehachapi, CABuilt 1977 · S/N 18265823N735ZWBarge And Associates Inc · Houston, TXBuilt 1977 · S/N 18265824N735ZZSkidmark Landings LLC · Bozeman, MTBuilt 1977 · S/N 18265827N73601Flex Air Holdings Inc · San Diego, CABuilt 1976 · S/N 17267570N73603Davis Kevin L · Lodi, CABuilt 1976 · S/N 17267572N73604Registration Pending · Raleigh, NCRegistration pendingBuilt 1976 · S/N 17267573N73605Jkg LLC · Murfreesboro, TNS/N 17267574N7360ABurton Justin Blake · Jenks, OKS/N 29460N7360CKacoyanis John George · Bedford, NHS/N U20603898N7360EShacklette Donald J · Smiths Grove, KYBuilt 1960 · S/N 57060N7360QNavolutions Inc · Pleasanton, CABuilt 1972 · S/N 18261000N7360SSsk Ventures LLC · Eagle, COBuilt 1976 · S/N 18265151N7360TSoper Phyllis D · San Mateo, CAS/N 46960N7360XHimwich Elizabeth W · Bethesda, MDBuilt 1962 · S/N 15059460N73610Stroup David L · Pottsboro, TXBuilt 1976 · S/N 17267576N73612American Aviation Inc · Page, AZBuilt 1980 · S/N 20700608N73618Ace States South West LLC · Stanton, TXBuilt 1976 · S/N 17267580N73619Jones & Co LLC · Londonderry, NHBuilt 1976 · S/N 17267581N7361CFocused Holdings LLC · Wellsville, UTS/N U20603899N7361NWilcox Aerial Applications Inc · Tilden, NEBuilt 1974 · S/N 18263145N7361RMcafee Scott A Trustee · Clifton, TXBuilt 1978 · S/N R18200647N7361XJohnson Michael · Huntington Beach, CABuilt 1977 · S/N R18200086N73622Dove Kenneth F · Danville, CABuilt 1978 · S/N R18200808N7362AParker Brian A · Waco, TXBuilt 1956 · S/N 29462N7362GKeno Leasing LLC · Monroe, LABuilt 1970 · S/N 17259062N7362KLacy David R · Seymour, TXBuilt 1976 · S/N R1722064N7362MFallis James B III · Wichita, KSBuilt 1958 · S/N 55662N7362SRegistration Pending · Colleyville, TXRegistration pendingBuilt 1976 · S/N 18265153N7362TSwanson Michael J · Wayzata, MNBuilt 1959 · S/N 46962N7362VReid David H · Houston, TXBuilt 1977 · S/N R1722305N7362XDraco Flight School Inc · Chino, CAS/N R18200087N7362Y32 Drakes LLC · Sulphur Bluff, TXBuilt 1977 · S/N R18200127N7363AF D P Aviation Inc · Irwin, PABuilt 1956 · S/N 29463N7363EWilkins Raymond E · Osceola, IABuilt 1978 · S/N 17272095N7363GFlying High Again LLC · Mount Juliet, TNS/N 17259063
Back to AD 87-20-03 R2