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 AALA20180305001Battery Pack · shortedAFT EMERGENCY LIGHTS AT LEFT DOOR INOPERATIVE, FOUND CENTER AISLE EXIT SIGN SHORTING OUT ON THE BATTERY PACK. REPLACED THE BATTERY PACK IAW AMM 33-51-00. AIRCRAFT WAS GROUNDED.SDR CALA2018030500851Battery Pack · no testCABIN EMERGENCY LIGHT BATTERY PACK FAILED A CAPACITY CHECK. REPLACED THE BATTERY PACK, FOUND NORMAL IAW AMM 33-51-60-960-802, REV 81, AND AMM 33-51-00-710-801, REV 81.SDR CALA2018030500850Battery Pack · no testCABIN EMERGENCY LIGHT BATTERY PACK CAPACITY CHECK FAILED. REPLACED THE BATTERY PACK, TESTED NORMAL IAW AMM 33-51-60-960-802, REV 81, AND AMM 33-51-00-710-801, REV 81.SDR CALA2018030500849Battery Pack · no testCABIN EMERGENCY LIGHT BATTERY PACK FAILED A CAPACITY CHECK. REPLACED THE BATTERY PACK, TESTED NORMAL IAW AMM 33-51-60-960-802, REV 81, AND AMM 33-51-00-710-801, REV 81.SDR CALA2018030500848Battery Pack · no testCABIN EMERGENCY LIGHT BATTERY PACK CAPACITY CHECK FOUND INOPERATIVE. REPLACED THE BATTERY PACK, TESTED & FOUND NORMAL IAW AMM 33-51-06-960-802, REV 81, AND AMM 33-51-00-710-801, REV 81.SDR CALA2018030500847Lens · crackedEMERGENCY LIGHT LENS BROKEN AT CENTER DIVIDER. REPLACED THE EMERGENCY LIGHT, TESTED, AND FOUND NORMAL IAW AMM 33-51-05-960-801, REV 81.SDR CALA2018030500846Battery Pack · inoperativeCABIN EMERGENCY LIGHT BATTERY PACK CAPACITY CHECK, FOUND INOPERATIVE. REPLACED THE POWER PACK, C/O THE EMERGENCY LIGHT TEST & FOUND NORMAL IAW AMM 33-51-06-960-802, REV 81, AND AMM 33-51-00-710-801, REV 81.SDR CALA2018030500843Lamp · inoperativeL4 DOOR EMERGENCY SLIDE LIGHT TEST FOUND LAMP OPEN. REPLACED THE LIGHT IAW AMM 33-51-04-960-801.SDR CALA2018030500842Fuse · inoperativeEMERGENCY LIGHT OVERWING SEAT LIGHTS ON BOTH SIDES, INOPERATIVE. REPLACED THE FUSE IN M1694. OPS CHECKED NORMAL.SDR CALA2018030500841Fuse · inoperativeSEAT EMERGENCY LIGHT IN FIRST CLASS INOPERATIVE. REPLACED THE FUSE IAW SSM 33-51-21. OPS CHECKED NORMAL.SDR DALA2018030301355Battery Pack · dischargedOVERHEAD EMERGENCY LIGHTS INOP BETWEEN SEAT ROWS 14-21. REMOVED AND REPLACED BATTERY PACK PER AMM 33-51-03.CABIN EMERGENCY LIGHTS OPS NORMAL.SDR MASA2018030313024Light · inoperativeEMERGENCY OVERHEAD FLOODLIGHT ROW 15 INOPERATIVE.SDR DALA2018030301345Battery Pack · inoperativeEMERGENCY CEILING LIGHTS AT ROWS 16-20 INOPERATIVE. REPLACED THE BATTERY PACK IAW 33-53. OPS CHECKED GOOD.SDR AALA201803059009Panel · detachedL1 DOOR, RIGHT SIDE COVER PANEL KEEPS FALLING OFF BRAKET. SECURED, AND CLOSED THE L1 EXIT LIGHT PANEL IAW AMM 25-28-00.SDR SWAA2018031220297Cover · brokenG4 GALLEY EMERGENCY EXIT LIGHT COVER BROKEN AT ATTACH POINT. R & R THE COVER ASSEMBLY IAW AMM.SDR AALA201803059007Lens · missingAIRCRAFT WAS NOT GROUNDED. R2 EXIT LIGHT LENS MISSING. REPLACED LENS PER AMM 33-51-18.SDR AALA201803059005Lens · missingAIRCRAFT WAS NOT GROUNDED. 1L SEAT MOUNTED EMERGENCY LIGHT MISSING LENS. REPLACED 1L SEAT MOUNTED EMERGENCY LIGHT ASSEMBLY PER 33-51-18.SDR DALA2018030201439Lens · damagedDURING INSPECTION, FOUND EMERGENCY AISLE LIGHT INOPERATIVE AT ROW 28. MAINTENANCE INSTALLED A NEW EMERGENCY LIGHT LENS, IAW AMM 33-51. OPS CHECKED NORMAL.SDR AALA201803059030Lens · missingEMERGENCY LIGHT LENS MISSING. REPLACED THE L4 DOOR SIGN ASSY IAW AMM 33-51-01. OPS CHECKED GOOD.SDR AALA20180303001Battery Pack · no testEMERGENCY LIGHT CAPACITY TEST, MID CABIN LIGHT DID NOT REMAIN ON FOR 15 MINUTES. REPLACED THE BATTERY PACK IAW AMM 33-51-06.SDR REXA2018030200172Lamp · inoperativeRIGHT FWD CENTER EXTERNAL EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS IAW CMM 33-52-07. OPS CHECKED GOOD.SDR SWAA2018030620243Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT M1669. R & R THE BATTERY PACK IAW AMM.SDR SWAA2018030620238Battery · no testFORWARD GALLEY LT EMERGENCY LIGHT BATTERY PACK FAILED A DEEP CYCLE CHECK. R & R THE BATTERY IAW AMM.SDR AALA201803059010Lens · detachedL3 DOOR EMERGENCY EXIT LIGHT LENS FELL OFF. REPLACED THE EMERGENCY EXIT LIGHT LENS.SDR AALA201803059035Light · detachedAIRCRAFT WAS NOT GROUNDED: GALLEY IN FRONT OF AIRCRAFT G3 POSITION, ESCAPE PATHLIGHT ON RIGHT SIDE OF AIRCRAFT, OUT OF SOCKET. MAINTENANCE REINSTALLED G3 GALLEY ISLE LIGHTING RIGHT SIDE AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER MM 33-51-05.SDR HALA2018030500069Light · unsecureAFT GALLEY FLOOR LIGHT STRIP COMING UP FROM FLOOR. NEEDS TO BE SECURED. SECURED LIGHT STRIP AS REQUIRED. OK FOR SERVICE.SDR ASAA2018030223750Sign · inoperativeAFT RT EXIT SIGN NOT ILLUMINATING. GROUNDED - YES. REPLACED COVER AND REPLACED AFT RT EXIT SIGN REF AMM 33-51-01. OPS CHK GOOD.SDR DALA2018030501385Light · brokenEMERGENCY LIGHT STRIP BROKEN AT SEAT 21B. REINSTALLED THE LIGHT STRIP. CHECKED OK.SDR ASOA201803024015Charger · inoperativeDURING A MAINTENANCE INSPECTION, THE EXTERNAL EMERGENCY LIGHT ON THE LT & RT OVERWING PANELS WERE FOUND TO BE INOPERATIVE. MAINTEMNANCE REMOVED AND REPLACED THE CHARGER ASSEMBLY, OPS TESTED WITH NO DEFECTS AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR YENA201803020118Power Supply · inoperativeINOPERATIVE CEILING EMERGENCY LIGHT IN PASSENGER CABIN. REPLACED THE EMERGENCY LIGHT POWER SUPPLY IAW AMM 33-50-01-400-801-A, PERFORMED AN OPS TEST IAW 35-50-01-710-801-A.SDR MASA2018030213022Lamp · inoperativeROW 21 OVERHEAD EMERGENCY FLOOD LIGHT INOPERATIVE. REPLACED THE LAMP.SDR DALA2018030201320Lamp · inoperativeDURING A SERVICE CHECK, EMERGENCY OVERHEAD LIGHTS OUT AT ROWS 17 - 21. REPLACED THE LAMPS.SDR AALA201803059004Battery · faultyAIRCRAFT WAS NOT GROUNDED. DURING CIDS1 TEST, GOT EPSU (12WL) EXT R CLASS 1 FAULT MESSAGE. INSTALLED SERVICEABLE BATTERY (12WL) PER AMM 33-51-38.SDR R61A201803010288Power Supply · inoperativeTWO EMERGENCY LIGHTS INOPERATIVE. R & R THE BATTERY PACK AND POWER SUPPLY IAW AMM 33-50-01.SDR AALA201803069012Lens · damagedEMERGENCY LIGHT LENS AT CORNER OF G3 GALLEY DAMAGED. MAINTENANCE INSTALLED A NEW EMERGENCY LIGHT LENS IAW AMM 33-50-00 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR SWAA2018030620261Battery Pack · no testCABIN EMERGENCY LIGHT BATTERY PACK FAILED A CAPACITY TEST AT M01672. R & R THE BATTERY PACK IAW AMM AND DWG.SDR SWAA2018030620260Battery Pack · no testCABIN EMERGENCY LIGHT BATTERY PACK FAILED A CAPACITY TEST AT M01670. R & R THE BATTERY PACK IAW AMM AND DWG.SDR SWAA2018030620259Battery Pack · no testCABIN EMERGENCY LIGHT BATTERY PACK FAILED A CAPACITY TEST AT M01669. R & R THE BATTERY PACK IAW AMM AND DWG.SDR SWAA2018030620258Battery Pack · no testCABIN EMERGENCY LIGHT BATTERY PACK FAILED A CAPACITY TEST AT M01673. R & R THE BATTERY PACK IAW AMM AND DWG.SDR SWAA2018030620251Battery Pack · no testCABIN EMERGENCY LIGHT BATTERY PACK FAILED A CAPACITY TEST AT M01668. R & R THE BATTERY PACK IAW AMM AND DWG.SDR SWAA2018030620250Lamp · inoperativeRIGHT EMERGENCY EXIT HATCH COVE LIGHT INOPERATIVE. REPLACED THE LAMP IAW AMM.SDR E07A201803060007Battery Pack · failedEMERGENCY LIGHTS STAYS ON IN ARM POSITION OR FLASHES ON/OFF IN ARM AND ON.SDR AALA201803029029Cover · missingAIRCRAFT WAS NOT GROUNDED. DOOR 4L EXIT LIGHT COVER MISSING. REPLACED MISSING EMERGENCY EXIT LENS AT DOOR 4L PER AMM 33-51-01.SDR AALA201803029028Light · damagedAIRCRAFT WAS NOT GROUNDED. LIGHT ON BRIGHT AT ANKLE HEIGHT BY FORWARD ENTRY DOOR. THE EMERGENCY EXIT LIGHT LOOKS DAMAGED/MELTED. REPLACED THRESHOLD LIGHT ASSEMBLY PER AMM 33-29-00.SDR AALA201803029027Plate · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT COVER PLATE MISSING FROM FIRST CLASS GALLEY WALL (ON THE AISLE). REPLACED FLOOR PROXIMITY LIGHT ASSEMBLY AND TESTED PER AMM 33-51-14.SDR SWAA2018030520224Battery Pack · no testEMERGENCY LIGHT BATTERY PACK FAILED A CAPACITY TEST AT M01670. R & R THE BATTERY PACK IAW AMM AND DWG.SDR SWAA2018030520223Battery Pack · no testEMERGENCY LIGHT BATTERY PACK FAILED A CAPACITY TEST AT M01672. R & R THE BATTERY PACK IAW AMM AND DWG.SDR SWAA2018030520222Battery Pack · no testEMERGENCY LIGHT BATTERY PACK FAILED A CAPACITY TEST AT M01669. R & R THE BATTERY PACK IAW AMM AND DWG.SDR SWAA2018030520218Lens · missingOVERWING EXIT DOORS CEILING EXIT SIGN LENS MISSING. R & R THE SIGN IAW SIP.SDR SWAA2018030520199Battery Pack · no testEMERGENCY LIGHT, BATTERY PACK FAILED A CAPACITY TEST AT M01673. R & R THE BATTERY PACK IAW AMM AND DWG.
Back to JASC 3350