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.

N908PScott Kevin · Santa Fe, NMBuilt 2000 · S/N EA-664N908VSeven M Enterprises LLC · Kalispell, MTBuilt 1974 · S/N D9645N9093QInvesta Aviation LLC · Yoakum, TXBuilt 1971 · S/N E-296N9094QAhrens Nathan · Groveland, CABuilt 1970 · S/N TH-107N9094SZompa Edward A Md Phd · Galveston, TXBuilt 1978 · S/N D-10152N9095QApt Jerome III · Pittsburgh, PABuilt 1970 · S/N D-9221N9096SRes-Air LLC · Clarksville, TNBuilt 1978 · S/N D-10153N9098QBuckeye Baron LLC · Sunbury, OHBuilt 1970 · S/N TH-109N9099SRegistration Pending · Davis, CARegistration pendingBuilt 1976 · S/N E-814N909ATGo Consultants LLC · Wilmington, DES/N E-2647N909CMFlightpath LLC · Montgomery, NYS/N TH-2022N909MDEmber Brett D · Cottondale, ALBuilt 1970 · S/N D-9210N909VBBedalou Aviation LLC · Joplin, MOBuilt 1997 · S/N E-3133N90EBJet Set Aircraft Inc · Van Nuys, CABuilt 1976 · S/N TH-793N90HFNovak Todd · Lumberton, NJBuilt 1990 · S/N CE-1495N90TMJ&W Aviation LLC · Taylor, NEBuilt 1976 · S/N D-9839N9102QLarosa Christopher · Tampa, FLBuilt 1970 · S/N D-9227N9102SHeartland Properties III Inc · Danville, ILS/N D-9972N9105SDominguez Cesar Trustee · Yuma, AZBuilt 1976 · S/N CE-630N9107QRitter Disposables Inc · Marion, ARBuilt 1971 · S/N E-241N9109SThomas Timber Inc · Harrells, NCBuilt 1976 · S/N E-816N910SAPersistent Roots LLC · Carpentersville, ILBuilt 1999 · S/N TH-1910N910WWLundell Plastics Corp · Odebolt, IABuilt 2004 · S/N TH-2092N9110QZen Air LLC · Kalispell, MTS/N D-9219N9111QDreifort David A · Brentwood, CABuilt 1970 · S/N CE-330N9112QSkyward Mn LLC · Hutchinson, MNBuilt 1971 · S/N D-9223N9113SBonanza Flyers Of Kansas LLC · Stilwell, KSBuilt 1976 · S/N D-9857N9118QBonanza Life LLC · Urbana, ILS/N D-9225N911GSAir-Ric LLC · Mobile, ALBuilt 1981 · S/N E-1785N911JKRegistered aircraftBuilt 1976 · S/N D-9925N911WTFernandez Daniel · Boca Raton, FLBuilt 1986 · S/N E-2298N9121QBehm Darren Wayne · Frisco, TXBuilt 1970 · S/N D-9228N9126QSks Aviation LLC · Sherman, TXBuilt 1971 · S/N D-9226N9127QDopfel Bruce E · Belle Plaine, KSBuilt 1971 · S/N E-245N9128QRegistered aircraftBuilt 1970 · S/N E-247N912HFMcs Aviation LLC · Sylvania, OHBuilt 1990 · S/N CE-1540N912LFFarmer Thomas E Jr · Galveston, TXBuilt 1974 · S/N D-9617N912MH James & Sons Inc · Fennimore, WIBuilt 2001 · S/N E-3379N912SCCrest Five Associates Inc · Breinigsville, PABuilt 1991 · S/N TH-1646N9133SWebster Eric M · Two Rivers, WIS/N CE-647N9134SDaytona Aircraft Services Inc · Daytona Beach, FLS/N TH-726N9135SChelette Garry · Chicago, ILBuilt 1976 · S/N D-9874N9136QBeech 9136q Charter Aircraft LLC · Chico, CABuilt 1970 · S/N E-248N9136SProctor Racing Group LLC · Glendora, CABuilt 1976 · S/N E-844N9137QSam Tyson Builders Inc · Monroe, NCFirst renewal noticeBuilt 1970 · S/N D-9233N9137SCiontea James C · Santa Barbara, CABuilt 1976 · S/N E-820N9138SRegistered aircraftBuilt 1976 · S/N D-9860N9139QBollings Avionics LLC · Bristol, TNBuilt 1970 · S/N E-249N913DSHaulin Ash Productions Inc · Franklin, TNS/N E-3523N913KMBlack Edward C · Orange, CABuilt 1979 · S/N CE-892
Back to AD 87-18-06 R1