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.

N4766DHutchison Frank J · Tucson, AZBuilt 1958 · S/N 34866N4766EWillard Raymond C · Wasilla, AKBuilt 1979 · S/N 18503872N4766UMoore Murray H · Twain Harte, CABuilt 1964 · S/N 18051466N47672Cruiseair Aviation Inc · Ramona, CABuilt 1979 · S/N 15283243N4767DFulton Daniel M · Blacksburg, SCBuilt 1958 · S/N 34867N4767NDavid Bell Farms Inc. Po Box 160 · Beaverton, ORBuilt 1979 · S/N 18267350N4767UDeckload Aviation LLC · Kodiak, AKBuilt 1979 · S/N U20605091N4768BEversole Eric L · Kent, WABuilt 1955 · S/N 31666N4768DBoyd Amy L · Kila, MTBuilt 1958 · S/N 34868N4768EEagle Aviation Inc · Tucson, AZBuilt 1978 · S/N 17271633N4768FZankiz Jose Carlos · Naples, FLS/N P206-0368N4768KJohnson Durwood · Beaumont, TXS/N P21000299N4768NTreadwell Dennis A · El Cajon, CABuilt 1979 · S/N 18267351N4768PBoone Patrick J · San Antonio, TXBuilt 1978 · S/N P21000101N4769BNesbett David A Trustee · Anchorage, AKBuilt 1955 · S/N 31667N4769KSpirit 210 LLC · Missoula, MTBuilt 1979 · S/N P21000300N4769NTurner Luke · Mineral Wells, TXBuilt 1979 · S/N 18267352N4769QFlight Time LLC · El Paso, TXBuilt 1981 · S/N 15285062N4769TBowsap LLC · Manson, WABuilt 1981 · S/N R18201757N4769XAnderson Aviation LLC · Erie, PABuilt 1966 · S/N 15064819N476DTTallarita Domenic A · Palm Springs, CAS/N 17254299N476DWSkylane Capital Group LLC · Seattle, WABuilt 1980 · S/N 18267793N476KETrexel Paul C · Willits, CABuilt 1975 · S/N 18264067N476LSHoffman Anthony J Trustee · Hillsboro, ORBuilt 1976 · S/N U20603283N476MSBrooks Duane T Trustee · Mount Shasta, CAS/N 15077515N476TCFlorida Flight Training Center Inc · Venice, FLBuilt 1979 · S/N 15283281N4770DNapier Michael D · Russell, KYBuilt 1958 · S/N 34870N4770KPaulk Charles Jr · Naples, FLBuilt 1979 · S/N P21000301N4771KAshby Kenny · Mead, COBuilt 1979 · S/N P21000302N4771ULoomis Rick A · Prescott, AZS/N 18051471N4772EDrost Larry L · Charlevoix, MIBuilt 1978 · S/N 17271637N4772QHodgson John P · Atlanta, GABuilt 1967 · S/N 185-1239N4772RKimball Michael G · Placerville, COBuilt 1979 · S/N 172RG0027N4772TCaballeros Aircraft LLC · Snohomish, WABuilt 1981 · S/N R18201760N4773BRegistered aircraftBuilt 1955 · S/N 31671N4773CDickert Daniel · Cross City, FLBuilt 1979 · S/N 21063621N4773KReason Farms · Yuba City, CABuilt 1979 · S/N P21000304N4773LSilver Express Co DBA · Miami, FLBuilt 1980 · S/N 15284230N4773PCoeur De Air LLC · Mcminnville, ORBuilt 1978 · S/N P21000102N4773SSonrex LLC · Auburn, INBuilt 1979 · S/N R18201423N4773THagerman John · Coxs Creek, KYBuilt 1981 · S/N R18201761N4773UFins Fur & Feathers Flying LLC · King Salmon, AKBuilt 1979 · S/N U20605094N4773XBlack Diamond Aviation LLC · Rathdrum, IDBuilt 1967 · S/N 15064823N4774BCunningham Martin Alden · Kansas City, MOBuilt 1955 · S/N 31672N4774EZhao Dan · New York, NYBuilt 1978 · S/N 17271639N4774FIlmberger Stephen J · Bend, ORBuilt 1979 · S/N 17273079N4774KWingfield John J · Parker, TXBuilt 1979 · S/N P21000305N4774PCannan Aviation Inc · Georgetown, TXBuilt 1980 · S/N 15284813N4775BChavez Edward C · Boise, IDBuilt 1955 · S/N 31673N4775DHetrick-Price Willow · Anchorage, AKBuilt 1979 · S/N 17272357
Back to AD 87-20-03 R2