JASC 3350
Service difficulty reports · 225,886
Reports filed under 3350 · Emergency Lighting, newest first.
Query with SQL
duckdb -csv -c "SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE jasc_code = '3350' ORDER BY difficulty_date DESC"
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.
SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE jasc_code = '3350' ORDER BY difficulty_date DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
SDR AALA201711219033Lens · missingEMERGENCY LIGHT AISLE SIDE WHITE LENS MISSING AT LAV L53. REPLACED THE LENS IAW AMM 33-51-13.SDR AALA201711219032Lens · missingEMERGENCY LIGHT AISLE SIDE WHITE LENS MISSING AT THE R4 DOOR. REPLACED THE LENS IAW AMM 33-51-13.SDR AALA201711219031Lens · missingEMERGENCY LIGHT AISLE SIDE WHITE LENS MISSING AT LAV L74. REPLACED THE LENS IAW AMM 33-51-13.SDR HALA2017112100263Power Supply · faultedDURING SLIDE OPERATIONAL CHECK, FOUND EPSU 13WL FAULTING. REPLACED EPSU 13WL.SDR DALA2017112008280Connector · disconnectedROW 25 AB & CD EMERGENCY EXIT SIDEWALL LIGHTS INOPERATIVE. FOUND CONNECTOR P1-2306 NOT FULLY SEATED. CONNECTED THE CONNECTOR AND OP CHECKED GOOD.SDR DALA2017112008272Battery Pack · inoperativeFOUND ROW 26 AB+CD EMERGENCY EXIT SIDE WALL LIGHTS INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK ASSY.SDR AALA201711209035Lens · looseAIRCRAFT WAS NOT GROUNDED: L1 DOOR EMERGENCY EXIT SIGN LENS WAS LOOSE. REPLACED NEW LENS COVER ON L1 DOOR EMERGENCY EXIT SIGN PER AMM 33-51-00. MAINTENANCE PERFORMED SUCCESSFUL OPERATIONS CHECK.SDR AALA201711209031Lens · detachedFORWARD EMERGENCY LIGHT LENS DETACHED DURING FLIGHT. SECURED THE LENS, AND OPS CHECKED GOOD.SDR AALA201711209030Bulb · inoperativeEMERGENCY LIGHT AT THE LEFT PARTITION FRAME 35 IS INOPERATIVE. REMOVED AND REPLACED THE LIGHT BULB IAW AMM 33-51-18. OPS CHECKED GOOD.SDR SWAA2017112117925Light · inoperativeRIGHT EMERGENCY LIGHT INOPERATIVE AT ROW 22. R & R THE LIGHT ASSEMBLY IAW AMM.SDR SWAA2017112117923Lamp · inoperativeL1 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM.SDR R61A201711190866Power Supply · inoperativeEMERGENCY LIGHT BATTERY FAULT MESSAGE ON EICAS. R & R THE POWER SUPPLY IAW AMM 33-50-01. OPS CHECKED GOOD.SDR AALA201711219039Battery · dischargedFLASHLIGHT LOW ON POWER AT THE RIGHT INBOARD AFT JUMP SEAT. REPLACED THE BATTERY IAW AMM 25-64-00.SDR CALA2017112004159Battery · dischargedROWS 1-7 OVERHEAD EMERGENCY LIGHTS, RT SIDE ARE INOPERATIVE. REPLACED THE BATTERY. OPS TESTED NORMAL IAW AMM 38-51-00-710-801, REV 81.SDR CALA2017111904156Fuse · inoperativeEMERGENCY LIGHT ROWS 20 AND 21 INOPERATIVE. R & R THE FUSES IN THE POWER SUPPLY, M1694. CHECKED GOOD IAW AMM 33-51-06.SDR CALA2017111904155Lens · looseEMERGENCY EXIT LIGHT LENS ABOVE LAVATORY D FELL OFF. INSTALLED THE LENS. OPS CHECKED GOOD IAW AMM 33-51-00.SDR CALA2017111904154Lens · brokenAFT EMERGENCY LIGHT LENS BROKEN AT SEAT 20C. REPLACED THE LENS AND TWO BULBS. OPS CHECKED NORMAL.SDR CALA2017111904153Lens · brokenAFT EMERGENCY LIGHT LENS BROKEN AT SEAT 15C. REPLACED THE LENS. OPS CHECKED NORMAL.SDR CALA2017111904152Lamp · inoperativeL2 DOOR SLIDE LIGHT INOPERATIVE. REPLACED THE LAMP IAW AMM 33-51-04-960-801. OPS TESTED NORMAL.SDR CALA2017111904149Sign · looseEXIT ROW SIGN RIGHT FELL DOWN REATTACHED R/H OVERWING EMERGENCY EXIT SIGN COVER IAW AMM 33-51- 01 REV 120SDR CALA2017111904148Battery Pack · inoperativeROWS 1-5 SEAT MOUNTED EMERGENCY LIGHTS INOPERATIVE. TROUBLESHOT IAW FIM 33-51-00, AND SSM 33-51-12. REMOVED AND REPLACED THE BATTERY PACK AND POWER SUPPLY, M33094. OPS CHECKED OK.SDR CALA2017111904144Lamp · inoperativeEXTERNAL EMERGENCY LIGHT AT THE L2 DOOR IS INOPERATIVE. REPLACED THE LAMPS. OPS TESTED GOOD IAW AMM 33-51-04-960-801, REV 81.SDR DALA2017112008243Lens · missingAFT EXIT DOOR CEILING LIGHT MISSING THE LENS. MAINTENANCE INSTALLED A NEW LENS.SDR DALA2017111908213Power Supply · inoperativeLOWER EMERGENCY EXIT DOOR LIGHTS ARE INOPERATIVE. MAINTENANCE REPLACED THE EMERGENCY LIGHT POWER SUPPLY AT B5-119. OPS CHECKED GOOD.SDR ASAA2017111922637Lens · detachedF/A REPORTS PLASTIC COVER ON REAR LT A/C JUMPSEAT HAS COME UNATTACHED. GROUNDED - YES. REINSTALLED EMERGENCY LIGHT LENS COVER CKS SECURE.SDR YENA201711190936Battery · dischargedFLT 1674, CHS-JFK. EPSU BATTERY EMER RT FAIL MESSAGE DURING EMERGENCY SYS TEST THRU CIDS. R & R OF THE BATTERY OF THE EPSU AT 12WL IAW AMM 33-51-38. SYS AND OPS CHK GOOD. A/C OK FOR SVC.SDR SWAA2017112017888Lens · brokenLEFT EMERGENCY EXIT SIGN LIGHT LENS BROKEN NEAR THE AFT LAV. R & R THE LENS IAW AMM.SDR DALA2017112008217Lens · damagedEMERGENCY LIGHT LENS DAMAGED. REPLACED THE LENS. CHECKED NORMAL.SDR SIMA20171119001Lamp · inoperativeSERVICE DOOR EXTERNAL EMERGENCY LIGHT INOPERATIVE. R & R THE LAMP IAW AMM 33-50-10-000-801, AND 33-50-10-400-801. OPS CHECKED GOOD.SDR MASA2017111912776Light · inoperativeROW 13 EMERG EXIT SIGNS INOP. RELAMPED.SDR MASA2017111912774Light · inoperativeESCAPE PATH LIGHTING AT 1A INOP. REPLACED LIGHT STRIP.SDR SWAA2017120618273Lens · crackedRT STOWBINS EMERGENCY LIGHT LENS CRACKED AT ROW 25. R&R LENS IAW AMM.SDR SWAA2017120618260Lens · crackedLT STOWBINS EMERGENCY LIGHT LENS CRACKED AT ROW 23. R&R LENS IAW AMM.SDR SWAA2017112718029Battery Pack · inoperativeL2 DOOR EMERGENCY EXIT SIGN L1076 INOPERATIVE. R & R THE BATTERY PACK IAW AMM.SDR AALA201711199012Lens · looseEMERGENCY LIGHT LENS LOOSE. REPLACED THE LENS AND PERFORMED SUCCESSFUL SYSTEM TEST IAW MM 33-51-18.SDR DALA2017112008267Light · unsecureEMERGENCY LIGHTS AT SEAT 29B ARE INOPERATIVE. SECURED LIGHT ASSEMBLY. SYSTEM OPERATION IS NORMAL.SDR REXA2017111801186Lens · brokenLEFT WING TRAILING EDGE INSPECTION LIGHT BROKEN. REMOVED AND REPLACED EMERGENCY LIGHT LENS IAW AMM 33-51-15.SDR SWAA2017112117937Lens · missingRIGHT EMERGENCY EXIT LOWER FORWARD POSITION LIGHT LENS MISSING. REPLACED THE LENS IAW AMM.SDR QXEA2017112100670Guard · missingFORWARD EMERGENCY LIGHT SWITCH GUARD IS MISSING. INSTALLED GUARD ON EMERGENCY LIGHT SWITCH IAW AMM 33-51-05-000/400-801.SDR AALA201711209038Power Supply · no testAFT LEFT EMERGENCY LIGHT POWER SUPPLY UNIT INOPERAIVE. REPLACED THE POWER SUPPLY IAW AMM 33-51-38.SDR AALA201711209037Battery · inoperativeAFT LEFT EMERGENCY POWER SUPPLY BATTERY INOPERATIVE. REPLACED THE BATTERY IAW AMM 33-51-38.SDR AALA201711199015Battery · inoperativeMID LEFT EMERGENCY POWER SUPPLY BATTERY INOPERATIVE. REPLACED THE BATTERY IAW AMM 33-51-38.SDR AALA20171119002Battery Pack · faultedDURING CID1 SYSTEM TEST, LATCHED FAULT BATTERY , EMERGENCY POWER SUPPLY UNIT (15WL) MID LEFT. REPLACED THE BATTERY PACK IAW AMM 33-51-38. OPS CHECKED.SDR CALA2017111804140Lens · detachedEMERGENCY LIGHT LENS MISSING. INSTALLED THE LENS.SDR CALA2017111804139Sign · looseEMERGENCY EXIT SIGN IN THE AFT GALLEY WAS LOOSE. SECURED THE SIGN.SDR AALA201711209041Sign · inoperativeAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN ABOVE THE L4 DOOR IS INOPERATIVE. REMOVED AND REPLACED EXIT SIGN PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20171118003Portable Light · inoperativeAIRCRAFT WAS NOT GROUNDED. FLIGHT DECK PORTABLE EMERGENCY LIGHT FAILED TEST. REMOVED AND REPLACED LIGHT PER AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR ASAA2017111822627Cover · out of positionF/A FOUND UNIDENTIFIED WHITE RECTANGULAR PIECE OF PLASTIC AT BACK OF AIRCRAFT. ROUGE PIECE BROUGHT UP TO FLIGHT DECK FOR FUTURE IDENTIFICATION. GROUNDED - YES. REINSTALLED LIGHT COVER FOR AFT CABIN AISLE EMERGENCY LIGHTS, OPS CHECKS GOOD COVER SECURE.SDR HALA2017111900262Cover · looseEMERGENCY EXIT COVER LOOSE AND DOOR 3R. RE-INSTALLED DOOR 3R EXIT COVER.SDR IPXA2017111923690Retainer · missingR1 DOOR HANDLE EMERGENCY LIGHT COVER MISSING RETAINER GROMMETS. REPLACED R1 DOOR HANDLE EMERGENCY LIGHT COVER RETAINER GROMMETS MM 33-52-02
Back to JASC 3350