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 QXEA2019021900080Light · missingGLOW STRIP MISSING (4A). REMOVED FROM SERVICE. REPLACED MISSING PHOTOLUMINESCENT INDICATOR STRIP LIGHT @ ROW 4A. REF E-175 AMM TASK 33-50-21-000-801-A AND 33-50-21-400-801-A. OPS CHECK GOOD. AIRCRAFT RETURNED TO SERVICE.SDR SWAA2019040131222Cover · brokenAFT LAV EXIT LIGHT COVER BROKEN. R&R LIGHT ASSEMBLY IAW AMM.SDR YENA201902180087Epsu · failedDURING HEAVY MAINTENANCE, EPSU BATTERY 15WL FAILED TEST, REF LHT NR 5000852972-0010. REMOVED EPSU WITH LOW VOLTAGE IAW AMM 33-51-38-000-001-A REV 76. INSTALLED NEW EPSU IAW AMM 33-51-38-400-001-A REV 76 OPS TEST OK IAW AMM 33-51-38-740-050-B REV 76.SDR YENA201902180086Epsu · failedDURING HEAVY MAINTENANCE, EPSU BATTERY 14WL FAILED TEST, REF LHT NR 5000852972-0010. REMOVED EPSU WITH LOW VOLTAGE IAW AMM 33-51-38-000-001-A REV 76. INSTALLED NEW EPSU IAW AMM 33-51-38-400-001-A REV 76 OPS TEST OK IAW AMM 33-51-38-740-050-B REV 76.SDR YENA201902180085Epsu · failedDURING HEAVY MAINTENANCE, EPSU BATTERY 13WL FAILED TEST, REF LHT NR 5000852972-0010. REMOVED EPSU WITH LOW VOLTAGE IAW AMM 33-51-38-000-001-A REV 76. INSTALLED NEW EPSU IAW AMM 33-51-38-400-001-A REV 76. OPS TEST OK IAW AMM 33-51-38-740-050-B REV 76.SDR YENA201902228084Battery · no testDURING HEAVY MAINTENANCE, EPSU BATTERY 12WL FAILED TEST; REF LHT NR 5000852972-0010 REMOVED EPSU WITH LOW VOLTAGE IAW AMM 33-51-38-000-001-A REV 76. INSTALLED NEW EPSU IAW AMM 33-51-38-400-001-A REV 76 OPS TEST OK IAW AMM 33-51-38-740-050-B REV 76SDR SWAA2019022229938Charger · inoperativeR1 DOOR ABOVE EMERGENCY LIGHT INOP. R&R BATTERY PACK CHARGER ASSEMBLY IAW AMM.SDR AALA201902220001Battery Pack · no testCIDS TEST FAILED, L1 EMERGENCY BATTERY PACK. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-51-00.SDR YENA201902228082Battery · failedFT # 225, EMERGENCY LIGHT TEST FAILED. REMOVED & REPLACED EMERGENCY LIGHT BATTERY AT 11WL PER AMM 33-51-38.SDR SWAA2019022029830Fuse · failedLT OVERWING EXIT SIDEWALL LIGHT FAILED TO ILLUMINATE. R&R FUSE IAW AMM.SDR FDEA201902180444Battery · lowEMER LT BAT 1 LO. RELEASED FOR SERVICE PER MEL 33-50-02 CATEGORY C EXPIRATION : 28FEB19. MEL 33-50-02: EMER LIGHTS - INOP.SDR DALA2019021901061Battery · dischargedEMERGENCY EXIT LIGHTS AT DOOR R2 AND L2 ARE INOPERATIVE. REPLACED BATTERY AT M121 R2 JUMP SEAT. SYSTEM OPERATION IS NORMAL.SDR AALA20190218004Sign · damagedAIRCRAFT WAS NOT GROUNDED: R1 DOOR LOWER AFT EXIT SIGN WAS DAMAGED. MAINTENANCE REPLACED SIGN PER AMM 33-51-01.SDR QXEA2019021800073Light · looseEMERGENCY FLOOR STRIP COMING UP IN 1 A/B. REMOVED FROM SERVICE. RE-SECURED PHOTOILLUMINESCENT STRIP AS REQUIRED. NO FURTHER DEFECTS NOTED. AIRCRAFT RETURNED TO SERVICE.SDR SWAA2019022629989Battery Pack · faultyLIGHTS CONNECTED TO M1674 EMERGENCY LIGHT BATTERY PACK FAULTY. R&R BATTERY PACK PER AMM.SDR DALA2019022001103Shroud · defectiveEMERGENCY ESCAPE PATH LIGHTS AT SEAT 33B ARE INOPERATIVE. REPLACED EMERGENCY LIGHT SHROUD ASSEMBLY. SYSTEM OPERATION IS NORMAL.SDR DALA2019022191096Battery Pack · no testDURING TEST, FOUND EMERGENCY LTS BATTERY PACK AT M1670 INOPERATIVE. RPLD BATTERY PACK PER AMM 33-51. OP CKS GOOD.SDR ASAA2019021728206Sign · unsecureTHE EXIT SIGN NEAR R-2 DOOR NEEDS TO BE REPLACED. IT WILL NOT STAY ATTACHED TO THE WALL. GROUNDED - YES. REMOVED AND REPLACED EMER LIGHT BASE ASSY ON R-2 DOOR (LOWER LIGHT ASSY) IAW AMM 33-51-01. OPS CHECK GOOD. OK FOR SERVICE.SDR FDEA201902170443Light · malfunctionedEMER LIGHT TEST ARM WOULD NOT TEST. PERFORMED RESET TO EMERGENCY LIGHT CONTROL C/B G13. OPERATIONAL CHECK OKSDR AALA20190219002Battery · dischargedAIRCRAFT WAS NOT GROUNDED: 13WL BATTERY LOW VOLTAGE. MAINTENANCE REPLACED BATTERY PER MM 25-60-00 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR ASOA2019021974006Light · inoperativeIAH - DURING MAINTENANCE INSPECTION THE R/H EMERGENCY OVERWING EXTERIOR LIGHT WAS FOUND TO BE INOP. MAINTENANCE REMOVED AND REPLACED THE AFFECTED LIGHT ASSEMBLY, OPERATIONALLY TESTED WITH NO DEFECTS, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR SIMA20190217002Light · inoperativeRT EXTERIOR OVERWING EMERGENCY LIGHT INOP. REMOVED AND REPLACED RT EXTERIOR OVERWING EMERGENCY LIGHT LAMP IAW AMM 33-50-10-000-801-A AND 33-50-10-400-801-A. OPS CHECK GOOD.SDR SIMA20190217001Charger · failedFOUND RT EMERGENCY OVER WING LIGHT INOP PER PS-2 CHECK. REMOVED AND REPLACED BATTERY CHARGER FOR BATTERY POWER SUPPLY 4 IAW AMM 33-50-04. OPS CHECK GOODSDR SWAA2019021829683Battery Pack · dischargedFORWARD RT EMERGENCY EXIT LIGHT BATTERY PACK INOP. R&R BATTERY PACK PER AMM.SDR AALA201902189002Light · inoperativeFOUND THE EMERGENCY LIGHT INOPERATIVE ON THE RT CLOSET, AFT OF ROW 17. REPLACED THE LIGHT ASSY IAW AMM 33-60-98. OPS CHECKED NORMAL.SDR DALA2019021801021Battery Pack · failedEMERGENCY LOWER LIGHTS WERE FOUND INOPERATIVE AT 21B AND 20CDE. MAINTENANCE FOUND THAT THE BATTERY PACK AT STA 804 HAD FAILED. THE BATTERY PACK WAS REPLACED PER B717 AMM 33-51-18. OPERATIONAL CHECK WAS GOOD. THE AIRCRAFT HAS RETURNED TO SERVICE. (LP #5547384)SDR SIMA20190216004Structure · cracked#8 LT EMERGENCY LIGHT EXTRUSION IS CRACKED. C/A-COMPLETE:INSTALLED NEW EXTRUSION FOR #8 LT EMERGENCY FLOOR LIGHT IAW AMM 33-50-12.SDR SIMA20190216003Light · damagedPCR: BOTH EMERGENCY LIGHT STRIPS IN FRONT OF ROLL DOOR DAMAGED. C/A-COMPLETE:REMOVED AND REPLACED BOTH EMERGENCY LIGHT STRIPS IN FRONT OF ROLL DOOR IAW AMM 30-50-21. OPS CK GOOD.SDR 2DYA2019040421604Battery Pack · dischargedL1 DOOR EMERGENCY LIGHT INOP. REMOVED AND REPLACED BATTERY PACK IAW B767-300 AMM 33-51-07SDR 2DYA2019040426003Battery Pack · dischargedR1 DOOR EMERGENCY LIGHT INOP. REMOVED AND REPLACED BATTERY PACK IAW B767-300 AMM 33-51-07SDR 2DYA2019040421602Battery · dischargedL3 EXIT SIGN INOP. REMOVED AND REPLACED BATTERY PACK L3 EXIT SIGN IAW B767-300 AMM 33-51-07.SDR 2DYA2019040421601Lamp · burned outR3 DOOR EMERGENCY LOWER SIGN INOP. RELAMPED R3 DOOR EMERGENCY LOWER SIGN IAW B767-300 AMM 33-51-09SDR YENA201902201677Battery Pack · no testFT # 610, DUE TO R & R OF L3 OVERWING EMERGENCY ESCAPE SLIDE, OPS TEST OF EMERGENCY LIGHTING SYSTEM REQUIRED. CIDS EPSU SYS OPS TEST FAILS; PER TSM 33-51-00-810-836-A, R & R EPSU 13WL, EPSU BATTERY 13WL, AND EPSU BATTERY 15WL IAW AMM 33-51-38. NO FIX; EPSU OPSSDR YENA201902201676Battery Pack · no testFT # 610, SDQ-JFK. DUE TO R & R OF L3 OVERWING EMERGENCY ESCAPE SLIDE, OPS TEST OF EMERGENCY LIGHTING SYSTEM REQUIRED. CIDS EPSU SYS OPS TEST FAILS; PER TSM 33-51-00-810-836-A, R & R EPSU 13WL, EPSU BATTERY 13WL, AND EPSU BATTERY 15WL IAW AMM 33-51-38. NO FIX;SDR YENA201902201675Epsu · no testFT # 610, SDQ-JFK. DUE TO R & R OF L3 OVERWING EMERGENCY ESCAPE SLIDE, OPS TEST OF EMERGENCY LIGHTING SYSTEM REQUIRED. CIDS EPSU SYS OPS TEST FAILS; PER TSM 33-51-00-810-836-A, R & R EPSU 13WL, EPSU BATTERY 13WL, AND EPSU BATTERY 15WL IAW AMM 33-51-38. NO FIX;SDR ASAA2019021628208Battery Pack · dischargedFOUND THE EMERGENCY EXIT SLIDE LIGHT INOP AT THE RT LOCATION JUST AFT OF THE WING. GROUNDED - YES. RELAMPED REF AMM 33-51-04-960-801. REMOVED & REPLACED BATTERY PACK ASSY REF AMM 33-51-06-960-806 & WDM 33-51-13. OPS CK GOOD.SDR ASAA2019021628207Sign · unsecureEMERGENCY EXIT SIGN FELL FROM CEILING OVER AISLE AT OVERWING EXIT ROW. GROUNDED - YES. REINSTALLED LENS OK FOR SERVICE.SDR AALA20190218001Lens · missingAIRCRAFT WAS NOT GROUNDED: SEAT 11G FORWARD EMERGENCY LIGHT LENS MISSING. MAINTENANCE REPLACED LIGHT PER MM 33-51-00 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR SWAA2019021929797Light · missingAFT LAV EXIT INDICATOR LIGHT ASSEMBLY (L1190) MISSING. INSTALLED LIGHT ASSEMBLY IAW AMM.SDR UIEA2019021903280Light · inoperativeLH DOOR L1853 EMERGENCY LT FOUND INOP(<P>LH DOOR L1853 EMERGENCY LT REPLACED AND TEST NORMAL IAW AMM 33-51-05.</P>)SDR DALA2019021901047Sign · dislodgedSHIP 5636 EMERGENCY EXIT SIGN COVER LOOSE / LOCATIONS:604 / EMERGENCY EXIT SIGN FELL OFF. CORRECTIVE ACTION: REINSTALLED EMERGENCY EXIT LIGHT COVER. (0947539)SDR UIEA2019021903281Light · inoperativeLH DOOR L1854 EMERGENCY LT FOUND INOP(<P>LH DOOR L1854 EMERGENCY LT ASSY REPLACED AND OPERATIONAL TEST PASSED IAW AMM 33-51-05.</P>)SDR SWAA2019021829686Lens · missingCENTER OVERHEAD EMERGENCY EXIT SIGN MISSING. INSTALLED LENS PER MM.SDR SWAA2019021829685Sign · missingRT OVERWING LOWER EMERGENCY EXIT SIGN MISSING. INSTALLED SIGN PER AMM.SDR SWAA2019022029860Sign · looseMID CABIN EMERGENCY EXIT SIGN LOOSE. SECURED SIGN PER AMM.SDR SWAA2019022029840Battery Pack · dischargedEMERGENCY EXIT LIGHT BATTERY PACK (M1673) BATTERY INOP. R&R BATTERY PACK IAW AMM.SDR DALA2019021901066Fuse · blownEMERGENCY SEAT LIGHTS AT 38FT TO 45FT ARE INOPERATIVE. MAINTENANCE FOUND FUSE BLOWN ON BATTERY CHARGER M734 BAD LIGHT SOCKET AT ROW 44FT AND 45FG. REPLACED FUSE AND LIGHT SOCKETS.SDR DALA2019021901059Battery Pack · dischargedEMERGENCY SEAT LIGHTS POWERED BY M6760 ONLY STAYING ON FOR 15 SECONDS. REPLACED BATTERY PACK AND CHARGER. SYSTEM OPERATION IS NORMAL.SDR SWAA2019021929823Light · inoperativeLT OVERWING ESCAPE GROUND ILLUMINATION LIGHT (L547) INOP. RELAMPED LIGHT PER AMM.SDR SWAA2019021929796Light · inoperativeRT OVERWING ESCAPE GROUND ILLUMINATION LIGHT (L548) INOP. RELAMPED LIGHT PER AMM.
Back to JASC 3350