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.

N9466NWingert Douglas L · Smithfield, KYBuilt 1969 · S/N 28R-35182N9466PNewton Bros · Stratford, CABuilt 1973 · S/N 18-7309016N9466WDisorbo Stephen S · New Milford, CTBuilt 1968 · S/N 28-11190N9467CDominy Alan L · The Woodlands, TXBuilt 1978 · S/N 28-7890413N9467DHahn Randal N · Wasilla, AKBuilt 1951 · S/N 18-863 MCN9467PRiver Aviation LLC · Wilmington, DEBuilt 1971 · S/N 24-4977N9467WHartshorn Brian · Waynesville, OHBuilt 1968 · S/N 28-11192N9468DKelly Henry Searles · Ossining, NYBuilt 1984 · S/N 172RG1177N9468FColeman Harold D · Pikeville, KYBuilt 1966 · S/N 106-0264N9468HShouse Andrew · Flagstaff, AZBuilt 1975 · S/N 17266169N9468JSheffield Glenn A · Houston, TXBuilt 1966 · S/N 28-3582N9468PSmall Alan J · Bristol, RIBuilt 1971 · S/N 24-4978N9469DRanney Gayle · Cordova, AKBuilt 1959 · S/N 18-6815N9469EParker Duane E · Louisville, KYBuilt 1979 · S/N 17272273N9469HAirplanes And Attitude LLC · Mckinney, TXBuilt 1975 · S/N 17266170N9469JNelson Stephen A · Milaca, MNBuilt 1966 · S/N 28-3584N9469VNorton Curtis S Jr · Beaver Falls, PAS/N 700038N946BWhiteside William E · Talmage, CABuilt 1961 · S/N TD-478N946BDBeede Curtis M Trustee · Maineville, OHBuilt 2019 · S/N 1589N946BVAnton Bill · Satanta, KSBuilt 2022 · S/N 3735N946CCBrown C C · Laramie, WYS/N RV6A22289N946CHCritchfield Flying Service LLC · Rupert, IDBuilt 1977 · S/N 17269021N946CVLightcap Michael Wayne · Mc Alpin, FLBuilt 2000 · S/N 22004N946DPDp Mirage LLC · Brentwood, TNBuilt 1999 · S/N 46-36240N946GSStage George A · Kirtland, OHBuilt 2010 · S/N 2070-LN946PMMorgensen John D · Prescott Valley, AZBuilt 2013 · S/N 91269N946PTBrillo Benjamin G · Union City, CABuilt 2002 · S/N 5739N946SMEntrekin David C · Ridgeland, MSBuilt 1982 · S/N 17275870N946TEStrange Bird LLC · Hackensack, NJBuilt 2003 · S/N 10225N9470DJacko Josh E · Anchorage, AKBuilt 1959 · S/N 18-7016N9470WRegistration Pending · Cortez, CORegistration pendingBuilt 1968 · S/N 28-11196N94714Wright Aero Inc · Saint Cloud, MNBuilt 1983 · S/N 15285771N9471CHitpas Henry R II · Beaufort, SCBuilt 1978 · S/N 28R-7837200N9471DRasmuson Travis R · Helena, MTBuilt 1959 · S/N 18-7018N9471PFly Yawa Aviation LLC · Statesboro, GAS/N 24-4982N9471VJ S Alguire Consulting Forestry Services Inc · Dover, DEBuilt 1970 · S/N 700060N9471WMidway Enterprises Inc · Wilmington, DES/N 28-11198N9472FJunell Sonny Brian · Midlothian, TXBuilt 1988 · S/N 18280201N9472HMulder Terry A · Appleton, WIBuilt 1976 · S/N 17266171N9472JMarquette County Flying Club · Marquette, MIBuilt 1966 · S/N 28-3587N9472WSelvaraj Mylappan · Butler, PABuilt 1968 · S/N 28-11199N9473DZweifel Douglas L · Anchorage, AKBuilt 1959 · S/N 18-7019N9473JEncounter Inc · Piedmont, OKBuilt 1966 · S/N 28-3588N9473PSterling Commanche LLC · Kimberton, PAS/N 24-4985N9473VBarcus Roger L · Saint Paul, MNBuilt 1970 · S/N 700039N9473WRohrer Stephen B · Decatur, GABuilt 1969 · S/N 28-11202N9473ZGoldstein Jeffrey Edward · Dix Hills, NYBuilt 1998 · S/N 18280165N9474BDiehl Greg · Angola, INBuilt 1981 · S/N 172RG0833N9474JGerber Dennis J · Liverpool, NYBuilt 1966 · S/N 28-3589N9474NA-G-E Corp · Fort Pierre, SDS/N 28R-35191
Back to AD 87-10-06 R1