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 DALA2019120307003Battery Pack · inoperativeTHE EMERGENCY EXIT LIGHTS ABOVE THE AFT DOOR AND IN THE AFT ACCESSORY COMPARTMENT ARE INOPERATIVE. MAINTENANCE REPLACED THE EMERGENCY LIGHT BATTERY PACK REF AMM 33-51. OPERATIONAL CHECK IS GOOD AND THE AIRCRAFT HAS RETURNED TO SERVICE.SDR SWAA2019120939470Lens · brokenL/H OVERWING EXTERNAL EXIT SLIDE LIGHT LENS BROKEN. / REPAIRED LIGHT PER AMM & SRM.SDR SWAA2019120939469Battery Pack · inoperativeEXIT LIGHTS CONNECTED TO M1673 BATTERY PACK INOP. / R&R BATTERY PACK PER AMM.SDR SWAA2019120939468Battery Pack · inoperativeEXIT LIGHTS CONNECTED TO M1670 BATTERY PACK INOP. / R&R M1670 BATTERY PACK PER AMM.SDR SWAA2019120939467Lamp · inoperativeL/H OVERWING SLIDE LIGHT INOP. / RELAMPED LIGHT PER AMM.SDR SWAA2019120659380Connector · inoperativeFORWARD LAV EXIT SIGN INOP. / RECONNECTED CONNECTOR PER WDM & AMM.SDR SWAA2019120659379Lamp · inoperativeFORWARD ENTRY DOOR SLIDE LIGHT INOP. / RELAMPED LIGHT PER AMM.SDR YENA2019120620691Battery Pack · failedFT # 391, BOS-TPA. FWD EMERG LIGHT FIN 10WL FAILED TEST; REMOVED AND REPLACED EMERG LIGHT BATTERY 10WL IAW AMM 33-51-38.SDR AALA2019120549009Battery · no testAIRCRAFT WAS NOT GROUNDED: 15WL ESPU BATTERY FAILED CIDS TEST. MAINTENANCE REPLACED BATTERY PER AMM 33-51-38.SDR DALA2019120537076Sign · detachedEMERGENCY SIGN OVER THE L2 DOOR FELL DOWN. ADJUSTED EMERGENCY EXIT SIGN AND RESECURED.SDR DALA2019120537075Lens · detached(AIRCRAFT 5643, L/P 6157756) EMERGENCY EXIT LIGHT LENSE OVER L2 DOOR CAME OFF. CORRECTIVE ACTION: RESECURED LENSE.SDR ASAA2019120423500Lens · detachedEXIT SIGN AT ROW 17 AISLE OVERHEAD -LENS FELL OFF. GROUNDED - YES. REATTACHED LENS COVER PER B737-800 AMM 33-51-01.SDR SWAA2019120439336Light · inoperativeFLIGHT DECK DOME EMERGENCY LIGHT INOP. / R&R LIGHT PER AMM.SDR ASAA2019120321493Bulb · burned outR/H FWD OVERWING EXIT LIGHT INOP. GROUNDED - YES. RELAMPED R/H FWD OVERWING EXIT SIGN LAMP, OPS CHECK GOOD REF B737-800 AMM 33-51-01.SDR DALA2019120307031Light · malfunctionedA/C 3149. CABIN EMER LIGHTS ILLUMIN INTERMITTENTLY WHILE IN ARM POS. *** CONTRACT MAINTENANCE EVENT - OCM: 221763 *** RESET EMER LIGHTS PER TSM 24-00.SDR AALA201912039020Light · faultyAIRCRAFT IN BASE MAINTENANCE: EMERGENCY EXIT AREA LIGHT ABOVE DOOR 2R INOPERATIVE. RELAMPED EXIT AREA LIGHT AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-06.SDR AALA201912039019Light · faultyAIRCRAFT IN BASE MAINTENANCE: EMERGENCY EXIT AREA LIGHT ABOVE DOOR 2L INOPERATIVE. RELAMPED EXIT AREA LIGHT AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-06.SDR AALA201912039016Fuse · faultyAIRCRAFT IN BASE MAINTENANCE: EMERGENCY SIGN LIGHT AT DOOR 1R INOPERATIVE. REPLACED POWER SUPPLY FUSE AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-06-960-801.SDR SWAA2019120339303Sign · unsecureEMERGING EXIT SIGN IN MID CABIN CEILING FELL DOWN HANGING BY WIRE. / INSTALLED LIGHT ASSEMBLY PER AMM.SDR SWAA2019120339299Cover · missingR/H SIDE OVERWING EXIT SIGN LIGHT COVER AT MISSING. / R&R COVER PER AMM.SDR SWAA2019120339298Lens · missingAIRCRAFT L/H AFT EMERGENCY EXIT ROW OVERWING LOWER EMERGENCY EXIT LIGHT LENS MISSING. / INSTALLED LENS IAW MM.SDR SIMA201912032001Charger · inoperativeAFT PAX EMERGENCY LIGHTS INCLUDING OVER WING EMERGENCY LIGHT INOP-C/A-REMOVED AND REPLACED BATTERY POWER SUPPLY & BATTERY PACK #4 IAW AMM 33-50-04 OPS CHK GOOD. EMERGENCY LIGHTING BATTERY P/N 2013-1A S/N 104912SDR SIMA201912032002Lamp · inoperativeEMERGENCY OVERWING EXIT PSU LIGHT INOP AT SEAT 11A.-C/A-REMOVED AND REPLACED EMERGENCY OVERWING EXIT PSU LIGHT LAMP AT SEAT 11A IAW EMB 140 AMM 33-50-07. OPC GOODSDR SIMA201912032003Battery Pack · inoperativeDURING PS-1 CHECK FOUND MULTIPLE EMERGENCY LIGHTS OUT NEAR CENTER FUSELAGE.-C/A-REMOVED AND REPLACED #3 EMERGENCY LIGHT BATTERY AND CHARGER ASSEMBLY IAW EMB 145 W/C 33-700-19. OPS CHECK GOOD. BATTERY CHARGER ASSY P/N 11-0049 S/N 12788SDR CALA2019120302140Light · crackedTHE FLOOR PROXIMITY LT ON OFCR L/H AFT LOWER ATTACHMENT WAS CRAC KED, REF NON-ROUTINE NO.9491250, ORIGINATED BY EMP V905459. PERFOMRED BY EMP V905459, REPLACED THE FLOOR PROXIMITY LT ON OFC R L/H AFT LOWER ATTACHMENT, PERFORMED OPERATIONAL TEST OF EMERGE NCY LSDR DALA2019120206968Power Supply · inoperativeWORKING SERVICE CHECK FOUND EMERGENCY LIGHT (L1 EXIT, R1 EXIT AND FIRST CLASS LIGHT) INOP. REMOVED AND REPLACED EMERGENCY POWER SUPPLY B5 -211 AND BATTERY ASSY PER MD88 AMM 33-53 OPS TEST GOOD. (LP6030148)SDR SWAA2020010340142Lens · crackedL/H CABIN OVERHEAD EMERGENCY LIGHT LENS CRACKED AT ROW 1. / R&R LENS PER AMM.SDR YENA2019120510690Battery Pack · no testDURING HEAVY MAINTENANCE, FAULT FWD SERVICE DOOR ELPU ON FWD AND CENTER RH POSITION; REF AEROMAN NR WO 2019-243/1 WCC 2019-366998 REMOVED AND REPLACED ELPU AT THE FWD SERVICE DOOR AND CENTER RH POSITION IAW E190 AMM 33-50-01-400-801-A AND PERFORMED OPERATIONALSDR AALA2019120429003Battery Pack · no testAIRCRAFT WAS NOT GROUNDED: EPAS BATTERY PACK AT DOOR 3R INOPERABLE. MAINTENANCE REPLACED EPAS BATTERY PACK PER AMM 52-11-20.SDR ASAA2019120311494Lens · detachedF.A. REPORTS: "EXIT SIGN" ABOVE L2 DOOR HAD COME OFF. GROUNDED - YES. INSTALLED EXIT SIGN LENS ABOVE L2 DOOR.SDR AALA201912039018Battery Pack · no testAIRCRAFT IN BASE MAINTENANCE: EMERGENCY SIGN LIGHT AT DOOR 4R INOPERATIVE. REPLACED BATTERY PACK AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-06.SDR AALA201912039017Fuse · faultyAIRCRAFT IN BASE MAINTENANCE: EMERGENCY SIGN LIGHT AT DOOR 4L INOPERATIVE. REPLACED POWER SUPPLY FUSE AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-06.SDR AALA201912039015Power Supply · no testAIRCRAFT IN BASE MAINTENANCE: EMERGENCY SIGN AT DOOR 1L INOPERATIVE. REPLACED POWER SUPPLY ASSEMBLY (M33093) AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-06.SDR AALA201912039014Power Supply · no testAIRCRAFT IN BASE MAINTENANCE: FLOOR PROXIMITY EMERGENCY LIGHTS FROM SEAT 7D TO 10D INOPERATIVE. REPLACED POWER SUPPLY ASSEMBLY AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-06.SDR SWAA2019120339307Light · inoperativeR2 DOOR EMERGENCY DOORWAY LIGHT ONE BULB INOP. / R&R LIGHT IAW AMM.SDR DALA2019120327027Light · broken(AIRCRAFT 5812, L/P 6680852) FOUND EMER. ESCAPE PATH LIGHT AT PAX SEAT 36D BROKEN. CORRECTIVE ACTION: R/R EMER. ESCAPE PATH LIGHT AT PAX SEAT 36D PER B757 AMM 33-51.SDR DALA2019120327025Cover · missing(AIRCRAFT 5815, L/P 6320711) L4 DOOR EMERGENCY EXIT LIGHT TEST BUTTON MISSING COVER. CORRECTIVE ACTION: REINSTALLED COVER.SDR QXEA2019120200435Guard · brokenFA EMERGENCY LIGHT SWITCH GUARD IS BROKEN. REMOVED FROM SERVICE. FOUND PIN DETACHED FROM RECEPTACLE FOR THE SWITCH GUARD @ FA EMERGENCY LIGHT SWITCH. RE SECURED PIN TO RECEPTACLE AS NEEDED NO FURTHER DEFECTS NOTED. RETURNED TO SERVICE.SDR AALA201912029023Light · inoperativeAIRCRAFT IN BASE MAINTENANCE: DOOR 2L SLIDE EXTERIOR EMERGENCY LIGHT INOPERATIVE. MAINTENANCE SECURED/RELAMPED DOOR SLIDE LIGHT PER AMM 33-51-04-960-801.SDR AALA201912029022Light · inoperativeAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHT A CEILING BETWEEN SEAT 17AC AND 17D INOPERATIVE. MAINTENANCE SECURED/RELAMPED EMERGENCY LIGHT AT CEILING BETWEEN 17AC AND 17D PER AMM 33-51-03-906-801 AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-03.SDR IPXA2019120219562Lamp · inoperativeINSPECTION TYPE:NACEILING EMERGENCY LIGHT INOP AT UPPER DECK , JUST FWD OF SUPERNUMERARY SEATS.RELAMPED CEILING EMERGENCY LIGHT AS REQUIRED REF: MM 33 51 07. OPS CHECK GOOD.SDR SWAA2019120239287Light · missingL1 DOOR EXTERIOR EMERGENCY EXIT LIGHT ADJACENT TO MISSING SCREW. / SECURED LIGHT IAW SIP.SDR SWAA2019120239256Light · inoperativeL2 DOOR EMERGENCY LIGHT INOP (EXTERIOR). / RELAMPED LIGHT IAW AMM.SDR SWAA2019120239230Sign · brokenAFT GALLEY OVERHEAD EMERGENCY EXIT SIGN BROKEN CLEAN OFF CEILING. / R&R SIGN PER MM.SDR F3LA201912020146Power Supply · inoperativeLP 1210697 DISCREPANCY ITEM 2-- CCR- DOOR 2R EXIT LIGHT IS NOT TURNING ON .. CORRECTIVE ACTION -- REMOVED AND REPLACED EPSU 14WL IAW AMM 35-51-38-000-001-A AND 35-51-38-400-001-A OPS CHECKS OK . AIRCRAFT OK FOR SERVICESDR WX0A2019120273441Battery Pack · inoperativeDURING EMERGENCY LIGHT TEST FOUND EMERGENCY BATTERY PACK 12WL INOP / "SDR REXA2019120211715Battery · dischargedEMER LGTS BATTERY DEPLETED
RECHARGED BATTERY WITH AIRCRAFT POWER IAW CMM 25-60-03 FOR 6 HOURS PERFORMED OPS TEST OF THE EMREGENCY LIGHTS IAW AMM 33-51-04 PERFORMED OPS TEST OF THE BATTERY PACK/CHARGER ASSY IAW AMM 33-51-00 OPS TEST PASSED A/C GOOD FOR SVCSDR AALA2019120319012Power Supply · no testAIRCRAFT WAS GROUNDED: EMERGENCY LIGHTING OPERATIONS CHECK NORMAL, EMERGENCY POWER SUPPLY UNIT 10WL FORWARD LEFT FAILED BITE TEST PER MM 33-51-00. MAINTENANCE REPLACED EMERGENCY POWER SUPPLY UNIT PER AMM 33-51-38-400-001.SDR DALA2019120327029Sign · loose(AIRCRAFT 655, L/P 6373706) EMERGENCY EXIT SIGN ABOVE DOOR 2R LOOSE/FALLING OFF. CORRECTIVE ACTION: SECURED EXIT SIGN ON 2R DOOR.SDR DALA2019120327028Cover · loose(AIRCRAFT 655, L/P 1380411) EMERGENCY EXIT SIGN COVER LOOSE / LOCATIONS: 2R. CORRECTIVE ACTION: SECURED LENS COVER, OP'S. CK. GOOD.
Back to JASC 3350