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.

N9623EHinojosa Edward · Georgetown, TXBuilt 1976 · S/N 76-32-166N9623FLeaver Dennis G · Pompton Plains, NJBuilt 1970 · S/N 800031N9623JVirginia Street Partnership · Farmville, VABuilt 1966 · S/N 28-3779N9623MHerb Adam W · Phoenix, AZBuilt 1966 · S/N 670200N9623UBare Michael J · Paola, KSBuilt 1975 · S/N AA5-0823N9623VSchreder Peter T · Joseph, ORS/N 17264403N9623WLiu Kevin R · Alhambra, CABuilt 1967 · S/N 28-22988N9623YTownsend Richard · Sagle, IDBuilt 1991 · S/N 1191N9623ZYellowstone Aviation Inc · Jackson, WYBuilt 1991 · S/N 1188N9624DBuster Wendy K · Forney, TXBuilt 1959 · S/N 22-6536N9624JTideline Aviation LLC · Wilmington, NCBuilt 1966 · S/N 28-3780N9624WJanak Jeffrey J · Corpus Christi, TXBuilt 1967 · S/N 28-23080N9625Mcwilliam Joseph · Longview, WAS/N 173N9625DCentral Products Inc · Gladwin, MIBuilt 1958 · S/N 22-6537N9625MGreen Evan Michael · Midland, TXBuilt 1966 · S/N 670202N9625QMars Aerospace Inc · Bay Shore, NYBuilt 1975 · S/N 17265709N9625SYoung Robert A Jr · Cass, WVBuilt 1966 · S/N 57N9625VFlight Time Builders Inc · Memphis, TNBuilt 1974 · S/N 17264405N9626BAirgo Inc · Centralia, ILBuilt 1981 · S/N 172RG0927N9626CExecutive Flight Training & Services LLC · Sanford, NCBuilt 1978 · S/N 28-7816506N9626HRenfro Jacqueline L · Bethel, AKBuilt 1975 · S/N 17266274N9626JCharles James Blake · Stinnett, TXBuilt 1966 · S/N 28-3782N9626QChambers Matthew A · Tehachapi, CABuilt 1975 · S/N 17265710N9627HSuperbuyer Inc · San Jose, CABuilt 1975 · S/N 17266275N9627JTucker Aviation LLC · Hollister, MOBuilt 1966 · S/N 28-3783N9627PDrake Aerial Enterprises LLC DBA · Genoa, OHBuilt 1976 · S/N 18-7709001N9628HT3 Aerosports LLC · Vian, OKBuilt 1975 · S/N 17266276N9628JMarshall Air LLC · Albuquerque, NMS/N 28-3785N9628KTriple Chin LLC · Bloomington, MNBuilt 1976 · S/N 28-7690266N9628MMeyer Michael A Trustee · Phoenix, AZBuilt 1966 · S/N 670205N96299Djm Aviation LLC · Rhome, TXS/N 17276054N9629CFly Gateway Aviation Institute · New Castle, DEBuilt 1978 · S/N 28-7890430N9629DAnderson Antoinette · Granbury, TXBuilt 1958 · S/N 22-6541N9629JBrown Korey Fetty · Macungie, PABuilt 1966 · S/N 28-3786N9629KN9629k LLC · Provo, UTBuilt 1976 · S/N 28-7690267N9629RThomas Christopher A · Seaford, DEBuilt 1959 · S/N TD-307N9629WRobbins Clyde · Golden, MSBuilt 1967 · S/N 28-23086N962DCCarruth Don V · Fredericksburg, TXBuilt 2013 · S/N 70706N962FMarshall Steven A · Blacksburg, VABuilt 1998 · S/N 3257067N962GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881227N962MCSmiley Rick N · Pasco, WABuilt 2010 · S/N 91244N962MSMt San Antonio College · Walnut, CABuilt 1976 · S/N 28R-7635459N962RSParis Casey · Oak Grove, LABuilt 2017 · S/N 094N962RTTatarchuk Johnie Roy Jr · Orange, TXBuilt 1993 · S/N 92006N962SCRegistration Pending · Texas City, TXRegistration pendingBuilt 1960 · S/N TD-359N962TDBartel Duane M · Ocean Shores, WABuilt 2011 · S/N 951N962TEPayne Mark Howard · Spring, TXBuilt 2004 · S/N 10241N962WFDodson International Parts Inc · Rantoul, KSBuilt 1999 · S/N 4636203N962WGChandler Air Services Inc · Chandler, AZBuilt 2000 · S/N 2843378N9630QKelley Aircraft LLC · Weyers Cave, VABuilt 1975 · S/N 17265714
Back to AD 87-10-06 R1