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.

N8215PAme LLC · Kalispell, MTBuilt 1963 · S/N 24-3468N8215YGlassburn Teresa L · Winthrop, WAS/N 30-1343N82162Conner Larry W · Los Lunas, NMBuilt 1982 · S/N 32R-8313015N82165Piper Aircraft Inc · Vero Beach, FLBuilt 1978 · S/N 18-7809136N82166Minuteman Aviation Inc · Missoula, MTBuilt 1978 · S/N 18-7809137N82168Earth Center Adventures Inc · Haines, AKBuilt 1979 · S/N 18-7909061N82169Patterson Colin G · Ballston Spa, NYBuilt 1979 · S/N 18-7909063N8216CYoung Mikaela R · Fairbanks, AKS/N 18-4444N8216NShelton William B · Wildwood, MOBuilt 1969 · S/N 28-25420N8216PBobbitt Aviation LLC · Edenton, NCBuilt 1960 · S/N 24-2219N8216SNulton Enterprises LLC · Johnstown, PABuilt 1980 · S/N 28-8016328N8216TRegistered aircraftBuilt 1982 · S/N 32-8206037N8216WBritair Inc · Austin, TXBuilt 1965 · S/N 28-2349N8216YMedia Stew LLC · Carson City, NVS/N 30-1344N82172Wadekamper Leo V · Helena, MTBuilt 1979 · S/N 18-7909064N82173Gagnier Hugh K · Hidden Hills, CABuilt 1982 · S/N 32R-8229055N8217NG U M P S Flying Club Inc · Warner Robins, GABuilt 1969 · S/N 28-25421N8217PDanilchuk Phillip A · Auburn, GAS/N 24-3470N8217QParis Air Inc · Vero Beach, FLBuilt 1980 · S/N 28-8016334N8217SValles Robert Jr · Spicewood, TXBuilt 1980 · S/N 28-8016335N8217YMaledy John Trustee · Salem, MOBuilt 1966 · S/N 30-1345N8217ZPerry Richard F · Lexington, MABuilt 1982 · S/N 32R-8213051N8218Kornegay Patrick C · San Benito, TXBuilt 1982 · S/N 18-8209005N82188Kubecka Daniel P · Edna, TXBuilt 1979 · S/N 18-7909068N8218AFirst Flight Inc · Watertown, CTBuilt 1982 · S/N 32R-8229064N8218CStargazer Aviation LLC · Clearwater, FLBuilt 1975 · S/N 28-7615081N8218KN8218k LLC · Chico, CABuilt 1982 · S/N 32R-8229063N8218NLee David · Palm Springs, CAS/N 28-25548N8218ZWingsleasing LLC · Wichita, KSBuilt 1980 · S/N 28-8090320N82196Flying W Ranch Jv · Cooperstown, NDBuilt 1979 · S/N 18-7909070N8219WA18 Missions LLC · Clinton, MOBuilt 1965 · S/N 28-2352N8219YDurden Julian F Jr · Twin City, GABuilt 1966 · S/N 30-1347N821BERas Aviation LLC · Elyria, OHBuilt 1978 · S/N 28-7816398N821BFDehn Timothy E · Braham, MNBuilt 2004 · S/N 90793N821CPCivil Air Patrol · Maxwell Afb, ALBuilt 2003 · S/N 18281261N821DBFlying Old Glory LLC · Kalispell, MTBuilt 2023 · S/N 40339N821DHMilsap Charles M · Owensboro, KYBuilt 2000 · S/N 18280710N821ESSchmitz Mark J · Ames, IABuilt 2019 · S/N 81767N821FASlavin Marc · Berlin, MDBuilt 2003 · S/N T18208210N821FJ8th Dimension Enterprises LLC · Aurora, ORBuilt 2021 · S/N 28020032N821GMHoosier Aviation LLC · Terre Haute, INBuilt 1957 · S/N 23-1247N821KCIreland Robert D Jr · Gulf Breeze, FLBuilt 1972 · S/N AA5-0121N821LLindrooth Steven A · Perkasie, PABuilt 1976 · S/N AA5B0333N821PASkywest Leasing Inc · St George, UTBuilt 2019 · S/N 2881248N821PCJones Clark L · Cave Creek, AZS/N 18-8031N821PTHermes Ana Paula F · West End, NCFirst renewal noticeBuilt 1973 · S/N 28-7305600N821RFAlaska Island Air Inc · Togiak, AKBuilt 1989 · S/N 3206053N821RGCircle Z Construction LLC · Mancos, COS/N T20609110N821RRAir Charter Inc DBA · Culebra, PRBuilt 1973 · S/N 338N821SDGlobal Adventures N821sd LLC · Hollywood, FLBuilt 1985 · S/N 172-76485
Back to AD 87-10-06 R1