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 SWAA961442Slide · low pressDURING WALKAROUND INSPECTION, FOUND LEFT AFT ENTRY DOOR ESCAPE SLIDE PRESSURE BELOW SERVICEABLE LIMITS. REPLACED SLIDE ASSEMBLY PER BOEING M/M.SDR AWXA9600781Slide · malfunctionedL-1 DOOR SLIDE BLEW ON OPENING OF DOOR. REMOVED AND REPLACED L-1 DOOR SLIDE PER MM 25-00.SDR SWAA961446Slide · low pressDURING SCHEDULED RON CHECK, FOUND AFT ENTRY DOOR SLIDE PRESSURE LOW. REPLACED PER BOEING M/M.SDR 9627119950Slide · low pressureDURING LINE MAINTENANCE INSPECTION, FOUND TAILCONE EVACUATION SLIDE PRESSURE LOW. REPLACED SLIDE.SDR TWAA9700101Slide · failedATL - FLT 641 - AS A RESULT OF AN INADVERTENT TAIL CONE DROP, THE TAIL CONE ESCAPE SLIDE DEPLOYED, BUT FAILED TO INFLATE. THE SLIDE AUTO INFLATE LANYARD WAS IMPROPERLY INSTALLED. REMOVED AND REPLACED TAIL CONE ESCAPE SLIDE. CHECK C - 1-1-97 - MZJ. (X)SDR 97ZZZM397Slide · light failedNR 1 EVAC SLIDE LIGHTS BURNED OUT, SLIDE P/N D31050-103 S/N 0832. REMOVED AND REPLACED SLIDE ASSEMBLY. (M)SDR 96UAL900966Slide · failedSLIDE REMOVED FOR AIR CRUISERS SERVICE INFORMATION LETTER DEVELOPED AN INFLATION TUBE SEAM LEAK DURING SHOP TEST. SLIDE SCRAPPED DUE TO INFLATION TUBE SEAM LEAK.SDR 9626839911Evac Slide · low batteryDURING PERIODIC CHECK, MAIN CABIN DOOR EVACUATION SLIDE FAILED EMERGENCY BATTERY TEST. REPLACED SLIDE.SDR 9626819920Evac Slide · low pressureDURING LINE MAINTENANCE INSPECTION, FOUND TAILCONE EVACUATION SLIDE LOW ON PRESSURE. REPLACED SLIDE.SDR 9626809986Evac Slide · low batteryDURING PERIODIC CHECK, FOUND FORWARD SERVICE DOOR EVACUATION SLIDE WITH LOW BATTERY. REPLACED SLIDE.SDR AALA961851Slide · low pressureJFK - DURING OVERNIGHT CHECK, FOUND THE LEFT EMERGENCY EVACUATION SLIDE BOTTLE PRESSURE LOW. INSTALLED NEW SLIDE. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR TWRA96377Slide · deployedAFTER ARRIVAL 5L DOOR WAS INADVERTENTLY DEPLOYED. REMOVED AND REPLACED SLIDE AND DOOR ASSIST BOTTLE AS PER MM 25-65-01. OPS CHECKED NORMAL. A/C RETURN TO SERVICE. (M)SDR SWAA961387Slide · low pressDURING SCHEDULED TERMINAL CHECK, FOUND FWD ENTRY DOOR SLIDE PRESSURE LOW. REPLACED SLIDE PER BOEING M/M.SDR 96UAL900940Inflation Tube · leaksSLIDE REMOVED FOR AIR CRUISERS SERVICE INFORMATION LETTER 28-98. DURING SHOP OVERHAUL INFLATION TUBE DEVELOPED A SEAM LEAK. SLIDE SCRAPPED.SDR 96UAL900939Inflation Tube · leaksSLIDE REMOVED FOR AIR CRUISERS SERVICE INFORMATION LETTER 25-98. DURING SHOP OVERHAUL INFLATION TUBE DEVELOPED A SEAM LEAK. SLIDE SCRAPPED.SDR 96UAL900938Inflation Tube · leaksSLIDE REMOVED FOR AIR CRUISES SERVICE INFORMATION LETTER SIL 25-98. DURING SHOP OVERHAUL INFLATION TUBE DEVELOPED A SEAM LEAK. SLIDE SCRAPPED.SDR 96UAL900937Inflation Tube · leaksSLIDE REMOVED FOR AIR CRUISERS SERVICE INFORMATION LETTER. DURING SHOP OVERHAUL INFLATION TUBE DEVELOPED A SEAM LEAK. SCRAPPED SLIDE.SDR 96UAL900936Inflation Tube · leaksSLIDE REMOVED FOR AIR CRUISERS SERVICE INFORMATION LETTER. DURING SHOP OVERHAUL INFLATION TUBE DEVELOPED A SEAM LEAK. SCRAPPED SLIDE.SDR 96UAL900935Inflation Tube · leaksSLIDE REMOVED FOR AIR CRUISER SERVICE INFORMATION LETTER. DURING SHOP OVERHAUL INFLATION TUBE DEVELOPED A SEAM LEAK. SCRAPPED SLIDE.SDR SWAA961378Slide · low pressDURING SCHEDULED RON CHECK, FOUND AFT SERVICE DOOR SLIDE PRESSURE LOW. REPLACED PER BOEING M/M.SDR ASAA9680268Inflation Bottle · low pressureOAK - DURING C-CHECK, THE L2 DOOR EMERGENCY EVACUATION SLIDE INFLATION BOTTLE PRESSURE WAS FOUND LOW. REPLACED THE EMERGENCY EVACUATION SLIDE. (M)SDR SWAA961339Slide · low pressDURING WALKAROUND CHECK, FOUND FWD RT DOOR ESCAPE SLIDE PRESSURE BELOW SERVICABLE LIMITS. REPLACED PER BOEING M/M.SDR ASAA9680265Slide · failedOAK - DURING C-CHECK, THE TAILCONE EMERGENCY EVACUATION SLIDE EMERGENCY LIGHTS FAILED TEST. REPLACED THE TAILCONE EMERGENCY EVACUATION SLIDE. (M)SDR 9626149981Slide · low batteryDURING PERIODIC CHECK, FORWARD SERVICE DOOR EVACUATION SLIDE FAILED BATTERY TEST. REPLACED SLIDE.SDR 96UAL900923Inflation Tube · leakingSLIDE REMOVED PER AIR CRUISERS SERVICE INFORMATION LETTER 25-98. DURING SHOP OVERHAUL A SEAM LEAK DEVELOPED ON THE INFLATION TUBE. SCRAPPED SLIDE.SDR 96UAL900921Inflation Tube · leakingSLIDE REMOVED PER AIR CRUISERS SERVICE INFORMATION LETTER 25-98. DURING SHOP OVERHAUL A SEAM LEAK DEVELOPED ON THE INFLATION TUBE. SLIDE SCRAPPED.SDR 9625799941Slide · low pressureDURING LINE MAINTENANCE INSPECTION, FOUND MAIN CABIN DOOR EVACUATION SLIDE LOW ON PRESSURE. REPLACED SLIDE.SDR CALA9601716Slide · low pressureINSPECTION FOUND THE L-1 DOOR EMERGENCY SLIDE PRESSURE LOW. THE SLIDE WAS REMOVED AND REPLACED.SDR 97ZZZM405Slide · brokenLEFT FORWARD PAX DOOR EVAC SLIDE BACKBOARD IS BROKEN. REPLACED THE SLIDE.SDR ASAA9680263Slide Bottle · low pressureOAK - DURING C-CHECK, THE TAILCONE EMERGENCY EVACUATION SLIDE INFLATION BOTTLE PRESSUER WAS FOUND LOW. REPLACED THE TAILCONE EMERGNCY EVACUATION SLIDE. (M)SDR 9625209924Slide · low batteryDURING PERIODIC CHECK, FOUND FORWARD GALLEY SERVICE DOOR EVACUATION SLIDE BATTERY PACK INOPERATIVE. REPLACED SLIDE.SDR TWRA95362Door Slide · zero pressureROUTINE CHECK MAINTENANCE FOUND NR 3 MED SLIDE WITH ZERO PRESSURE. REMOVED AND REPLACED SLIDE AS PER MM 25-65-06 AND WI, TC 25-664-23R. OPERATIONAL CHECK OK. AIRCRAFT RETURN TO SERVICE. (M)SDR MWEA96636Evac Slide · low pressDURING SERVICE CHECK, FOUND FWD ENTRY DOOR EVACUATION SLIDE BOTTLE PRESSURE LOW. MAINTENANCE REMOVED AND REPLACED FWD ENTRY EVACUATION SLIDE. RETURNED A/C TO SERVICE. (X)SDR 96UAL900894Hose · crackedSLIDE WAS INADVERTANTLY DEPLOYED AND THE SLIDE PORTION OF THE SLIDE/RAMP DID NOT FULLY INFLATE. THE SLIDE INFLATION HOSES WERE FOUND TO BE BROKEN IN SEVERAL PLACES AND METAL FITTING WAS CRACKED. REPLACED HOSES AND SLIDE INFLATED SATISFACTORILY. SENT HOSES TSDR TWRA96360Slide · failedDURING TRAINING TEST, 4L MAIN ENTRY DOOR SLIDE FAILED TO DEPLOY CORRECTLY DUE TO ASPIRATOR HOSE 'B' FITTING FAILURE, SLIDE P/N D30440105 S/N 0817. REMOVED AND REPLACED 4L MAIN ENTRY DOOR SLIDE PER MM 25-69-00. OPS CHECK NORMAL. (M)SDR SWAA961283Slide · low pressDURING SCHEDULED RON CHECK, FOUND AFT SERVICE DOOR ESCAPE SLIDE PRESSURE LOW. REPLACED PER BOEING M/M.SDR 96UAL900878Slide · failed testSLIDE REMOVED FOR INADVERTANT DEPLOYMENT. DURING OVERHAUL, SLIDE FAILED AIR RETENTION TEST DUE TO POROSITY. SCRAPPED SLIDE AND INSTALLED NEW SLIDE.SDR 9625029913Slide · failed testDURING PERIODIC CHECK, FORWARD ENTRY EVACUATION SLIDE FAILED BATTERY TEST. REPLACED SLIDE.SDR TWRA96361Door Slide · low pressureDURING ROUTINE CHECK, MAINTENANCE FOUND NR 3MED SLIDE WITH LOW PRESSURE. REMOVED AND REPLACED SLIDE AS PER MM 25-65-01 PAGE 401. AIRCRAFT RETURNED TO SERVICE. (M)SDR G60A96323Slide · malfunctionedWHEN AIRCRAFT BLOCKED IN AT PHF FOR UNLOAD OF TRAINING CREW, THE DOOR WAS OPENED WITHOUT DISARMING EVACUATION SLIDE BY MEMBER OF FLIGHT CREW. THE SLIDE FAILED TO DEPLOY TO THE FULLY DEPLOYED POSITION. (X)SDR SWAA961278Slide · deployedDURING SCHEDULED RON, GALLEY DOOR SLIDE DEPLOYED. REPLACED SLIDE PER BOEING M/M.SDR SWAA961281Slide · low pressDURING SCHEDULED TERMINAL CHECK, FOUND AFT SERVICE DOOR ESCAPE SLIDE PRESSURE LOW. REPLACED PER BOEING M/M.SDR 96UAL900875Slide · leakingDURING TIME CONTROLLED OVERHAUL SLIDE DEVELOPED SEAM LEAK ON INFLATION TUBE. SLIDE SCRAPPED.SDR 96UAL900874Slide · leakingDURING TIME CONTROLLED OVERHAUL SLIDE DEVELOPED SEAM LEAK ON INFLATION TUBE. SLIDE SCRAPPED.SDR 96UAL900873Slide · leakingDURING TIME CONTROLLED OVERHAUL SLIDE DEVELOPED A SEAM LEAK ON INFLATION TUBE. SLIDE SCRAPPED.SDR 96UAL900871Inflation Tube · chafedDURING TIME CONTROLLED OVERHAUL, SLIDE UNIT INFLATABLE SHOWS CHAFE DAMAGE CAUSED BY THE PRESSURE RELIEF VALVE SCREWS. HOLES ARE WORN THROUGH THE CHAFE COVER (2) AND THROUGH THE TOP INFLATION TUBE (5 HOLES). EACH HOLE IS .25 INCH IN DIAMETER. PATCH PER MANUSDR ASAA9680254Slide · out of positionLAX - AFTER ARRIVAL OF FLT 255 - CREW REPORTED THE L2 DOOR DIFFICULT TO OPEN, APPEARS TO BE STICKING AT LOWER AFT CORNER. FOUND THE EMERGENCY EVACUATION SLIDE COVER HOLDING THE DOOR TRIM OUT OF POSITION AND INTERFERRING WITH DOOR FRAME. REPLACED THE EMERGENCSDR SWAA961240Slide · press lowDURING WALKAROUND CHECK, FOUND FWD ENTRY DOOR SLIDE PRESSURE BELOW MINIMUM LIMITS. REPLACED SLIDE PER BOEING M/M.SDR UF6A961101Escape Slide · failed to deploySBN - PERFORMED FUNCTIONAL TEST OF FORWARD ESCAPE SLIDE. SLIDE FAILED TO DEPLOY, PIN STAYED IN BOTTLE. MAINTENANCE DEPLOYED MANUALLY. (M)SDR 96ZZZM1552Cylinder · low pressureDURING SCHEDULED CHECK, THE EVACUATION SLIDE CYLINDER PRESSURE WAS FOUND BELOW LIMITS. THE EVACUATION SLIDE/CYLINDER ASSEMBLY WAS REPLACED.
Back to JASC 2565