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.

N76KSSchroepfer Ken J · Pecatonica, ILBuilt 2007 · S/N 70229N76LCHacienda Hills Skyhawk LLC · Laveen, AZBuilt 1977 · S/N 17268925N76LMPavlovich Martin · Menomonee Falls, WIS/N 22604N76LYYonge Laurie W Jr · Oklawaha, FLBuilt 1964 · S/N 302N76MBHolt Helicopter Inc · Uvalde, TXBuilt 2006 · S/N 1661N76MLDunn Courtland E Jr · West Grove, PABuilt 1974 · S/N 446-74N76MMRichardson John H · Monticello, NMBuilt 1957 · S/N 18-6031N76NATri Flying Tigers Inc · Wilmington, DEBuilt 1960 · S/N 23-1909N76NCDonald K Ashley · Bradenton, FLBuilt 1976 · S/N M-1787N76NKNaples Jet Management LLC · Naples, FLS/N ME-334N76NNSale Reported · Middletown, OHSale reported, canceledBuilt 1979 · S/N ME-158N76NPCollins Shannan S · Justin, TXS/N SA-300-726N76PFRodriguez Amable Omar · Hialeah, FLBuilt 1982 · S/N 28-8216151N76PPGround Effect Aviation LLC · Ogden, UTBuilt 2007 · S/N 494-2007N76PQBoyd Benjamin L · Kila, MTBuilt 1976 · S/N 18-7609130N76PTMcmurtrey Michael · Farmington, MNBuilt 1974 · S/N MC228N76RMMj Aero LLC · College Station, TXBuilt 2011 · S/N 001N76RSCocke James A · Clarendon, TXBuilt 1976 · S/N 683-HN76RVVandevort Lynn A · Manitowoc, WIBuilt 1999 · S/N 23420N76RWThomas Allen C · Willow, AKBuilt 1953 · S/N 18-1886N76SBAdams Simmie A · Bealeton, VABuilt 1975 · S/N M-1776N76SHConrad Edgar · Mc Alpin, FLBuilt 1995 · S/N 22886N76SLLarsh Steven S · Libby, MTBuilt 2004 · S/N 1001N76SRTangipahoa Mosquito Abatement District # 1 · Hammond, LABuilt 1972 · S/N 27-7304976N76SSNorth Texas Aeronautics LLC · Burleson, TXS/N 17263711N76SWHendricks Blair · Charleston, SCBuilt 1980 · S/N 28-8011123N76TAAhlhorn Travis W · New Braunfels, TXS/N 17276025N76TCCox Thomas R · Kirkland, WABuilt 2001 · S/N 80500N76TDWillmott Wilson R · Huntington Station, NYBuilt 1979 · S/N 32R-8013027N76TJBais Tim · Escondido, CABuilt 1994 · S/N 21675N76TRSwaney Mark J · Oxnard, CABuilt 2015 · S/N 031N76TXBrenner Kurt · Saint Ann, MOBuilt 1976 · S/N 28-7625102N76VAHartzell Propeller Emp Flg Club · Piqua, OHBuilt 1976 · S/N M-1786N76VMSwartz Aviation Group LLC · Argyle, TXBuilt 2010 · S/N 82155N76WLBuckel Joseph T · Ellison Bay, WIBuilt 1976 · S/N VAC-57-76N76WNCorben David Meyer · Lafayette, INBuilt 1978 · S/N 433HN76WPHowes Robert P · Belleview, FLFirst renewal noticeS/N AA5A-0090N76WWOakley James H · Spring Valley, CABuilt 1976 · S/N 18-7609114N76YHose Jerry A II · Oregon, ILBuilt 1985 · S/N 71N76YBJames Marvin L · Scio, ORBuilt 1976 · S/N 8056N76YDBeasley Charles A · Spencer, VABuilt 1975 · S/N 199-75N7700ATim Whitfield Aviation Inc · Fairfield, NCBuilt 1998 · S/N 0438N7700JLuke Motley IV · Sherman, TXBuilt 1968 · S/N 32-1067N7700MWood Duck Loop LLC · Mooresville, NCBuilt 1967 · S/N 670118N7700PBarber Chris · Toney, ALBuilt 1961 · S/N 24-2911N7700WGleasman Steven J · Rockton, ILBuilt 1964 · S/N 28-1692N7701AEdb Air Inc · Wilsonville, ORBuilt 2001 · S/N 4496089N7701DChrysler Sheldon A · Pueblo, COFirst renewal noticeS/N 22-5372N7701MHurt Roy DBA · Newark, OHBuilt 1967 · S/N 670119N7701NN5746u LLC · Dover, DEBuilt 1968 · S/N 28-5147
Back to AD 87-10-06 R1