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 AALA201910169010Power Supply · inoperativeAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS EPSU (10WL) FWD L BAT FAULT. REMOVED & REPLACED EPSU (10WL) IAW AMM 33-51-38. OPS CHECK OK.SDR AALA2019101649007Light · brokenAIRCRAFT WAS NOT GROUNDED: SEAT 24C EMERGENCY PATH LIGHT BROKEN. MAINTENANCE REPLACED LIGHT PER AMM 33-51-18.SDR SWAA2019101637958Light · damagedR/H EMERGENCY FLOOR EVACUATION EGRESS IN FILLED WITH WATER HARD TO SEE. / R&R PHOTO LUMINESCENT STRIP IAW AMM.SDR 29GA2019101600001Light · inoperativeFLIGHT# 0052, EMERGENCY LIGHT OVER SEAT 3A INOP. REMOVED AND REPLACED EMERGENCY LIGHT IN PSU PANEL IAW AMM 23-30-35-04-2.SDR SIMA201910154002Lamp · inoperativeEXTERIOR RH UPPER EMERGENCY LIGHT INOP. REMOVED AND REPLACED EXTERIOR RH UPPER EMERGENCY LAMP IAW AMM 33-50-10 OPC GOODSDR SIMA201910154001Lamp · inoperativeEMERGENCY EXIT ROW CEILING LIGHT INOP. R & R EMERGENCY EXIT ROW CEILING LIGHT LAMP IAW EMB 140 AMM 33-50-08. OPC GOOD. RARSDR SWAA2019101537804Light · inoperativeFORWARD ENTRY DOOR EMERGENCY EXIT LIGHT INOP. R&R LIGHT ASSEMBLY PER AMM.SDR MASA2019101412089Bulb · inoperativePAX DR FLOOR LEVEL EMERG EXIT SIGN 1 BULB INOP. REPLACED THE BULB.SDR CALA2019101401759Power Supply · no testEPSU L AND R FAIL P TP SYSTEM LIGHT CHECK REMOVED AND REPLACED LEFT AND RIGHT EPSU''S (11WL AND 12WL) AND L EFT AND RIGHT EPSU BATTERIES IAW AMM 33-51-38-000-001-A, 33 -51-38-400-001-A, 33-51-38-000-002-A, AND 33-51-38-400-002-A. PE RFORMED OPS CHECK OF THE EMSDR SIMA201911193003Battery Pack · inoperativeEMERGENCY FLOOR LIGHTS STRIPS #4, 5, AND ALL INTERNAL EMERGENCY EXIT ROW MARKERS IDENTIFIERS ARE INOP.-C/A-COMPLETE:REMOVED AND REPLACED #3 BATTERY AND BATTERY CHARGER ASSY IAW ENVOY W/C 33-700-19. OPERATIONAL CHECK GOOD.SDR SIMA201911193004Sign · inoperativeAFT FACING EMERGENCY EXIT SIGN AT OVERWING EMERGENCY EXIT IS INOP-C/A-COMPLETE:REMOVED AND REPLACED AFT FACING EMERGENCY EXIT SIGN AT OVERWING EMERGENCY EXIT IAW EMB 145 AMM 33-50-15. OPS CHECK GOOD.SDR SWAA2019102938336Battery Pack · inoperativeFORWARD EMERGENCY LIGHT POWER UNIT BATTERY DEAD. / R&R BATTERY PACK M1675 PER AMM.SDR DALA2019101735955Battery Pack · inoperativeDURING INSPECTION FOUND EMERGENCY ISLE LIGHTS INOPERATIVE AT ROWS 18-23 RT SIDE. R+R CHARGER AND BATTERY PACK AT LOC M1670. LIGHTS CK OK.SDR DALA2019101735954Battery Pack · inoperativeDURING INSPECTION FOUND EMERGENCY ISLE LIGHTS INOPERATIVE AT ROWS 24-28 RT SIDE. R+R BATTERY PACK AT LOC M1672. LIGHTS CK OK.SDR SWAA2019101637874Light · missingAFT L/H EMERGENCY EXIT INDICATOR LIGHT ASSEMBLY MISSING. INSTALLED LIGHT ASSEMBLY PER AMM AND WDM.SDR AALA2019101549005Battery Pack · no testAIRCRAFT WAS GROUNDED: MAINTENANCE REPORTS DURING ACCOMPLISHMENT OF JOB CARD 2908 BATTERY PACKS M1670, M1673, M1694 AND M1695 FAILED CAPACITY CHECK. REPLACED BATTERY PACKS AT M1670, M1673, AND M1695 AND POWER SUPPLY AT M1694 IAW AMM 33-51-06. OPS CHECK NORMAL.SDR AALA201910159016Battery Pack · no testAIRCRAFT WAS GROUNDED: MAINTENANCE REPORTS DURING ACCOMPLISHMENT OF JOB CARD 2908 BATTERY PACKS M1670, M1673, M1694 AND M1695 FAILED CAPACITY CHECK. REPLACED BATTERY PACKS AT M1670, M1673, AND M1695 AND POWER SUPPLY AT M1694 IAW AMM 33-51-06. OPS CHECK NORMAL.SDR AALA201910159017Battery Pack · no testAIRCRAFT WAS GROUNDED: MAINTENANCE REPORTS DURING ACCOMPLISHMENT OF JOB CARD 2908 BATTERY PACKS M1670, M1673, M1694 AND M1695 FAILED CAPACITY CHECK. REPLACED BATTERY PACKS AT M1670, M1673, AND M1695 AND POWER SUPPLY AT M1694 IAW AMM 33-51-06. OPS CHECK NORMAL.SDR AALA201910159018Power Supply · inoperativeAIRCRAFT WAS GROUNDED: MAINTENANCE REPORTS DURING ACCOMPLISHMENT OF JOB CARD 2908 BATTERY PACKS M1670, M1673, M1694 AND M1695 FAILED CAPACITY CHECK. REPLACED BATTERY PACKS AT M1670, M1673, AND M1695 AND POWER SUPPLY AT M1694 IAW AMM 33-51-06. OPS CHECK NORMAL.SDR DALA2019101545904Battery Pack · inoperativeRIGHT OVERWING EXIT CEILING EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED THE EMERGENCY LIGHT BATTERY PACK AT ROW 24 RIGHT. OPS CHECK GOOD IAW AMM 33-37-03-420-801.SDR DALA2019101405893Power Supply · inoperativeFOUND BOTTOM EMERG LIGHTS FROM ROWS 1 TO 5 LT SIDE INOP. REPLACED EMERG BATTERY CHARGER/ PWR SUPPLY PER B767-300 AMM 33- 51.SDR SWAA2019101437752Lamp · inoperativeAFT LEFT PASSENGER DOOR EXTERNAL SLIDE, OVERWING LIGHT INOPERATIVE. RELAMPED LIGHT PER AMM.SDR ASAA2019101431009Light · inoperativeEMERGENCY LIGHT AISLE LIGHT INOP AT ROW 24 RIGHT. GROUNDED - YES. REMOVED, REPLACED, AND TESTED EMERGENCY LIGHT AISLE LIGHT ASSY AT ROW 24 RIGHT PER AMM 33-51-03-960-802 - OPS NORMALSDR SIMA2019101430002Inverter · inoperativeOVERWING EMERGENCY EXIT CEILING AFT SIGN INOP. REMOVED AND REPLACED #4 EMERGENCY LIGHT DC/AC INVERTER IAW EMB 145 AMM 33-50-11. OPC GOODSDR SIMA2019101430001Lamp · inoperativeDURING PS-2 CHECK, FOUND LT SIDE CENTER FAIRING EMERG LIGHT INOP. REMOVED AND REPLACED EMERG LIGHT LAMP IAW EMB 145 AMM 33-50-10. OPS CHECK GOOD.SDR WX0A219101473431Power Supply · no testEPSU 13WL FAILED DURING CABIN EMERGENCY LIGHTING TEST / R&R EPSU"SDR WX0A2019101473430Power Supply · no testEPSU 10WL FWD L FAILED DURING CABIN EMERGENCY LIGHTING / R&R EPSU"SDR WX0A2019101473429Power Supply · no testLT & RT OVERWING EPSU FAILED TO TEST. R & R THE EPSU.SDR UIEA2019101325706Lamp · inoperativeUPPER DECK EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP, OPS CHECK OK IAW AMM 33-51-00.SDR SIMA201911182002Lens · crackedRIGHT OVERWING EXTERIOR EMERGENCY LIGHT JUST AFT OF EMERGENCY EXIT CUTOUT HAS A CRACKED LENS.-C/A-COMPLETE:RAR'D RH OVERWING EXTERIOR EMERGENCY LIGHT LENS IAW AMM 20-21-00.SDR SIMA201911182003Cover · crackedEMERGENCY LIGHT STRIP COVERS LH1, LH9, RH9, RH10, AND EMERGENCY EXIT ROWS (4 EACH) ARE CRACKED.-C/A-COMPLETE:INSTALLED NEW EMERGENCY LIGHT STRIP COVERS LH1, LH9, RH9, RH10, AND EMERGENCY EXIT ROWS 4EA. IAW CRJ AMM 33-51-01.SDR SIMA201911182001Cover · brokenSEVERAL AISLE LIGHTS COVERS AND LIGHT STRIPS BROKEN-C/A-COMPLETE:REPLACED SEVERAL AISLE (4EA) LIGHT COVERS AND STRIPS IAW CRJ AMM 33-51-01.SDR DALA2019101605933Charger · inoperativeROW 30 CEILING EMER LIGHT INOP. CORRECTIVE ACTION: R/R BATT CHARGER PER B737 AMM 33-51. R/R BATTERY PER B737 AMM 33 -51. (6203687).SDR SWAA2019101637932Lamp · inoperativeFORWARD ENTRY EMERGENCY EXIT LIGHTS INOP. RELAMPED LIGHTS PER AMM.SDR SWAA2019101637910Lamp · inoperativeL/H OVERWING EXIT DOOR WINDOW FORWARD EMERGENCY LIGHT INOP. RELAMPED LIGHT PER WDM AND AMM.SDR SWAA2019101637909Lamp · inoperativeR/H OVERWING EXIT DOOR WINDOW EMERGENCY LIGHTS INOP. RELAMPED LIGHT PER WDM AND AMM.SDR SWAA2019101637908Lamp · inoperativeSERVICE EXTERIOR EMERGENCY EXIT LIGHTS INOP. RELAMPED LIGHTS PER AMM.SDR SWAA2019101637907Bulb · inoperativeR/H OVERWING EXTERIOR EMERGENCY LIGHT INOP. R&R LIGHT BULB PER AMM.SDR SWAA2019101637876Lamp · inoperativeR/H OVERWING EMERGENCY EXIT LIGHT INOP. / R&R SLIDE LIGHT LAMP PER AMM.SDR SWAA2019101657867Lamp · inoperativeL1 DOOR FORWARD ESCAPE SLIDE LIGHT (L731) INOP. / RELAMPED LIGHT PER AMM.SDR SWAA2019101537859Battery Pack · inoperativeEMERGENCY EXIT LIGHT BATTERY PACK POWER SUPPLY M1676 INOP. / R&R BATTERY PACK PER AMM.SDR SWAA2019101537847Cover · detachedEMERGENCY EXIT SIGN OVERWING EXIT DETACHED. REINSTALLED LENS COVER PER AMM.SDR ASAA2019101421010Battery Pack · dischargedLH FWD GALLEY EMERGENCY EXIT LIGHTS INOP. GROUNDED - YES. REMOVED AND REPLACED LH FWD GALLEY EMERGENCY EXIT LIGHT BATTERY PACK PER B737-900 AMM TASK 33-51-06-960-805. PERFORMED EMERGENCY LIGHTS OPERATIONAL TEST PER AMM TASK 33-51-00-710-801. OPS CHECK GOOD.SDR DALA2019101425875Cover · missingEMERGENCY LIGHT 14D MISSING COVER, LIGHT OPERATES NORMALLY, REPLACED COVERSDR MASA2019101322084Bulb · inoperativeROW 14A EXIT SIGN 1 LIGHT BULB INOPERATIVE. PLACED ON MELSDR DALA2019101305870Battery Pack · inoperativeON SVC CHECK PERFORMED EPSU TEST RECEIVED CLASS 1 BAT/EPSU(15WL) MID L FAULT, REPLACED EPSU BATTERY FIN 15WLSDR DALA2019101805983Lens · missingSEAT 14D EMERGENCY ESCAPE PATH LIGHT MISSING COVER LIGHT OPERATES NORMALLY, REMOVED & INSTALLED SERVICEABLE REPLACEMENT SEAT 14D EMERGENCY PATH LIGHT ASSYSDR SWAA2019101537843Cover · dislodgedOVERHEAD CENTER AISLE EMERGENCY EXIT SIGN COVERS CAME OFF. INSTALLED COVERS PER MM.SDR ASOA201910151106Inverter · inoperativeDURING MX INSPECTION, THE EMERGENCY EXIT MARKER FOR LT ESCAPE HATCH WAS NOT ILLUMINATING. MX REMOVED AND REPLACED THE NR 4 EMERGENCY LIGHT AC/DC INVERTER WITH OPERATIONAL CHECKED GOOD.SDR SWAA2019101437768Battery Pack · no testEMERGENCY LIGHT BATTERIES FAILED CAPACITY TEST AT LOCATIONS M1668, M1669, M1672 AND M1675. R&R BATTERIES PER AMM.
Back to JASC 3350