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 CALA2021030100243Lamp · inoperativeLEFT AFT OVERWING EXTERIOR EMERGENCY EXIT LIGHT INOP. RE-LAMPED LIGHT REF MM 33-51-04. OPS CK OK.SDR SWAA2021030452636Battery · inoperativeEMERGENCY LIGHTS AT FWD ENTRY DOOR LINING & FWD GALLEY DO NOT ILLUMINATE / REPLACED FWD EMERGENCY BATTERY M1674 AND PERFORMED SATISFACTORY TEST PER AMM 33-51-06-960-805.SDR SWAA2021030452637Battery · inoperativeEMERGENCY LIGHTS AT LH OVERWING EMERGENCY EXIT DO NOT ILLUMINATE / REPLACED LT OVERWING EMERGENCY BATTERY M1668 AND PERFORMED SATISFACTORY EMERGENCY LIGHTS TEST PER AMM 33-51-06-960-805SDR SWAA2021030352123Light · inoperativeEMERGENCY LIGHT AT ROW 21 DEF INOP /SDR DALA2021030301211Lens · missingSHIP OR3 OVERHEAD EMERGENCY EXIT SIGN LENS COVER MISSING. CORRECTIVE ACTION: REPLACED MISSING LENS COVER. SYSTEM OPERATION IS NORMAL. (LP 7407130)SDR DALA2021030301204Battery Pack · no test(LOG 7519278) DURING EMERGENCY LIGHT CHECK FOUND FWD RIGHT R1 AND 1ST CLASS PAX EMERGENCY LIGHTS INOPERATIVE. R+R FWD RIGHT EMERGENCY LIGHT BATTERY PER B737 AMM 33-51.SDR AALA202103019014Light · brokenAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT BROKEN AT FWD CLOSET 1L. REPLACED LIGHT WITH NEW IAW AMM 33-51-00, OPS CHECK GOOD.SDR SWAA2021030251976Lamp · inoperativePASSENGER CABIN; EMERGENCY AREA LIGHT AT SEAT ROW 17 ABC IS OUT. / REPLACED LAMP ON EMERGENCY AREA LIGHT AT SEAT ROW 17ABC IAW AMM 33-51-03-960-801 LIGHT CHECKS GOOD 'A' TAG D90421SDR SWAA2021030252000Light · inoperativeEXTERIOR EMER. EXIT LIGHT AFT OF R2 DOOR INOP. / RELAMPED IAW AMM 33-51-04. OPS CHECK GOOD.SDR SWAA2021030252013Cover · looseEMERGENCY EXIT LIGHT COVER LOOSE / REATTACHED EMERGENCY EXIT LIGHT COVER PER AMM 33-51-01SDR N6WA2021022702Light · inoperativeCEILING EMERGENCY LIGHT AT ROW 17 INOP. AS PER TELECON WITH MX CONTROL DEFERRED CEILING LEVEL EMERGENCY FLOODLIGHT ON DMI OPEN CONTROL NUMBER 70071678 PER MEL 33-51-01-2A CAT CSDR N6WA2021022701Bulb · inoperative2 LIGHTS OUT IN EMER EXIT NEXT TO SERVICE DOOR, R&R EMERGENCY LIGHT BULBS IAW CRJ AMM 33-51-05. OPS CHECK GOOD.SDR 2DYA20210227001Switch · stuckEMERGENCY LIGHT SWITCH STICKING OPEN AND DRAINING THE BATTERY PACKS. REMOVED AND REPLACED EMERGENCY LT SW, OPS CHECK NORMAL, AIRCRAFT RETURN TO SERVICES.SDR QXEA2021030100089Light · looseFLOOR EMER LIGHTING LOOSE IN FRONT OF SEAT 2DE. REMOVED FROM SERVICE. RESECURED EMERGENCY FLOOR LIGHTING STRIP. NO OTHER DEFECTS NOTED. AIRCRAFT RETURNED TO SERVICE.SDR DALA2021030101159Sign · misinstalledSHIP 1813 MAINTENANCE FOUND LLCR EXIT SIGN NOT INSTALLED PER MOD PAPER WORK SPECIFICATIONS. CORRECTIVE ACTION: REPLACED EMERGENCY LIGHT SIGN ASSEMBLY UNDER THE STAIRS. SYSTEM OPERATION IS NORMAL. (LP 7621254)SDR DALA2021030101158Sign · inoperativeSHIP 1813 MAINTENANCE FOUND EXIT SIGN ON AFT LOWER CREST WALL INOPERATIVE AND REPLACED SIGN ASSEMBLY. (LP 7621253)SDR SIMA20210227001Bulb · inoperativeR/H EXTERIOR EMEREGNCY LIGHT FORWARD OF WING INOP-C/A-RAR BULB PER AMM 33-50-10.SDR SIMA20210227003Battery Pack · no testALL FOUR EMERGENCY LIGHT BATTERY PACKS FAIL FUNCTIONAL CHECK-C/A-REMOVED AND REPLACED ALL 4 EMERGENCY LIGHT POWER UNITS IAW EMB 175 AMM 33-50-01SDR I5EA2021022700009Charger · no testEMERGENCY BATTERY CHARGER AT M1672 INOP. REMOVED AND REPLACED EMERGENCY BATTERY CHARGER M1672 AT STA.973 WITH SERVICEABLE UNIT IAW B-737-300 AMM 33-51-51. TEST GOOD.SDR SWAA2021031151954Power Supply · inoperativeEMERGENCY LIGHTS SIGN INOP AT L/H OVERWING EXIT DOOR ( INTERIOR ). / REMOVED AND REPLACED FUSE AT POWER SUPPLY M1663 AS PER B737 AMM 33-51-06-960-804. PERFORMED OPERATIONAL CHECK NORMALSDR SWAA2021030251753Battery Pack · no testFAILED BATTERY PACK CAPICITY CHECK 33-51-06. POSITIONS FWD L/HRH; MID CABIN LH; AFT CABIN RH / REMOVED AND REPLACED BATTERIES PER MM 33-51-06SDR SWAA2021030251879Lens · looseEMERGENCY EXIT LENS AT OVERWING EXIT LEFT SIDE CAME LOOSE. REMOVED AND REPLACED EMERGENCY EXIT LIGHT ASSY AT LH OVERWING EXIT IAW AMM 33-51-04; OPS TEST GOOD.SDR SWAA2021030251585Light · inoperativeWINDOW LIGHT INOP RH EMERGENCY OVERWING EXIT. ( CABIN INTERIOR ILLUM BOEING SKY INTERIOR PHOTOLUMINESCENT ) /SDR DALA2021030101176Light · inoperativeEMERGENCY LIGHT OUT AT 32ABC - SEAT MOUNTED WHITE LIGHT. ALL OTHERS OP NORMAL. C/W TIME LIMITED REPAIR PER ERA 590321-14 REV ORIG FWD TO MEL/ PLAC 33-50-03B WIRES CAPPED AND STOWED AT SEAT DISCONNECT. ASSOCIATED ER/A 59-032114 ADDED FOR AC 3094 INSTALLED NEW CSDR MYWA202103020001Bulb · inoperativeDURING P/T FOUND L1 DOOR EXTERIOR EMERGENCY LIGHT INOP.SDR ASAA2021022634202Bulb · inoperativeL1 SLIDE LIGHT INOP. GROUNDED - YES. RELAMPED.OPS CHECK GOOD IAW B737-800 AMM 33-51-04.SDR AALA202102279008Power Supply · no testAIRCRAFT WAS GROUNDED: EPSU ON LACATION 11WL FAILED EMERGENCY LIGHT TEST. REMOVED AND REPLACED EPSU ON 11WL PER AMM 33-51-38-400.SDR AALA202102279001Power Supply · no testAIRCRAFT WAS GROUNDED: EPSU ON LOCATION 12 WL FAILED EMERGENCY LIGHT TEST. REMOVED AND REPLACED EPSU ON 12WL PER AMM 33-51-38-400.SDR GTIA2021030135615Battery · no testEPSU BATTERY FAILED OPS CHECK. SDR CREATED.-REVIEWED LTPR NRI 5001055828-0010 AND EPSU 10WL BATTERY HAS BEEN REPLACED IAW AMM 33-51-38-400-002-A REV 68 OPS CHECK GOODSDR HALA2021030100022Battery Pack · inoperativeEMER EQ - CATWALK EMERGENCY EXIT FLOOR LIGHTS INOP. // REMOVED & REPLACED EMERGENCY BATTERY PER AMM 33-51-03, OPS CHECK GOODSDR DALA2021030101160Sign · inoperativeSHIP 1815 EMERGENCY LIGHT R2 AFT DOOR INOPERATIVE. MAINTENANCE REPLACED THE PASSENGER EXIT SIGN ASSEMBLY. (LP 7595476)SDR F3LA2021030100016Battery · dischargedLP 145547 ITEMS 2 & 3 UPON AIRCRAFT INSPECTION THE EMERGENCY POWER SUPPLY UNITS 11WL & 12WL (EPSU BATTERIES) FAILED TO TEST
CORRECTIVE ACTION: REMOVED AND REPLACED EPSU BATTERIES 11WL & 12WL -TEST OK REF AMM 33-51-38-04 CONF 00SDR JJBA20210301036Light · inoperativeBOTH LH SIDE EXTERNAL EMERGENCY LIGHTS INOPERATIVE. R&R LH SIDE EXTERNAL EMERGENCY LIGHTS. OPS CHECK SAT.SDR SIMA20210226001Charger · inoperativeLH AND RH OVER WING EMERGENCY EXIT LIGHTS INOP-C/A-RAR #4 BATTERY AND CHARGER ASSEMBLY IAW W/C 33-700-19. OPC GOOD IAW W/C 33-700-17SDR I5EA2021022600008Battery Pack · no testCENTER AISLE EMERGENCY EXIT SIGN INOP. REMOVED AND REPLACED EMERGENCY EXIT CENTER AISLE STA 629 BATTERY PACK AND OPS CHECK GOOD IAW B-737-400 AMM 33-51-51.SDR SWAA2021030251924Battery · inoperativeEMERGENCY LIGHTS COMMON TO M1668 ARE INOP. / REMOVED AND INSTALLED BATTERY AS PER AMM 33-51-06-960-805 STEP 4.D.(1);(2);(3);(4) LEAD 821 29FEB21 INSP 231 27FEB21 PERFORMED SATISFACTORY M1668 EMERGENCY LIGHTS TEST PER AMM 33-51-06-960-805.SDR N6WA2021022502Light · inoperativeEMER LIGHTS OVERHEAD SECOND FWD LIGHT INOP. R AND R SECOND FWD FLOOD LIGHT IAW CRJ 550 AMM 33-51-09 OPS CHECK SAT AT THIS TIME.SDR YENA2021030100131Battery · failed(FORMERLY YENA2021022600128. REFILED DUE TO DUPLICATE SEQUENCE NUMBER) FLT 1696, SJU-MCO. AFT L EPSU BATT FAILED TEST ; R & R AFT L EPSU BATT OPS TEST OK REF AMM 33-51-00.SDR SWAA2021030151198Bulb · inoperativeLEFT OVERWING EMERGENCE LIGHT ABOVE DOOR LIGHT HAS AFT BULB INOP. / RELAMPED LEFT OVERWING EMERGECNY LIGHT ABOVE DOOR PER AMM 33-51-03; OPS CHECK O.K.SDR SWAA2021030151534Battery Pack · no testEMERGENCY LIGHT BATTERY PACKS AT LOCATIONS M01669 AND M01672 FAILED CAPACITY CHECK / REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACKS AT LOCATIONS M01669 AND M01672 PER AMM 33-51-06SDR SWAA2021030151222Lens · missingFORWARD SERVICE DOOR EMER LIGHT LENS MISSING DIRECTIONAL ARROW / REPLACED LENS ASSY REF B737 AMM 33-51-01SDR SWAA2021030152052Lens · missingREAR LENS COVER ON AISLE EXIT SIGN OFF / INSTALLED R5EAR LENS COVER ON EMERGENCY EXIT AISLE SIGN IAW AMM 33-51-01SDR AALA202102269011Power Supply · no testAIRCRAFT WAS GROUNDED: ACCOMPLISHED CIDS TEST PER PS CHECK. FOUND BATTERY/EPSU (10WL) FORWARD MESSAGE. REMOVED AND REPLACED EPSU 10WL IAW AMM 33-51-38.SDR DALA2021030101173Light · inoperativeSHIP 5653 AISLE CEILING EMERGENCY LIGHTS ARE INOPERATIVE AT 1DC AND 29ABC. MAINTENANCE FOUND LOOSE GROUND WIRE AT GREEN BLOCK 12 AND RESECURED AT 29ABC AND RELAMPED EMERGENCY LIGHTS AT 1DC. SYSTEM OPERATION IS NORMAL. (LP 7201661)SDR DALA2021030101127Lens · missingSHIP 685 EXIT SIGN AT L2 DOOR FELL OFF. MAINTENANCE RE-SECURED SIGN. SYSTEM OPERATION IS NORMAL. (LP 7489084)SDR AALA202103019012Sign · dislodgedAIRCRAFT WAS NOT GROUNDED: 3L EXIT SIGN FELL. MOUNTED EXIT SIGN AT 3L PER AMM 33-51-01.SDR DXTA022520213864Battery Pack · defectiveCABIN EMERGENCY LIGHTS PAX ADVISED CABIN EMERGENCY LIGHTS WERE FLICKERING. ITEM PREVIOUSLY WORKED BY GAMA PBI "GAINED ACCESS TO THE CABIN APPLIED POWER AND FOUND NO FAULTS WITH THE EMER LIGHTS. WHILE I WAS THERE THE CREW CAME BY AND ADVISED THEY THOUGHT THE SDR AALA202102269014Lens · missingAIRCRAFT WAS NOT GROUNDED: ESCAPE PATH LIGHT LENS MISSING AT LOWER GALLEY CLOSET. REPLACED LIGHT ASSEMBLY WITH NEW IAW AMM 33-51-05, OPS CHECK GOOD.SDR N6WA2021022601Lamp · inoperativeEMER LIGHTS OVERHEAD SECOND FWD LIGHT INOP. R AND R SECOND FWD FLOOD LIGHT IAW CRJ 550 AMM 33-51-09 OPS CHECK SAT AT THIS TIME.SDR AALA202102269015Lens · missingAIRCRAFT IN BASE MAINTENANCE: L4 DOOR EXIT SIGN LENS IS MISSING. INSTALLED EXIT SIGN LENS AT L4 DOOR PER AMM 33-51-01.
Back to JASC 3350