JASC 2560
Service difficulty reports · 40,741
Reports filed under 2560 · Emergency Equipment, 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 = '2560' 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 = '2560' 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 SWAA2014042227309Flashlight · inoperativeL1 DOOR EMERGENCY FLASHLIGHT INOPERATIVE. R & R FLASHLIGHT IAW CMM.SDR R61A201404020504Girt Bar · corrodedDURING HEAVY CHECK, SPLICE BAR INBD OF FWD L2 DOOR GIRT BAR FITTING AFT OF FRAME 5 CORRODED. MX R & R SPLICE BAR IAW SRM 51-40-02, 51-43-03.SDR SWAA2014040326777Flashlight · inoperativeFORWARD GALLEY LOWER EMERGENCY FLASHLIGHT INOPERATIVE. R & R FLASHLIGHT IAW MM.SDR SWAA2014060628801Mount · corrodedLEFT EMER ESCAPE LINE MOUNTING HARDWARE CORRODED. R & R MOUNTING ASSEMBLY IAW SRM.SDR REXA2014040100346Safety Wire · brokenSAFETY WIRE ON FIRST AID KIT BROKEN. R & R FIRST AID KIT IAW AMM 25-61-00.SDR UHLA2014040100281Girt Bar · dirtyARMED INDICATION ON L1 DOOR NOT SHOWING ARMED WHEN CLOSED. ALL OTHER INDICATIONS SHOWING DOOR IS LOCKED AND ARMED. REMOVED DEBRIS IN FLOOR FITTING, OPS CHECK OF L1 DOOR GOOD IAW AMM 52-11-00.SDR N6WA20140401004Hook And Loop · unsecureEMERGENCY OVERWING EXIT HANDLE COVER FELL OFF. SECURED HOOK AND LOOP ON LT OVERWING EXIT DOOR AS REQUIRED. OK FOR SERVICE IAW AMM 52-70-10.SDR SWAA2014040326783Cover · missingRIGHT EMERGENCY EXIT ESCAPE ROPE COVER MISSING. INSTALLED COVER ASSEMBLY IAW SIP.SDR USAA2014040200010Battery · dischargedTHE EMERGENCY FLASHLIGHT AT L3 DOOR NOT BLINKING. REPLACED FLASHLIGHT BATTERY, OPS CHECKED GOOD.SDR USAA2014040100001Battery · dischargedR3 DOOR UPPER FLASHLIGHT LED NOT FLASHING. REPLACED R3 EMERGENCY FLASHLIGHT BATTERY, OPS CHECKED GOOD.SDR SIMA20140331001Cradle · inoperativeFIRST OFFICER'S FLASHLIGHT NOT CHARGING IN HOLDER. R & R FIRST OFFICER`S FLASHLIGHT HOLDER IAW AMM 25-61-02.SDR SIMA20140330021Power Supply · inoperativeBATTERY POWER SUPPLY INOPERATIVE PN 11-0049 & SN 18295. REMOVED BATTERY POWER SUPPLY INOPERATIVE PN 11-0049 & SN 18295.SDR QXEA2014033000249Seal · missingPART OF THE DITCHING DAM RUBBER SEAL MISSING ON MAIN CABIN DOOR. R & R FWD MCD AIRSTAIR DITCHING DAM IAW AMM TASKS 25-62-01-000-801 AND 25-62-01-400-801. APPLIED MISSING PLACARDS ON TOP EDGE OF NEW DITCHING DAM. RETURNED TO SERVICE.SDR SIMA20140330007Flashlight · inoperativeCAPTAIN'S FLASHLIGHT INOPERATIVE. R & R CAPTAIN'S FLASHLIGHT IAW AMM 33-50-16, OPERATIONS CHECKED GOOD.SDR SIMA20140330001Flashlight · defectiveFLIGHT ATTENDANT REPORTS FLASHLIGHT, AFT, NOT CHARGING. R & R FLIGHT ATTENDANT AFT FLASHLIGHT IAW AMM 33-51-00, OPERATIONS CHECKED GOOD.SDR SWAA2014041727197Girt Bar · out of positionL2 DOOR EMERGENCY EVAC SLIDE GIRT BAR OUT OF POSITION. REPOSITIONED GIRT BAR IAW MT.SDR SWAA2014040826936Plate · corrodedR1 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR MOUNT PLATE CORRODED. REPAIRED PLATE IAW SRM.SDR SWAA2014040826935Plate · corrodedR1 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR MOUNT PLATE CORRODED. REPAIRED PLATE IAW SRM.SDR SIMA20140329007Flashlight · inoperativeFLASHLIGHT DOESN'T HOLD CHARGE. R & R WHOLE ASSEMBLY IAW AMM 33-50-16, OPERATIONS CHECKED GOOD AT THIS TIME.SDR ASOA2014040110260Battery · dischargedF/A FLASHLIGHT INTERMITTENTLY WORKING. REPLACED BATTERY IAW AMM 25-60-00. OK FOR SERVICE.SDR FDEA201403280596Lever · bindingVERY DIFFICULT TO ARM THE SLIDE ON THE LEFT CREW ENTRY DOOR. REQUIRED SEVERAL ATTEMPTS TO GET IT ARMED. GENERAL VISUAL INSPECTION CARRIED OUT OF THE ARMING SYS. OPS CHECKED IAW MM 25-66-00-5, SYS CHECKED NORMAL.SDR SIMA20140328012Flashlight · malfunctionedCAPTAIN`S FLASHLIGHT RED INDICATOR LIGHT MISSING. PERFORMED OPERATIONAL CHECK OF CAPTAIN'S EMERGENCY FLASHLIGHT IAW MM 25-61-02. OPS CHECKED GOOD.SDR SIMA20140328004Pbe · unserviceableCOCKPIT PBE HAS A HOLE IN BAG. R & R COCKPIT PBE & BOX IAW AMM 20-10-01 & 35-30-03. FOUND DURING REMOVAL OF EMERGENCY EQUIPMENT.SDR SIMA20140328001Flashlight · inoperativeFWD CABIN FLASHLIGHT INOPERATIVE. R & R FLASHLIGHT IAW AMM 33-50-16. OPERATIONS CHECKED GOOD.SDR SWAA2014040726890Panel · delaminatedR1 DOOR EMERGENCY EVAC SLIDE PANEL DELAMINATED. REPAIRED PANEL IAW MM.SDR R61A201403270449Flashlight · missingCREW REPORTED THAT THE CAPTAINS FLASHLIGHT WAS MISSING.SDR REXA2014032700335Smoke Goggles · brokenOBSERVER`S SMOKE GOGGLES BROKEN. DEFERRED OBSERVER`S SMOKE GOGGLES IAW MEL 25-12-11 AUTH 3567 CH ENTER IN MM02 PLACARD INSTALLED. R & R OBSERVER`S SMOKE GOGGLES IAW CRJ 200 AMM 35-11-15, REMOVED FROM MM02.SDR REXA2014032600333Glowstrip · delaminatedEMERGENCY FLOOR PATH LIGHTING, PHOTO LUMINESCENT, STRIP AT ROWS 11 - 12 C & D HAS DELAMINATION MEASURING ABOUT 4 INCHES IN LENGTH AT MID-POINT OF STRIP.SDR WX0A071898Battery · dischargedFWD FLIGHT ATTENDANT STATION LOWER FLASHLIGHT INOPERATIVE. R & R FWD LOWER FLIGHT ATTENDANT FLASHLIGHT BATTERIES IAW AMM 25-60-00. OPERATIONS CHECKED NORMAL AT THIS TIME.SDR SWAA2014032826594Nut Plate · damagedR1 DOOR SLIDE COVER AFT ATTACH NUTPLATE DAMAGED. R & R NUTPLATE IAW MM.SDR R61A201403260447Flashlight · inoperativeCREW REPORTED THAT THE CAPTAINS FLASHLIGHT WAS INOPERATIVE. MAINTENANCE OPS CHECKED FLASHLIGHT GOOD IAW AMM.SDR SIMA20140326005Holder · brokenFLASHLIGHT BRACKET OVER FLIGHT ATTENDANT`S JUMP SEAT IS BROKEN. R & R WITH SERVICEABLE FWD FLIGHT ATTENDANT’S HOLDER IAW AMM 33-50-16. OPERATIONS CHECKED OK.SDR SIMA20140326003Holder · brokenFLASHLIGHT BRACKET OVER FLIGHT ATTENDANT`S JUMP SEAT IS BROKEN. R & R WITH SERVICEABLE FWD FLIGHT ATTENDANT’S FLASHLIGHT HOLDER IAW AMM 33-50-16. OPERATIONS CHECKED OK.SDR SIMA20140326002Flashlight · inoperativeNR 1 FLIGHT ATTENDANT FLASHLIGHT & MOUNT FELL OFF WALL & WILL NOT CHARGE. REPLACED NR 1 FLIGHT ATTENDANT FLASHLIGHT ASSEMBLY IAW AMM 25-61-02, OPERATIONS GOOD.SDR UHLA2014032500246Fitting · deformedPERMANENT DEFORMATION, R1 DOOR EVAC SLIDE AFT FLOOR FITTING IS GOUGED. REWORK R1 DOOR EVAC SLIDE AFT FLOOR FITTING IAW ETD 2014-170-024655.SDR REXA2014032500330Pbe · unserviceableCOCKPIT & WARDROBE PBES BOTH SQUISHY. R & R COCKPIT & WARDROBE PBE'S IAW PBE USER REFERENCE & PROCEDURES MANUAL, OK FOR SERVICE.SDR GTIA2014032501236Megaphone · inoperativeAFT MEGAPHONE INOPERATIVE. R & R MEGAPHONE IN AFT GALLEY IAW AMM 25-65-51-920-001, MM 25-60-01. OPS CHECKED GOOD.SDR SWAA2014032726560Fitting · dirtyL1 DOOR EMERGENCY EVAC SLIDE RT GIRT BAR FITTING DIRTY. CLEANED FITTING IAW SIP.SDR SWAA2014032726557Battery · dischargedFORWARD OTBD FLASHLIGHT INOPERATIVE. R & R BATTERY IAW MM.SDR SWAA2014032626516Mount Bracket · brokenR2 DOOR EMERGENCY EVAC SLIDE AFT SIDE MOUNT BRACKET BROKEN. R & R BRACKET IAW SRM.SDR USAA2014032600002Strap · unsecureCREW REPORTED A STRAP HANGING UNDER ENTRY DOOR, FWD, SLIDE. SECURED STRAPS AT BOTTOM OF L1 DOOR SLIDE COVER. OPERATED DOOR SEVERAL TIMES OPEN & CLOSE, CHECKED GOOD.SDR SWAA2014032526491Bracket · looseR1 DOOR EMERGENCY EVAC SLIDE GIRT BAR DOOR BRACKET LOOSE. SECURED BRACKET IAW SIP.SDR SIMA20140324003Holder · brokenFIRST OFFICER`S FLASHLIGHT HOLDER BROKEN. R & R FIRST OFFICER`S FLASHLIGHT ASSEMBLY IAW AMM 33-50-16. OPERATIONS CHECKED GOOD.SDR SIMA20140324005Holder · looseFLIGHT ATTENDANT`S FLASHLIGHT HOLDER LOOSE. TIGHTEN FLIGHT ATTENDANT`S FLASHLIGHT SCREWS AS REQUIRED, OPERATIONS CHECKED GOOD.SDR GTIA2014032401227Battery Pack · inoperativeL2 DOOR F/A FLASHLIGHT INOPERATIVE. R & R FLASHLIGHT BATTERY IAW AMM 25-65-53. OPS CHECKED GOOD.SDR R61A201403230475Mount · corrodedDURING HEAVY CHECK, FWD SLIDE MOUNT LUG ON BOTTOM OF L1 DOOR HAS DAMAGE. MAINTENANCE CLEANED SLIDE MOUNT LUG, FOUND DAMAGE TO BE TOP COAT ONLY PRIMED AND REPAIRED TOP COAT IAW SRM 51-23-06.SDR R61A201403230474Bolt · corrodedDURING HEAVY CHECK L1 DOOR FWD SLIDE MOUNT ON BOTTOM OF L1 DOOR BOLT IS CORRODED. MAINTENANCE R & R L1 DOOR FWD SLIDE MOUNT ON BOTTOM OF L1 DOOR BOLT IAW AMM 52-11-40, PN NAS6604D11, BOLT.SDR R61A201403230473Mount · corrodedDURING HEAVY CHECK, AFT SLIDE MOUNT LUG ON BOTTOM OF L1 DOOR HAS DAMAGE. MX CLEANED SLIDE MOUNT LUG ON BOTTOM OF L1 DOOR FOUND DAMAGE TO BE TOP COAT ONLY PRIMED AND REPAINTED TOP COAT IAW SRM 51-23-06.SDR REXA2014032300324Battery · weakFIRST OFFICER'S EMERGENCY FLASHLIGHT BATTERY IS WEAK. R & R FIRST OFFICER`S EMERGENCY FLASHLIGHT ASSEMBLY IAW AMM 25-61-02.SDR SIMA20140323011Flashlight · inoperativeFLIGHT ATTENDANT FLASHLIGHT WAS DISCOVERED IN LAVATORY & INOPERATIVE. DEFERRED IAW MEL 25-53. INSTALLED FLIGHT ATTENDANT FLASHLIGHT IAW CMM 25-60-11. OPERATIONAL TEST GOOD. THIS ACTION RESTORED MEL.
Back to JASC 2560