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.

N7090RMekolichick Jerry D · Whitehall, PABuilt 1966 · S/N 28-21793N7090WShipman Donald C · Interlochen, MIBuilt 1962 · S/N 28-877N7090YTucker Brandon · Rockledge, FLBuilt 1973 · S/N 28-7305058N7090ZSales Joe H · Seminole, TXBuilt 1964 · S/N 25-2876N7091GSkylark Flight Training LLC · Wilmington, DEBuilt 1969 · S/N 17258791N7091VFreimund Chandler R · Big Horn, WYBuilt 1976 · S/N 20-1217N7092FBerger Jeremy L · Noble, ILBuilt 1976 · S/N 28-7715194N7092GAmick Thomas C · Newberry, SCBuilt 1969 · S/N 17258792N7092PPaul Eric C · Grapevine, TXBuilt 1961 · S/N 24-2246N7092RCosey William Vester Franklin · Inverness, FLBuilt 1966 · S/N 28-21796N7092VTextor William E · Springfield, MOBuilt 1976 · S/N 20-1218N7092ZHollister Soaring Center LLC · Hollister, CABuilt 1964 · S/N 25-2879N7093BBackcountry Aviation LLC · Berthoud, COFirst renewal noticeBuilt 1957 · S/N 18-5176N7093FPockrus Pat B · Mineral Wells, TXBuilt 1966 · S/N 15063693N7093GAero Performance LLC · Scooba, MSBuilt 1969 · S/N 17258793N7093RKearns Joseph E · Worthington, OHBuilt 1966 · S/N 28-21797N7093YMoore James S Trustee · Gray Court, SCBuilt 1963 · S/N 30-108N7093ZMid Continent Aircraft Corp · Hayti, MOBuilt 1964 · S/N 25-2880N7094DPotter Kent · Laurel, MTBuilt 1957 · S/N 18-5584N7094GJohnson And Assoc · Davenport, IABuilt 1969 · S/N 17258794N7094JTtwn Media Networks LLC · New York, NYBuilt 1999 · S/N 0600N7094PS & M Aviation LLC · South Boston, VABuilt 1960 · S/N 24-2249N7094QRegistered aircraftBuilt 1972 · S/N 17260394N7094RWilson Flyers LLC · Rocky Mount, NCBuilt 1966 · S/N 28-21798N7094VMason Gary W · Rockledge, FLBuilt 1976 · S/N 22-1422N7095GHunter John Bockett · Riverton, NJBuilt 1969 · S/N 17258795N7095QWong Henry L III · Lake Forest, CABuilt 1972 · S/N 17260395N7095RStevens Aircraft LLC · Morehead, KYBuilt 1966 · S/N 28-21799N7095WByers Brady L · Newberg, ORBuilt 1962 · S/N 28-882N7096RHumphrey Richard K Jr · Abilene, TXBuilt 1966 · S/N 28-21800N7096WN7096w LLC · Sherman Oaks, CABuilt 1962 · S/N 28-883N7097GMurdy David C · Round Rock, TXBuilt 1969 · S/N 17258797N7097RFields Michael L · Rockwood, TNBuilt 1966 · S/N 28-21802N7097WGlidepath Consulting LLC · Yuma, AZBuilt 1962 · S/N 28-884N7098NSearcy Moto-Air Inc · Searcy, ARS/N 2409N7098WFarabee Mechanical Inc · Hickman, NEFirst renewal noticeBuilt 1962 · S/N 28-885N7099CAnderson Richard Alan · Brainerd, MNBuilt 1975 · S/N 28-7615042N7099GHunt Howard E · Martinsville, ILBuilt 1969 · S/N 17258799N7099QVenaleck John T · Painesville, OHBuilt 1972 · S/N 17260399N7099YSparks Richard A · Wasilla, AKS/N 18-8135N709AMAirtrust LLC - 13 - Series 13 Trustee · Sheridan, WYBuilt 2001 · S/N 2101N709BTAverett University · Danville, VABuilt 2017 · S/N 2843920N709BWWolf Robert B · Boise, IDBuilt 1999 · S/N 25111N709CAChristiansen Aviation LLC · Wilmington, DEBuilt 2024 · S/N 2881729N709CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281709N709DBPowerhouse Detox Inc · Otis, ORBuilt 2004 · S/N 18281382N709DFGregoire Aviation Services LLC · New York, NYBuilt 1979 · S/N 28-7916349N709GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881205N709HSRokaboka Ltd · Mount Ida, ARFirst renewal noticeS/N 27-3615N709LAN709la LLC · Philadelphia, PABuilt 2025 · S/N 28020221
Back to AD 87-10-06 R1