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.

N174URocky Mountain Ventures Inc · Cheyenne, WYBuilt 1970 · S/N TH-73N17505Trout Christopher S · Albuquerque, NMBuilt 1977 · S/N D-9966N17509Starke Charles H III · Weirsdale, FLBuilt 1976 · S/N E-972N1750WYounger Benjamin · Narrowsburg, NYBuilt 1972 · S/N D-9406N17516Gillis Alan · Richmond, TXBuilt 1977 · S/N D-9978N17520Patterson William · Spring, TXBuilt 1976 · S/N E-974N17522M & A Business Propertys LLC · Wilmington, DEBuilt 1977 · S/N CE-690N1752WMichael S Austin Dmd Ms Psc · Utica, KYBuilt 1972 · S/N E-373N1753WConservative Three LLC · Taft, CABuilt 1972 · S/N CE-410N1755WAis Construction Equip Corp · Grand Rapids, MIBuilt 1972 · S/N E-374N17561Demott Andrew Dolphus III · Hernando, FLBuilt 1977 · S/N D-9983N17568Chance Research Corp · Mineral Wells, TXBuilt 1977 · S/N D-9984N1756WIverson Bradley · Grinnell, IABuilt 1972 · S/N D-9409N17571De Oliveira Derek · Meadow Vista, CABuilt 1977 · S/N E-983N17577James Rodney D · Bono, ARBuilt 1977 · S/N TE-1091N1758WJanneck Curtis · Mooresville, INBuilt 1972 · S/N CE-411N175LKern Charter Service Inc · Bakersfield, CABuilt 1977 · S/N E-985N175TPadgett Don K · Albuquerque, NMBuilt 1971 · S/N D-9259N17604Montgomery Aviation Corp · Montgomery, ALBuilt 1977 · S/N TE-1094N17607Juren Nicholas J · Los Osos, CABuilt 1977 · S/N CE-695N17618Kloptenstein Kevin S · Parker, AZBuilt 1977 · S/N CE-696N17621Boe Mark · Morgan, UTBuilt 1977 · S/N E-992N17628Elliot Air LLC · Dunwoody, GABuilt 1977 · S/N E-993N17629Haven Av LLC · New Braunfels, TXBuilt 1977 · S/N D-9991N1762WWillis Frederick A · Scottsdale, AZS/N D-9410N17632Hunt Elizabeth H · Clifton, TXBuilt 1977 · S/N CE-697N17636Rocha Heriberto · Houston, TXBuilt 1977 · S/N CE-698N17639Peterson Eric S · San Jose, CABuilt 1977 · S/N E-997N1763W63 Whiskey LLC · Seattle, WABuilt 1973 · S/N E-406N17650Pynes Anthony P · Round Rock, TXBuilt 1977 · S/N D-9993N17653Coggin Randall · Longview, TXBuilt 1977 · S/N E-998N17656Liddell Patrick A · Columbia Falls, MTBuilt 1977 · S/N D-9995N17660Simpson Chad · Harrison, ARBuilt 1977 · S/N TH-810N17668Broadway Travis A · Alexandria, LABuilt 1977 · S/N E-1001N17669Srg Enterprises LLC · Montgomery, ALBuilt 1977 · S/N E-1002N17692Starnes Robert D · Suwanee, GAS/N CE-700N17698Spindel Stuart H · Hawesville, KYBuilt 1977 · S/N E-1005N176DRKelly Daniel · Alpharetta, GAS/N E-3592N176LFFour Basics LLC · Olathe, KSBuilt 1977 · S/N E-1052N176STCp A36 Inc · Knoxville, TNBuilt 1976 · S/N E-884N176VBGraystoke Aviation LLC · Shepherd, MTBuilt 1976 · S/N D-9926N176WHarwell Evin Dtrustee · Howell, MIBuilt 1978 · S/N E-1335N176XClub Turbo 176 LLC · Santa Clara, CABuilt 1976 · S/N E868N17702Bosley Blake R · Richmond, TXBuilt 1977 · S/N CE-701N17703Dakota Aviation LLC · Sioux Falls, SDBuilt 1977 · S/N E-1007N17704Hall Thomas N · Dothan, ALBuilt 1977 · S/N E-1008N17718Katzakian Philip O · Lodi, CABuilt 1977 · S/N D-9998N1772WRichland Flight Academy LLC · Sidney, MTBuilt 1972 · S/N E-377N17732Wright Brian L · Franklin, TNBuilt 1977 · S/N TE-1102N17735Stoppelbein Colby · Kenansville, NCBuilt 1977 · S/N CE-703
Back to AD 87-18-06 R1