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.

N6701ZOsher Air LLC · Wallingford, IABuilt 1963 · S/N 25-2308N67022Mccormack James · Mount Jewett, PABuilt 1970 · S/N 17259032N6702DMcwilliams Christopher S · Atlanta, GABuilt 1979 · S/N M-2231N6702HGoetz Terry L · Defiance, IABuilt 1975 · S/N 17265545N6702JWaldron Michelle M · Saranac, NYBuilt 1968 · S/N 28-24397N6702NRoman Jose Ernesto · Guaynabo, PRBuilt 1968 · S/N 680080N6702PWakefield Robert M · Winnemucca, NVBuilt 1960 · S/N 24-1828N6702UKruse Benjamin · Phoenix, AZS/N 2434N6702XFlight Time Builders Inc · Memphis, TNBuilt 1981 · S/N ME-287N6703SSilverhawk Aviation Academy LLC · Caldwell, IDBuilt 2004 · S/N 3621N6703ZSchneider Aerial Inc · Rugby, NDBuilt 1963 · S/N 25-2309N6704DScaled Composites LLC · Mojave, CABuilt 1980 · S/N ME-325N6704EWings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 17272052N6704JRussell John T · Southaven, MSBuilt 1979 · S/N M-2238N6704LSoflo Aviation LLC · Oakland Park, FLBuilt 1979 · S/N M-2240N6704NBethel William C · Murray, KYBuilt 1968 · S/N 680081N6705JDuncan William E · Troy, IDBuilt 1968 · S/N 28-24400N6705NGerback Andrew · East Canton, OHBuilt 1968 · S/N 680042N6706BZvacek Dennis E Trustee · Tulsa, OKBuilt 1956 · S/N 22-4038N6706HDairy Air Inc · Wyoming, PABuilt 1975 · S/N 17265547N6706NKorn Richard Mark · Lexington Park, MDBuilt 1968 · S/N 680082N6706PHadley George M · Boston, MABuilt 1960 · S/N 24-1832N6706YSorbi Aviation Inc · El Cajon, CABuilt 1979 · S/N ME-299N6707FSeals Jeremy C · Goshen, KYBuilt 1976 · S/N 32R-7780035N6707HWjt Investments LLC · Gurley, ALBuilt 1975 · S/N 17265548N6707NRegistered aircraftBuilt 1968 · S/N 680043N6707XGromack Stephen · Bloomfield, NMBuilt 1980 · S/N M-2241N6707ZHood River Soaring Inc · Hood River, ORBuilt 1963 · S/N 25-2316N6708BHartman Darrell W · Fish Lake Valley, NVBuilt 1956 · S/N 22-4041N6708NBobby Stephen M · Dunkirk, MDBuilt 1979 · S/N M-2243N6708PWest Robert S · Gravois Mills, MOBuilt 1960 · S/N 24-1834N6708RStorey Timothy J · Camarillo, CABuilt 1980 · S/N M-2244N6708SWininger Spencer C · Wichita, KSBuilt 1980 · S/N M-2245N6708UBlaedow Kyle R · Leesville, LAS/N 2440N6708VAircraft Restoration Service Enhancements LLC · Mesa, AZBuilt 1970 · S/N 31011N6709FMorning Star Transportation Inc · Dardanelle, ARBuilt 1979 · S/N M-2247N6709PRzewinski Leonard · Wading River, NYBuilt 1960 · S/N 24-1835N670BBeck Mark A · Fort Wayne, INBuilt 2007 · S/N 60176N670LHFf22 LLC · Scottsdale, AZBuilt 2023 · S/N 2881680N670MAVan Anda Aviation LLC · Apopka, FLBuilt 1999 · S/N 17280728N670MPStar Ground Services Inc · Tinian, MPBuilt 1971 · S/N 32-7140021N670PWN670pw LLC · Monmouth Beach, NJBuilt 1981 · S/N 32R-8213010N670RVSokoloski Gregory · Magnolia, TXBuilt 2006 · S/N 90670N670SBDanles Enterprises LLC · Solvang, CABuilt 2001 · S/N 23806N670SCSpartan Education LLC · Tulsa, OKBuilt 2021 · S/N 2881436N670UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2024 · S/N 28020168N670WBCt Cattle Co LLC · Wichita Falls, TXBuilt 1966 · S/N 30-1053N6710BBarnard Matthew Bryan · Fort Worth, TXBuilt 1980 · S/N M-2246N6710NJohnson Kenneth W · Pine Bluff, ARBuilt 1968 · S/N 680084N6710POdell Jeffrey S · Roseville, CABuilt 1960 · S/N 24-1836
Back to AD 87-10-06 R1