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.

N8698NUnder Bridge LLC · Wilmington, DEBuilt 1971 · S/N 32-7240045N8699Blake Rodney · Trophy Club, TXBuilt 1973 · S/N 358-73N8699DBohannon James A III · Waller, TXBuilt 1958 · S/N 18-6277N8699NHolding Short LLC · Travelers Rest, SCBuilt 1971 · S/N 32-7240047N8699PKroll Corey · Gilbert, SCBuilt 1964 · S/N 24-4097N869BCInter American University Of Puerto Rico · Bayamon, PRBuilt 2026 · S/N 28020269N869CPExecutive Flight Institute LLC · Murrieta, CABuilt 1999 · S/N 17280641N869GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881468N869KF3 Aero LLC · New Lenox, ILFirst renewal noticeS/N 292-HN869RVThwaits John Drew · Ashland, MABuilt 2005 · S/N 90869N869TASheeptick LLC · Conrad, MTBuilt 2022 · S/N 2881545N869TTDimond Joan M · Birch Run, MIBuilt 1969 · S/N 157N869VLVieques Air Link Inc · Vieques, PRBuilt 1983 · S/N 1048N869WCSchofield Wayne D · Polson, MTBuilt 1957 · S/N 22-5521N86AJMullins Mark C · Riverside, CABuilt 1972 · S/N 32-7200036N86AKBuss Bryce D · Homer, AKBuilt 2000 · S/N BC1-1N86AT86at LLC · Elizabethtown, PABuilt 1976 · S/N 61P-0364-114N86AVPlane Fun Inc Tr Trustee · Snellville, GAS/N 523N86AYN86ay LLC · Burke, VABuilt 1977 · S/N 32R-7780478N86BJWings Over Texas Holdings LLC · Denton, TXBuilt 1997 · S/N 17280238N86BKBlue Raven Air LLC · Eagle River, AKBuilt 1999 · S/N 2041N86BPMiller Jacob Gordon · Fountaintown, INBuilt 1962 · S/N 24-3329N86BTTaylor Paul E · Hilo, HIS/N 1296N86CAInternational Air Services Inc Trustee · Carson City, NVBuilt 1971 · S/N 32-40957N86CKFord Darin E · Colorado Springs, COBuilt 1987 · S/N M-II-1002N86CMNewman Aviation Services Inc · Tiffin, OHBuilt 1969 · S/N 31-468N86DPerry Richard Kevin · Titusville, FLBuilt 1987 · S/N 577N86DBMchugh John J · Camano Island, WABuilt 1970 · S/N 17259123N86DJJakusz Donald G · Coppell, TXBuilt 1989 · S/N 64N86DMShine Dylan Patrick · Jupiter, FLS/N 8-0015N86DWWhidbey Flight Services LLC · Coupeville, WABuilt 1973 · S/N AA5-0357N86ECParisi Mario · Grosse Ile, MIS/N 28-7525026N86EFCic Aviation LLC · Wenatchee, WABuilt 1978 · S/N R18200481N86FGGrantham George F · Bush, LABuilt 2009 · S/N 40364N86FPGateway Flight Center LLC · Port Lavaca, TXBuilt 1978 · S/N 17271406N86GMMcguire Michael D · Lake Stevens, WABuilt 1987 · S/N G.M.3N86GPNichols Clint T · Tehachapi, CABuilt 1973 · S/N 1-0011N86HCN86hc LLC · Rochelle, ILBuilt 1997 · S/N 3257025N86HFSkillman Michael W · Brookshire, TXS/N XX8N86HLGalpin Henry M · Kalispell, MTBuilt 1988 · S/N 1N86HWWalker James J · Santa Clara, CABuilt 2009 · S/N WHB-RV4-301N86HYBock Roger · Williamsville, ILBuilt 2002 · S/N 2200N86JDBurton Nicholas D · Clinton, TNBuilt 2004 · S/N 10539N86JJFelda Farms LLC · Felda, FLBuilt 1996 · S/N 2377N86KYMartin Jay L · Tijeras, NMBuilt 1987 · S/N 0105N86LGEast High Flying Inc · Othello, WABuilt 1976 · S/N 61P-0283-065N86LKKoinzan Flying Serv Inc · Elgin, NEBuilt 1988 · S/N 294N86MDLol Splash LLC · Helena, MTBuilt 1988 · S/N 4050CN86MKStinson Jeffrey S · The Villages, FLBuilt 2005 · S/N 70-426N86MLLam Aviation Inc · Los Altos Hills, CABuilt 1986 · S/N 101
Back to AD 87-10-06 R1