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 = '2565' 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 = '2565' 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 MWEA96003Evac Slide · low pressureDURING SERVICE CHECK, FOUND TAIL COMPARTMENT EVAC SLIDE PRESSURE LOW. REMOVED AND REPLACED EVAC SLIDE.SDR DL72L960059Slide · low pressureDURING INSPECTION, R-1 DOOR SLIDE PRESSURE FOUND LOW 500 LBS. REPLACED SLIDE.SDR 96UAL900012Seam · leakingSLIDE REMOVED FROM AIRCRAFT DUE TO INADVERTENT DEPLOYMENT. SLIDE HAS A SEAM LEAK AT THE LT CORNER OF THE SLIDE. REPAIRED SEAM LEAK, NON-STRUCTURAL.SDR ASAA9680012Slide · failed testOAK - DURING C-CHECK, THE R1 DOOR EMERGENCY EVACUATION SLIDE EMERGENCY LIGHTS FAILED TEST. REPLACED THE R1 DOOR EMERGENCY EVACUATION SLIDE. (M)SDR 96ZZZX2136Slide · malfunctionedDURING SCHEDULED DEPLOYMENT, SLIDE DEPLOYED UNDER THE AIRCRAFT.SDR ASAA9510118Slide · low pressureDURING A-CHECK, THE L-1 EMERGENCY EVACUATION SLIDE PACK PRESSURE WAS FOUND LOW. REPLACED SLIDE ASSEMBLY. VENDOR TEAR DOWN REVEALED LOW BOTTLE PRESSURE. OVERHAULED, HYDROSTATIC TESTED, AND REFILLED BOTTLE. REFERENCE: OPERATOR CONTROL NR 96ZZZX633. (X)SDR 9521709936Slide · low batteryDURING PERIODIC CHECK, MAIN CABIN DOOR EVACUATION SLIDE FAILED BATTERY CHECK. REPLACED SLIDE. OPERATIONAL CHECK GOOD.SDR AALA952109Slideraft · damagedLAX - DURING SHOP TEST DEPLOYMENT, EMERGENCY EVACUATION SLIDERAFT FABRIC BLISTERING. SCRAPPED EMERGENCY EVACUATION SLIDERAFT. (M)SDR AALA952108Slide · failedLAX - DURING SHOP TEST DEPLOYMENT, EMERGENCY EVACUATION SLIDE HAD POROSITY LEAKS. EMERGENCY EVACUATION SLIDE SCRAPPED. (M)SDR QXEA9500447Slide Assy · low pressureSEA - THE EMERGENCY ESCAPE SLIDE BOTTLE PRESSURE IS LOW. REMOVED AND REPLACED SLIDE ASSEMBLY AND AIRCRAFT WAS RETURNED TO SERVICE.SDR UPS805142Slide · low pressureMAINT REPORTED, ESCAPE SLIDE PRESSURE BELOW LIMITS AND DUE 12/95. REMOVED AND REPLACED SLIDE PER M/M 25-60-01, CHECKS OK.SDR DL73S954655Slide · low pressureL1 DOOR SLIDE PRESSURE LOW PILOT REPORT. REPLACED DOOR SLIDE.SDR SCNA95276Slide · failedWHEN OPENING THE R-3 DOOR THE SLIDE WAS DEPLOYED INADVERTENTLY AND THE UPPER PORTION OF THE SLIDE FAILED TO INFLATE. REMOVED AND REPLACED THE R-3 DOOR SLIDE.SDR 9520513230Slide · malfunctionedAFTER THE AIRCRAFT ARRIVED AT THE GATE, THE FLIGHT ATTENDANT INADVERTENTLY DEPLOYED THE SLIDE AT DOOR 4R. THE SLIDE DID NOT FULLY INFLATE. MAINTENANCE REMOVED SLIDE AND SENT TO THE SHOP WHERE THE SLIDE WAS REPACKED. THIS SLIDE WILL BE INSTALLED ON AN AIRCRASDR MWEA95431Evac Slide · low pressureDURING INSPECTION, FOUND GALLEY SERVICE DOOR EVACUATION SLIDE PRESSURE LOW. MAINTENANCE REMOVED AND REPLACED GALLEY SERVICE DOOR EVACUATION SLIDE, RETURNED A/C TO SERVICE.SDR 96ZZZM358Escape Slide · inopRIGHT AFT ESCAPE SLIDE LIGHTING INOP. REPLACED SLIDE.SDR QXEA9500383Slide · low pressureGEG - DURING PRE-FLIGHT, FOUND THE BOTTLE PRESSURE FOR EMERGENCY ESCAPE SLIDE WAS LOW. SLIDE ASSY WAS REPLACED AND AIRCRAFT RETURNED TO SERVICE.SDR BJNA951102Evac Slide · bottle leakingR-2 SLIDE LEAKING PRESSURE FROM BOTTLE. REMOVED AND REPLACED THE R-2 SLIDE PER BMM 25-61-311. (M)SDR 95ZZZX6833Slide · misrepairedLIGHTING SYSTEM BATTERY LANYARD WAS TIED OFF USING COPPER WIRE AS OPPOSED TO COTTON THREAD. FIRING CABLE WAS INCORRECTLY ROUTED THROUGH HOLE IN PACKBOARD.SDR 95ZZZX6832Slide · misrepairedFRANGIBLE LINKS USED TO REGULATE DEPLOYMENT HAD APPARENTLY BEEN FUNCTIONED ONCE (NOT RE-USEABLE); HOWEVER, WHAT REMAINED ON THE LINK WAS RECONSTRUCTED USING UNAPPROVED WIRE, AND AT TIMES, TAPED OVER WITH GRAY DUCT TAPE. LIGHTING SYSTEM BATTERY LANYARD WAS TIESDR 95ZZZX6831Slide · misrepairedFRANGIBLE LINKS USED TO REGULATE DEPLOYMENT HAD APPARENTLY BEEN FUNCTIONED ONCE (NOT RE-USEABLE); HOWEVER, WHAT REMAINED ON THE LINK WAS RECONSTRUCTED USING UNAPPROVED WIRE, AND AT TIMES, TAPED OVER WITH GRAY DUCT TAPE. LIGHTING SYSTEM BATTERY LANYARD WASTIEDSDR UPS805008Latch · brokenWHILE ON GROUND, MAINTENANCE FOUND LATCH FOR ESCAPE SLIDE BROKEN. REMOVED AND REPLACED ESCAPE SLIDE CONTAINER AND SECURED.SDR 96ZZZM364Slide · failed checkTHE NR 3 EMERGENCY SLIDE FAILED THE POWER PACK EFFICIENCY CHECK. REPLACED THE SLIDE.SDR UPS804920Slide · damagedWHILE ON THE GROUND, MAINTENANCE FOUND THE EMERGENCY ESCAPE SLIDE PRESSURE INDICATION WITH OPEN COVER. REPOSITIONED INDICATOR, SLIDE INFLATED, NEEDS REPLACED. MAINTENANCE REPLACED THE EMERGENCY ESCAPE SLIDE PER MM 25-60-01.SDR 96ZZZM365Slide · damagedDEPLOYED THE LEFT FORWARD ESCAPE SLIDE S/N 0548, PER MM 25-60-11 PAGE 501 APRA 1A, 1C, AND ZW CHECK LIST 25-60-36-06. THEN REMOVED THE SLIDE FOR A DETAILED VISUAL INSPECTION, FORWARDED THE CHECK LIST WITH THE SLIDE TO THE SHOP. UPDATE TASK P/N 625601102, S/NSDR MWEA95360Slide · failed testDURING ROUTINE TIME CHANGE OF FWD GALLEY SERVICE DOOR EVACUATION SLIDE, THE DEPLOYMENT TEST FAILED. MAINTENANCE FOUND RELEASE LANYARD ROUTED INCORRECTLY INSIDE SLIDE AT BOTTLE REGULATOR. MAINTENANCE REPLACED GALLEY SERVICE DOOR EVACUATION SLIDE AND RETURNED SDR A6WR95045Battery · failedDURING C-CHECK, FORWARD PASSENGER DOOR EVACUATION SLIDE BATTERY FAILED EFFICIENCY CHECK DUE TO LOW VOLTAGE. REPLACED BATTERY. (X)SDR A6WR95044Light Assy · defectiveDURING C-CHECK, FOUND AFT SERVICE DOOR EVAC SLIDE LAMP CIRCUIT AMPERAGE LOW DURING LAMP HARNESS TEST. REPLACE LIGHT ASSY. CIRCUIT TESTED WITHIN REQUIRED AMPERAGE PARAMETERS. (X)SDR A6WR95015Slide · light defectiveUPON SCHEUDLED SLIDE DEPLOYMENT TEST EMERGENCY LIGHTS ON SLIDE FAILED TO ILLUMINATE. BATTERY VOLTAGE CHECKED OK. FOUND ONE LIGHT ASSEMBLY DAMAGED AND WIRES SHORTED. (X)SDR CA951129511Slide Cable · routing wrong(CAN)DURING INSPECTION OF L2 DOOR ESCAPE SLIDE, MAINTENANCE FOUND ACKBOARD RELEASE MECHANISM INSTALLED INCORRECTLY BY MANUFACTURER. AS A RESULT SLIDE WOULD NOT DEPLOY PROPERLY. UNIT REMOVED TO SAFETY SHOP FOR OVERHAUL.SDR AALA951770Slide · defectiveLAX - DURING SHOP TEST DEPLOYMENT, EMERGENCY EVACUATION SLIDE HAD SEAM DEFECTS AND POROSITY LEAKS. EMERGENCY EVACUATION SLIDE SCRAPPED. (M)SDR 95UAL900187Slide · wornDURING TIME CONTROLLED OVERHAUL OF A NR 2 DOOR SLIDE, WEAR WAS FOUND IN THE GIRT FABRIC PASSING THROUGH THE INFLATION TUBE. THIS TYPE OF WEAR HAS BEEN NOTED BEFORE AND IS CAUSED BY THE GIRT ATTACH LANYARD. RETURNED UNIT TO VENDOR FOR REPAIR. (X)SDR MWEA95342Evac Slide · low preasureDURING SERVICE CHECK, THE TAIL EVACUATION SLIDE PRESSURE WAS FOUND LOW, 2400 PSI. MAINTENANCE REMOVED AND REPLACED TAIL EVACUATION SLIDE IAW DC9 MM, RETURNED A/C TO SERVICE.SDR MWEA95317Evac Slide · low pressureMAIN DOOR SLIDE FOUND LOW ON PRESSURE. REMOVED AND REPLACED CABIN DOOR SLIDE WITH A SERVICEABLE UNIT.SDR CAL950867Slide · deployedFLT NR 711 - IAH - THE EICAS MESSAGE RIGHT OVERWING SLIDE DISPLAYED STEADY AND THE EMERGENCY DOORS OVERHEAD LIGHT ILLUMINATED STEADY AFTER TAKEOFF FROM EWR. CABIN PRESSURE WAS GOOD AND A VISUAL INSPECTION OF BOTH EXITS APPEARED NORMAL. THE FLIGHT WAS CONTINUSDR SCNA95197Batteries · dischargedTHE L-1 DOOR SLIDE TESTED WEAK. THE SLIDE INTEGRITY TEST BATTERIES WERE FOUND WEAK. REPLACED BATTERIES AND SLIDE TESTED GOOD.SDR SCNA95194Slide · faultyTHE L-3 DOOR SLIDE WOULD NOT TEST. REPLACED THE L-3 DOOR SLIDE IAW MM 25-61-01 AND THE SLIDE TESTED GOOD.SDR 95ZZZM576Cylinder · low pressureDURING PREFLIGHT, THE EVACUATION SLIDE CYLINDER PRESSURE WAS FOUND TO BE BELOW LIMITS. THE EVACUATION SLIDE/CYLINDER ASSEMBLY WAS REPLACED.SDR MWEA95306Evac Slide · deployedDURING INSPECTION, TAIL EVACUATION SLIDE INADVERTENTLY DEPLOYED WHILE INSTALLING. MAINTENANCE INSTALLED NEW TAIL EVACUATION SLIDE AND RETURNED A/C TO SERVICE.SDR 95UAL900128Slide · tornDOOR 3 RT INTERNAL BULKHEAD DAMAGE - TOP HINGE TAPE HAS 2 INCH TEAR AND TOP BULKHEAD HAS 2 INCH SEPARATION. SLIDE SENT TO VENDOR FOR REPAIR.SDR 95UAL900127Slide · tornDOOR 3 LEFT SLIDE, INTERNAL OUTBOARD BULKHEAD DAMAGE - TOP HINGE TAPE HAS 2.75 INCH TEAR. THE BOTTOM HINGE TAPE HAS A 2.25 INCH TEAR. THE TOP BULKHEAD HAS 2.75 INCH SEPARATION. THE BOTTOM BULKHEAD HAS 2.25 INCH SEPARATION. SLIDE ASSY SENT TO VENDOR FOR REPSDR 95UAL900126Slide · leakingDOOR 5 LT SLIDE FAILED POROSITY TEST DURING PROOF PRESSURE TEST AT OVERHAUL. SLIDE SCRAPPED.SDR 9514025507Evac Slide · wornDURING OVERHAUL IN SHOP, THE EVACUATION SLIDE FROM DOOR 1L WAS FOUND WITH A HOLE WORN IN THE SILL TUBE. REPAIRED PER 25-66-01 PG 606-1 AND OVERHAULED SLIDE. WEAR CAUSED BY CHAFING AGAINST IPC REF 52-11-53-02 ITEM 129A.SDR 95ZZZX5162Gauge · out of toleranceDURING MAINTENANCE CHECK, FOUND R-1 DOOR SLIDE PRESSURE GAUGE READING HIGH BEYOND LIMIT. REMOVED AND REPLACED R1 DOOR SLIDE/RAFT ASSY PER MM. RESULTS SATISFACTORY.SDR USVA8954Evac Slide · low pressureL-1 DOOR SLIDE READS ZERO PRESSURE. REMOVED AND REPLACED DOOR SLIDE IAW BMM 25-61-311. (X)SDR ASAA9580189Slide Bottle · low pressureSEA - DURING MAINTENANCE CHECK, THE L1 DOOR EMERGENCY EVACUATION SLIDE INFLATION BOTTLE PRESSURE WAS FOUND LOW. REPLACED THE L1 DOOR EMERGENCY EVACUATION SLIDE. (M)SDR ASAA9580188Evac Slide · failed testOAK - DURING C-CHECK, THE R1 DOOR EMERGENCY EVACUATION SLIDE EMERGENCY LIGHTS FAILED TEST. REPLACED THE R1 DOOR EMERGENCY EVACUATION SLIDE. (M)SDR AALA951481Slide · defectiveLAX - DURING SLIDE SHOP RECEIVING INSPECTION, FOUND HOLE ABOVE LEFT RELIEF VALVE EMERGENCY EVACUATION SLIDE. REPAIRED SLIDE, SLIDE CHECKS GOOD. (X)SDR 95FDEA01077Escape Slide · torn girtFORWARD ENTRY DOOR ESCAPE SLIDE GIRT IS TORN 1.5 PER TC 72C247-00 THIS REQUIRES REPLACEMENT. REPLACED FORWARD ENTRY DOOR ESCAPE SLIDE ASSY IAW FEDEX MM 25-60-13.SDR ORJA9554Escape Slide · malfunctionedTAILCONE WAS ACCIDENTALLY DEPLOYED. SLIDE DEPLOYED NORMALLY, HOWEVER, IT DID NOT INFLATE. SLIDE WAS REPLACED, TAILCONE REPAIRED AND AIRCRAFT RETURNED TO SERVICE. (M)
Back to JASC 2565