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.

N4698DDrm Aviation LLC · Glencoe, ALBuilt 1979 · S/N 17272333N4698FSmith Marciano S · Fort Lauderdale, FLS/N 28-7715061N4698JShea William Preston · Franklin, TNBuilt 1968 · S/N 28R-30601N4699JBeach Robert E · Fairfax, VABuilt 1968 · S/N 28R-30602N4699PGv Air Inc · Medford, ORBuilt 1960 · S/N 27-227N4699RGillis Jeremiah · Cody, WYBuilt 1966 · S/N 28-21463N4699SStrike Allen P · Flint, MIBuilt 1969 · S/N 32-1158N4699YSandhill Soaring Club Inc · Brighton, MIBuilt 1967 · S/N 25-4417N469AKWells Kris G · Barron, WIBuilt 2018 · S/N CC18-0088N469BKClark John Wayne · Lexington Park, MDBuilt 1969 · S/N 32-1156N469CBCentral Boiler Promotions Inc · Greenbush, MNBuilt 2002 · S/N 1203N469DLuxury Aviation LLC · Butler, PABuilt 1977 · S/N 32R-7880030N469DKKimbrough Duke III · Rhome, TXBuilt 1984 · S/N 249N469DTBarr Air Patrol LLC · Mesquite, TXBuilt 2000 · S/N 18280773N469EHClaybrook Douglas E · Little Rock, ARBuilt 1978 · S/N R18200335N469FAStratus Rr LLC · New Castle, DEBuilt 2022 · S/N 28020069N469FSSunderland Richard · Matthews, NCBuilt 2013 · S/N 73474N469JHHolland John R · Jacksonville, FLBuilt 1975 · S/N 645N469JJTesmer Dean D · Rio, WIBuilt 1989 · S/N 1809030N469JLKnaack Roland · Cumming, GABuilt 1979 · S/N 32R-7987023N469JSToole William B · Goochland, VAFirst renewal noticeBuilt 1966 · S/N MA-23N469KLM9 Flight LLC · Delhi, LABuilt 1966 · S/N 61N469NETauber Samara R · La Jolla, CAFirst renewal noticeBuilt 1983 · S/N 17275952N469SMMyres Mark D · Freeland, WABuilt 2021 · S/N KA19290427N469TCEast Pole Aviation LLC · E Setauket, NYBuilt 2001 · S/N 18280989N469TFHalf Penny Hangar Inc · Houston, TXBuilt 2022 · S/N 2881592N469TWEmge Douglas W · Albertville, ALBuilt 1989 · S/N 507N46AArcher Jimmy R · Houston, TXBuilt 2000 · S/N 002WBN46AHDobbs Joseph D Jr · Charlotte, NCS/N 23180N46AJPosson John L Trustee · Petaluma, CABuilt 1998 · S/N 94-0155N46APMorris Christopher J · Crockett, TXBuilt 1963 · S/N 28-1203N46ATBurcar Mark L · Gig Harbor, WAS/N 1N46BEvans James · Tuolumne, CABuilt 1991 · S/N 1498N46BLGayle Todd S · El Paso, TXBuilt 1992 · S/N 27-0132N46CBSkylance Ventures LLC · Riverside, CABuilt 1977 · S/N 32R-7780481N46CCCravens Clarence C · Fairview, OKBuilt 2019 · S/N 7218001N46CTBurns Donald E · Corning, CABuilt 2003 · S/N 5208N46DAPotts Timothy W · Oscoda, MIBuilt 1993 · S/N 1556N46DCMonberg James · Seattle, WABuilt 1981 · S/N 0001N46DHMusgrave John R · Morris, ILS/N 369N46DJBullough William Ronald · Ocala, FLBuilt 2012 · S/N 144SRN46DZLuepke Quinn L · Wasilla, AKS/N 001N46EAEssential Aviation LLC · Meridianville, ALBuilt 1970 · S/N 39-79N46ERAviation Trust Company LLC Trustee · Oklahoma City, OKS/N 27-3649N46ETNicholson Jim · Cody, WYBuilt 2012 · S/N 8-6894N46EXRegistered aircraftBuilt 1993 · S/N 014N46EYFirefly LLC · Del Mar, CABuilt 1985 · S/N 46N46FCCopeland Forrest H · Brentwood, CABuilt 2003 · S/N 60075N46FTSerrino Sam K · Youngstown, OHBuilt 2022 · S/N 002N46GACrosswind Leasing LLC · Prescott, AZBuilt 2005 · S/N 10627
Back to AD 87-10-06 R1