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 MASA2019081412001Light · inoperativeROW 3 CEILING EMERGENCY FLOOD LIGHT INOPERATIVE.SDR FDEA2019081531855Bulb · failedL1 SLIDE TEST LIGHT INOP. REPLACED BULBS WITH CORRECT BULB TYPE. OPS CHECK GOODSDR SWAA2019081635983Light · damagedFORWARD LAVATORY EXIT LIGHT DAMAGED SET SCREW. R&R LIGHT IAW AMM.SDR WX0A2019081473413Power Supply · no testEPSU FAILED BITE. R&R THE EPSU.SDR F3LA201908140075Cids · malfunctionedGREEN FLOOR LIGHTS ON 14-15-16 A/C RIGHT SIDE AND 19-24 ALL OTHER OFF. PERFORMED CIDS RESET PER AMM 23-73-00-PB 501 AC OK TO CONTINUE OPS CHECK NORMAL MCC NOTIFIEDSDR ASOA2019081434046Sign · looseIAH - THE FLIGHT CREW REPORTED THAT THE EXIT SIGN NEAR THE FORWARD FA JUMPSEAT WAS INOP. MAINTENANCE RESET THE AFFECTED LIGHT, OPERATIONALLY TESTED WITH NO DEFECTS NOTED AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR SWAA2019081435931Light · damagedG1 GALLEY EMERGENCY EXIT LIGHT ASSEMBLY DAMAGED. / R&R LIGHT ASSEMBLY IAW AMM.SDR SWAA2019081435912Cover · missingFORWARD ENTRY EMERGENCY EXIT LIGHT LOWER LENS MISSING DIRECTIONAL ARROW. R&R COVER PER SIP.SDR SWAA2019081435910Lamp · inoperativeFORWARD SERVICE DOOR EXTERNAL EMERGENCY LIGHT INOP. RELAMPED LIGHT IAW AMM.SDR HNAA2019081400227Light · inoperativeNR 5 EMERGENCY LIGHT STRIP INOPERATIVE. R & R THE PROXIMITY LIGHT STRIP IAW AMM 33-50-12-400-801-ASDR HNAA2019081400226Lamp · inoperativeLH AFT EMERGENCY LIGHT DOES NOT ILLUMINATE. R & R LH AFT EMERGENCY LIGHT LAMP IAW AMM 33-50-10-000/400-801-ASDR 29GA2019081400002Circuit Breaker · trippedC/B L8 (EMERGENCY LIGHT CONTROL) POP UP IN FLIGHT. CORERECTIVE ACTION: RESET C/B AND PERFORMED OPERATIONAL CHECK NO DEFECT NOTED AT THIS TIME.SDR 29GA2019081400001Light · unsecureEMERGENCY LIGHT STRIP LOOSE AND IN PATHWAY. SECURED EMERGENCY LIGHT STRIP PATHWAY IAW 20-10-00 SAAB AMM.SDR VNAA2019081211101Light · inoperativeMX FOUND RH OVERWING EMERGENCY EXIT LIGHT FAILS TO ILLUMINATE. REMOVED R/H OVERWING EMERGENCY LIGHT. OP CHECK GOOD.SDR IXXA20190817014Battery Pack · inoperativeN751CX GROUNDED FOR SPECIAL MX VISIT, MAINTENANCE REPORTS "FAULTY BATTERY CHARGER EMERGENCY LIGHT". REMOVED AND REPLACED FAULTY POWER SUPPLY EMERGENCY LIGHT WITH SERVICEABLE PART IAW BOEING AMM 33-51-07. NO ADDITIONAL FAULTS NOTED. AIRCRAFT REMAINS GROUNDED FOSDR IPXA2019081645690Battery Pack · no testLEVEL 1 EMER 1 RT BATT LOW DURING TEST. R&R'D EMERGENCY POWER SUPPLY FOR EMERGENCY LIGHTING PER AMM 33-61-01-400-802. ESR: IPC 33-51-01-008SDR DALA2019081544770Lens · looseEMERGENCY EXIT SIGN COVER LOOSE / INTERIOR. REINSTALLED EMERGENCY EXIT SIGN LENS PER B757AMM 33-51.SDR YENA2019081520453Battery · failedDURING HEAVY MAINTENANCE, EPSU BATTERY ON THE FOLLOWING POSITIONS FAILED TEST 10WL, 11WL, 12WL. REMOVED AND REPLACED EPSU BATTERIES AT 10WL, 11WL AND 12WL IAW AMM 33-51-38. SYS OPS CHECKS NORMAL. R/R EPSU AT 11WL POSITION IAW AMM 33-51-38.SDR YENA201908152452Battery · failedDURING HEAVY MAINTENANCE, EPSU BATTERY ON THE FOLLOWING POSITIONS FAILED TEST 10WL, 11WL, 12WL. REMOVED AND REPLACED EPSU BATTERIES AT 10WL, 11WL AND 12WL IAW AMM 33-51-38. SYS OPS CHECKS NORMAL. R/R EPSU AT 11WL POSITION IAW AMM 33-51-38.SDR YENA2019081520451Battery · failedDURING HEAVY MAINTENANCE, EPSU BATTERY ON THE FOLLOWING POSITIONS FAILED TEST 10WL, 11WL, 12WL. REMOVED AND REPLACED EPSU BATTERIES AT 10WL, 11WL AND 12WL IAW AMM 33-51-38. SYS OPS CHECKS NORMAL. R/R EPSU AT 11WL POSITION IAW AMM 33-51-38.SDR YENA2019081420450Battery Pack · failedEMERGENCY LIGHT BATTERIES 11WL AND 13WL FAIL TEST; R & R BATTERIES IAW AMM 33-51-38, OPS CKS OK.SDR YENA2019081420449Battery Pack · failedEMERGENCY LIGHT BATTERIES 11WL AND 13WL FAIL TEST; R & R BATTERIES IAW AMM 33-51-38, OPS CKS OK.SDR AALA201908149017Lens · missingAIRCRAFT WAS NOT GROUNDED: MISSING EMERGENCY LIGHT COVERS AT SEAT 11G, 8G, 3D, AND 8D. MAINTENANCE REPLACED EMERGENCY LIGHT AT SEAT 11G, 8G, 3D, AND 8D PER AMM 33-51-05.SDR AALA201908149016Lens · missingAIRCRAFT WAS NOT GROUNDED: MISSING EMERGENCY LIGHT COVERS AT SEAT 11G, 8G, 3D, AND 8D. MAINTENANCE REPLACED EMERGENCY LIGHT AT SEAT 11G, 8G, 3D, AND 8D PER AMM 33-51-05.SDR AALA201908149015Lens · missingAIRCRAFT WAS NOT GROUNDED: MISSING EMERGENCY LIGHT COVERS AT SEAT 11G, 8G, 3D, AND 8D. MAINTENANCE REPLACED EMERGENCY LIGHT AT SEAT 11G, 8G, 3D, AND 8D PER AMM 33-51-05.SDR AALA201908149008Lens · missingAIRCRAFT WAS NOT GROUNDED: MISSING EMERGENCY LIGHT COVERS AT SEAT 11G, 8G, 3D, AND 8D. MAINTENANCE REPLACED EMERGENCY LIGHT AT SEAT 11G, 8G , 3D, AND 8D PER AMM 33-51-05.SDR YENA2019081420448Lens · missingROW 1 EMERGENCY LIGHT COVER MISSING. INSTALLED NEW EMERGENCY LIGHT COVER PER AMM 33-50-00.SDR SWAA2019081435893Lens · looseCENTER CABIN OVERHEAD EMERGENCY EXIT SIGN AFT LENS FELL OFF. / SECURED LENS PER SIP.SDR SWAA2019081435874Battery Pack · inoperativeR/H FORWARD SLIDE EMERGENCY EVAC LIGHT INOP. R&R BATTERY PACK MODULE PER AMM.SDR DALA2019081304752Light · detachedSEAT MOUNTED LIGHT FELL OFF AND IS NOW UNDER SEAT. R & R SEAT MOUNTED E-LIGHT ASSY AS PER A320FAM AMM 33-51.SDR SWAA2019081335865Lamp · inoperativeL/H EMERGENCY EXIT LIGHT OVERWING INOP. RELAMPED LIGHT IAW AMM.SDR DALA2019081304749Lens · missing(LOG 6045272) DURING INSPECTION FOUND MID CABIN OVERHEAD EMERGENCY EXIT SIGN LENSES ARE MISSING. LOCATED AND REPLACED MISSING EXIT SIGN LENSES. OK FOR SERVICE.SDR AALA201908139005Battery · no testAIRCRAFT WAS NOT GROUNDED: FORWARD FLIGHT ATTENDANT FLASHLIGHT INOPERABLE. MAINTENANCE REPLACED FLASHLIGHT BATTERY PER STANDARD PRACTICES.SDR AALA201908139004Light · damagedAIRCRAFT WAS NOT GROUNDED: DURING WAKE UP CHECK, SEAT MOUNTED EMERGENCY LIGHT AT ROW 9R DAMAGED. MAINTENANCE REPLACED LIGHT PER AMM 33-51-18-000-001-A.SDR AALA201908139002Sign · faultyAIRCRAFT WAS NOT GROUNDED: R1 DOOR LOWER EMERGENCY EXIT LIGHT DID NOT COME ON. MAINTENANCE REPLACED EXIT MARKER PER TASK 33-51-13 AND SWP 20-43-13.SDR AALA201908139001Battery · no testAIRCRAFT WAS NOT GROUNDED: EMERGENCY POWER SUPPLY UNIT LIGHT BATTERY FAILED TEST. MAINTENANCE REPLACED EMERGENCY POWER SUPPLY UNIT BATTERY PER AMM 33-51-38.SDR 2019F00240Battery Pack · weakSEAT MOUNTED EMERGENCY LIGHTS ARE VERY DIM BETWEEN ROWS 19D AND 26D. REPLACED BATTERY PACK M10953 IAW MM 33-51-07, OP CHECKED NORMAL.SDR DALA2019081624818Power Supply · inoperativeOVERHEAD EMERGENCY LIGHTS IARE INOPERATIVE AT ROW 22FG- 41FG. REMOVED AND REPLACED BATTERY AND POWER SUPPLY. SYSTEM OPERATION IS NORMAL.SDR DALA2019081534768Sign · detachedR2 EXIT SIGN FELL OFF. SECURED, NOW OK FOR SVC.SDR YENA2019081410447Light · no testEMERGENCY LIGHT TEST FAILED; REMOVED AND REPLACED OVERWING EMERGENCY LIGHT FIN #63WL PER AMM 33-51-15.SDR YENA201908141446Battery Pack · no testEMERGENCY LIGHT TEST FAILED; REMOVED AND REPLACED EPSU BATTERIES AT FIN 11WL AND 12WL PER AMM 33-51-38.SDR YENA2019081410445Battery Pack · no testEMERGENCY LIGHT TEST FAILED; REMOVED AND REPLACED EPSU BATTERIES AT FIN 11WL AND 12WL PER AMM 33-51-38.SDR ASAA2019081330378Sign · detachedEXIT ROW SIGN CAME OFF - CENTER ROW - EXIT. GROUNDED - YES. RESECURED EXIT ROW SIGN IN CENTER ROW.SDR SWAA2019081335782Lamp · inoperativeR/H FORWARD SLIDE LIGHT INOP. R&R LAMP PER AMM.SDR DALA2019081314744Battery Pack · inoperativeDURING INSPECTION FOUND EMERGENCY LIGHTS (SEAT MOUNTED) AT SEAT 10-14 INOPERATIVE. REPLACED BATTERY PACK AT 11 L FOR SEATS 10-14 PER B737-700 AMM 33-52. OPS CK GOOD.SDR AALA201908139007Lens · brokenAIRCRAFT WAS NOT GROUNDED: LENS ON ROW 27RH WAS BROKEN. MAINTENANCE REPLACED LENS PER AMM 33-51-03.SDR AALA201908139006Battery Pack · no testAIRCRAFT WAS NOT GROUNDED: SEAT MOUNTED EMERGENCY LIGHTS VERY DIM BETWEEN 19D AND 26D. MAINTENANCE REPLACED BATTERY PACK M10953 PER MM 33-51-07.SDR AALA2019081329007Lens · missingAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LOCATOR LIGHT LENS AT SEAT 9D WAS MISSING. MAINTENANCE REPLACED LENS PER AMM 33-51-18.SDR AALA201908129005Sign · detachedAIRCRAFT WAS GROUNDED: 3L EXIT SIGN KNOCKED DOWN. MAINTENANCE CLIPPED EXIT SIGN BACK INTO PLACE PER A330 AMM 33-51-17.SDR SIMA201908121003Lamp · inoperativeCOCKPIT EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED COCKPIT EMERGENCY LIGHT LAMP IAW AMM 33-50-05. OPC GOOD
Back to JASC 3350