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 SIMA20140714001Flashlight · inoperativeFIRST OFFICERS FLASHLIGHT INOPERATIVE. R & R FIRST OFFICERS FLASHLIGHT & CRADLE IAW AMM .33-50-16.SDR MASA2014071402235Battery · dischargedAED BATTERY DEAD. REPLACED BATTERY.SDR MASA2014071402234Flashlight · inoperativeFWD F/A FLASHLIGHT INOPERATIVE.SDR SWAA2014091732065Latch · bentR1 DOOR EMER EVAC SLIDE RELEASE LATCH BENT. R & R LATCH IAW MT.SDR SWIA201438712Battery Pack · inoperativeF/A FLASHLIGHT INOPERATIVE. INSTALLED NEW BATTERIES.SDR N6WA20140713002Hook And Loop · missingEXIT ROW 18 RT EMER ROPE COVER MISSING HOOK AND LOOP. INSTALLED NEW HOOK AND LOOP ON RT EXIT ESCAPE ROPE COVER IAW AMM 51-22-61.SDR REXA2014071300696Smoke Goggles · defectiveCAPTAIN & FIRST OFFICERS SMOKE GOGGLES NO ELASTICITY. REPLACED BOTH SMOKE GOGGLES IAW AMM 35-10-00.SDR SWIA201438704Battery Pack · failedCABIN EMERGENCY FLASHLIGHT NOT WORKING. R & R F/A FLASHLIGHT BATTERY. OPS CHECKED GOOD.SDR SWIA201438905Battery Pack · inoperativeCOCKPIT FLASHLIGHT INOPERATIVE. R & R THE BATTERIES, OPS CHECKED GOOD.SDR 2WAA20140715002Flashlight · inoperativeDOORWAY L-1 FLASHLIGHT NOT WORKING. REMOVED AND REPLACED FLASHLIGHT IAW MM 33-53-00. OPS CHECKED NORMAL.SDR SWIA201438711Flashlight · inoperativeTHE FWD F/A FLASHLIGHT IS INOPERATIVE. REPLACED THE FWD F/A FLASHLIGHT. OPS CHECKED GOOD.SDR REXA2014071200695Pbe · damagedTWO PBE'S DAMAGED. R & R COCKPIT PBE & GALLEY CLOSET PBE IAW AMM 35-30-00.SDR SWAA2014071429967Battery · dischargedAFT GALLEY EMER FLASHLIGHT INOPERATIVE. R & R BATTERY IAW SIP.SDR SWAA2014071429966Girt Bar · looseR2 DOOR EMER EVAC SLIDE GIRT BAR LOOSE. SECURED GIRT BAR IAW AMM.SDR SWAA2014071429913Battery · faultyFORWARD FLASHLIGHT FAULTY. R & R BATTERY IAW MM.SDR DALA2014071404101Cable · misroutedL1 DOOR DID NOT ARM PROPERLY. FOUND GIRT BAR CABLE MISROUTED. REPOSITIONED CABLE. OK FOR CONTINUED SERVICE.SDR SWIA201438763Battery Pack · failedREAR F/A FLASHLIGHT NOT BLINKING. R & R AFT F/A FLASHLIGHT BATTERY. OPS CHECKED GOOD.SDR SWIA201438709Battery Pack · dischargedF/A FLASHLIGHT DISCHARGED. R & R BATTERY IAW AMM.SDR R61A201407110871Flashlight · inoperativeCREW REPORTED THAT THE CAPTAIN`S FLASHLIGHT WAS INOPERATIVE.SDR SIMA20140711004Holder · inoperativeNUMBER 1 FLIGHT ATTENDANT FLASHLIGHT HOLDER INOPERATIVE. R & R FLIGHT ATTENDANT NR 1 FLASHLIGHT ASSEMBLY IAW AMM 25-61-02. OPERATIONS CHECKED GOOD AT THIS TIME.SDR 2014FA0000425Bracket · brokenDURING THE COURSE OF A FATAL INCIDENT INVESTIGATION ON JULY 5, 2014, IT WAS DISCOVERED THAT THE PILOT’S SEAT, BRACKET-SAFETY-SEAT-BELT-CENTER, PN 0425132, WAS BROKEN AND THE SEAT BELT HAD SLIPPED OFF THE BRACKET. THE ACFT ROLLED OFF THE RUNWAY AFTER LANDING ASDR SWIA201438758Battery Pack · inoperativeAFT F/A EMERGENCY FLASHLIGHT INOPERATIVE. R & R BATTERY PACK ON AFT FLASHLIGHT IAW AMM.SDR SWIA201438757Battery Pack · failedAFT FLASHLIGHT BATTERY FAILED. INSTALLED SERVICEABLE BATTERY. GROUND OPS CHECKED GOOD.SDR IPXA2014071183591Cover Plate · brokenCAPTAIN`S EMERGENCY ESCAPE ROPE ACCESS COVER BROKEN. INSTALLED DOOR ASSY IPC 25-14-01-02-850.SDR SIMA20140710001Holder · brokenFIRST OFFICERS EMER FLASHLIGHT HOLDER IS BROKEN. R & R FIRST OFFICERS EMER FLASHLIGHT ASSEMBLY IAW AMM 25-61-02.SDR USAA2014071100001Latch · missingTHE R4 DOOR SLIDE COVER MISSING LATCH. REPLACED R4 DOOR SLIDE COVER IAW AMM 25-62-50.SDR FDEA201407101686Escape Rope · unsecureRIGHT DOOR ENTRY WILL NOT ARM. LT RT FOUND SLIDE ROPE & STRAP HANGING DOWN. RE STOWED ROPE & STRAP. OPERATIONS CHECKED NORMAL.SDR ASOA2014071110850Flashlight · inoperativeF/A'S FLASHLIGHT DOES NOT WORK. R & R FLASHLIGHT IAW AMM 25-60-00.SDR ASOA2014071110849Flashlight · inoperativeF/A FLASHLIGHT INOPERATIVE. R & R FLASHLIGHT IAW AMM 25-61-04. OPS CHECKED GOOD. ACFT OK FOR SERVICE.SDR GTIA2014070901377Megaphone · inoperativeMEGAPHONE AT L1 DOOR DAMAGED. R & R MEGAPHONE IAW EMERGENCY EQUIPMENT DWG NK 319-12-EQ.SDR USAA2014071000003Battery · dischargedFLASHLIGHT UNDER FWD FLIGHT ATTENDANT JUMP SEAT INOPERATIVE. REPLACED FLASHLIGHT BATTERY AT FWD FLIGHT ATTENDANT JUMP SEAT.SDR R61A201407090860Battery Pack · weakCREW REPORTED THAT THE FORWARD F/A FLASHLIGHT WAS DIM. MAINTENANCE R & R THE FLASHLIGHT BATTERY IAW AMM. OPS CHECKED GOOD.SDR USAA2014071000008Megaphone · brokenFORWARD MEGA PHONE BROKEN. REPLACED FWD MEGA PHONE.SDR MASA2014070902219Flashlight · inoperativeF/O FLASHLIGHT INOPERATIVE.SDR SWAA2014090231461Retaining Clip · looseR1 DOOR EMER EVAC SLIDE AFT GIRT BAR RETAINER CLIP LOOSE. SECURED CLIP IAW SRM.SDR SWAA2014090231460Retaining Clip · looseL1 DOOR EMER EVAC SLIDE FWD GIRT BAR RETAINER CLIP LOOSE. SECURED CLIP IAW SRM.SDR 2014F00133Release Mech · brokenWHILE ADJUSTING THE PASSENGER SEAT BELTS BETWEEN FLIGHTS, THE SEAT BELT RELEASE MECHANISM BROKE OFF WHILE RELEASING THE HARNESS FROM THE BUCKLE.SDR SWIA201438756Battery Pack · failedF/A REPORTS FWD FLASHLIGHT NOT BLINKING. R & R FWD FLASHLIGHT BATTERY IAW AMM.SDR REXA2014070800688Defibrillator · unserviceableAED KIT MISSING SECURITY TAPE & FIRST RESPONDER TAB RIPPED. R & R AED IAW AMM 25-60-10.SDR ASOA2014071110848Battery Pack · dischargedFLASHLIGHT AT F/A STATION NOT WORKING. R & R FLASHLIGHT BATTERIES IAW AMM 25-61-00. OPS CHECKED GOOD.SDR SWAA2014071029831Hinge · brokenR2 DOOR EMER EVAC SLIDE FWD PARTITION COMPARTMENT SLIDE OUT DOOR HINGE BROKEN. R & R HINGE IAW SIP.SDR SIMA20140708001Flashlight · odorCAPTAINS FLASHLIGHT EMITTING STRONG BURNT ELEC SMELL. REMOVED CAPTAINS FLASHLIGHT FROM ACFT & DEFERRED IAW MEL 25-53. R & R CAPTAINS FLASHLIGHT ASSEMBLY IAW AMM 33-50-16. OPERATIONS CHECKED GOOD. MEL 25-53 RESTORED.SDR SWIA201438653Battery Pack · inoperativeF/A REPORTED FWD FLASHLIGHT INOPERATIVE. R & R FWD FLASHLIGHT BATTERY IAW CMM.SDR GTIA2014070701374Flashlight · inoperativeFWD F/A FLASHLIGHT INOPERATIVE. R & R FWD OTBD EMERGENCY FLASHLIGHT IAW CMM 25-60-13.SDR R61A201407070854Girt Bar · damagedCREW WAS UNABLE TO CLOSE L1 DOOR. MAINTENANCE INSPECTED AND FOUND THE L1 DOOR GIRT BAR HANGING DOWN. MAINTENANCE R & R THE L1 DOOR SLIDE IAW AMM AND OPS CHECKED GOOD.SDR SWAA2014070929812Hook · brokenR1 DOOR EMER EVAC SLIDE GIRT BAR HOOK BROKEN. R & R HOOK ASSEMBLY IAW SRM.SDR SWAA2014070929809Battery · dischargedAFT FLASHLIGHT INOPERATIVE. R & R BATTERY IAW MM.SDR R61A201407070855Battery Pack · inoperativeCREW REPORTED THAT THE COCKPIT FLASHLIGHT BATTERY IS INOPERATIVE. MAINTENANCE R & R FLIGHT DECK FLASHLIGHT BATTERIES IAW AMM AND OPS CHECKED GOOD.SDR USAA2014070800006Girt Bar · dirty2R DOOR ARMING MECHANISM MAKES GRINDING NOISE WHILE TRYING TO CLOSE OR OPEN. FLIGHT ATTENDANT SAYS IT DOESN'T FEEL NORMAL. FOUND DEBRIS ON GIRT BAR AT FLOOR ATTACH BRACKETS. CLEANED DEBRIS & LUBED IAW AMM 12-22-52-640-014-A.SDR USAA2014070800002Megaphone · inoperativeTHE AFT MEGA PHONE INOPERATIVE. REPLACED THE AFT MEGA PHONE. OPERATIONS CHECKED OK.
Back to JASC 2560