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 SWAA2015091844059Glowstrip · crackedRIGHT PHOTO LUMINESCENT STRIP CRACKED AT ROW 28. R & R STRIP IAW MM.SDR SIMA20150917004Flashlight · damagedAFT FLIGHT ATTENDANT FLASHLIGHT DAMAGED, DEFERRED ORIG AML PG 3924724-1 MEL 25-53. R & R AFT FLIGHT ATTENDANT EMER FLASHLIGHT IAW AMM 33-50-16, OPERATION CHECKED GOOD. MEL ITEM RESTORED.SDR SIMA20150917001Flashlight · inoperativeCAPTAINS FLASHLIGHT NOT CHARGING. R & R CAPTAINS FLASHLIGHT IAW AMM 33-50-16. 0PERATIONS CHECKED GOOD.SDR UHLA201509170721Glowstrip · dislodgedFLOOR GLOW IN DARK STRIP SEAT 18B HAS SLID. REPOSITIONED EGRESS FLOOR STRIP IAW AMM 33-52-21 TO CORRECT POSITION. NO OVERLAY VISIBLE.SDR SWAA2015102345273Glowstrip · deterioratedAFT CABIN STRIP PHOTO LUMINESCENT FLOOR PROXIMITY LIGHTING DETERIORATED. R & R STRIP IAW AMM.SDR AALA201509179001Flashlight · inoperativeFLIGHT ATTENDANT JUMP SEAT FLASHLIGHT INOPERATIVE. REPLACED FLASHLIGHT.SDR SWAA2015091744020Slide · looseL2 DOOR EMER EVAC SLIDE, GIRT BAR LOOSE. R & R SLIDE IAW MT.SDR SWAA2015091744019Girt Bar · looseR1 DOOR EMER EVAC SLIDE, GIRT BAR LOOSE. SECURED GIRT BAR IAW SIP.SDR MASA2015091612394Flashlight · inoperativeFWD F/A FLASHLIGHT NOT BLINKING. PLACED ON MEL.SDR SWAA2015110545769Spacer · corrodedR1 DOOR GIRT BAR SPACER CORRODED. R & R SPACER IAW SRM & DWG.SDR ASOA2015091513766Battery Pack · dischargedF/O & F/A FLASHLIGHTS INOPERATIVE. R & R FLASHLIGHT BATTERYS IAW AMM 25-61-01.SDR ASOA2015091513764Battery Pack · dischargedCOCKPIT FLASHLIGHT INOPERATIVE. REPLACED FLASHLIGHT BATTERIES, OPS CKS GOOD IAW AMM 25-61-00. NO FURTHER DEFECTS NOTED.SDR RAIA201509150001Flashlight · unsecureAFT EMERGENCY FLASHLIGHT WILL NOT CHARGE. MAINTENANCE RESTOWED AFT FLASHLIGHT, ENSURED PROPER CHARGE, OPS CHECK GOOD.SDR SWAA2015091643962Glowstrip · crackedLEFT PHOTO LUMINESCENT STRIPS CRACKED. R & R STRIP IAW MM.SDR SWAA2015091643957Glowstrip · crackedRIGHT PHOTO LUMINESCENT STRIPS CRACKED. R & R STRIP IAW MM.SDR MASA2015091512390Flashlight · inoperativeFWD F/A FLASHLIGHT INOPERATIVE.SDR P5CA2015091700146Door · unsecureF/O ESCAPE ROPE HATCH FALLS OPEN IAW AMM 25-61-02 PERFORMED LATCH OPS. REINSTALLED PANEL; CONDITION CHECKED NORMAL.SDR SWAA2015091643940Fitting · looseR1 DOOR EMER EVAC SLIDE GIRT BAR CLIP LOOSE. SECURED CLIP IAW SIP.SDR SWAA2015091543883Battery · dischargedFORWARD FLASHLIGHT INOPERATIVE. R & R BATTERY IAW AMM.SDR SIMA20150914001Holder · brokenCAPTAINS EMER FLASHLIGHT HOLDER BROKEN. R & R CAPTAINS EMER FLASHLIGHT HOLDER IAW AMM 33-50-16-000-801-A & 33-50-16-400-801-A.SDR MASA2015091412384Flashlight · inoperativeF/O FLASHLIGHT INOPERATIVE.SDR REXA2015091300894Flashlight · inoperativeTASK CARD EE-900 PILOTS EMER FLASHLIGHT INOPERATIVE, BATTERY INDICATOR SHOWS BATTERY IS GOOD. R & R PILOTS EMER FLASHLIGHT IAW AMM 25-61-02-A10.SDR SWAA2015091643946Retainer · inoperativeL1 DOOR EMER EVAC SLIDE GIRT BAR SPRING CLIP RETAINER INOPERATIVE. R & R RETAINER IAW SIP.SDR SWAA2015091543882Battery · dischargedAFT OTBD EMER FLASHLIGHT INOPERATIVE. R & R BATTERY IAW MM.SDR WX0A2015091472861Battery · dischargedONE FWD & ONE AFT FLIGHT ATTENDANT FLASHLIGHT NOT BLINKING. REPLACED BATTERIES FOR ONE FWD & ONE AFT FLIGHT ATTENDANT FLASHLIGHTS IAW AMM 25-60-00. OPERATIONS CHECKED NORMAL.SDR MASA2015091312382Flashlight · inoperativeAFT F/A FLASHLIGHT INOPERATIVE.SDR SWAA2015092544282Strap · brokenFORWARD GALLEY AREA, EMER FLASHLIGHT SAFETY STRAP BROKEN. R & R STRAP IAW CMM.SDR AALA201509139004Girt Bar · dirty1L DOOR WILL NOT ARM. REMOVED DEBRIS FROM GIRT BAR. OPERATIONS CHECKED GOOD.SDR ASOA2015091213738Megaphone · intermittentCABIN MEGAPHONE WORKS INTERMITTENTLY. R & R CABIN MEGAPHONE IAW AMM 25-61-14. OPS CHECKED GOOD.SDR SWAA2015112346331Fitting · corrodedL1 DOOR EMER EVAC SLIDE, FWD GIRT BAR FITTING CORRODED. R & R FITTING IAW AMM.SDR SWAA2015112346330Fitting · corrodedR1 DOOR EMER EVAC SLIDE, AFT GIRT BAR FITTING CORRODED. R & R FITTING IAW AMM.SDR SWAA2015091443820Glowstrip · damagedLEFT PHOTO LUMINESCENT FLOOR STRIP DAMAGED AT ROW 20. R & R STRIP IAW AMM.SDR SWAA2015091443819Glowstrip · damagedRIGHT PHOTO LUMINESCENT FLOOR STRIP DAMAGED AT ROW 22. R & R STRIP IAW AMM.SDR SWAA2015091443818Glowstrip · damagedRIGHT PHOTO LUMINESCENT FLOOR STRIP DAMAGED AT ROW 19. R & R STRIP IAW AMM.SDR SWAA2015091443817Glowstrip · damagedRIGHT PHOTO LUMINESCENT FLOOR STRIP DAMAGED AT ROW 14. R & R STRIP IAW AMM.SDR SWAA2015091443816Glowstrip · damagedRIGHT PHOTO LUMINESCENT FLOOR STRIP DAMAGED AT ROW 9. R & R STRIP IAW AMM.SDR SWAA2015091443814Glowstrip · damagedRIGHT PHOTO LUMINESCENT FLOOR STRIP DAMAGED AT ROW 4. R & R STRIP IAW AMM.SDR SWAA2015091443813Glowstrip · damagedRIGHT PHOTO LUMINESCENT FLOOR STRIP DAMAGED AT ROW 1. R & R STRIP IAW AMM.SDR SWAA2015091443763Bracket · out of adjustL2 DOOR GIRT BAR BRACKET OUT OF ADJUSTMENT. ADJUSTED BRACKET IAW SIP.SDR AALA201509129006Battery · dischargedFLASHLIGHT AT FLIGHT ATTENDANT JUMP SEAT INOPERATIVE. REPLACED FLASHLIGHT BATTERY AT FWD FLIGHT ATTENDANT JUMP SEAT.SDR AALA20150911009Battery · dischargedDURING SQUIB TEST 1 & 2 LT & RT EMER ESCAPE INDICATOR LIGHTS REMAINED EXTINGUISHED. ACCOMPLISHED FIM 25-65-00-815-820-002-2. R & R LT OFF WING ESCAPE SYS EMER BATTERIES IAW AMM 25-65-17. R & R SQUIB TEST PANEL IAW AMM 26-21-04. SQUIB TEST 1 & 2 LT & RT CHESDR AALA20150911008Test Panel · faultyDURING SQUIB TEST 1 & 2 LT & RT EMER ESCAPE INDICATOR LIGHTS REMAINED EXTINGUISHED. ACCOMPLISHED FIM 25-65-00-815-820-002-2. R & R LT OFF WING ESCAPE SYS EMER BATTERIES IAW AMM 25-65-17. R & R SQUIB TEST PANEL IAW AMM 26-21-04. SQUIB TEST 1 & 2 LT & RT CHESDR R61A201509100622Glowstrip · damagedMAINTENANCE REPORTED THAT THE PHOTOLUMINESCENT STRIP FORWARD OF SEAT 1D WAS DAMAGED. MAINTENANCE R & R PHOTOLUMINESCENT STRIP IAW AMM AND OPS CHECKED GOOD.SDR REXA2015091000856Glowstrip · detachedEMERGENCY GLOW STRIP ON FLOOR ROW 12 AC LT DETACHED. SECURED EMER GLOW STRIP ON FLOOR AT ROW 12 AS REQUIRED LT SIDE.SDR REXA2015091000853Battery · dischargedCAPTAINS EMER FLASHLIGHT INOPERATIVE. R & R CAPTAINS EMER FLASHLIGHT BATTERY IAW CMM 25-60-02. OPERATIONS CHECKED GOOD.SDR ASOA2015090913713Battery Pack · dischargedFWD F/A FLASHLIGHT INOPERATIVE. REPLACED BATTERIES, OPS CHECKED GOOD IAW AMM 25-60-00.SDR SIMA20150909002Cradle · brokenCAPTAINS FLASHLIGHT CRADLE BROKEN. R & R CAPTAINS FLASHLIGHT ASSEMBLY. OPERATIONS CHECKED GOOD IAW AMM 33-50-16.SDR SIMA20150909001Cradle · brokenAFT CABIN EMER FLASHLIGHT CRADLE BROKEN. R & R AFT CABIN EMER FLASHLIGHT CRADLE IAW AMM 33-50-16-000-801-A & 33-50-16-400-801-A. OPERATIONS CHECKED GOOD AT THIS TIME.SDR AALA201509099005Battery · dischargedFLIGHT ATTENDANT REPORTS, REAR GALLEY EMER FLASHLIGHT BATTERY LOW. REPLACED AFT LT GALLEY EMER FLASHLIGHT BATTERY.SDR AALA201509099002Girt Bar · dirtyDOOR 1R WILL NOT CLOSE & CANNOT ARM. REMOVED DEBRIS FROM FLOOR & GIRT BAR RETAINER. NO FURTHER DEFECTS NOTED AMM 52-11-00-862-077.
Back to JASC 2560