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.

N952ANAztec 66 LLC · Indianapolis, INBuilt 1965 · S/N 27-2862N952DAEppes Michael Scott · Austin, TXBuilt 1995 · S/N 3213103N952DGSkywatch Aviation LLC · Leesburg, VABuilt 1977 · S/N 14319N952JCCarver Jonathan E · Oxford, NCBuilt 2004 · S/N 5282N952LCThorx Aviation LLC · Tampa, FLBuilt 2007 · S/N 40021N952MKhan Mohsin H · Lodi, CABuilt 1966 · S/N 3364N952NDUniversity Of North Dakota · Grand Forks, NDBuilt 2020 · S/N 2881370N952SHNelson Chris · Crown Point, INBuilt 2005 · S/N 3920N952TBLong Jacob · Bend, ORBuilt 2011 · S/N 25074N952TFAir Fleet Holdings LLC · Missoula, MTBuilt 2025 · S/N 2881952N952WAMcenery William J · East Haddam, CTBuilt 1973 · S/N 394-73N95302Wright David W · Arlington, TXBuilt 1969 · S/N 28-25878N95303Morrison Robert F II · Denton, TXS/N 28-25879N95305Eagle Aviation Inc · Tucson, AZFirst renewal noticeBuilt 1969 · S/N 28-25880N9530BSierra Alpha Aeronautical LLC · San Antonio, TXBuilt 1981 · S/N 172RG0858N9530JNations Jeffrey L · Kingshill, VIS/N 28-3657N9530LClark Dale H · Discovery Bay, CABuilt 1974 · S/N AA5-0530N9530WGateway Flight Training LLC · Saint Louis, MOBuilt 1967 · S/N 28-22958N95315Valencic Adam · Apopka, FLBuilt 1969 · S/N 28-25885N9531DAtp Aircraft 4 LLC · Wilmington, DEBuilt 1999 · S/N 17280473N9531JGrayhawk Flight Training LLC · Lucas, TXBuilt 1966 · S/N 28-3658N9531KCline Timothy E · Rome, GABuilt 1976 · S/N 28-7610104N9531LBaker Bob E · Carmichael, CABuilt 1974 · S/N AA5-0614N9531MWright Bradley S · Quitaque, TXS/N 670108N95327Seashell Aviation LLC · Milton, FLBuilt 1969 · S/N 28-25889N95329Jay Stylz Trucking LLC · Cedar Rapids, IABuilt 1969 · S/N 28-25891N9532DPayne Frederick B · Fayetteville, GABuilt 1958 · S/N 22-6448N9532JHarris Jason L · Clanton, ALFirst renewal noticeBuilt 1966 · S/N 28-3659N9532LShattuck Charles W · Goshen, CTBuilt 1974 · S/N AA5-0532N9532PAerial Banners North Inc · Pembroke Pines, FLBuilt 1974 · S/N 25-7405618N9532WRodriguez Santos Jr · West Plains, MOS/N 28-22960N9533GSmith James R · Delaware, NJBuilt 1998 · S/N 18280354N9533JWadel Ronald A · Shippensburg, PABuilt 1966 · S/N 28-3660N9533MHattensty Robert Wade · Burleson, TXBuilt 1966 · S/N 670110N95343Obert Megan E · Hartselle, ALBuilt 1969 · S/N 28-25896N95346Jackson Douglas A · Cynthiana, KYBuilt 1969 · S/N 28-25512N95347Jora Imports LLC · Atlanta, GABuilt 1969 · S/N 28-25728N9534DLevinson Isaac F · White Salmon, WAS/N 22-6450N9534HBotezatu Florin · Gig Harbor, WABuilt 1975 · S/N 17266208N9534JTock Robert · Saint Paul, MOBuilt 1966 · S/N 28-3661N9534LPowley Robert L · Mahwah, NJS/N AA5-0534N95357Kidd Keith W · Covington, KYBuilt 1969 · S/N 28-25899N9535HNorthwest Wings LLC · Hillsboro, ORBuilt 1975 · S/N 17266209N9535JBradley D Schnell · Mequon, WIBuilt 1966 · S/N 28-3662N9535MGillman Charles J · Houston, TXBuilt 1966 · S/N 670112N9535WEast Carolina Aviation LLC · Camden, NCBuilt 1967 · S/N 28-22964N95364Hostetler Joseph A · Brownsburg, INBuilt 1969 · S/N 28-25900N95365Mason Brent M · Clarksville, FLBuilt 1969 · S/N 28-25734N95369Szmurlo Steven R · Easton, PABuilt 1969 · S/N 28-25901N9536DCalifornia Management And Consulting LLC · North Hollywood, CABuilt 1998 · S/N 17280481
Back to AD 87-10-06 R1