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 UALA2011072503755Pbe · expiredPBE AT LOWER LOBE CREW REST PAST RUNOUT DATE. REPLACED PBE AT LOWER LOBE CREW REST.SDR ZZDA2011600Glowstrip · brokenEMERGENCY EXIT STRIP ALONG FLOOR ROW 1 IS BROKEN. REMOVED AND REPLACED FLOOR PROXIMITY LIGHT (PHOTOLUMINESCENT) STRIP IAW B737 AMM 33-51-15 AT ROW 1.SDR USAA2011072500012Girt Bar · out of adjustDOOR 2L GIRT BAR WILL NOT STOW SECURE. ADJUSTED AND STOWED GIRT BAR, OK FOR SERVICE.SDR USAA2011072500011Battery · dischargedEMERGENCY FLASHLIGHT RT AFT GALLEY INOP. REMOVED AND REPLACED FLASHLIGHT BATTERY, OPS CHECKS OK.SDR MASA2011072503295Battery · inoperativeFWD F/A'S FLASHLIGHT INOP. R & R FLASH LIGHT BATTERYSDR UALA2011072203731Pbe · damagedPBE DOOR 4L IS SOFT. REPLACED PBE DOOR.SDR UALA2011072203730Pbe · damagedPBE DOOR 4R IS SOFT. REPLACED PBE DOOR.SDR MASA2011072503297Flashlight · inoperativeF/O'S FLASHLIGHT INOP. R2 F/O'S FLASHLIGHT ASSY.SDR MASA2011072503296Battery · dischargedF/O'S FLASH LIGHT INOP. R2 F/O'S FLASHLIGHT BATTERY.SDR MASA2011072503294Battery · dischargedF/O FLASH LIGHT FOUND REMOVED FROM HOLDED AND INOP. CREW PUT FLASH LIGHT BACK IN HOLDER BUT WAS NOT FULLY CHARGED, R2 BATTERY.SDR MASA2011072203284Strap · unsecureSAFETY STRAP ON AED UNSECURED. FOUND IT TO BE THE MALE END OF THE BACK-PACK STYLE RESTRAINING CLIP THAT HOLDS THE AED TO THE OVHD BIN AND AM UNABLE TO FIND P/N FOR IT IN IPC OR ON OTHER CLIP SAFETY STRAP ON AED UNSECURED INSTALLED STRAP.SDR MASA2011072203282Battery · dischargedAFT FA FLASHLIGHT NOT FLASHING. R2 FLASHLIGHT BATTERIES.SDR USAA2011072200002Knob · missingMEGAPHONE VOLUME KNOB MISSING. REPLACED MEGAPHONE VOLUME KNOB.SDR UALA2011072203716Smoke Goggles · unknownF/O NEEDS A NEW PAIR OF SMOKE GOGGLES. REPLACED SMOKE GOOGLES.SDR N6WA20110725Cover · missingRT ROPE BOX COVER AT EMERGENCY EXIT ROW IS MISSING. RESECURED ROPE BOX COVER IAW AMM 25-60-00.SDR SIMA201120104Cradle · brokenON FLIGHT 4236 THE CREW REPORTED THE CAPTAIN’S FLASHLIGHT CRADLE HAD BROKEN. THE AIRCRAFT WAS REMOVED FROM SERVICE. REMOVED AND REPLACED THE CAPTAIN'S FLASHLIGHT HOLDER IAW EMB-145 AMM 33-50-16. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR MASA2011071903266Battery · inoperativeCAPT FLASHLIGHT INOP. REMOVED AND REPLACED BATTERY.SDR N6WA20110724D-Ring · missingLT OVERWING EMERGENCY EXIT; RING IS MISSING FROM ESCAPE ROPE. INSTALLED HOOK SNAP ON LT SIDE EMERGENCY EXIT ESCAPE ROPE IAW AMM 25-63-04. OK FOR SERVICE.SDR MASA2011071903265Battery · dischargedCAPTAIN`S FLASHLIGHT INOP. R2 BATTERY.SDR MASA2011071903264Battery · dischargedFWD & AFT FLASHLIGHTS NOT BLINKING. R2 THE BATTERY.SDR R61A20110184Girt Bar · out of adjustCREW REPORTED L-2 DOOR ARMING MECHANISM WAS STUCK. DEN ADJUSTED GIRT BAR PER EMB AMM, OPS CHECK GOOD.SDR UALA2011071703625Seal · brokenAUTOMATED EXTERNAL DEFIBRILLATOR (AED) HAS BROKEN OR MISSING GREEN SEAL. REPLACED KIT.SDR N6WA20110720Reflector · looseSERVICE DOOR REFLECTIVE STRIP LOOSE. REATTACHED GALLEY SERVICE DOOR REFLECTIVE STRIP IAW CRJ700 AMM 25-56-07SDR USAA2011071800005Flashlight · inoperativeCDG - FLASHLIGHT AT DOOR 3R IS INOP. SEAL BROKEN. MAINTENANCE RELEASED ON MEL. ON JULY 16, 2011 THE FLASHLIGHT AT DOOR 3R WAS REMOVED AND REPLACED, MEL REMOVED.SDR MASA2011071503242Battery · dischargedAFT ATTEND FLASHLIGHT INOP. R2 BATTERY, OPS GOOD.SDR MASA2011071503238Smoke Goggles · crackedF/O SMOKE GOGGLES CRACKED. R2 GOGGLES.SDR USAA2011071500010Megaphone · unserviceableCABIN MEGAPHONE MISSING VOLUME KNOB. REPLACED MEGAPHONE IN AFT CABIN.SDR N6WA20110718D-Ring · missingOVERWING RT EMERGENCY EXIT ROPE MISSING D-RING. ACFT IS SAFE FOR A ONE TIME FERRY FLIGHT, AUTHORIZED BY MX CONTROL AND MX CONTROL MANAGER. MX REPLACED D-RING IAW AMM 25-63-04.SDR MASA2011071503228Battery · dischargedF/O'S FLASHLIGHT INOP. REMOVED AND REPLACED F/O'S FLASHLIGHT BATTERY, OPS CHECK GOOD.SDR USAA2011071400001Battery · discharged2S CHECK - INOP FLASHLIGHT AFT FLIGHT ATTENDANT SEAT RT SIDE. REPLACED BATTERY IN FLASHLIGHT AT AFT FLIGHT ATTENDANT SEAT RT SIDE IAW A319 CMM 25-60-02.SDR N6WA20110717Glowstrip · loosePHOTOLUMINESCENT STRIP LOOSE AT 1A/B. RESECURED PHOTOLUMINESCENT STRIP AT ROW 1A/B IAW AMM 33-51-01.SDR MASA2011071403226Battery · dischargedF/O'S FLASHLIGHT INOP. R2 F/O'S FLASHLIGHT BATTERY.SDR SWAA2012080806607Hook · out of adjustL2 DOOR EMERGENCY EVAC SLIDE GIRT BAR HOOKS OUT OF ADJUST. ADJUSTED HOOKS PER MM.SDR UALA2011071203485Pbe · unserviceablePBE POUCH FEELS SPONGY AND SOFT PER 'A' CHECK PAPERWORK IN DOOR 3R LWR LOBE CREW REST. REPLACED PBE.SDR UALA2011071203484Pbe · unserviceablePBE POUCH FEELS SPONGY AND SOFT PER 'A' CHECK PAPERWORK BY DOOR 4R. REPLACED PBE.SDR UALA2011071203483Pbe · unserviceablePBE POUCH FEELS SPONGY AND SOFT PER 'A' CHECK PAPERWORK BY DOOR 4L. REPLACED PBE.SDR UALA2011071203482Pbe · unserviceablePBE POUCH FEELS SPONGY AND SOFT PER 'A' CHECK PAPERWORK BY DOOR 3R. REPLACED PBE.SDR UALA2011071203481Pbe · unserviceablePBE POUCH FEELS SPONGY AND SOFT PER 'A' CHECK PAPERWORK BY DOOR 3L. REPLACED PBE.SDR UALA2011071203479Pbe · unserviceablePBE POUCH FEELS SPONGY AND SOFT PER 'A' CHECK PAPERWORK BY DOOR 1R. REPLACED PBE AT DOOR 1R.SDR UALA2011071203478Pbe · unserviceablePBE POUCH FEELS SPONGY AND SOFT PER 'A' CHECK PAPERWORK BY DOOR 1L. REPLACED PBE AT DOOR 1L.SDR UALA2011071203477Pbe · unserviceablePBE POUCH FEELS SPONGY AND SOFT PER 'A' CHECK PAPERWORK IN FLIGHT DECK STOWAGE COMPT. REPLACED PBE IN FLIGHT DECK.SDR MASA2011071303214Battery · dischargedF/O FLASHLIGHT INDICATOR INOP. PLACED ON MEL. R2 FLASHLIGHT BATTERYSDR MASA2011071503225Flashlight · inoperativeF/O FLASHLIGHT INDICATOR INOP. R2 FLASHLIGHT BATTERY CLEARED.SDR MASA2011071503222Battery · dischargedAFT F/A FLASHLIGHT INOP. R2 BATTERY.SDR SWAA115039Fitting · corrodedDURING SCHEDULED 12Y CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE GIRT BAR FWD FITTING CORRODED. REMOVED AND REPLACED FITTING IAW SRM AND DWG.SDR SWAA115010Hook · out of adjustL2 DOOR EMERGENCY EVAC SLIDE GIRT BAR HOOK OUT OF ADJUST. ADJUSTED HOOK PER MM.SDR MASA2011071303213Battery · dischargedAFT F/A FLASHLIGHT INOP. R2 BATTERY.SDR SWAA114966Plate · corrodedDURING SCHEDULED 12Y CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE GIRT BAR ATTACHMENT SUPPORT CORRODED AT BS 312, LBL 55. REMOVED AND REPLACED PLATE PER SRM.SDR SWAA2012080806584Hook · looseR1 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR HOOK LOOSE. SECURED HOOK PER MM.SDR ASOA201101311Megaphone · inoperativeMEGAPHONE INOP. R & R MEGAPHONE IAW AMM 25-61-14. OPS CHECK GOOD. NO FURTHER DEFECTS NOTED AT THIS TIME. (CLOSED)
Back to JASC 2560