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.

N713TTAbe Air LLC · Salinas, CABuilt 1975 · S/N D-9806N714BMMurphy Randall · Ruston, LABuilt 2000 · S/N E-3345N714DBIpiranga Inc · Houston, TXBuilt 1996 · S/N EA-585N715BCSkinner Edward Mcgregor · LondonBuilt 1975 · S/N E782N715LTTraveler LLC · Fort Stockton, TXBuilt 1998 · S/N E-3205N7166KKellar John C · Runaway Bay, TXBuilt 1975 · S/N TH649N716DSSheppard Daniel · Cochranville, PAS/N CE-458N716JFAlexander Aviation LLC · Ellisville, MSBuilt 1977 · S/N E-954N716RJHenson Walter L · Quitaque, TXBuilt 1973 · S/N CE-441N717ERThomas James V · Cullman, ALBuilt 1985 · S/N TH-1463N717KHTrevino Alejandro B · Gibsonia, PABuilt 1989 · S/N CE-1308N717MMWalker Brian K Trustee · Novato, CABuilt 1978 · S/N CE-831N718HSWinnlu Aviation LLC · Greenwich, CTS/N E-3462N71GGTrans-Exec Air Service Inc · Van Nuys, CABuilt 1971 · S/N TE-835N71GRRahmeyer Gary W · Lake Ozark, MOBuilt 1976 · S/N TH784N71KWAcuff Joseph · Mooresville, NCBuilt 1977 · S/N E-1144N71LMHirshik Larry E · Center Harbor, NHBuilt 1989 · S/N CE-1424N71YLN825fg Corp Trustee · Wilmington, DES/N D-9468N72006Detmer Darren D · Chappell Hill, TXBuilt 1984 · S/N TJ-460N72007Garvey James T · Dallas, TXS/N E-2170N7200CCaccavale John J · Oakdale, NYBuilt 1983 · S/N E-2122N7200HHefelfinger James F · Port Orange, FLBuilt 1984 · S/N EA-426N7202MG&M Baron Aviation LLC · Bradenton, FLS/N TJ-456N72045Pembroke Flyers LLC · Pembroke, NHBuilt 1984 · S/N CE-1042N7204EOverit Air LLC · Las Vegas, NVBuilt 1984 · S/N TJ-457N7205EAl Force 1 LLC · North Salt Lake, UTBuilt 1984 · S/N TJ-458N7206BSt Andrews Systems LLC · Navarre, FLBuilt 1984 · S/N CE-1043N7206DCrazy Plane LLC · Saint Augustine, FLBuilt 1984 · S/N EA-435N7207KWhitehead John · Cresson, TXBuilt 1984 · S/N E-2186N7207LSparkman Aviation · Odessa, TXBuilt 1984 · S/N EA-438N7207YBig Game Air LLC · Wilmington, DEBuilt 1984 · S/N E-2187N7208MTahoe Aviation LLC · Reno, NVBuilt 1984 · S/N E-2188N7208RBelford Mark C · Sammamish, WABuilt 1974 · S/N D-9699N7208VMeyer Ag Aviation Inc · Whittemore, IABuilt 1984 · S/N TH-1432N7209BFly By Knight Inc · Hammond, LABuilt 1984 · S/N TH-1428N7209EExecutive 21 LLC · Kansas City, MOBuilt 1985 · S/N CE-1046N720TMinter Michael D Jr · Rock Port, MOBuilt 1975 · S/N D-9813N720WCSw Aviation LLC · Wilmington, DEBuilt 1991 · S/N TH 1624N72100Klein John C · Indianapolis, INBuilt 1984 · S/N E-2196N72108Osprey 72108 LLC · Macon, GABuilt 1984 · S/N E-2197N7210CUpupair LLC · Raleigh, NCBuilt 1984 · S/N TH-1431N7210LPescetti Investigation Services LLC · Carmichael, CABuilt 1984 · S/N E-2215N72121I Fly Planes LLC · Tulsa, OKBuilt 1984 · S/N E-2202N72124Fuller Kenneth C · Studio City, CABuilt 1984 · S/N CE-1047N7212URegistered aircraftBuilt 1984 · S/N E-2201N7213MTulip City Air LLC · Pella, IABuilt 1984 · S/N E-2206N7214DWaheguru Holdings LLC · Corvallis, ORS/N E-2210N7215AGayler Granville II E · Rio Verde, AZBuilt 1984 · S/N E-2213N7217HMaine Instrument Flight · Augusta, MEBuilt 1984 · S/N TH-1442N7218HBoston Robert G · Atlanta, GABuilt 1985 · S/N CE-1056
Back to AD 87-18-06 R1