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.

N708MTThibodeau Michael L · Joseph, ORS/N 32014N708RFHilton Charles Larry · Arcadia, FLBuilt 1964 · S/N 17250695N708TEAileron Aviation Inc · Cookeville, TNBuilt 1978 · S/N 17270934N709Frey Robert Henry Jr · Keller, TXBuilt 1966 · S/N 18051694N70901Ckt Aviation LLC · Anchorage, AKBuilt 1968 · S/N 18259411N70902Bienz David E · Scottsdale, AZBuilt 1968 · S/N 18259412N7090XGoodrich Dianna L · Sebastopol, CABuilt 1961 · S/N 15059190N70913Sunset Aviation LLC · New Iberia, LABuilt 1968 · S/N 18259416N70915Patterson Thomas L · Bryan, TXBuilt 1968 · S/N 18259417N70917Edwards Guy A · Sedalia, COBuilt 1968 · S/N 18259419N7091ASears Rusty M · Alma, GAS/N 29191N7091GSkylark Flight Training LLC · Wilmington, DEBuilt 1969 · S/N 17258791N7091SMoyer Alan L · Perkasie, PABuilt 1967 · S/N 15067791N7091TJensen William Robert · Zephyrhills, FLFirst renewal noticeBuilt 1959 · S/N 46691N7091XPonnequin Craig R · Marsing, IDBuilt 1961 · S/N 15059191N70920Lannoye Tyler G · Leeds, NDBuilt 1968 · S/N 18259420N7092GAmick Thomas C · Newberry, SCBuilt 1969 · S/N 17258792N7092MBohlke Cliff J · Prosser, WAS/N 55392N7092XJackson Roy M II · San Angelo, TXBuilt 1961 · S/N 15059192N70933Beta Flight LLC · South Burlington, VTS/N 18259423N70938Dawson Ranch Aviation LLC · Encinal, TXBuilt 1968 · S/N 18259425N7093AValle Daniel J · Canton, MIBuilt 1956 · S/N 29193N7093ERollins James A Trustee · Laconia, NHBuilt 1960 · S/N 56593N7093FPockrus Pat B · Mineral Wells, TXBuilt 1966 · S/N 15063693N7093GAero Performance LLC · Scooba, MSBuilt 1969 · S/N 17258793N7093MSentz Daniel J · Wasilla, AKBuilt 1958 · S/N 55393N7093XDreiling Timothy A · Lawrence, KSBuilt 1961 · S/N 15059193N70949Saucier Brock D · Dallas, TXBuilt 1968 · S/N 18259431N7094FLarsen Gary A · Honolulu, HIBuilt 1966 · S/N 15063694N7094GJohnson And Assoc · Davenport, IABuilt 1969 · S/N 17258794N7094QRegistered aircraftBuilt 1972 · S/N 17260394N7094SEdwards Thomas · West Richland, WABuilt 1967 · S/N 15067794N70956Holdsworth Randy L · Zoar, OHBuilt 1968 · S/N 18259435N70958Froh Samuel · North Pole, AKS/N 15074631N7095GHunter John Bockett · Riverton, NJBuilt 1969 · S/N 17258795N7095QWong Henry L III · Lake Forest, CABuilt 1972 · S/N 17260395N7095SSutton Aircraft Salvage LLC · Palmer, AKBuilt 1967 · S/N 15067795N7095TCurrence Brian J · Rock Hill, SCS/N 46695N70966Kelly David M · Hedgesville, WVS/N 18259437N70967Bramblett Steve · Bennington, OKBuilt 1968 · S/N 18259438N7096AWhite Lee A · Columbus, OHS/N 29196N7096FJanuary Lynn E · Mcpherson, KSFirst renewal noticeBuilt 1966 · S/N 15063696N7096XMoran Margaret Smith · Como, MSBuilt 1961 · S/N 15059196N70974Ross Donald Malcolm · Lawton, OKBuilt 1968 · S/N 18259439N70977Soran Patrick David · Reno, NVBuilt 1968 · S/N 18259440N7097GMurdy David C · Round Rock, TXBuilt 1969 · S/N 17258797N7097MLevine Jay Jacob · Los Angeles, CABuilt 1958 · S/N 55397N70981Broken Rainbow Enterprises Inc · Torrey, UTBuilt 1968 · S/N 18259443N70984Rau Brian C · Medina, NDBuilt 1968 · S/N 18259445N70986Hobby John J · Durango, COBuilt 1968 · S/N 18259446
Back to AD 87-20-03 R2