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.

N526PHangar Four LLC · Blue Ridge, GAS/N E-603N527BHRed River Cellular Telephone Corp · Paris, TXBuilt 1980 · S/N TH-1190N527RSLookout Mountain LLC · Mill Valley, CABuilt 1999 · S/N E3222N527TAPlane Leasing LLC · Wilmington, DEBuilt 1973 · S/N TH-290N527TCLeonardo Paul A III · Merced, CABuilt 1991 · S/N EA-527N528EWNc Aviator LLC · Fuquay Varina, NCBuilt 1989 · S/N CE-1375N528PLebanon Air Taxi LLC · Hanover, NHBuilt 2004 · S/N E-3565N529DDSchwertfeger Dean · Woodruff, WIBuilt 1970 · S/N D-9151N529SARaptorsair LLC · Mchenry, ILBuilt 2001 · S/N E-3429N52CEUlmer Ken W · Houston, TXS/N E-3495N52HCOak Bay Aviation LLC · Bellvue, WABuilt 1980 · S/N TJ-274N52KTMontgomery Transit LLC · Fulton, MSS/N E-3391N52LGGroom Lincoln · Wadmalaw Island, SCBuilt 1991 · S/N CE-1627N52SBRedwood Oil Co Inc · Rohnert Park, CABuilt 1978 · S/N E-1274N52TZTurley Dale R · Poway, CABuilt 1988 · S/N CE1297N530CContinental Title Trust LLC Trustee · Wichita, KSBuilt 1976 · S/N D-9927N531ABMissionair Inc · Danbury, CTS/N TJ-454N531BFLouis F Olberding Dds Pc · Lincoln, NEBuilt 1973 · S/N D-9541N531KCConstantine LLC · Fort Collins, COBuilt 1985 · S/N TH-1484N532CHall Brian · Yuma, AZBuilt 2002 · S/N EA-691N532EBlue Pointe Aviation LLC · Valparaiso, INBuilt 1989 · S/N CE-1377N532GMsd Sales Inc · Cedar Rapids, IABuilt 1977 · S/N E-1038N533XRegistered aircraftBuilt 1985 · S/N E-2234N5349B39 Bravo LLC · Wilmington, DEBuilt 1988 · S/N E-2416N535BEValiair Lc Trustee · Casper, WYBuilt 1970 · S/N D-9170N535VBSchellenger Jonathan H · Port Saint Lucie, FLBuilt 1975 · S/N D-9742N536AMTriniair LLC · Warner Robins, GABuilt 1978 · S/N E1172N536BAPlasko Enterprises LLC · Trumbull, CTBuilt 1978 · S/N E-1170N536BCChavers Construction Inc · Cantonment, FLS/N E-2160N536EUSarabay Aviation Partners LLC · Sarasota, FLBuilt 2005 · S/N E-3616N536JSShoffner James P Jr · Denver, COBuilt 1984 · S/N EA-418N536KEngage Helicopters LLC · Sarasota, FLS/N E3220N536PSky High II LLC · Clinton, NCBuilt 1998 · S/N E3197N536TCI C Aviation LLC · Scottsdale, AZBuilt 1988 · S/N EA-481N536WWright Jack · Fortson, GABuilt 2002 · S/N E-3458N536WGAdvantage Aviation Inc · Palo Alto, CABuilt 1990 · S/N CE-1446N537SWBingham Leasing Co Lc · Mesa, AZBuilt 1991 · S/N TH-1619N539REdward Jennings LLC · Valdosta, GABuilt 1985 · S/N E-2296N53BBWing Bird Aviation LLC · Garland, TXBuilt 1972 · S/N TE-866N53LEBonanza With A Cause LLC · Westlake Village, CAS/N E-3488N53RTCas Capital Holdings LLC · Newark, DES/N TH-2113N53WWPlanemarketing LLC · Vero Beach, FLS/N E-3480N541JESimpson Kendal · Port Orange, FLBuilt 1975 · S/N TH-577N543RBBaron Aviation LLC · Calera, ALBuilt 2000 · S/N TH-1953N543RCBarone Nicholas D · Lincoln, RIBuilt 1987 · S/N E-2384N543VWich Robert · Norfolk, VABuilt 1995 · S/N EA-581N544BSAerospace Trust Management LLC Trustee · Wilmington, DES/N EA-246N545GMInternational Air Services Inc Trustee · Carson City, NVBuilt 1972 · S/N D-9318N545LKKernisan Louis Philippe · Doral, FLBuilt 2000 · S/N E-3348N5461Lb Flying Aces LLC · Wilmington, DEBuilt 1991 · S/N E-2621
Back to AD 87-18-06 R1