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.

N7325JBasco Richard A · Charlotte, NCBuilt 1968 · S/N 28-24678N7325SVineyard View Aviation Inc · Napa, CABuilt 1981 · S/N R18201705N7325WMitchell Lawrence Jr · Steubenville, OHFirst renewal noticeBuilt 1963 · S/N 28-1195N73262Air Spacers Inc · Santa Monica, CABuilt 1976 · S/N 17267342N73267Schutze Eric D · Ojai, CABuilt 1976 · S/N 17267344N7326DAllen Jason J · Benson, NCBuilt 1957 · S/N 22-5114N7326EMountain South Aviation LLC · Telford, TNS/N 17272085N7326FByrd Jonathan L · Rome, GAS/N 28-25235N7326PHarris David M · Costa Mesa, CABuilt 1961 · S/N 24-2504N7326WHeinze William J · Ashley, MIBuilt 1963 · S/N 28-1196N7326YHighsky Aero Inc · Arlington, TXBuilt 1964 · S/N 30-371N7327DFrankfort Flying Club Inc · Beulah, MIBuilt 1957 · S/N 22-5115N7327FAirconrad LLC · Duncansville, PAS/N 28-25236N7327JWhite Benjamin M · Hallsville, TXBuilt 1968 · S/N 28-24681N7327PTown Terry N · Lake Havasu City, AZBuilt 1961 · S/N 24-2505N7327WCerto Russell · Grand Island, NYBuilt 1963 · S/N 28-1198N7327YGeyman Edward J · Wilmington, OHBuilt 1964 · S/N 30-372N73289Correggio James · Shapleigh, MEBuilt 1976 · S/N 17267346N7328CGuiver Douglas G · Mesquite, NVBuilt 2003 · S/N 60582N7328GShort Larry D DBA · Allen, KYBuilt 1970 · S/N 17259028N7328JNightline Air LLC · Saratoga Springs, UTBuilt 1968 · S/N 28-24682N7328PCoffee Bean Connoisseur LLC · Highland, NYBuilt 1961 · S/N 24-2506N7328YBarnett David K · Brock, TXS/N 30-374N73293Shawano Flying Service Inc · Shawano, WIBuilt 1976 · S/N 17267349N73294G And G Maintenance Corp · Miami, FLBuilt 1976 · S/N 17267350N73295Whitten Chris D · Townville, SCBuilt 1976 · S/N 17267351N73296Han Farms Inc · Inverness, MTBuilt 1976 · S/N 17267352N73298Castelan Luis E · Irving, TXBuilt 1976 · S/N 17267354N7329DCampbell Michael S · Ann Arbor, MIS/N 22-5117N7329FProflite Aero LLC · Easton, PABuilt 1968 · S/N 28-25237N7329GFive Guys Aviation LLC · Pendleton, SCBuilt 1970 · S/N 17259029N7329JWalser Air LLC · Warwick, RIBuilt 1968 · S/N 28-24683N7329PSlm Holdings LLC · Kalispell, MTBuilt 1961 · S/N 24-2507N7329WHohl Warren G · Albany, GABuilt 1963 · S/N 28-1200N732ACaraway Michael S · Decatur, TXBuilt 1993 · S/N 20321N732BJSendero Helicopters LLC · Bandera, TXBuilt 2005 · S/N 10837N732BNConn Teresa M · Fairfax, VABuilt 1960 · S/N 252N732CATrey Stroup Aviation LLC · Fort Pierre, SDBuilt 1966 · S/N 30-1086N732JBHenry Sean M · Savannah, GABuilt 1998 · S/N 60031N732NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2016 · S/N 2843856N732RCCarter Ronald J · Benicia, CABuilt 2022 · S/N 70835N732UASonoran Aero LLC · Phoenix, AZBuilt 1968 · S/N 25-4658N732VFVictor Fox Aviation LLC · Newport Beach, CABuilt 1998 · S/N 18280296N732WAsher Mitchell J · Senoia, GABuilt 2009 · S/N 82000N732WDBig Picture Aviation Inc · Wheaton, ILBuilt 1980 · S/N 172RG0264N73306Boomer Aviation Inc · Fort Walton Beach, FLBuilt 1976 · S/N 17267361N73307Ftk Aviation LLC · Evans, GABuilt 1976 · S/N 17267362N7330KFinke Michael C · Sewickley, PABuilt 1950 · S/N 20-231N7330PGenpack LLC · Hillsdale, NJBuilt 1961 · S/N 24-2509N7330WAdventist World Aviation · Wilson, NCFirst renewal noticeBuilt 1963 · S/N 28-1201
Back to AD 87-10-06 R1