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 USAA2014020300014Megaphone · inoperativeMAINTENANCE REPORTED THE FWD MEGA PHONE INOPERATIVE. R 7 R FWD MEGA PHONE IAW AMM 25-60-00, OK FOR SERVICE.SDR MASA2014020130901Flashlight · inoperativeF/O FLASHLIGHT INOPERATIVE.SDR USAA2014020300013Battery · dischargedFLIGHT ATTENDANT FLASHLIGHT AT THE 2R DOOR WAS REPORTED INOPERATIVE. REPLACED BATTERY, EMERGENCY FLASHLIGHT LOCATION AT 2R DOOR OK FOR USE.SDR USAA2014020300023Attach Fitting · dirtyDOOR R1 SLIDE DID NOT DISARM UNTIL ARMING HANDLE CYCLED SEVERAL TIMES. REMOVED DEBRIS FROM GIRT BAR FITTINGS & LUBED GIRT BAR FITTINGS IAW A320 AMM 52-11-31, OPERATIONS CHECKED NORMAL IAW A320 AMM 52-10-00.SDR SIMA20140131006Holder · brokenCABIN REAR FLASHLIGHT HOLDER BROKEN. FLASHLIGHT FELL OUT UPON LANDING. R & R FLASHLIGHT & CRADLE IAW AMM 25-61-02.SDR USAA2014020300011Megaphone · inoperativePHL FOUND EMERGENCY MEGA PHONE INOPERATIVE, AFT CABIN. R & R MEGA PHONE, OPERATIONS CHECKED GOOD.SDR REXA2014013100155Battery · disconnectedFORWARD FLIGHT ATTENDANT`S INOPERATIVE. RECONNECTED FWD FLIGHT ATTENDANT`S FLASHLIGHT BATTERY. OPERATIONS CHECKED GOOD IAW CRJ900 AMM 25-61-02.SDR FDEA201401310225Cover · delaminatedL1 DOOR ESCAPE SLIDE COVER HAS ONE EACH LATCH BROKEN. RELEASED FOR SERVICE IAW MEL 52-11-01-A. L1 DOOR SLIDE INOPERABLE, IDENTIFY INOPERABLE OR MISSING. REPAIRED AREA UNDER LATCH & REPLACED FOUR INSERTS THAT ATTACH LATCH ASSEMBLY IAW AMM 25-00-00-8.SDR SWAA2014022425503Cable · frayedL1 DOOR EMERGENCY EVAC SLIDE GIRT BAR RELEASE CABLE FRAYED. R & R CABLE IAW AMM.SDR GTIA201401301143Pin · brokenMEGAPHONE TEST PIN BROKEN (FORWARD). R & R FORWARD MEGAPHONE IAW AMM.SDR USAA2014013100005Girt Bar · defectivePHX L4 DOOR GIRT BAR FWD FOOT NOT SLIDING. R & R L4 DOOR GIRT BAR.SDR JJBA20140130019Line · looseLEFT DITCHING DAM LOW. SECURED LINE FROM LT N2 BOTTLE TO GAUGE SERVICED TO 1500.SDR SIMA20140129001Holder · brokenDURING MX INSPECTION ON FLIGHT 3629 FOUND FWD FLIGHT ATTENDANT FLASHLIGHT HOLDER IS BROKEN. R & R FWD CABIN EMERGENCY FLASHLIGHT ASSEMBLY IAW AMM 25-61-02, OPERATIONS CHECKED GOOD.SDR REXA2014012900150Flashlight · inoperativeFLIGHT ATTENDANT`S FLASHLIGHT INOPERATIVE. R & R FWD FLIGHT ATTENDANT`S FLASHLIGHT IAW CRJ200 AMM 25-61-02. OPERATIONS CHECKED GOOD, ACFT FOR SERVICE.SDR USAA2014013100004Girt Bar · defectivePHX 4L DOOR ARMED LIGHT WOULD NOT ILLUMINATE WHEN ARMED. REINSTALLED GIRT BAR FOOT, OPERATIONS CHECKED GOOD.SDR R61A201401290156Flashlight · inoperativeCREW REPORTED THAT THE FORWARD F/A FLASHLIGHT WAS INOPERATIVE.SDR SIMA20140129003Cradle · brokenDURING PS 1 CHECK FOUND MAIN DOOR ENTRANCE EMERGENCY FLASHLIGHT HOLDER CRADLE BRACKET BROKEN. R & R MAIN DOOR ENTRANCE EMERGENCY FLASHLIGHT ASSEMBLY IAW MM 33-50-16, OPERATIONS CHECKED GOOD.SDR SIMA20140129007Cradle · brokenCAPTAIN`S EMERGENCY FLASHLIGHT CRADLE BROKEN. R & R CAPTAIN`S EMERGENCY FLASHLIGHT & CRADLE IAW AMM 25-61-02, OPERATIONS CHECKED GOOD.SDR SIMA20140129006Cradle · brokenFORWARD FLIGHT ATTENDANT EMERGENCY FLASHLIGHT CRADLE BROKEN. R & R FWD FLIGHT ATTENDANT`S EMERGENCY FLASHLIGHT & CRADDLE IAW AMM 25-81-02, OPERATIONS CHECKED GOOD.SDR QXEA2014012700082Latch · inoperativeF/A REPORTED EMERGENCY EQUIPMENT COMPARTMENT LATCH UNDER REAR F/A SEAT WONT STAY LATCHED. R & R LATCH ASSY. NO FURTHER DEFECTS NOTED. RETURNED TO SERVICE.SDR REXA2014012800144Pbe · unserviceablePBE IN AFT CABIN UNSERVICEABLE. R & R WITH SERVICEABLE PBE IN AFT CABIN IAW CRJ200 AMM 25-60-00.SDR REXA2014012800143Pbe · unserviceablePBE IN GALLEY CLOSET UNSERVICEABLE. R & R WITH SERVICEABLE PBE IN GALLEY CLOSET IAW CRJ200 AMM 25-60-01.SDR USAA2014012900011Flashlight · inoperativeTHE EMERGENCY FLASHLIGHT, AT FWD FLIGHT ATTENDANT STATION, THE LED IS NOT BLINKING. REPAIRED EMERGENCY FLASHLIGHT AS REQUIRED, OPERATIONS CHECKED GOOD.SDR USAA2014012900009Battery · dischargedTHE AFT FLIGHT ATTENDANT EMERGENCY FLASHLIGHT LED INOPERATIVE. REPLACED BATTERY IN AFT FLIGHT ATTENDANT EMERGENCY FLASHLIGHT, CHECKED OK.SDR USAA2014012900002Latch · lack of lubeDOOR 1L GIRT BAR LATCH STUCK. LUBED DOOR 1L GIRT BAR LATCH, OPERATIONS CHECKED SATISFACTORY IAW AMM 52-11-00-501-00-820-001A.SDR SIMA20140128003Holder · brokenFLASHLIGHT HOLDER AT AFT CABIN & FIRST OFFICER`S POSITION BROKEN. R & R FLASHLIGHT HOLDERS IAW AMM 33-50-16. NO FURTHER DEFECT NOTED, OPERATIONS CHECKED GOOD.SDR IPXA2014013181729Arming Lever · inoperativeL1 DOOR SLIDE WILL NOT DISARM. R & R SLIDE AND DOOR ARMING SYSTEM. OPERATES NORMALLY IAW MM 25-61-21-04.SDR SWAA2014020324809Battery · dischargedFWD LOWER FLASHLIGHT INOPERATIVE. R & R BATTERY IAW AMM.SDR SWAA2014012924662Holder · looseR1 DOOR EMERGENCY EVAC SLIDE GIRT BAR HOLDER LOOSE. SECURED HOLDER IAW SIP.SDR UHLA2014012700020Glowstrip · unsecureGLOWSTRIP LOOSE ON FLOOR NEAR FWD GALLEY. SECURED GLOWSTRIP IAW AMM 25-24-01. NO DEFECTS NOTED AT THIS TIME.SDR SIMA20140127005Holder · brokenAFT CABIN FLASHLIGHT HOLDER BROKEN. R & R AFT CABIN FLASHLIGHT HOLDER IAW EMB AMM 33-50-16.SDR SWAA2014012824620Battery · dischargedFWD EMERGENCY FLASHLIGHT INOPERATIVE. R & R BATTERY IAW AMM.SDR R61A201401270145Switch · brokenCREW REPORTED THAT THE F/O`S FLASHLIGHT SWITCH WAS BROKEN. MAINTENANCE R & R F/O`S FLASHLIGHT IAW AMM AND OPS CHECKED GOOD.SDR R61A201401270144Flashlight · inoperativeCREW REPORTED THAT THE CAPTAIN`S FLASHLIGHT WAS NOT CHARGING. MAINTENANCE R & R CAPTAINS FLASHLIGHT IAW AMM AND OPS CHECKED GOOD.SDR USAA2014012800002Battery · dischargedFOWARD FLIGHT ATTENDANT FLASHLIGHT DOES NOT INDICATE CHARGING. R & R FWD FLIGHT ATTENDANT FLASHLIGHT BATTERY.SDR USAA2014012700033Latch · dirtyFLIGHT ATTENDANT WAS UNABLE TO ARM 1R DOOR. MX CLEANED FOD FROM GIRT BAR LATCHING AREA. ACCOMPLISHED AMM TASK 52-73-00-001-A, OPERATIONS CHECKED GOOD.SDR USAA2014012700011Latch · dirtyDOOR L1 GIRT BAR LATCH STUCK. CLEANED & LUBED DOOR L1 LATCH.SDR SIMA20140126002Flashlight · brokenCAPTAIN`S FLASHLIGHT SWITCH BROKEN OFF. R & R CAPTAIN`S FLASHLIGHT, OPERATIONS CHECKED GOOD IAW 33-51-01 AMM.SDR SIMA20140126001Flashlight · inoperativeFORWARD FLIGHT ATTENDANT`S FLASHLIGHT INOPERATIVE. FLIGHT CREW PLACARDED IAW MEL 25-14.SDR SIMA20140126003Flashlight · inoperativeCAPTAIN`S FLASHLIGHT REQUIRES REPLACEMENT. R & R CAPTAIN`S FLASHLIGHT IAW AMM 25-61-02, OPERATIONS CHECKED GOOD.SDR MASA2014012620894Flashlight · inoperativeCAPTAIN'S FLASHLIGHT INOPERATIVE.SDR ASOA2014012809812Megaphone · inoperativeMEGAPHONE INOPERATIVE. R & R MEGAPHONE IAW AMM 25-61-14.SDR SWAA2014012724559Fitting · looseR1 DOOR EMERGENCY EVAC SLIDE GIRT BAR BRACKET CLIPS LOOSE. SECURED CLIPS IAW SIP.SDR SIMA20140125007Flashlight · inoperativeAFT CABIN FLASHLIGHT IS INOPERATIVE. VERIFIED THAT BULB NOR BATTERY WERE AT FAULT. R & R FLASHLIGHT AS REQUIRED, OPERATIONS CHECKED GOOD.SDR SIMA20140125001Flashlight · missingAFT FLIGHT ATTENDANT`S RECHARGEABLE FLASHLIGHT MISSING. R & R AFT FLIGHT ATTENDANT`S RECHARGEABLE FLASHLIGHT IAW AMM-25-61-02.SDR DALA2017041102984Scuff Plate · corrodedFWD DOOR AFT GIRT BAR FITTING LOWER ATTACH SCUFF PLATE MOUNT CORRODED. REPLACED.SDR R61A201401240142Flashlight · missingCREW REPORTED THAT THE COCKPIT FLASHLIGHTS WERE MISSING.SDR SWAA2014012724592Bracket · looseL1 DOOR EMERGENCY EVAC SLIDE GIRT BAR BRACKET LOOSE. SECURED BRACKET IAW SIP.SDR USAA2014012700034Latch · dirtyMAINTENANCE REPORTED THE L2 DOOR HARD TO ARM. GIRT BAR FLOOR ENGAGEMENT LATCHES DIRTY. CLEANED & LUBED GIRT BAR & LATCHES IAW AMM 52-13-22-400-001-A, SUBTASK 640-050-A. DOOR ARMS & DISARMS NORMAL, DOOR OK FOR CONTINUED SERVICE.SDR USAA2014012700004Girt Bar · obstructedECAM ON DOOR R1 WILL NOT SHOW ARM. CLEARED DEBRIS FROM GIRT BAR MECHANISM.
Back to JASC 2560