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.

N616SFAmelia Reid Aviation LLC · San Jose, CABuilt 1980 · S/N 172RG0740N616SKSuperior Flying Services LLC · Superior, WIBuilt 1979 · S/N 17273381N616SRBarendregt Melvin E · Heyburn, IDS/N 24-1800N616TBChristofferson Kevin J · Fruita, COBuilt 2006 · S/N 20983N616TKScano James · Gunter, TXBuilt 2018 · S/N 73509N616VTNamendorf Michael · New Hyde Park, NYBuilt 1979 · S/N 28-7916500N616WDHalama Patrick J · Whitehall, WIBuilt 2006 · S/N 90669N61700Torres Ramon L · Mulberry, FLS/N 17264741N61701Jls Aviation LLC DBA · Fredericksburg, VABuilt 1975 · S/N 17264742N61703Beising Steven · Las Vegas, NVBuilt 1975 · S/N 17264744N61704Glick Mervin L · Stanardsville, VABuilt 1975 · S/N 17264745N61707Spartan National Holdings LLC · Missoula, MTBuilt 1975 · S/N 17264747N61709Caldwell Clifton · Sterling City, TXBuilt 1975 · S/N 17264748N6170JSeeler John A · Bristol, NHBuilt 1976 · S/N 28R-7635316N6170MRothe Zachary W · Riverside, CABuilt 1978 · S/N 7179CN6170PMaurer Bruce C · Power, MTBuilt 1959 · S/N 24-1271N6170SNice Flight LLC · Medford, ORBuilt 1980 · S/N R18201637N6170YGe Org Advanced Systems LLC · Newton, NJBuilt 1966 · S/N 27-3391N61710Bob Hoover Academy Inc · Salinas, CABuilt 1975 · S/N 17264749N61713Miller Melanie L · Spanaway, WABuilt 1975 · S/N 17264750N61718Ortman Bernard R · Bozeman, MTBuilt 1975 · S/N 17264753N6171HTyler Cherokee 235 LLC · Lindale, TXBuilt 1977 · S/N 32R-7880047N61727Mays Gloria J · College Station, TXBuilt 1975 · S/N 17264755N6172DBlue Spruce Aviation LLC · Fairview Park, OHBuilt 1979 · S/N 17272617N61733Pan Air Flying Club Inc · Miami, FLBuilt 1975 · S/N 17264760N61737Executive Flight Institute LLC · Murrieta, CABuilt 1975 · S/N 17264763N61738Finn Development LLC · Kaysville, UTBuilt 1975 · S/N 17264764N61739Southern Aero LLC · Homestead, FLS/N 17264765N6173DArs Logistics LLC · Hackettstown, NJBuilt 1957 · S/N 22-4820N6173JMinor Michael W · Summerland Key, FLS/N 32R-7680324N6173PSwenson James A · Lake Point, UTBuilt 1959 · S/N 24-1274N6173QKinder Mark Edward · Bozeman, MTBuilt 2004 · S/N 18281388N6173WDiaz Jose O · Ramey, PRBuilt 1964 · S/N 28-20190N61743Carruth John T · Danvers, MNBuilt 1975 · S/N 17264768N61748Zapata Raymond E · Cabo Rojo, PRBuilt 1975 · S/N 17264772N6174DOtoole Makena · Cordova, AKBuilt 1957 · S/N 22-4821N6174JAloms Enterprises LLC · Marietta, GABuilt 1976 · S/N 32R-7680325N6174PAbernathy Larry D · Vernon, TXBuilt 1959 · S/N 24-1275N6174RLaurel Highlands Aeronautical Academy · Latrobe, PAS/N 172RG0103N61752Lee Robert Eric · Charleston, WVBuilt 1975 · S/N 17264774N61755K E F Enterprises · Plymouth, MABuilt 1975 · S/N 17264777N61759Watkins Joe C · Albany, GABuilt 1975 · S/N 17264780N6175GKimber 123 Holdings LLC · Morgantown, WVBuilt 1979 · S/N 17273574N6175TNewell John D · Cleveland, TXBuilt 1994 · S/N RV-4-2722N6175ZSpot-Air LLC · Burlington, TXBuilt 1959 · S/N 25-208N61760Little Duane V · Puyallup, WABuilt 1975 · S/N 17264781N61761Hawk Aviation Inc · Rush City, MNBuilt 1975 · S/N 17264782N61763Bortoto Da Silva Alexandre · Fort Lauderdale, FLBuilt 1975 · S/N 17264784N61764Wohlgemuth Terry D · Squaw Valley, CABuilt 1994 · S/N 1N61765Dean Mark T · Van Alstyne, TXBuilt 1975 · S/N 17264785
Back to AD 87-10-06 R1