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 SWAA2019020429133Lens · detachedL1 DOOR EMERGENCY EXIT LIGHT LENS COVER DETACHED. R&R LIGHT PER AMM.SDR SWAA2019020429132Lens · faultyR1 DOOR EXIT SIGN LENS FAULTY. SECURED LENS PER EA.SDR SWAA2019020429128Sign · looseAFT EMERGENCY EXIT WALL SIGN LOOSE. REINSTALLED SIGN IAW AMM.SDR DALA2019020400714Battery Pack · inoperativeTHE TAIL CONE EMERGENCY EXIT LIGHTS ARE INOPERATIVE. MAINTENANCE REPLACED THE BATTERY PACK AND THE CHARGER PER B717 AMM 33-51. CHECK WAS GOOD. (LP #3790932)SDR AALA201902042001Sign · inoperativeEXIT SIGN ABOVE SEAT 7 LEFT, FAILED TO CHECK. REMOVED AND INSTALLED THE SIGN HOUSING ABOVE SEAT 7 LEFT, PERFORMED AN OPS CHECK OPS CHECK GOOD IAW AMM 33-51-01-960-803.SDR MASA2019020111696Bulb · inoperativeROW 13 OVHD EMER LIGHT INOP
REPLACED BULBSDR DALA2019020400833Epsu · inoperativeEPSU (13WL) IN PASSENGER CABIN INOPERATIVE. REMOVED AND REPLACED SAME. OPERATION CHECKS GOOD.SDR DALA2019020710828Power Supply · inoperativeCABIN EMERGENCY FLOOR LIGHTS INOP AT ROW 12 AND 14 ABC, REPLACED EMERGENCY LIGHT POWER SUPPLY UNIT FIN 14WLSDR SIMA20190131003Light · malfunctionedFA REPORTS EMERG LIGHTS WOULD NOT TEST. REINITIALIZED POWER TO A/C EMERG LIGHTS OPS CK GOOD IAW AMM 33-50-00.SDR DALA2019020100780Light · unsecureEMERGENCY ASSEMBLY LOOSE AT SEAT 29GF, 30, 31AB, 34AB, 17GF. SECURED ALL LIGHT ASSEMBLIES.SDR SWAA2019020529227Light · inoperativeLT OVERWING LOWER EMERGENCY EXIT SIGN BULBS INOP. R&R LAMP PER AMM.SDR DALA201902050748Battery Pack · inoperativeDURING S/C FOUND EMERGENCY LIGHTS AT L4 DOOR INOP. REPLACED BATTERY PACK AND CHARGER M33407 PER B777 AMM 33-51 AT L4 DOOR. CHECKS GOOD.SDR ASAA2019013128029Light · inoperativeA/C REAR LEFT FUSELAGE EMERG EXIT LIGHT BULB OUT. GROUNDED - YES. RELAMPED A/C REAR LT FUSELAGE EMERGENCY LIGHT OP CHECK GOOD IAW AMM 33-51-00.SDR DALA2019020100728Lens · unsecureEMERGENCY EXIT COVER DIFFUSER LENS DAMAGED OR MISSING / LOCATIONS:206. RESECURED LENS.SDR SWAA2019020429163Battery · faultyFORWARD ENTRY GALLEY LIGHT ASSEMBLY HAD STRONG BURNT ELECTRICAL SMELL COMING FROM ABOVE. R&R BATTERY PER AMM.SDR SWAA2019020429162Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1675. R&R BATTERY PER AMM.SDR SWAA2019020429149Sign · looseMID CABIN EMERGENCY EXIT SIGN LOOSE. SECURED SIGN SIP.SDR SWAA2019020429137Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1672. R&R BATTERY PER AMM.SDR SWAA2019020429134Cover · missingLT FORWARD OVERWING EMERGENCY EXIT LIGHT COVER MISSING. INSTALLED COVER PER MM.SDR SWAA2019020429130Charger · faultyFORWARD ENTRY GALLEY LIGHT ASSEMBLY HAD STRONG BURNT ELECTRICAL SMELL COMING FROM ABOVE. R&R POWER SUPPLY CHARGER PER AMM.SDR AALA201902049017Control Unit · inoperativeDOOR 1 EXIT IDENTIFIERS (4) LIGHTS INOP AT THE L1 DOOR INTERIOR EMERGENCY EXIT LIGHT . INSTALLED CONTROL UNIT AT THE L1 DOOR. LOADED SOFTWARE AND OPS CHECKED IAW 33-51-00.SDR DALA2019013100694Battery Pack · faultedDURING M CHECK, FAULT MESSAGE EPSU-18WL-CABIN. REPLACED THE EPSU 18WL.SDR DALA2019013100645Battery Pack · inoperative(LOG 4882608) DURING INSPECTION FOUND AFT LEFT DOOR EMERGENCY LIGHT INOPERATIVE. R/R AFT EMERGENCY LIGHT BATTERY PACK PER B737 AMM 33-51. OPS CHK NML.SDR DALA2019013100637Power Supply · inoperativeEMERGENCY EXIT AND PATH LIGHTS ROW 1-12 IN OP. T/S EMERGENCY LIGHTS IAW AMM 33-53, R/R BATTERY POWER SUPPLY, P/N RPS1B, S/N OFF 032, S/N ON 6830, OP CKS GOOD IAW AMM 33-53. (LP5242190)SDR SWAA2019030730439Battery Pack · dischargedLT CABIN OVERWING EMERGENCY EXIT SIDEWALL PANEL 231YJW LIGHT INOP. R&R BATTERY PACK PER AM.SDR SWAA2019030730420Power Supply · inoperativeLT CABIN OVERWING EMERGENCY EXIT SIDEWALL PANEL 231YJW LIGHT INOP. R&R POWER SUPPLY PER AM.SDR SWAA2019030130197Lens · crackedRT EMERGENCY EXIT DOOR LENS DISCOLORED AND CRACKED. R&R LENSES PER AMM.SDR SWAA2019020429127Light · inoperativeLT OVERHEAD BIN EMERGENCY EVACUATION LIGHT INOP AT SEAT 12. RELAMPED LIGHT IAW AMM.SDR R61A2019020130140Power Supply · inoperativeFORWARD 3 EMERGENCY LIGHTS NOT WORKING, BUT NO EICAS MESSAGE. CA FOUND LIGHTS ON WHEN HE BOARDED THE AIRCRAFT. CA IS REPOWERING VIA APU. R&R #2 EMERGENCY BATTERY SUPPLY IAW AMM 33-50-01.SDR CALA2019020100195Power Supply · inoperativeREF NR L/P:9473253 - SPEC NO.B777-33-3-6019 - EMERGENCY LT POWER SUPPLY M023 FND NO DC OUTPUT. REPLACED EMERGENCY LT POWER SUPPLY CHARGE ASSY AND OP TEST CARRI ED OUT FND NORMAL AS PER AMM 33-51-06-960-803 REV85. ADD EMP:V903172 IDT BY TA551.SDR CALA2019020100194Power Supply · inoperativeREF NR L/P 9473252 - SPEC NO.B777-33-3-6019 - EMERGENCY LT POWER SUPPLY M33098 FND NO DC OUTPUT. REPLACED EMERGENCY LT POWER SUPPLY CHARGE ASSY AND OP TEST CARRI ED OUT, FOUND NORMAL AS PER AMM 33-51-06-960-813 REV.85. ADD EMP:V903172 IDT BY TA551.SDR AALA201902011001Battery · no testBATTERY 12WL FAILED AN OPS TEST, REMOVED AND REPLACED THE BATTERY IAW AMM 33-51-00. OPS CHECKED NORMAL.SDR 29GA2019020100002Circuit Breaker · trippedFLIGHT# 121 MCO/FLL CIRCUIT BREAKER L8 UNDER EMERGECNY EXT CTL, POPPED , RESET ONCE, THEN POPPED AGAIN. CORRECTIVE ACTION: RESET CB L8, CHECKED WIRES AT OVERHEAD PANEL AND F/A PANEL FOR SECURITY AND CONDITION NO DEFECT NOTED, OPERATION CHECK NORMAL.SDR SWAA2019013129065Light · crackedFORWARD LAV EMERGENCY LIGHT ASSEMBLY ON CRACKED. R&R LIGHT ASSEMBLY PER AMM.SDR SWAA2019013129041Battery Pack · dischargedFORWARD CEILING LIGHT INOP DURING TEST. R&R BATTERY PACK IAW AMM.SDR SWAA2019013129040Battery Pack · dischargedR1 LOWER EXIT SIGN INOP DURING TEST. R&R BATTERY PACK IAW AMM.SDR SWAA2019013129039Battery Pack · dischargedFIRST BULLNOSE EMERGENCY LIGHT INOP DURING TEST. R&R BATTERY PACK IAW AMM.SDR SWAA2019013129032Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1673. R&R BATTERY IAW AMM.SDR SWAA2019013129030Battery Pack · dischargedR1 DOOR EXTERNAL EMERGENCY LIGHT INOP DURING TEST. R&R BATTERY PACK IAW AMM.SDR SWAA2019013129029Light · inoperativeR2 DOOR EMERGENCY EXIT LIGHT BULB INOP. RELAMPED BULB IAW AMM.SDR SWAA2019013129022Lens · unsecureLT LENS ON EMERGENCY EXIT ON WING CAME OFF. REINSTALLED LENS PER SIP.SDR AALA201902010001Housing · brokenR4 DOOR EMERGENCY LIGHT WAS BROKEN. REPLACED THE LIGHT ASSEMBLY.SDR REXA20190130099Sign · inoperativeFLOOR LEVEL EXIT SIGN INOP. REPLACED EXIT SIGN IAW AMM 33-51-10 OPS CHECK GOODSDR SWAA2019021329528Switch · brokenP5 OVERHEAD EMERGENCY LIGHTS GUARDED SWITCH BROKEN. R&R SWITCH GUARD IAW SOPM.SDR SWAA2019020429161Battery Pack · failedEMERGENCY LIGHTING BATTERY PACKS FAILED CAPACITY TEST AT LOCATION M01674. R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2019020429160Battery Pack · failedEMERGENCY LIGHTING BATTERY PACKS FAILED CAPACITY TEST AT LOCATION M01673. R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2019020429159Battery Pack · failedEMERGENCY LIGHTING BATTERY PACKS FAILED CAPACITY TEST AT LOCATION M01670. R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2019020429158Battery Pack · failedEMERGENCY LIGHTING BATTERY PACKS FAILED CAPACITY TEST AT LOCATION M01669. R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2019020429146Battery Pack · failedEMERGENCY LIGHTING BATTERY PACKS FAILED CAPACITY TEST AT LOCATION M01675. R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2019020429129Plate · crackedFORWARD GALLEY EMERGENCY EXIT LIGHT BLANK OFF PLATE CRACKED. R&R LIGHT PLATE PER SIP.
Back to JASC 3350