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 ASOA201610304079Inverter · inoperativeDURING MAINTENANCE INSPECTION THE FIRST THREE AISLE PATH LIGHT STRIPS WERE FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE NR 2 EMERGENCY LIGHT INVERTER, OPERATIONALLY TESTED WITH NO DEFECTS NOTED, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVSDR A6WA201644535Light · inoperativeEMERGENCY LIGHTS FROM ROW 8 AFT DO NOT TURN ON.SDR UHLA201610300478Light · no testEMERGENCY LIGHTS FAILED OPERATIONAL TEST. R & R THE LIGHT IAW AMM.SDR DALA2016103107952Battery Pack · inoperativeTHE FLIGHT ATTENDANT DISCOVERED THAT AN EMERGENCY EXIT SIGN DIFFUSER COVER WAS DAMAGED. MAINTENANCE REPLACED THE BATTERIES. OPS CHECKED GOOD.SDR DALA2016103107950Battery Pack · inoperativeDURING LINE CHECK, MAINTENANCE FOUND THAT SEVERAL OF THE EMERGENCY LIGHTS INOPERATIVE. MAINTENANCE REPLACED BATTERY PACKS AND PERFORMED A SATISFACTORY FUNCTIONAL CHECK OF THEM.SDR MASA2016103012484Battery · dischargedEMERGENCY LIGHTS INOP. ALLOWED BATTERIES TO CHARGE.SDR SWAA2016112910034Lens · missingCEILING EMERGENCY EXIT LIGHT LENS MISSING. INSTALLED LENS IAW AMM.SDR DALA2016110408280Housing · damagedEMERGENCY LIGHT HOUSING DAMAGED AT SEAT ROW 14D, REPAIRED THE HOUSING.SDR GTIA2016102901646Battery · failedCHECK OF BATTERY CAPACITY TEST (11WL) AND (13WL) FAILED. R&R BATTERY OF EMERGENCY SUPPLY UNIT (11WL) AND (13WL) IAW AMM 33-51-38. OPS CHECK GOOD 13WL.SDR DALA2016110108156Lens · looseTHE PILOT DISCOVERED THAT THE MAIN CABIN DOOR EMERGENCY EXIT SIGN HAS A LOOSE LENS. MAINTENANCE SECURED THE LENS AND THE OPERATIONAL CHECK WAS GOOD.SDR AALA20161101014Sign · brokenAIRCRAFT NOT GROUNDED. RIGHT AFT OVERWING EMERGENCY EXIT IDENTIFIER BROKEN. REMOVED AND REPLACED EXIT IDENTIFIER IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20161101011Lens · missingAIRCRAFT NOT GROUNDED. R2 DOOR EMERGENCY EXIT SIGN LENS COVER MISSING. REPLACED LENS COVER IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR SWAA2016110109267Cover · looseRT AFT GALLEY EMERGENCY EXIT SIGN COVER LOOSE. R&R COVER IAW SIP.SDR DALA2016110108093Power Supply · no testLEFT OVERWING EXIT EPSU FAILED OPS CHECK, REPLACED THE POWER SUPPLY.SDR DALA2016103108069Light · inoperativeON SVC CK, EMER LT CK ROW 12 ED EMER LIGHT OUT. RELAMPED AS REQUIRED PER AMM 33-50 OPS CHECKS GOOD.SDR CALA2016103100835Battery Pack · inoperativeEMERGENCY LIGHT BATTERY PACK M1674 WILL NOT HOLD A CHARGE. REMOVED AND REPLACED BATTERY PACK AT M1674 IAW AMM 33-51 -06 OPS CHECKED GOOD IAW AMM 33-51-00SDR DALA2016103107992Light · unsecureDURING INSPECTION FOUND INOP EMERGENCY LIGHT AT ROW 4C AND D. MAINTENANCE RESECURED BULB AT ROW 4 C AND D CHECKS GOOD. REF AMM 33-50.SDR SIMA20161029001Battery · inoperativeFWD FLASHLIGHT IS NOT WORKING. R & R THE BATTERY IAW CMM 25-60-11. OPS CHECKED GOOD.SDR DALA2016103007990Unknown · malfunctionedEMERGENCY EXIT LIGHTS COME ON WHEN NO SMOKING LIGHT IS TURNED ON. RESET CIDS 1, OPERATIONAL CHECK OK.SDR DALA2016103107972Lens · missingLAVATORY 202 WALL MOUNT EMERGENCY LIGHT CLEAR LENS MISSING. REPLACED THE LENS. SYSTEM OPS NORMAL.SDR AALA201610309002Battery · inoperativeLEFT EMERGENCY POWER SUPPLY UNIT BATTERY FAULTED. REPLACED LEFT EMERGENCY POWER SUPPLY UNIT BATTERY AND ACCOMPLISHED A SATISFACTORY OPS CHECK IAW AMM 33-51-38-000-002-A.SDR DALA2016103107953Lens · damagedTHE FLIGHT ATTENDANT DISCOVERED THAT AN EMERGENCY EXIT SIGN DIFFUSER LENS WAS DAMAGED. MAINTENANCE REPLACED THE LENS AND THE OPS CHECKED GOOD.SDR ASOA201610293063Battery · inoperativeEMERGENCY LIGHTS IN GALLEY INOPERATIVE. REMOVED AND REPLACED THE EMERGENCY LIGHT BATTERY AND OPS CHECKED GOOD.SDR F3LA2016103100065Battery Pack · dischargedLEFT EMERGENCY EXIT POWER SUPPLY BATTERY FAULT. REPLACED THE BATTERY PACK, OPS CHECKED OK. IAW AMM 33-51-38 PB 401.SDR MASA2016102912481Light · inoperativeEMER FLOOD LIGHT ROW 15 INOP. PLACED ON MEL.SDR SWAA2016112809944Light · brokenAFT GALLEY CENTER EMERGENCY EXIT LIGHT BROKEN AT MOUNT. R & R THE LIGHT IAW AMM.SDR AALA20161101015Power Supply · failedAIRCRAFT NOT GROUNDED. RIGHT AFT EMERGENCY LIGHTS FAILED 15 MINUTE TEST. REMOVED AND REPLACED EMERGENCY LIGHTS POWER SUPPLY. OPERATIONAL CHECK GOOD.SDR AALA20161101013Lens · brokenAIRCRAFT NOT GROUNDED. L1 DOOR EMERGENCY EXIT SIGN LENS COVER BROKEN. REMOVED AND REPLACED LENS COVER IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20161101002Control Module · faultyAIRCRAFT NOT GROUNDED. ESCAPE PATH LIGHTING DIM FROM ROW 26 BACK, FUSELAGE STATIONS 1470 TO 1678. REMOVED AND REPLACED AISLE PATH LIGHTING CONTROL MODULE IAW 33-51-11. OPERATIONAL CHECK GOOD. REF AALA20161029003.SDR AALA20161029004Battery · faultyAIRCRAFT NOT GROUNDED. EMERGENCY POWER SUPPLY UNIT FAILED TEST AT 11WL. REMOVED AND REPLACED EPSU BATTERY IAW 33-51-38. OPERATIONAL CHECK GOOD.SDR AALA20161029003Battery Pack · dischargedAIRCRAFT NOT GROUNDED. ESCAPE PATH LIGHTING DIM FROM ROW 26 BACK, FUSELAGE STATIONS 1470 TO 1678. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACK IAW 33-51-11. OPERATIONAL CHECK GOOD. REF AALA20161101002.SDR SWAA2016110109268Sign · brokenR1 DOOR EXIT SIGN BROKEN. R&R SIGN ASSEMBLY IAW AMM.SDR SWAA2016110109255Light · inoperativeAFT CABIN EMERGENCY EXIT HATCH SIGN BULB INOP. R&R BULB IAW AMM.SDR SWAA2016110109195Lens · looseR2 DOOR EXIT SIGN LENS LOOSE. R&R LENS PER MM.SDR DALA2016103108089Lens · damagedEMERGENCY SEAT MOUNTED LIGHTING DAMAGED. REPLACED EMERGENCY LIGHT LENS COVER.SDR FDEA201610283740Bulb · inoperativeDURING SERVICE CHECK, FOUND R1 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE BULB IAW AMM 33-51-06-2-1 REV 117. TESTED GOOD.SDR CALA2016103195880Battery Pack · no testEMERGENCY EXIT LIGHT BATTERY FWD LEFT FAILED CAP TEST REPLACED THE BATTERY 10WL, OPS TEST PASSEDSDR AALA201610299004Power Supply · inoperativeAFT CABIN EMERGENCY LIGHTS INOPERATIVE. REPLACED CENTER CABIN, RIGHT EMERGENCY POWER SUPPLY UNIT AND AFT CABIN LEFT EMERGENCY POWER SUPPLY UNIT IAW AMM 33-51-38.SDR AALA201610299003Power Supply · inoperativeAFT CABIN EMERGENCY LIGHTS INOPERATIVE. REPLACED CENTER CABIN, RIGHT EMERGENCY POWER SUPPLY UNIT AND AFT CENTER CABIN LEFT EMERGENCY POWER SUPPLY UNIT IAW AMM 33-51-38.SDR AALA20161029001Lens · brokenR1 DOOR EMERGENCY EXIT MARKER LENS IS BROKEN. REMOVED AND REPLACED THE SIGN IAW AMM 33-50-00. OPS CHECKED NORMAL.SDR DALA2016103007991Sign · disconnectedDOOR 3L EXIT SIGN NOT CONNECTED. RECONNECTED DOOR 3L EXIT SIGN.SDR R61A201610280629Battery Pack · inoperativeCREW RECEIVED AN EMERGENCY BATTERY FAULT AND COCKPIT EMERGENCY LIGHT WOULD NOT COME ON. MAINTENANCE REMOVED AND REPLACED EMERGENCY LIGHT POWER SUPPLY 1 AND 4 IAW AMM AND OPS CHECKED GOOD.SDR AALA201610319019Lens · brokenEMERGENCY EXIT LIGHT ON SEAT 9ED BOTTOM LOWER CASING BROKEN. REPLACED EMERGENCY LIGHT COVER ASSEMBLY AND ACCOMPLISHED A SATISFACTORY OPS CHECK IAW CMM 25-28-72.SDR AALA201610299001Lens · detachedPLASTIC COVER OF EXIT ROW LIGHT AT 1C HAS BEEN BROKEN OFF. SECURED THE LENS.SDR DALA2016103107951Sign · crackedTHE PILOT REPORTED THAT THE CENTER ISLE EXIT SIGN AT THE OVERWING EXIT HATCH IS CRACKED AND HANGING DOWN. MAINTENANCE ADJUSTED THE CORNER OF THE EXIT SIGN AND RETURNED THE EMERGENCY LIGHTS TO SERVICEABLE CONDITION.SDR CALA2016102800829Light · inoperativeRT AFT OVERWING EMERGENCY EXIT LIGHT INOP RELAMPED LIGHT IAW AMM 33-51-04. OPS CHECK GOOD.SDR CALA2016102800828Light · inoperativeRT AFT EXTERIOR EMERGENCY LIGHT INOP. RELAMPED RT AFT EXTERIOR EMERGENCY LIGHT. OPS CHECK GOOD.SDR CALA2016102800827Light · inoperativeEMERGENCY RT AFT SERVICE DOOR INOP. RELAMPED OPS CHECKED NORMAL.SDR HNAA2016102800342Light · malfunctionedEMERGENCY LIGHT FLICKER MULTIPLE TIMES DURING FLIGHT. CLEANED AND INSPECTED NR 1 AND 2 BRUSH BLOCK ASSY. CHECKED FOR OBVIOUS DEFECTS IN ASSOCIATED CONNECTOR PLUGS AND WIRING, WITH NO DEFECTS NOTED. GROUND RAN AIRCRAFT. OPS CHECKED PROP HEAT. OPS CHECKED GOOSDR HNAA2016102800343Light · malfunctionedEMERGENCY LIGHTS ARE INOPERATIVE. .CYCLED EMERGENCY LIGHT SWITCH SEVERAL TIMES. SYSTEM OPS CHECKED GOOD. OK FOR SERVICE.
Back to JASC 3350