OpenAirDocs.org
AD 87-18-06 R1

Registered aircraft · 6,238

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-18-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-18-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.

N8256HGj Flight Group LLC · Newark, DEBuilt 1991 · S/N E-2664N8257HS And G Ventures LLC · Wilmington, DEBuilt 1992 · S/N TH-1650N8259AParisien Robert · Bow, NHS/N EA-529N8259CShepard Christopher N · Westerville, OHS/N CE-1763N8259EAtlanta Human Performance Center Inc · Mableton, GABuilt 1992 · S/N CE-1641N8259LFriendly Air LLC · Tampa, FLBuilt 1992 · S/N CE-1642N825ECPeterson Air LLC · Chisago City, MNBuilt 1999 · S/N E-3272N825EGFlying Eagle LLC · Wilmington, DEBuilt 1976 · S/N CE-668N825JFVendito LLC · Lewes, DEBuilt 1986 · S/N E2329N825VGarmin At Inc · Salem, ORBuilt 1977 · S/N E-963N8261K8th Street Aviation LLC · Urbandale, IABuilt 1992 · S/N E-2690N8261VTds Airpro LLC · Shreveport, LABuilt 1992 · S/N E-2691N8262DMistarz Bruce E · Gainesville, GABuilt 1992 · S/N CE-1645N8263ASullivan Larry R · Tranquillity, CABuilt 1993 · S/N CE-1730N8263VPrecision Service Mtr Inc · Addison, ILBuilt 1990 · S/N EA-504N8265XOzark Management Inc · Columbia, MOBuilt 1993 · S/N E-2804N8268TN8268t LLC · Phoenix, AZBuilt 1990 · S/N CE-1547N8269VN8269v Inc · Lewes, DEBuilt 1993 · S/N E-2796N826MGOrten Symer Enterprises Inc · East Hampton, NYBuilt 1993 · S/N E2782N826MTG T Acft Inc · Franklin Square, NYBuilt 1979 · S/N TK-109N826RSSpence Charles A · Midland, TXBuilt 1971 · S/N D-9272N826TBonanza H35 LLC · Greensboro, NCBuilt 1973 · S/N D-9518N826VMills Aviation Ltd · Wapakoneta, OHBuilt 1977 · S/N D-9950N8272BAndy-Oxy Co Inc · Asheville, NCBuilt 1990 · S/N TH-1601N8275ASigillito Michael A · Vero Beach, FLBuilt 1993 · S/N E-2803N8277DValiair Lc Trustee · Casper, WYS/N E-2798N8278TRegistered aircraftBuilt 1992 · S/N TH-1672N827BYoung James Frederic Sr · Shepherdstown, WVBuilt 1986 · S/N CE-1080N827EBEbor Management Inc · Alpharetta, GABuilt 1970 · S/N TH-135N827TSCurless Harley · Havana, ILBuilt 1977 · S/N TH-836N827VMoore Plane Fun LLC · Toledo, OHS/N E907N8283WSwampair LLC · Hillsboro, ORBuilt 1993 · S/N CE-1739N8284FRullman Laurie J Trustee · Reno, NVBuilt 1993 · S/N CE-1747N8285CBonanza Enterprise LLC · Tucson, AZBuilt 1993 · S/N E-2810N8285LGilbran Properties LLC · Oklahoma City, OKBuilt 1993 · S/N CE-1745N8285MCohen Aviation LLC · Rolla, MOBuilt 1993 · S/N E-2815N8286FDaedalus Advisory LLC · Seattle, WAS/N CE-1767N828DSOhlsson Kenneth S Trustee · Sedona, AZBuilt 1976 · S/N E-847N828KASvehla Gustav Jr · Flower Mound, TXBuilt 1990 · S/N CE-1512N828KMSjr Holdings LLC · Raleigh, NCBuilt 2001 · S/N TH-1999N828SBEa Aircraft Lease LLC · Dayton, MNS/N EA-111N828TFryar Arliss E · Pollock, LABuilt 1976 · S/N E-941N828TTLoud LLC · Carthage, NCBuilt 1994 · S/N TH-1729N828VJames David O · Overland Park, KSBuilt 1976 · S/N E-883N828WTLaymon Air LLC · Redlands, CAS/N E-3581N82903Nms Air Services LLC · Chelmsford, MABuilt 1993 · S/N CE-1740N8290EWb Aviation LLC · Belmont, MIBuilt 1993 · S/N E-2805N8290ULets Fly LLC · Fortson, GABuilt 1993 · S/N TH-1688N8293MMaffett Properties LLC · Dublin, GABuilt 1993 · S/N E-2794N8295YBonanza Flyers LLC · Clovis, CAS/N E-2825
Back to AD 87-18-06 R1