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.

N300KKrakeel James A · Mount Pleasant, SCBuilt 1977 · S/N TE-1103N300RSLane Tyrone · El Dorado Hills, CABuilt 1977 · S/N CE-689N300RTChoux Aviation LLC · Cypress, CABuilt 1983 · S/N E-2074N300SAWhalen Sean B · Naples, FLS/N CE-545N300THPacific Flight Academy LLC · Honolulu, HIBuilt 1972 · S/N TH-266N300TTDg Aero LLC · Little Rock, ARBuilt 1980 · S/N CE-906N3012HBonanza Two USA Inc Trustee · Wilmington, DEBuilt 1987 · S/N CE-1109N3014WRunyan Joseph D · Bushnell, ILBuilt 1973 · S/N TE-933N3017WKirk Michael E · Alvin, TXBuilt 1973 · S/N D9520N301CTVatm Sky Investments LLC · Thomson, GABuilt 1980 · S/N TH-1166N301JFGrace Eric C · Valdosta, GABuilt 1979 · S/N E-1593N301PRussell Bill W · Victoria, TXBuilt 1978 · S/N TH-890N3021WElliott Robert · Hartington, NES/N E-459N3023WBoughen James R · Camas, WABuilt 1973 · S/N D-9517N3024HMll Air LLC · Kalispell, MTBuilt 1994 · S/N E-2863N3024QJones Sean D · Adams, TNBuilt 1987 · S/N CE-1110N30282Saucerman Equipment Leasing LLC · Indianapolis, INFirst renewal noticeBuilt 1987 · S/N E-2357N3028WK2 Aviation LLC · Carroll, IABuilt 1973 · S/N E-465N302BCG2 Leasing LLC · Cedar Spring, MIBuilt 1982 · S/N E-1982N302WDivine John S III DBA · Myrtle Beach, SCS/N E-302N3030DBoardwalk Management LLC · Kalispell, MTBuilt 1999 · S/N E-3230N3030SBrewer Mike · Cameron Park, CABuilt 1978 · S/N E-1280N3031QBrut N3031q · Los Angeles, CAFirst renewal noticeBuilt 1998 · S/N E-3196N3032LBlue Sky Air Ventures LLC · Wilmington, DEBuilt 1999 · S/N EA-632N3032WDebrouwer Isabelle Mc · Alpine, TXBuilt 1973 · S/N D-9525N3033BPalms Edward M · Greenwood Village, COBuilt 1998 · S/N TH-1869N3034CTyler Bonnie Flying LLC · Tyler, TXBuilt 1986 · S/N E-2341N3035WWorldwide Air & Sea Inc · Wilton, NHBuilt 1999 · S/N EA-635N303HVRegistered aircraftBuilt 1994 · S/N E-2864N303KCCurry Kenneth R · Cookeville, TNS/N CE-1138N303NMiles James · Memphis, TNBuilt 1981 · S/N E-1880N303SASoder Christopher R · Hewitt, TXBuilt 1971 · S/N E-303N303TTCoop Aero LLC · New Albany, MSBuilt 2001 · S/N E-3377N3041CVangundy Timothy S · Camby, INBuilt 1976 · S/N D9946N3041KDodson International Parts Inc · Rantoul, KSFirst renewal noticeBuilt 1987 · S/N CE-1112N3042NRunway Aircraft LLC · Sugar Land, TXBuilt 1987 · S/N CE-1113N3042V3 Pandas LLC · Farmington, NMBuilt 1998 · S/N EA-622N3044W625 Mike Tango LLC · Dickinson, TXBuilt 1973 · S/N TH-344N3045TRegistered aircraftBuilt 1987 · S/N E-2369N3045YMassee Donald R · Riverside, CAS/N EA-623N3046DAldredge John F · Cornville, AZBuilt 1994 · S/N E-2866N3046KBas Part Sales LLC · Greeley, COBuilt 1987 · S/N E-2362N3048VBoswell Craig A · Hernando, MSBuilt 1987 · S/N E-2363N3048WEarthbound Aviation Group LLC · Wilmington, DEBuilt 1973 · S/N E-484N3049APresidential Aviation LLC · Bakersfield, CABuilt 1987 · S/N CE-1117N3049DAnchor Equipment Leasing LLC · Covington, KYBuilt 1998 · S/N TH-1873N3050KWalter Jones III Md Inc · Redlands, CABuilt 1987 · S/N E-2364N3052JParker Joe B · Uvalde, TXBuilt 1986 · S/N E-2346N3052XJc Flight Inc · Wilmington, DES/N CE-1120N3053WVictor Echo LLC · Knoxville, TNBuilt 1994 · S/N CE-1783
Back to AD 87-18-06 R1