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 DALA2018010900188Charger · inoperativeEMERGENCY LIGHTS INOP AT3L DOOR. NEED BATTERY PACKS AT LOCATION M33406 AND 33405. FOUND BAD BATTERY CHARGER, REPLACED. ALSO REPLACED 4 EACH BATTERIES. ALL EMERGENCY LIGHTS OPN NORMAL.SDR IPXA2018010825242Battery Pack · dischargedDURING EMERGENCY LIGHT TEST, EMERGENCY LIGHT BATTERY 1 LOW ILLMINATED. R & R THE BATTERY OPS CHECKED GOOD AMM 33-51-01.SDR QXEA2018011000008Switch · failedEMERGENCY LIGHTS REMAINED ON AFTER ACFT POWERED DOWN, WOULD TURN OFF AFTER EXTERNAL POWER APPLIED. REMOVED AND DISASSEMBLED ADVISORY PASSENGER WARNING PANEL IAW AMM 31-51-33-000-801 STEPS 1-4A(6). COMPLETED REMOVAL OF ADVISORY PASSENGER WARNING PANEL AND EMSDR SWAA2018011018969Sign · looseOVERHEAD EMERGENCY EXIT SIGN LIGHT LOOSE IN MIDDLE OF CABIN. SECURED LIGHT PER AMM.SDR SWAA2018011018955Light · brokenFORWARD LAV EMERGENCY EXIT LIGHT BROKEN. R&R LIGHT PER AMM.SDR HALA2018010900006Light · looseEMERGENCY FLOOR LIGHT STRIP LOOSE AT SEAT 25H. REPLACED EMERGENCY FLOOR PATH LIGHT COVER AT SEAT 25H.SDR ASAA2018010823104Charger · inoperativeMID CABIN OVERHEAD EMERGENCY LIGHT INOPERATIVE. ACFT GROUNDED. INSPECTED AND FOUND THE BATTERY CHARGER INOPERATIVE. REMOVED AND REPLACED THE BATTERY AND BATTERY CHARGER IAW WDM 33-51-13-4. PERFORMED AN EMERGENCY LIGHT OPS TEST IAW AMM 33-51-00/501. LIGHTSSDR MASA2018010812897Light · inoperativeCEILING EMERGENCY FLOOD LIGHT ROW 15 INOPERATIVE. PLACED ON MEL.SDR UIEA2018010800043Switch · unsecureEMERGENCY LIGHT SWITCH ON OVERHEAD PANEL NOT SECURE. SECURED THE SWITCH, NORMAL OPS IAW AMM 27-50-10.SDR MASA2018010812895Battery Pack · inoperativeFIVE FWD FLOOD AND AFT MID CABIN EXIT LIGHTS INOPERATIVE. R & R THE BATTERY PACK NR 3.SDR IPXA2018010825215Battery · dischargedFOUND DURING PS-1 CHECK, THE EMERGENCY LIGHT BATTERY 1 LOW ALERT. TROUBLESHOT IAW FIM 33-51-02-00, STEP 6, REL 88.01. REPLACED THE BATTERY IAW AMM 33-51-01, PB 401 REL. 90.01. PERFORMED AN OPS TEST IAW AMM 33-51-01-700-802 FOUND SATISFACTORY. OK TO CONTSDR MASA2018010812894Battery Pack · inoperativeROW 14 FLOOR LEVEL EMERGENCY LIGHTS INOPERATIVE. R & R THE NR 1 AND 3 BATTERY PACKS.SDR CALA2018010800106Power Supply · faultedDURING EMERGENCY LIGHT CHECK, FOUND THE LEFT OVERWING EMERENCY POWER SUPPLY UNIT WITH INTERIOR LIGHT FAULT AND EXTERIOR LIGHT FAULT. REMOVED AND REPLACED THE POWER SUPPLY CONTROL UNIT AND BATTERY IAW AMM 33-51-38, PERFORMED EPSU OPS CHECK IAW AMM 33-51-38 ANSDR CALA2018010800105Power Supply · inoperativeEMERGENCY LIGHT TEST FAILED. REMOVED AND REPLACED THE EPSU AT THE L1 DOOR IAW AMM 33-51-38-400-001-A, CHECKED OK.SDR CALA2018010800104Light · inoperativeSEAT 38C EMERGENCY RED LIGHT INOPERATIVE ADJACENT TO MONUMENT. REPLACED THE LENS. EMERGENCY LIGHTS OPS CHECKED NORMAL.SDR CALA2018010800103Bulb · inoperativeAFT EMERGENCY EXIT, SEAT 15C RED LIGHT INOPERATIVE. REPLACED THE BULBS AND LENS. EMERGENCY LIGHTS OPS CHECKED NORMAL.SDR CALA2018010800102Lamp · inoperativeEMERGENCY EXIT LIGHT ON EXTERIOR OF FUSELAGE AT THE L1 DOOR FOUND INOPERATIVE. REPLACED THE LAMPS, OPS CHECKED GOOD.SDR CALA2018010800101Lamp · inoperativeEMERGENCY EXIT LIGHT ON EXTERIOR OF FUSELAGE AT THE R1 DOOR FOUND INOPERATIVE. REPLACED THE LAMPS, OPS CHECKED GOOD.SDR CALA2018010800097Light · missingROW 3 ADJACENT SEAT B, EMERGENCY LIGHT MISSING. REPLACED THE LIGHT AND OP CHECKED GOOD.SDR DALA2018010800126Lamp · inoperativeSEAT 31ED EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM 33-00, OPS CHECKED GOOD.SDR SWAA2018020719480Battery Pack · failedEMERGENCY BATTERY PACK DID NOT PASS CAPACITY CHECK AT BS 603, RBL 67. R&R BATTERY PACK IAW AMM.SDR SWAA2018020719479Battery Pack · failedEMERGENCY EXIT BATTERY DID NOT PASS CAPACITY CHECK AT BS 603, LBL 67. R&R BATTERY PACK IAW AMM.SDR AALA201801109014Shroud · missingAIRCRAFT WAS NOT GROUNDED. SEAT 9D EMERGENCY LIGHT SHROUD IS MISSING. REPLACED SEAT 9D LIGHT SHROUD PER MM 33-51-11.SDR AALA201801109012Light · looseAIRCRAFT WAS NOT GROUNDED: AFT RIGHT GALLEY DOOR EXIT SIGN AT MID-DOOR HEIGHT CLOSEST TO GALLEY CABINETS, LOOSE FROM SIDEWALL. MAINTENANCE REPLACED LIGHT ASSEMBLY PER AMM 33-51-01 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201801099008Power Supply · defectiveTHE AIRCRAFT WAS GROUNDED. FOUND EMERGENCY PATH LIGHTING FROM ROW 9D THRU 15D VERY DIM. REMOVED AND REPLACED EMERGENCY PATH LIGHTING POWER SUPPLY AND BATTERY PACK PER MM 33-51-07. ALL OPERATIONS AND INDICATIONS NOW TEST NORMAL.SDR AALA201801089047Bulb · burned outBURNED OUT BULBS AT THE OVERWING EXIT EMERGENCY LIGHTS. MAINTENANCE REPLACED THE BULBS IAW AMM 33-51-16-400-001.SDR AALA201801109023Switch · not seatedEMERGENCY EXIT LIGHT SWITCH ON OVERHEAD PANEL WOULD NOT STAY ENGAGED WITH SWITCH. AIRCRAFT WAS GROUNDED. MAINTENANCE RESEATED TOGGLE SWITCH GUARD AND PERFORMED SUCCESSFUL OPS CHECKED IAW AMM 33-51-00.SDR AALA201801109022Lens · contaminatedEXTERIOR EMERGENCY LIGHT NEXT TO THE L1 DOOR HAS MOISTURE UNDER LENS. MAINTENANCE REMOVED, CLEANED, AND REINSTALLED THE LIGHT IAW AMM 33-51-04.SDR AALA201801109021Lens · missingMISSING EMERGENCY EXIT LIGHT LENS AT THE R1 DOOR. MAINTENANCE REPLACED THE LENS IAW 33-51-01 AND PERFORMED A SATISFACTORY OPS CHECK.SDR AALA20180108004Light · crackedTHE AIRCRAFT WAS NOT GROUNDED. EMERGENCY PATH LIGHT ASSEMBLY CRACKED. REPLACED EPL LIGHT ASSEMBLY PER AMM 33-51-14. OPERATION CHECKED PER ECO/J1888AA_0001.SDR AALA20180107002Cover · missingTHE AIRCRAFT WAS NOT GROUNDED. LOWER FORWARD ENTRY WAY WALL LIGHT MISSING COVER. REMOVED AND REPLACED EMERGENCY LIGHT R SIDE PER MM 33-51-00.SDR SWAA2018010918945Battery · dischargedR2 DOOR EXTERIOR EMERGENCY LIGHT INOP. R&R BATTERY IAW AMM.SDR AALA201801099012Lens · missingR4 DOOR EMERGENCY LIGHT LENS MISSING. REPLACED THE LENS. OPS CHECKED GOOD.SDR AALA201801089057Battery · dischargedEMERGENCY FLASHLIGHT AT THE L2 DOES NOT FLASH. REPLACED THE BATTERY. OPS CHECKED GOOD.SDR ASAA2018010723095Lamp · inoperativeEXIT SIGN AT THE RIGHT AFT OVERWING EXIT HAS SEVERAL LAMPS INOPERATIVE. ACFT GROUNDED. REPLACED THE LAMPS AND TESTED IAW AMM 33-51-01-960-801. OPS NORMAL.SDR DALA2018010800148Lens · unsecureEMERGENCY EXIT COVER DIFFUSER LENS MISSING FROM CEILING EXIT LIGHT AT ROW 1. MAINTENANCE LOCATED THE EMERGENCY EXIT COVER AND SECURED IAW AMM 33-51. OK FOR SERVICE.SDR AALA201801089023Lens · brokenFORWARD LEFT LAVATORY EXIT SIGN LENS BROKEN. REPLACED THE LENS. AIRCRAFT WAS GROUNDED.SDR SIMA20180107003Charger · failedBOTH AFT OVERWING EMERGENCY LIGHTS ARE INOPERATIVE. REMOVED AND REPLACED THE NR 4 EMERGENCY LIGHT CHARGER AND BATTERY ASSY, OPS CHECKED BAD IAW AMM 33-50-04.SDR DALA2018010800122Battery Pack · inoperativeFWD AND ENTRANCE AND COCKPIT EMERGENCY LTS INOPERATIVE. REPLACED TWO BATTERIES ON THE EMERGENCY LIGHT.SDR CALA2018010700089Battery Pack · dischargedEMERGENCY EXIT LOC SIGN ON MID FWD AND LEFT OVERWING EXIT LIGHT ASSY WAS REPORTED INOP. REPLACED POWER SUPPLY, BATTERY PACK AND EXIT LOC SIGN LIGHT ASSY REF AMM 33-51-07 . OPS CHK NORMAL.SDR CALA2018010700088Fuse · blownEXTERIOR EMERGENCY LIGHT R4 NOT WORKING RE-LAMPED NO HELP FOUND BAD FUSE ON M734. REMOVE AND REPLACE FUSE IAW AMM 33-51-07 . OPS CHECK GOOD.SDR CALA2018010700090Light · inoperativeSLIDE LIGHT DOOR 2R NEEDS RELAMP. RELAMPED 2R DOOR SLIDE LIGHT. OPS CHECK GOOD.SDR CALA2018010700086Cover · looseL1 DOOR EMERGENCY LIGHT COVER FALLING DOWN. REPLACED LIGHT ASSY.SDR MASA2018010712893Light · inoperativeROW 15 AFT EMER EXIT SIGN INOP. RELAMPED.SDR AALA201801099030Bezel · missingTHE AIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHT BEZEL MISSING AT SET 12D. LIGHTS WORK OK. REPLACED EMERGENCY LIGHTS ASSEMBLY AT SEAT 12D. OPERATIONS CHECK GOOD. SEE CONTROL AALA201801099026 & AALA201801099029SDR AALA201801099029Bezel · missingTHE AIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHT BEZEL MISSING AT SET 11D. LIGHTS WORK OK. REPLACED EMERGENCY LIGHTS ASSEMBLY AT SEAT 11D. OPERATIONS CHECK GOOD. SEE CONTROL AALA201801099026 & AALA201801099030SDR AALA201801099026Bezel · missingTHE AIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHT BEZEL MISSING AT SET 7D. LIGHTS WORK OK. REPLACED EMERGENCY LIGHTS ASSEMBLY AT SEAT 7D. OPERATIONS CHECK GOOD. SEE CONTROL AALA201801099029 & AALA201801099030SDR DALA2018010800184Battery Pack · dischargedEMERGENCY LIGHTS ROWS 1-12 INOPERATIVE. REMOVED AND REPLACED BATTERY PACK B5-227 IAW MM. OPERATION CHECKS GOOD.SDR YENA201801060010Battery Pack · no testFWD EMERGENCY LIGHT BATTERY FAILED TO TEST. R & R THE BATTERY IAW AMM 33-51-38. OPS CHECKED OK.SDR DALA2018010800178Light · detachedSEAT 26D MOUNTED EMERGENCY LIGHT DAMAGED, FALLING OUT OF FRAME. REMOVED THE BUMPER ASSEMBLY. INSTALLED A NEW BUMPER ASSEMBLY.
Back to JASC 3350