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.

N584HPN305yv LLC · Doral, FLBuilt 1983 · S/N TH-1365N584JTGoff James T · Sunriver, ORBuilt 1980 · S/N TH-1127N584MBCenterline Holdings Inc · Camden, DES/N TK-151N584METwo Spinny Things LLC · Overland Park, KSBuilt 1974 · S/N TH-427N584MJC5 Aviation LLC · Harrison, ARBuilt 1987 · S/N TH-1512N584MWRela Matthew V · Monroe, NJBuilt 1991 · S/N TH-1615N584RCrooked Creek Enterprises LLC · Nacogdoches, TXBuilt 1985 · S/N TH-1464N584SMRegistered aircraftBuilt 1973 · S/N TH-412N584TBSundancer Enterprises LLC · Norman, OKBuilt 1997 · S/N TH-1810N584WKing Air Ny LLC · Schenectady, NYBuilt 1993 · S/N TH-1699N5858PMatherne David M · Houma, LAS/N TJ446N585CKKalitta Charters LLC · Ypsilanti, MIBuilt 1981 · S/N TH-1299N585KGWhitgo LLC · Lucas, TXS/N E-3413N585MJCostanzo Aviation Inc · Bethany Beach, DEBuilt 1977 · S/N E-1195N585RJMr Aeronautics LLC · Clarksville, TNBuilt 1985 · S/N TH-1479N586CKKalitta Charters LLC · Ypsilanti, MIS/N TH-1084N587ANCalifornia In Nice Inc DBA · San Jose, CAS/N TH1530N587CKKalitta Charters LLC · Ypsilanti, MIBuilt 1980 · S/N TH-1189N587PDTurbulence Inc · Wilmington, DEBuilt 1990 · S/N CE-1461N587RKRegistration Pending · Santa Rosa, CARegistration pendingBuilt 1976 · S/N CE-665N588ANCalifornia In Nice Inc DBA · San Jose, CAS/N TH-1843N588CKKalitta Charters LLC · Ypsilanti, MIBuilt 1978 · S/N TH-965N588PAirstar LLC · Lees Summit, MOBuilt 1994 · S/N TH-1725N588PCAustin Aviation LLC · Santa Ana, CABuilt 1999 · S/N E-3271N588TBac LLC · Aliceville, ALBuilt 1977 · S/N TH-791N589CSpringville Flying Club · Spanish Fork, UTBuilt 1988 · S/N CE-1224N589PUniversity Of Central Missouri · Warrensburg, MOBuilt 1989 · S/N TH-1559N589RBDukas Air LLC · Fort Lauderdale, FLBuilt 1977 · S/N TJ-89N589YDennis Aviation LLC · Bartlett, TNBuilt 1977 · S/N TH-852N58ARAnnis Aviation LLC · Gray, GABuilt 1987 · S/N TH-1525N58BESouth Georgia Air LLC · Valdosta, GAS/N TH-2055N58BNMinus 7 Inc · Boulder, COBuilt 1979 · S/N TK-99N58BPN7ss LLC · Nashville, TNBuilt 1978 · S/N TJ-176N58BSJordan Corporation · Jackson, MIS/N TH-1142N58BYFry Shawn Trustee · Baxter, TNBuilt 1970 · S/N TH-25N58CHChase Brandon C · Plains, KSBuilt 1978 · S/N TH-949N58CKMajestic Fleet LLC · Miami, FLBuilt 1974 · S/N TH-567N58DAUniversity Of Central Missouri · Warrensburg, MOBuilt 1984 · S/N TH1402N58DCDream Air LLC · Jonesboro, ARBuilt 1981 · S/N TH-1206N58DFB727 LLC · Midland, TXBuilt 1984 · S/N TJ-453N58DLHam John T · Murfreesboro, TNBuilt 1975 · S/N TH-692N58ELN1107u LLC · Lewisville, NCBuilt 1979 · S/N TH-1003N58EVLittle Tree Aeromotive LLC · Banner Elk, NCBuilt 1976 · S/N TH-704N58GELje Air LLC · Park Ridge, ILBuilt 1985 · S/N TH-1480N58GFCollier Air LLC · Fernandina Beach, FLBuilt 2004 · S/N TH-2095N58GKMvm LLC · Lewes, DEBuilt 1976 · S/N TH-763N58GWAlpha Whiskey LLC · Easton, PAS/N TH-2048N58HCMedina Sky LLC · Medina, OHBuilt 1975 · S/N TH-637N58HDRoberts John E · Naples, FLBuilt 1979 · S/N TJ-230N58HESoaring Ventures LLC · La Quinta, CABuilt 1977 · S/N TK-59
Back to AD 87-18-06 R1