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.

N74219Cmcs Aviation LLC · Atlantic Beach, FLBuilt 1975 · S/N AA5B-0165N7421GLibby Matthew P · Castle Hill, MEBuilt 1970 · S/N 17259121N7421JBaker Ronald A · Belgrade, MTBuilt 1968 · S/N 28R-30764N7421VYacuzzi Gerald A · Quinque, VABuilt 1975 · S/N 20-1155N7421WMiller James Robert · Gainesville, GABuilt 1963 · S/N 28-1309N7421YHinkle Anthony Gray · Mineola, TXBuilt 1964 · S/N 30-486N74225Campbell Thomas J III · Good Hope, GABuilt 1975 · S/N AA5B-0166N7422DEvans Clyde Joseph · Muscatine, IABuilt 1957 · S/N 22-5183N7422GLafayette Escadrille Flying Club · Rock Spring, GABuilt 1970 · S/N 17259122N7422RCastillo Alex R · West Covina, CABuilt 1966 · S/N 28-21948N7422VPanto Anthony · Jackson, NJS/N 20-1156N7422ZFarm Air Inc · Astoria, ILBuilt 1965 · S/N 25-3399N74237Carino Jane Liu · Buckley, WABuilt 1975 · S/N AA5B-0169N7423PVarner David C · Atascadero, CABuilt 1961 · S/N 24-2611N7424Stansbury Tracy E · The Dalles, ORBuilt 2006 · S/N 14119CN74243Marion Tiger LLC · Marion, INBuilt 1975 · S/N AA5B-0172N7424DBradley Bane L · Lyndonville, NYBuilt 1957 · S/N 22-5185N7424PHutcheson Raymond E · Lawrence, INBuilt 1961 · S/N 24-2612N7424RAscend Aviation LLC · Bountiful, UTBuilt 1966 · S/N 28-21952N7424VMorgan James P · Arlington Heights, ILBuilt 1975 · S/N 21-1164N74257Norton John B · Colorado Springs, COBuilt 1946 · S/N 1370N7425GSmoke Eagles Inc · Downey, CABuilt 1970 · S/N 17259125N7425PRiffle Christopher B · Altus, OKBuilt 1961 · S/N 24-2613N7425SSweeney Sean M · Reunion, FLBuilt 1969 · S/N 61-0010N74261Cunningham Glenn C · Manvel, TXBuilt 1975 · S/N AA5B-0176N74262Mckay William J · Maitland, FLBuilt 1975 · S/N AA5B-0177N7426GProvoncha Tina · Oak Harbor, WABuilt 1970 · S/N 17259126N7426LWright Air Service Inc · Fairbanks, AKBuilt 1972 · S/N 31-812N7426PNehus Christopher J · Camarillo, CABuilt 1961 · S/N 24-2614N7426SDanick Mechanical Inc · Nicolaus, CABuilt 1981 · S/N R18201711N7426WGreen William · Mancelona, MIBuilt 1963 · S/N 28-1314N7426ZKeystone Aviation LLC · Anchorage, AKBuilt 1965 · S/N 18-8308N74270R & D Bennett LLC · San Jose, CABuilt 1975 · S/N AA5B-0178N74275Dail Alan Scot · Virginia Beach, VABuilt 1975 · S/N AA5B-0181N74276Steinke Matthew R · Gibson, IABuilt 1975 · S/N AA5B-0184N7427GWilliams Jason R · Cordova, TNBuilt 1970 · S/N 17259127N7427RVasconcelos Kathleen Marie · Woodsville, NHBuilt 1966 · S/N 28-21956N7427VCrowe Aaron C · Hickory, NCBuilt 1975 · S/N 21-1167N7427WWingswat LLC · Placentia, CABuilt 1963 · S/N 28-1315N74282Santana Joseph W · Waynesboro, VABuilt 1946 · S/N 1395N7428RKnaust William C · Gig Harbor, WABuilt 1966 · S/N 28-21958N74292Patel Kalpesh · Chevy Chase, MDBuilt 1975 · S/N AA5B-0187N74298Ariel Aircraft Corp · Wilmington, DEBuilt 1975 · S/N AA5B-0189N7429DTomporowski Robert C · Piesco, NYBuilt 1957 · S/N 22-5192N7429GDiditair Inc · Knoxville, TNBuilt 1970 · S/N 17259129N7429PSwett Frank M · Zebulon, NCBuilt 1961 · S/N 24-2617N7429SStarport Logistics LLC · Kathleen, GABuilt 2006 · S/N 70902N7429VMordica John E Jr · Hawk Point, MOBuilt 1975 · S/N 21-1169N7429WJ A Piper LLC · Bancroft, IDBuilt 1963 · S/N 28-1317N7429YDewitt Troy C · Lake Elmo, MNBuilt 1964 · S/N 30-489
Back to AD 87-10-06 R1