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 ASOA2020073094019Battery Pack · dischargedFLIGHT 3914, DURING MAINTENANCE INSPECTION THE #2 EMERGENCY LIGHT BATTERY PACK PACK WAS FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE AFFECTED EMERGENCY LIGHT BATTERY PACK, OPERATIONALLY TESTED WITH NO DEFECTS AND THE AIRCRAFT WAS APPROVED FORSDR AALA2020073099008Cover · damagedAIRCRAFT WAS NOT GROUNDED, EMERGENCY LIGHT COVER AT SEAT 25C WAS DAMAGED. REPLACED THE AISLE EMERGENCY LIGHT COVER IAW CMM 25-21-61.SDR SWAA2020072904326Lens · crackedAFT SERVICE DOOR AFT LIGHT LENS CRACKED. REMOVED AND REPLACED AFT SERVICE DOOR LIGHT LENS IAW 33-51-01.SDR SWAA2020072904553Light · inoperativeOUTSIDE EMERGENCY LIGHT AFT OF R1 DOOR INOPERATIVE.SDR SWAA2020072904552Light · inoperativeR1 DOOR HEADER PANEL EMERGENCY LIGHT INOPERATIVE.SDR SWAA2020080604637Lamp · inoperativeEMERGENCY EXIT AISLE LIGHT AT ROW 17LEFT WAS INOPERATIVE. REPLACED THE LAMPS AND PERFORMED A GOOD FUNCTIONAL TEST IAW AMM 33-51-03-960-801.SDR SWAA2020080304426Battery Pack · no testEMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY FUNCTIONAL CHECK AT LOCATION M01669. R&R EMERGENCY LIGHTING BATTERY PACK AND POWER SUPPLY AS PER AMM 33-51-06.SDR SWAA2020080304124Lamp · inoperativeEXTERNAL EMERGENCY LIGHT INOP JUST AFT OF FWD SERVICE DOOR. RELAMPED AND OPS CHECKED GOOD IAW MM 33-51-04SDR SWAA2020080304143Lamp · inoperativeR2 DOOR EXTERIOR SLIDE EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP IAW AMM 33-51-04. OPS-OKSDR DALA2020080312691Switch · no testL1 DOOR EMERGENCY LIGHT TEST SWITCH WILL NOT TEST. CORRECTIVE ACTION: REPLACED SWITCH. (LP 7022986)SDR ASAA2020073182960Power Supply · inoperativeEMERGENCY LIGHTS COMMON TO POWER SUPPLY M1676 INOP. GROUNDED - YES. REMOVED AND REPLACED EMERGENCY LIGHTS P/S M1676 IAW B737-800 AMM 33-51-06-960-806. OPS CHECKED GOOD.SDR UIEA2020073101662Battery · inoperativeFOUND EMERGENCY LIGHT AT UPPER DECK NOT ILLUMINATING AFT ELEC IAW AMM 33-51-04-902-001-001, REV 99. REPLACED THE BATTERY AND CONDITION CHECK NORMAL IAW AMM 33-51-04-902-001-001, REV 99. PERFORMED POWER SUPPLY TEST AND RESULT WAS SATISFACTORY.SDR UIEA2020073101663Battery · no testFOUND UPPER LIGHT BATTERY PACKS CAPACITY LOW (M5057) IAW AMM 33-51-04-902-001-001, REV 98. REPLACED THE BATTERY IAW AMM 33-51-04-902-001-001, REV 98. PERFORMED AN EMERGENCY LIGHT BATTERY. POWER SUPPLY TEST AND THE RESULT WAS SATISFACTORY.SDR AALA2020073199003Power Supply · inoperativeAIRCRAFT WAS GROUNDED. R3 DOOR EMERGENCY POWER SUPPLY UNIT M33404 FAILED TEST. REMOVED AND REPLACED EMERGENCY LIGHT POWER SUPPLY ASSEMBLY LOCATED ABOVE DOOR R3 (M33404) IAW AMM 33-51-06.SDR DALA2020073092672Battery Pack · inoperativeEMERGENCY ROW OVER WING LIGHTS AND AFT DOOR ARE INOPERAIVE. REPLACED BATTERY PACKS AT OVER WING LOCATION AND RIGHT DOOR.SDR DALA2020073092670Battery Pack · inoperativeEMERGENCY PATH LIGHTS FROM SEAT 23DEF TO 28DEF ARE INOPERATIVE. REPLACED BATTERY PACKS. SYSTEM OPERATION IS NORMAL.SDR AALA2020073099014Battery Pack · inoperativeAIRCRAFT WAS GROUNDED, FOUND EMERGENCY LIGHTS OUT AT CREW REST AREA WALL. REPLACED BATTERY PACK M33400 AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK IAW AMM 33-51-06.SDR AALA2020073099013Battery Pack · inoperativeAIRCRAFT WAS GROUNDED, FOUND EMERGENCY LIGHTS OUT AT SEAT ROWS 7D-10D. REPLACED BATTERY PACK (M33098) AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK IAW AMM 33-51-06.SDR AALA2020073099012Battery Pack · inoperativeAIRCRAFT WAS GROUNDED. FOUND EMERGENCY LIGHTS AT AFT GALLEY WALL INOPERATIVE. REPLACED BATTERY PACK M33409 AND ACCOMPLISHED A SATISFACTORY OPERATIOANL CHECK IAW AMM 33-51-06.SDR AALA2020073099011Battery Pack · inoperativeAIRCRAFT WAS GROUNDED, IAW WORK CARD 2341, FOUND OVERHEAD EMERGENCY LIGHTS AT SEATS 17-30D INOPERATIVE. REPLACED THE BATTERY PACK M33408 IAW AMM 33-51-06.SDR AALA2020073099007Light · detachedAIRCRAFT WAS NOT GROUNDED, SEAT 26C EMERGENCY LIGHT HANGING FROM ARMREST. REPOSITIONED EMERGENCY LIGHT COVER AT SEAT 26C IAW AMM 33-51-11.SDR AALA2020073099004Battery Pack · no testAIRCRAFT WAS GROUNDED, L3 DOOR EMERGENCY BATTERY PACK M33405 FAILED TO TEST. REPLACED EMERGENCY LIGHT BATTERY PACK AT DOOR 3L IAW 33-51-06.SDR AALA2020073099002Power Supply · no testAIRCRAFT WAS GROUNDED. R3 DOOR EMERGENCY POWER SUPPLY UNIT M33401 FAILED TO TEST. REPLACED EMERGENCY LIGHT POWER SUPPLY ASSEMBLY LOCATED AT DOOR 3R IAW 33-51-06.SDR AALA2020073099001Battery Pack · no testAIRCRAFT WAS GROUNDED, L1 DOOR EMERGENCY BATTERY PACK M33424 FAILED TO TEST. REPLACED THE BATTERY PACK IAW 33-51-06-201.SDR AALA2020073029010Lens · missingAIRCRAFT NOT GROUNDED - EMERGENCY EXIT SIGN MISSING, FIRST CLASS GALLEY DOOR. REPLACED EMERGENCY EXIT SIGN LENS PER AMM 33-20-00, GROUND CHECKS GOOD.SDR SWAA2020072904315Power Supply · inoperativeFIRST AND SECOND EMERGENCY LIGHTS ON BULLNOSE INOPERATIVE. REMOVED AND REPLACED THE POWER SUPPLY IAW AMM 33-51-06.SDR DALA2020072902665Battery Pack · inoperativePASSENGER CABIN FWD LT & RT OVERWING EMERGENCY EXIT IDENTIFIERS SIDE PANE SIGNS INOPERATIVE. REPLACED THE B6-118 BATTERY PACK TRAY IAW WDM 33-51-14 PG 3. 1A.SDR IPXA2020072988358Button · damagedOVERHEAD PANEL EMERGENCY EXIT DISARM LIGHT DAMAGED. REMOVED AND REPLACED OVER HEAD PANEL EMERGENCY EXIT DISARM LIGHT PUSH BUTTON HEAD.SDR AALA2020072700350Battery Pack · no testPER WORK CARD 2341 FOUND EMERGENCY LIGHTS AT AFT GALLEY WALL INOP. REPLACED BATTERY PACK M33409 REF AMM 33-51-06. ALL EMERGENCY LIGHTS CHECK NORMSDR AALA2020072700349Battery Pack · no testPER W/C 2341 FOUND O/H EMERGENCY LIGHTS AT SEATS 17D THROUGH 30D INOPERATIVE. REPLACED THE BATTERY PACK M33408 IAW AMM 33-51-06. SYSTEM OPS CHECKED NORMAL.SDR AALA2020072700348Battery Pack · no testPER WORK CARD 2341 FOUND EMERGENCY LIGHTS INOPERATIVE AT AFT CREW REST AREA WALL. REPLACED BATTERY PACK M33400 REF AMM 33-51-06,ALL EMERGENCY LIGHTS CHECK NORM.SDR AALA2020072700347Battery Pack · no testPER W/C 2341 FOUND EMERGENCY LIGHTS OUT AT 7D-10D SEATS. REPLACED BATTERY PACK IAW AMM 33-51-06. SYSTEM OPS CHKS NORMAL.SDR YENA2020073100407Battery · failedDURING RTS, NOTED EMERGENCY LIGHT SYSTEM TEST FAILS EMER LT BATT (FWD L) FAULT CODE 33500002UT1; R & R FWD LT EMERG. LIGHT POWER UNIT OPS CK GOOD IAW MM 33-50-01.SDR REXA2020073100606Resistor · inoperativeLH OVERWING FWD EMERGENCY LIGHT INOPERATIVE. R & R THE DIODE/RESISTOR IAW CMM 25-28-62 AND WM 91-11-00. OPS CHECKED GOOD.SDR AALA2020073089011Power Supply · inoperativeAIRCRAFT IN BASE MAINTENANCE - EMERGENCY EXIT LIGHT INOP, CABIN RIGHT SIDE (1 EA). REMOVED AND REPLACED EMERGENCY POWER SUPPLY UNIT (EPSU) 12WL PER AMM TASK 33-51-38-400-001-A, AND PERFORMED SATISFACTORY BITE CHECK OF EMERGENCY LIGHT SYSTEM PER AMM 33-51-00.SDR SWAA2020072904129Battery Pack · inoperativeFWD CABIN ALL EMERGENCY LIGHTS POWERED BY M2816 BATTERY PACK WERE INOPERATIVE.SDR IPXA2020072978313Battery Pack · inoperativeCOCKPIT EMERGENCY LIGHTS INOPERATIVE. REPLACED THE BATTERY AND BATTERY PWER SUPLY IAW MM 33-51-07-201 .OPS CHECKED NORMALSDR IPXA2020072978331Light · inoperativeEMERGENCY EXIT LIGHT INOPERATIVE.SDR JJBA202007297004Inverter · inoperativeEMERGENCY LIGHT INOPERATIVE ABOVE SERVICE DOOR. R&R INVERTER #2. OPS CHECK SAT.SDR DXTA2020072703908Light · inoperativeTHE EMERGENCY LIGHTS INOPERATIVE, WITH THE EMER LTS SWITCH IN THE ON POSITION, WHILE CONDUCTING THE POWER ON CHECKLIST.SDR DALA2020072802659Battery Pack · inoperativeDURING INSPECTION FOUND DOOR 4L EMERGENCY LIGHT INOPERATIVE. REPLACED BATTERY PACK OPS NOW OK PER AMM 33-51.SDR SWAA2020072804156Light · missingPASSENGER CABIN EVACUATION STRIP MISSING AT AFT WHEEL CHAIR CLOSET AFT OF SEAT 24ABC. / INSTALLED STRIP PER AMM 33-51-15SDR SWAA2020072803876Lamp · inoperativeRIGHT FWD SERVICE DOOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM 33-51-04.SDR AALA202007289009Lens · unsecureAIRCRAFT WAS NOT GROUNDED: ESCAPE PATH LIGHT RED LENS BELOW FWD CLOSET FELL OFF. RESECURED LIGHT LENS.SDR DALA2020072802654Battery Pack · inoperativeEMERGENCY LIGHTS ARE INOPERATIVE. REPLACED BATTERY PACKS. SYSTEM OPERATION IS NORMAL.SDR SIMA202007287001Bulb · inoperativeRH OVERWING EMERGENCY LIGHT INOPERATIVE. R & R THE OVERWING EMERGENCY LIGHT BULB IAW AMM 33-50-10. OPS CHECKED GOOD.SDR AALA202010299004Battery · no testAIRCRAFT WAS NOT GROUNDED. BATTERY AT WELL UNIT 24 AND 11.4 IS NOT TESTING, PER TASK CARD 2803. REPLACED WELS UNIT BATTERY AT WCU 11.4 (AALA202010279018) AND WCU 24 (AALA202010299004), PER AMM 33-51-07. A SATISFACTORY OPERATIONAL CHECK WAS ACCOMPLISHED.SDR AALA202010279018Battery · no testAIRCRAFT WAS NOT GROUNDED. BATTERY AT WELL UNIT 24 AND 11.4 IS NOT TESTING, PER TASK CARD 2803. REPLACED WELS UNIT BATTERY AT WCU 11.4 (AALA202010279018) AND WCU 24 (AALA202010299004), PER AMM 33-51-07. A SATISFACTORY OPERATIONAL CHECK WAS ACCOMPLISHED.SDR SIMA20200726008Bulb · inoperativeEMERGENCY LIGHT ON CEILING PANEL AT 7A INOP. C/A COMPLETE: REMOVED AND REPLACED BULB ON CEILING PANEL 7A, IAW EMB 145 AMM 33-50-08. CHECKS GOOD.SDR SIMA20200726009Power Supply · not reportedSTD REQ A110 OPS A. REPLACE EPSU CRJ WC 33-002 OR EMB WC 33-700-19 PN: 11-0049 SN: 18369 POS: 2. C/A COMPLETE: PCW BY RECORDS REVIEW AND DVI OF EQUIPMENT INSTALLED ON AIRCRAFT, REF CITRIX (MTX OPS) NRWC 689-DFW-04797 DATED: 07/19/20. FOR R&R OF POS NR 2 EME
Back to JASC 3350