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 AALA201705199030Battery · dischargedAIRCRAFT WAS NOT GROUNDED. FLIGHT ATTENDANT EMERGENCY FLASHLIGHT BY THE L1 DOOR IS INOPERATIVE. REMOVED AND REPLACED FLASHLIGHT BATTERY IAW AMM 25-64-00. OPERATIONAL CHECK GOOD.SDR MASA2017051812309Battery Pack · dischargedFWD FA FLASHLIGHT LED. REPLACED FLASHLIGHT BATTERY.SDR SWAA2017052213856Fitting · looseR1 DOOR SLIDE FORWARD GIRT BAR FITTING RIVETS LOOSE. SECURED THE FITTING IAW SRM.SDR AALA201705199033Flashlight · missingAIRCRAFT WAS NOT GROUNDED. FLIGHT ATTENDANT EMERGENCY FLASHLIGHT IS MISSING IN THE FORWARD GALLEY, AFT WALL, CENTER RIGHT SEAT. INSTALLED FLASHLIGHT IAW AMM 25-64-00. OPERATIONAL CHECK GOOD.SDR AALA201705199032Flashlight · missingAIRCRAFT WAS NOT GROUNDED. FLIGHT ATTENDANT EMERGENCY FLASHLIGHT IS MISSING IN THE FORWARD GALLEY, AFT WALL, CENTER LEFT SEAT. INSTALLED FLASHLIGHT IAW AMM 25-64-00. OPERATIONAL CHECK GOOD.SDR AALA201705189012Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED. FLIGHT ATTENDANT EMERGENCY FLASHLIGHT AT L2 DOOR IS INOPERATIVE. REMOVED AND REPLACED FLASHLIGHT IAW AMM 25-64-00. OPERATIONAL CHECK GOOD.SDR AALA201705189018Battery · dischargedONE AFT CABIN FLASHLIGHT FOUND TO BE INOPERATIVE AND TAMPER SEAL BROKEN. REPLACED THE BATTERY IN AFT CABIN FLASHLIGHT & TAMPER SEAL IAW AMM 25-60-00.SDR AALA201705199035Flashlight · inoperativeFLASHLIGHT LED DOES NOT FLASH. REPLACED THE FLASHLIGHT.SDR FDEA201705171451Girt Bar · unsecureL1 DOOR GIRT BAR IS LOOSE AND HANGING DOWN. REINSTALLED THE GIRT BAR IAW AMM 25-61-01-4.SDR YENA201705170375Nut Plate · brokenFLT 59, JFK-KIN. RETURN TO FIELD (DUE TO OTHER DISCREPANCY). DOOR R2 NOT ARMED INDICATION IN FLIGHT WITH INDICATION ON CIDS PANEL ALSO. PERFORMED ADJUSTMENT OF GIRT BAR FITTINGS FOR R2 DOOR PAX DOOR ESCAPE SLIDE IAW AMM 52-13-11-820-071-A. FOUND NUT PLATE OF RSDR DALA2017051700172Power Supply · inoperativeHFA CHECK FLIGHT COMPARTMENT STEP 2 FAILED ESCAPE SLIDE LT SW/EPSU (16WL) DOOR 3. REPLACED POWER SUPPLY 16WL TWICE NO HELP UNIT DOES NOT POWER UP. REPLACED POWER SUPPLY AND BATTERY TEST PASSED.SDR AALA201705179026Battery · dischargedAIRCRAFT WAS GROUNDED. DURING PREFLIGHT, OVERWING SLIDE SQUIBS FAILED TEST. REMOVED AND REPLACED RIGHT OFF-WING ESCAPE SYSTEM EMERGENCY BATTERY M962 IAW AMM 25-65-17. OPERATIONAL CHECK GOOD.SDR AALA201705179024Battery · dischargedAIRCRAFT WAS GROUNDED. DURING PREFLIGHT, OVERWING SLIDE SQUIBS FAILED TEST. REMOVED AND REPLACED LEFT OFF-WING ESCAPE SYSTEM EMERGENCY BATTERY M961 IAW AMM 25-65-17. OPERATIONAL CHECK GOOD.SDR SWAA2017051813826Lanyard · looseR1 DOOR EMERGENCY EVAC SLIDE CABLE LOOSE. SECURED LANYARD PER SIP.SDR AALA201705179028Megaphone · inoperativeAFT GALLEY MEGAPHONE INOP PER F/A. REPLACED AFT GALLEY MEGAPHONE IAW MM 25-60-00. OPS CK GOOD. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201706099032Fitting · corrodedCORROSION ON FORWARD GALLEY R1 DOOR LOWER FRAME LOCK FASTENER FITTINGS AT GIRT BAR ATTACH POINTS STRINGER 23R AND FR 20. REPLACED FITTINGS PER SRM 51-42-11 AND DRAWING D53112806.SDR AALA201705179022Battery · dischargedAIRCRAFT WAS NOT GROUNDED. FLIGHT ATTENDANT EMERGENCY FLASHLIGHT MID GALLEY LEFT FORWARD SEAT FAILED TEST. REMOVED AND REPLACED FLASHLIGHT BATTERY. OPERATIONAL CHECK GOOD.SDR AALA201705169007Battery · inoperativeCREW REPORTED THE FLASHLIGHT INOPERATIVE AT THE L4 DOOR. REMOVED AND REPLACED THE BATTERY, CHECKED GOOD.SDR SWAA2017051813824Holder · looseR1 DOOR EMERGENCY EVAC SLIDE GIRT BAR HOLDER LOOSE. ADJUSTED HOLDER PER MT.SDR AALA201705169031Girt Bar · lack of lubeL1 DOOR EMERGENCY EVACUATION SLIDE GIRT BAR STICKS IN HOLDER. LUBRICATED THE GIRT BAR AND HOLDER. OPERATIONAL CHECKED GOOD.SDR CALA2017051501449Battery · faultyEMERGENCY FLASHLIGHT (MISSING, NEEDS NEW BATTERY, ETC.) COCKPIT FLASHLIGHT NEEDS A NEW BATTERY. REPLACED FLASHLIGHT AND BATTERY OPS CHECK NORMAL.SDR MASA2017051512303Flashlight · inoperativeFWD FA FLASHLIGHT INOPERATIVE.SDR SWAA2017051813836Strap · looseR2 DOOR SAFETY STRAP LOOSE. SECURED STRAP BUTTON PER SIP.SDR AALA201705169046Flashlight · missingFLIGHT ATTENDANT EMERGENCY FLASHLIGHT AT THE L2 DOOR AFT FACING THE JUMPSEAT IS MISSING. REPLACED THE FLASHLIGHT ASSEMBLY IAW AMM 20-11-00. OPERATIONAL CHECKED GOOD.SDR AALA201705169028Cover · detachedAFT RIGHT OVERWING EXIT DOOR AT ROW 15 HAS A DETACHED CLOTH COVER THAT HOLDS THE HOOK AND LIFE LINE . ATTACHED THE COVER. OPERATIONAL CHECKED GOOD.SDR AALA201705169015Battery Pack · inoperativeFLASHLIGHT AT THE L2 DOOR IS INOPERATIVE. REMOVED AND REPLACED THE FLASHLIGHT BATTERY PACK IAW AMM 25-64-01. OPS CHECKED GOOD.SDR SWAA2017051713817Strap · brokenFORWARD GALLEY FLASHLIGHT RESTRAINING STRAP BROKEN. R & R THE STRAP IAW MM.SDR SWAA2017051713815Holder · looseR1 DOOR SLIDE GIRT BAR SUPPORT BAR LOOSE. ADJUSTED THE HOLDER IAW MM.SDR SWAA2017051713809Strap · brokenFORWARD EMERGENCY FLASHLIGHT STRAP BROKEN. R & R THE STRAP IAW SIP.SDR MASA2017051412301Flashlight · inoperativeFWD FA FLASHLIGHT INOPERATIVE. REPLACED THE FLASHLIGHT.SDR MASA2017051412299Flashlight · inoperativeFWD FA FLASHLIGHT INOP. PLACED ON MEL.SDR MASA2017051412297Flashlight · inoperativeWD FA FLASHLIGHT INOP. PLACED ON MEL.SDR IPXA2017051417070Axe · damagedMAIN CARGO DECK CRASH AXE BLADE DAMAGED. R & R CRASH AXE IAW AMM 25-60-00-216-005.SDR SWAA2017052213900Retainer · out of adjustR2 DOOR SLIDE GIRT BAR OUT OF ADJUST. ADJUSTED THE GIRT BAR RETAINERS IAW SIP.SDR AALA201705169044Strap · defectiveFLASHLIGHT WILL NOT TURN OFF AND WILL NOT STOW. MAINTENANCE REPLACED FLASHLIGHT STOW STRAP AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201705159030Bustle · looseAIRCRAFT NOT GROUNDED. 2R SLIDE BUSTLE LOOSE. SECURED AS REQUIRED.SDR SWAA2017051613714Megaphone · inoperativeMEGAPHONE INOPERATIVE. R & R THE MEGAPHONE IAW MM.SDR AALA201705169045Girt Bar · obstructedR1 DOOR WILL NOT ARM. REMOVED DEBRIS FROM GIRT BAR. OPERATIONAL CHECKED GOOD.SDR AALA201705169042Cover · detachedR1 DOOR ARMING LEVER COVER IS DETACHED. INSTALLED THE COVER IAW AMM 52-11-00. OPS CHECKED GOOD.SDR GTIA2017051201911Flashlight · no testBOTH FLASHLIGHTS IN THE AFT CABIN WOULD NOT TEST. R & R BOTH FLASHLIGHTS AT AFT FA STATIONS IAW EMERGENCY EQUIPMENT LAYOUT DRAWING NK321-296 EQ.SDR AALA201705139004Lens · detachedLENS FOR CABIN DOOR PRESSURE LIGHT FELL OFF AT THE R4 DOOR. REPLACED CABIN PRESSURE WARNING LIGHT LENS AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR REXA2017051200582Megaphone · inoperativeDURING AN EE-900 CHECK, MEGAPHONE ALARM WAS FOUND INOPERATIVE. R & R THE MEGAPHONE.SDR CALA2017051201405Cover · loose2 OVERWING EXIT SIGN COVERS HAVE COME OFF. INSTALLED 2 EA EMERGENCY EXIT SIGN COVERS ON MID CEILING AS REQUIRED.SDR CALA2017051201373Panel · crackedRT OVERWING EVACUATION SLIDE OUTER SURROUND PANEL HAS SEVERAL CRACKS AT LOWER AFT CORNER AREA. REMOVED AND REPLACED RT OVERWING SLIDE REF AMM 25-62-42-400-001A.SDR MASA2017051212293Flashlight Assy · inoperativeFIRST OFFICER`S FLASHLIGHT RED LIGHT NOT BLINKING.SDR AALA201705129006Battery · dischargedMEGAPHONE BATTERIES INOPERATIVE IN BOTH THE FORWARD AND AFT MEGAPHONES. REPLACED MEGAPHONE BATTERIES OF FWD AND AFT MEGAPHONES IAW AMM 25-65-51-920-001-A.SDR DALA2017051203892Girt Bar · obstructedON ARRIVAL, THE L3 DOOR WOULD NOT DISARM. FOUND DEBRIS IN THE GIRT BAR ATTACH POINT, REMOVED DEBRIS AND ALL CHECKED GOOD.SDR REXA2017051100581Defibrillator · inoperativeBOTH DEFIBRILLATOR`S POWER INOPERATIVE NOT GREEN. REMOVED AND REPLACED IAW CRJ 200 AMM 25-60-00.SDR AALA201705129005Hook · obstructedL2 DOOR SLIDE WILL NOT ARM. REMOVED DEBRIS FROM THE GIRT BAR HOOK.SDR SIMA20170511001Flashlight · inoperativeFA'S FLASHLIGHT DISCHARGED. FOUND STOWED SWITCHED ON. REMOVED AND REPLACED THE FA FLASHLIGHT. OPS CHECKED GOOD.
Back to JASC 2560