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.

N25720Smile Air LLC · Macomb, MIBuilt 1973 · S/N E-479N25734Gardner Aviation LLC · Hot Springs, ARBuilt 1973 · S/N TH-390N25745Bird Dog Aviation LLC · Kalispell, MTS/N TE-949N25798Hayek Investments LLC · Gulf Breeze, FLBuilt 1986 · S/N E-2308N258BBGhanimian Zaven · Encino, CABuilt 1977 · S/N TH-892N258DTwin Engine Express LLC · Lewes, DEBuilt 1995 · S/N TH-1740N258JYDodson International Parts Inc · Rantoul, KSS/N E-2343N258MTK5 Aviation LLC · Lewes, DES/N TH-244N258NCFidelis Flight Group Inc · Elm Springs, ARBuilt 1978 · S/N TH899N258RPInternational Air Services Inc Trustee · Carson City, NVBuilt 1994 · S/N TH-1737N258TNKrause Jason · Glendale, AZBuilt 1988 · S/N TH-1539N259CN259c LLC · Woodward, OKBuilt 2001 · S/N EA-684N259JHall James A · Bozeman, MTBuilt 1973 · S/N D-9430N259MMDavidson Bryan H · Sarasota, FLBuilt 1986 · S/N E-2311N25BTFernandez Sergio R · Port Saint Lucie, FLBuilt 1981 · S/N D-10373N25CGMcdonough Aviation LLC · Montgomery, ALBuilt 1978 · S/N E-1297N25FPEastern Stearman Inc Trustee · Leesburg, VABuilt 1992 · S/N E-2720N25JFaria Manuel Steven Trustee · Tipton, CABuilt 1974 · S/N CE-536N25LRRoam Airlines LLC · Eugene, ORBuilt 1981 · S/N EA-196N25LSBzaviation LLC · Saint Louis, MOBuilt 1994 · S/N E-2838N25MJHb Flying LLC · Pampa, TXS/N E-3236N25QGrant Janice · Friday Harbor, WABuilt 2001 · S/N E-3398N25QYCuller Richard E · Winston Salem, NCBuilt 1976 · S/N CE-653N25RDHamilton Robert L · Vashon, WABuilt 1971 · S/N CE-358N25RHPoseidon Transport Inc · Watertown, NYBuilt 1982 · S/N CE-1009N25RMSky Travel LLC · Clayton, MOS/N TJ-459N25RXOlde Same Place LLC · Thiensville, WIBuilt 1971 · S/N TE-832N25TMYankee Tango Mike LLC · Dublin, TXS/N EA-265N25UPNewsome Jeffery S · Blackwell, OKBuilt 1977 · S/N E-987N25VBOtto Aircraft Sales Inc · Sarasota, FLBuilt 1976 · S/N D-9841N25WWRainey Aerial Ag Service Inc · Obion, TNBuilt 1976 · S/N E-842N260ARDeep South Flying Services LLC · Albany, GABuilt 1983 · S/N TJ436N260EABlue Sky Airfleet LLC · Kalispell, MTBuilt 2004 · S/N E-3408N2613CThree Two Five Echo Fc · Corinth, TXBuilt 1985 · S/N E-2293N261EABrownstone Aviation II LLC · Houston, TXBuilt 2001 · S/N E-3423N262EAJeaps Aviation LLC · Edgewater, FLBuilt 2001 · S/N E-3417N262PMBig Bend Community College · Moses Lake, WABuilt 1992 · S/N CE-1681N263EAJdcwac LLC · Blair, NEBuilt 2002 · S/N E-3437N263SAColumbia Asset Trust Corp Trustee · Wichita, KSBuilt 1999 · S/N E-3283N2646PAlas De La Aguila LLC · Kalispell, MTS/N E-2313N264JGSparkling Diamond LLC · Middleton, WIBuilt 1999 · S/N E3264N264SBCkw Aviation LLC · Dalhart, TXS/N TE-1125N264SWBuilding Materials Supply Inc · Yakima, WABuilt 1998 · S/N E-3190N2653M97 Lima LLC · Edina, MNBuilt 1986 · S/N E-2315N2658BBrowning Frank W · Port Orange, FLBuilt 1986 · S/N CE-1086N2659UMec Management LLC · Wilmington, DEBuilt 1986 · S/N E-2316N265RVWb Aviation LLC · Saint Jo, TXS/N E3512N2664MInfcon LLC · Wilmington, DEFirst renewal noticeS/N E-2317N266EASouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N TH-2031N266TCAir Control Systems · Bigfork, MTS/N EA-483
Back to AD 87-18-06 R1