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.

N8131NArgus Lester M · Margate City, NJBuilt 1991 · S/N CE-1584N8132NBeechit LLC · Prescott, AZBuilt 1991 · S/N CE-1585N8133RAero Tex LLC · Jacksonville, FLBuilt 1974 · S/N CE-543N8133VN8133v LLC · Greenville, NCBuilt 1991 · S/N CE-1569N8134RFolsom Airplane Co LLC · Longwood, FLBuilt 1974 · S/N CE-524N8135NAlbion Air Enterprises LLC · Albion, NEBuilt 1991 · S/N E-2642N8135RKeyt Richard C · Granbury, TXBuilt 1974 · S/N D-9696N8136ERunyon Rodney D · Portland, TNBuilt 1991 · S/N E-2614N8136RDreamstead Recreational Vehicles LLC · Kalispell, MTBuilt 1974 · S/N E-612N8137PFlying Daze · Batavia, OHBuilt 1991 · S/N E-2653N8137RWestdale Aviation LLC · Shreveport, LABuilt 1974 · S/N D-9660N8138RDavenport Clifford M · Bonita, CABuilt 1974 · S/N E-587N8139RStiller David L · Sedona, AZBuilt 1974 · S/N CE-522N813CHBlech Andreas J · Grants Pass, ORBuilt 1973 · S/N D-9536N813MMRc Air Ventures LLC · New York, NYBuilt 2000 · S/N E-3342N813PJBank Of Utah Trustee · Salt Lake City, UTS/N E-3485N8140NViolette James · Glendale, AZBuilt 1992 · S/N CE-1713N8141YTrifunac Alexander D Trustee · Boulder, COBuilt 1991 · S/N CE-1592N8142NSmith Dennis A Trustee · Salem, ORBuilt 1993 · S/N E-2768N8142WByrne Real Estate Group LLC · Charlotte, NCBuilt 1993 · S/N CE-1729N8143JFly Girl Aviation LLC · Little Rock, ARBuilt 1991 · S/N CE-1595N814JGKrahulik Jon L · Fredericksburg, TXBuilt 1991 · S/N E-2622N814LAAkamo Abiodun T · Line Lexington, PABuilt 1994 · S/N E-2849N814TDWesley Roy W · Carmichael, CABuilt 1977 · S/N E-1085N8151REnterprise Aviation Holdings LLC · Wilmington, DEBuilt 1974 · S/N TH-510N8152CBonanza52c LLC · Eastsound, WABuilt 1993 · S/N E-2773N8152RElbow Key LLC · Blue Bell, PABuilt 1993 · S/N E-2778N8153GValenzuela Aviation LLC · Little Rock, ARBuilt 1990 · S/N E-2583N8154QShine Hugh D · Temple, TXBuilt 1990 · S/N E-2584N8158RFullerton Vtail Partners LLC · Mission Viejo, CABuilt 1974 · S/N D-9665N8159RWiencke John K · San Francisco, CABuilt 1974 · S/N CE-527N815JTL G T LLC · Bronwood, GABuilt 1976 · S/N CE-688N815LAGarrettgobo LLC · Saint Augustine, FLBuilt 1994 · S/N E-2850N815RSCurtis Carter LLC · Prior Lake, MNS/N E-3573N8162DWc&R LLC · Austin, TXBuilt 1991 · S/N E-2589N8163FCalugar Ronald C · Bunnell, FLBuilt 1991 · S/N E-2590N81640Miller Ralph G Trustee · Napa, CABuilt 1991 · S/N CE-1591N8165EWw Air LLC · Templeton, CABuilt 1998 · S/N E-3193N8165QStewart Robert Page · Monroe, NCS/N E-2592N8166GRohrer John D · Belmont, CABuilt 1993 · S/N EA-546N8166RJmac Aviation Services LLC · Andalusia, ALBuilt 1974 · S/N D-9666N8166WScope Leasing Inc · Columbus, OHBuilt 1991 · S/N E-2593N8167AMagic Aviation LLC · Joplin, MOBuilt 1991 · S/N E-2594N8167KHues Oulton A · Norwood, MABuilt 1993 · S/N EA-547N8168FSnyder Jeffrey L · Clarkston, MIBuilt 1991 · S/N E-2596N8169RPreister Properties LLC · Norfolk, NEBuilt 1974 · S/N D-9668N816LATipuani Corp · Dover, DEBuilt 1994 · S/N E-2851N816UMcmullen Gerald W Trustee · Spokane, WABuilt 1970 · S/N D-9161N816VBrawler Aviation LLC · Edmond, OKBuilt 1971 · S/N D-9266N8170DWagner Dairy Lp · Escalon, CAS/N E-2600
Back to AD 87-18-06 R1