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 USAA2014021700009Lock · lack of lubeCREW REPORTED L2 DOOR HARD TO ARM & DISARM. MX PERFORMED TROUBLESHOOTING IAW TASK 52-13-00-820-001-A. LUBRICATED L2 DOOR GIRT BAR LOCKS, CHECKED NORMAL & OK FOR SERVICE.SDR R61A201402160269Battery Pack · missingCREW REPORTED THAT THE COCKPIT FLASHLIGHT WAS MISSING BATTERIES. MAINTENANCE REPLACED BATTERIES IAW AMM AND OPS CHECKED GOOD.SDR USAA2014021700001Handle · misalignedUNABLE TO DISARM 1L DOOR. ARM - DISARM HANDLE & GIRT BAR OUT OF SYNC. REMOVED SLIDE & SYNCED HANDLES & GIRT BAR.SDR MASA2014021630936Glowstrip · looseRT OVERWING EXIT LUMINESCENT TAPE LOOSE. MAINTENANCE SECURED TAPE.SDR IPXA2014021981973Girt Bar · stuckCOULD NOT DISARM SLIDE ON ARRIVAL. FOUND FWD END OF GIRT BAR NOT INSTALLED INTO SLIDER. REINSERTED SLIDER ARMS & DISARMS NORMALLY IAW AMM 25-61-21-04.SDR SWAA2014021725186Flashlight · inoperativeAFT INBD FLASHLIGHT INOPERATIVE. R & R FLASHLIGHT IAW AMM.SDR FDEA201402150326Cover Plate · brokenCAPTAIN`S ESCAPE ROPE COVER PLATE BROKE, WILL NOT STAY ON. REINSTALLED LATCHES ON CAPTAIN'S ESCAPE ROPE COVER PLATE, GLUED IAW MM SMP. REINSTALLED COVER IAW MM 25-61-00-4, OPERATIONS CHECKED GOOD AT THIS TIME.SDR SIMA20140214008Flashlight · intermittentAFT EMERGENCY FLASHLIGHT WORKS INTERMITTENTLY. R & R AFT EMERGENCY FLASHLIGHT IAW CMM 25-60-11. OPERATIONS CHECKED GOOD.SDR GTIA201402141169Knob · missingFWD MEGAPHONE MISSING VOLUMN KNOB. R & R FWD MEGAPHONE IAW AMM. OP CHECKED GOOD.SDR GTIA201402141168Knob · missingFWD MEGAPHONE VOLUME KNOB MISSING. R & R MEGAPHONE KNOB IAW CMM. OPS CHECKED GOOD.SDR IPXA2014021781939Girt Bar · malfunctionedSLIDE APPEARED TO DISARM BUT HANDLE WOULD NOT MOVE ENOUGH TO INSTALL PIN. INSERTED GIRT BAR SLIDER IAW AMM 25-61-21-04-01. OPS CHECKED DOOR SLIDE ARM LEVER MULTIPLE TIMES. OPS CHECKED NORMAL.SDR R61A201402140268Flashlight · missingCREW REPORTED THAT THE CAPTAINS FLASHLIGHT WAS MISSING FROM THE ACFT. FLASHLIGHT WASR REPLACED.SDR REXA2014021400205Battery · dischargedFIRST OFFICER`S EMERGENCY FLASHLIGHT INOPERATIVE. R & R FLASHLIGHT BATTERY IAW AMM 25-61-04-04.SDR MASA2014021430932Flashlight · inoperativeFWD FA'S FLASHLIGHT INOPERATIVE.SDR SIMA20140214001Flashlight · inoperativeFLIGHT ATTENDANT`S FLASHLIGHT ON OVERHEAD OF JUMP SEAT IS NOT CHARGING PROPERLY. R & R FLASH LIGHT & CRADLE ASSEMBLY ON OVERHEAD OF FLIGHT ATTENDANT`S JUMP SEAT IAW AMM-33-50-16. OPERATIONS CHECKED GOOD.SDR SWAA2014021925326Flashlight · inoperativeAFT GALLEY FLASHLIGHT INOPERATIVE. R & R FLASHLIGHT IAW AMM.SDR USAA2014021800001Glowstrip · deterioratedC3 CHECK PHOTO LUMINESCENT PATH LIGHTING IS DETERIORATED IN NUMEROUS AREAS. REPLACED PHOTO LUMINESCENT PATH LIGHTING AT L1 & R1 ENTRY DOORS, ENVOY COAT CLOSET, FWD GALLEY & AFT GALLEY AREAS IAW DWG 12P25D0301 & IAW AMM SUPPLEMENT 33-51-10.SDR SWAA2014021725222Girt Bar · out of adjustR1 DOOR EMERGENCY EVAC SLIDE GIRT BAR OUT OF ADJUSTMENT. ADJUSTED GIRT BAR IAW MT.SDR SIMA20140213003Crash Ax · missingCRASH AX MISSING. REPLACED MISSING AX AS REQUIRED.SDR GTIA201402131167Knob · missingF/A REPORTS VOLUME KNOB MISSING ON MEGAPHONE. INSTALLED NEW MEGAPHONE AT FWD F/A STATION IAW EMERGENCY EQUIPMENT LAYOUT.SDR SWAA2014021725208Girt Bar · out of adjustR1 DOOR EMERGENCY EVAC SLIDE GIRT BAR OUT OF ADJUSTMENT. ADJUSTED GIRT BAR IAW MM.SDR SWAA2014021725207Stop Fitting · crackedL2 DOOR EMERGENCY EVAC SLIDE GIRT BAR AFT RETAINER COLLAR CRACKED. R 7 R GIRT BAR STOP IAW MM.SDR SWAA2014021425175Retaining Clip · looseR1 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR RETAINER CLIP LOOSE. SECURED CLIP IAW SRM.SDR GTIA201402121166Flashlight · inoperativeAFT SINGLE F/A AISLE SEAT FLASHLIGHT LED PRESS TO CHECK INOPERATIVE. R & R CABIN EMERGENCY FLASHLIGHT IAW AMM. OPS CHECKED GOOD.SDR SIMA20140212002Flashlight · inoperativeFIRST OFFICER'S EMERGENCY FLASHLIGHT INOPERATIVE. R & R FIRST OFFICER'S EMERGENCY FLASHLIGHT & BATTERY IAW AMM 33-50-16-000-801-A & 33-50-16-400-801-A. OPERATIONS CHECKED GOOD, NO DEFECTS NOTED.SDR SIMA20140212001Holder · brokenFORWARD FLIGHT ATTENDANT`S FLASHLIGHT HOLDER BROKEN. DEFERRED IAW MEL 25-53 AUTH 020570-C. COMPLIED WITH THE MEL PROCEDURES.SDR GTIA201402111164Flashlight · inoperativeR4 F/A SEAT FLASHLIGHT WILL NOT TEST". R & R R4 DOOR F/A SEAT FLASHLIGHT IAW CMM. OPS CHECKED & TESTED GOOD.SDR GTIA201402111163Flashlight · inoperativeAFT FLASHLIGHT NEAR F/A JUMPSEAT INOPERATIVE. R & R FLASHLIGHT ASSY IAW DME CMM. OP'S CHECKED GOOD.SDR GTIA201402111162Flashlight · inoperativeFWD INBD F/A EMERGENCY FLASHLIGHT BROKEN. R & R EMERGENCY FLASHLIGHT IAW FWD INBD F/A SEAT IAW CMM.SDR REXA2014021100200Battery · dischargedFIRST OFFICER'S EMERGENCY FLASHLIGHT STRAP BROKEN. FOUND BATTERY DEAD R & R FLASHLIGHT BATTERY & STRAP IAW CRJ200 AMM 25-61-02. OPERATIONS CHECKED GOOD.SDR SIMA20140211003Cradle · brokenAFT FLIGHT ATTENDANT`S FLASHLIGHT CRADLE BROKEN. R & R AFT FLIGHT ATTENDANT`S FLASHLIGHT & CRADLE IAW 33-50-16, OPERATIONS CHECKED GOOD.SDR SIMA20140211004Flashlight · inoperativeFLIGHT ATTENDANT'S REAR FLASHLIGHT IS INOPERATIVE. R & R REAR FLASHLIGHT ASSEMBLY IAW AMM 33-50-16, OPERATIONS CHECKED GOOD.SDR MASA2014021130930Battery Pack · inoperativeFWD FLASHLIGHT NOT CHARGING. REPLACED BATTERY.SDR R61A201402100262Flashlight · missingCREW REPORTED THAT THE CAPTAIN`S FLASHLIGHT WAS MISSING. INSTALLED FLASHLIGHT IAW AMM.SDR SIMA20140210002Cradle · brokenBRACKET ON FIRST OFFICER`S FLASHLIGHT CRADLE BROKEN. R&R FIRST OFFICER`S EMERGENCY FLASHLIGHT BASE IAW AMM 33-50-11. OPERATIONS CHECKED GOOD MEL RESTORED.SDR SIMA20140210005Holder · brokenFIRST OFFICER`S FLASHLIGHT HOLDER BROKEN. R & R FIRST OFFICER'S FLASHLIGHT ASSEMBLY IAW AMM 33-50-16. OPERATIONAL CHECKED GOOD.SDR REXA2014021000192Battery · dischargedCAPTAIN`S SIDE FLASHLIGHT BATTERY DEAD. R & R FLASHLIGHT BATTERY IAW CRJ200 AMM 25-61-02.SDR USAA2014021100001Mechanism · detachedUNABLE TO ARM 2R DOOR. RE-ATTACHED R2 DOOR SLIDE ARMING MECHANISM. OPERATIONS CHECKED NORMAL, OK FOR CONTINUED SERVICE.SDR SIMA20140210004Holder · wornREAR FLASHLIGHT HOLDER WORN. R & R REAR FLASHLIGHT HOLDER ASSEMBLY IAW AMM 33-50-16. OPERATIONS CHECKED GOOD.SDR SIMA20140210001Holder · looseREAR FLASHLIGHT HOLDER LOOSE. SECURED REAR FLASHLIGHT IAW STANDARD MX PRACTICES.SDR REXA2014020900198Strap · brokenEMERGENCY FLASH LIGHT BEHIND CAPTAIN'S SEAT SECURING STRAP BROKE. REPLACED EMERGENCY FLASHLIGHT ASSEMBLY IAW CRJ 200 AMM CHAPT 25. OPERATIONS CHECKED GOOD.SDR MASA2014020930919Megaphone · malfunctionedAFT MEGAPHONE VOLUME LOW. MX C/W TSD FOR NEW MEGAPHONE INSTALLATION.SDR MASA2014020930918Flashlight Assy · inoperativeFWD F/A FLASHLIGHT INOPERATIVE.SDR MASA2014020930915Flashlight Assy · inoperativeFORWARD F/A FLASHLIGHT LED NOT BLINKING DURING PREFLIGHT INSPECTION.SDR UHLA2014020800079Hose · looseR2 DOOR DISARM HANDLE WILL NOT MOVE TO DISARM POSITION. FOUND FWD TWO AFT R2 ESCAPE SLIDE FITTING ASSEMBLY HOSE LOOSE. ADJUSTED PLATES REF AMM 20-10-01 AND AMM 52-42-40. OPS CHECKED GOOD.SDR SWAA2014021125057Flashlight · inoperativeFWD EMERGENCY FLASHLIGHT INOPERATIVE. R & R FLASHLIGHT IAW EA.SDR SIMA20140208002Holder · brokenFIRST OFFICER`S FLASHLIGHT HOLDER FINGER BROKEN OFF. R & R FLASHLIGHT HOLDER IAW AMM 33-50-16, OPERATIONS CHECKED GOOD.SDR R61A201402080222Flashlight · inoperativeCREW REPORTED THE CAPTAINS FLASHLIGHT WAS INOPERATIVE. MAINTENANCE R & R THE FLASHLIGHT IAW AMM AND OPS CHECKED GOOD.SDR USAA2014021000002Battery · dischargedDOOR 1 LT, FWD LT HAND CREW REST EMERGENCY TORCH BATTERY FLAT. REPLACED THE BATTERY.SDR UHLA2014020700078Handle · stuckR1 DOOR STUCK HALF WAY IN ARM/DISARM POSITION. COMPLIED WITH EO-52-41-0002. FUNCTIONAL CHECKED GOOD AT THIS TIME.
Back to JASC 2560