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.

N802NHWiechmann August J · Hubbard, IABuilt 1992 · S/N E-2694N8032XCass Joseph R · Nevis, MNBuilt 1991 · S/N CE-1551N8036TPaysse John G · Hanford, CABuilt 1980 · S/N EA-150N8036VC J Logistics LLC · Dodge City, KSS/N E-2693N8037XJ B Aviation Inc · Charlotte, NCS/N E-2705N8038ZBas Part Sales LLC · Greeley, COBuilt 1990 · S/N E-2568N803DLRapids Ruddervators LLC · Wisconsin Rapids, WIBuilt 1973 · S/N D-9448N803NHCoastal Helicopters Inc · Panama City, FLBuilt 1992 · S/N E-2697N8043BT & A Aviation 2 LLC · Saint Petersburg, FLBuilt 1991 · S/N E-2618N8044UCrowe Stephen R Trustee · Lake Ozark, MOBuilt 1992 · S/N E-2708N8045UCox Clifford J · Armada, MIBuilt 1990 · S/N E-2570N8046GPoupard Chris Steven · Celina, TXBuilt 1992 · S/N CE-1646N8046JSgl Aero LLC · Alpine, WYBuilt 1990 · S/N CE-1527N8047KVan Dinter Mike · Post Falls, IDS/N CE-1648N8047PThompson Craig A · Dallas, TXBuilt 1992 · S/N CE-1660N8047RBrooks Auto Parts Inc · Douglas, GAS/N E-2709N8050NWillard Scott E · Mount Pleasant, SCBuilt 1992 · S/N CE-1650N8051UChandler Christian J · Ashfield, MABuilt 1990 · S/N TH-1607N8055RPioneer Aviation LLC · Portland, ORS/N E-2711N8055UJones Kyle M · Kerrville, TXBuilt 1992 · S/N CE-1664N8055ZAir Hatzis LLC · Baton Rouge, LABuilt 1990 · S/N E-2572N805JCBig Sky Baron Lc · Missoula, MTBuilt 1980 · S/N TJ-253N805NHT-Bone Truck Stop Inc · Columbus, NEBuilt 1992 · S/N E-2699N8064MTeam Financial Inc · Birmingham, ALBuilt 1992 · S/N CE-1674N8064NSierra Hotel Aviation LLC · Spartanburg, SCBuilt 1990 · S/N E-2578N8064UCommercial Flight Services Inc · West Chester, PABuilt 1992 · S/N CE-1673N8067UPalmer Eric E · Tucson, AZBuilt 1992 · S/N EA-536N8068USan Diego Flight Corp · San Diego, CABuilt 1992 · S/N E-2725N8069GR B Hanson Equipment LLC · Clancy, MTBuilt 1992 · S/N CE-1677N8069UV115 Aviation LLC · Mount Juliet, TNBuilt 1992 · S/N E-2727N806NHWes Electric LLC · Lafayette, LABuilt 1992 · S/N E-2702N806TPickering Jeff C · Paris, TXBuilt 1973 · S/N E-423N80722Benzinger Fay A · Bethesda, MDS/N CE-295N8072DLong Jill A · Apo, AES/N E-2728N8073HFrye Lloyd H · Zachary, LAS/N CE-1682N8073WKilo Mike LLC · Nancy, KYBuilt 1992 · S/N E-2730N8077MKriessler Scott C · Port Clinton, OHBuilt 1990 · S/N E-2565N8077XTudor George J · Mecca, CABuilt 1990 · S/N E-2534N8079ZParker Larry E Jr · Lumber Bridge, NCBuilt 1992 · S/N EA-538N807DJGreat West Produce Co Inc · Commerce, CABuilt 2001 · S/N E-3371N807LWLocke Jeffrey · The Plains, VABuilt 1978 · S/N CE-807N807NHJohnson Gregory D · Elkhart, IAS/N E-2704N807THSan Mateo Real Estate Inc · San Mateo, CABuilt 1977 · S/N TH-807N8080NStratz Gregory A · Port Orange, FLBuilt 1992 · S/N CE-1688N8080PPiper Llp · Decatur, ALBuilt 1992 · S/N E-2736N8083FTindall Haul And Erect Corp · Spartanburg, SCBuilt 1993 · S/N E-2771N8083RR And P Air LLC · Cimarron, KSBuilt 1992 · S/N CE-1689N8085NRandall Daniel Ronald · Minneapolis, MNS/N E-2740N8087RCavanaugh Robert K · Valparaiso, INBuilt 1992 · S/N E-2738N8088JPhillips Robert Carroll III · Waxhaw, NCBuilt 1990 · S/N E-2502
Back to AD 87-18-06 R1