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 SWAA2014030725832Flashlight · inoperativeFWD FLASHLIGHT INOPERATIVE. R & R FLASHLIGHT IAW AMM.SDR REXA2014030600262Battery · dischargedFIRST OFFICER`S FLASHLIGHT BATTERY INDICATION LIGHT NOT BLINKING. R & R FLASHLIGHT BATTERY IAW AMM 25-61-00.SDR REXA2014030600261Battery · dischargedCAPTAIN'S EMERGENCY FLASHLIGHT INOPERATIVE. REPLACED CAPTAIN'S EMERGENCY FLASHLIGHT BATTERY. OPERATIONS CHECKED GOOD IAW AMM 25-60-00. PN ON & OFF P4-01-0021.SDR SIMA20140306007Holder · brokenFORWARD FLASHLIGHT HOLDER IN CABIN BROKE. R & R FWD CABIN FLASHLIGHT HOLDER IAW AMM 33-50-16.SDR R61A201403060337Flashlight · dimCREW REPORTED THAT THE AFT F/A FLASHLIGHT WAS VERY DIM. MAINTENANCE R & R FLASHLIGHT IAW AMM AND OPS CHECKED GOOD.SDR SIMA20140306006Flashlight · inoperativeFLIGHT ATTENDANT FWD FLASHLIGHT INOPERATIVE. REPLACED FWD FLIGHT ATTENDANT FLASHLIGHT, OPERATIONS CHECKED NORMAL IAW AMM 33-51-01.SDR MASA2014030630976Battery Pack · inoperativeFWD F/A FLASHLIGHT INOPERATIVE. R & R FLASHLIGHT BATTERIES.SDR SIMA20140305008Flashlight · missingMAIN CABIN AFT EMERGENCY FLASHLIGHT MISSING. DEFERRED AFT EMERGENCY LIGHT FLASHLIGHT IAW MEL 25-53 AUTH 030253-C. REINSTALLED AFT FLASHLIGHT & OPERATIONS CHECKED GOOD IAW AMM 33-51-01. MEL ITEM IS RESTORED.SDR DALA14015020654Girt Bar · frozenDOOR WILL NOT DISARM. FOUND GIRT BAR FROZEN, R & R EMERGENCY POWER RESERVOIR IAW AMM 52-11-30.SDR SIMA20140305002Flashlight · missingFLIGHT ATTENDANT AFT EMERGENCY FLASHLIGHT MISSING. INSTALLED NEW EMERGENCY FLASHLIGHT AFT CABIN IAW AMM 25-60-00.SDR UHLA2014030500185Rod · out of adjustMAIN CABIN DOOR SLIDE INDICATION ARM-DISARM INDICATION IS OFF. R & R INDICATOR ADJUSTMENT ROD ON L1 DOOR IAW AMM 52-11-22. OPS CHECK GOOD.SDR SWAA2014031726119Fastener · corrodedR1 DOOR EMERGENCY EVAC SLIDE HARDWARE CORRODED. R & R HARDWARE IAW SRM.SDR SWAA2014031225980Fitting · corrodedR1 DOOR EMERGENCY EVAC SLIDE GIRT BAR FITTINGS CORRODED. R & R FITTINGS IAW SRM.SDR SIMA20140304002Flashlight · missingFLIGHT ATTENDANT AFT FLASHLIGHT MISSING. INSTALLED AFT F/A FLASHLIGHT AS PER CMM 25-60-11 MEL RESTOREDSDR REXA2014030400252Seal · missingFLIGHT DECK PBE IS MISSING A SEAL. RE SECURED FLIGHT DECK PBE SEAL IAW CRJ AMM 25-63-00.SDR R61A201403040377Flashlight · inoperativeCREW REPORTED THAT THE F/O FLASHLIGHT WAS INOPERATIVE. MAINTENANCE R & R THE F/O FLASHLIGHT IAW AMM AND OPS CHECKED GOOD.SDR REXA2014030400253Cover · unsecureLEFT EMERGENCY LIFE LINE COVER WILL NOT STAY ON. SECURED EMERGENCY ROPE COVER IAW AMM 25-63-04.SDR MASA2014030430969Battery Pack · dischargedAFT F/A FLASHLIGHT DISCHARGED.SDR IPXA4182159Light · inoperativeSLIDE EVACUATION WARNING LIGHT INOPERATIVE. PERFORMED ADJUSTMENT AND TEST IAW MM 52-73-00-501. OPS CHECKED GOOD.SDR ASOA2014030610073Battery Pack · inoperativeFWD F/A FLASHLIGHT INOPERATIVE. R & R FWD FLASHLIGHT BATTERIES IAW AMM 25-61-00. OP TESTED GOOD.SDR SWAA2014030525785Bracket · damagedL2 DOOR EMERGENCY EVAC SLIDE FLOOR BRACKETS ASSEMBLY HARDWARE DAMAGED. R & R BRACKET ASSEMBLY IAW AMM.SDR SWAA2014030525784Bracket · damagedR2 DOOR EMERGENCY EVAC SLIDE FLOOR BRACKET ASSEMBLY HARDWARE DAMAGED. R & R BRACKET ASSEMBLY IAW AMM.SDR SIMA20140303003Cradle · brokenAFT CABIN EMERGENCY FLASHLIGHT CRADLE BROKEN. R & R AFT CABIN EMERGENCY FLASHLIGHT CRADLE IAW AMM TASK 33-50-16-000-801-A & 33-50-16-400-801-A. OPERATIONS CHECKED GOOD.SDR SIMA20140303005Flashlight · inoperativeFIRST OFFICER`S FLASHLIGHT INOPERATIVE. R & R FIRST OFFICER`S FLASHLIGHT IAW AMM 25-61-02. OPERATIONS CHECKED GOOD.SDR SIMA20140303001Cradle · brokenFWD CABIN EMERGENCY FLASHLIGHT CRADLE BROKEN. R & R FWD CABIN EMERGENCY FLASHLIGHT HOLDER IAW 33-50-16-000-801 33-50-16-400-801, OPERATIONS CHECKED GOOD.SDR SWAA2014030425731Girt Bar · dirtyL1 DOOR EMERGENCY EVAC SLIDE GIRT BAR DIRTY. CLEANED GIRT BAR IAW SIP.SDR SIMA20140302004Flashlight · faultyFIRST OFFICER`S FLASHLIGHT VERY HOT & STRONG BURN ODOR IN COCKPIT. ITEM DEFERRED IAW MEL 25-53 AUTH 030666. FIRST OFFICER`S FLASH LIGHT REMOVED FROM ACFT.SDR USAA2014030300002Sign · unsecureDOOR 2L AFT FACING OVERHEAD EXIT SIGN WILL NOT STAY IN PLACE. SECURED EXIT SIGN AT 2L, OK FOR SERVICE.SDR USAA2014030300019Flashlight · inoperativeTHE FWD FLASHLIGHT INOPERATIVE. R & R FWD FLIGHT ATTENDANT FLASHLIGHT.SDR MASA2014030130974Flashlight · inoperativeAFT F/A FLASHLIGHT INOPERATIVE.SDR C77A20140301020Lanyard · frayedFWD SERVICE DOOR EMERGENCY EVACUATION SLIDE BUSTLE PIN LANYARD FRAYED. R & R FWD SERVICE DOOR SLIDE IAW AMM 25-65-01 ON WORK ORDER 784497-253. NO FURTHER DEFECTS. PN 4A4030-5, SN ED1134, MFG GOODRICH, TAT 9675.88, TAC 5595 & TSO 705.48.SDR MASA2014030130972Flashlight · inoperativeAFT F/A'S FLASHLIGHT INOPERATIVE.SDR SWAA2014030425724Battery · disconnectedFWD FLASHLIGHT BATTERY INOPERATIVE. CONNECTED BATTERY IAW SIP.SDR DALA14014245803Girt Bar · brokenL1 DOOR GIRT BAR FWD LEAF SPRING FAILED CHECK, DOES NOT RETAIN SLIDER, SLIDER RIDES OVER SPRING. R & R GIRT BAR AND SPRING CHECK C/W.SDR DALA14014235803Girt Bar · brokenR1 DOOR GIRT BAR, AFT LEAF SPRING IS BROKEN OFF. R & R SERVICEABLE GIRT BAR. SPRING CK C/W.SDR MASA2014030330982Glowstrip · wornFOUND PASSENGER DOOR ILLUMINATING STRIPS WORN, R & R STRIPS.SDR SIMA20140228009Bracket · crackedFORWARD FLIGHT ATTENDANT EMERGENCY FLASHLIGHT CHARGING BRACKET CRACKED. R & R FWD FLIGHT ATTENDANT EMERGENCY FLASHLIGHT CHARGING BRACKET IAW AMM 33-50-16, OPERATIONS CHECKED GOOD.SDR MASA2014022830969Battery Pack · inoperativeAFT F/A FLASHLIGHT NOT FLASHING. MX REPLACED BATTERY.SDR SIMA20140228002Flashlight · defectiveFIRST OFFICER`S FLASHLIGHT CHARGING STATION NOT CHARGING. REPOSITIONED FIRST OFFICER`S FLASHLIGHT 33-5-16 AMM WORKING GOOD.SDR SIMA20140228001Flashlight · inoperativeAFT EMERGENCY FLASHLIGHT INOPERATIVE. R & R AFT EMERGENCY FLASHLIGHT IAW AMM 33-50-16. OPERATIONS CHECKED GOOD, NO FURTHER DEFECTS NOTED.SDR CA140228001Bolt · loose(CAN) DURING ROUTINE INSPECTION OF FORWARD AND AFT F/A WALL MOUNTED SEAT HARNESSES, SEAT BOTTOM PAN PIVOT BOLTS WERE FOUND LOOSE. BOLTS WERE TIGHTENED AND SEAT OPS CHECKED SERVICEABLE.SDR SWAA2014030725845Retaining Clip · looseR1 DOOR EMERGENCY EVAC SLIDE RETAINING CLIPS LOOSE. R & R CLIPS IAW SOPM.SDR SWAA2014030725844Retaining Clip · looseL2 DOOR EMERGENCY EVAC SLIDE GIRT BAR RETAINING CLIPS LOOSE. R & R CLIPS IAW SRM.SDR GTIA201402271189Flashlight · inoperativeL1 DOOR OTBD F/A EMERGENCY FLASHLIGHT FAIL TO TEST. R & R F/O'S EMERGENCY FLASHLIGHT IAW AMM 25-65-52-000-001-A/400-001-A. OPS CHECKED GOOD.SDR SIMA20140227003Flashlight · brokenFLASHLIGHT BASE IN FWD CABIN BROKEN. R & R FLASHLIGHT ASSEMBLY IN FWD CABIN, OPERATIONS CHECKED GOOD IAW AMM 33-50-16.SDR SIMA20140227001Holder · brokenAFT FLIGHT ATTENDANT`S FLASHLIGHT HOLDER BROKEN. R & R AFT FLASHLIGHT & CRADLE IAW CRJ MM 25-61-05, OPERATIONS CHECKED GOOD.SDR FDEA201402260405Battery Pack · inoperativeR1 DOOR SLIDE REMOTE PRESS TO TEST INDICATOR INOPERATIVE. REMOVED AND REPLACED BATTERIES IAW 25-61-04. OK FOR SERVICE.SDR USAA2014022700006Lock · dirtyCREW REPORTED DOOR 4R DIFFICULT TO ARM. FOUND DEBRIS IN GIRT ASSEMBLIES. CLEANED LOCKS & LUBED CATCHES, DOOR ARMS PROPERLY, OK FOR CONTINUED SERVICE.SDR SIMA20140226002Escape Rope · unsecureFIRST OFFICER`S ESCAPE ROPE DOOR OPENS DURING TAKEOFF & LANDING & DURING LIGHT CHOP. RE-SECURED FIRST OFFICER`S ESCAPE ROPE IAW AMM 25-60-00, OPERATIONS CHECKED GOOD.SDR SIMA20140226001Flashlight · inoperativeFLIGHT ATTENDANT REPORTS REAR FLASHLIGHT INOPERATIVE. SECURED IAW AMM 33-50-16, OPERATIONS CHECKED GOOD, NO DEFECT NOTED.
Back to JASC 2560