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 AALA2019121109009Power Supply · no testAIRCRAFT WAS NOT GROUNDED: DURING OPERATIONAL CHECK OF THE EMERGENCY LIGHTS PER JOB CARD 26L00005005, R4 AND L4 LOWER INTERIOR EMERGENCY LIGHTS WOULD NOT COME ON. MAINTENANCE REPLACED EMERGENCY POWER SUPPLY UNIT PER AMM 33-51-38 AND PERFORMED SATISFACTORY OPERSDR HNAA2019121100381Light · inoperativeLEFT SIDE OVERWING EMERGENCY LIGHT INOP...FIX: R&RD OVERWING EMERGENCY LIGHT IAW AMM 33-50-10SDR SWAA2019121139535Lens · dirtyFUSELAGE REAR AFT EMERGENCY LIGHT LENS DIRTY (LOCATED AFT OF AFT WING-TO-BODY FAIRING BS. 757). / CLEANED LENS PER SIP.SDR ASAA2019120931555Bulb · burned outEMERGENCY LIGHT EXIT LOCATOR SIGN ADJACENT TO RIGHT AFT OVERWING EXIT IS INOP. GROUNDED - YES. RELAMPED AND TESTED PER B737-900 AMM 33-51-01-960-801 - OPS NORMAL.SDR SWAA2019121039500Cover · brokenL2 DOOR EMERGENCY LIGHT COVER BROKEN OFF. / R&R COVER PER AMM.SDR SWAA2019121039499Battery Pack · failedL2 DOOR FAILED TO ILLUMINATED. / CLEANED CONNECTORS ON LIGHT ASSEMBLY AND REPLACED BATTERY PACK PER AMM.SDR SWAA2019121039438Indicator · detachedEMERGENCY LIGHT ANNUNCIATOR LIGHT IN OVERHEAD PANEL FELL OUT WHILE IN FLIGHT COULD NOT LOCATE LAMP. / INSTALLED MISSING P5 PANEL EMERGENCY LT PB SWITCH IAW SWPM.SDR SIMA201912109005Light · inoperativeRH UPPER WING EMERGENCY LIGHT INOP-C/A-RAR RH OVERWING EMERGENCY LIGHT IAW EMB AMM TASK 33-50-07-000-801-A AND 33-50-07-400-801-A OPC GOODSDR SIMA201912109002Light · inoperativeRH OVERWING EMERGENCY LIGHT INOP-C/A-REMVOED AND REPLACED RH OVERWING EMERG LIGHT IAW EMB 145 AMM 33-50-07. OPC GOOD.SDR SIMA201912109004Lamp · inoperativeLH DOOR FWD EMERGENCY EXIT LIGHT INOP-C/A-RAR LH DOOR FWD EMERGENCY EXIT LIGHT LAMP IAW EMB AMM 33-50-10-000-801-A AND 33-50-10-400-801-A. OPC GOOD.SDR AALA201912099038Power Supply · inoperativeAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS DURING COMPLIANCE OF OPS CHECK EPSU, FOUND L3 UNIT FAULT. REMOVED AND REPLACED L3 EPSU UNIT AND EMERGENCY BATTERY IAW AMM 33-51-38. OPS CHECK OK.SDR SWAA2019120939428Lamp · inoperativeR1 DOOR EMERGENCY LIGHT EXTERIOR LIGHT BEHIND INOP. / RELAMPED LIGHT IAW AMM.SDR 2DYA20191209001Power Supply · failedDURING 28-DAY CHECK FOUND L4 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED L-4 POWER SUPPLY IAW B767 AMM 33-51-07. OPS CHECK FOUND NORMAL.SDR CALA2019120902173Lamp · inoperativeLH ROW 20, EMERGENCY EXIT DOOR, FWD EMERGENCY THRESHOLD LIGHT, IS INOP RELAMPED, OP CHECKS GOOD REF AMM TASK 33-51-00-710-801SDR DALA2019120907159Fuse · blownEMERGENCY LIGHTS OUT AT L1 AND R1 DOORS AND SEATS 1C TO 12D. FOUND FUSE BLOWN ON POWER SUPPLY AT SEAT 3D. REPLACED FUSE. OPS CHECK OK. REFERENCE MD-88 CMM 33-21-70. PN ON B215-06. (LP6030176)SDR 4TXA2019120900234Battery Pack · dischargedEMERGENCY BATTERY PACK FAILED DURING ROUTINE MAINTENANCE CHECKSDR R61A2019121181363Light · unsecureFLOOR STRIP COMING UP IN FRONT OF WARDROBE CLOSET. EMERGENCY LIGHTING. RESECURED PHOTOLUMINESCENT INDICATOR STRIP LIGHT IAW AMM 33-50-21.SDR AALA201912109013Battery · no testAIRCRAFT WAS NOT GROUNDED: AFT LEFT 13WL EMERGENCY LIGHT BATTERY FAILED BITE TEST. MAINTENANCE REPLACED EMERGENCY LIGHT BATTERY AT AFT LEFT 13WL PER AMM 33-51-38.SDR AALA201912109012Battery · no testAIRCRAFT WAS NOT GROUNDED: FORWARD LEFT 10WL EMERGENCY LIGHT BATTERY FAILED BITE TEST. MAINTENANCE REPLACED EMERGENCY LIGHT BATTERY AT FORWARD LEFT 10WL PER AMM 33-51-38.SDR DALA2019121007198Charger · inoperative4L AND 4R DOOR EMERGENCY EXIT SIGNS/ LIGHTS INOP T/S PER WDM 33-51-14 AMD 33-51-11 NO POWER TO BATTERY CHARGER M1210. REPAIRED BROKEN WIRE W836-002-16 PER SWPM 20-30. CKS GOOD (1391856)SDR AALA201912099036Decoder · faultyAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS EMERGENCY LIGHT FAILED BITE. REMOVED AND REPLACED DEU B (300RH7) AND OPS CHECKED GOOD IAW AMM 23-73-47.SDR AALA201912099037Power Supply · inoperativeAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS EPSU 14WL FAILS. REMOVED AND REPLACED EPSU 14WL IAW AMM 33-51-38.SDR N6WA20191209801Lens · missingOVERHEAD EMERGENCY EXIT SIGN COVER MISSING AT ROW 11. FOUND LENS FOR OVERWING EXIT LOCATING SIGN AND INSTALLED IAW CRJAMM-33-51-07.SDR SWAA2019120939439Light · missingEMERGENCY EXIT LIGHT LENS FORWARD OF AFT L/H LAV MISSING. / INSTALLED LIGHT ASSEMBLY IAW AMM.SDR QXEA2019120900452Light · looseESCAPE PATH LIGHTING NEAR MAIN CABIN DOOR LOOSE. REMOVED FROM SERVICE. RE-SECURED STRIP. NO DEFECTS NOTED. RETURNED TO SERVICE.SDR HALA2019120900509Sign · detachedEXIT SIGN ABOVE DOOR 3R NEEDS TO BE RE-ATTACHED. FELL OFF DURING BOARDING. // REATTACHED EXIT SIGN AT 3R. OK FOR SVCSDR MASA2019120812171Bulb · inoperativeEMER LIGHT AT ROW 6 INOP
REPLACED BULBSDR SWAA2019123140093Lens · brokenAFT GALLEY AREA EMERGENCY EXIT LENS BROKEN. / R&R LENS IAW AMM.SDR VNAA2019121271101Light · damagedEMERGENCY FLOOR PATH LIGHTING ON RH SIDE ROWS 16-18 DAMAGED. REMOVED AND REPLACED EMERGENCY FLOOR PATH LIGHTING ON THE RH SIDE AT ROWS 16-18 IAW CRJ 700 AMM 33-51-01-000/400-801-A11-PSA.SDR DALA201912117230Cover · loose(AIRCRAFT 5816, L/P 1391533) EMERGENCY EXIT SIGN COVER LOOSE / LOCATIONS: 38. CORRECTIVE ACTION: REF LOG 1391532 SIGN RESECURED.SDR DALA201912117229Cover · unsecure(AIRCRAFT 5816, L/P 1391532) EMERGENCY EXIT SIGN COVER LOOSE / LOCATIONS: 37. CORRECTIVE ACTION: RESECURED EXIT SIGN. DEFECT NOTED & ENTERED.SDR FDEA2019120973208Bulb · inoperativeSVC CK R-1 DOOR EMERGENCY ESCAPE SLIDE LIGHT INOP. RELAMPED R ESCAPE SLIDE LIGHT REF AMM 33-51-06-2-1, BULB GE767. OP'S NORMAL OK FOR SERVICESDR AALA201912099022Relay · failedAIRCRAFT IN BASE VISIT: MAINTENANCE REPORTS NEW CIDS #1 BOX FAILED TEST AFTER INSTALLATION. ESCAPE SLIDE FWD LT / EXIT SIGNS FWD L / FPEEMS AISLE LT FWD / EMERGENCY LT LH FWD / FPEEMS CROSS AISLE FWD L. MAINTENANCE REPLACED RELAY 106RH-DEU-B IAW AAWRD 20-00-0SDR AALA201912099016Battery Pack · no testAIRCRAFT WAS NOT GROUNDED: DURING EMERGENCY LIGHT OPERATIONAL TEST, FOUND EMERGENCY LIGHT BATTERY PACK DISCHARGED AT DOOR 4R. MAINTENANCE REPLACED EMERGENCY LIGHT ON BATTERY PACK PER AMM 33-51-06.SDR SWAA2019120939494Lamp · inoperativeL/H EMERGENCY AREA LIGHTS INOP AT SEAT 6. / RELAMPED LIGHT IAW AMM.SDR SWAA2019120939430Lamp · inoperativeR/H EMERGENCY AREA LIGHTS INOP AT SEAT 13. / RELAMPED LIGHT IAW AMM.SDR SWAA2019120939427Cover · detachedL2 DOOR EXIT SIGN COVER NEAR AFT BOARDING DOCK FELL OFF. / R&R COVER PER AMM.SDR DALA2019120977182Light · inoperative(AIRCRAFT 5805, L/P 6571768) ROW 41 SEAT MOUNTED EMER LIGHT INOP (WHITE). CORRECTIVE ACTION: REMOVED AND REPLACED LIGHT ASSY REF B757 WDM 33-51.SDR DALA2019120907173Battery Pack · inoperativeEMERGENCY LIGHTS OVER L4/R4 DOOR INOP R/R BATTERY PACK AND CHARGER ASSY PER B767 AMM 33-51 OPOS CK NML (6708593)SDR CALA2019120702163Lamp · inoperativeFLOOR PATHWAY EMER EXIT LIGHTS INOP AT SESTS 1AB,26ABC, & 30ABC. RELAMPED REF AMM 33-51-11 OPS CHECKED OK. ACP IDT INSP OF RELACING EEL PATH LT LAMPS AT SEA #1, #26, AND #30 REF GMM 09-10-05 AND AMM 33-51-11. OPS CK GOOD.SDR AALA2019120700143Battery Pack · dischargedDURING EMERGENCY LIGHT OPERATIONAL TEST FOUND EMER LIGHT BATERY PACK INOP AT DOOR 4RSDR DALA2019120707150Battery Pack · inoperativeTHE AFT TAIL CONE OVERHEAD EMERGENCY LIGHTS ARE INOPERATIVE. MAINTENANCE REPLACED THE BATTERY PACK IN THE RIGHT LAVATORY AND THE OPERATION CHECK OF OVERHEAD TAIL CONE EMERGENCY LIGHTS WAS GOOD. (LP #6561511)SDR SIMA2020032706009Cover · crackedMULTIPLE EMERGENCY LIGHT STRIPS: (#1 FWD RHT AND LFT)(#2 RHT)(#3 LFT)(#4 LFT AND RHT)(#6 RHT)(#7 LFT)(#8 RHT AND LFT)(#9 LFT)(#10 EXIT RH FWD)(#12 RHT) ARE CRACKED.-C/A-COMPLETE:REMOVED AND REPLACED MULTIPLE EMERGENCY LIGHT STRIP COVERS IAW AMM 33-51-01.SDR FDEA201912063197Power Supply · inoperativeLT PASSENGER DOOR EXTERNAL EMERGENCY LIGHT L25 INOP. POWER SUPPLY M731 REPLACED.SDR SIMA2020021906008Charger · failedEMERGENCY LIGHTING BATT P/N 2013-1 S/N 109524 AND POWER SUPPLY P/N 11-0049 S/N 24464 A110 REQ TO BE REMOVED AND REPLACED.-C/A-FOUND BATTERY S/N 109524 AND CHARGER S/N 24464 IN THE #3 POSITION. REMOVED AND REPLACED EMERGENCY LIGHTING BATTERY AND CHARGER IAW CSDR SWAA2019121839792Light · brokenLAV A, EMERGENCY EXIT LIGHT BROKEN. / R&R LIGHT IAW AMM.SDR SWAA2019121639602Cover · detachedR/H OVERWING EMERGENCY EXIT SIGN LENS FELL OFF. / INSTALLED COVER PER AMM.SDR DALA2019121267244Battery Pack · inoperativeEMERGENCY EXIT SIGNS ABOVE THE LEFT AND RIGHT OVER WING EXITS INOPERATIVE. REPLACED BATTERY PACK M1209. SYSTEM OPERATION IS NORMAL.SDR REXA2019121161720Charger · inoperativeDURING ROUINE CHECK FOUND EMERGENCY LIGHTS WOULD NOT GO OFF
"R+R PS35 BATTERY CHARGER PER CRJ 900 AMM 35-51-17/ OPS CHECK GOOD, NOOTHER DEFECTS NOTED AT THIS TIME. P/N: 11-0049 S/N OFF:23214 S/N ON:22974
"SDR YENA2019121160695Battery 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.
Back to JASC 3350