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.

N9142JKormash John A · Edgewater, FLBuilt 1966 · S/N 28-3196N9142KSwales Michael K · Harrisville, MIBuilt 1976 · S/N 28-7615177N9142PErickson Ralph E · Foristell, MOBuilt 1966 · S/N 24-4623N9142WArtman Holdings LLC · Safford, AZBuilt 1966 · S/N 28-10763N9142ZLippity Clippity Aviation LLC · Muskegon, MIS/N 27-0151N9143DHellberg Farms LLC · Lowden, WAS/N 18-6533N9143JN9143j LLC · Fort Wayne, INBuilt 1966 · S/N 28-3197N9143SBooton Charles E · Navarre, FLBuilt 1975 · S/N MC-397N9143VCrazy Mountain Cub LLC · Helena, MTBuilt 1988 · S/N 1809002N9143WLara Anthony Michael Thomas · Manitou Springs, COBuilt 1966 · S/N 28-10764N9143XCt King Airplane LLC · Snohomish, WABuilt 1991 · S/N 27-0090N9144CMazzara David J · Collierville, TNBuilt 1991 · S/N 27-0091N9144PKober Kelly W · West Chester, PABuilt 1966 · S/N 24-4625N9144TShiflett Philip B · Marietta, OHBuilt 1985 · S/N 28-8690029N9144VHardin Ralph · New Plymouth, IDBuilt 1969 · S/N 690029N9144WMedema Roger E · Lake Forest, ILBuilt 1966 · S/N 28-10765N9145CReitz Andrew P · Pembroke Pines, FLS/N R18200419N9145JBonertz Brian J · Muscatine, IAS/N 28-3200N9145VRoe Cameron · Salt Lake City, UTBuilt 1969 · S/N 690011N9145XHk Aero LLC · Wilmington, DEBuilt 1991 · S/N 27-0095N9146DSmith Paul G · Wasilla, AKBuilt 1958 · S/N 18-6536N9146JSwarey Steven · Whiteville, TNBuilt 1966 · S/N 28-3201N9146KBartlett Jesse Charles · Henderson, NVBuilt 1976 · S/N 28-7615178N9146LMalone Aaron E · Wasilla, AKS/N 812-71N9146PBlack Diamond Aviation LLC · Levelland, TXBuilt 1967 · S/N 24-4629N9146VWood David Allen · Conyers, GABuilt 1969 · S/N 690025N9146WGam Aviation LLC · Sioux Falls, SDBuilt 1966 · S/N 28-10768N9147PDesouza Ian · Binghamton, NYBuilt 1966 · S/N 24-4631N9147THoiles Richard C · Shortsville, NYBuilt 2006 · S/N 632EN9147VN206ht LLC · Pulaski, IABuilt 1969 · S/N 690037N9147WBishop Samuel E · Soquel, CABuilt 1966 · S/N 28-10770N9147XInfinity Aviation Group LLC · Nashua, NHBuilt 1991 · S/N 27-0103N9148DSky Blue Aviation LLC · Hershey, PABuilt 1991 · S/N 27-0104N9148GCheutin Didier V · Orlando, FLBuilt 1995 · S/N 24-3362N9148JNovember Nine One Four Eight Juliet LLC · Fulton, MOBuilt 1966 · S/N 28-3203N9148PJohnson T J H · Franklin, MIBuilt 1966 · S/N 24-4632N9148SBlue Skies Aviation LLC · Holland, MIS/N MB-787N9148WD & D Kaye Inc · Santa Clara, CABuilt 1991 · S/N 27-0106N9148XFaik Salaheddine · Marion, IABuilt 1988 · S/N 2811019N9149CBryan Robert G · New Lenox, ILBuilt 1978 · S/N R18200422N9149JJones Lynn · Birmingham, ALS/N 28-3204N9149PJustack Aviation Inc · Columbus, INBuilt 1991 · S/N 27-0108N9149QCovington James A · Huntsville, ALBuilt 1996 · S/N 24-3377N9149SBurnard Russell J · Seward, AKBuilt 2001 · S/N 456RN9149WTcherneshoff Robert · Clayton, NMBuilt 1966 · S/N 28-10775N9149XJohnson Daniel C · Mount Hope, KSBuilt 1991 · S/N 27-0111N9149YBest Crane & Equipment Co LLC · Wilmington, DES/N 27-0112N914ADDepinet Andrew P · Galion, OHBuilt 2026 · S/N 001N914AMWilliamson Tom P · Nacogdoches, TXBuilt 1988 · S/N 2811020N914AZN969az LLC · Miami, FLBuilt 1985 · S/N 17276379
Back to AD 87-10-06 R1