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.

N9580LBlack Carrell C · Cochranville, PABuilt 1974 · S/N AA5-0580N9580MRegistration Pending · Campbellsville, KYRegistration pendingBuilt 1966 · S/N 670157N9580URogers Ronald G · Forest, VABuilt 1975 · S/N AA5A-0080N9580WDestination Flyer LLC · Memphis, TNBuilt 1967 · S/N 28-23025N9581GN9581g Corp · Skokie, ILBuilt 1998 · S/N 17280530N9581SKing John D · Midland, VABuilt 1966 · S/N 192N9581VMartin Northern Aviation LLC · Benton, ARBuilt 1998 · S/N 18280257N9582DMontminy John · Berlin, NHBuilt 1958 · S/N 22-6489N9582HMiller Timothy · Saratoga, CABuilt 1975 · S/N 17266244N9582VCady Craig D · New Braunfels, TXBuilt 1974 · S/N 17264384N9582WBlomquist Kevin C · Kanab, UTS/N 28-23027N9583BBurke Larry Ryan · Pembroke, GABuilt 1981 · S/N 172RG0898N9583JTevik Michael A · Provo, UTBuilt 1966 · S/N 28-3722N9584B360 Marine · Bristol, RIBuilt 1981 · S/N 172RG0899N9584JLow Wing LLC · Upland, CABuilt 1966 · S/N 28-3723N9584MKing Wesley C Jr · Dayton, OHBuilt 1966 · S/N 670161N9584PSugarbush Soaring Assn Inc · Warren, VTBuilt 1974 · S/N 25-7405702N9584QHoward Genetics Inc · Ardmore, OKBuilt 1998 · S/N 18280258N9584VStick & Rudder Club Inc · Waukegan, ILBuilt 1974 · S/N 17264386N9584WMitchell Gary N · Kansas City, KSS/N 28-23030N9585CEldredge Matthew · Locust Grove, GABuilt 1978 · S/N 32R-7885058N9585DArnt James Robert Jr · Worthington, MNBuilt 1958 · S/N 22-6492N9585JHaj Aviation Inc · Cypress, TXNon-citizen corporation, flight hours not reportedBuilt 1966 · S/N 28-3724N9585KPuetthoff Jan H · Mount Sterling, KYBuilt 1976 · S/N 32R-7680230N9585LEight5lima LLC · Phoenix, AZBuilt 1974 · S/N AA5-0585N9585MScheuneman Carl V · Plano, TXBuilt 1966 · S/N 670162N9585VHarrington Aviation LLC · Scarborough, MEBuilt 1974 · S/N 17264387N9585WRandolph Richard A · Gallipolis, OHBuilt 1967 · S/N 28-23031N9586DHauser Nathan S · Newark, DES/N 22-6493N9586JGeorge Neal E · Crestview, FLBuilt 1966 · S/N 28-3725N9586LJones Jr Lee S · Kearneysville, WVBuilt 1974 · S/N AA5-0586N9586MH W S Enterprises Inc · Canal Fulton, OHBuilt 1966 · S/N 670163N9586WAlpha 3 LLC · Troy, KSBuilt 1967 · S/N 28-23032N9587JScott Jeremy A · Newark, OHBuilt 1966 · S/N 28-3726N9587LWiles Robert B · Biloxi, MSBuilt 1974 · S/N AA5-0587N9587MNorman Bradley T · Glen Rose, TXBuilt 1966 · S/N 670164N9587SReberg Timothy J · Bayport, MNBuilt 1965 · S/N 5N9587UKramer Andrew J · Sacramento, CAS/N AA5A-0087N9587VPinnick Brent E · West Baden Springs, INBuilt 1974 · S/N 17264389N9588DGardner Brian D · Mesa, AZS/N 22-6495N9588MDrietz Dallas A · Lake Benton, MNBuilt 1966 · S/N 670165N9588URgm LLC · Missoula, MTS/N AA5A-0088N9588VKachemak Bay Flying Service Inc · Temple, TXBuilt 1975 · S/N 17264390N9589HFryar Scott D · Starke, FLBuilt 1975 · S/N 17266248N9589LVincent Jared H · Fairhope, ALBuilt 1974 · S/N AA5-0589N9589SJones Daniel S · Panama City Beach, FLBuilt 1965 · S/N 9N958CPJoslyn Larry J · Las Vegas, NVBuilt 1996 · S/N S1710N958EGGores Thomas J · Franklin, WIBuilt 1976 · S/N 960547N958LRegistered aircraftBuilt 1993 · S/N 20446N958LBBevilacqua Jeffrey L · Thousand Oaks, CABuilt 2021 · S/N 001
Back to AD 87-10-06 R1