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 AALA2019062659009Battery · inoperativeAIRCRAFT IN BASE VISIT: MAINTENANCE REPORTS BATTERIES 11WL, 12WL,15WL, AND 18WL FAILED EPSU SYSTEM TEST. REPLACED EPSU BATT 11WL, 15WL, 13WL, 18WL IAW AMM 33-51-38. OPS TEST GOOD.SDR SWAA2019062634152Lens · dirtyR/H SIDE FUSELAGE EXTERIOR LIGHT LENS FORWARD OF AFT CARGO BAY DOOR DIRTY. CLEANED LENS IAW AMM.SDR SWAA2019062654141Lamp · inoperativeFORWARD R1 DOOR EMERGENCY EXIT EXTERIOR LIGHT INOP. / RELAMPED LIGHT PER AMM.SDR SWAA2019062654117Lamp · inoperativeR/H OVERWING DOOR EMERGENCY EXIT EXTERIOR GROUND LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2019062654112Lens · detachedR/H EMERGENCY EXIT SIGN COVER ROW POPPED OFF. REATTACHED COVER PER SIP.SDR SWAA2019062654111Lens · missingR/H EXIT ROW LIGHT COVER MISSING AT ROW 14. INSTALLED LENS PER SIP.SDR AALA201906259021Battery Pack · no testAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHTS FAILED TEST ON PS CHECK. MAINTENANCE REPLACED BATTERY PACK 13WL PER MM 33-51-38.SDR AALA201906259014Light · crackedAIRCRAFT WAS NOT GROUNDED: EMERGENCY SEAT MOUNTED LIGHT AT 16ABC WAS CRACKED. MAINTENANCE REPLACED EMERGENCY SEAT MOUNTED LIGHT AT 16ABC PER AMM 33-51-19.SDR AALA201906259008Power Supply · no testAIRCRAFT WAS GROUNDED: L1 DOOR EMERGENCY EXIT SIGN FLOOR LEVEL INOPERATIVE. MAINTENANCE REPLACED POWER SUPPLY ASSEMBLY PER AMM 33-51-06.SDR SIMA201906254004Lamp · inoperativeCOCKPIT OVERHEAD EMERGENCY LIGHT INOPERATIVE. R & R THE COCKPIT OVERHEAD EMERGENCY LIGHT LAMP IAW AMM 33-50-05-000-801 AND 33-50-05-400-801 OPS CHECKED GOOD.SDR DALA2019062503845Battery Pack · malfunctionedROWS 33 TO 37 RT SIDE EMERGENCY LIGHTS WILL NOT SHUT OFF. REMOVED AND REPLACED EMEG BATTERY PACK AT M11648 PER B757 AMM 33-51, OPS CHECKED GOOD.SDR DALA2019062503844Light · malfunctionedEMERGENCY LIGHTS IN CABIN CONTINUE TO COME ON & GO OFF ON CLIMB OUT & DESCENT. PERFORMED OPS CHECKS OF THE EMERGENCY LIGHTS IAW AMM 33-51. NO FAULTS NOTED AT THIS TIME.SDR DALA2019062503834Battery Pack · inoperativeAFT WING PLUG DOOR EXIT SIGNS, LT AND RT, UPPER ARE INOPERATIVE. REMOVED AND REPLACED THE BATTERIES. OPS CHECKED GOOD.SDR DALA2019062403768Lamp · inoperativeDURING INSPECTION FOUND RT OVERWING ESCAPE EMERG. LIGHTS INOPERATIVE. RELAMPED SAME, OPS NML PER B737 AMM 33-51.SDR DALA2019062403761Battery Pack · inoperativeBOTH FWD OVERWING EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED THE BATTERIES AT POWER SUPPLY B5-103. PREFORMED OPS CHECK IAW AMM 33-53. CHECKED OK. OK FOR SERVICE.SDR REXA2019062301022Light · inoperativeTHIS IS SUPPLEMENTAL INFORMATION TO A PRIOR SUBMISSION. PART NUMBER WAS RECEIVED THAT WAS REPLACED AFTER THIS EVENT. LT AFT EMER EXIT EMER LIGHT NOT COMING ON. REMOVED AND REPLACED LIGHT BULB AT LT AFT EXTERIOR EMER LIGHT IAW CMM 33-52-06 OPS TEST ACCOMPLISHEDSDR SWAA2019071134695Fuse · blownLT OVERWING DOOR EMERGENCY EXIT LIGHTS INOPERATIVE. R&R FUSE ON M1668 PER AMM.SDR SWAA2019071034694Fuse · blownRT OVERWING DOOR EMERGENCY EXIT LIGHTS INOPERATIVE. R&R FUSE ON M1669 PER AMMSDR AALA201906259010Light · faultyAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT AT SEAT 11C WOULD NOT WORK. MAINTENANCE REPLACED LIGHT PER AMM 33-51-18.SDR AALA201906249056Power Supply · no testAIRCRAFT WAS NOT GROUNDED: EPSU FAILED SYSTEM TEST. MAINTENANCE REPLACED EPSU 13WL PER TSM 33-51-00-810-836-A.SDR SWAA2019062434015Power Supply · inoperativeR1 DOOR ESCAPE SLIDE EMERGENCY LIGHT INOP. R&R BATTERY POWER SUPPLY ASSEMBLY IAW AMM.SDR HNAA2019062400180Bulb · burned outCEILING EMERGENCY LIGHT AT ROW 12 DOES NOT ILLUMINATE. R & R THE CEILING EMERGENCY LIGHT BULB. OPS CHECKED GOOD.SDR YENA2019062820352Battery Pack · no testDURING HEAVY MAINTENANCE, EPSU BATTERY PACKS 5EA FAILED TEST IAW AMM SUBTASK 33-51-00-710-057-A; REF LHT-BQN NR 5000898562-0010. R & R 5EA IAW AMM 33-51-38-400-001-A. TESTS GOOD. SUPPLEMENTAL INFORMATION TO FOLLOW.SDR YENA2019062820351Power Supply · no testDURING HEAVY MAINTENANCE, EPSU AT LOCATION 15WL FAILED OPS CK THRU MCDU; REMOVED REPLACED EPSU @ MID LEFT 15WL IAW AMM 33-51-38-400-001-A. OPS CKS GOOD. SUPPLEMENTAL INFORMATION TO FOLLOW.SDR YENA2019062720344Power Supply · failedFT # 2167, RH AFT OVERWING EMERGENCY LIGHT INOP; REMOVED AND REPLACED ELPSU # 4 IAW AMM 33-50-01 OPS CHECK NORMAL.SDR YENA2019062620343Battery Pack · failedFT # 391, BOS-TPA. EMERGENCY LIGHT TEST FAILED EPSU BATTERY AT 12WL; REMOVED & REPLACED EMERGENCY LIGHT BATTERY AT EPSU FIN 12WL PER AMM 33-51-38.SDR AALA2019062549025Battery · inoperativeAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS EMERGENCY LIGHT INOPERATIVE @ SECTION DOOR 1L. REMOVED AND REPLACED WIRELESS BATTERY UNIT, DOOR 1L. OPERATIONAL TEST OK IAW AM 33-51-07.SDR R61A2019062520647Circuit Breaker · trippedEMERGENCY LIGHT ON IN ARMED POSITION WITH POWER ON A/C. FOUND EMERGENCY FWD BATTERY CIRCUIT BREAKER POPPED. RESET CIRCUIT BREAKER PER AMM 33-50-00.SDR R61A2019062520646Power Supply · inoperativeEMERGENCY LIGHT INOPERATIVE CEILING AT ROW 15. R & R THE NR 3 BATTERY POWER UNIT IAW AMM 33-50-01.SDR SWAA2019062434027Battery Pack · inoperativeR/H AISLE EMERGENCY LIGHTS INOP OVER ROWS 3 TO ROW 5. R&R BATTERY PACK M1674 AMM.SDR DALA2019062433765Light · inoperativeEMERGENCY LIGHT AFT OF DOOR 2L INOPERATIVE. REPLACED LIGHT ASSEMBLY. LP 5957949SDR IPXA201906243612Battery · inoperativeDURING EMERGENCY LIGHTING TEST EXIT BATTERY 1 LOW MESSAGE SHOWS. R&R NR 1 EMERGENCY LIGHTING BATTERY IAW MM 33-51-01-401 OPS CHECKED NORMAL.SDR HNAA2019062400181Battery Pack · dischargedMID CEILING AFT EMERGENCY LOCATOR SIGN INOP... FIX: TROUBLESHOT WIRES LEADING TO SIGN AND FOUND LOW VOLTAGE. R & R D EMERGENCY BATTERY #300 IAW AMM TASKS 33-50-04-000-801-A AND 33-50-04-400-801-A. OPS CHK GOODSDR MASA2019062201920Flashlight · inoperativeFWD FA FLASHLIGHT LED INOPERATIVE.SDR DALA2019070204004Light · disconnectedTHE CABIN CEILING EMERGENCY LIGHTS AT ROW 1 & 24 ARE INOPERATIVE. ONE LIGHT AT EACH LOCATION IS INOPERATIVE, LIGHTS ARE NOT ADJACENT. EACH WAS RELAMPED, BUT DID NOT CORRECT THE PROBLEM. THE LIGHTS WERE PLACED ON MEL 33-51-01A AND PLACARDS INSTALLED. MAINTENACESDR AALA201906259016Battery · no testAIRCRAFT IN BASE VISIT: MAINTENANCE REPORTS EMERGENCY POWER SUPPLY UNITS 12WL AND 14WL BATTERIES FAILED CIDS1-SYSTEM TEST 1-EPSU SYSTEM TEST IN REFERENCE WITH JOB CARD 26L00005062. REMOVED AND REPLACED 12WL & 14WL EMERGENCY POWER SUPPLY UNIT BATTERIES IAW AMMSDR AALA2019062549042Power Supply · no testAIRCRAFT IN BASE VISIT: MAINTENANCE REPORTS EMERGENCY POWER SUPPLY UNITS 12WL AND 14WL BATTERIES FAILED CIDS1-SYSTEM TEST 1-EPSU SYSTEM TEST IN REFERENCE WITH JOB CARD 26L00005062. REMOVED AND REPLACED 12WL & 14WL EMERGENCY POWER SUPPLY UNIT BATTERIES IN REFESDR AALA2019062549041Power Supply · no testAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS EPSUC (10WL) L FAILED SELF TEST. REMOVED AND REPLACED 10WL EMERGENCY POWER SUPPLY UNIT IAW AMM 33-51-38.SDR DALA2019062513847Battery Pack · no testEPSU BATTERY EMER R 33-51-38 DISPLAYED ON CIDS EPSU SELF-TEST, REPLACED EPSU 12WL BATTERYSDR AALA201906249043Light · brokenAIRCRAFT IN BASE MAINTENANCE: BROKEN ASSEMBLY LIGHT EMERGENCY EXIT ON DOOR FRAME LINING. REPLACED ASSEMBLY LIGHT ON DOOR FRAME LINING PER AMM 33-51-13-400-001-A.SDR DALA2019062513839Battery Pack · inoperativeEMERGENCY LIGHTS INOPERATIVE AT ROWS 11 TO 17 . REMOVED & REPLACED THE BATTERY PACK IAW AMM 33-51.SDR DALA2019062543837Housing · damagedEMERGENCY LIGHTING AT ROW 20DEF WAS DAMAGED. REPLACED THE EMERGENCY LIGHT HOUSING IAW AMM 33-51.SDR AALA201906249024Fuse · faultyAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS EMERGENCY EXIT SIGN LIGHT ABOVE RIGHT ISLE NEXT TO R1 DOOR INOP. MAINTENANCE FOUND FAULTY FUSE ON M33093 PWR SUPPLY REPLACED IAW AMM 33 51-06. ACCOMPLISHED ALL REQ CHECKS NORMAL OF EMERGNCY LIGHTS.SDR AALA201906249027Power Supply · inoperativeAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS EMERGENCY LIGHT INOP AT DOOR 1 AREA CENTER GALLEY. REPLACED POWER SUPPLY ASSY & OPERATIONAL CHECK OK IAW AMM 33-51-06.SDR AALA201906249037Power Supply · inoperativeAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS OPS TEST OF EMERGENCY LIGHT SYS. FAILED EPSU UNIT EMER R. REMOVED AND REPLACED EPSU (12WL)IAW AMM 33-51-38-000-001/400-001.SDR QXEA2019062400254Lamp · inoperativeFWD F/A EMERGENCY SWITCHLIGHT NOT ILLMINATING. REMOVED FROM SERVICE. RELAMPED FWD F/A EMERGENCY "NORMAL" SWITCH LIGHT. LAMP CHECK GOOD. NO FURTHER DEFECTS NOTED. RETURNED TO SERVICE.SDR SIMA201906241002Light · brokenNUMBER 3 EMERGENCY FLOOR LIGHT STRIP WIRE BROKEN. REMOVED AND REPLACED LIGHT ON NUMBER 3 EMERGENCY FLOOR LIGHT STRIPS IAW EMB 145 AMM 33-50-12.SDR SWAA2019062434053Lamp · inoperativeR/H OVERWING EXIT ESCAPE SLIDE LIGHT FORWARD OF AFT CARGO BAY DOOR INOP. R&R LAMP IAW AMM.SDR SWAA2019062434029Cover · out of positionL1 DOOR EMERGENCY EXIT LIGHT LENS HAD ARROW POINTING IN WRONG DIRECTION. INSTALLED COVER PER AMM.SDR SWAA2019062434019Cover · missingR/H OVERWING EXIT SIGN COVER WAS MISSING. INSTALLED NEW COVER PER AMM.
Back to JASC 3350