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 USAA2014051200004Battery · dischargedCREW REPORTED BOTH FWD FLIGHT ATTENDANT`S FLASHLIGHTS INOPERATIVE. REPLACED FWD FLASHLIGHT BATTERIES.SDR GTIA2014050901297Light · inoperativeMEGAPHONE GREEN "ON LIGHT" INOPERATIVE. R & R AFT MEGAPHONE IAW AMM. OPS CHECKED GOOD.SDR SIMA20140508003Holder · brokenAFT FLIGHT ATTENDANT FLASHLIGHT HOLDER BROKEN. REPLACED AFT FLIGHT ATTENDANT FLASHLIGHT & CRADLE ASSEMBLY IAW MM 33-50-00, OPERATIONS CHECKED GOOD.SDR SIMA20140508007Flashlight · inoperativeFIRST OFFICER`S FLASHLIGHT INOPERATIVE. R & R FIRST OFFICER`S FLASHLIGHT ASSEMBLY IAW AMM 33-50-16.SDR SIMA20140508008Flashlight · inoperativeCAPTAIN`S FLASHLIGHT INOPERATIVE. R & R CAPTAIN`S FLASHLIGHT ASSEMBLY IAW AMM 33-50-16.SDR SIMA20140508006Flashlight · inoperativeFWD FLIGHT ATTENDANT FLASHLIGHT INOPERATIVE. R & R FWD FLIGHT ATTENDANT FLASHLIGHT ASSEMBLY.SDR SIMA20140508004Flashlight · brokenFLASHLIGHT IN COCKPIT BROKEN. R & R FLASHLIGHT IN COCKPIT IAW AMM 33-50-16, OPERATIONS CHECKED GOOD.SDR REXA2014050800432Battery · dischargedFOUND EMERGENCY FLASHLIGHT BEHIND FIRST OFFICER`S SEAT NOT FLASHING. R & R BATTERY IN EMERGENCY LIGHT BEHIND FIRST OFFICER`S SEAT IAW AMM 25-61-00, OPERATIONS CHECKED GOOD.SDR R61A201405080633Flashlight · missingCREW REPORTED THAT BOTH COCKPIT FLASHLIGHTS WERE MISSING.SDR USAA2014050900003Battery · dischargedBOTH MEGA PHONES REQUIRE BATTERY REPLACEMENT. REPLACED BATTERIES IAW JOB CARD.SDR USAA2014050800007Strap · unsecureL1 DOOR SLIDE STRAP HANGING DOWN. SECURED L1 DOORS SLIDE STRAP.SDR C77A20140508001Battery · dischargedDOOR L1 FLIGHT ATTENDANT FLASHLIGHT LED LIGHT DOES NOT FLASH. R & R L1 FLIGHT ATTENDANT FLASHLIGHT BATTERY IAW AMM 33-51-01. OPERATIONS CHECKED GOOD, OK FOR SERVICE.SDR MASA2014050731089Flashlight Assy · inoperativeAFT F/A FLASHLIGHT LED NOT BLINKING.SDR SIMA20140506007Cradle · brokenFORWARD CABIN EMERGENCY FLASHLIGHT CRADLE BROKEN. R & R FWD CABIN EMERGENCY FLASHLIGHT ASSEMBLY IAW AMM 33-50-16-000-801-A & 33-50-16-400-801-A, OPERATIONS CHECKED GOOD.SDR USAA2014050700008Knob · missingMEGAPHONE KNOB MISSING. REPLACED MEGAPHONE ASSEMBLY.SDR USAA2014050700005Megaphone · crackedTHE AFT MEGAPHONE CRACKED. REPLACED THE AFT MEGAPHONE, OK FOR SERVICE.SDR R61A201405060628Battery · inoperativeCREW REPORTED THAT THE F/O FLASHLIGHT WOULD NOT HOLD A CHARGE. MAINTENANCE R & R THE FLASHLIGHT BATTERY IAW AMM AND OPS CHECKED GOOD.SDR WX0A071944Battery · dischargedFWD EMERGENCY FLASHLIGHT INOPERATIVE. R & R FWD FLASH BATTERY, OPERATIONS CHECKED GOOD IAW MM 25-60-00. THIS CLEARS MEL 25-09 SIT 1 DMI 8644 PLACARD REMOVED.SDR SWAA2014050727758Lens · crackedR1 DOOR EMER EVAC SLIDE LENS CRACKED. R & R LENS PER MT & AMM.SDR SWAA2014050727756Lens · looseR2 DOOR EMER EVAC SLIDE COVER LENS LOOSE. SECURED LENS IAW AMM & MT.SDR SWAA2014050627722Flashlight · inoperativeFORWARD FLASHLIGHT INOPERATIVE. R & R FLASHLIGHT IAW MM.SDR SIMA20140505001Flashlight · inoperativeAFT FLASHLIGHT CABIN INOPERATIVE. DEFERRED AFT FLIGHT ATTENDANT FLASHLIGHT IAW MEL 25-53. M PROCEDURE COMPLIED WITH. FWD FLIGHT ATTENDANT, CAPTAINS & FIRST OFFICER`S FLASHLIGHT OK. MEL 25-53 REQUIRES 3 FLASHLIGHTS FOR DISPATCH, INSTALLED ADDITIONAL SPARE 4SDR SIMA20140505002Flashlight · inoperativeFORWARD CABIN EMERGENCY FLASHLIGHT INOPERATIVE. R & R FWD CABIN EMERGENCY FLASHLIGHT ASSEMBLY, OPERATIONS CHECKED GOOD IAW AMM 33-50-16.SDR FDEA201405050949Indicator · failedDOOR 1L SLIDE TEST INDICATES INOPERATIVE. REPLACED SLIDE REMOTE PRESS IND ASSEMBLY & OPERATIONS TESTED SATISFACTORY IAW MM 25-61-04-4.SDR CALA2014050690976Pin · shearedLEFT OVERWING SLIDE DOOR FWD ALIGNMENT PIN IS SHEARED OFF. REMOVED SHEARED PIN, PIN IS AOG.SDR IXXA20140506007Battery · dischargedEMERGENCY FLASHLIGHT AT ATTENDANT SEAT R4 LED INDICATING LIGHT INOPERABLE. IAW AMM 25-64-00 FLASHLIGHT BATTERY WAS R & R. OPERATIONAL CHECK SATISFACTORY.SDR SWAA2014050527681Battery · dischargedFORWARD INBD FLASHLIGHT INOPERATIVE. R & R BATTERY IAW AMM.SDR FDEA201405040944Indicator · inoperativeL1 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. REPLACED SLIDE REMOTE PRESS IND ASSEMBLY & OPERATIONS TESTED SATISFACTORY IAW MM 25-61-04-4.SDR USAA2014050500014Strap · brokenFORWARD FLIGHT ATTENDANT INBD FLASHLIGHT STRAP BROKEN. INSTALLED NEW SECURITY STRAP ON FWD FLIGHT ATTENDANT INBD FLASHLIGHT ASSEMBLY.SDR SIMA20140504002Cradle · damagedFIRST OFFICER`S FLASHLIGHT CRADLE DAMAGED. R & R FIRST OFFICER`S FLASHLIGHT CRADLE IAW AMM TASK 33-50-16-000-801-A & 33-50-16-400-801-A.SDR SIMA20140504001Flashlight · inoperativeFORWARD FLIGHT ATTENDANT`S FLASHLIGHT NOT CHARGING. R & R FWD FLIGHT ATTENDANT`S FLASHLIGHT ASSEMBLY IAW MM 25-61-02, OPERATIONS CHECKED OK.SDR SIMA20140503009Pin · disconnectedPILOTS FLASHLIGHT HAS NO CHARGE. RECONNECTED PIN IAW WM 91-10-02 & SWPM 20-00-03, LED CHARGE LIGHT NOW ILLUMINATED, OPERATIONS CHECKED GOOD.SDR 2WAA201405003Battery Pack · loosePORTABLE FLASHLIGHT AT L1 DOOR DOES NOT COME ON WHEN SELECTED. INSPECTED FLASHLIGHT, FOUND LOOSE BATTERY, SECURED THE BATTERY IAW MM 33-53-00. OPS CHECKED NORMAL.SDR SWAA2014050827806Girt Bar · out of adjustL1 DOOR EMERGENCY EVAC SLIDE GIRT BAR OUT OF ADJUSTMENT. ADJUSTED GIRT BAR IAW AMM.SDR SWAA2014050727775Holder · looseL2 DOOR EMER EVAC SLIDE GIRT BAR HOLDER LOOSE. SECURED HOLDER IAW MM.SDR ASOA2014050710469Battery Pack · inoperativeF/A FLASHLIGHT INOPERATIVE. R & R FLASHLIGHT BATTERIES IAW AMM 25-60-00, NO FURTHER DEFECT NOTED.SDR DALA14028189015Fitting · out of adjustCREW FOUND THAT THE R1 DOOR GIRT BAR WOULD NOT STAY IN THE FITTINGS. MAINTENANCE ADJUSTED THE THRESHOLD THAT WAS IN THE WAY OF THE GIRT BAR.SDR DALA14028097007Hook · bindingL2 DOOR WILL NOT DISARM. L 2 DOOR ARM-DISARM LEVER FOUND BINDING. SLIDE RAFT REMOVED AND L2 DOOR DECLARED INOPERATIVE. FOUND DOOR ASSIST BOTTLE LOW R & R DOOR ASSIST BOTTLE IAW AMM 52-11. REPLACED HOOK ASSY IAW AMM 52-11, OPS CHECKED GOOD. INSTALLED SLIDE SDR SWAA2014050527711Fitting · dirtyL1 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR FITTING DIRTY. CLEANED FITTING IAW AMM.SDR USAA2014050500011Strap · brokenAFT FLIGHT ATTENDANT POSITION FLASHLIGHT STRAP BROKEN. REPLACED AFT FLIGHT ATTENDANT POSITION FLASHLIGHT STRAP.SDR GTIA2014050301288Flashlight · inoperativeL2 DOOR F/A EMERGENCY FLASHLIGHT WILL NOT TEST. R & R FLASHLIGHT IAW CMM 25-60-13. OPS TESTED OK.SDR SIMA20140503002Retaining Clip · brokenCAPTAIN`S FLASHLIGHT HOLDER HAS A BROKEN RETAINING CLIP. R & R WITH SERVICEABLE CAPTAIN`S FLASHLIGHT ASSEMBLY IAW AMM 33 50 16, OPERATIONS CHECKED OK.SDR SWAA2014050527680Holder · looseL1 DOOR EMER EVAC SLIDE GIRT BAR HOLDER LOOSE. R & R HOLDER IAW SIP.SDR CALA2014050290949Mechanism · lack of lubeLEFT OVERWING DISABLE HANDLE IS BINDING WHETHER ARMING OR DISARMING HANDLE. LUBED MECHANISM & HARDWARE, HANDLE MOVES FREELY, OK TO CONTINUE.SDR SIMA20140502002Flashlight · inoperativeFLASHLIGHT FIRST OFFICER`S SIDE INOPERATIVE. OPERATIONS CHECK FLIGHT OFFICER`S FLASHLIGHT GOOD IAW AMM 33-50-16.SDR SIMA20140502001Flashlight · brokenNUMBER 2 FLIGHT ATTENDANT FLASHLIGHT BROKEN. R & R NR 2 FLIGHT ATTENDANT FLASHLIGHT IAW 25-60-00, OPERATIONS CHECKED GOOD.SDR REXA2014050100415Flashlight · inoperativeFLIGHT ATTENDANT`S EMERGENCY FLASHLIGHT INOPERATIVE. R & R FLIGHT ATTENDANT`S EMERGENCY FLASHLIGHT IAW AMM 25-61-04.SDR REXA2014050100405Flashlight · inoperativeWHILE PERFORMING TASK CARD EE-900 NOTED FIRST OFFICER'S EMERGENCY FLASHLIGHT LED INDICATOR WAS NOT FLASHING. R & R FLASHLIGHT ASSEMBLY IAW AMM 25-51-02. OPERATIONS CHECKED GOOD AT THIS TIME, PN OFF & ON P2-07-0001-214.SDR REXA2014043000411Pbe · unserviceablePBE SEAL MISSING, FLIGHT DECK. R & R COCKPIT PBE IAW AMM 35-30-00 DUE TO BROKEN PBE CASE, OK FOR SERVICE.SDR USAA2014050100007Battery · dischargedTHE LT EMERGENCY FLASHLIGHT AT FWD ENTRANCE DOOR HAS LOW BATTERY. R & R FLASHLIGHT BATTERY AT FWD ENTRANCE IAW MPPM 54-01-10. OK FOR CONTINUED SERVICE.
Back to JASC 2560