OpenAirDocs.org
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.

N415RGalyon Aviation LLC · Sweetwater, TNBuilt 1958 · S/N TD-161N415RCAvco Patrol LLC · Lyndon, KSBuilt 1998 · S/N 18280302N415SGriffing Flying Service Inc · Port Clinton, OHBuilt 1978 · S/N 28-7990041N415SAArtemis Aviation Group LLC · Kalispell, MTBuilt 1954 · S/N 14064N415VAVel-Air Inc · Clifton, VABuilt 2000 · S/N 4636290N415WHPaavola Troy E · Kansas City, MOS/N 28R-7435199N415WRN415wr LLC · Bogart, GAS/N 4636147N41604Schuur Rodney E · Slayton, MNBuilt 1974 · S/N 28-7415290N41606My Flight LLC · Cypress, TXS/N 287415291N41609Worthington John F II · Russiaville, INBuilt 1974 · S/N 28-7405124N4160CNewman Holdings LLC · Dallas, TXBuilt 1978 · S/N R18200332N4160FYatin Servet · Weston, MABuilt 2000 · S/N 2844028N4160JIvy James E · Alba, TXS/N 28-22489N4160NSteele Howard Scott · Idaho Falls, IDBuilt 2000 · S/N 4636280N4160POgle Richard W Jr · Joplin, MOS/N 23-1645N41614Cartier Edward J Jr · Columbia, MSS/N 28-7415294N41618Evv Warrior LLC · Evansville, INBuilt 1974 · S/N 28-7415295N41619Charles City Aeronautics Inc · Charles City, IABuilt 1974 · S/N 28-7415296N4161JRegistration Pending · Hardinsburg, KYRegistration pendingBuilt 1966 · S/N 28-22490N4161PRegistered aircraftBuilt 1999 · S/N 2843309N4161ZAri Ben Aviator Inc · Fort Pierce, FLBuilt 1998 · S/N 2843129N41622Stingray LLC · Kalispell, MTBuilt 1974 · S/N 28-7415297N41623Airplanesusa LLC · Schaumburg, ILBuilt 1974 · S/N 28-7405126N4162MSilverhawk Aviation Academy LLC · Caldwell, IDBuilt 2008 · S/N 1877N4162REckman Jason · Waterford, WIBuilt 1968 · S/N 32-40477N4162WBas Part Sales LLC · Greeley, COBuilt 1967 · S/N 32-40235N4162YGarrels Gregory J · Salcha, AKBuilt 1977 · S/N 242-77N4162ZSpirit Flyers Inc · Saint Louis, MOBuilt 2000 · S/N 3257127N41639Airmotive Service LLC · Brigham City, UTBuilt 1974 · S/N 28-7415299N4163DMiraza Aviation LLC · Longview, TXBuilt 2000 · S/N 32-57145N4163EAllied Aviators Inc · Allison Park, PABuilt 2000 · S/N 3257136N4163FHammans Gail A · Hot Springs, ARBuilt 1976 · S/N 28-7725003N4163JLoera Josa · Laredo, TXS/N 28-22493N4163PMalibu Aviation LLC · Bloomfield Hills, MIBuilt 2000 · S/N 4636274N4163RFlying Javelina Aero-Club · Tucson, AZBuilt 1968 · S/N 32-40478N41641Gunderson Roger · Fort Collins, COBuilt 1999 · S/N 2843276N41645Coastal Air Inc · Groton, CTBuilt 1974 · S/N 28-7405128N41648Russell Matthew M · Niantic, CTBuilt 1974 · S/N 28-7415304N41649Air Trek North LLC · South Saint Paul, MNBuilt 1974 · S/N 28-7415305N4164HRobertson James I · La Pine, ORBuilt 1978 · S/N 24-0623N4164JCaister Benjamin M · Saint Clair, MIS/N 28-22494N4164PSeaplanes R Fun Inc · Wilmington, DEBuilt 1959 · S/N 23-1649N4164YBoard Of Trustees · Savoy, ILBuilt 2000 · S/N 2843317N41650Airmotive Service LLC · Brigham City, UTBuilt 1974 · S/N 28-7415306N41657Morton Zac D · San Antonio, TXBuilt 1974 · S/N 28-7415308N4165EJauer Brant A · Saukville, WIBuilt 1999 · S/N 2843291N4165LValiair Limited Co Trustee · Tucson, AZS/N 3257129N4165UInter American University Of Puerto Rico · Bayamon, PRBuilt 1998 · S/N 2843200N4165ZHollingsworth Lloyd Dan · Anchorage, AKBuilt 1965 · S/N 18-8346N41667Lewis Clifton Jack · North Branch, MIBuilt 1974 · S/N 28-7415116
Back to AD 87-10-06 R1