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.

N433DNGary Boyce Aircraft Sales LLC · Shelbyville, TNBuilt 1990 · S/N CE-1475N4340WHanger Aviation Inc · Charleston, SCBuilt 1974 · S/N D-9577N4342AR&B Air LLC · Clayton, MOBuilt 1970 · S/N D-9133N4344RCash Doug · Newton, IABuilt 1972 · S/N TE-859N434CCLambo Air LLC · Springtown, TXBuilt 1982 · S/N EA-321N435DGV1 Corp · Fort Lauderdale, FLS/N E-3500N435JMBonanza A36 LLC · Nashville, TNBuilt 1975 · S/N E-762N435MGonzalez Frank · Sun Valley, CABuilt 1992 · S/N E-2726N4362WReaume Andrew G · Wayne, PABuilt 1974 · S/N E-557N4366WPrentice Chris · Independence, ORBuilt 1974 · S/N D-9620N436ATWheels Up LLC · Aloca, TNBuilt 1978 · S/N TH-953N436DGGetting Dean W · Fort Dodge, IABuilt 1978 · S/N E-1213N436EUStevann Farms Ltd · De Witt, IABuilt 2005 · S/N E-3612N436JB700p LLC · Lewes, DEBuilt 1976 · S/N D-9884N436MHaase LLC Series 5 · Henderson, NVBuilt 1990 · S/N EA-512N436RADebon Corp · La Center, WABuilt 1999 · S/N E-3270N4370WHincha Stacie B · Thatcher, AZBuilt 1974 · S/N E-559N4371WRussell Chris J · Cheyenne, WYBuilt 1974 · S/N CE-501N4374MThursby William T · Cedar Hill, TXBuilt 1979 · S/N E-1589N4375WTouch N Go Aeroworks LLC · Greenville, SCS/N TH-489N4376WSmith Ryan · Canby, ORBuilt 1974 · S/N D-9626N4377GD&P Enterprises Inc · Fresno, CABuilt 1985 · S/N TJ-479N437PCantrell William Taylor Jr · Richmond, VAS/N CE-1045N4380WAtaraxia Aircraft Holdings LLC · Greenville, SCBuilt 1974 · S/N TH-448N4384WPacific Media Properties Inc · Santa Ana, CABuilt 1974 · S/N E-536N4388WNiezen Henry J · San Luis Obispo, CABuilt 1974 · S/N D-9600N438GMRye Air LLC · Grimes, IABuilt 2000 · S/N E-3353N438TBluhm Raymond M · Waxhaw, NCBuilt 1971 · S/N D-9256N4393AOgilvie Terry Michael · Loveland, COBuilt 1970 · S/N CE-300N4394WSisson James M · Orlando, FLBuilt 1974 · S/N TH-460N43BBHilyer Bruce W · Camano Island, WABuilt 1990 · S/N CE-1517N43HPBarbara Aviation Inc · Middletown, DEBuilt 1977 · S/N TH-885N43KEInternational Air Services Inc Trustee · Carson City, NVBuilt 1988 · S/N EA-484N43KTTowles Michael D · Corona Del Mar, CABuilt 1993 · S/N E-2808N43LVLight & Variable Lp · Las Vegas, NVS/N E3546N43QCAviation LLC · Kalispell, MTBuilt 1984 · S/N TJ-467N43RQChristman George Myron · Amsterdam, NYBuilt 1977 · S/N CE-716N43YIsbell Edwin Chad · Spring, TXBuilt 1974 · S/N E-576N4405AJohnson Marvin E · Garfield, WABuilt 1970 · S/N D-9141N440BLL R Aviation LLC · Plymouth, NCBuilt 1977 · S/N TH-801N440GVon Pasecky Ronald · Gilbert, AZBuilt 1976 · S/N D-9911N440SUFutrell Kenneth R · New Smyrna Beach, FLBuilt 1977 · S/N E-1115N440TJs Aviation Group LLC · Sedona, AZBuilt 1976 · S/N CE-681N4417WReyling Joseph E · Glasgow, MTBuilt 1974 · S/N E-529N4418ABorchert Pete · Prescott, AZBuilt 1970 · S/N D-9142N4419AMccants Robley D · Mesa, AZS/N D-9147N441WW4kd Corporation · Wilmington, DEBuilt 1975 · S/N CE-606N4427WRockwall LLC · Wye Mills, MDBuilt 1974 · S/N D-9605N4428CPayne Jeffrey C Trustee · Stockton, CABuilt 1980 · S/N EA-59N442RGRivas Andrew · Flagstaff, AZBuilt 1990 · S/N CE-1437
Back to AD 87-18-06 R1