AD 87-10-06 R1

Registered aircraft · 72,010

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-10-06-R1')
    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-10-06-R1')
  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.

N7881WEast Crest Management LLC · Eastvale, CABuilt 1964 · S/N 28-1905N7882CKeck Joseph S · Las Vegas, NVS/N 28-7625087N7882PWaters Robert D · Albuquerque, NMBuilt 1962 · S/N 24-3110N7882VSlepian Isaac J · El Dorado Hills, CABuilt 1965 · S/N 2844N78830Frederick Wayne Schultz · Bradley, ILBuilt 1968 · S/N 17257782N78834Barron Ted L · Hoover, ALBuilt 1968 · S/N 17257783N7883DMeierotto Marty · Two Rivers, AKBuilt 1957 · S/N 18-6043N7883PFinke Michael C · Pleasant Prairie, WIBuilt 1962 · S/N 24-3111N7883VFranks Gary E · Ponder, TXBuilt 1964 · S/N 2845N7883WStack Brian James · Paso Robles, CABuilt 1964 · S/N 28-1907N7883YHoward Jerry W · Snellville, GABuilt 1965 · S/N 30-968N78842Helice Sarcelle LLC · San Antonio, TXBuilt 1968 · S/N 17257787N78846Aero Investors Lc · Jackson, MIS/N 17257788N78850Karpik Richard Paul · Grand Rapids, MNBuilt 1968 · S/N 17257790N78856Bedwell Christopher A · Paso Robles, CABuilt 1968 · S/N 17257791N78857Hunt Thornton Trevon · Aurora, COBuilt 1968 · S/N 17257792N7885DLindstrom Daniel G · Somerset, WIBuilt 1957 · S/N 18-6045N7885WCp Authority LLC · Poulsbo, WABuilt 1964 · S/N 28-1909N7885YKregel Steven · Garnavillo, IABuilt 1965 · S/N 30-970N78861Wood Jeffrey A · Willis, TXS/N 253N78865Gingras Carl A · Avondale, COS/N 2880N78869Zullo Thomas L · Lindenhurst, NYBuilt 1964 · S/N 2884N7886GArctic Barnabas Ministries Inc · Kenai, AKBuilt 1970 · S/N 17259586N7886VLowenhaupt Michael J · Metairie, LABuilt 1964 · S/N 2848N7886WChelena Eric D · San Antonio, TXBuilt 1964 · S/N 28-1910N78871Rosenfeld Kristina M · Eureka, CABuilt 1964 · S/N 2886N78873Mesner Steven M · Tomah, WIBuilt 1964 · S/N 2888N78875Janssen Christopher R · Ankeny, IABuilt 1964 · S/N 2890N78877Obrien Garrett G · Sheep Ranch, CABuilt 1965 · S/N 254N7887GLandrum Erik · Austin, TXBuilt 1970 · S/N 17259587N7887P7887papa LLC · Glenwood Springs, COBuilt 1962 · S/N 24-3116N7887WDepp Gregory B · Ft Worth, TXBuilt 1964 · S/N 28-1911N7887YAskins Jack C · Wichita Falls, TXBuilt 1966 · S/N 30-973N78880Coma Aviation LLC · Buckhannon, WVBuilt 1964 · S/N 2895N78882Triplat Bonnie E · Rosamond, CABuilt 1964 · S/N 2897N78884Cooke Daniel S · Kanarraville, UTBuilt 1964 · S/N 2899N78888Woodard Ben C · Truckee, CABuilt 1964 · S/N 2903N7888MMonpas Mark E · Anderson, CABuilt 2011 · S/N 72599N7888WLashinski Michael J · Monument, COBuilt 1964 · S/N 28-1912N7888YBurkel Robert G · Hemet, CABuilt 1966 · S/N 30-975N78890Edmondson Donald M · Harvest, ALBuilt 1964 · S/N 2905N78891Registered aircraftBuilt 1964 · S/N 2906N78892Rathbun Robert E · Maywood, MOS/N 2907N78893King Eugene A · Rch Palos Vrd, CABuilt 1964 · S/N 2908N78894Gonzalez Francisco C · Biloxi, MSBuilt 1965 · S/N 2909N78897Knox Phillip A · Snellville, GABuilt 1964 · S/N 2912N78898Clawson Michael · Allentown, NJS/N 2913N7889GFricker Mark W · Avon, INFirst renewal noticeBuilt 1970 · S/N 17259589N7889PWalker Zachary R · Burlington, NDBuilt 1963 · S/N 2403N7889VPoorman Christopher · Burleson, TXBuilt 1964 · S/N 2851
Back to AD 87-10-06 R1