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 REXA2020080500610Light · inoperativeSECOND TO AFT EMERGENCY FLOOR TRACK LIGHT, INOPERATIVE. REPLACED THE EMERGENCY LIGHT IAW AMM 33-51-01. OPS CHECKED GOOD.SDR IPXA2020080538607Power Supply · no testEMERGENCY LIGHTS FAILED TO TEST. R & R THE BATTERY POWER SUPPLY IAW AMM 33-51-01-000-802.SDR DALA2020080542715Battery Pack · inoperativeDURING SERVICE CHECK FOUND EMERGENCY LIGHTS AT ROWS 1,2 AND 3 INOPERATIVE. REPLACED BATTERY PACK M730. SYSTEM OPERATION IS NORMAL.SDR DALA2020080532713Light · inoperativeEMERGENCY ESCAPE PATH LIGHTS AT SEAT 44D INOPERATIVE. REPLACED LIGHT ASSEMBLY. SYSTEM OPERATION IS NORMAL.SDR N6WA20200804302Battery Pack · dischargedEMERGENCY LIGHTS INOP. RECHARGE EMERGENCY LIGHT BATTERIES AND PERFORMED OPS TEST IAW CRJ AMM 33-51-17SDR N6WA20200804301Battery Pack · dischargedEMERGENCY LIGHTS INOPERATIVE. RECHARGED THE EMERGENCY LIGHT BATTERIES AND PERFORMED OPS TEST IAW AMM 33-51-17SDR AALA202008049002Lens · missingAIRCRAFT WAS NOT GROUNDED: COVER PLATE (LENS) OFF SIGN NEAR SEAT 1C. REPLACED LENS. OK FOR CONTINUED SERVICE PER GPM 02.01.2.SDR DALA2020080302695Battery Pack · inoperativeDURING INSPECTION, FOUND CENTER OVERHEAD EXIT LIGHT WILL NOT ILLUMINATE. REMOVE AND REPLACED POWER SUPPLY AT BATTERY LOCATION M1670 IAW B737 AMM 33-51. OPS CHECK GOOD.SDR SWAA2020081005274Light · inoperativeFOUND RH OVERWING EMERGENCY EXIT DOOR EXTERIOR EMERGENCY LIGHT INOP. / REPLACED BATTERY PACK M1669 ON N/R W161831 AND PERFORMED EMERGENCY LIGHTS OPS TEST AT R/H OVERWING EXIT DOOR EXTERIOR FOUND NORMAL AS PER REF. B737 AMM 33-51-00-710-801; T/S AS PER FIM 33-5SDR SWAA2020081005273Light · inoperativeFOUND RH OVERWING EMERGENCY DOOR EXIT SIGNS INOP. / REPLACED BATTERY PACK ON N/R W161831 AND PERFORMED EMERGENCY LIGHTS OPS AT R/H OVERWING EMERGENCY EXIT DOOR FOUND NORMAL AS PER REF. B737; AMM 33-51-00-710-801.SDR SWAA2020080505411Battery Pack · inoperativeMULTIPLE EMERGENCY LIGHTS INOPERATIVE. REMOVED & REPLACED BATTERY PACK AND CHARGER ASSY AT BS 500C +7. + OPS CHECKED GOOD IAW AMM 33-51-06.SDR SWAA2020080506139Charger · inoperativeMULTIPLE EMERGENCY LIGHTS INOPERATIVE. REMOVED & REPLACED THE BATTERY PACK AND CHARGER ASSY AT BS 500C +7. OPS CHECKED GOOD IAW AMM 33-51-06.SDR DALA2020080532717Battery Pack · inoperativeON SERVICE CHECK FOUND CABIN EMERGENCY LIGHTS M10568 INOPERATIVE. CORRECTIVE ACTION. REPLACED BATTERY. SYSTEM OPERATION IS NORMAL.SDR DALA2020080302700Power Supply · failedDISPATCH MSG CABIN EMER EXIT LT. COMPLIED WITH MX DIRECTION PER ACARS. CORRECTIVE ACTION: FAULTING EPSU NIS ATL. PERFORMED EPSU BITE PER A350 AMM 33-51 TEST FAULTS EPSU FIN 101WL1 AND 101WL4 REMOVED AND REPLACED 101WL1 PER A350 33-51OPS TEST NORMAL STILL FAULTSDR DALA2020080302697Battery Pack · inoperativeDURING INSPECTION, FOUND AFT LOWER EMERGENCY EXIT LIGHTS INOPERATIVE AT ROW 23 AFT. REMOVED AND REPLACED BATTERY. OPS CHECK GOOD PER B737 AMM 33-51.SDR SIMA202008032001Lamp · inoperativeLH WING EMERGENCY LIGHT INOPERATIVE. R & R LT WING EMERGENCY LIGHT LAMP IAW AMM 33-50-10 OPS CHECK GOOD.SDR SWAA2020081105334Battery Pack · inoperativeAFT EMERGENCY EXITS LIGHT BATTERY M1673 WILL NOT HOLD A CHARGE. REMOVED AND REPLACED EMERGENCY EXIT LIGHTS BATTERY PACK M1673 AND PERFORMED GOOD TEST IAW AMM 33-51-06-960-805.SDR DALA2020080302716Battery Pack · inoperativeEMERGENCY EXIT LIGHTS ARE INOPERATIVE. CORRECTIVE ACTION: REPLACED FORWARD BATTERY PACK. SYSTEM OPERATION IS NORMAL.SDR DALA2020080532712Battery Pack · inoperativeEMERGENCY LIGHTS AT ROWS 33-37 ARE INOPERATIVE. REPLACED BATTERY PACK. SYSTEM OPERATION IS NORMAL.SDR REXA2020080500609Battery · inoperativeEXIT LIGHT OUT AT ROW 5 FOUND DURING FA PREFLIGHT. R & R THE BATTERY ASSY PS36 IAW AMM 33-51-17. ALL CHECKED GOOD.SDR SWAA2020080405373Light · detachedFWD SERVICE DOOR EXIT LENS COVER DETATCHED / R&R FWD SERVICE DOOR EMERGENCY EXIT LIGHT ASSEMBLY (LWR) PER AMM 33-51-01. OPS CHECK OK.SDR SWAA2020080405471Lamp · inoperativeEMERGENCY LIGHT JUST AFT OF AFT ENTRY DOOR INOPERATIVE. R & R THE LAMP ON EMERGENCY LIGHT IAW MM 33-51-04.SDR REXA2020080400608Battery Pack · inoperativeFORWARD FACING CURVED EMERGENCY LIGHTS ON CEILING ABOVE EXIT ROWS INOPERATIVE. REMOVED AND REPLACED EPSU BATTERY PACK PS43 IAW AMM 33-51-17. OPS CHECKED GOOD.SDR REXA2020080400607Cover · missingREAR FACING EXIT SIGN IN PAX CABIN MISSING. INSTALLED EXIT SIGN COVER IAW AMM 33-51-07.SDR SIMA202008031001Battery Pack · dischargedEMERGENCY EXIT LIGHT INOPERATIVE. PERFORMED EMERGENCY LIGHT POWER UNIT CHARGE IAW AMM 33-50-01 OPERATIONAL TEST OF THE EMERGENCY LIGHTING OK REF. 33-50-00.SDR WX0A2020080373541Battery Pack · no testEPSU BATTERY (12WL) FAILED BATTERY CAP TEST. / REMOVED AND REPLACED BATTERY IAW AMM 33-51-38-000-002-A AND AMM 33-51-38-400-002-A. OPS CHECK GOOD."SDR WX0A2020080373540Battery Pack · no testOPERATIONAL TEST OF EMERGENCY LIGHTS FOR WEEKLY CHECK FAILED EPSU 13WL BATTERY / REMOVED AND REPLACED BATTERY FOR EPSU 13WL IAW AMM 33-51-38-400-002. OPS CKS GOOD."SDR DALA2020080302696Battery Pack · inoperativeDURING INSPECTION, FOUND MULTIPLE EMERGENCY LIGHTS OUT IN F/C ON WALK AROUND. R/R M2816 BATTERY PACK PER B737 AMM 33-51. OPS CKS GOOD.SDR AALA2020080329014Power Supply · no testAIRCRAFT WAS NOT GROUNDED: DURING PS CHECK EMERGENCY POWER SUPPLY UNIT (10WL) BATTERY FAULTS. REPLACED BATTERY PER AMM 33-51-38.SDR AALA2020080329013Power Supply · no testAIRCRAFT WAS NOT GROUNDED: DURING PS CHECK EMERGENCY POWER SUPPLY UNIT (11WL) BATTERY FAULTS. REPLACED BATTERY PER AMM 33-51-38.SDR AALA2020080329012Power Supply · no testAIRCRAFT WAS NOT GROUNDED: DURING PS CHECK EMERGENCY POWER SUPPLY UNIT (12WL) BATTERY FAULTS. REPLACED BATTERY PER AMM 33-51-38.SDR AALA2020080329011Lens · missingAIRCRAFT WAS NOT GROUNDED: 2L DOOR EMERGENCY EXIT LIGHT ON LOWER LEFTSIDE OF DOOR HAS A MISSING LENS. RECOVERED AND REPLACED MISSING LENS.SDR J7SA2020082600215Battery Pack · malfunctionedDISCOVERED EMERGENCY LIGHTS ILLUMINATED AND WOULD NOT EXTINGUISH IN FLIGHT. REMOVED AND REPLACED BOTH FWD AND AFT EMERGENCY BATTERY SUPPLY WITH A MODIFIED BATTERY FOR THE FWD AND TESTED BATTERY PACK FOR THE AFT. OPERATIONS CHECK SATISFACTORY. REFERENCE CHAPSDR DALA2020081312771Battery Pack · inoperativeEMERGENCY EXTERNAL LIGHTS AT THE R2 DOOR WERE INOPERATIVE. REPLACED THE BATTERY.SDR DALA2020080432707Battery Pack · inoperativeMERGENCY LIGHTS FROM SEAT 38D-42D ARE INOPERATIVE. REPLACED THE BATTERY PACK M735. SYSTEM OPERATION NORMAL.SDR DALA2020080432705Battery Pack · inoperativeEMERGENCY SEAT LIGHT AT ROWS 38-42 ARE INOPERATIVE. REPLACED BATTERY. SYSTEM OPERATION IS NORMAL.SDR DALA2020080432704Battery Pack · inoperativeL2 DOOR AND SURROUNDING AISLE EMERGENCY EXIT LIGHTS ARE INOPERATIVE. REPLACED BATTERY. SYSTEM OPERATION IS NORMAL.SDR QXEA2020080400230Warning Message · illuminatedWHEN TURNING OF AIRCRAFT POWER EMERGENCY LIGHTS ASSOCIATED WITH POWER SUPPLY PS1 ILLUMINATED.SDR UIEA2020080411526Light · inoperativeUPPER DECK BS 550 AISLE EMERGENCY LIGHT WAS FOUND INOPERATIVE. THE EMERGENCY LIGHT ASSY WAS REPLACED AND TESTED NORMAL IAW AMM 33-51-07.SDR UIEA2020080331601Battery · inoperativeEMERGENCY LIGHT FUNCTIONAL TEST FOUND M5169 POWER SUPPLY FAILED, LOCATED AT BS 590, RBL 83, WBL 323. THE POWER SUPPLY BATTERY M5169 WAS REPLACED AND THE EMERGENCY LIGHTS TESTED NORMAL IAW AMM 33-51-04, AND 33-51-00.SDR WX0A2020080373542Battery Pack · no testCABIN EMERGENCY BATTERY CLASS 1 FAULT AFT L (13WL) / REMOVED AND REPLACED AFT L EMERGENCY SUPPLY BATTERY UNIT IAW AMM 33-51-000-002-A AND 33-51-38-400-002-A. OPS CHECK GOOD"SDR WX0A2020080373538Light · missingPHOTOLUMINSCENT EMERG LIGHT STRIP SECTION MISSING AT ROW 30 RH. REPLACED MISSING SECTION OF PHOTOLUMINSCENT EMERG LIGHT STRIP REF AMM 33-51-21 PB 401.SDR DALA2020080312699Battery Pack · inoperativeDURING INSPECTION, FOUND FIRST CLASS EMERGENCY LIGHTS INOPERATIVE RIGHT SIDE. REMOVED & REPLACED APPLICABLE BATTERY PACK PER 33-51. OPS CHECKS GOOD.SDR AALA2020080319008Light · unsecureAIRCRAFT WAS NOT GROUNDED: OVERHEAD EMERGENCY EXIT LIGHT FELL FROM CEILING AT OVERWING EXIT ON TAXI INTO GATE. RE-SECURED OVERHEAD EMERGENCY EXIT LIGHT BY OVERWING EXIT PER AMM 33-51-01.SDR VNAA2020080111103Battery Pack · failedEMERGENCY LIGHTS ASSOCIATED WITH EMERGENCY PACK NR 4 TURN ON BUT DIE 2 MINUTES AFTER TURNING ON. R & R THR NR 4 EMERGENCY POWER SUPPLY UNIT BATTERY IAW AMM 33-51-17-000/400-801. OPS CHECKED GOOD.SDR KO0R202007310005Light · inoperativeEMERGENCY LIGHTS FAILED TO ILLUMINATESDR AALA202007319002Light · missingAIRCRAFT WAS GROUNDED, SEAT MOUNTED EMERGENCY LIGHT ASSEMBLY MISSING AT ROW 15. REPLACED THE SEAT MOUNTED EMERGENCY LIGHT ASSEMBLY IAW AMM 33-51-19.SDR SIMA20200730007Light · brokenLT NR 1,NR 2, AND NR 3 EMERGENCY LIGHT STRIP EXTRUSIONS BROKEN. C/A COMPLETE: REMOVED AND REPLACED LT NR 1, NR 2, AND NR 3 EMERGENCY LIGHT STRIP EXTRUSIONS, IAW EMB 145 AMM 33-50-12.SDR SIMA20200730009Light · damagedLT NR 4 EMERGENCY LIGHT STRIP EXTRUSION SCREW HOLE ELONGATED. C/A COMPLETE: REMOVED AND REPLACED LT NR 4 EMERGENCY LIGHT STRIP EXTRUSION, IAW EMB 145 AMM 33-50-12.SDR SIMA20200730006Light · brokenLT NR 5 EMERGENCY LIGHT STRIP EXTRUSION BROKEN. C/A COMPLETE: REMOVED AND REPLACED LT NR 5 EMERGENCY LIGHT STRIP EXTRUSION, IAW EMB 145 AMM 33-50-12.
Back to JASC 3350