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 SIMA20140106002Flashlight · inoperativeCABIN FWD FLASHLIGHT INOPERATIVE. FLIGHT CREW PLACARDED IAW MEL 2553 AUTH 010277C MOC 135181. R & R FWD CABIN EMERGENCY FLASHLIGHT IAW AMM 33-50-16 STEPS 2 J 1 & 3 I 4. OPERATIONS CHECKED GOOD. MEL RESTORED.SDR R61A201401060036Glowstrip · looseCREW REPORTED THAT THE PHOTO LUMINESCENT STRIP BY SEAT 1D WAS LOOSE. MAINTENANCE SECURED STRIP IAW AMM AND OPS CHECKED GOOD.SDR SWAA2014010823880Attach Bracket · looseL2 DOOR EMERGENCY EVAC SLIDE UPPER FWD ATTACH BRACKET LOOSE. R & R BRACKET IAW SRM.SDR R61A201401060028Flashlight · inoperativeCOCKPIT FLASHLIGHT INOPERATIVE. R & R FLASHLIGHT IAW AMM 25-00-00. OPS CHECKED GOOD.SDR MASA2014010620838Glowstrip · brokenSERVICE DOOR PHOTO ILLUMINESCENT STRIP, BROKEN. REPLACED STRIP.SDR USAA2014010700009Attach Fitting · dirtyDOOR 2R IS DIFFICULT TO ARM & DISARM, ARMING LEVER IS STIFF. CLEANED & LUBRICATED GIRT BAR FITTINGS IAW A320 AMM 25-62-44.SDR SIMA20140106005Flashlight · malfunctionedFIRST OFFICER`S FLASHLIGHT RED CHARGING LIGHT NOT COMING ON. RESET FIRST OFFICER`S FLASHLIGHT, OPERATIONS CHECKED GOOD IAW AMM CH 33-51-01.SDR SIMA20140106004Holder · brokenFIRST OFFICER`S FLASHLIGHT HOLDER BROKEN. R & R FLASH LIGHT HOLDER IAW AMM 33-50-16, OPERATIONS CHECKED GOOD.SDR REXA2014010500108Pbe · openPBE BAG OPEN. REPLACED PBE IAW 35-30-01, OK FOR SERVICE.SDR SIMA20140105012Flashlight · inoperativeFLIGHT ATTENDANT`S FWD FLASHLIGHT INOPERATIVE. FLIGHT CREW PLACARDED IAW MEL 2553. R & R FWD FLIGHT ATTENDANT`S FLASHLIGHT IAW AMM 33-50-16. OPERATIONS CHECKED GOOD. MEL ITEM RESTORED.SDR FDEA201401050021Light · inoperativeR1 DOOR PRESS TO TEST LAMP INOPERATIVE. R & R BULBS IAW AMM CHAPTER 25-61-04-4. OPERATIONS CHECKED GOOD.SDR USAA2014010600003Battery · dischargedLIH FLIGHT ATTENDANT`S FLASHLIGHT INOPERATIVE AT L2 DOOR ACFT LT. REPLACED BATTERY IN FLASHLIGHT.SDR R61A201401040027Flashlight · inoperativeF/O FLASHLIGHT DOES NOT WORK. R & R FLASHLIGHT ASSY IAW AMM 33-51-00. OPS CHECKED GOOD.SDR SIMA20140104006Mount Bracket · brokenAFT CABIN FLASHLIGHT MOUNTING BRACKET IS BROKEN. R & R FLIGHT ATTENDANT`S NR 1 FLASHLIGHT IAW CRJ-700 AMM-25-61-02.SDR WX0A071809Battery · dischargedAFT FLIGHT ATTENDANT`S FLASHLIGHT INOPERATIVE. R & R AFT FLIGHT ATTENDANT`S FLASHLIGHT BATTERY IAW AMM 25-60-00, OPERATIONS CHECKED GOOD.SDR USAA2014010600023Attach Fitting · lack of lubeDOOR 2L HARD TO ARM & DISARM. LUBED LOWER GIRT BAR ATTACHMENT.SDR UIEA2014010600001Flashlight · inoperativeFLIGHT DECK FLASHLIGHT NOT CHARGING. R & R FLASH LIGHT IAW MM 25-63-00.SDR SWAA2014010823896Retainer · brokenR1 DOOR EMERGENCY EVAC SLIDE GIRT BAR RETAINER BROKEN. REPAIRED RETAINER IAW SRM.SDR SWAA2014010723813Hook · out of adjustR1 DOOR EMERGENCY EVAC SLIDE GIRT BAR HOOKS OUT OF ADJUSTMENT. ADJUSTED HOOKS IAW SIP.SDR REXA2014010300106Pbe · defectiveAFT PBE APPEARS DEFECTIVE. R & R AFT PBE IAW ESSEX CMM PRM-01. OK FOR SERVICE.SDR YENA20140103004Girt Bar · frozenCREW REPORTED THAT R1 DOOR ARMING HANDLE UNABLE TO MOVE UP. THE TECH FOUND AFT LOCK ON GIRT BAR FROZEN, UNFROZE GIRT BAR, OPS CHECKED GOOD IAW 52-12-40.SDR MASA2014010320834Flashlight · inoperativeFWD F/A EMERGENCY FLASHLIGHT LED NOT BLINKING.SDR ASOA2014010609737Flashlight · inoperativeFWD F/A FLASHLIGHT INOPERATIVE. INSTALLED NEW FLASHLIGHT IAW AMM 25-61-01. OK FOR SERVICE.SDR REXA2014010200104Defibrillator · inoperativeF/A NOTED AED INSERVICEABLE DUE TO SOLID RED BATTERY INDICATION. REPLACED AED IAW AMM 25-61-04 ACFT OK FOR SERVICE.SDR SWAA2014010823887Girt Bar · dirtyL1 DOOR EMERGENCY EVAC SLIDE GIRT BAR DIRTY. CLEANED GIRT BAR IAW AMM.SDR SWAA2014010223754Fastener · looseR2 DOOR EMERGENCY EVAC SLIDE COVER LOWER SUPPORT FASTENERS LOOSE. R & R FASTENER ASSEMBLY IAW SRM.SDR SWAA2014010223753Retaining Clip · looseR1 DOOR EMERGENCY EVAC SLIDE COVER GIRT BAR FWD RETAINER CLIP LOOSE. SECURED CLIP IAW SRM.SDR SWAA2014010223752Retaining Clip · looseL1 DOOR EMERGENCY EVAC SLIDE COVER GIRT BAR AFT RETAINER CLIP LOOSE. SECURED CLIP IAW SRM.SDR R61A201401010021Flashlight · inoperativeFORWARD F/A FLASHLIGHT INOPERATIVE. R & R FWD F/A FLASHLIGHT IAW AMM 33-51-01. OPS CHECKED GOOD.SDR UHLA2014010100001Girt Bar · frozenR2 SERVICE DOOR WILL NOT OPEN IAW AMM 12-22-01, ICE REMOVED FROM GIRT BAR BRACKETS. DOOR OPERATIONS CHECK OK.SDR SIMA20140101001Mount Bracket · brokenFLIGHT ATTENDANT'S FWD EMERGENCY FLASHLIGHT MOUNTING BRACKET CLIP BROKEN. REMOVED AND INSTALLED SERVICEABLE FLIGHT ATTENDANT'S FWD EMERGENCY FLASHLIGHT MOUNTING BRACKET IAW AMM 25-61-02. OPERATIONS CHECKED GOOD.SDR MASA2014010120832Battery Pack · inoperativeFWD F/A EMERGENCY FLASHLIGHT LED NOT BLINKING. REPLACED BATTERIES.SDR USAA2014010200001Battery · dischargedJUMP SEAT BY 4L DOOR, BREAKAWAY FLASHLIGHT NEEDS REPLACED. REPLACED BATTERY IN CABIN FLASHLIGHT AT JUMP SEAT BY 4L DOOR, CHECKED OK.SDR SIMA20131231004Flashlight · inoperativeON FLIGHT 3345 CREW REPORTED AFT FLASHLIGHT INOPERABLE. AIRCRAFT WAS REMOVED FROM SERVICE. REMOVED AND REPLACED F/A REAR FLASHLIGHT IAW EMB 140 AMM 33-50-16 OPC GOOD AT THIS TIME.SDR SIMA20131231001Holder · brokenFIRST OFFICER`S FLASHLIGHT HOLDER CLIP BROKEN. R & R FIRST OFFICER`S FLASHLIGHT & HOLDER IAW AMM 33-50-16. OPERATIONS CHECKED GOOD.SDR SIMA20131231002Flashlight · defectiveCAPTAIN`S FLASHLIGHT NOT SECURE IN HOLDER & NOT CHARGING. R & R CAPTAIN`S FLASHLIGHT ASSEMBLY IAW AMM 33-50-16. OPERATIONS CHECKED GOOD MEL IS RESTORED.SDR USAA2014010200008Battery · dischargedCREW REPORTED THE EMERGENCY FLASHLIGHT AT AFT LT CABIN JUMP SEAT DOES NOT FLASH. REPLACED BATTERY ON AFT LT EMERGENCY FLASHLIGHT, OK FOR SERVICE.SDR USAA2014010200002Battery · dischargedAFT RT FLASHLIGHT NEEDS TO BE REPLACED. REPLACED BATTERY & RESEALED.SDR CALA2014010290038Smoke Goggles · contaminatedCAP SMOKE GOGGLES & COVER SOILED WITH LIQUID. REPLACED GOGGLES & COVER OK TO CONTINUE.SDR R61A201312301350Flashlight · inoperativeCAPTAIN'S FLASHLIGHT INOPERATIVE, STEADY RED DOT IS SHOWING BUT LIGHT BULB IS OUT. REPLACED FLASHLIGHT IAW AMM 33-51-01. OPS CHECKED GOOD.SDR SIMA20131230006Flashlight · inoperativeFIRST OFFICER’S FLASHLIGHT INOPERATIVE. RELAMPED FIRST OFFICER`S FLASHLIGHT AS REQUIRED.SDR GTIA201312301096Flashlight · inoperativeL2 FLASHLIGHT INOPERATIVE. R & R FLASHLIGHT IAW CMM 25-60-02.SDR CALA2013123194073Cover · missing4L CABIN ENTRY DOOR FWD GIRT BAR SWITCH SENSOR COVER MISSING. ACP INTERIM SWITCH COVER IAW ECRA 2566-01098.SDR FDEA201312303067Battery · dischargedL1 DOOR SLIDE TEST LIGHT INOPERATIVE. R & R BATTERIES & OPERATIONS CHECKED IAW MD-10-10 AMM 25-61-01-2, OK FOR SERVICE.SDR MASA2013123020830Flashlight · inoperativeCAPTAIN`S FLASHLIGHT INOPERATIVE.SDR SWAA2014010923919Fitting · corrodedL1 DOOR FWD GIRT BAR TIE DOWN FITTING CORRODED AT BS 312, LBL 54. R & R FITTING IAW SRM.SDR SIMA20131229001Holder · defectiveCAPTAIN`S FLASHLIGHT IS LOOSE IN THE CRADLE & HARD TO KEEP CHARGING. DEFERRED IAW MEL 25-53 AUTH 121495 C CAT C M ACTION. REMOVED AND REPLACED CAPTS FLASHLIGHT HOLDER IAW AMM 25-50-16 OPS CHECK GOOD.SDR SWAA2014010223700Fitting · looseL1 DOOR EMERGENCY EVAC SLIDE GIRT BAR CLIP ASSEMBLY LOOSE. R & R CLIP ASSEMBLY IAW SIP.SDR SWAA2014010223759Flashlight · inoperativeFWD EMERGENCY FLASHLIGHT INOPERATIVE. R & R FLASHLIGHT IAW MM.SDR IPXA2014010201191Latch · brokenCAPTAIN'S OVERHEAD ESCAPE ROPE DOOR LATCH INOPERATIVE. OVERHEAD PANEL ASSY R & R IAW AMM TASK 25-1 4-02. ROPE INSTALLED IAW AMM TASK 25-61-02-682-001, REV 110, 02.
Back to JASC 2560