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.

N84KLSpitfire-173 & Partners LLC · New Bern, NCBuilt 1999 · S/N 3246128N84KTTaylor Kevin G · Mountain Grove, MOBuilt 2011 · S/N 82291N84KYPaul Johnny D Jr · Camden, SCBuilt 1998 · S/N 76-31N84LAMav Air LLC · Rigby, IDBuilt 1980 · S/N 32R-8029102N84LLLiebsch Mark · Reno, NVBuilt 1984 · S/N 995N84LPMinuteman Air Service Inc · Dewitt, ARBuilt 2003 · S/N 25643N84MFPlanelease LLC · Mason City, IABuilt 2003 · S/N 084N84MGSchroeder Mike J · Colby, KSBuilt 2010 · S/N 40854N84MMEllison Phillip G · Castle Hayne, NCBuilt 1984 · S/N MM1-324N84MSEdwards Bruce W · Palmer, AKS/N 621BN84NSale Reported · Eagle Point, ORSale reportedBuilt 1998 · S/N 1N84PSValiair Lc Trustee · Casper, WYBuilt 1983 · S/N 5031N84PTTackabury Jenny Ann · Santa Paula, CABuilt 1985 · S/N 1N84RLStockman Harold O · Elko, NVBuilt 1996 · S/N 84N84RMAugust Aero LLC · Kalispell, MTS/N 115N84RPWellborn Michael Barrett · Broken Arrow, OKBuilt 1998 · S/N 20849N84SAAshley Heating & Air · Wasilla, AKS/N 81576N84SFFifield Scott D · Overgaard, AZBuilt 2008 · S/N 5334N84SKQuinlan John H · Claxton, GABuilt 1989 · S/N SN-554N84SMRideinsky Aviation LLC · Daytona Beach, FLBuilt 1978 · S/N 60 0540-174N84SSHoffman Thomas A- Trustee · Emmett, KSBuilt 1980 · S/N 32R-8013101N84TDBailey Dennis · Kernersville, NCBuilt 1969 · S/N 30-1951N84TKRegistered aircraftBuilt 2007 · S/N 21432N84TXBrooks Nathan · Manhattan, KSBuilt 2000 · S/N 80700N84VCExperimental Flight Test Solutions LLC · Seattle, WABuilt 2008 · S/N 71248N84WAFlying High LLC · Selah, WAS/N T18208425N84WMErickson Lee A Trustee · Fargo, NDBuilt 1994 · S/N 1264N84WPJayanthi Venkata R · Columbus, OHBuilt 1978 · S/N 28-7911035N84WTAndreotti Mark C · Colusa, CABuilt 2004 · S/N 3255021N84ZRomeo Aviation Ltd · East Sparta, OHBuilt 1959 · S/N TD-232N85007Sidell Joel R · Brighton, COBuilt 2010 · S/N 2000N8500DScootair LLC · Alburgh, VTBuilt 1957 · S/N 22-5727N8500UGlobal First Capital Aviation Group LLC · Amarillo, TXS/N 20-0062N8501DStrausser Brian J · Lower Burrell, PABuilt 1957 · S/N 22-5728N8501LSnider Scott E DBA · Turner, MTBuilt 1969 · S/N 25-4915N8502DConrad Dylan · Randolph, WIBuilt 1957 · S/N 22-5729N8502NDickman Edward A · Melba, IDBuilt 1971 · S/N 32-7140052N8502VAngel Aviation Inc · Peoria, AZBuilt 1973 · S/N 34-7350252N8502WWinker Kurt F · Los Lunas, NMBuilt 1963 · S/N 28-10003N8503EB&B Aviation Holdings LLC · Pembroke Pines, FLBuilt 1976 · S/N 28-7690175N8503NKirkland Joseph Talmadge III · Memphis, TNBuilt 1969 · S/N 28-11223N8503YRoberti John O · Barre, VTBuilt 1967 · S/N 30-1662N8504LTexas Soaring Association · Midlothian, TXBuilt 1969 · S/N 25-4919N8505Lunetta Peter Joseph Jr · Niskayuna, NYBuilt 1973 · S/N 69-73N8505DRegistration Pending · Wilmington, DERegistration pendingBuilt 1957 · S/N 22-5732N8505NMahffey Gary L · Parachute, COBuilt 1969 · S/N 28-11247N8505WMcnamara Kevin Jr · East Aurora, NYBuilt 1963 · S/N 28-10006N8505YCli Aerospace LLC · Appleton, WIBuilt 1968 · S/N 30-1665N8506NTiller Aviation LLC · Omaha, NES/N 28-11248N8506WWestenburg Garrett V · Porter, TXBuilt 1963 · S/N 28-10007
Back to AD 87-10-06 R1