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.

N554WFs II Inc · Minden, NVS/N E3554N5551VRegistered aircraftBuilt 1991 · S/N E-2637N5552XJjs Aero LLC · Middletown, DES/N E-2521N5554XDellechiaie Anthony J · Mahwah, NJBuilt 1990 · S/N CE-1457N5558PValiair Lc Trustee · Casper, WYS/N TJ-399N555CSGibson Air LLC · Park Hills, MOS/N TJ-385N555DBSira Arashpal Singh · Lakewood, CABuilt 1978 · S/N CE-803N555HCWikle Leon · Rapid City, SDBuilt 1979 · S/N E-1586N555LFMadden Todd A · Houston, TXBuilt 1979 · S/N D-10270N555LTHogan Daniel · Salina, KSBuilt 1975 · S/N E-737N555MGHampshire Blue Skies LLC · Bedford, NHBuilt 1987 · S/N E-2391N555PDSw Plains Aviation LLC · Ford, KSBuilt 1980 · S/N EA-61N555PZLada Aviation LLC · Alpine, UTBuilt 1975 · S/N D-9782N555RAMooseknuckle Aviation LLC · Haslet, TXBuilt 1975 · S/N TE-1066N555TGDodson International Parts Inc · Rantoul, KSBuilt 1975 · S/N TE-1034N555TXBoujo Yoni · Valley Village, CABuilt 1976 · S/N D-9890N555VRm A36 LLC · Jacksonville, FLBuilt 1978 · S/N E-1221N555WCWilliams Grant A · Port Orange, FLBuilt 1976 · S/N CE-671N555WTHigh Speed Low Drag Aviation LLC · Hamilton, MTS/N CE-1536N555YDYoder Philip G Trustee · Dublin, OHBuilt 1977 · S/N E-1048N5561UAllen Calvin L · Mico, TXBuilt 1990 · S/N CE-1436N5562ZGordon Reed T · Troup, TXBuilt 1990 · S/N CE1467N5565DDirect Flight Inc · Vineyard Haven, MABuilt 1989 · S/N TH-1552N5565XHenry Michael Todd Trustee · Manhattan Beach, CABuilt 1990 · S/N CE-1485N55674Frog Air LLC · Amarillo, TXBuilt 1990 · S/N E-2542N5569NReverie Aviation LLC · Burbank, CABuilt 1990 · S/N E-2529N5571CHarrison Steven D · Rolla, MOBuilt 1989 · S/N CE-1347N5571DReuland Robert C · West Windsor, VTBuilt 1989 · S/N CE-1405N5579MTbc Capital Management LLC · Phoenix, AZS/N CE-1394N557CEBce Aviation Llp · Lexington, KYBuilt 1977 · S/N TH-864N557SASouthard Dennis W Trustee · Tulsa, OKBuilt 2002 · S/N E-3457N5581TChristenson Timothy M · Scituate, MABuilt 1989 · S/N CE-1350N5582XAlpe Holding LLC · Van Nuys, CABuilt 1989 · S/N CE-1353N5585KMacias Aviation LLC · Canadian, TXBuilt 1989 · S/N CE-1385N5585YBlacklock Beech Boys LLC · Langlois, ORS/N CE-1389N558PSouth Electrical Inc · Laurinburg, NCBuilt 1982 · S/N TJ-421N558RSAyelet Aviation LLC · Mackinac Island, MIBuilt 1977 · S/N TK-67N558RT558rt LLC · Rocky Mount, NCBuilt 1993 · S/N TH-1691N558THScannelli Jeff · Southampton, NYBuilt 2001 · S/N TH-2000N558WHRex Aero LLC · Wilmington, DEBuilt 1982 · S/N TH-1356N5591ABig Dog I LLC · Wallace, MIBuilt 1989 · S/N TH-1566N5591VCortese Michael C · South Chatham, MABuilt 1989 · S/N E-2501N5593CSouth Coast Aviation LLC · San Diego, CAFirst renewal noticeBuilt 1989 · S/N E-2493N5594CNovember Inc · Murfreesboro, TNBuilt 1991 · S/N E-2685N5598GNorth River Investments Inc · Palmetto, FLBuilt 1990 · S/N EA-503N5599PAd Ventures LLC · Camden, DEBuilt 1989 · S/N CE-1344N55CVCavu LLC · Charleston, WVBuilt 1977 · S/N TE-1114N55EZSummit Aviation Resources LLC · Akron, OHBuilt 1970 · S/N TE-785N55HDNo Bad Days Consulting LLC · Frisco, TXBuilt 1977 · S/N TE-1089N55JBHigh Point Management Co · Graford, TXBuilt 1990 · S/N CE-1493
Back to AD 87-18-06 R1