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.

N71KTL L C LLC · Rapid City, SDBuilt 1965 · S/N 28-21258N71LZGriffin Ralph J Jr · Thibodaux, LABuilt 1977 · S/N 28-7816275N71MSTaf Aerial Services LLC · Beeville, TXBuilt 1984 · S/N 7452CN71NSSpeedy Nigel A · Cinnaminson, NJBuilt 2015 · S/N 001N71PRegistration Pending · Okeechobee, FLRegistration pendingBuilt 2000 · S/N 30006CN71PAGregory Edward P · Bernardsville, NJS/N 103N71PBProgression Aviation LLC · Alpharetta, GABuilt 2000 · S/N 118N71PKBob Hoover Academy · Salinas, CABuilt 1974 · S/N 17263272N71PMAnderson Aviation LLC · Bulverde, TXBuilt 1971 · S/N 28-7125523N71PVCeleste LLC · Playa Del Rey, CABuilt 1966 · S/N 30-1261N71REEigsti Rodney E Trustee · Friend, NEBuilt 1995 · S/N 942N71RKOtt Randal K · League City, TXS/N 0001N71RLPatriot Capital Ventures LLC · Mokena, ILBuilt 2001 · S/N 3246197N71RZSmith John J · Middlefield, CTBuilt 1996 · S/N 5349N71SATake Off LLC · Boise, IDBuilt 1971 · S/N 28-7125607N71SDRalph B Beatty LLC · Murrysville, PABuilt 1980 · S/N 625-80N71SGRocket Sauce Engineering LLC · Columbia, MOBuilt 1994 · S/N 556N71SHReese Jose A · Yuma, AZBuilt 1967 · S/N 28-4048N71SLSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1990 · S/N S1468N71TKKallio Thomas A · Carmel, INBuilt 2017 · S/N 90908N71UPSisson Edward E · Northome, MNBuilt 1990 · S/N EW2N71WFRobins David M · Tehachapi, CAS/N R18200618N71WLWild Bill'S Aviation Inc · Tustin, CABuilt 1999 · S/N 2031N71WZArlington Aviation Inc Trustee · Wilmington, DEBuilt 2000 · S/N 4636275N71ZZPlum South Aircraft LLC · Abbeville, SCBuilt 1980 · S/N 11644N7200GWe Fly High LLC · Helena, MTBuilt 1969 · S/N 17258900N7200JBell Dylan Will Nash · W Columbia, TXBuilt 1968 · S/N 28-24471N7200LWorley Matthew · Cordova, TNBuilt 1974 · S/N AA5-0500N7200PThompson Grover A · Locust, NCBuilt 1960 · S/N 24-2386N7200QFisher Eric C · San Francisco, CABuilt 1972 · S/N 17260500N7200WAgri Air LLC · Fairfax, MOBuilt 1963 · S/N 28-1011N7200YBroussard Don W Jr · Wynne, ARBuilt 1963 · S/N 30-224N7201DEnyeart Warren L · Eagle River, AKBuilt 1957 · S/N 22-5025N7201FPowell Jonathan C · Philadelphia, PABuilt 1968 · S/N 28-25108N7201HMcclure Richard A · Edna, TXBuilt 1978 · S/N 24-0597N7201JTrebor Aviation LLC · Prescott Valley, AZBuilt 1968 · S/N 28-24531N7201POrillac Natalie · Doral, FLBuilt 1978 · S/N 24-0599N7201VCompass Rose Aviation LLC · Fort Myers, FLS/N 24-0600N7201WTaylor Robert · Greensboro, NCS/N 28-1012N7201XMathews Daniel R · Vallejo, CABuilt 1978 · S/N 24-0601N7202GUrmston Benjamin R · Sherborn, MABuilt 1969 · S/N 17258902N7202JAir Indiana LLC · Noblesville, INBuilt 1968 · S/N 28-24533N7202KCollins Michael P · Cordova, AKS/N 18-93N72035Christiano Brett T · Pasco, WABuilt 1967 · S/N 17700240N7203FLaird Grant M · Puryear, TNBuilt 1968 · S/N 28-25111N7203GVenard Inc · Murdo, SDS/N 17258903N7203JRegistration Pending · Tifton, GARegistration pendingBuilt 1968 · S/N 28-24534N7203PGorge Fast Aviation LLC · Hood River, ORBuilt 1960 · S/N 24-2373N7203ZConrad Coy S · Tobaccoville, NCBuilt 1965 · S/N 18-8306N7204CHousley Communications Inc · San Angelo, TXBuilt 1975 · S/N 32R-7680042
Back to AD 87-10-06 R1