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 SIMA20131221008Flashlight · missingFLIGHT ATTENDANT REPORTS AFT CABIN FLASHLIGHT MISSING. GAVE A NEW FLASHLIGHT TO THE FLIGHT ATTENDANT TO PUT IN THE AFT CABIN IAW STANDARD MAINT PRACTICE. (RESUBMITTED)SDR USAA2013122300016Flashlight · inoperativeTHE AFT JUMP SEAT FLASHLIGHT NEEDS REPLACING. R 7 R AFT JUMP SEAT FLASHLIGHT.SDR SIMA20131221002Flashlight · inoperativeON FLIGHT 3629 CREW REPORTED CAPTAIN`S FLASHLIGHT INOPERABLE. R & R CAPTAIN'S FLASHLIGHT IAW CRJ700 AMM 25-61-02 BRACKETS & FLASHLIGHT MOUNTING. OPERATIONS CHECKED GOOD AT THIS TIME.SDR SIMA20131221007Flashlight · defectiveON FLIGHT 3719 FLIGHT ATTENDANT REPORTS FLASHLIGHT CHARGING STATION AT NR 1 POSITION WILL NOT HOLD FLASHLIGHT SECURE. R & R THE FWD FLIGHT ATTENDANT`S FLASHLIGHT & CHARGER ASSEMBLY IAW CRJ 700 AMM 25-61-02 OPERATION TESTED GOOD.SDR CALA2013122693918Guard · brokenEVAC COMMAND BUTTON GUARD AT DOOR 4R IS BROKEN. REPLACED SWITCH GUARD.SDR REXA2013122002416Smoke Goggles · missingDURING PREFLIGHT INSPECTION, F/O SIDE MISSING SMOKE GOGGLES. REPLACED SMOKE GOGGLES IAW AMM 25-60-00.SDR R61A201312201347Flashlight · inoperativeAFT F/A FLASHLIGHT WAS FOUND TO BE INOPERATIVE. SECURED FLASHLIGHT ENDCAP IAW AMM 25-00-00. OPS CHECKED GOOD.SDR DALA13070863232Girt Bar · corrodedDURING INSPECTION, FOUND CORROSION ON PLATE ASSY BETWEEN FRAMES 16 TO 20 AT S23R OF GIRT BAR FITTING FWD PAX DOOR CUTOUT. REPLACED PLATE ASSY IAW SRM 51-72-11.SDR REXA2013122002229Flashlight Assy · inoperativeFLASHLIGHT AT EXTRA JUMPSEAT NOT FLASHING. R & R NR 3 FLASHLIGHT AND HOLDER, IAW AMM 25-61-02. OPS CHECKED GOOD.SDR AALA20131220001Cover · out of alignmentAFT GALLEY SLIDE PACK COVER OUT OF ALIGNMENT & RUBS AIRFRAME OPENING UPON DOOR USE. REPLACED AFT GALLEY SLIDE AFT COVER.SDR ASOA2013122009673Flashlight · intermittentCAPTAIN`S FLASHLIGHT GOES IN AND OUT. R & R FLASHLIGHT IAW AMM 25-61-02.SDR CALA2013122093854Light · inoperativeDOOR 2L SLIDE ARM LT INOPERATIVE, AFTER PUSH BACK. RELAMPED & OPERATIONS NOW NORMAL.SDR SWAA2013122023572Battery · dischargedFWD FLIGHT ATTENDANT`S AFT FLASHLIGHT INOPERATIVE. R & R FLASHLIGHT BATTERY IAW MM.SDR USAA2013122000006Megaphone · inoperativeFORWARD MEGAPHONE INOPERATIVE, HAS BAD TRIGGER HANDLE. INSTALLED SERVICEABLE MEGAPHONE.SDR MASA2013121928019Flashlight · inoperativeCAPTAIN`S FLASHLIGHT INOPERATIVE.SDR SWAA2013122023562Fitting · looseL1 DOOR ESCAPE SLIDE COVER AFT GIRT BAR STOW CLIP LOOSE. INSTALLED CLIP BAR RIVET TO SECURE IAW SRM.SDR MYWA20131218001Flashlight · inoperativeAFT INBOARD EMERGENCY FLASHLIGHT DOES NOT TURN ON.SDR R61A201312181331Spacer · missingDURING HEAVY CHECK, FOUND GIRT BAR SPACERS AND WASHERS ON THE L1 DOOR WERE MISSING. MISSING SPACERS AND WASHERS WERE INSTALLED IAW AMM 25-65-01.SDR SWAA2013121923528Retainer · brokenL1 DOOR EMERGENCY EVAC SLIDE GIRT BAR RETAINER BROKEN. R & R RETAINER IAW MM.SDR IPXA2013122301098Light · unknownTHE RED WARNING LIGHT ON THE SLIDE ARMING PANEL IS INOPERATIVE. PERFORMED BITE TEST AND RESET IAW MM 52-73-00-0501. SYS OPS CHECKED NORMAL.SDR REXA2013121602409Safety Wire · brokenMEDICAL KIT SAFETY WIRES BROKEN. R & R FIRST AID KIT IAW AMM 25-60-00.SDR REXA2013121602408Flashlight · inoperativeCAPTAIN`S FLASHLIGHT INOPERATIVE. REPLACED CAPTAIN`S FLASHLIGHT IAW AMM 25-61-02, OPERATIONS CHECKED GOOD.SDR WX0A071790Battery · dischargedAFT FLIGHT ATTENDANT`S FLASHLIGHT READY LIGHT NOT BLINKING. REPLACED BATTERY IN AFT FLIGHT ATTENDANT`S EMERGENCY FLASHLIGHT & OPERATIONS CHECKED GOOD IAW AMM 25-60-00.SDR MASA2013121628014Battery · inoperativeF/O FLASHLIGHT INOPERATIVE. REPLACED BATTERY.SDR SWAA2013121723419Lanyard · wornR1 DOOR EMERGENCY EVAC SLIDE CLIP WORN. R & R LANYARD IAW AMM.SDR R61A201312161322Flashlight · inoperativeDURING PREFLIGHT CHECK THE AFT F/A FLASHLIGHT WAS FOUND TO BE INOPERATIVE. THE FLASHLIGHT WAS R & R IAW AMM 33-51-01.SDR REXA2013121602403Battery · dischargedFIRST OFFICER`S FLASHLIGHT NOT FLASHING. REPLACED FIRST OFFICER`S FLASHLIGHT BATTERY IAW AMM 25-61-01. OPERATIONS CHECKED OK, OK FOR SERVICE.SDR REXA201321502405Smoke Goggles · missingSMOKE GOGGLES IN OBSERVER`S SEAT MISSING. INSTALLED SMOKE IAW AMM 25-61-00SDR SWAA2013121823511Fitting · looseR2 DOOR EMERGENCY EVAC SLIDE COVER RETAINING SCREW LOOSE. SECURED CLIP IAW SIP.SDR MASA2013121528012Battery · inoperativeAFT F/A FLASHLIGHT INOPERATIVE. REPLACED BATTERY.SDR SWAA0166120123397Girt Bar · looseR1 DOOR EMERGENCY EVAC SLIDE GIRT BAR LOCK LOOSE FROM COVER. SECURED GIRT BAR ASSEMBLY IAW AMM.SDR SIMA20131215001Holder · brokenFLIGHT ATTENDANT`S REAR FLASHLIGHT HOLDER BROKEN. R & R FLIGHT ATTENDANT`S AFT FLASHLIGHT HOLDER & FLASHLIGHT IAW EMB-140 AMM 33-50-16, OPERATIONS CHECKED GOOD.SDR SIMA20131215003Flashlight · inoperativeFLIGHT ATTENDANT`S FLASHLIGHT INOPERATIVE CRADLE BROKEN. R & R FLIGHT ATTENDANT`S FLASHLIGHT SYS IAW EMB AMM 33-50-16-000-801-A & 33-50-16-400-801-A, OPERATIONS CHECKED GOOD.SDR UHLA2013121400659Indicator · out of positionR1 GIRT BAR INDICATOR MISSING. REPOSITIONED R1 GIRT BAR INDICATOR IAW AMM 52-11-41, INDICATOR NOT MISSING.SDR FDEA201312142984Latch · brokenLEFT SIDE ESCAPE ROPE COVER PANEL BOTTOM LATCH BROKEN. REPLACED LATCH IAW SMP, OPERATIONS CHECKED GOOD.SDR IPXA2013121801078Bolt · looseDURING INSPECTION, EMERGENCY ESCAPE DEVICES HAS BOLTS LOOSE ON ANCHORS. SECURED ANCHORS ON DEVICES, REF MM 25-61-02-2. DEVICES SECURED AND STRAPPED.SDR ASOA2013121309649Battery Pack · dischargedFLASHLIGHT DOES NOT WORK. REPLACED BATTERIES IAW AMM 25-60-00, OPS CHECKED GOOD, ACFT OK FOR SERVICE.SDR REXA2013121202223Flashlight · inoperativeFLIGHT ATTENDANT`S REPORTS FLASHLIGHT ON GALLEY SERVICE DOOR, RED LIGHT NOT FLASHING. DEFERRED FLASHLIGHT IAW MEL 25-61-4 MX NOTIFIED 53431 ENTERED INTO MM02 & PLACARD PLACED. R & R FLIGHT ATTENDANT’S EMERGENCY FLASHLIGHT ASSEMBLY BY SERVICE DOOR IAW AMM 25-6SDR REXA2013121202401Smoke Goggles · crackedSMOKE GOGGLES CRACKED. R & R SMOKE GOGGLES IAW AMM 35-11-12.SDR USAA2013121300002Girt Bar · dirtyTHE LT FRONT DOOR SLIDE BECAME DISARMED IN FLIGHT. ARMING HANDLE IS ABOUT 1/4 INCH OUT OF POSITION. SLIDE WILL ARM WHEN HANDLE IS HELD IN ARMED POSITION. CLEANED DEBRIS FROM GIRT BAR AREA & LUBED MECHANISM. L1 DOOR OPERATIONS CHECKED GOOD IAW AMM 52-11-12.SDR FDEA201312122968Light · inoperativeAFTER ARRIVAL AT GATE NOTICED L1 DOOR ESCAPE SLIDE ARMED LIGHT INOPERATIVE. RELAMPED L1 SLIDE ARM LIGHT IAW AMM 33-16-02-2, OPERATIONS CHECKED NORMAL.SDR MASA2013121268002Flashlight · inoperativeF/O FLASHLIGHT INOPERATIVE.SDR REXA2013121102226Power Unit · faultyFLASHLIGHT NEXT TO EXTRA FLIGHT ATTENDANT JUMP SEAT IS INOPERATIVE. DEFERRED IAW MX 95765 IAW MEL 25-61-4A. ENTERED INTO MM02 & INSTALLED PLACARD. R & R EXTRA FLIGHT ATTENDANT`S FLASHLIGHT POWER UNIT IAW CMM 25-60-11. OPERATIONS CHECKED GOOD. THIS CLEARS SDR ASOA2013121309647Megaphone · inoperativeF/A MEGAPHONE IS INOPERATIVE. R & R MEGAPHONE, IAW AMM 25-61-14, OPS CHECKED GOOD.SDR ASOA2013121309646Glowstrip · missingTHREE FEET OF THE GLOW STRIP TAPE MISSING FROM SERVICE DOOR. REPLACED MISSING TAPE AS REQUIRED, ACFT OK FOR SERVICE.SDR GTIA201312111066Flashlight · inoperativeF/A FLASHLIGHT INOPERATIVE AT L2 POSITION. R & R FLASHLIGHT IAW AMM. OPS CHECKED GOOD.SDR MASA2013121268004Flashlight · inoperativeGALLEY ENTRANCE FLASHLIGHT INOPERATIVE. R & R FLASHLIGHT.SDR DALA13068685643Spring · failedL4 DOOR GIRT BAR LOCK SPRING CHECK FAILED. R & R L4 DOOR GIRT BAR ASSY IAW AMM 25-66-10-402-022, OPS CHECKED GOOD.SDR USAA2013121200006Retainer · obstructedFORWARD ENTRY DOOR GIRT BAR RETAINER STUCK IN THE DOWN POSITION. REMOVED FOREIGN DEBRIS UNDER GIRT BAR RETAINER, OPERATIONS CHECKED GOOD.SDR SIMA20131211002Holder · brokenON FLIGHT 3226 THE CREW REPORTED CAPTAIN`S FLASHLIGHT HOLDER BROKEN. THE ACFT WAS REMOVED FROM SERVICE. R 7 R CAPTAIN`S FLASHLIGHT ASSEMBLY IAW EMB 140 AMM 33-50-16 & OPERATIONAL CHECK WAS GOOD. THE ACFT WAS RETURNED TO SERVICE.
Back to JASC 2560