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.

N6055JElkhorn Valley Aviation LLC · Fremont, NEBuilt 1979 · S/N TE-1160N6056YDiesel Flying LLC · Wilmington, DEBuilt 1979 · S/N D-10242N6057SRamelow Noyan · Seabrook, TXBuilt 1976 · S/N TJ-45N6058AAlpha Air LLC · Sparks, NVBuilt 1979 · S/N TH-1017N6059SGallardo Jorge Luis Marquez · El Mirage, AZS/N TJ-49N605CCommerce Landing Aviation LLC · Tampa, FLS/N TH-2081N6060ZDesert Aero LLC · Hobbs, NMBuilt 1984 · S/N E-2155N6064SYasechko James Edward · Bonaire, GABuilt 1975 · S/N D-9819N6065SEdwards Aviation LLC · Fresno, CABuilt 1975 · S/N CE-613N6067SCanterbury Ventures LLC · Litchfield Park, AZBuilt 1975 · S/N CE-614N6067TSullivan Patrick V · Chicago, ILBuilt 2002 · S/N E-3467N6069SNelson Ronald E · Richmond, TXBuilt 1975 · S/N D-9821N606BCBell Camp Inc · Lubbock, TXFirst renewal noticeBuilt 1980 · S/N EA-72N606REPebblebrook Aviation LLC · Ellinwood, KSBuilt 1982 · S/N TJ-430N606TWhitney Richard E Jr · Warrenton, VABuilt 1977 · S/N E-1155N6070SEdward C Kole · Lake Geneva, WIBuilt 1975 · S/N D-9822N6072SMiller Walter Timothy · Henderson, NVBuilt 1975 · S/N D-9823N6073SLocke Mary · Sherman, TXBuilt 1975 · S/N E-776N6074SWatson Glenn M · Round Rock, TXBuilt 1975 · S/N E-778N6075SJohnson Jamie D · Leonard, TXBuilt 1975 · S/N E-780N6077SMcdaniel Leigh W · Orland, CABuilt 1977 · S/N E-962N6078SWhisero Aero Inc · Tullahoma, TNBuilt 1975 · S/N TH-625N607GSGaines Robert G · Howell, MIBuilt 1982 · S/N TK-147N6081STearse David S · Swisher, IABuilt 1975 · S/N TE-1069N6087SVega Peter · Thrall, TXBuilt 1975 · S/N E-784N6089SVincent Shawn P · Hinsdale, ILFirst renewal noticeBuilt 1975 · S/N CE-617N608EBPinnacle Roof Solutions LLC · New Baden, ILBuilt 1979 · S/N E-1512N6091SAir Transport Inc · Liberal, KSBuilt 1975 · S/N E-787N6092SRobinson David John · Eads, TNBuilt 1975 · S/N D-9830N6093SFarmer Scott · Springtown, TXBuilt 1975 · S/N D-9826N6096SMortensen Daniel R Trustee · Newhall, CABuilt 1975 · S/N TH-699N6097SDonbee Farms Inc · Brawley, CABuilt 1975 · S/N E-789N60AMCleveland Flying Inc · Cleveland, MSS/N CE-764N60AULife'S A Beech LLC · Sun Prairie, WIFirst renewal noticeS/N TE-915N60DRSudeep Singh Flllp · Clovis, CABuilt 1978 · S/N E-1214N60EDKamal Ronny · Chicago, ILBuilt 1985 · S/N E-2241N60ETChankhunthod Anawat · Saratoga, CAS/N TK-57N60LPLowpass Aviation Services LLC · Germantown, TNBuilt 1977 · S/N E-1061N60MLStephens Gary James · Austin, TXBuilt 1976 · S/N D-9955N60NECub Crafters Resale LLC · Yakima, WABuilt 1978 · S/N E-1209N60RMMartin Bennie D · Garden Ridge, TXBuilt 1977 · S/N D-10048N60SHBas Part Sales LLC · Greeley, COBuilt 1980 · S/N TJ-267N60TZMeadows Christopher · Vestavia Hills, ALS/N CE-729N6105CPaschall Flights LLC · Hailey, IDBuilt 1981 · S/N CE-979N6108EMid America Sprayers Inc · Ulysses, KSBuilt 1981 · S/N E-1939N6108STorres Jose C · Santa Clarita, CABuilt 1982 · S/N E-1946N6113ADelianides Aris Philip · Virginia Beach, VABuilt 1981 · S/N E-1941N6113DMurfin Drilling Co Inc · Afton, OKS/N E-3513N6119UQureshi Arif · Dansville, NYBuilt 1981 · S/N E-1948N611RSWickman William S · Mckinleyville, CABuilt 1976 · S/N E-982
Back to AD 87-18-06 R1