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 9608649913Slide · low pressureDURING PERIODIC CHECK, FOUND MAIN CABIN DOOR EVACUATION SLIDE LOW ON PRESSURE. REPLACED SLIDE.SDR QXEA9600149Slide · low pressEVACUATION SLIDE BOTTLE PRESSURE IS OUT OF THE GREEN ARC .SLIDE WAS REPLACED AND AIRCRAFT RETURNED TO SERVICE.SDR UPS96805960Escape Slide · failed to deployCREW REPORTED ESCAPE SLIDE FAILED TO DEPLOY. REPLACED SLIDE ASSY, DAMAGED LANYARD.SDR MWEA96108Evac Slide · low pressureDURING INSPECTION, FOUND TAIL SLIDE PRESSURE LOW AT 2,400 PSI. REPLACED TAIL SLIDE ASSY.SDR 96UAL900247Girt Tube · wornSLIDE REMOVED FOR OVERHAUL. SLIDE HAD 3 HOLES ON THE LOWER SIDE OF THE GIRT INFLATION TUBE. REPAIRED SLIDE PER VENDORS MANUAL.SDR 9607829612Evac Slide · low pressureDURING LINE MAINTENANCE INSPECTION, FOUND TAIL CONE EMERGENCY EVACUATION SLIDE LOW ON PRESSURE. REPLACED SLIDE.SDR 9607409943Evac Slide · low pressureDURING LINE MAINTENANCE INSPECTION, FOUND GALLEY DOOR EVACUATION SLIDE LOW ON PRESSURE. REPLACED SLIDE.SDR DL72L960833Slide · torn webbingON PREFLIGHT, FOUND RT AFT SERVICE DOOR EMERGENCY SLIDE WEBBING AT GIRT BAR TORN. REPLACED SLIDE.SDR DL757960713Slide · low pressR2 DOOR SLIDE BOTTLE PRESSURE LOW. REPLACED SLIDE ASSY.SDR DL757960709Slide · deployedR-1 DOOR SLIDE WAS NOT DEACTIVATED BY CREW PRIOR TO ARRIVAL AT GATE. R-1 DOOR SLIDE DID NOT DEPLOY PROPERLY WHEN DOOR WAS OPENED BY CABIN SERVICE. DOOR SLIDE DID NOT CLEAR DOOR SLIDE COVER, UPON DOOR OPENING. DOOR WAS HUNG ON DOOR SLIDE IN PARTIALLY OPENED SDR ASAA9680085Slide Bottle · low pressSEA - FLT NR 242 - CREW REPORTED TAILCONE EMERGENCY EVACUATION SLIDE PRESSURE LOW. REPLACED TAILCONE SLIDE ASSEMBLY. (M)SDR 9607019960Evac Slide · low pressureDURING PERIODIC CHECK, FOUND TAILCONE EVACUATION SLIDE LOW ON PRESSURE. REPLACED SLIDE.SDR 96UAL900209Hinge Tape · tornDURING ROUTINE OVERHAUL OF SLIDE, FOUND TORN HINGE TAPE AT LEFT HAND OUTBOARD INTERNAL BULKHEAD. ADDITIONALLY FOUND BULKHEAD SEPARATION EXTENDING APPROXIMATELY 2.5 INCHES FROM TOP END. UNIT SENT TO OEM FOR REPAIR.SDR AALA960426Slide · scrappedLAX - DURING SHOP TEST DEPLOYMENT, EMERGENCY EVACUATION UPPER TUBE HAD POROSITY LEAKS. SCRAPPED EMERGENCY EVACUATION SLIDE.SDR AALA960425Slide · scrappedLAX - DURING A SHOP OVER PRESSURE CHECK, FOUND THE EMERGENCY EVACUATION SLIDE TUBE TORN OPEN. SCRAPPED EMERGENCY EVACUATION SLIDE. (M)SDR 96UAL900206Top Tube · leakingSLIDE RAFT REMOVED FOR FIRST TIME. CONTROLLED OVERHAUL AND FAILED AIR RETENTION TEST. SLIDE RAFT HAD POROSITY AT ALL SEAMS AND A SEAM LEAK AT THE TOP TUBE. RETURNED FAULTY SLIDE RAFT TO ORGINAL EQUIPMENT MANUFACTURER FOR WARRANTY REPAIR.SDR 96UAL900201Upper Tube · wornSLIDE/RAFT REMOVED FOR FIRST TIME OVERHAUL AND FAILED THE AIR RETENTION TEST. ONE SCREW HEAD SECURING THE PRESSURE RELIEF VALVE WORE A HOLE THROUGH THE RELIEF VALVE CHAFE COVER, TUBE SEAM TAPE, 2 LAYERS OF TUBE FABRIC, AND THE TUBE FABRIC OPPOSITE THE TUBE SESDR MWEA96060Evac Slide · low pressureAFT ACCESSORY COMPARTMENT TAIL EVAC SLIDE PRESSURE READS BELOW MINIMUM. REPLACED TAIL EVACUATION SLIDE ASSY.SDR AWXA960137Door Slide · fell offLAS - FLT 292 - L-2 SLIDE FELL OFF DURING FLIGHT. REHUNG L-2 DOOR SLIDE. (M)SDR DL76L960600Slide · malfunctionedRIGHT REAR SLIDE FELL OUT OF THE DOOR COVER WITH DOOR HALF OPEN AND THEN OUT OF THE ACFT WITH THE GIRT BAR DETACHED. SLIDE BLOCKED EXIT AND REMAINED HUNG ON DOOR INSTEAD OF GIRT BAR FITTINGS. DOOR WAS OPENED FROM OUTSIDE OF A/C AND DOOR WAS DISARMED. REPLACSDR AALA960391Slide · low pressureATL - DURING OVERNIGHT CHECK, TAIL CONE EMERGENCY EVACUATION SLIDE PRESSURE GAUGE INDICATED IN RED (LOW) ZONE. REPLACED TAIL CONE EMERGENCY EVACUATION SLIDE. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR 96UAL900171Slide/Raft · failed testNR 3 RT SLIDE/RAFT REMOVED FOR TIME EXPIRATION. UNIT FAILED THE AIR RETENTION TEST DUE TO LEAKING AROUND THE COMMUNICATOR TUBE. RETURNED UNIT TO MANUFACTURER FOR REPAIR.SDR 96UAL900169Slide · failed testSLIDE FAILED AIR RETENTION TEST DURING OVERHAUL. FAILED DUE TO POROSITY. SLIDE SCRAPPED.SDR 96UAL900168Slide · failed testSLIDE FAILED AIR RETENTION TEST DURING OVERHAUL. AIR RETENTION FAILED DUE TO SLIDE POROSITY. SLIDE SCRAPPED.SDR 96UAL900167Slide · failed testSLIDE FAILED AIR RETENTION TEST DURING OVERHAUL. AIR RETENTION FAILED DUE TO SLIDE POROSITY. SLIDE SCRAPPED.SDR USAAD96026ASlide · malfunctionedFLT NR 307 - LGA - LEFT AFT CABIN DOOR CHUTE DEPLOYED WHEN IT FELL FROM THE DOOR AFTER UTILITY ENTERED. GIRT BAR WAS STOWED AND CAUGHT ON DOOR WHEN SLIDE PACK FELL. MAINTENANCE REPLACED THE AFT DOOR EMERGENCY SLIDE. NO PROBLEM EXISTED WITH THE SLIDES AS IT SDR ASAA9680063Slide · failedOAK - DURING C-CHECK, THE TAILCONE EMERGENCY EVACUATION SLIDE EMERGENCY LIGHTS FAILED TEST. REPLACED THE TAILCONE EMERGENCY EVACUATION SLIDE. (M)SDR QXEA9600079Slide · low pressPDX - FORWARD GALLEY EMERGENCY ESCAPE SLIDE BOTTLE PRESS FOUND LOW, 25 PSI. ITEM FOUND DURING C-CHECK. SLIDE REPLACED I/A/W MAINT MANUAL. AIRCRAFT RETURNED TO SERVICE.SDR P9IA096006Evac Slide · low pressureL2 EVACUATION SLIDE BOTTLE PRESSURE BELOW LIMITS. REPLACED L2 EVACUATION SLIDE PRESSURE BOTTLE IAW MM 25-0-15. (X)SDR USAAD96025Slide · failedFLT NR 517 - PHL - GALLEY EMERGENCY CHUTE PRESSURE IS 2500 PSI IN RED ZONE. REPLACED GALLEY EMERGENCY CHUTE. (M)SDR USAAF96024Slide · shiftedFLT NR 1017 - PIT - EMERGENCY SLIDE AT MAIN ENTRY DOOR IS COMING OUT OF ITS PACK. REPLACED MED EMERGENCY SLIDE PER MM. OPS CHECK GOOD. (M)SDR 9604789938Slide · low pressureDURING PERIODIC CHECK, FOUND FORWARD SERVICE DOOR EVACUATION SLIDE LOW ON PRESSURE. REPLACED SLIDE.SDR AALA960287Evacuation Slide · defectiveJFK - FLT 0587 - AFTER PUSH BACK FROM THE GATE WHEN NR 2 ENGINE STARTED, SMOKE NOTED IN COCKPIT. AIRCRAFT WAS EVACUATED USING SLIDES AND DOOR 3R EMERGENCY EVACUATION SLIDE CAME OUT OF THE CONTAINER AND PARTIALLY UNFOLDED, BUT DID NOT INFLATE. REPLACED EMERGESDR 9604119989Slide · low pressureDURING LINE MAINTENANCE INSPECTION, FOUND TAIL EVACUATION SLIDE LOW ON PRESSURE. REPLACED SLIDE.SDR 9604109604Slide · low pressureDURING PERIODIC CHECK, FOUND FORWARD GALLEY SERVICE DOOR EVACUATION SLIDE LOW ON PRESSURE. REPLACED SLIDE.SDR 9604149948Slide · low pressureDURING LINE MAINTENANCE INSPECTION, FOUND TAIL CONE EVACUATION SLIDE LOW ON PRESSURE. REPLACED SLIDE.SDR AU960169Cable · misinstalled(AUS) LT OFF WING ESCAPE SLIDE SEPARATED FROM STOWAGE COMPARTMENT BUT DID NOT INFLATE AND DEPLOY AS REQUIRED - INVESTIGATION FOUND THATTHE FAILURE WAS IN THE TRANSFER OF FORCE FROM THE INFLATION TRIGGER TO THE FIRING MECHANISM WITH THE TRIGGER CABLE BEING FESDR 96UAL900100Slide · leakingDOOR 4 RT, RETURNED TO SHOP FOR TIME CONTROLLED OVERHAUL. THE LOWER INFLATION TUBE IS LEAKING AT THE SEAMS. ALSO, THERE IS CORROSION IN BOTH ASPIRATORS AND ON THE CHECK VALVES. RETURNED TO VENDOR FOR REPAIR.SDR 96UAL900099Slide · leakingDOOR 2 RT SLIDE RETURNED TO SHOP FOR TIME CONTROLLED OVERHAUL. LOWER INFLATION TUBE IS LEAKING AT THE SEAMS AND THERE IS CORROSION IN BOTH ASPIRATORS AND ON THE CHECK VALVES. RETURNED TO VENDOR FOR REPAIR.SDR MWEA96036Slide · low pressDURING SERVICE CHECK, FOUND TAIL EVACUATION SLIDE PRESSURE LOW. INSTALLED SERVICEABLE TAIL SLIDE.SDR DLM88960279Lanyard · detachedL1 DOOR GIRT BAR HARD TO OPERATE. FOUND SLIDE PACK LANYARD DETACHED FROM SLIDE. REMOVED AND REPLACED SLIDE ASSY.SDR 9603369610Slide · low pressureDURING PERIODIC CHECK, FOUND AFT TAIL SECTION EMERGENCY EVACUATION SLIDE WITH LOW PRESSURE. REPLACED SLIDE.SDR 9603059967Slide · low pressureDURING LINE MAINTENANCE INSPECTION, FOUND MAIN CABIN DOOR EVACUATION SLIDE LOW ON PRESSURE. REPLACED SLIDE.SDR 96UAL900084Schrader Valve · leakingSLIDE REMOVED FOR TIME CONTROLLED OVERHAUL. SLIDE HAS SCHRADER VALVE SEPARATION FROM THE SLIDE MATERIAL. REINSTALLED THE SCHRADER VALVE TO THE LATEST MODEL ASPIRATOR AND PATCHED THE SLIDE PER VENDOR MANUAL.SDR 9602699902Slide · low pressureDURING LINE MAINTENANCE INSPECTION, FOUND TAIL EVACUATION SLIDE LOW ON PRESSURE. REPLACED SLIDE.SDR DL72S960178Cable · brokenLEFT SERVICE DOOR EVACUATION SLIDE FAILED TO DEPLOY AND PULL HANDLE CAME OFF WHEN PULLED. CABLE ON PULL HANDLE BROKE. REPLACED DOOR SLIDE PER M/M 25-60-15.SDR ASAA9680025Slide Bottle · low pressureSEA - DURING MAINTENANCE CHECK, THE R1 DOOR EMERGENCY EVACUATION SLIDE INFLATION BOTTLE PRESSURE WAS FOUND LOW. REPLACED THE R1 DOOR EMERGENCY EVACUATION SLIDE. (M)SDR 96UAL900049Seam · leakingNR 2L EVACUATION SLIDE REMOVED FOR EXPIRATION OF TIME. SHOP FOUND MINOR SEAM LEAK ON THE TUBE DIRECTLY UNDER THE GIRT. REPAIRED SEAM LEAK, NON-STRUCTUAL.SDR MWEA96004Evac Slide · low pressureDURING A-CHECK, FOUND TAIL EVAC SLIDE PRESSURE LOW. REPLACED TAIL EVAC SLIDE.SDR ASAA9640003Slide · failed to deploySEA - THE L-2 EMERGENCY EVACUATION ESCAPE SLIDE FAILED TO DEPLOY FULLY DURING TESTING. REPLACED SLIDE ASSEMBLY. THOROUGH INVESTIGATION AND FUNCTIONAL EVALUATION BY AIRCRUISERS COMPANY SHOWED NO ABNORMALITIES IN THE HARDWARE OR FUNCTIONING OF THE SLIDE. NO R
Back to JASC 2565