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.

N938BDB And M Aircraft Inc · Wilmington, DES/N E-3436N9393QD5167 LLC · Kalispell, MTBuilt 1970 · S/N CE-304N93APGill Paul E · Port Saint Lucie, FLBuilt 1980 · S/N EA-96N93MTJ2 Sky LLC · Encinitas, CABuilt 1972 · S/N E-335N93VTLidner Mark H · Sun City, AZBuilt 1970 · S/N D-9155N9400QPrealow Scottie T · Lubbock, TXBuilt 1970 · S/N D-9163N9403QBlue Sky Baron LLC · Highlands Ranch, COBuilt 1970 · S/N TH-54N940RLaw Offices Of Ray S Jones Psc · Pikeville, KYBuilt 1973 · S/N TE896N940ZBMcbee Harvey Edward III · College Station, TXBuilt 1978 · S/N E-1210N9411QWhite Tavis · Huntsville, ALBuilt 1970 · S/N TH-66N9415QMichael D Scott · Los Gatos, CABuilt 1972 · S/N CE-362N9418QBonanza Partners LLC · Taos Ski Valley, NMBuilt 1972 · S/N E-307N9429QBuck Hollow Investments LLC · Austin, TXBuilt 1972 · S/N TH-200N942CPV1 Holdings LLC · Morgan Hill, CABuilt 1977 · S/N TK-61N942VEndeavor Enterprises LLC · Alta Loma, CAS/N E-715N9430QHoyt Stuart T · Raleigh, NCBuilt 1972 · S/N D-9316N9431QN9431q LLC · Round Rock, TXBuilt 1972 · S/N CE-365N9432QKnh LLC · Bozeman, MTBuilt 1972 · S/N E-310N9440QKatz Alan E · Hopkinton, MABuilt 1972 · S/N D-9319N9446QGalt Gulch LLC · Ann Arbor, MIBuilt 1972 · S/N TH-236N944LFAir Northeast LLC · Colorado Springs, COBuilt 1995 · S/N E-2968N944PACrebbs Ben H · Tucson, AZBuilt 1982 · S/N EA-300N9461QRose Kim N · East Wenatchee, WABuilt 1972 · S/N D-9322N9462QR & B Corp · Pittstown, NJBuilt 1972 · S/N E-313N9463QCcf Ventures Inc · Bangor, MEBuilt 1972 · S/N D-9324N9465QMaydew Aircraft LLC · Dallas, TXBuilt 1972 · S/N D-9325N9466QLan Dale Co · Reno, NVBuilt 1972 · S/N TH-205N9467QAg Aero Inc · Tallulah, LABuilt 1972 · S/N TH-206N9468QSunrise Aviation Inc · Wrangell, AKBuilt 1972 · S/N E-314N946TTTalley Tank Lines Inc · Madera, CABuilt 1992 · S/N TH-1673N9470QCullison James B Trustee · Canby, ORBuilt 1972 · S/N D-9327N9473QStephens Milton D · Birmingham, ALBuilt 1972 · S/N E-315N947TTobler Patrick M · Wake Forest, NCBuilt 1971 · S/N D-9270N9480QCrockett Richard S · St George, UTBuilt 1972 · S/N CE-370N9481QSterengin Pllc · Cottonwood, AZS/N CE-371N9482QSoberg Bryant W · Hartford, SDS/N E-318N9483QSouthwest Investment Co · Little Rock, ARS/N D-9331N9487QLebarron David · Winnsboro, TXBuilt 1972 · S/N D-9333N9488EV2 Destinations LLC · Cullman, ALBuilt 2000 · S/N E-3367N9491QMcclung Aerial Spraying Inc · Big Springs, NEBuilt 1972 · S/N E-321N9499QE J K LLC · Brawley, CABuilt 1972 · S/N E-323N949BGGabriel Kevin E · Galveston, TXBuilt 1979 · S/N E-1494N94EMSkyclub A36 LLC · Alpharetta, GABuilt 1982 · S/N E-2011N94JKWestwind Aviation Inc · Plantation, FLS/N E-2149N94JVSlikker Benn W · Marana, AZBuilt 1991 · S/N E-2625N94KMBurton Aviation LLC · Burlington, NCBuilt 1997 · S/N TH-1816N94MQBreshan Enterprises LLC · Chicago, ILBuilt 1975 · S/N TE-1060N94PBBaron 94pb LLC · Tuscaloosa, ALBuilt 1979 · S/N TJ-245N94TJHuber Robert T · West Chester, PABuilt 2002 · S/N TH2029N94WWZephyr Homes LLC · Sebring, FLBuilt 1981 · S/N E-1817
Back to AD 87-18-06 R1