OpenAirDocs.org
AD 87-08-08 R3

Registered aircraft · 22,416

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-08-08-R3')
    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-08-08-R3')
  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.

N9670WMoore Nicholas · Cedar Park, TXBuilt 1967 · S/N 28-23134N9671CFrench Loren · Gypsum, COS/N 28-7890435N9671JElite Aircraft LLC · Bend, ORBuilt 1967 · S/N 28-3841N9671KPray Aviation Inc · Augusta, KSBuilt 1976 · S/N 28-7615226N9672JRoger Dodger Vector Victor LLC · Fort Myers, FLBuilt 1967 · S/N 28-3842N9672KEverglades Aviation Academy LLC · Weston, FLBuilt 1976 · S/N 28-7615227N9673JTamke Jon A · Battle Lake, MNS/N 28-3843N9674DSpace Coast Aircraft Co · Merritt Island, FLBuilt 1978 · S/N 28-7816583N9674KLambert Dwight · Albany, ORBuilt 1976 · S/N 28-7615228N9675CRegistered aircraftBuilt 1978 · S/N 32-7840110N9676CNot A Jet Yet LLC · Molalla, ORBuilt 1978 · S/N 32R-7885065N9676JOligario Jeremiah J · Fayetteville, NCBuilt 1967 · S/N 28-3846N9676KEjs Enterprises LLC · Incline Village, NVBuilt 1976 · S/N 28-7690272N9676TWindy Road LLC · Vancouver, WABuilt 1977 · S/N 28R-7703065N9678JNegley Neil C · Newburg, PABuilt 1967 · S/N 28-3849N9678WDependable Aviation LLC · Cartersville, GABuilt 1967 · S/N 28-23146N9679WDnr Solutions LLC · Idaho Falls, IDS/N 28-23147N967ABPiper Aircraft Inc · Vero Beach, FLS/N 28010091N967GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881474N967LVN967lv Inc Trustee · Wilmington, DEBuilt 2007 · S/N 3257481N967MSMt San Antonio College · Walnut, CABuilt 2023 · S/N 2881637N9680CGregorski Thomas E · Kenly, NCBuilt 1978 · S/N 28-7816514N9680JAltizer Joseph F · West Logan, WVBuilt 1967 · S/N 28-3850N9680WConrady Colt · Laguna Niguel, CABuilt 1967 · S/N 28-23149N9682JLenz Frank M · Boca Raton, FLBuilt 1967 · S/N 28-3853N9682WCullen Clay T · Danbury, CTBuilt 1967 · S/N 28-23151N9683JDale Allyson K I · Clarkston, MIBuilt 1967 · S/N 28-3855N9683WHincy William P · Palmdale, CABuilt 1967 · S/N 28-23152N9684JBlackstone Aircraft LLC · Hartselle, ALBuilt 1967 · S/N 28-3856N9684WGousios Eleni E · Rocklin, CAS/N 28-23154N9685CCendejas Agustin · Chino, CABuilt 1978 · S/N 28-7890436N9686JPohl Andrew L · Zephyrhills, FLBuilt 1967 · S/N 28-3859N9686KGaasedelen Trading Co · Edina, MNBuilt 1976 · S/N 28R-7635255N9686WRosenberry David D · Tucson, AZBuilt 1967 · S/N 28-23156N9687KMorris Zane F · Draper, UTBuilt 1976 · S/N 32R-7680242N9688JUrban Jess A · Marysville, KSBuilt 1967 · S/N 28-3862N9689WRegistration Pending · Denver, CORegistration pendingBuilt 1967 · S/N 28-23160N968CAAmerican Aviator LLC · Arlington, TXBuilt 1965 · S/N 28-2130N968SA75tb LLC · Springfield, TNBuilt 1982 · S/N 32R-8229021N968WCOcr Enterprises LLC DBA · Long Beach, CABuilt 2001 · S/N 2843490N9690CWindsock Inc · Red Wing, MNBuilt 1978 · S/N 28R-7837216N9690KSantana Alexandre C · Long Beach, CAS/N 28-7625190N9690WCloud Catcher Aviation LLC · Great Falls, MTBuilt 1967 · S/N 28-23161N9691JSteinberg Matthew Robert · Wayne, NJBuilt 1967 · S/N 28-3880N9692JRegistered aircraftBuilt 1967 · S/N 28-3881N9693WDelaney Kevin P · Germantown, TNBuilt 1967 · S/N 28-23165N9694JEli Team 6 Air Services LLC · Madisonville, TNBuilt 1967 · S/N 28-3883N9694WBertsch Brian · Seeley Lake, MTS/N 28-23166N9695CTrhb Enterprises LLC · Danville, PABuilt 1978 · S/N 32-7840112N9695JVaughn Gary Petty · Sanger, TXBuilt 1967 · S/N 28-3884
Back to AD 87-08-08 R3