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.

N6477JSweat Jeremy A · Morrill, KSS/N 28-4904N6477TPhillips Christopher R · Peoria, AZBuilt 1986 · S/N R18202036N6477WWashington Samuel L · Cleveland, MSBuilt 1965 · S/N 28-20551N64786Magee Wayland G · Bennington, NEBuilt 1961 · S/N 17557075N6478DBrezovich Ivan A · Birmingham, ALBuilt 1979 · S/N 17272826N6478JPart Guy LLC · Berlin, NJS/N 28-4905N6478QGlasgow Christopher S · Morgans Point, TXBuilt 1967 · S/N 680020N6478WLamar Edward Blake Jr · Rch Palos Vrd, CABuilt 1964 · S/N 28-20552N64791Tfa Aircraft Holding Corp · Daytona Beach, FLBuilt 1982 · S/N 17275624N64792Air Sal Leasing Inc · Fort Myers, FLS/N 17275625N6479JBabula Ronald Lee Jr · Drums, PABuilt 1968 · S/N 28-4906N6479QRegistration Pending · Myrtle Beach, SCRegistration pendingS/N 680021N6479RGromada Kristian Paul · Eagle River, AKBuilt 1966 · S/N 28-21669N6479WManagement Ranch LLC · Sheridan, WYBuilt 1964 · S/N 28-20553N647BMaxiao Aviation Corp · Milpitas, CABuilt 1979 · S/N 32-7940040N647CABilli The Flying Cat LLC · Atlanta, GABuilt 1978 · S/N 28-7890312N647CPUnicorn Aviation Inc · Canton, CTBuilt 2005 · S/N 27-0332N647FLRegistration Pending · Fruitland Park, FLRegistration pendingBuilt 1971 · S/N 28-7125555N647FTFlorida Institute Of Technology · Melbourne, FLBuilt 2013 · S/N 2843707N647JCReinke Paul A · Elkhart, IABuilt 2008 · S/N 90564N647JRAlexander Robert · Middleton, IDBuilt 1989 · S/N 1809020N647MHanbo Aviation Inc · Wilmington, DEBuilt 2013 · S/N 60474N647MAHot Wings Aviation LLC · Fishers, INBuilt 2026 · S/N 28020267N647MTArbo Elijah B · Mount Chase, MEBuilt 1970 · S/N 17259158N647RSSkorupa Ralph J · Salem, WIBuilt 1997 · S/N RS-01N647SPElizabeth City State University · Elizabeth City, NCBuilt 1998 · S/N 172S8054N6480DFlyright Aviation LLC · North Las Vegas, NVBuilt 1979 · S/N 17272828N6480JBeaver Douglas G · Harleysville, PABuilt 1968 · S/N 28-4908N6480PCmc Aero LLC · Broken Arrow, OKS/N 24-1597N6480QTadlock Stephen S · Midland, TXBuilt 1967 · S/N 680022N6480YTechnical Education Services Inc · Virginia Beach, VABuilt 1967 · S/N 27-3776N64814Propel Air LLC · Pottstown, PABuilt 1982 · S/N 17275630N64815Channel Islands Aviation Inc · Camarillo, CABuilt 1982 · S/N 17275631N6481JCape Flight Instruction Inc · Cotuit, MABuilt 1980 · S/N 17273876N6482JSmart Avionics Inc · Marietta, PABuilt 1968 · S/N 28-4910N6482PCorson County Feeders Inc · Mc Laughlin, SDBuilt 1959 · S/N 24-1600N6482QStevenson Randall J · Wildwood, MOBuilt 1967 · S/N 680024N64834Golden Mahalo LLC · Sheridan, WYBuilt 1982 · S/N 17275632N6483JCimarron Flying Lc · Elkhart, KSS/N 28-4912N6483PLee Charles C · New Buffalo, MIBuilt 1959 · S/N 24-1601N6483UFalk Edward A · Seattle, WAS/N 2230N6483ZSpokane Soaring Society · Spokane, WABuilt 1962 · S/N 25-2002N6484JMathis Flight Solutions LLC · Dubberly, LABuilt 1968 · S/N 28-4913N64859Leyva Maria · New Smyrna Beach, FLBuilt 1982 · S/N 17275636N6485JYankee Flyers LLC · Berryville, VABuilt 1968 · S/N 28-4914N6485QWaller Drew · Bellville, TXBuilt 1967 · S/N 680027N6485WShades Daniel L · Tumwater, WABuilt 1965 · S/N 28-20560N6485YMeluskey Michael · Christiansted, VIBuilt 1967 · S/N 27-3782N64866Universal Aviators Academy Inc · El Monte, CABuilt 1982 · S/N 17275639N6486C86 Charlie Corp · Roscoe, ILBuilt 1978 · S/N 32R-7885029
Back to AD 87-10-06 R1