OpenAirDocs.org
AD 87-08-08 R3

Registered aircraft · 22,416

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-08-08-R3')
    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-08-08-R3')
  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.

N9285GRockafellow Air LLC · Lubbock, TXS/N 2843073N9285JCope Jarret C · Lexington, NCS/N 28-3369N9285M5 M Leasing LLC · Englewood, COBuilt 1985 · S/N 28-8616043N9285QJrb Aviation Ltd · Jasper, GABuilt 1997 · S/N 3257023N9286MWiley Aviation LLC · Murfreesboro, ARBuilt 1985 · S/N 28-8616044N9286WAmigos Flight Club LLC · Schertz, TXBuilt 1967 · S/N 28-10962N92877Hart Air LLC · Graford, TXS/N 3246078N9287ESkyborne Airline Academy Inc · Vero Beach, FLBuilt 1997 · S/N 2842019N9288BWuest Air LLC · Wilmington, DEBuilt 1997 · S/N 3246079N9288JMccormack John P · New Castle, INS/N 28-3373N9288KCoug Air LLC · Oregon City, ORBuilt 1976 · S/N 28-7690240N9288WThut Bruno H · Chagrin Falls, OHBuilt 1967 · S/N 28-10965N9289CSmallwood Chadwick D · Newnan, GABuilt 1978 · S/N 28-7890397N9289WCoffman John H · Polo, ILBuilt 1967 · S/N 28-10966N928BLWingsleasing LLC · Wichita, KSBuilt 2024 · S/N 2881767N928LYLp Aviation Maintenance LLC · Bayonne, NJS/N 28R-30007N928PPSwair LLC · Denver, COS/N 2843298N928TAPray Aviation Inc · Augusta, KSBuilt 1981 · S/N 28-8116180N928WAChapman Martha P · Rogersville, TNBuilt 1976 · S/N 28-7790142N9290CMym Air LLC · Pattison, TXBuilt 1978 · S/N 28R-7837184N9290DSymons George Jay Trustee · San Francisco, CABuilt 1997 · S/N 3246086N9290JRodgers Bruce F · Quakertown, PABuilt 1966 · S/N 28-3375N9290KArrow Leaseback LLC · Danbury, CTBuilt 1976 · S/N 28R-7635231N9290NFlight Vision 1 LLC · Lake Mary, FLBuilt 1997 · S/N 2843108N9290UPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020281N9291JMidwest Aero Club Inc · Omaha, NEBuilt 1966 · S/N 28-3377N9291WFarleman LLC · Aurora, OHBuilt 1968 · S/N 28-11100N9292LRegistered aircraftBuilt 1997 · S/N 3246092N9292NN9292n LLC · Valdosta, GABuilt 1997 · S/N 3257008N9292QRegistered aircraftBuilt 1997 · S/N 3246077N9293BCludy Skies LLC · Wildwood, MOBuilt 1997 · S/N 2843100N9293JChaldu Ronald S · Oswego, NYBuilt 1966 · S/N 28-3381N9293KYakel Donald L Jr · Springfield, ILFirst renewal noticeBuilt 1997 · S/N 3246093N9293YBecker Ryan · Sheldon, IABuilt 1985 · S/N 32R-8629004N92949Prouts Travel LLC · Wilmington, DES/N 3246094N9294NCmhw LLC · Memphis, TNBuilt 1998 · S/N 3246104N9294QPlane Training LLC · Rapid City, SDBuilt 1998 · S/N 2843122N9294WBorkowski Brian L · Irwin, IABuilt 1967 · S/N 28-10971N9295GMcavian LLC · Westworth Village, TXBuilt 1997 · S/N 3257017N9295JKohn Brent A · Spring Valley, MNS/N 28-3385N9295WH&H Aircraft LLC · Scottsbluff, NEBuilt 1967 · S/N 28-10972N9296JAlpha Kilo Aviation LLC · Wasilla, AKBuilt 1966 · S/N 28-3386N9296NSunrider Aviation Inc · Irvine, CABuilt 1997 · S/N 3257013N9297C831 Aviation LLC · Salinas, CABuilt 1978 · S/N 32-7840093N9297QTequila Sunrise LLC · Anniston, ALBuilt 1997 · S/N 2843097N9297WTorrey Robert E · Pleasant Hill, CABuilt 1967 · S/N 28-10974N9298DAims Air LLC · Kingsport, TNBuilt 1997 · S/N 3257002N9298JSt Pete Aviation Services LLC · Saint Petersburg, FLBuilt 1997 · S/N 2843107N9298LLangenberg Stewart M · Santa Barbara, CABuilt 1998 · S/N 3246108N9298NDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 1997 · S/N 3257005
Back to AD 87-08-08 R3