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 YENA201809230362Battery · dischargedDURING HEAVY MAINTENANCE, CHECKS FOUND EPSU'S 11WL,13WL,& 14WL TO HAVE LOW VOLTAGE NEED TO BE RECHARGED OR REPLACED. REMOVAL OF EPSU BATTERIES 11WL, 13WL, & 14WL WAS PERFORMED IAW AMM TASK 33-51-38-000-002-A REV 74. INSTALLATION OF THE EPSU BATTERIES 11WL,13WLSDR YENA201809230361Battery · dischargedDURING HEAVY MAINTENANCE, CHECKS FOUND EPSU'S 11WL,13WL,& 14WL TO HAVE LOW VOLTAGE NEED TO BE RECHARGED OR REPLACED. REMOVAL OF EPSU BATTERIES 11WL, 13WL, & 14WL WAS PERFORMED IAW AMM TASK 33-51-38-000-002-A REV 74. INSTALLATION OF THE EPSU BATTERIES 11WL,13WLSDR YENA201809230360Battery · dischargedDURING HEAVY MAINTENANCE, CHECKS FOUND EPSU'S 11WL,13WL,& 14WL TO HAVE LOW VOLTAGE NEED TO BE RECHARGED OR REPLACED. REMOVAL OF EPSU BATTERIES 11WL, 13WL, & 14WL WAS PERFORMED IAW AMM TASK 33-51-38-000-002-A REV 74. INSTALLATION OF THE EPSU BATTERIES 11WL,13WLSDR SWAA2018092625557Battery · dischargedEMERGENCY LIGHTS BATTERY INOP AT M1672. R&R BATTERY PER AMM.SDR SWAA2018092625556Battery · dischargedEMERGENCY LIGHTS BATTERY INOP AT M1670. R&R BATTERY PER AMM.SDR SWAA2018092625539Battery · dischargedEMERGENCY LIGHTS BATTERY INOP AT M1668. R&R BATTERY PER AMM.SDR SWAA2018092425451Sign · looseEMERGENCY EXIT SIGN IN CEILING AT OVERWING EXITS LOOSE. R&R SIGN IAW AMM.SDR DALA2018092505741Sign · looseEXIT SIGN OVERHEAD DOOR 2R HANGING LOOSE. RE INSTALLED. OPS CK OK.SDR ASAA2018092426214Power Supply · inoperativeEXTERNAL EMERGENCY EXIT LIGHT INOP AT FWD LEFT OVERWING EMERGENCY EXIT. GROUNDED - YES. EXTERNAL EMERGENCY LIGHT POWER PACK REPLACED & OPS CHECK GOOD IAW AMM 33-51-06-960-806.SDR ASAA2018092426202Power Supply · inoperative'CUSTOMER WALK' EMERGENCY CABIN LIGHT AT FOLLOWING LOCATION INOP ROW 6 ABC, 9 ABC AND 11 ABC. GROUNDED - YES. EMERGENCY CABIN LIGHT POWER PACK ASSY M2335 REPLACED (SN: 33706) IAW AMM 33-51-06-960-806 OPS CHECK GOOD.SDR AALA201809249032Lens · missingL1 DOOR EXIT LIGHT LENS WAS MISSING. INSTALLED A LENS IAW AMM 33-51-13.SDR AALA201809249017Lens · missingTHE R4 DOOR EXIT LIGHT LENS WAS MISSING. REPLACED EXIT LIGHT LENS. AIRCRAFT OK FOR SERVICE.SDR AALA201809249016Light · brokenROW 25 EMERGENCY EXIT LIGHT WAS BROKEN. INSTALLED A NEW EMERGENCY LIGHT. OPS CHECKED GOOD.SDR SIMA20180923003Power Unit · inoperativeFWD EMERGENCY EXIT LIGHT INOP. REPLACED THE FWD EMERGENCY EXIT LIGHT POWER UNIT IAW AMM 33-50-01. OPC GOOD.SDR SWAA2018092625555Battery Pack · dischargedEMERGENCY BATTERY PACK INOP AT M1672. R&R BATTERY PACK PER AMM.SDR SWAA2018092425502Light · inoperativeRT EMERGENCY LIGHTS ON FUSELAGE JUST BEHIND WING INOP. RELAMPED LIGHT PER AMM.SDR SWAA2018092425477Light · inoperativeLT EMERGENCY LIGHTS ON FUSELAGE JUST BEHIND WING INOP. RELAMPED LIGHT PER AMM.SDR SWAA2018092425476Light · inoperativeL1 DOOR EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT IAW PER AMM.SDR SWAA2018092425475Light · inoperativeR1 DOOR EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT IAW PER AMM.SDR SWAA2018092425474Sign · looseLT EMERGENCY EXIT SIGN IN AFT GALLEY LOOSE. SECURED SIGN PER SRM.SDR SWAA2018092425415Cover · missingEMERGENCY LIGHT SWITCH COVER MISSING. R&R KORRY LIGHT PER SWPM & AMM.SDR ASAA2018092426200Power Supply · inoperativeR1 DOOR EMERGENCY LIGHTS INOP. GROUNDED - YES. REMOVED AND REPLACED M1674 POWER SUPPLY S/N 13913 IAW AMM 33-51-06-960-806. OPS CHECK GOOD.SDR AALA201809249022Lens · brokenEMERGENCY LIGHT AT SEAT 3L, THE LENS WAS BROKEN. REPLACED LIGHT ASSY IAW AMM 33-51-09.SDR CALA2018092401989Charger · inoperativeC/O EMER LIGHT FOUND BATTERY M33098 CHARGER ASSY INOP AT DR2 RT. REPLACED THE M33098 BATTERY CHARGER ASSY AND C/O EMER LIGHT OPERATION TEST FOUND NORMAL REF AMM 33-51-06-960-803 AND AMM 33-51-06-710-003 REV 83.SDR MASA2018092211399Light · inoperativeROW 11 OVHD EMERG FLOOD LIGHT INOP.SDR SWAA2018102226077Light · brokenFORWARD LOWER CEILING CLOSEOUT PANEL, EMERGENCY EXIT LIGHT ASSEMBLY BROKEN. R&R LIGHT ASSEMBLY IAW AMM.SDR SWAA2018092725593Lens · unsecureFORWARD ENTRY DOOR EXIT SIGN CAME OFF. SECURED LENS PER AMM.SDR SWAA2018092725589Battery Pack · dischargedLT OVERWING EXIT LIGHT INOP AT LOCATION M1668. R&R BATTERY PACK PER AMM.SDR SWAA2018092725588Battery Pack · dischargedLAV A EXIT LIGHT INOP AT M1675. R&R BATTERY PACK PER AMM.SDR SWAA2018092725587Battery Pack · dischargedR1 DOOR EXIT LIGHT INOP. R&R BATTERY PACK PER AMM.SDR SWAA2018092425504Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT LOCATION M01675. R&R BATTERY PER MM.SDR SWAA2018092425503Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT LOCATION M01670. R&R BATTERY PER MM.SDR SWAA2018092425444Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT LOCATION M01672. R&R BATTERY PER MM.SDR AALA2018092549036Power Supply · inoperativeALL FOUR ISLE RED EMERGENCY LIGHTS WERE INOPERATIVE AT THE FIRST OVERWING AREA DOORS. MAINTENANCE TROUBLESHOT THE LIGHTS IAW TSM 33-51-00-810-802-A, AND FOUND A FAULTY POWER SUPPLY 14WL. MAINTENANCE REPLACED THE POWER SUPPLY IAW AMM 33-51-38.SDR HALA2018092100242Sign · unsecureDOOR 1L EXIT SIGN FELL OFF. RE-SECURED DOOR 1L EXIT SIGN.SDR DALA2018092405734Light · inoperativeOVERWING EMERGENCY LIGHTS (3 EACH) ARE INOP ON RIGHT SIDE OF FUSELAGE. REPLACED LIGHT BULBS IAW AMM.SDR DALA2018092405731Light · inoperativeEMERGENCY LIGHTS CHECK. FOUND RT AFT OVERWING LIGHT INOP. R&R RT AFT OVERWING LIGHT BULB PER AMM 33-50. OPS NML.SDR DALA2018092405714Battery · dischargedEMERGENCY LIGHTS AT SEAT ROW 46 THROUGH 49 AND DOOR R4 INOP. REPLACED BATTERY PACK M736 PER AMM 33-51-07. OPS NML.SDR DALA2018092405720Power Supply · inoperativeDURING SERVICE CHECK MAINTENANCE FOUND ROW 24-30 LOWER EMERGENCY LIGHTS TO BE INOPERATIVE. THEY REPLACED THE POWER SUPPLY PER AMM 33-53. AND THE OPERATIONAL CHECK IS GOOD.SDR BUEA20180924001Battery · dischargedDEN- DAYLIGHT CONDITIONS, OAT +80F, ON COMING CAPTAIN STATED HALF OF THE EMERGENCY LIGHTS FAILED TO ILLUMINATE ON PREFLIGHT. UTILIZED THE APU GENERATOR TO RECHARGE THE (EMERGENCY POWER SUPPLY) BATTERIES WITH NO FURTHER ISSUES. THIS SDR IS BEING SUBMITTED PER SDR DALA2018092105695Battery · dischargedAFT EMER EXIT LIGHTS INOP. REPLACED THE M737 BATTERY REF AMM 33-51.SDR MASA2018092111395Light · inoperativeGALLEY FLR LVL EMER FLOOD LIGHT INOP. PLACED ON MEL.SDR SWAA2018092425466Sign · looseMID CABIN CEILING EXIT SIGN LOOSE. SECURED SIGN PER SIP.SDR SWAA2018092425465Battery Pack · dischargedEMERGENCY LIGHTS INOP AT M1674. R&R BATTERY PACK IAW AMM.SDR SWAA2018092425418Battery Pack · failedEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK AT LOCATION M01673. R&R BATTERY PACK PER AMM.SDR AALA2018092419017Battery Pack · no testDURING ACCOMPLISHMENT OF CARD 2735, FOUND THE BATTERY PACK M33096 DID NOT WORK FOR 15 MINUTES. REPLACED BATTERY PACK IAW AMM 33-57-06.SDR DALA2018092405716Battery · dischargedDURING SERVICE CHECK, MAINTENANCE FOUND THE COCKPIT EMERGENCY LIGHT TO BE INOPERATIVE. TROUBLESHOOTING LEAD TO A DEFECTIVE BATTERY IN THE POWER PACK REF AMM 33-53. BOTH BAD CELLS IN THE BATTERY PACK WERE REPLACED. OPERATIONAL CHECK WAS GOOD.SDR AALA201809219038Battery · no testWHILE ACCOMPLISHING JC 33C22033002, THE L1 DOOR EMERGENCY LIGHT POWER SUPPLY BATTERY FAILED. MAINTENANCE REPLACED THE BATTERY AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201809219030Battery · no testDURING A CIDS TEST, EMERGENCY POWER SUPPLY FAULTED CLASS 1. MAINTENANCE REPLACED THE POWER SUPPLY BATTERY 12WL. PERFORMED A SATISFACTORY OPERATIONAL CHECK.SDR AALA201809219035Power Supply · no testPOWER SUPPLY 14WL FAILED AN OPS CHECK. REPLACED THE POWER SUPPLY, AND BATTERY PACK IAW AMM 33-51-38. OPS CHECKED GOOD. THE AIRCRAFT WAS OK FOR SERVICE.
Back to JASC 3350