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.

N2138LBrooks John S · Camarillo, CAS/N E-893N21398Peterson Peter M · Silverado, CABuilt 1977 · S/N D-10077N213CHEz Aviation LLC · Morrisville, NCS/N TH-2079N213DRCon-Ag Rentals Inc · Blairsville, GAFirst renewal noticeBuilt 1999 · S/N E-3247N2141LErwin James Erskine III · Newnan, GABuilt 1976 · S/N E-896N2143JTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1998 · S/N TH-1855N2144LPrivate Paws LLC · Colorado Springs, COBuilt 1976 · S/N E-895N2146LDm Group LLC · Troutman, NCBuilt 1976 · S/N TH-778N2148LL&M Cleared2land LLC · Coral Gables, FLBuilt 1976 · S/N E-897N2149LRocky Hill Airshows Inc · San Jose, CABuilt 1976 · S/N E-898N214CHFlycarolina LLC · Concord, NCBuilt 1980 · S/N TH-1160N214KPBnb Aviation LLC · Chesterfield, MOBuilt 1999 · S/N TH-1894N214RJJones Larry V · Ocala, FLBuilt 1999 · S/N E3263N214RSFlying Kw Co · Millsap, TXBuilt 1977 · S/N E-957N2150LB-58 Inc · Albany, GAS/N TH-781N2153ROrton Sterling · Cedar City, UTS/N EA-540N2155NFlight Test Affiliates LLC · Flagler Beach, FLBuilt 1981 · S/N EA-255N2159LMark A Smith Airplane Sales Inc · Homosassa, FLBuilt 1976 · S/N E-902N215CHKld Air LLC · Charlotte, NCBuilt 1977 · S/N TE-1116N215NCDodson International Parts Inc · Rantoul, KSBuilt 2002 · S/N E-3444N215PDube William E Jr · Prescott, AZBuilt 1992 · S/N CE-1676N215RWUnderwood Darin M · Cedar Rapids, IABuilt 1995 · S/N E-2965N2163LS & S Southern Group Inc · Port Orange, FLS/N E-903N2168LRobbins Aviation LLC · Genoa, NYFirst renewal noticeBuilt 1976 · S/N E-905N216RHannah Ambra · Tucker, GABuilt 1978 · S/N E1341N2173LPritchard Timothy L · Fargo, NDBuilt 1976 · S/N CE-666N217ARRgv Sky LLC · Harlingen, TXBuilt 2001 · S/N E-3421N217LJFessenden Hart W · Port Orange, FLBuilt 2000 · S/N E-3334N217PDanford Air Inc · Wilmington, DEBuilt 1979 · S/N CE-839N217PCClearwater Consultants Inc · Starkville, MSBuilt 2000 · S/N E-3330N217SCJtfs LLC · Huntsville, ALBuilt 1999 · S/N E-3221N2183LDarfus Jason D · Tracy, CABuilt 1976 · S/N E-969N218CGCourtney Melissa · San Diego, CABuilt 1980 · S/N E-1741N2190LSedine Aaron J · Cedar Springs, MIBuilt 1976 · S/N E-909N21914Autumn Air LLC · Prescott, AZBuilt 1977 · S/N D-10078N2199LCardamone-Rayner Mark · Manistique, MIBuilt 1976 · S/N E-968N219CHSteel Eagle Aviation LLC · Birmingham, ALBuilt 2001 · S/N TH-1990N219DKRegistered aircraftBuilt 1980 · S/N E-1599N219GMStewart Michael A · Washington, DCBuilt 1988 · S/N TH-1536N219RPMorrow Dennis J · Houston, TXBuilt 1976 · S/N E-885N21BCAmelse Troy · Chippewa Falls, WIBuilt 1980 · S/N EA-65N21DAW Squared Holdings LLC · Edmond, OKBuilt 1978 · S/N TH-980N21ETDepucchio Mark V · Plainville, CTBuilt 1976 · S/N E-889N21JPDmmag LLC · Windermere, FLBuilt 1977 · S/N TE-1092N21KKLife'S A Beech LLC · Gulf Breeze, FLBuilt 1979 · S/N E-1563N21LPLp Aviation Inc · Wilmington, DEBuilt 1977 · S/N TH-848N21MFOsgood Air LLC · Hays, KSBuilt 1998 · S/N TH-1871N21NPRossi Michael · Ronan, MTBuilt 1978 · S/N TK-77N21VRJb Aviation LLC · Baton Rouge, LABuilt 1989 · S/N E-2468N21WPAir Dryden LLC · Dothan, ALBuilt 1972 · S/N E-336
Back to AD 87-18-06 R1