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.

N757MK101 Flight LLC · Waterford, MIBuilt 1974 · S/N 17264629N757MLSchaffer Michael W · New Meadows, IDBuilt 2013 · S/N 556-2013N757PKoerner Lukes Gene · Wisconsin Rapids, WIBuilt 1967 · S/N 24-4604N757PDLeavitt Erin G · Lewiston, IDBuilt 1979 · S/N R18201251N757PUAvs Aviation LLC · Williamsburg, VABuilt 1979 · S/N R18201253N757QTMoxley Equipment Co Inc · Council Grove, KSBuilt 1979 · S/N R18201258N757RBTaa Aviation LLC · Lewes, DEBuilt 2004 · S/N T20608460N757RSRegistered aircraftBuilt 1978 · S/N R18200308N757RVJohnson Scott E · Land O Lakes, FLBuilt 2025 · S/N 75031N757SP4e Aviation LLC · Alpine, UTS/N R18201261N757SQByrne Sarah Boltz · Dallas, TXBuilt 1979 · S/N R18201262N757TMontgomerie Robert A · Oriental, NCBuilt 2006 · S/N 1854LN757TWHildebrand Russell W · Chandler, AZBuilt 2002 · S/N 23911N757UGehret Barry · Sonoma, CABuilt 1965 · S/N 933N757UG2lyons Enterprises LLC · Wellington, FLBuilt 1967 · S/N 32-862N757USPeasley Robert E · Lonsdale, MNBuilt 2019 · S/N 526-2019N757VYRice Timyn J · Saint Petersburg, FLBuilt 1979 · S/N R18201268N757WBReineke John S · Powell, OHBuilt 1979 · S/N R18201269N757WTElectrical Management Services · North Andover, MABuilt 1979 · S/N R18201230N757XRosenberger R Scott · Baltimore, MDBuilt 2003 · S/N 70497N757XDSouth Texas War Birds LLC · Santa Fe, TXBuilt 1979 · S/N R18201272N757XUHighflight Inc · Perkinsville, VTBuilt 1979 · S/N R18201273N757YGDayton Pilots Club Inc · Springboro, OHBuilt 1979 · S/N R18201274N75801Hartland Aviation LLC · New Smyrna Beach, FLBuilt 1976 · S/N 17267960N75803Kuntz Donald Alan · Whitefish, MTBuilt 1976 · S/N 17267962N75805Roney Howard D · Salem, ORBuilt 1976 · S/N 17267964N75806Jones Bros Amc Jeep Inc · Harrison, ARBuilt 1976 · S/N 17267965N75807Pearl River Community College · Poplarville, MSS/N 17267966N75809C & S Flyers LLC · Grand Lake, LABuilt 1976 · S/N 17267967N7580PWiseman Charles D · Orlando, FLS/N 24-2791N7580TBushgoair LLC · Chicago, ILBuilt 1978 · S/N R18200043N7580YMeekin Michael · Sutton, AKBuilt 1965 · S/N 18-8300N75816Lns Aviation LLC · Chandler, AZBuilt 1976 · S/N 17267973N7581CGurr James E · Alden, MIBuilt 1957 · S/N 186N7581GManasco Inc · Tucson, AZBuilt 1970 · S/N 17259281N7581LPruitt Kerry P · Nacogdoches, TXBuilt 1975 · S/N 18-7509079N7581RMiller Galen E · Lewistown, ILS/N 28-22343N7581WSutherland Joel C · Greenbrier, TNBuilt 1964 · S/N 28-1523N7581ZHorton Gregory S · Anchorage, AKBuilt 2016 · S/N PEA-20-1N75820Zoviv Michael · Hollywood, FLBuilt 1976 · S/N 17267977N75822International Air Services Inc Trustee · Carson City, NVBuilt 1976 · S/N 17267979N75823Wings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 17267980N75824Williams John S · Fort Walton Beach, FLBuilt 1976 · S/N 17267981N75825Patrick Ronald D · Locust Grove, GAFirst renewal noticeBuilt 1976 · S/N 17267982N75829Hofmann LLC · Blauvelt, NYBuilt 1976 · S/N 17267985N7582CKnutson Wayne R · Tioga, NDBuilt 1957 · S/N 187N7582GCapps Christopher T · Anchorage, AKBuilt 1970 · S/N 17259282N7582JJohnsen Leif Erik · Alburgh, VTS/N 28R-30932N7582WKoch Scott A · Voorhies, IABuilt 1964 · S/N 28-1524N75831Mccall Freddie W · Century, FLBuilt 1976 · S/N 17267987
Back to AD 87-10-06 R1