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.

N9088QGolf Foxtrot Yankee LLC · Kingston, NYBuilt 1986 · S/N 2890002N9088UPennington Daniel W · Rutland, VTBuilt 1986 · S/N 28-8611008N9089K&M Land Surveying Inc · Lincoln, NEBuilt 1966 · S/N 32-215N90898Nation Steven R · Hurricane, UTBuilt 2007 · S/N 24131N9089CCrew Sourcing Inc · Wilmington, DEBuilt 1985 · S/N 28-8690016N9089HDavis Joseph S · Andalusia, ALBuilt 1975 · S/N 17265936N9089PDummer Donald W · Novato, CABuilt 1966 · S/N 24-4563N908AArcher Aero LLC · Wilmington, DEBuilt 2015 · S/N 2843802N908AFRobinson Craig M · Colfax, CABuilt 1967 · S/N 28-23976N908AGPeregrine Howard Aeroflight Owner LLC · New Orleans, LABuilt 2025 · S/N 2881946N908AZWingsleasing LLC · Wichita, KSS/N 40.388N908BLBoudreaux Jacques P · Shreveport, LABuilt 2006 · S/N 90854N908CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 172S8331N908DKNeilson Frank · Orlando, FLBuilt 1973 · S/N 32-7440070N908DRRhodes Dennis R · Taylorsville, GABuilt 2008 · S/N 91359N908ENEl Aviation LLC · Alpena, MIBuilt 2000 · S/N 20608105N908GDCorpus Terra Investments LLC · Hialeah, FLBuilt 1988 · S/N 2040N908JDNash Gregg Lynn · New Waverly, TXBuilt 2009 · S/N 81284N908MABlue Air Venture LLC · Gilcrest, COS/N T20608093N908NDUniversity Of North Dakota · Grand Forks, NDBuilt 2020 · S/N 2881368N908QCCook Hugh Q · Aurora, COBuilt 2020 · S/N 82854N908TBushby Harvey M · Minooka, ILBuilt 2009 · S/N M-II-2418N908VLBlue Waters Air Charters LLC · San Juan, PRBuilt 1984 · S/N 2187N90908Charles Wilford W · Big Lake, AKBuilt 1981 · S/N 18-8109043N9090BHaynes Aviation LLC · Wetumpka, ALBuilt 1986 · S/N 2890003N9090PCatherwood Owen · Eugene, ORBuilt 1966 · S/N 24-4564N9090WRyeco Inc · Lewes, DEBuilt 1965 · S/N 28-10696N9090XTahaney David J · Fox Lake, ILS/N 2811001N90912Snead Douglas A · Derby, KSBuilt 1972 · S/N 338-73N90919Allman Joseph S · Blackstone, VABuilt 1973 · S/N 61-73N9091CYoung Gregory S · Riverside, CABuilt 1978 · S/N R18200396N9091DCanton Logan J · Petersburg, AKS/N 18-6469N9091HCampbell Raymond · Box Elder, SDBuilt 1975 · S/N 17265937N9091PGalagan Robert · Lincoln Park, NJBuilt 1966 · S/N 24-4565N9091VScheutzow David P · Medina, OHBuilt 1968 · S/N 690008N9091YCsa Investments LLC · Wayne, PABuilt 1969 · S/N 28R-35197N90922Blair Ernest J · St Thomas, NDBuilt 1981 · S/N 18-8109045N90928Skunberg Leonard T · Salmon, IDS/N 253-73N9092CAdirondack Aviators LLC · Peru, NYBuilt 1978 · S/N R18200397N9092HWinemiller Stevie Dale · Swifton, ARBuilt 1975 · S/N 17265938N9092JRegistered aircraftBuilt 1966 · S/N 28-3130N9092VHogan Roger C · Virginia Beach, VABuilt 1969 · S/N 690004N9092WLong Earl V III DBA · Wichita, KSBuilt 1997 · S/N 246N9093Zimsim LLC · Charleston, SCBuilt 1974 · S/N 212N90931Davies Donald K · Hastings, MNBuilt 1981 · S/N 18-8109048N90932Hall Air Inc · Weiner, ARBuilt 1973 · S/N 432-73N9093FArcher 93f LLC · Danvers, MABuilt 1986 · S/N 28-8690039N9093JRichardson Harley T Jr · Mullins, SCS/N 28-3131N9093KPdg Leasing LLC · Maryland Heights, MOBuilt 1985 · S/N 28-8690032N9093LBielamowicz John Kolbe · Waxahachie, TXBuilt 1970 · S/N 228-70
Back to AD 87-10-06 R1