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.

N8383HAerni Brian S · Columbus, NEBuilt 1981 · S/N 28-8116221N8383PWhatley Mark · Orion, MIBuilt 1964 · S/N 24-3642N8383TLoyd Dayton A · Carbondale, ILBuilt 1981 · S/N 28-8116223N8383VH&M Air LLC · Metamora, MIBuilt 1981 · S/N 28-8116224N8383WMj Aero LLC · Mims, FLBuilt 1965 · S/N 28-2586N8383YHolland Carl J · Dillsboro, INBuilt 1967 · S/N 30-1538N8383ZFreeman Edward B · Killeen, TXBuilt 1981 · S/N 288190229N8384CMountain Flying Adventures LLC · Missoula, MTBuilt 1976 · S/N 32R-7680105N8384EG & M Aircraft Inc · Wheat Ridge, COBuilt 1981 · S/N 28-8190236N8384HTwin Tier Aviation Association Inc · Eldred, PABuilt 1981 · S/N 28-8190237N8384LMaring Inc · Blaine, MNBuilt 1981 · S/N 32R-8129054N8384PMauch Archie C · Magnolia, TXBuilt 1964 · S/N 24-3643N8384SBuschmeier William A · Cincinnati, OHBuilt 1981 · S/N 28-8111065N8384WWilt Jared C · Marysville, OHBuilt 1965 · S/N 28-2587N8384YProgressive Flying Corp · North Salem, INBuilt 1981 · S/N 28-8111072N8385LKrebs Lisa Christine · Homer, AKBuilt 1968 · S/N 17256585N8385QBlue Sky Harbors LLC · Crystal, MNBuilt 1981 · S/N 32-8106064N8385SN8385s LLC · Lancaster, PABuilt 1981 · S/N 32-8106065N8385WJohnson Robert J · Floral City, FLS/N 28-2588N8385YNesbitt Loyd B Jr · Independence, ORBuilt 1967 · S/N 30-1540N8386BSprj Aviation LLC · Tampa, FLBuilt 1981 · S/N 32R-8113068N8386C86 Charlie LLC · Rochester, MNBuilt 1976 · S/N 28-7690134N8386HSierra Aero · Carson City, NVBuilt 1981 · S/N 32R-8129067N8386LAdams Haidyn · Pentwater, MIS/N 17256586N8387CRuday Dennis J DBA · Glendora, CABuilt 1976 · S/N 28-7625110N8387JCallison Patrick L · Hazel Green, ALBuilt 1979 · S/N VAC-153-80N8387LSerra Christopher R · Snellville, GABuilt 1968 · S/N 17256587N8387RMiloud Chadd K · Fort Worth, TXBuilt 1966 · S/N 28-22264N8387WHolt Zachary Ian · Bogalusa, LAS/N 28-2591N8387YN8387y LLC · Huntsville, ALBuilt 1967 · S/N 30-1542N83882Warrior 83882 LLC · Dover, DES/N 28-8116227N8388AHamm Simon P · Denali, AKBuilt 1953 · S/N 25240N8388RFloyd James · Gainesville, TXBuilt 1966 · S/N 28-22265N8388WWatts Timothy S · Denver, NCBuilt 1965 · S/N 28-2592N8388YInternational Air Services Inc Trustee · Carson City, NVBuilt 1981 · S/N 28-8116226N83894Sale Reported · Grangeville, IDSale reportedBuilt 1981 · S/N 32-8124029N8389AJacobus Larry E · Ipava, ILBuilt 1981 · S/N 28-8116228N8389EBymers Robert F · Waunakee, WIS/N 1567N8389LJkg LLC · Murfreesboro, TNBuilt 1968 · S/N 17256589N8389PPower Joe D · Seguin, TXS/N 24-3648N8389WStegemoller Ronald G · Washington, TXS/N 28-2594N838AJsl Air LLC · Sikeston, MOS/N 83812017N838CFCherokee Flyers Inc · Vero Beach, FLBuilt 2024 · S/N 2881838N838DHGcbc LLC · Norman, OKBuilt 1979 · S/N 28-7916247N838JHFitzmaurice Doyle · Sparta, WIS/N 28-7110009N838JWFleming Cheri Rene · Joseph, ORBuilt 1977 · S/N 18-7709147N838MACca Aero Estate LLC · Missoula, MTS/N 28-7916019N838MBFreischlag Karl A · Fort Collins, COBuilt 1989 · S/N SN-460RN838MPWhitney Stephen · Fort Myers, FLS/N 17258274N838PProfessional Training Aircraft LLC · Wilmington, DEBuilt 2018 · S/N 2843941
Back to AD 87-10-06 R1