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.

N9485FGonzales David M · Corvallis, ORBuilt 1966 · S/N 1260294N9485JBlakely Jerry II · Coeur D Alene, IDBuilt 1966 · S/N 28-3602N9485PMiddlebrook Eric · Anchorage, AKBuilt 1971 · S/N 24-4999N9485VBrown Douglas B · Petaluma, CABuilt 1970 · S/N 700043N9486BMccoy Robert P · Fairbanks, AKBuilt 1981 · S/N 172RG0837N9486CRhodes Ryan · Dallas, TXBuilt 1978 · S/N 28-7890415N9486JJames Andy K · Shallowater, TXBuilt 1966 · S/N 28-3603N9486KAerial Avionics Inc · Modesto, CABuilt 1976 · S/N 28-7615207N9486NRahimi Navid B · Silver Spring, MDBuilt 1969 · S/N 28R-35205N9487JElmenhurst Daniel D · Walla Walla, WABuilt 1966 · S/N 28-3604N9487KInverted Air LLC · Mesa, AZBuilt 1976 · S/N 28-7690254N9487RBoyer Air Lc · West Des Moines, IABuilt 1978 · S/N R18200710N9487WPikes Peak Fliers LLC · Colorado Springs, COBuilt 1968 · S/N 28-11226N9488DClear Prop Aviation LLC · Sioux City, IABuilt 1959 · S/N 18-6740N9488GTap Solutions Inc · San Diego, CABuilt 1979 · S/N 17273629N9488JSneed Associates LLC · Fort Morgan, COBuilt 1966 · S/N 28-3605N9488PAntes James H · Northfield, MABuilt 1971 · S/N 24-5004N9488VMarlow Michael L · Bandera, TXBuilt 1970 · S/N 700045N9489FHensley Richard · Bertram, TXS/N 870325N9489JIndiana County Flying Club Inc · Blairsville, PABuilt 1966 · S/N 28-3606N9489VReeder John Galen · Cedar Falls, IAS/N 700048N948DBBoard David N · Moundsville, WVBuilt 1963 · S/N 22-7600N948JTThompson James L · Thousand Oaks, CABuilt 2000 · S/N 001N948RVGeer Roy R · Fort Worth, TXBuilt 2004 · S/N 82021N948SAPavlatos Plato Nicholas · Springfield, OHBuilt 1989 · S/N 948N948SMScenic Concepts LLC · La Crosse, WIBuilt 1982 · S/N 172RG1057N948TPray Aviation Inc · Augusta, KSFirst renewal noticeBuilt 1964 · S/N TD-600N948WDAndrews Aviation Two LLC · Temple, TXBuilt 2010 · S/N 71660N9490HNovak Rickson J · Pine City, MNBuilt 1975 · S/N 17266177N9490PSurti Freddy Rusi · Des Moines, WABuilt 1971 · S/N 24-5007N9491JRoy Thomas M Jr · Carbondale, ILBuilt 1966 · S/N 28-3609N9491NWalker Mark L · Turlock, CABuilt 1969 · S/N 28R-35212N9491PClearprop Consulting LLC · Boynton Beach, FLBuilt 1972 · S/N 24-5008N9492FDeer Creek Helicopters LLC · Chico, CABuilt 1973 · S/N 1030245N9492HSchodack Aviation Association · Ghent, NYBuilt 1975 · S/N 17266178N9492NKnaust Kurt · Baldwinsville, NYBuilt 1969 · S/N 28R-35213N9492VRivera Jaime · San Antonio, TXBuilt 1970 · S/N 700066N9492WHixson Robert S · Los Alamos, NMBuilt 1969 · S/N 28-11232N9493DJack Browns Seaplane Base Inc · Winter Haven, FLBuilt 1958 · S/N 18-6745N9493JHayes Enterprises · Glendale, AZBuilt 1966 · S/N 28-3611N9493NHigh Prairie Aviation LLC · Washington, IABuilt 1969 · S/N 28R-35214N9493PNeidert Melvin E · Ulysses, KSS/N 24-5010N9494CChristensen Robert R · Mattawa, WABuilt 1978 · S/N 32-7840099N9494DReder Monte D · Miles City, MTBuilt 1958 · S/N 18-6746N9494JRuiz Serge · Montgomery, TXS/N 28-3613N9494RBig Squirrelly LLC · Kalispell, MTBuilt 2014 · S/N 1325N9494WDavisson Michael A · Edgewood, NMBuilt 1969 · S/N 28-11234N9495DEichholz Kenneth D · Cordova, TNBuilt 1985 · S/N 172RG1187N9495HNelson Flying Service LLC · Lansford, NDBuilt 1975 · S/N 17266180N9495NNagel Richard A · Mequon, WIBuilt 1969 · S/N 28R-35216
Back to AD 87-10-06 R1