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.

N675QFisher Global LLC · Conway, ARBuilt 1959 · S/N TD-246N675RFGoodson Danny R · Bristol, VABuilt 2021 · S/N 21845N6760BAnderson Michael N · Anchorage, AKBuilt 1954 · S/N 18-5035N6760WBitter Loren Mark · Maricopa, AZBuilt 1965 · S/N 28-20885N6761UJaeger Howard E · Claremore, OKBuilt 1963 · S/N 2483N6761WGirdley James Kevin · Taylorsville, KYBuilt 1965 · S/N 28-20886N6762BCarver Clarence K Trustee · Lutz, FLBuilt 1956 · S/N 18-5037N6762LSummit Aviation LLC · Sun Valley, IDBuilt 1970 · S/N 31-664N6762NTaylor Norman A · Fayette, ALBuilt 1968 · S/N 680076N6762WFox John M · Warrenville, ILBuilt 2000 · S/N 60224N6763JMiddlestetter Matthew G · Green Cove Springs, FLBuilt 1968 · S/N 28-24487N6763NRegistration Pending · Minden, NVRegistration pending, pending cancellationBuilt 1968 · S/N 680077N6763PHeublein Eric C · Molalla, ORBuilt 1960 · S/N 24-1893N6764BMccollum Glen R Jr · Nikiski, AKBuilt 1956 · S/N 18-5039N6764JZalik Michael A · San Francisco, CABuilt 1968 · S/N 28-24488N6764NBiermann William W · Hollister, CABuilt 1968 · S/N 690001N6765NBogdan Joseph H · Soper, OKBuilt 1968 · S/N 680088N6765PJamison Ronnie L · Phoenix, AZBuilt 1960 · S/N 24-1895N6765WKakoczki Robert J · White Cloud, MIBuilt 1965 · S/N 28-20891N6766BRutland Norman L Jr · Birmingham, ALBuilt 1956 · S/N 18-5041N6766NFoley Erik J · Henderson, NVS/N 680079N6766PStephens Christopher R · Upper Marlboro, MDBuilt 1960 · S/N 24-1896N6767BHolseberg Aviation LLC · Ridgeville, SCBuilt 1956 · S/N 18-5042N6767CSilverstein Devyn · Austin, TXBuilt 1967 · S/N 670130N6767JLarson Wayne K · Amboy, CABuilt 1968 · S/N 28-24491N6767NEichhorn Tyler L · Paonia, COBuilt 1968 · S/N 680089N6767VParmenter Micah J · Aurora, COBuilt 1970 · S/N 700059N6768BKimmel Frank Stewart III · Greenwood, MSBuilt 1957 · S/N 18-5046N6768FFallis Robert P · Keller, TXBuilt 1972 · S/N AA5-0182N6768JSuncoast Flight Training LLC · Sarasota, FLBuilt 1968 · S/N 28-24492N6768NPorthouse Chris · Bellingham, MABuilt 1968 · S/N 680080N6768PKeenan John E · Saratoga, CABuilt 1960 · S/N 24-1899N6768RTaylor Bradley K · Muskego, WIS/N 18280543N6768UBranson Randel L · Eclectic, ALBuilt 1963 · S/N 2490N6768WCimeira Aviation LLC · Birmingham, ALBuilt 1965 · S/N 28-20895N6768YPiper Aircraft Inc · Vero Beach, FLBuilt 1968 · S/N 27-4100N6769JHanson Tobin S · Westlake, ORBuilt 1968 · S/N 28-24493N6769NCausey Kevin L · Bainbridge, GABuilt 1968 · S/N 680081N6769PKroll Richard L · Montague, MIBuilt 1960 · S/N 24-1900N6769UWard Leonard · Preston, IDBuilt 1963 · S/N 2491N676APiper Archer Three LLC · Wilmington, DEBuilt 2014 · S/N 2843779N676AKDillard Clayton B · Talkeetna, AKBuilt 2022 · S/N CD001N676ARBlackdog Air LLC · Belton, SCS/N 31-8152182N676CHTake Off Aviation Services LLC · Rockledge, FLBuilt 1976 · S/N 17266905N676DWSunrise Aviation Inc · Ormond Beach, FLBuilt 1999 · S/N 17280774N676ECCastle Joseph E · Marietta, OHBuilt 1997 · S/N 2163N676FLEdwards William J · Big Rapids, MIBuilt 1971 · S/N 28-7125605N676MMButler Nathaniel J · West Fargo, NDBuilt 2006 · S/N 2843631N676NLoftus Timothy P · Mclean, VABuilt 1968 · S/N 680032N676QKeil Urban G · The Villages, FLBuilt 2002 · S/N 4213
Back to AD 87-10-06 R1