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 SWAA2019102238113Charger · faultyL/H EMERGENCY EXIT LIGHT FAULTY AT ROW 12. / R&R BATTERY PACK CHARGER PER MM.SDR QXEA2019102200392Light · looseLUMINESCENT STRIP IN FRONT OF SEATS 2E AND 2D PEELING UP. REMOVED FROM SERVICE. RESECURED LUMINESCENT STRIP A SEAT 2E/D. FUNCTIONS AS REQUIRED. NO FURTHER DEFECTS NOTED. AIRCRAFT RETURNED TO SERVICE.SDR REXA2019102211478Light · unknownF/A REPORTS EMERGENCY EXIT LIGHTS NEAR GALLEY DOOR INOP
OPERATIONAL CHECKS ON EMERGENCY EXIT LIGHT IAW CRJ 900 AMM 33-51-05 OPS CHECKS GOODSDR JJBA20191021009Light · missingMISSING EMERGENCY LIGHT STRIP BY ENTRANCE. INSTALLED EMERGENCY LIGHT STRIP. NO DEFECTS NOTED AT THIS TIME.SDR DALA2019102206112Lens · missingSHIP 6820 EMERG SIGN BROKEN. CORRECTIVE ACTION: UPON INSPECTION FOUND COVER MISSING REPLACED COVER PER B757 AMM 33-50. (6391110)SDR SWAA2019110638661Block · corrodedGROUND BLOCK GD03810S (WITH WIRES) AT BS 1006 STRINGER 11 R/H IS CORRODED. / REMOVED AND REPLACED GROUND BLOCK GD03810S AS PER SRM 51-40-02-0G-0. PERFORMED DOOR WARNING SYSTEM TEST FOR THE AFT SERVICE DOOR AS PER AMM 52-71-00-730-801. OPERATIONAL TEST FOR EMERSDR YENA2019102400612Battery Pack · no testFT # 225, JFK-TPA. EMERG LIGHT BATTERIES 11WL AND 13WL FAILED TEST; REMOVED AND REPLACED EMER LIGHT BATTERIES 11WL AND 13WL IAW AMM 33-51-38.SDR YENA2019102400611Battery · no testFT # 225, JFK-TPA. EMERG LIGHT BATTERIES 11WL AND 13WL FAILED TEST; REMOVED AND REPLACED EMER LIGHT BATTERIES 11WL AND 13WL IAW AMM 33-51-38.SDR DALA2019102426125Lens · missing(AIRCRAFT 6710, L/P 6748106) LENS MISSING LEFT OVERWING EXIT ADJACENT TO EXIT SIGN. CORRECTIVE ACTION: REPLACED LENS.SDR AALA2019102319021Cover · missingAIRCRAFT WAS NOT GROUNDED: EXIT LIGHT LENS COVER MISSING AT DOOR 1R. MAINTENANCE REPLACED LIGHT LENS COVER PER STANDARD PRACTICES.SDR MASA20191022101Light · inoperativeEMERG LIGHT / CEILING AT ROW 1 / OUTSDR SWAA2019102213838Lamp · inoperativeR2 DOOR OUTSIDE EMERGENCY LIGHT INOP. / RELAMPED LIGHT PER AMM.SDR HALA2019102100432Sign · brokenDURING CABIN VISIT, FOUND 3R EXIT SIGN BROKEN. // REPLACED EXIT SIGN AT 3R PER A330 AMM 33-51-10.SDR DALA201910216015Sign · brokenBROKEN ON OVER WING EMERGENCY EXIT SIGN (2 EA) (CPAX). SUMMARY OF NRC 00544: OVER WING EMERGENCY EXIT SIGNS (2 EA) P/N: BR9051-001 WERE REPLACED PER B717-200 AMM 33-51-05. (LP1323338)SDR XMXR20201118003Battery Pack · failedEMERGENCY LIGHTS FLICKERING. REPLACED EMERGENCY LIGHTS NR 2 AFT BATTERY PACK.SDR AALA201911019002Battery · dischargedAIRCRAFT IN BASE VISIT: DOOR R4 EPAS BATTERY FAILS TEST. REMOVED AND REPLACED EPAS BATTERY AND REPAIRED WIRE (SM-1) SPLICE IN DOOR. SUPPLEMENTAL ACTION: SECT.3, TT/TC.SDR SWAA2019102538195Sign · brokenPASSENGER CABIN SIDEWALL PANEL 232ZLW HAD BROKEN EMERGENCY EXIT SIGN. / R&R SIGN IAW SRM.SDR AALA2019102219008Light · looseAIRCRAFT NOT GROUNDED: PILOT REPORTS ESCAPE PATH LIGHT AT BASE OF BUSINESS CLASS LAV IS LOOSE. LOCATED ACROSS FROM G2. REMOVED AND REPLACED EMERGENCY LIGHT CAPSULE AT G2 GALLEY IAW AMM 33-51-18. OPS CHECKS GOOD.SDR AALA2019102219028Battery · no testAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS EMERGENCY BATTERY AT LOCATION 12WL FAILED EPSU SYS TEST. REMOVED AND REPLACED EMERGENCY BATTERY AT LOCATION 12WL EMERGENCY POWER SUPPLY UNIT IAW AMM 33-51-38, EPSU SYS TEST PASSED.SDR ASOA2019102295108Bulb · burned outDURING MX THE LEFT FORWARD EXTERNAL EMERGENCY LIGHT WAS INOP. MX RELAMPED THE LEFT FORWARD EXTERNAL LIGHT WITH OPERATIONAL CHECK GOOD. A/C WAS APPROVED FOR RETURN TO SERVICE.SDR DALA2019102006089Bulb · inoperativeLEFT OVERWING EMERGENCY EXIT PULL HANDLE LIGHTS HAVE INOP BULBS BOTH EXITS, RELAMPED LEFT SIDE OW PULL HANDLE LIGHTSSDR DALA2019102206086Battery Pack · no testDURING SERVICE CHECK - PERFORMING EMERGENCY LIGHT TEST - NO SYS OK LIGHT WITH MESSAGE BATTERY L, REPLACED BATTERYSDR DALA2019102206085Bulb · inoperativeRIGHT OVERWING EMERGENCY EXIT PULL HANDLE LIGHTS HAVE INOP BULBS FWD EXIT, RELAMPED RT OW FWD PULL HANDLE LIGHTSDR SWAA2019102213887Sign · brokenCENTER CABIN EMERGENCY EXIT SIGN BROKEN. / R&R SIGN PER AMM.SDR SWAA2019102213883Light · detachedFORWARD EXIT FLOOR COVER LIGHT FELL OFF. / R&R LIGHT ASSEMBLY PER AMM.SDR SWAA2019102213836Sign · out of positionCEILING MOUNTED EXIT SIGN AT THE OVERWING EXIT OUT OF POSITION. / REPOSITIONED EXIT SIGN PER SIP.SDR AALA2019102219023Light · no testAIRCRAFT WAS NOT GROUNDED: OVERHEAD EMERGENCY LIGHT INOPERATIVE BETWEEN BINS 29 AND 30 LEFT HAND AISLE. MAINTENANCE ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK OF EMERGENCY LIGHT PER AMM 33-51-00.SDR AALA2019102219022Cover · inoperativeAIRCRAFT WAS NOT GROUNDED: SEAT 4R EMERGENCY EXIT LIGHT COVER INOPERATIVE. MAINTENANCE REPLACED LIGHT COVER PER STANDARD PRACTICES.SDR ASAA2019102193067Bulb · burned outR2 DOOR EXTERIOR EMERGENCY LIGHT INOP GROUNDED - YES. R2 EXTERIOR LIGHT RELAMPED, OPS CHECK GOOD IAW AS B737-800 AMM 33-51-04-960-801SDR AALA201910219027Battery · no testAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS EMERGENCY BATTERY AT LOCATION 11WL FAILED EPSU SYS TEST. REMOVED AND REPLACED EMERGENCY BATTERY AT LOCATION 11WL EMERGENCY POWER SUPPLY UNIT IAW AMM 33-51-38, EPSU SYS TEST PASSED.SDR AALA201910219043Battery Pack · no testAIRCRAFT WAS NOT GROUNDED: DURING PS CHECK, DOME LIGHT L273 WOULD NOT ILLUMINATE DURING EMERGENCY LIGHTS OPERATIONS CHECK. MAINTENANCE REPLACED LIGHT BATTERY PACK M1675 PER STANDARD PRACTICES.SDR AALA201910219020Light · inoperativeAIRCRAFT WAS NOT GROUNDED: R3 DOOR EMERGENCY LIGHT INOPERATIVE. MAINTENANCE ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK OF EMERGENCY LIGHT PER AMM 33-51-04.SDR AALA201910219012Battery · no testAIRCRAFT WAS NOT GROUNDED: FORWARD LEFT EMERGENCY POWER SUPPLY UNIT BATTERY TEST FAILED. MAINTENANCE ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK OF EMERGENCY POWER SUPPLY UNIT BATTERY PER AMM 33-51-00.SDR SIMA201910219001Warning Message · false activationEMERGENCY LIGHTS CAME ON IN FLIGHT + EICAS MESSAGE EMER LIGHT NOT ARMED & THEN WENT AWAY-C/A-PERFORMED OPS CKS OF EMER LIGHTS SYST PER EMB 140 MM 33-50-00 OPS CKS GOOD AT THIS TIMESDR DALA2019102106012Charger · inoperativeEMERGENCY CEILING LIGHTS @ ROWS 27-31 INOP. R/R BATT CHARGER AT B5-106 AND BATTERIES. CKS OK A/C OK FOR SVC REF MD88 WDM 35-51-11 CHARGER SN ON 20123 - S/N OFF 23162. (LP5587555)SDR ASOA2019102285107Light · malfunctionedPILOT REPORTED THE EMERGENCY LIGHTS STAY ON AFTER SHUTDOWN. THE PILOT STATED DISCREPANCY NO LONGER EXISTS PER MX CONTROL AND NO FURTHER ACTION WAS REQUIRED. A/C WAS APPROVED FOR RETURN TO SERVICE.SDR DALA2019102206087Power Supply · no testEPSU L FW FAILED DURING EMERGENCY LIGHT TEST, REPLACED EPSUSDR DALA2019102216077Sign · detached(AIRCRAFT 5653, L/P 6093786) EXIT LIGHT ON 2 RIGHT DOOR FELL OFF. CORRECTIVE ACTION: RESECURED EMERGENCY LIGHT COVER AT 2R DOOR. LIGHTS OPERATE NORMAL PER B757 AMM 33-51.SDR ASAA2019102183044Power Supply · intermittentFA REPORTS THE EMERGENCY EXIT LIGHT OVER R2 DOOR INTERMITTENTLY IS ON AND OFF. VERIFIED EMERGENCY EXIT LIGHT SWITCH IS ARMED (NOT ON). NO ADDITIONAL DOOR OR ELECTRICAL ABNORMALITIES. GROUNDED - YES. REPLACED POWER SUPPLY M1672, REF B737-900 AMM 33-51-06. OPS NSDR AALA201910219003Light · inoperativeAIRCRAFT IN BASE MAINTENANCE: R3 DOOR INTERIOR EMERGENCY LIGHT INOPERABLE. MAINTENANCE PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-00.SDR DALA2019102186031Battery Pack · no testCABIN EMERGENCY LIGHTS EPSU 14WL BATTERY FAILS TEST, REPLACED BATTERY OF EMERGENCY POWER SUPPLY UNIT 14WLSDR DALA2019102196028Light · intermittentEXIT LIGHT OVER DOOR 1L FLASHES INTERMITTENTLY DURING FLIGHT. COULD NOT DUPLICATE ON GROUND LIGHT OPERATES NORMAL OK FOR SVC.SDR DALA201910216020Shroud · brokenFOUND BROKEN EMERGENCY LIGHT ASSY SHROUD AT 25B. REMOVED AND REPLACED LIGHT ASSY SHROUD PER CMM 25-28-89. SECURED CHKD OK. (LP1321400)SDR MASA2019101812097Lamp · inoperativeEMER LIGHT BULB OUT AT 12F EXIT SIGN. RELAMPED.SDR SWAA2019110138468Lens · crackedAFT WET AREA R2 DOOR EMERGENCY EXIT LENS CRACKED. / R&R LENS IAW AMM.SDR DALA201910306273Lens · wrong part(AIRCRAFT 7101, L/P 1332718) FOUND DR 2 RH LED EXIT SIGN ASSY (BF1-0123-02-004) CAME WITH ONE WRONG LENS. CORRECTIVE ACTION: REPLACED DR 2 RH LED EXIT SIGN LENS AS PER B777 AMM 33-51-01. OPERATIONAL TEST CARRIED OUT AS PER B777 AMM 33-51-01. FOUND SATISFACTORYSDR SWAA2019102238033Lens · misinstalledEXIT DOOR SIGN ARROW POINTED AWAY FROM DOOR. / R&R LENS PER AMM.SDR ASAA2019102173064Sign · detachedMID CABIN CEILING EMERGENCY EXIT SIGN HAS HAD A PIECE FALL OFF. GROUNDED - YES. RESECURED EMERGENCY EXIT SIGN LENS.SDR DALA2019102106059Battery Pack · inoperativeSHIP 5808 ON SVC FOUND EMERGENCY LIGHTS FOR BATTERY PACK M11487 WOULD ONLY BE ON FOR A MIN. CORRECTIVE ACITON: R+R BATTERY PACK AT M11487 OPS CHECK NORMAL PER B757 33-51. (6632297)SDR DALA2019102186058Power Supply · inoperativeSHIP 664 EMER LIGHTS ROWS 12-15 & ON EXTERIOR IN ZONE INOP. CORRECTIVE ACTION: REPLACED POWER SUPPLY M735 AND BATTERY PACK IAW B757AMM 33-51-07. OP TEST GOOD. (5488389)
Back to JASC 3350