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.

N731JPParker Aviation LLC · West Chicago, ILS/N TH-2064N731MLRomine George · Sahuarita, AZS/N D-10208N731PCapital Dental Management · Medford, ORBuilt 2001 · S/N TH-1997N731WCCross Wayne Trustee · Novato, CABuilt 2001 · S/N E-3404N732P626cf LLC · Lynchburg, VABuilt 1999 · S/N TH-1929N7339RDoell Tom C · Dallas, TXBuilt 1974 · S/N E-563N733ACHock Frederick · Waynesboro, VABuilt 1974 · S/N CE-499N7346RSeagull Flying Club Inc · San Jose, CABuilt 1974 · S/N E-569N7347RN145ta LLC · Carson City, NVBuilt 1974 · S/N TH-482N7349RGettier Albert F Jr · Henderson, NVBuilt 1974 · S/N CE-507N7355CGeneva Laes Aviation LLC · Lake Geneva, WIBuilt 1973 · S/N TE-925N7357RWalter Charles T Jr · Ocala, FLBuilt 1974 · S/N E-571N7358BHinkle Aviation LLC · Moro, ARS/N TH-373N735PTwo J Aviation LLC · Lima, OHBuilt 1978 · S/N TH-981N735VThomas Stephen · Granbury, TXBuilt 1979 · S/N D-10262N7366RAndes David A · Fairborn, OHBuilt 1974 · S/N CE-514N7367RMockingbird Aviation LLC · Wilmington, NCBuilt 1974 · S/N D-9638N7368RCruiseair Aviation Inc · Ramona, CABuilt 1974 · S/N CE-510N7369RDuman Ralph J · Cedarville, MIBuilt 1974 · S/N D-9650N7378RLarson Aviation LLC · Waukegan, ILBuilt 1974 · S/N CE-516N7379RSunny Skies Inc · Columbus, GABuilt 1974 · S/N TH-512N737ELCsi Flight Services LLC · Mcminnville, ORS/N EA-127N737PM & E Horizons LLC · Slatington, PABuilt 1994 · S/N E-2908N7385RCw Aircraft LLC · Atlanta, GABuilt 1976 · S/N TH-734N7388RPeitz Russell W · Sebring, FLBuilt 1974 · S/N E565N738TFester John P · Sullivan, MOS/N TH-706N7391REdm Corporation · Nevada, MOBuilt 1974 · S/N D-9651N7392RJohnson Franklin H · Tyler, TXBuilt 1974 · S/N E-579N7396RBaja Aviation LLC · Northbrook, ILBuilt 1974 · S/N E-580N7397RWest Michael P · Colusa, CABuilt 1974 · S/N D-9654N73CAShelor Investments LLC · Christiansburg, VAS/N TH-1889N73DEHill Christopher Michael · Linden, TXBuilt 1976 · S/N D-9909N73HW73 Hotel Whiskey Llp · West Fargo, NDBuilt 1979 · S/N TJ-223N73JWKiang Justin · Simi Valley, CABuilt 1974 · S/N TE-982N73MVPlantation Air LLC · Spartanburg, SCS/N E-3583N73RHBradley A Eli Dental Corp · Encinitas, CABuilt 1973 · S/N D-9487N73SMBrown Michael · Gardnerville, NVS/N E-2961N73VBVb Aviation LLC · Mount Pleasant, SCBuilt 1973 · S/N D-9534N741ESSmith Edward B · Slidell, LABuilt 1981 · S/N E-1915N741LFValley Aviation Inc · Lake Lillian, MNBuilt 1979 · S/N E-1529N741RVInternational Fun Place Hangar 32 LLC · Laughlin, NVBuilt 1987 · S/N CE-1198N742NEPotkulski Daniel M · Locust Grove, GABuilt 1978 · S/N TK82N743TIsr Aviation LLC · Lewes, DEBuilt 1976 · S/N E-802N7444Tytex LLC · Dallas, TXS/N E1520N744PZHemmingway Gray Inc · Los Gatos, CABuilt 1981 · S/N TJ-382N744TIverson Walter P · Nancy, KYBuilt 1977 · S/N TE-1096N745TStoneman Thomas K · Friendswood, TXBuilt 1973 · S/N TE-900N746DMBirds Birds LLC · Bradenton, FLS/N TH-354N7476PMobley Aviation LLC · The Colony, TXBuilt 1976 · S/N CE-631N747BPRose James M · White Hall, ARBuilt 1973 · S/N D-9440
Back to AD 87-18-06 R1