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.

N9294BHall Justin E · York, NEBuilt 1958 · S/N 55094N9294NCmhw LLC · Memphis, TNBuilt 1998 · S/N 3246104N9294PJensen Thomas · Durango, COBuilt 1968 · S/N 24-4793N9294QPlane Training LLC · Rapid City, SDBuilt 1998 · S/N 2843122N9294VMulligan Sean S · Kitty Hawk, NCBuilt 1969 · S/N 690082N9294WBorkowski Brian L · Irwin, IABuilt 1967 · S/N 28-10971N9295DStanford Jay H · Anchorage, AKS/N 18-6602N9295GMcavian LLC · Westworth Village, TXBuilt 1997 · S/N 3257017N9295HMiami Seaplane Tours Inc · Miami, FLBuilt 1975 · S/N 17266075N9295SSteadman John Harold · Santa Clarita, CABuilt 1975 · S/N M-1630N9295VSt Denis Robert G · Lake City, FLBuilt 1969 · S/N 690084N9295WH&H Aircraft LLC · Scottsbluff, NEBuilt 1967 · S/N 28-10972N9296HSmith Richard A · Burnsville, MNBuilt 1975 · S/N 17266076N9296JAlpha Kilo Aviation LLC · Wasilla, AKBuilt 1966 · S/N 28-3386N9296NSunrider Aviation Inc · Irvine, CABuilt 1997 · S/N 3257013N9296PStevens John W · Westlake Village, CABuilt 1968 · S/N 24-4795N9296SShindel Mark · Los Gatos, CABuilt 1975 · S/N MC-334N9296VOswald Paul C · Shohola, PABuilt 1970 · S/N 700049N9297C831 Aviation LLC · Salinas, CABuilt 1978 · S/N 32-7840093N9297EGod'S Country Aviation LLC · Trapper Creek, AKBuilt 1977 · S/N 6203CN9297MBowers Matthew Monroe · Dayton, NVBuilt 1966 · S/N 1230N9297P9797p LLC · San Angelo, TXBuilt 1968 · S/N 24-4796N9297WTorrey Robert E · Pleasant Hill, CABuilt 1967 · S/N 28-10974N9297YHart Linda B · San Antonio, TXBuilt 1977 · S/N AA5B0547N9298DAims Air LLC · Kingsport, TNBuilt 1997 · S/N 3257002N9298JSt Pete Aviation Services LLC · Saint Petersburg, FLBuilt 1997 · S/N 2843107N9298LLangenberg Stewart M · Santa Barbara, CABuilt 1998 · S/N 3246108N9298PBlackhawk Airventures LLC · Wilmington, DEBuilt 1997 · S/N 3246088N9298SQuality Aviation Inc · Atlanta, GABuilt 1975 · S/N M-1629N9298VJones Eric S · Tucson, AZBuilt 1969 · S/N 690067N9298WUniversal Avn Inc · La Cygne, KSBuilt 1967 · S/N 28-10975N9298ZFrederick Ag LLC · Humboldt, KSS/N 17701215N9299BBird Acquisition LLC · Phoenix, AZBuilt 1998 · S/N 2843116N9299JLucas Steven R · Canton, OHBuilt 1966 · S/N 28-3389N9299PFusion Flight Management LLC · Lake Havasu City, AZBuilt 1997 · S/N 4636123N9299SSky King Flying Club Inc · Jackson, OHBuilt 1975 · S/N MC-338N9299XSchoepel Alexandra E Trustee · Templeton, CABuilt 1997 · S/N 3257021N929AArcher Aero LLC · Wilmington, DEBuilt 2015 · S/N 2843803N929BMSuntops Aircraft Holding LLC · Lakeland, FLBuilt 1975 · S/N 17265826N929BYPorter Ronald A · Waco, TXBuilt 1993 · S/N 21217N929CEMeyer Jonathan · Douglas, WYS/N 18-5001N929CMCanyon West LLC · Amarillo, TXBuilt 2016 · S/N 20357N929DFFanning Dale E · Chesapeake, VABuilt 2017 · S/N 92046N929DJA And S Flying Services Inc · Bristol, VABuilt 2004 · S/N 3257344N929DWGreen Bryan D · Brenham, TXBuilt 1958 · S/N 18-6604N929ELPatterson Bryan J · Brooks, GABuilt 1999 · S/N 828-99N929GSRegistered aircraftBuilt 2001 · S/N 5692N929JARegistered aircraftBuilt 2007 · S/N 90688N929JCBurris Wesley Jay II · Richmond, TXBuilt 2011 · S/N 82549N929KKDavies Lincoln J · Oostburg, WIBuilt 2002 · S/N 1195
Back to AD 87-10-06 R1