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 SWAA2018080724078Battery Pack · dischargedLT STOWBIN EMERGENCY EXIT LIGHT INOP BETWEEN ROW 9 TO ROW 12. R&R BATTERY PACK IAW AMM.SDR SWAA2018080724077Light · inoperativeLT EMERGENCY EXIT LIGHTS AFT WING TO BODY PANELS INOP. R&R LIGHT IAW AMM.SDR SWAA2018080724071Lens · looseR2 DOOR LOWER RT EMERGENCY EXIT LIGHT LENS COVER LOOSE LOWER CLIP. SECURED COVER PER EA & AMM.SDR SWAA2018080724062Battery · failedFORWARD LT EMERGENCY LIGHT BATTERY FAILED CAPACITY TEST. R&R BATTERY PER AMM & DWG.SDR SWAA2018080724061Battery · failedLT OVERWING EMERGENCY LIGHTS BATTERY FAILED CAPACITY CHECK. R&R BATTERY PER AMM.SDR SWAA2018080724022Sign · brokenFORWARD ENTRY DOOR EXIT SIGN BROKEN. R&R SIGN ASSEMBLY PER MM.SDR SWAA2018080624020Cover · brokenAFT PANEL EMERGENCY EXIT LIGHT COVER BROKEN. R&R COVER PER AMM.SDR DALA2018080624889Power Supply · inoperativeEMERGENCY LIGHTS INOPERATIVE AT ROWS 18 - 22. REMOVED AND REPLACED POWER SUPPLY M733. CHECKED GOOD.SDR DALA201808064878Lens · damagedEMERGENCY EXIT LIGHT LENS DAMAGED. MAINTENANCE SECURED THE DAMAGED EXIT SIGN LENS.SDR DALA201808064877Lens · damagedEMERGENCY EXIT LENS WAS DAMAGED. MAINTENANCE SECURED THE DAMAGED EXIT SIGN LENS.SDR DALA201808064869Battery Pack · inoperativeTHE LEFT AND RIGHT AFT OVER WING EXIT SIGNS WERE INOPERATIVE. MAINTENANCE REPLACED THE BATTERY PACK AND BATTERY B5-119 IAW AMM 33-51. OPS CHECKED NORMAL.SDR AALA2018080639027Cover · missingAFT LEFT EMERGENCY LIGHT COVER MISSING. INSTALLED THE COVER AS REQUIRED.SDR DALA2018080304856Control Unit · failedEMERGENCY LIGHTS ILLUMINATED DURING FLIGHT, THE SWITCH WAS IN THE ARMED POSITION AT THE L2 & L3 DOORS. REPLACED REPLACED THE CONTROL UNIT.SDR SIMA201808032001Lamp · inoperativeEMERGENCY LIGHT AT THE SERVICE DOOR WAS INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHT LAMP IAW AMM 33-50-10. OPS CHECKED GOOD.SDR REXA2018080300670Lens · missingISLE EXIT SIGN OVER ROWS 12-13 MISSING REAR FACING ""EXIT"" PANEL. REINSTALLED EXIT LENS IAW AMM 33-51-07. A/C OKAY FOR SERVICE.SDR REXA2018080300669Charger · inoperativeFORWARD EXIT SIGN NOT ILLUMINATED. REMOVE AND REPLACED CHARGER ASSY 1 AND BATTERY PACK ASSY 1 IAW AMM 33-51-17 AND AMM 33-51-17. OPS CHECK GOOD A/C OK FOR SERVICE AT THIS TIME.SDR DALA2018080304842Bracket · brokenEXIT ROW AISLE ILLUMINATION LIGHT DANGLING BRACKET BROKEN. RESECURED EXIT LIGHT. OK FOR SERVICE.SDR AALA201808039017Battery · dischargedAFT FLIGHT ATTENDANT EMERGENCY FLASHLIGHT WAS INOPERATIVE. REPLACED THE FLASHLIGHT BATTERY, OPS CHECKED NORMAL IAW AMM 25-60-00.SDR SWAA2018090424708Light · brokenG1 EMERGENCY EXIT LIGHT BROKEN AT LOCATION M1674. R&R BATTERY PACK IAW AMM.SDR DALA2018081025000Light · damagedSEAT MOUNTED EMERGENCY LIGHT WAS DAMAGED AT SEAT 40B. REPLACED SEAT BUMPER ASSEMBLY. EMERGENCY LIGHT MOUNT CHECKS GOOD.SDR SWAA2018080724080Sign · unsecureAFT FACING OVERHEAD OVERWING EMERGENCY EXIT SIGN FELL OFF. REPOSITIONED SIGN PER MM.SDR AALA2018080739025Light · inoperativeFORWARD LOWER AFT STAIR PANEL EMERGENCY LIGHT INOPERATIVE. REPLACED AFT STAIR LEFT SIDE EMERGENCY LIGHT ASSEMBLY PER AMM 33-53-00.SDR DALA2018080614884Power Supply · inoperativeEMERGENCY LIGHTS AT SEATS 18 THRU 22 WERE INOPERATIVE. REMOVED AND REPLACED THE POWER SUPPLY M733 IAW AMM 33-51.SDR REXA2018080300668Light · inoperativeRT OVERWING EXTERIOR EMERGENCY LIGHT (FWD) INOP. R&R RT FWD OVERWING EMERGENCY LIGHT ASSY IAW AMM 33-51-15. OPS CHECK GOOD.SDR AALA2018080639024Lens · missingAISLE EMERGENCY LIGHT LENS WAS MISSING AT ROW 5R. REPLACED THE EMERGENCY LIGHT LENS IAW AMM 33-51-19.SDR YENA2018080610304Battery · failedEPSU EMERGENCY BATTERY 11WL FAILED A SYSTEM TEST. R & R THE BATTERY 11WL IAW AMM 33-51-38, EMERGENCY LIGHT TESTED GOOD.SDR YENA2018080310301Battery · failedCLIMBING THROUGH 10,000 FEET, AFTER CYCLING THE NO SMOKING SIGN ON. AUTO THE MID AISLE OVERHEAD EXIT LIGHT AND OVERWING EXIT LIGHT ON AIRCRAFT LEFT BECAME INOPERATIVE. R & R THE LT OVERWING EPSU AND BATTERY PACK IAW AMM 33-51-38. OPS CHECKED NORMAL.SDR YENA201808010300Power Supply · failedCLIMBING THROUGH 10,000 FEET AFTER CYCLING THE NO SMOKING SIGN ON, AUTO THE MID AISLE OVERHEAD EXIT LIGHT AND OVERWING EXIT LIGHT ON AIRCRAFT LEFT BECAME INOPERATIVE. R & R THE LT OVERWING EPSU AND BATTERY PACK IAW AMM 33-51-38. OPS CHECKED NORMAL.SDR YENA2018080310299Epsu · inoperativeEMERGENCY EXIT SIGNS DID NOT ILLUMINATE, TROUBLESHOT TO THE LT EPSU. R & R THE POWER SUPPLY IAW 33-51-00, OPS AND TESTED GOOD.SDR AALA201808032010Battery Pack · no testEMERGENCY LIGHT INOPERATIVE AT THE CEILING DOOR AND M1/M2 GALLEY. MAINTENANCE REPLACED THE BATTERY PACK IAW AMM 33-51-06, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR DALA2018080304834Battery · faultedAFT LEFT EMERGENCY LIGHT BATTERY FAULT. REMOVED AND REPLACED AFT LEFT EMERGENCY LIGHT BATTERY. OPERATION CHECKS GOOD.SDR SIMA201808021002Relay · failedEMERGENCY LIGHTS CYCLE ON AND OFF UNCOMMANDED. REMOVED AND REPLACED RELAY K135 REF ESPM 20-42-00. OPC GOOD REF AMM 33-24-07.SDR SWAA2018080224004Light · inoperativeLT EMERGENCY LIGHT INOP AT ROW 1. RELAMPED LIGHT IAW AMM.SDR SWAA2018080224003Battery · failedAFT RT EMERGENCY BATTERY FAILED CAPACITY CHECK. R&R BATTERY PER AMM.SDR SIMA201808021001Light · inoperativeRT OVER WING EMERGENCY LIGHT INOP. REMOVED AND REPLACED RT OVER WING EMERGENCY LIGHT LAMP PER AMM 33-50-07. OP CHECKED GOOD PER AMM 33-50-00.SDR MASA2018080113442Light · inoperativeROW 5 CEILING FLOOD EMER LIGHT INOP. PLACED ON MEL.SDR MASA2018080113444Light · inoperativeONE BULB INOP RH FLOOR EMER SIGN. RELAMPED.SDR DALA2018080104807Power Supply · defectiveDOOR 1L EXIT SIGN DID NOT LIGHT UP AFTER GEAR EXTENSION, ON THE GROUND, WITH EXIT LIGHT ON, IT WORKED NORMALLY. REPLACED EPSU AT DOOR 1L.SDR SWAA2018080123991Sign · inoperativeMID CABIN CEILING EMERGENCY EXIT SIGN INOP. R&R SIGN PER AMM.SDR MASA2018080113443Light · inoperativeROW 11 CEILING LVL EMERG FLOOD LIGHT INOP. PLACED ON MEL.SDR SIMA20180731006Connector · brokenEMERGENCY LIGHT STRIP CONNECTOR AT PANEL 251DF IS BROKEN.-C/A-COMPLETE:RAR EMERGENCY LIGHT STRIP CONNECTOR AT PANEL 251DF IAW EMB 140 SWPM 20-21-00. EASI# 102. FOR OPERATIONAL CHECK OF EMERGENCY LIGHT SEE BOW 300222.SDR SIMA2018092731007Light · crackedEMERGENCY FLOOR LIGHT EXTRUSION CRACKED LH #1-#2-#3-#4-#5-#6-#7-C/A-COMPLETE:RAR EMERGENCY FLOOR LIGHT EXTRUSION LH #1-#2-#3-#4-#5-#6-#7 IAW EMB 140 MM 33-50-12SDR SIMA2018092731004Lens · crackedEMERGENCY EXIT LIGHT LENS CRACKED ON CEILING PANEL 253CLC-C/A-COMPLETE:REMOVED AND REPLACED EMERGENCY EXIT LIGHT LENS ON CEILING PANEL 253 CLC IAW CD CMM 25-28-24.SDR CALA2018080601741Battery Pack · no testDURING A CHECK, THE R3 DOOR M33401 BATTERY PACK CAPACITY CHECK FAILED. THE BATTERY PACK REPLACED AND TESTED NORMAL IAW AMM 33-51-06.SDR CALA2018080601740Battery Pack · no testL3 DOOR M33406 BATTERY PACK CAPACITY CHECK FAILED., THE BATTERY PACK WAS REPLACED AND TESTED NORMAL IAW AMM 33-51-06.SDR REXA2018080300666Battery · dischargedFOUND SECTION OF E-LIGHTS INOP. R&R AFT BATTERY CHARGER ASSY IAW AMM 33-51-17 AND R&R E-LIGHT BATTERY PS38 IAW JOB CARD 33-900-701. OP/C GOOD.SDR DALA2018080304847Charger · inoperativeON SERVICE CHECK FOUND OVERHEAD AISLE EMERGENCY LIGHT AT STATION 770 INOP. LAMPED NO HELP REF AMM 33-51. REMOVED AND REPLACED BATTERY CHARGER M732 OPS NORMAL.SDR SWAA2018080224002Battery · failedFORWARD LT EMERGENCY BATTERY FAILED CAPACITY CHECK. R&R BATTERY PER AMM.SDR SWAA2018080224000Sign · looseCEILING MOUNTED EMERGENCY EXIT SIGN LOOSE AT ROW 12. R&R SIGN PER MM.SDR AALA2018080219006Power Supply · no testFWD LEFT EMERGENCY POWER SUPPLY INTIAL LOAD FAULT IAW EMERGENCY SYSTEM TEST. REPLACED THE POWER SUPPLY IAW TSM 33-51-00. OPS TESTED GOOD.
Back to JASC 3350