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 AALA20150417007Flashlight · defectiveEMERGENCY FLASHLIGHT IN AFT GALLEY UNDER RT FLIGHT ATTENDANT SEAT IS BAD. R & R FLASHLIGHT IAW AMM 25-60-00. SYS CHECKED NORMAL.SDR UHLA2015041700252Cable · malfunctionedAFT RT SIDE SERVICE DOOR GIRT BAR WAS NOT SHOWING A LATCHED INDICATION WHEN CLOSED. R & R R2 DOOR EMERGENCY EVACUATION SLIDE CABLE. OPS CHECK GOOD REF AMM 52-42-40, SUBTASKS 52-42-00-000-801-A, 52-42-40-400-801-A.SDR SWAA2015042038704Glowstrip · crackedRIGHT PHOTO LUMINESCENT STRIPS CRACKED AT ROW 1. R & R STRIPS IAW MM.SDR SWAA2015042038700Glowstrip · crackedLEFT PHOTO LUMINESCENT STRIPS CRACKED AT ROW 1. R & R STRIPS IAW MM.SDR AALA201504179001Battery · dischargedFLIGHT ATTENDANT DOOR 1 FLASHLIGHT INOPERATIVE. REPLACED THE BATTERY TO THE DOOR 1L OTBD FLASHLIGHT.SDR R61A201504160241Battery Pack · inoperativeCREW REPORTED THAT THE AFT F/A FLASHLIGHT WAS INOPERATIVE. MAINTENANCE INSTALLED NEW BATTERIES IN THE AFT F/A FLASHLIGHT IAW AMM AND OPS CHECKED GOOD.SDR R61A201504160240Cradle · brokenCREW REPORTED THAT THE FORWARD F/A FLASHLIGHT BRACKET WAS BROKEN. MAINTENANCE PLACED ON MEL AND LATER R & R FORWARD F/A FLASHLIGHT ASSY IAW AMM AND OPS CHECKED GOOD.SDR MASA2015041612046Pbe · inoperativeFWD PBE RED INDICATOR STICKING OUT. REPLACED PBE.SDR MASA2015041612045Cradle · inoperativeFWD F/A FLASHLIGHT HOLDER NOT BLINKING.SDR WX0A2015042272543Battery · dischargedAFT EMER FLASHLIGHT NOT BLINKING. R & R BATTERY. OPERATIONS CHECKED NORMAL IAW MM 25-60-00.SDR N6WA2015041501Tab · missingSEAT 18D EMER ROPE COVER PULL COVER TAB MISSING. SECURED AS NECESSARY, NO MAINT ACTION REQUIRED.SDR SWAA2015041738648Hook · looseR1 DOOR EMER EVAC SLIDE GIRT BAR HOOK LOOSE. R & R HOOK IAW SRM.SDR SWAA2015041738620Glowstrip · crackedRIGHT PHOTO LUMINESCENT STRIPS CRACKED AT ROW 1. R & R STRIP IAW MM.SDR SWAA2015041738614Glowstrip · crackedLEFT PHOTO LUMINESCENT STRIPS CRACKED AT ROW 1. R & R STRIP IAW MM.SDR SWAA2015041638591Bracket · looseR1 DOOR EMER EVAC SLIDE GIRT BAR AFT BRACKET LOOSE. SECURED BRACKET IAW SRM.SDR SWAA2015041638590Bracket · looseL1 DOOR EMER EVAC SLIDE LINER GIRT BAR BRACKET LOOSE. SECURED BRACKET IAW SRM.SDR SWAA2015052740104Retaining Clip · looseL2 DOOR EMER EVAC SLIDE COVER FWD GIRT BAR RETAINER CLIP LOOSE. R & R CLIP IAW SRM.SDR SWAA2015052039884Cover · damagedR1 DOOR EMER EVAC SLIDE COVER DAMAGED AT LOWER AFT CORNER. REPAIRED COVER IAW CMM.SDR SWAA2015052039883Retaining Clip · looseR1 DOOR EMER EVAC SLIDE COVER FWD GIRT BAR RETAINER CLIP LOOSE. SECURED CLIP IAW SRM.SDR SWAA2015052039882Retaining Clip · looseL1 DOOR EMER EVAC SLIDE COVER AFT GIRT BAR RETAINER CLIP LOOSE. SECURED CLIP IAW SRM.SDR REXA2015041300426Line · frayedLEFT EMERGENCY OVERWING SAFETY LINE IS FRAYED. MECHANIC REMOVED LT OVERWING SAFETY LINE AND INSTALLED SERVICABLE LINE IAW AMM 25-63-04.SDR REXA2015041300424Battery Pack · inoperativeCO-PILOT EMERGENCY FLASHLIGHT BATTERY IS DEAD. MECH R & R CO-PILOTS EMERGENCY FLASHLIGHT BATTERY IAW DME CORPORATION CMM 25-60-11, PAGE 3001 5.0 AND PAGE 7001 4.0. FUNCTIONAL CK GOOD.SDR AALA201504149013Battery · inoperativeAFT FLIGHT ATTENDANT FLASHLIGHT INOPERATIVE. REPLACED AFT FLIGHT ATTENDANT BATTERY. OPERATIONAL CHECKED GOOD.SDR SIMA20150413004Flashlight · inoperativeFLIGHT ATTENDANT FLASHLIGHT INOPERATIVE. R & R IAW AMM 25-61-02. OPERATIONS CHECKED GOOD.SDR REXA2015041300403Reflector · detachedEMERGENCY REFLECTIVE STRIP UNATTACHED FROM FLOOR. SECURED EMER REFLECTIVE STRIP TO GALLEY FLOOR IAW AMM 33-51-01.SDR CALA2015041300279Lens · looseSMALL EXIT SIGN COVER NEAR DOOR 1R HANDLE IS LOOSE & WILL NOT STAY ATTACHED DURING TURBULENCE. ON LT SIDE OF BUSSELL. COVER SECURED, CHECKED OK. THIS ITEM IS SDR.SDR REXA2015041300384Flashlight · inoperativeFOUND BOTH GALLEY & AFT FLIGHT ATTENDANT STATION EMER FLASHLIGHTS INOPERATIVE. R & R ALL 3 EMER FLASHLIGHTS IAW AMM 25-61-02. PART NR ON & OFF P2-07-0001-214.SDR SWAA2015041438482Battery · failedAFT EMER FLASHLIGHT FAILED TEST. R & R BATTERY IAW AMM.SDR ASOA2015041512603Battery Pack · inoperativeF/A FLASHLIGHT INOPERATIVE. REPLACED BATTERIES IN FLASHLIGHT IAW 25-60-00.SDR AALA201504149009Flashlight · inoperativeCREW REPORTED AFT GALLEY INBD FLASHLIGHT INOPERATIVE. R & R AFT GALLEY INBD FLASHLIGHT.SDR GTIA2015041101552Megaphone · inoperativeAFT GALLEY MEGAPHONE INOPERATIVE. R & R AFT GALLEY MEGAPHONE IAW EMERGENCY EQUIPMENT LAYOUT DWG NK320-232-EQ, REV 4. OPS CHECKED GOOD.SDR SWAA2015041338390Bracket · brokenR2 DOOR EMER EVAC SLIDE GIRT BAR CLAMSHELL BRACKET BROKEN. R & R BRACKET IAW MT.SDR MASA2015041112027Flashlight Assy · inoperativeFWD F/A'S FLASHLIGHT INDICATOR LIGHT NOT FLASHING.SDR MASA2015041112026Flashlight Assy · inoperativeAFT F/A'S FLASHLIGHT INDICATOR LIGHT NOT FLASHING.SDR REXA2015041000400Flashlight · failedCAPTAINS EMER FLASHLIGHT FAILS RED LED TEST. R & R FIRST OFFICER & CAPTAINS EMER FLASHLIGHT ASSEMBLY. OPERATIONS CHECKED GOOD IAW AMM 25-61-02.SDR REXA2015041000382Battery Pack · dischargedTASK CARD CR FLIGHT DECK RT EMER FLASHLIGHT RED CHARGED LIGHT NO LONGER FLASHING, BATTERY PN P4-01-0021 EF-1 DME 25-60-02. REPLACED FLIGHT DECK RT EMER FLASHLIGHT BATTERY PACK IAW CMM 25-60-02 PG 6001 3 0 A - F.SDR SIMA20150409008Flashlight · damagedAFT CABIN FLASHLIGHT, CRADLE SHOWS EVIDENCE OF BEING BURNED, TOP & BOTTOM CAP O RINGS ARE DAMAGED. R & R AFT CABIN FLASHLIGHT IAW AMM 33-50-16. FNC GOOD.SDR SIMA20150409001Flashlight · missingFLASHLIGHT AT 18 BC MISSING. FLIGHT CREW PLACARDED IAW MEL 25-53.SDR MASA2015040912021Flashlight · inoperativeF/A NR 1 FLASHLIGHT INOPERATIVE.SDR AALA201504099002Girt Bar · no testSLIDE CONTROL UNIT, 22DH, F HEAT G AFT INDICATOR LIGHT DOES NOT ILLUMINATE WHEN TESTED. R & R SLIDE FITTING, 26DH.SDR AALA201504099001Girt Bar · damagedSLIDE CONTROL UNIT, 21DH, F HEAT G AFT INDICATOR LIGHT DOES NOT ILLUMINATE WHEN TESTED. R & R L4 GIRT BAR FITTING, 25DH.SDR R61A201504080233Battery Pack · dischargedF/A REPORTED THAT THE MEGPHONE BATTERIES WERE LOW. MAINTENANCE R & R MEGAPHONE IAW AMM AND OPS CHECKED GOOD.SDR MASA2015040812017Flashlight · inoperativeF/O'S EMERGENCY FLASHLIGHT INOPERATIVE.SDR REXA2015040600374Battery · dischargedCAPTAINS SIDE EMER LIGHT INOPERATIVE. R &R BATTERY IAW 25-61-00. OPERATIONS CHECKED GOOD.SDR MASA2015040613015Flashlight · inoperativeFWD F/A'S FLASHLIGHT INOPERATIVE.SDR SWAA2015040838264Girt Bar · out of adjustR1 DOOR EMER EVAC SLIDE GIRT BAR FLOOR BRACKET OUT OF ADJUSTMENT. ADJUSTED GIRT BAR IAW SIP.SDR SWAA2015040738239Battery · dischargedRIGHT AFT GALLEY FLASHLIGHT INOPERATIVE. INSTALLED BATTERY IAW AMM.SDR SWAA2015040738237Battery · dischargedAFT EMER FLASHLIGHT INOPERATIVE. R & R BATTERY IAW MM.SDR USAA2015040600001Battery · dischargedFORWARD FLIGHT ATTENDANT STATION FLASHLIGHT NOT CHARGED. REPLACED BATTERY IAW AMM 25-65-00.SDR R61A201504050230Flashlight · inoperativeMAINTENANCE REPORTED THAT THE AFT F/A FLASHLIGHT WAS INOPERATIVE. MAINTENANCE INSTALLED NEW BATTERIES IN AFT F/A FLASHLIGHT IAW AMM AND OPS CHECKED GOOD.
Back to JASC 2560