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.

N9516MBurrell John Eric · Springfield, VABuilt 1966 · S/N 670093N9516WRingco Aviation LLC · Oklahoma City, OKS/N 18280226N95173First Flight Corporation · San Diego, CABuilt 1969 · S/N 28-25832N9517DLarson David R · Boerne, TXBuilt 1958 · S/N 22-6433N9517FS Martinez Livestock Inc · Moxee, WABuilt 1967 · S/N 170312N9517JBanks Brian H · Zebulon, GABuilt 1966 · S/N 28-3640N95181Stahl Jason R · Etters, PABuilt 1969 · S/N 28-25835N9518DJaugust Vladimir · Somerville, MABuilt 1998 · S/N 18280126N9518MPritchard Benjamin Ross · Cedar Rapids, IABuilt 1966 · S/N 670095N9518SSprunk Logan J · Chaffee, NDBuilt 1965 · S/N 7GCB-283N9518WMarshall Christopher · Oshkosh, WIBuilt 1967 · S/N 28-22944N95192Kilo Fox Aviation LLC · Saint Joseph, MIBuilt 1969 · S/N 28-25837N95198Hippen Justin L · Virginia, NEBuilt 1969 · S/N 28-25839N9519DCraig Reginald S · Deville, LABuilt 1958 · S/N 22-6435N9519JBarlia David L · Anaheim, CABuilt 1966 · S/N 28-3643N9519MNiemeyer John P · Cortland, NEBuilt 1966 · S/N 670096N951ACCotyk Andrew L · Galesburg, MIBuilt 2024 · S/N 90072N951AGAcn951ag LLC · Worthington, OHBuilt 1999 · S/N 850-99N951ANNorth Branch Aviation LLC · Fort Worth, TXBuilt 1974 · S/N AA5-0669N951GTK And M Aviation LLC · Palm Harbor, FLBuilt 1979 · S/N 32-7940036N951HCUsweixin · Sheridan, WYBuilt 1980 · S/N 172RG0282N951JBHuddleston H Glenn · San Antonio, TXBuilt 2000 · S/N 20029N951KCN951kc LLC · Rehoboth Beach, DEBuilt 1995 · S/N 2526N951MCSky Mates Inc · Wilmington, DEBuilt 2001 · S/N 172S8951N951MKFeliciano Gordon F Jr · Thornton, COBuilt 1977 · S/N AA5B0613N951NDUniversity Of North Dakota · Grand Forks, NDBuilt 2025 · S/N 2881925N951RVSeverance Ryan N · Darwin, MNBuilt 2009 · S/N 90337N951SJeffrey M Abbott · Canonsburg, PABuilt 2021 · S/N 41953N951SMBurks Aviation Inc · Hattiesburg, MSBuilt 2004 · S/N 21084CN951SPN591sp LLC A Series Of Aero Lease LLC · San Antonio, TXS/N 172S8151N951TFAir Fleet Holdings LLC · Missoula, MTBuilt 2025 · S/N 2881951N951WEEmbree Walter G · Harrisonburg, VABuilt 2008 · S/N 22656N951WTShook William W · New Port Richey, FLBuilt 2014 · S/N 81417N95203Neptune Aviation Services Inc DBA · Missoula, MTBuilt 1969 · S/N 28-25840N9520DHodge Flight Services LLC · Pittsburg, CABuilt 1998 · S/N 17280385N9520JStaples Laurence C · Makanda, ILBuilt 1966 · S/N 28-3645N9520MCoker Steve L Jr · Tyler, TXBuilt 1966 · S/N 670097N9520SPease Richard C · Snow Camp, NCBuilt 1965 · S/N 8N9520WAmeriflyers Of Texas Inc · Addison, TXBuilt 1998 · S/N 17280407N95211Massey Aviation LLC · Ashburn, GABuilt 1969 · S/N 28-25843N95216International Air Services Inc Trustee · Carson City, NVBuilt 2008 · S/N 71523N95217Laight Kevin · Greeneville, TNS/N 28-25844N9521HJordan Recreation Development LLC · Clinton, TNBuilt 1975 · S/N 17266197N9521JGeesaman Brian K · Mount Pleasant, PABuilt 1966 · S/N 28-3739N9521WFlap Happy LLC · Sheridan, WYBuilt 1967 · S/N 28-22948N95225Cherokee 95225 LLC · Provo, UTS/N 28-25851N9522ADunn Legacy Inc · Saint Petersburg, FLBuilt 1998 · S/N 17280411N9522EGraham Xochitl L · Los Lunas, NMBuilt 1976 · S/N 76-31134N9522HUrbas Robert M · Rockford, ILBuilt 1975 · S/N 17266198N9522MCrouch Mark W · Cumming, GABuilt 1966 · S/N 670099
Back to AD 87-10-06 R1