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 MASA2016060212730Flashlight · inoperativeAFT F/A FLASHLIGHT INOPERATIVE.SDR MASA2016060212729Flashlight · inoperativeFORWARD F/A FLASHLIGHT INOPERATIVE.SDR MASA2016060212728Flashlight · inoperativeFORWARD F/A FLASHLIGHT INOPERATIVE.SDR SWAA2016060652357Glowstrip · dirtyMAIN CABIN PHOTOLUMINESCENT EMERGENCY LIGHT DIRTY. CLEANED LIGHT IAW AMM.SDR ASAA2016060116919Girt Bar · out of positionF/A'S REPORT R1 EMERGENCY SLIDE PACK HANGS LOW AND MAKES IT HARD TO ARM AND DISARM. ACFT GROUNDED. REPOSITIONED R1 SLIDE AND GIRT INTO SLIDE COVER ASSY, REF AMM 25-66-01. GIRT BAR LATCHES AND UNLATCHES NORMAL.SDR AALA201606029003Battery · inoperativeAFT CABIN LT EMERGENCY FLASHLIGHT INOPERATIVE. REPLACED THE FLASHLIGHT BATTERY.SDR SWAA2016060652274Battery · dischargedAFT FLASHLIGHT CHARGING INDICATION INOPERATIVE. R & R BATTERY IAW MM.SDR FDEA201605311771Girt Bar · misalignedDOOR 1R WOULD NOT CLOSE & LATCH PROPERLY. REINSTALLED GIRT BAR IAW AMM 25-66-10-2. OPERATION CHECKED OK. ACFT OK TO CONTINUE.SDR MASA2016053112724Battery Pack · inoperativeFWD F/A FLASHLIGHT INOPERATIVE. REPLACED BATTERY.SDR AALA20160531004Flashlight · inoperativeFLASHLIGHT AT L2 DOOR AFT FLIGHT ATTENDANT SEAT IS INOPERATIVE. R & R FLASHLIGHT ASSEMBLY IAW AMM 25-64-01.SDR REXA2016052900958Battery Pack · inoperativeFIRST OFFICERS EMER FLASHLIGHT LED IS NOT BLINKING. R & R FIRST OFFICERS EMER FLASHLIGHT BATTERY IAW CMM 25-60-02.SDR UHLA201605290268Lever · inoperativeSLIDE ARMING LEVER ON DOOR R1 INOPERATIVE. R & R R1 DOOR EMERGENCY EVACUATION SLIDE MECHANISM IAW AMM 52-41-40. OPS CHECK GOOD.SDR SWAA2016060152181Fitting · looseL1 DOOR SLIDE GIRT BAR OUT OF ADJUSTMENT. ADJUSTED GIRT BAR CLIPS IAW MM.SDR REXA2016052900954Flashlight · inoperativePILOT SIDE FLASHLIGHT FLASHING LIGHT NOT FLASHING. R & R PILOT SIDE FLASHLIGHT IAW AMM 25-61-02. OPERATIONS CHECKED GOOD.SDR REXA2016052900953Flashlight · inoperativeFLIGHT ATTENDANT NOTED AFT FLASHLIGHT NOT BLINKING. MX & DISPATCH NOTIFIED. R & R FLASHLIGHT MOUNTING BRACKETS IAW CRJ900 AMM 25-61-00.SDR SIMA20160529003Flashlight · brokenAFT FLIGHT ATTENDANT FLASHLIGHT BROKEN IN PIECES, INOPERATIVE. R & R AFT FLASHLIGHT IAW SMP.SDR FDEA201605291751Indicator · inoperativeR1 PRESS TO TEST PRESS INDICATOR LAMP OUT. RELEASED FOR SERVICE IAW MEL 25-61-01, CATEGORY C, EXPIRATION 08JUN16. EVAC SLIDE REMOTE PRESS INDICATOR INOPERATIVE IAW MEL 25-61-01, VERIFY & RECORD IN THE AML. EVAC SLIDE SYS PRESS ONCE EACH FLIGHT DAY.SDR FDEA201605281749Escape Rope · out of positionEMERGENCY ESCAPE ROPE NOT STOWED. STOWED EMER ESCAPE ROPE IAW AMM 25-61-04-2-1, OK FOR SERVICE.SDR FDEA201605281748Battery · dischargedUPON CLOSING & ARMING R1 DOOR, NO LIGHT ON SLIDE PRESS TO TEST BUTTON, MEL 25-61-02. R1 EVAC SLIDE REMOTE PRESS INDICATOR INOPERATIVE IAW MEL 25-61-02, VERIFY & RECORD IN THE AML. EVAC SLIDE SYS PRESS ADEQUATE ONCE EACH FLIGHT DAY. CHECKED R1 SLIDE PRESS. SDR AALA201605299002Girt Bar · obstructedAIRCRAFT WAS NOT GNDED. 4R DOOR WOULD NOT ARM. REMOVED OBSTRUCTION FROM 4R DOOR GIRT BAR, DOORS ARMS PROPERLY.SDR MASA2016052812718Battery Pack · inoperativeFWD F/A FLASHLIGHT INOPERATIVE. REPLACED BATTERY.SDR N6WA2016052702Hook And Loop · missingLEFT EMERGENCY ROPE PANEL HOOK AND LOOP MISSING. REMOVED & STOWED COVER IN FWD CLOSET.SDR ASOA2016052714899Megaphone · unserviceableDMEGA PHONE INOPERATIVE. R & R MEGAPHONE IAW AMM 25-61-14, IPC 25-61-14, ITEM 5. ACFT OK FOR SERVICE.SDR P5CA2016053100121Escape Rope · unwanted deployNR 2 & NR 4 DESCEND DEVICES FOUND DEPLOYED UPON ARRIVAL. R & R DESCENT DEVICES IAW SMM 25-61-63.SDR SIMA20160527003Cradle · crackedFLIGHT ATTENDANT FLASHLIGHT CRADLE CRACKED. R & R FLIGHT ATTENDANT FLASHLIGHT CRADLE IAW AMM 33-50-16-000-801-A & 33-50-16-400-801-A. NO FURTHER DEFECTS NOTED AT THIS TIME.SDR SWAA2016062053030Plate · corrodedGIRT BAR FITTING SUPPORT PLATE CORRODED AT BS 344, LBL 61. R & R PLATE IAW SRM.SDR SWAA2016062053029Plate · corrodedGIRT BAR FITTING SUPPORT PLATE CORRODED AT BS 312, LBL 54. R & R PLATE IAW SRM.SDR SWAA2016060152177Bracket · looseR1 DOOR SLIDE AFT GIRT BAR BRACKET LOOSE. INSTALLED FASTENER AT GIRT BAR BRACKET IAW MM.SDR IPXA2016052603870Escape Rope · pulledENTRY DOOR ESCAPE ROPE PULLED OUT. REINSTALLED ROPE, IAW MM 25-61-04.SDR AALA201605279006Flashlight · missingAIRCRAFT WAS NOT GNDED. FLASHLIGHT AT R1 DOOR FLIGHT ATTENDANT SEAT IS MISSING. REPLACED FLASHLIGHT AT R1 DOOR FLIGHT ATTENDANT SEAT.SDR SWAA2016070553529Collar · crackedR2 DOOR EMERGENCY SLIDE AFT GIRT BAR COLLAR CRACKED. R & R THE COLLAR IAW AMM.SDR SWAA2016070553528Girt Bar · dirtyR2 DOOR EMERGENCY SLIDE GIRT BAR DIRTY. CLEANED THE GIRT BAR IAW AMM.SDR SWAA2016062053026Girt Bar · dirtyL2 DOOR EMERGENCY EVAC SLIDE GIRT BAR DIRTY. CLEANED GIRT BAR IAW AMM.SDR MASA2016052512707Flashlight · inoperativeFWD F/A FLASHLIGHT INOPERATIVE.SDR SIMA20160525001Flashlight · inoperativeAFT FLIGHT ATTENDANT FLASHLIGHT INOPERATIVE. DEFERRED FLASHLIGHT IAW MEL 25-53, M PROCEDURES COMPLIED WITH. INSTALLED FLASHLIGHT ASSY ON AFT CABIN OPS CHECK GOOD IAW EMB 145 MM 33-50-16. MEL RESTOREDSDR AALA201605269007Battery · dischargedAIRCRAFT WAS NOT GNDED. FLASHLIGHT AT FWD ENTRANCE NEEDS TO BE REPLACED. R & R FLASHLIGHT BATTERY IAW AMM 25-60-10.SDR AALA201605269005Mechanism · dirtyAIRCRAFT WAS NOT GNDED. LT AFT DOOR WILL NOT STAY ARMED. INSPECTED DOOR ARMING SYS IAW AMM 52-10-00 & FOUND DEBRIS IN GIRT BAR MECHANISM. CLEARED DEBRIS. OPERATIONAL CHECKED NORMAL.SDR AALA201605269004Battery · dischargedAIRCRAFT WAS NOT GNDED. FLASHLIGHT AT AFT GALLEY FLIGHT ATTENDANT SEAT IS NOT BLINKING. R & R FLASHLIGHT BATTERY. OPERATIONAL CHECKED GOOD.SDR SWAA2016061652952Bracket · corrodedL2 DOOR EMERGENCY EVAC SLIDE FLOOR MOUNT BRACKET CORRODED. R & R BRACKET IAW AMM.SDR SWAA2016061652951Bracket · corrodedR2 DOOR EMERGENCY EVAC SLIDE FLOOR MOUNT BRACKET CORRODED. R & R BRACKET IAW AMM.SDR SWAA2016052552060Battery Pack · dischargedAFT EMER FLASHLIGHT INOPERATIVE. R & R BATTERY PACK IAW AMM.SDR SWAA2016052552058Hook · looseL1 DOOR ESCAPE SLIDE GIRT BAR AFT HOOK LOOSE. R & R HOOK IAW SRM.SDR AALA201605259001Flashlight · inoperativeAIRCRAFT WAS NOT GNDED. 2R EMER FLASHLIGHT INOPERATIVE. REPLACED 2R EMER FLASHLIGHT IAW AMM 25-60-00. ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK.SDR UHLA201605230265Indicator · out of adjustL2 DISARMED INDICATION NOT SHOWING. ADJUSTED ARM/DISARM INDICATOR IAW AMM 52-12-00.SDR SWAA2016052552105Mount · crackedR2 DOOR FWD SLIDE MOUNT CRACKED. R & R MOUNT IAW SRM.SDR AALA201605249005Girt Bar · obstructedAIRCRAFT WAS NOT GNDED. 4R DOOR WILL NOT ARM. REMOVED DEBRIS FROM GIRT BAR.SDR SWAA2016052452042Battery · dischargedAFT RT FLASHLIGHT INOPERATIVE. R & R BATTERY IAW AMM.SDR MASA2016052312702Flashlight · inoperativeFWD F/A FLASHLIGHT INDICATOR LIGHT INOPERATIVE.SDR MASA2016052312701Flashlight · inoperativeCAPTAIN`S FLASHLIGHT INOPERATIVE.SDR MASA2016052312700Flashlight · inoperativeFWD F/A FLASHLIGHT INDICATOR LIGHT INOPERATIVE.
Back to JASC 2560