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.

N793LMJohnson Roger C · Lake Havasu City, AZBuilt 1979 · S/N D-10300N794CBBeckwith Robert E · Torrance, CABuilt 1978 · S/N CE-794N7958DNewcomb Clint M · Benton, ARS/N TH-1019N7958PHall Wendell W · Cheraw, SCBuilt 1976 · S/N CE-655N795ABSilver Mar LLC · Key Biscayne, FLBuilt 1998 · S/N TH-1880N795SBInternational Air Services Inc Trustee · Carson City, NVBuilt 1991 · S/N CE-1599N798GMJust US Pilots Inc · Clearwater, FLBuilt 1998 · S/N E-3184N798JBMidwest Aircraft LLC · Olathe, KSBuilt 2002 · S/N E-3468N79APHigh Tide Aviation LLC · Naples, FLBuilt 1979 · S/N TJ206N79CEBe 58 Corp · Rochester, NYS/N TH-2099N79DRMcneill Steve · Santa Fe, NMBuilt 1994 · S/N EA-559N79DSBonanza Air Ventures LLC · Mammoth Lakes, CABuilt 1982 · S/N EA-326N79HCBmc Group · Hawthorne, CABuilt 1990 · S/N E-2538N79HEMontauk Flying Inc · Montauk, NYBuilt 2004 · S/N E-3542N79MCKruse Air LLC · Sheridan, WYBuilt 1981 · S/N E-1903N79PRHutchinson Andrew J · Gardner, KSBuilt 1970 · S/N D-9138N7BW7bw LLC · Lewes, DEBuilt 1973 · S/N E-395N7BXHoneywell International Inc · Phoenix, AZBuilt 1975 · S/N TE-1020N7BYN7by LLC · Jensen Beach, FLBuilt 1991 · S/N CE-1611N7CJPropart Inc · Austin, TXBuilt 1990 · S/N E-2575N7DHBrown Michael D · Bloomington, INBuilt 1970 · S/N TH-118N7DMNix Terry W · Golden, MSBuilt 1972 · S/N TH-214N7EVYellow Star Mgmt LLC · Waco, TXBuilt 1998 · S/N E-3162N7FHGroh David · Mason, MIBuilt 1977 · S/N E-1142N7JKosco Matthew D · Munster, INBuilt 2000 · S/N E-3316N7JNB & K Steel & Supply Inc · Ogden, UTBuilt 2000 · S/N EA-663N7KTOrtiz Alexander · Walnut Creek, CABuilt 1979 · S/N D-10268N7MWSeven Aces LLC · Chesterfield, NJBuilt 1982 · S/N TH-1353N7NKHall Gregory Lyman · College Station, TXBuilt 1993 · S/N E-2786N7PD426th Aero Squadron LLC · Cropwell, ALBuilt 2000 · S/N TH-1972N7PKBohn Robert D Jr · Midway, GABuilt 1974 · S/N D-9608N7PRRed Aero LLC · Batesville, INBuilt 1974 · S/N E-622N7RQTctj Holdings LLC · Yoakum, TXBuilt 1991 · S/N CE1622N7RZZantop Reese C Trustee · Naples, FLBuilt 1990 · S/N E-2562N7SPTriple Bee Transport LLC · Leon, WVS/N CE-1004N7YYNejad Shahpour M · Gresham, ORFirst renewal noticeBuilt 1986 · S/N E-2333N80000Mccue Mark K · Gualala, CABuilt 1992 · S/N E-2741N8003RBig Sky Bonanza Inc · Wilmington, DEBuilt 1990 · S/N E-2558N8008KKraus Lee G Jr · Port Orange, FLBuilt 1990 · S/N E-2559N800CFSparky'S Air LLC · Wilmington, DEBuilt 1990 · S/N TH-1599N800CXColeman James M · Aiken, SCBuilt 1979 · S/N E-1435N800EEMarks Robin · San Luis Obispo, CABuilt 1979 · S/N D-10288N800JCThomas Bonner Enterprises LLC · Lubbock, TXBuilt 1979 · S/N TK-90N800XCommander 500a LLC · Scottsdale, AZS/N E-2696N801TMajestic Enterprises Ltd · Wilmington, DEBuilt 1973 · S/N TH-330N8021AEncompass Partners · Goodwell, OKBuilt 1990 · S/N CE-1520N8021WNothing Wasted Consulting LLC · Kannapolis, NCBuilt 1992 · S/N E-2700N8026TRdz Aircraft LLC · Effingham, ILBuilt 1992 · S/N E-2701N8028DHammond Mick L · Abilene, TXBuilt 1991 · S/N CE-1550N8028JVintage Aircraft Sales LLC · Radnor, OHBuilt 1990 · S/N CE-1531
Back to AD 87-18-06 R1