OpenAirDocs.org
AD 87-10-06 R1

Registered aircraft · 72,007

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.

N327STBeach Cities Real Property Holdings LLC · Hermosa Beach, CABuilt 2005 · S/N T18208447N32801Registration Pending · Indianapolis, INRegistration pendingBuilt 1971 · S/N 28-7525117N32805Scheffler Frederick L · Corinth, KYBuilt 1974 · S/N 28-7525115N32808Strander Chad A · Lodi, WIS/N 28-7515247N3280FChristian Edward A · Evans, GABuilt 1967 · S/N 670373N3280PRiggin Flight Service Inc · Madison, SDBuilt 1956 · S/N 23-679N3280RAmson Technology Lc · Des Moines, IABuilt 1969 · S/N 28R-31260N32810Knoch Thomas James · Grass Valley, CABuilt 1974 · S/N 32-7540067N32813Clear Sky Investments LLC · Martinsville, INS/N 28-7515248N32816Williamson Flying Club Inc · Williamson, NYBuilt 1974 · S/N 28-7515249N32817Keating William P · New Port Richey, FLBuilt 1974 · S/N 28-7515250N3281FCapps Daniel Boyce · Newcastle, OKS/N 670374N32820Turner Douglas A · Sacramento, CABuilt 1974 · S/N 28R-7535093N32825Manning John E Jr · Sylacauga, ALBuilt 1974 · S/N 28-7525118N3282QMaxwell Benjamin D · Collierville, TNBuilt 1977 · S/N 28-7725221N3282TCavu Aircraft Sales & Management Inc · Olyphant, PABuilt 1967 · S/N 17700582N32830Mach One Over Six LLC · Atlanta, GABuilt 1974 · S/N 28-7505097N32831Jochen Nathan D · Sevierville, TNBuilt 1974 · S/N 28R-7535094N32832Brendel William B · China Spring, TXBuilt 1974 · S/N 28-7510031N32837Arias Aviation LLC · Hazle Township, PABuilt 1974 · S/N 28-7525120N32838Brawders Stephen Andrew · Simi Valley, CABuilt 1974 · S/N 28-7525121N3283BGay Morgan C · Tunkhannock, PABuilt 1954 · S/N 20-1096N3283FMorgan Lance A · Georgetown, TXBuilt 1967 · S/N 670485N3283WGlasgow Ronnie Kyle Jr · Guin, ALS/N 32-114N32841Blue Sky West LLC · Tempe, AZBuilt 1974 · S/N 28-7515256N32846Coulter James A · Bakersfield, CABuilt 1974 · S/N 28-7515257N32847International Air Services Inc Trustee · Carson City, NVBuilt 1974 · S/N 28-7515258N3284FHicks Raymond K · Villa Rica, GABuilt 1967 · S/N 670377N3284REsser Jill · Mason, MIBuilt 1970 · S/N 28R-31261N3284WLower James A · Greenville, MIBuilt 1965 · S/N 32-115N3285FAir Mods And Repair Inc · Robbinsville, NJS/N 670378N3285PLsop Rentals Premier Asset Management LLC · Gowanda, NYBuilt 1957 · S/N 23-1233N32860Schroeder Scott · Decatur, TNS/N 28-7505099N32861New Hope Equipment Sales Inc · Ardmore, OKBuilt 1974 · S/N 28R-7535096N32865Minor Larry B · Glasgow, KYBuilt 1974 · S/N 28-7515265N32868Brolan Aviation LLC · Kansas City, MOBuilt 1974 · S/N 28-7515266N32870Pineland Flying LLC · Valdosta, GABuilt 1974 · S/N 28R-7535097N32871Luckie Deborah K · Kingman, AZS/N 28-7510032N32874Strawberry Aviation Inc · Watsonville, CABuilt 1974 · S/N 28-7525125N32876J-Mac Aviation Services LLC · Andalusia, ALBuilt 1974 · S/N 28-7515267N32878Hewett David R · Supply, NCBuilt 1974 · S/N 28-7515268N3287EOff Course Aero Ventures LLC · Mechanicsville, VABuilt 1978 · S/N 17271492N3287FSchaumberg John · Lebanon, INS/N 670380N3287QJase Aircraft Leasing LLC · Lenexa, KSBuilt 1977 · S/N 28-7725222N3287RWright Maurice · Las Vegas, NVBuilt 1970 · S/N 28R-31262N32888Flying Wings Inc · Wilmington, DEBuilt 1974 · S/N 28-7515270N3288FFlightbyte LLC · Wilmington, DEBuilt 1967 · S/N 670381N3288ZOney John M · Anchorage, AKBuilt 1959 · S/N 18-7218N32898Spitaleri Robert F · Winter Haven, FLS/N 28-7525126N3289AKennedy Kelly · Wheatland, WYBuilt 1953 · S/N 25933
Back to AD 87-10-06 R1