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.

N158TCBoyd Brent · Fort Worth, TXBuilt 1978 · S/N TK-68N158WCKing Air Properties LLC · Huntington Beach, CABuilt 2001 · S/N TH-2008N1591WMuraszko Raymond P · Monroe, NJBuilt 1972 · S/N CE-381N1592LLwcr Transportation Inc · Minot, NDBuilt 1976 · S/N E-832N1592WDebonair Flying Club Inc · Medon, TNBuilt 1972 · S/N CE-383N1593LBurr Walter E · Tecumseh, MIBuilt 1976 · S/N CE-637N1594LIntermill Alice R · Volga, SDBuilt 1976 · S/N E-833N1595LClemens Jerry W · Parsons, KSBuilt 1976 · S/N D-9869N1597LTougas John D · Huntingtown, MDS/N CE-638N1597WSmith William J · Wichita Falls, TXBuilt 1972 · S/N D-9359N1598TRegistered aircraftBuilt 1981 · S/N EA-263N1598WCanvasback Investments LLC · Kerrville, TXBuilt 1972 · S/N D-9356N159AARegistered aircraftBuilt 1975 · S/N E-765N159GMArmy Air Corps LLC · Wilmington, DEBuilt 1978 · S/N CE-765N159SMMcneill Transportation LLC · Whiteville, NCS/N TH-2085N159ZIdaho State University · Pocatello, IDBuilt 1978 · S/N TJ-178N15DNSnowflake Aircraft LLC · Fayetteville, NYBuilt 1989 · S/N E-2472N15GMBristol Aviation De LLC · Wilmington, DEBuilt 1995 · S/N E2977N15JAAdams Harry Jay · New Waverly, TXBuilt 1979 · S/N TK95N15JUC&D Aviation LLC · Appleton, WIBuilt 1982 · S/N TJ-434N15PMDodson International Parts Inc · Rantoul, KSBuilt 1977 · S/N E-1016N15RDWood Richard W Trustee · Oroville, CABuilt 1978 · S/N E-1407N15RPKnob Creek Aviation LLC · Oak Ridge, LABuilt 1974 · S/N E-539N15VMGagne Jay A · Dyersburg, TNBuilt 1976 · S/N D-9936N15XLrb Aviation LLC · Catawba, NCBuilt 1979 · S/N TJ-226N15XAMenigoz Michael Steven · Puyallup, WABuilt 1975 · S/N E-732N1601WSix Ten Ventures LLC · Grand Prairie, TXBuilt 1972 · S/N D-9360N1604MMckinney John Merrill Jr · Bessemer, ALBuilt 1983 · S/N TH1359N1604WSteve Byrd Aviation LLC · Terrell, TXBuilt 1972 · S/N TH-242N160SPAerospace Trust Management LLC Trustee · Wilmington, DES/N D-9615N1619WExecutive Aircraft Management LLC · Northport, ALBuilt 1972 · S/N TE-869N161ABSafford Aviation Service Inc · Coolidge, AZBuilt 1977 · S/N TJ-122N161KCCk Aviation LLC · Melbourne, ARBuilt 1980 · S/N E-1700N161TRRambo Timothy B · Nampa, IDBuilt 1991 · S/N CE-1619N161TSDoege Jackson B · Dallas, TXS/N E-3519N1622WN83993 LLC · Cherry Hill, NJExpired dealer, pending cancellationBuilt 1972 · S/N TE-870N1624WHill Travis · Smithville, TXBuilt 1972 · S/N CE-384N1625WGunter Professional Pilot Services LLC · Wichita Falls, TXBuilt 1972 · S/N D-9365N1628WT W Air LLC · Worthington, KYS/N D-9366N1629WRegistered aircraftN-number assigned, not yet registeredS/N TH-245N162BLMid South Aviation Inc · New Orleans, LAS/N E-2263N162DFFaford Aviation Leasing Co · Atherton, CABuilt 1982 · S/N TJ-403N1632WCdg Aviation LLC · Cresson, TXBuilt 1972 · S/N D-9363N1634WTaglieri Ronald F · Pass Christian, MSBuilt 1972 · S/N D-9378N1635WTullos Hugh S III · Oklahoma City, OKBuilt 1972 · S/N E-350N163SPAgriflite Services Inc · Wakarusa, INBuilt 1972 · S/N TE-872N1643EYoung Michael T · Flower Mound, TXBuilt 1992 · S/N CE1643N1648WKings Aviation Corp · Garden City, NYBuilt 1972 · S/N TH-251N1650WGriffin Michael D · Madison, ALBuilt 1972 · S/N E-352N165HPKessler William A Jr · Uvalde, TXBuilt 1981 · S/N E-1856
Back to AD 87-18-06 R1