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 SWAA2019121639629Bulb · burned outAFT CENTER CEILING EXIT SIGN HAD SEVERAL BURNED OUT BULBS. / RELAMPED BULBS PER AMM.SDR SWAA2019121639628Bulb · burned outR/H OVERWING EXIT SIGN HAD SEVERAL BURNED OUT BULBS. / R&R BULB PER AMM.SDR SWAA2019121639627Bulb · burnedR2 DOOR EMERGENCY EXIT SIGN HAD SEVERAL BURNED OUT BULBS. / RELAMPED BULB PER AMM.SDR DALA2019121627336Lens · damaged(AIRCRAFT 5805, L/P 1398465) EMERGENCY EXIT COVER DIFFUSER LENS DAMAGED OR MISSING. CORRECTIVE ACTION: REPLACED L2 DOOR EXIT SIGN COVER REF. B757 AMM 33-51.SDR DALA2019121627319Connector · unsecureEMERGENCY LIGHTS INOPERATIVE AT SEATS 36AB AND 39AB. RESECURED CONNECTOR AT 36AB AND RETERMINATED CONNECTOR AT 39AB. SYSTEM OPERATION IS NORMAL. (LP 6119345)SDR SWAA2019121639670Battery Pack · no testEMERGENCY LIGHTING BATTERY PACK FAIL CAPACITY TEST AT M01669. / R&R BATTERY PACK IAW AMM AND DWG.SDR SWAA2019121639669Battery Pack · no testEMERGENCY LIGHTING BATTERY PACK FAIL CAPACITY TEST AT M01670. / R&R BATTERY PACK IAW AMM AND DWG.SDR SWAA2019121639668Battery Pack · no testEMERGENCY LIGHTING BATTERY PACK FAIL CAPACITY TEST AT M01672. / R&R BATTERY PACK IAW AMM AND DWG.SDR SWAA2019121639667Battery Pack · no testEMERGENCY LIGHTING BATTERY PACK FAIL CAPACITY TEST AT M01673. / R&R BATTERY PACK IAW AMM AND DWG.SDR YENA2019121610700Power Supply · failedFT # 8, LAS-FLL. WITH AIRCRAFT POWER OFF R/H OVERWING EXIT HATCH "SLIDE ARMED" LIGHT REMAINS ILLUMINATED WITH POWER ON. R/H OVERWING "EXIT SALIDA" SIGN DOES NOT COME ON WITH EMERGENCY LIGHTS SELECTED ON; REPLACED R/H OVERWING PSU & BATTERY PER M/M 33-51-38. OPSDR YENA2019121610699Battery Pack · failedFT # 8, LAS-FLL. WITH AIRCRAFT POWER OFF R/H OVERWING EXIT HATCH " SLIDE ARMED" LIGHT REMAINS ILLUMINATED WITH POWER ON. R/H OVERWING "EXIT SALIDA" SIGN DOES NOT COME ON WITH EMERGENCY LIGHTS SELECTED ON; REPLACED R/H OVERWING PSU & BATTERY PER M/M 33-51-38. OSDR YENA2019121610698Power Supply · no testDURING HEAVY MAINTENANCE, EMERGENCY POWER UNIT EPSU 11WL IN PASSENGER CABIN DOES NOT PASS TEST; REF AEROMAN N/R 2019-363259 - THE VISUAL INSPECTION OF THE WIRING OF THE TERMINAL BLOCK 7225VT-6 FOUND WIRE 3351-1780 IMPROPERLY CONNECTED AND WIRE 3351-1780 WAS COSDR FDEA2019121313221Switch · out of positionPDIS 861 25-60 8026 11DEC19 CGN FACT U EMERG LIGHTS SWITCH COVER TURNS OFF SWITCH WHEN CLOSED. CGN U FOUND PULLING MECHANISM OF SWITCH GUARD MOVED OF THE SWITCH. RE-ALLIGNED THE SWITCH POSITION AND MECHANISM (MOVING NUTS TO LET THE SWITCH SHSDR DALA2019121327294Cover · missingL2 DOOR EXIT SIGN COVER MISSING, INSTALLED NEW EXIT SIGN COVER AT L2SDR AALA2019121329002Power Supply · no testAIRCRAFT WAS GROUNDED: FORWARD EMERGENCY LIGHT INOPERABLE. MAINTENANCE REPLACED EMERGENCY POWER SUPPLY UNIT PER AMM 33-51-38.SDR REXA2019121311724Bulb · inoperativeLH EXTERIOR EMERGENCY LIGHT INOP
REPLAMPED EMREGENCY LIGHT IAW CMM 33-52-06. OPS CHECK GOOD. P/N OFF/ON: 8GH002473-08SDR REXA2019121211723Battery Pack · inoperativeEMERGENCY LIGHT FULLY DRAINED IT NEED TO BE RE-CHARGED
REMOVED AND REPALCED BATTERY PACK ASSY: PS4LF, PS1LF, PS2LF, PS3LF IAW CRJ 200 JOBCARD 33-900-701 OPS CHECK GOODSDR AALA201912129003Power Supply · inoperativeAIRCRAFT WAS GROUNDED: MAINTENANCE FOUND EMERGENCY LIGHTING INOP. REMOVED AND REPLACE D EPSU 12WL IAW AMM 33-51-38. OPS CHECKS OK.SDR AALA201912129005Power Supply · inoperativeAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS OFAR (DOOR 5) RH BATTERY DISCHARGED. REMOVED AND REPLACED OFAR (DOOR 5) RH POWER SUPPLY IAW AMM 33-29-12.SDR SIMA201912121001Light · inoperative11 B/C INTERIOR OVERHEAD EMERGENCY LIGHT INOP-C/A-REMOVED AND REPLACED 11 B/C INTERIOR OVERHEAD EMERGENCY LIGHT IAW EMB AMM 33-50-08-000-801-A AND 33-50-08-400-801-A. OPC GOOD.SDR SWAA2019121239597Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1674. / R&R BATTERY PER AMM.SDR SWAA2019121239570Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1668. / R&R BATTERY PER AMM.SDR SWAA2019121239569Lamp · inoperativePASSENGER R/H OVER WING EMERGENCY LIGHT INOP. / RELAMPED LIGHT PER AMM.SDR SWAA2019121239564Lens · looseA/C ENTRY FOUND FORWARD ENTRY FLOOR LEVEL EMERGENCY EXIT LENS HANGING LOOSE. / SECURED LENS PER SIP.SDR SWAA2019121239563Lamp · inoperativeR2 DOOR EMERGENCY EXIT LIGHT INOP. / RELAMPED LIGHT IAW AMM.SDR SWAA2019121139533Lens · missingEMERGENCY EXIT LIGHT LENS FORWARD OF AFT LEFT LAV MISSING. / REINSTALLED LIGHT LENS IAW SIP.SDR SWAA2019123039942Battery Pack · inoperativeEMERGENCY LIGHT BATTERY M2816 WOULD NOT HOLD A CHARGE. R&R BATTERY PACK M2816 IAW AMM.SDR SIMA2019122710003Light · weakFWD TWO FLOOR PROXIMITY LIGHT STRIPS DO NOT FULLY ILLUMINATE. REMOVED AND REPLACED THE FLOOR PROXIMITY LIGHTS IAW AMM 33-50-21. OPS CHECKED PASSED.SDR R61A201912241432Sign · dim***WHILE A/C WAS OUT OF SERVICE FOR A HEAVY CHECK*** FWD SERVICE DOOR EMERGENCY EXIT IDENTIFIER DOES NOT ILUMINATE COMPLETELY. REPLACED IAW AMM 33-50-15-400-801-A. A/C REMAINS OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR DALA2019121327295Light · detachedEMERGENCY FLOOR LIGHT ASSY BROKEN OFF FROM THE SEAT 15C, INSTALLED EMERGENCY LIGHT/HOUSINGSDR AALA2019121319007Battery Pack · no testAIRCRAFT WAS GROUNDED: 4L EMERGENCY LIGHT BATTERY INOPERABLE. MAINTENANCE REPLACED EMERGENCY BATTERY PACK PER STANDARD PRACTICES.SDR AALA201912139007Battery Pack · failedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHT SYSTEM TEST HAS FAULT EPSU (13WL) AFT L/DEU B (300RH7). REPLACED ESPU 13WL BATTERY PACK PER AMM 33-51-38.SDR AALA201912129011Battery · faultedAIRCRAFT WAS GROUNDED: ESCAPE BATTERY 13WL FAULTED. MAINTENANCE REPLACED 13WL BATTERY PER AMM 33-51-38.SDR AALA201912129010Battery · faultedAIRCRAFT WAS GROUNDED: ESCAPE BATTERY 10WL FAULTED. MAINTENANCE REPLACED 10WL BATTERY PER AMM 33-51-38.SDR DALA2019121207245Light · shortedEMERGENCY PATH LIGHTS ROWS 1-5 INOPERATIVE ON LEFT SIDE. FOUND FORWARD LGITH ASSEMBLY AT SEAT 5 SHORTED AND REPLACED. SYSTEM OPERATION IS NORMAL.SDR DALA2019121217242Battery Pack · inoperativeFOUND EMERGECY LGITHS DIM AT SEATS 13G-20G. REPLACED BATTERY M1209. SYSTEM OPERATION IS NORMAL.SDR DALA2019121217249Battery Pack · inoperative(AIRCRAFT 5637, L/P 6096506) FOUND EMERGENCY LIGHTING INOP SEATS 23, 24, 25, 26. CORRECTIVE ACTION: R/R'D M105467 BATTERY PACK PER B757 FRM/FIM 33-51-00-815-802.SDR DALA2019121107219Lens · missingTHE MID CABIN OVERHEAD EMERGENCY SIGN LENS IS MISSING. MAINTENANCE INSTALLED A NEW LENS. EEPL ARE OK FOR SERVICE PER B717 AMM 33-51. (LP #5371965)SDR DALA2019121007214Light · damagedEMERGENCY SEAT MOUNTED LIGHTING DAMAGED / INOP / LOCATION 1C, REPLACED LIGHT FIXTURE AT SEAT 1CSDR SWAA2020010840275Lens · brokenL/H OVERHEAD EMERGENCY EXIT STOWAGE BIN BULL NOSE LIGHT LENS BROKEN. / R&R LENS IAW AMM.SDR SWAA2019123040024Battery Pack · inoperativeR/H EMERGENCY LIGHTS INOP AT SEATS 21. R&R BATTERY PACK PER AMM.SDR SWAA2019123040023Battery Pack · inoperativeR/H EMERGENCY LIGHTS INOP AT SEATS 18. R&R BATTERY PACK PER AMM.SDR SWAA2019123040022Battery Pack · inoperativeL/H EMERGENCY LIGHTS INOP AT SEATS 27. R&R BATTERY PACK IAW AMM.SDR SWAA2019123040021Battery Pack · inoperativeL/H EMERGENCY LIGHTS INOP AT SEATS 12. / R&R BATTERY PACK PER AMM.SDR SWAA2019123040006Battery Pack · inoperativeEMERGENCY BATTERY PACK M1673 INOP. R&R BATTERY PACK M1673 IAW AMM.SDR SWAA2019123039963Sign · inoperativeR/H OVERWING AFT EMERGENCY SIGN INOP. R&R SIGN PER AMM.SDR SWAA2019123039962Battery Pack · inoperativeEMERGENCY BATTERY PACK M1675 INOP. R&R BATTERY PER AMM.SDR AALA2019121219012Light · inoperativeAIRCRAFT WAS NOT GROUNDED: EXIT SIGN ON FLIGHT ATTENDANT JUMPSEAT INOPERABLE. MAINTENANCE REPLACED EXIT SIGN LIGHT ASSEMBLY PER AMM 33-51-01.SDR AALA2019121109019Battery · no testAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT AFT SEATS FLASHLIGHT FAILED TEST. MAINTENANCE REPLACED FLASHLIGHT BATTERY PER AMM 25-64-00.SDR AALA2019121109018Power Supply · no testAIRCRAFT WAS NOT GROUNDED: ZONE C, RIGHT HAND SIDE EMERGENCY PATH LIGHTING ILLUMINATED FOR 10 TO 15 SECONDS. MAINTENANCE REPLACED POWER SUPPLY M33404 PER AMM 33-51-06 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.
Back to JASC 3350