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 YENA2019121160694Battery Pack · failedFT #20, SAN-BOS. EMERG LIGHT BATTERIES OVER DOOR 3L AND 3R (12WL AND 11WL) NEED TO BE REPLACED; R & R EMERGENCY LIGHT BATTERIES 12WL & 11WL PER A320 AMM 33-51-38, OPS CHECK SATISFACTORY.SDR HALA2019121067148Sign · looseDOOR 3R OVERHEAD EXIT SIGN AFT PANEL MISSING. SECURED DOOR 3R OVERHEAD EXIT SIGN AFT PANEL.SDR AALA201912099023Relay · failedAIRCRAFT IN BASE VISIT: MAINTENANCE REPORTS ESPU FAILED TO TEST 10WL. REMOVED AND REPLACED 10WL ESPU AND BATTERY IAW AMM 33-51-38. NO HELP. REMOVED AND REPLACED RELAY 106RH, OPS CHECK GOOD.SDR AALA201912099024Battery · inoperativeAIRCRAFT IN BAST VISIT: MAINTENANCE REPORTS ESPU BATTERY FAILED TEST AT 12WL. REMOVED AND REPLACED BATTERY AT 12WL ESPU IAW 33-51-38. OPS CHECKS GOOD.SDR AALA201912099012Light · missingAIRCRAFT WAS NOT GROUNDED: EXIT MARKER LIGHT AT L1 DOOR MISSING. MAINTENANCE REPLACED EXIT SIGN LIGHT PER AMM 33-51-01.SDR SWAA2019120939472Light · inoperativeL/H AISLE EMERGENCY LIGHTS INOP BETWEEN ROWS 1 TO ROW 4. / R&R LIGHT PER AMM.SDR SWAA2019120939471Bulb · inoperativeR/H OVERWING EXIT CUTOUT EMERGENCY DOOR WAY LIGHT, AFT BULB INOP. / R&R BULB IAW AMM.SDR SWAA2019120939434Light · inoperativeL/H INTERIOR EMERGENCY AISLE LIGHT INOP AT ROW 6. / RELAMPED LIGHT PER AMM.SDR N6WA20191209601Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 14 INOP. DEFERRED OVERHEAD EMR FLOOD LIGHT AT ROW 14 PER MEL 33-51-01B CAT C.SDR PNSA201912090601Light · brokenEMERGENCY TRACK LIGHTING STRIP FWD LEFT SIDE BROKEN - STRIP WAS NOT BROKEN, MX RE-ATTACHED STRIP, OPS CHECKED GOOD.SDR DALA2019120967190Sign · detached(AIRCRAFT 5812, L/P 1389085) EMERGENCY EXIT SIGN COVER LOOSE. CORRECTIVE ACTION: REATTACHED FALLEN EXIT SIGN NEAR 3C DOOR.SDR DALA2019120907187Cover · missing(AIRCRAFT 6808, L/P 6706034) EMERG DOOR LIGHT MISSING FROM OVERHEAD PANEL. CORRECTIVE ACTION: FOUND EMERG LIGHT COVER ON CLEANERS VACUUM. COVER RE-ATTACHED AND SECURED.SDR DALA2019120907185Power Supply · inoperative(AIRCRAFT 5801, L/P 6751213) EMER LIGHTS OT SEATS RT. 1,2,3 INOP. CORRECTIVE ACTION: REPLACED POWER SUPPLY M00371 BATTERY.SDR DALA2019120907184Battery Pack · inoperative(AIRCRAFT 5801, L/P 6751212) EMER LIGHTS AT BULLNOSE ROWS 17, 19, 20, 21 INOP. CORRECTIVE ACTION: REPLACED BATTERY AND M11486 POWER SUPPLY.SDR CALA2019120702159Battery Pack · inoperativeOVERWING ESCAPE LEFT EMER LIGHT BATTERY NEEDS REPLACEMENT - WILL NOT CHARGE REMOVED & REPLACED OVERWIGN ESCAPE LEFT EMER LIGHT BATTERY IAW B 737 AMM 33-51-06-960-805, SUBTASK 33-51-06-710-004.SDR CALA2019120702158Battery Pack · inoperativeFWD PASSENGER DOOR EMER LIGHT BATTERY NEEDS REPLACEMENT WILL NOT CHARGE REMOVED & REPLACED FWD PASSENGER DOOR EMER LIGHT BATTERY IAW B73 7 AMM 33-51-06-960-805 SUBTASK 33-51-06-710-004.SDR CALA2019120702157Battery Pack · inoperativeAFT PASSENGER DOOR EMER LIGHT BATTERY NEEDS REPLACEMENT - WILL N OT CHARGE REMOVED & REPLACED AFT PASSENGER DOOR EMER LIGHT BATTERY IAW B73 7 AMM 33-51-06-960-805, SUBTASK 33-51-06-710-004.SDR CALA2019120702156Battery Pack · inoperativeAFT PASSENGER DOOR EMER LIGHT BATTERY NEEDS REPLACEMENT - WILL N OT CHARGE REMOVED & REPLACED AFT PASSENGER DOOR EMER LIGHT BATTERY IAW B73 7 AMM 33-51-06-960-805, SUBTASK 33-51-06-710-004. DATA WAS TRANS CRIBED FROM PAPER DOC UAL NR 9724934 WORK ACP BY MECH VSDR CALA2019120702155Battery Pack · inoperativeOVERWING ESCAPE RT EMER LIGHT BATTERY NEEDS REPLACEMENT - WILL N OT CHARGE REMOVED & REPLACED OVERWING ESCAPE EMER LIGHT BATTERY (RIGHT) IA W B737 AMM 33-51-06-960-805, SUBTASK 33-51-06-710-004. DATA WAS TRANSCRIBED FROM PAPER DOC UAL NR 6724933 WORK ACP BY MESDR CALA2019120702154Battery Pack · inoperativeFWD PAX DOOR EMER LIGHT BATTERY NEEDS REPLACEMENT-WILL NOT CHARG E REMOVED AND REPLACED FWD PASSENGER DOOR EMR LIGHT BATTERY IAW B7 37 AMM 33-51-06-960-805 SUBTASK 33-51-06-710-004. DATA WAS TRANS CRIBED FROM PAPER DOC UAL NR 6724938 WORK ACP BY MECH V915689 ISDR R61A201912061354Battery · inoperativeRIGHT HAND SERVICE DOOR EMERGENCY LIGHT BATTERY INOP. R&R RIGHT HAND SERVICE DOOR EMERGENCY LIGHT BATTERY IAW AMM 33-50-01.SDR DALA2019121267246Fuse · blownLEFT & RIGHT OVERWING EMERGENCY LIGHTS INOPERATIVE. DURING FUNCTIONAL CHECK FLIGHT. FOUND BLOWN FUSES AND REPLACED.SDR SWAA2019120939436Cover · detachedL/H EMERGENCY LIGHT COVER FELL OFF AT ROW 14. / SECURED COVER PER SIP.SDR QXEA2019120900453Light · inoperativeFLOOR PATCH STRIP BY ROW 1 NOT ILLUMINATED. REPLACED FLOOR PATH LIGHTING STRIPS IAW E175 AMM 33-50-21-00/400-801A. CHECKS GOOD.SDR DALA2019120957192Sign · detached(AIRCRAFT 5643, L/P 6157781) 2L EMERGENCY EXIT SIGN FELL OFF WHEN DOOR OPENED. CORRECTIVE ACTION: REINSTALLED EXIT ROW SIGN.SDR SWAA2019120939426Battery Pack · inoperativeFIRST TWO R/H SIDE AISLE EMERGENCY LIGHT INOP. / R&R BATTERY PACK PER AMM.SDR SWAA2019120939425Battery Pack · inoperativeR1 DOOR ESCAPE SLIDE EMERGENCY LIGHT INOP. / R&R BATTERY PACK PER AMM.SDR SWAA2019120939424Fuse · failedFIRST TWO R/H SIDE AISLE EMERGENCY LIGHT INOP. / R&R POWER SUPPLY FUSE PER AMM.SDR SWAA2019120939406Fuse · inoperativeR1 DOOR ESCAPE SLIDE EMERGENCY LIGHT INOP. / R&R POWER SUPPLY FUSE PER AMM.SDR SWAA2019120939384Lens · detachedEMERGENCY EXIT SIGN IN AISLE HAD COVER KNOCKED OFF. / SECURED LENS PER AMM.SDR CALA2019120762151Battery Pack · inoperativeEMERGENCY LIGHTS BATTERY NEEDS REPLACEMENT WILL NOT HOLD CHARGE REMOVED AND REPLACED EMERGENCY LIGHT BATTERIES IAW AMM 33-51-06- 960-805 SUBTASK 33-51-06-710-004. DATA WAS TRANSCRIBED FROM PAPE R DOC UAL NR 6724923 WORK ACP BY MECH V918690 INSP BY AQC009 ON 02SDR CALA2019120762150Battery Pack · discharged5868126-SPT-SEVERAL EMERGENCY LIGHTS INOP THROUGHOUT CABINSDR DALA2019120607149Sign · unknownEXIT SIGNS ABOVE CABIN DOORS DO NOT LIGHT UP. PERFORMED A330 TSM 33-51-00-810-812A. AFTER CIDS 1 POWER UP, OPERATIONAL CHECK OK. LP 1387978SDR AALA201912069013Power Supply · inoperativeAIRCRAFT IN BASE VISIT: MAINTENANCE REPORTS EPSU 17WL FAILED TEST. REQUIRES REPLACEMENT. REPLACED EPSU 17WL IAW AMM 33-51-38. OPS CHECK GOOD.SDR AALA201912069012Power Supply · no testAIRCRAFT IN BASE VISIT: MAINTENANCE REPORTS EPSU 15WL FAILED TEST. REQUIRES REPLACEMENT. REPLACED EPSU 15WL IAW AMM 33-51-38. OPS CHECK GOOD.SDR AALA201912069011Power Supply · no testAIRCRAFT IN BASE VISIT: MAINTENANCE REPORTS EPSU 11WL FAILED TEST. REQUIRES REPLACEMENT. REPLACED EPSU 11WL IAW AMM 33-51-38. OPS CHECK GOOD.SDR AALA201912069010Power Supply · no testAIRCRAFT IN BASE VISIT: MAINTENANCE REPORTS EPSU 16WL FAILED TEST. REQUIRES REPLACEMENT. REPLACED EPSU 16WL EPSU IAW AMM 33-51-38. OPS CHECK GOOD.SDR SIMA201912065002Control Module · failedEMERG LT NOT ARMED CAUTION MSG ON TAKE OFF AT APPROX 100 KIAS. THEN INTERMITTENTLY APPROX EVERY 3 MIN IN FLIGHT.-C/A-UPON FUTHER INSPECTION FOUND C/P FOR COCKPIT EMER LT SWITCH TO BE LOOSE. RESECURRED C/W. VERIFIED NORMAL OPERATION. REF EMB 140 SWPM 20-50-00SDR SIMA201912065001Charger · inoperativeLH FWD EXTERIOR EMERGENCY LIGHT INOP-C/A-REMOVED AND REPLACED #1 EMERGENCY LIGHT BATTERY AND CHARGER, OPC GOOD, IAW EMB AMM 33-50-04. EMERGENCY LIGHTING BATTERY P/N 2013-1A S/N 77460SDR AALA201912069021Battery Pack · no testAIRCRAFT IN BASE MAINTENANCE: AFT GALLEY EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK ON POWER SUPPLY M33409 PER AMM 33-51-06-760-802 AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-06-710-002.SDR AALA201912069003Light · inoperativeAIRCRAFT WAS NOT GROUNDED: 4L DOOR EXTERIOR SLIDE LIGHT WAS INOPERABLE. MAINTENANCE RELAMPED SLIDE LIGHT PER AMM 33-51-06.SDR WX0A2019120673444Battery Pack · faultedEPSU SYS TEST FAULTING BATT (10WL), AND BATT (13WL) / REPLACED BATTERY PACKS"SDR DALA2019120607105Lens · missing(AIRCRAFT 7008, L/P 1387470) EMERGENCY EXIT COVER DIFFUSER LENS DAMAGED OR MISSING / LOCATIONS:603 / INTERIOR. CORRECTIVE ACTION: NEW LENS INSTALLED.SDR JJBA201912065001Lamp · inoperativeRIGHT SIDE EXTERNAL EMERGENCY LIGHT OVER WING INOPERATIVE. REMOVED AND REPLACED RIGHT SIDE EXTERNAL OVER WING EMERGENCY LIGHT LAMP. OPS CHECK SAT.SDR YENA2019120650693Battery · failedFT # 882, UVF-JFK. EPSU BATTERY FAULT 15WL DURING CAPACITY CHECK PER T.C A320-33-51-00-710- 003; R & R EMER. BATTERY IAW AMM 33-51-00. OPS TEST OK.SDR YENA2019120650692Battery Pack · failedFT # 882, UVF-JFK. EPSU BATTERY FAULT 12WL DURING CAPACITY CHECK PER T.C A320-33-51-00-710- 003; R & R EMER. BATTERY IAW AMM 33-51-00. OPS TEST OK.SDR DALA2019120507056Battery Pack · inoperativeOVERHEAD EMERGENCY LIGHTS IN REAR TAIL CONE ARE INOPERATIVE. MAINTENANCE REPLACED THE BATTERY PACK, B5-116, IN THE AFT RIGHT LAVATORY. THE OVERHEAD EMERGENCY LIGHTS IN THE REAR TAIL CONE RETURNED TO NORMAL OPERATION. (LP #6607840)SDR P5CA2019120500225Battery · inoperativeMAIN CABIN DOOR EMERGENCY EXIT LIGHTS DO NOT ILLUMINATE WITH EMERGENCY LIGHT TEST SWITCH OR FLIGHT DECK EMER LIGHT SWITCH ON.(<P>REMOVED AND REPLACED EMERGENCY LIGHTS BATTERY PER IAI AMM 33-51-00. OPS TEST GOOD PER IAI AMM 33-51-00, NO FURTHER DEFECTS NOTED ATSDR SWAA2019120939485Power Supply · no testR/H OVERWING EMERGENCY EXIT LIGHT POWER SUPPLY ASSEMBLY AT POSITION M1669 FAILED OPERATIONAL TEST. / R&R POWER SUPPLY ASSEMBLY PER AMM.SDR SWAA2019120939393Battery Pack · no test1 EACH CABIN EMERGENCY LIGHTING BATTERY PACK FAILS CAPACITY TEST. / R&R BATTERY PACK PER AMM AND DWG.
Back to JASC 3350