OpenAirDocs.org
AD 87-20-03 R2

Registered aircraft · 54,017

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.

N4692BTruitt Cory G · Centennial, WYS/N 31590N4692CTaylor James L · Lowell, ARBuilt 1953 · S/N 25636N4692GJz Air LLC · Brooklyn, NYS/N 17273318N4692LBravo Aviation LLC · Rexburg, IDS/N 17254687N4692NWilliams Douglas J · Bristol, NHBuilt 1979 · S/N 18267290N4692QZulu Aircraft Leasing LLC · Grants Pass, ORBuilt 1973 · S/N 17261745N4692XMelvin Jet · Bedford, INS/N 15064742N4693BSutton Aircraft Salvage LLC · Palmer, AKS/N 31591N4693EJayo Construction Inc · Boise, IDS/N 18268261N4693JThibodeaux Gerald J · Duson, LABuilt 1979 · S/N 17273663N4693LEmerald Air LLC · Snohomish, WABuilt 1966 · S/N 17254688N4693QSievert David M · Santa Cruz, CABuilt 1973 · S/N 17261746N46940Registration Pending · Como, MSRegistration pendingBuilt 1967 · S/N 17255577N4694CChristensen Tyler R · Red Bluff, CABuilt 1953 · S/N 25638N4694GRegistered aircraftBuilt 1979 · S/N 17273320N4694LSky Tours LLC · Port Clinton, OHBuilt 1966 · S/N 17254689N4694SRegistered aircraftBuilt 1979 · S/N R18201384N4694YKempton Chevrolet Buick Ltd · Safford, AZBuilt 1980 · S/N 21063988N46953Pea-Wayman Flight LLC · Daytona Beach, FLBuilt 1979 · S/N 15283149N4695AAgarwal Ravi · Bath, PABuilt 1983 · S/N P21000816N4695CBall Scott G · Goleta, CABuilt 1953 · S/N 25639N4695LRoss Richard R · Mckinney, TXBuilt 1966 · S/N 17254690N46964Simsbury Aviation Services LLC · Simsbury, CTBuilt 1979 · S/N 15283152N4696ASokol Dennis A · Milan, OHBuilt 1956 · S/N 32293N4696CWormwood Colton Daniel · Trout Creek, MTBuilt 1953 · S/N 25640N4696FTorres Roberto · Bavamon, PRBuilt 1979 · S/N 17273073N4696K96 Kilo LLC · Modesto, CABuilt 1975 · S/N 18263697N4696LKoontz Marina M · Seattle, WABuilt 1966 · S/N 17254691N4696THess Aero Corp Inc · Huntsville, ALBuilt 1981 · S/N R18201737N4696XAval Aviation LLC · Las Vegas, NVBuilt 1966 · S/N 15064746N4697GVeety Roy D · Dalton, PAS/N 17273323N4697KMorgan James D · Denali Park, AKBuilt 1975 · S/N 18263698N4697LTverberg Justin T · Omak, WABuilt 1966 · S/N 17254692N4697NWang Kun · Whitestone, NYS/N 18267291N4698C98 Charlie LLC · Anchorage, AKBuilt 1974 · S/N 18502598N4698DDrm Aviation LLC · Glencoe, ALBuilt 1979 · S/N 17272333N4698KRegistered aircraftBuilt 1975 · S/N 18263699N4699AReed Aviation LLC · Pearl, MSBuilt 1956 · S/N 32296N4699FStinson Ryan · Eagle, IDBuilt 1966 · S/N P206-0299N4699UValdez David M · Shady Shores, TXBuilt 1964 · S/N 18051399N4699WN4699w LLC · Rutherford, CABuilt 1981 · S/N 18268131N469DCLaw David L · Derby, KSBuilt 1979 · S/N 18266646N469EHClaybrook Douglas E · Little Rock, ARBuilt 1978 · S/N R18200335N469NETauber Samara R · La Jolla, CAFirst renewal noticeBuilt 1983 · S/N 17275952N46AMDuffy Kevin · Manchester Center, VTBuilt 1959 · S/N 52130N46BCHfc Inc · Halma, MNBuilt 1967 · S/N U206-0826N46CAEnglehart James C · Marietta, GABuilt 1969 · S/N 15070135N46CSPlane Fun Inc Tr Trustee · Snellville, GABuilt 1979 · S/N P21000413N46JFTisdell Michael S · Olivia, MNBuilt 1986 · S/N 18268563N46JWWerner John D · Pownal, VTBuilt 1969 · S/N 17257942
Back to AD 87-20-03 R2