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 96UAL900844Inflate Tube · leakingDURING TIME CONTROLLED OVERHAUL SLIDE DEVELOPED SEAM LEAK ON INFLATION TUBE. SLIDE SCRAPPED.SDR 9623179977Slide · low batteryDURING PERIODIC CHECK, FOUND MAIN CABIN DOOR EVACUATION SLIDE LIGHT BATTERY INOPERATIVE. REPLACED SLIDE.SDR 9623039960Slide · low pressureDURING LINE MAINTENANCE INSPECTION, FOUND GALLEY SERVICE DOOR EVACUATION SLIDE LOW ON PRESSURE. REPLACED SLIDE.SDR SWAA961173Slide · low pressureDURING SCHEDULED SERVICE CHECK, FOUND FWD ENTRY DOOR SLIDE PRESSURE BELOW SERVICEABLE LIMITS. REPLACED SLIDE PER BOEING M/M.SDR 97ZZZX581Discharge Valve · spring missingDURING OVERHAUL OF ESCAPE SLIDE ASSEMBLY FOUND DISCHARGE VALVE MISSING ITS BALL SPRING P/N 504S0023. CAUSE FOR CONDITION IS DUE TO ASSEMBLY ERROR DURING LAST OVERHAUL OR VALVE SERVICING. CONDITION AS STATED COULD HAVE RESULTED IN LOSS OF STORED GASSES FROM SSDR 9622689957Slide · failed inspDURING PERIODIC CHECK, MAIN CABIN DOOR EVACUATION SLIDE FAILED INSPECTION. REPLACED SLIDE.SDR UPS96821384Door Slide · low pressINSPECTION TYPE-N/A, MAIN ENTRY DOOR ESCAPE SLIDE PRESSURE LOW SEE REQ A446735. REMOVED AND REPLACED MAIN ENTRY DOOR ESCAPE SLIDE ON 5156100-4DG.SDR 9622419304Slide · deployedAFT TAILCONE EVACUATION SLIDE INADVERTANTLY DEPLOYED. REPLACED SLIDE.SDR CALA9601474Slide · failedAFT SERVICE DOOR SLIDE FAILED EMERGENCY SLIDE LIGHT FUNCTIONAL CHECK. REPLACED EMERGENCY SLIDE PER MAINTENANCE MANUAL.SDR SWAA961120Slide · low pressureDURING SCHEDULED SERVICE CHECK, FOUND AFT ENTRY DOOR SLIDE PRESSURE BELOW MINIMUM. REMOVED AND REPLACED SLIDE ASSEMBLY PER BOEING M/M.SDR CALA9601469Slide · tornSLIDE ON FORWARD GALLEY TORN AT GIRT BAR. REMOVED AND REPLACED SLIDE PER MAINTENANCE MANUAL.SDR 96UAL900815Inflate Tube · separatedDURING TIME CONTROLLED OVERHAUL, SLIDE SUFFERED SEAM SEPARATION OF THE INFLATION TUBE. SCRAPPED UNIT.SDR 96UAL900814Bulkhead · failedDURING TIME CONTROLLED OVERHAUL, RAMP PORTION OF SLIDE SUFFERED INTERNAL BULKHEAD FAILURE. ALSO, LT RAMP RAIL, LOWER END SUFFERED INTERNAL BULKHEAD FAILURE. SCRAPPED RAMP PORTION OF SLIDE.SDR SWAA961103Slide · low pressureDURING SCHEDULED A1 CHECK, FOUND FWD SERVICE DOOR ESCAPE SLIDE PRESSURE LOW. REPLACED PER BOEING M/M.SDR 9621889960Slide Battery · dischargedDURING PERIODIC CHECK, FORWARD ENTRANCE DOOR EVACUATION SLIDE FAILED BATTERY TEST. REPLACED SLIDE.SDR AWXA960582Cable · brokenPHX - FLT 10 - DURING ROUTINE MAINTENANCE CHECK, FOUND R2 DOOR GIRT BAR RELEASE CABLE BROKEN. REMOVED AND REPLACED CABLE. (M)SDR ASAA9680223Inflation Bottle · low pressurePDX - DURING MAINTENANCE CHECK, THE L-2 DOOR EVACUATION SLIDE INFLATION BOTTLE PRESSURE WAS FOUND LOW. REPLACED EVACUATION SLIDE ASSEMBLY. (M)SDR 9621699914Batteries · dischargedDURING PERIODIC CHECK, FOUND MAIN CABIN DOOR AND GALLEY DOOR EVACUATION SLIDES WITH LOW BATTERIES. REPLACED SLIDE.SDR AWXA960556Slide · deployedCMH - FLT 2860 - L-1 DOOR SLIDE INADVERTENTLY FELL OFF AND PARTIALLY OPENED. REMOVED AND REPLACED L-1 DOOR SLIDE IAW 25-62-44. OPERATIONS CHECKED GOOD. (M)SDR ORJA9662Slide · low pressureREMOVE AND REPLACE PASSENGER DOOR EVACUATION SLIDE DUE TO LOW BOTTLE PRESSURE. REMOVED AND REPLACED PASSENGER DOOR EVACUATION SLIDE DUE TO LOW BOTTLE PRESSURE. (X)SDR 97ZZZX286Slide · not chargedATW - FLT 514 - FA REPORTS THAT THE RIGHT FORWARD PASSENGER DOOR EVACUATION SLIDE CHARGE IS IN THE RED. CORRECTIVE ACTION: REMOVED AND REPLACED EVAC SLIDE, CHECKS BAD, GENERATED W/C FOR CONTINUATION OF MAINTENANCE. S/N OFF: 0397. S/N ON: 0627.SDR 96UAL900768Excape Slide · deployedPER CREW, DOOR 4R SLIDE DEPLOYED. AIRCRAFT FERRIED TO LAX. REPLACED SLIDE AND DOOR EMERGENCY BOTTLE, OPERATION CHECKS NORMAL.SDR 96UAL900764Regulator · failedSLIDE REMOVED FOR TIME CONTROLLED OVERHAUL. DURING FLAT FIRE, BOTTLE VALVE FAILED TO FULLY OPEN DUE TO DAMAGED ROTATION SHAFT AND PIN. OVERHAULED VALVE, REPLACED SHAFT AND CONTACTED MANUFACTURER.SDR 96UAL900757Seam · separatedDURING TIME CONTROLLED OVERHAUL SLIDE, ENCOUNTERED SEAM SEPARATION. SCRAPPED UNIT.SDR SWAA961015Slide · low pressureDURING SCHEDULED SERVICE CHECK, FOUND FORWARD SERVICE DOOR EVACUATION SLIDE PRESSURE LOW. REPLACED SLIDE PER BOEING M/M.SDR 9620609605Slide · low pressureDURING PERIODIC CHECK, FOUND MAIN CABIN DOOR EVACUATION SLIDE LOW ON PRESSURE. REPLACED SLIDE.SDR ASAA9640086Slide · misinstalledOAK - DURING C-CHECK, DURING THE REINSTALLATION OF THE LEFT AFT DOOR EMERGENCY EXIT SLIDE, THE SLIDE WAS FOUND TO HAVE HAD A RED SECURING STRAP WRAPPED AROUND THE SLIDE. REMOVED STRAP AND COMPLETED SLIDE INSTALLATION. (M)SDR ASAA9680208Evac Slide · brokenSEA - PRIOR TO DEPARTURE OF FLIGHT 598 - CREW REPORTED THE R1 DOOR EMERGENCY EVACUATION SLIDE DEPLOY LANYARD WAS BROKEN AND DETACHED. REPLACED THE EMERGENCY EVACUATION SLIDE. (M)SDR 96UAL900718Inflate Tube · separatedDURING CONTROLLED OVERHAUL, SLIDE FAILED DUE TO SEAM SEPARATION OF THE INFLATION TUBE. SLIDE SCRAPPED.SDR 96UAL900717Inflate Tube · separatedDURING TIME CONTROLLED OVERHAUL, SLIDE FAILURE DUE TO SEAM SEPARATION OF THE INFLATION TUBE. UNIT SCRAPPED.SDR TWRA96315Slide · deployedINADVERTENTLY, L1 DOOR WAS OPENED WHILE IN AUTO MODE SLIDE DEPLOYED. PERFORMED INSPECTION PER 5-51-23. REPLACED SLIDE AT L21 DOOR PER TC 25-665-1L AND REPLACED DOOR ASSIST BOTTLE AT L1 DOOR PER WIC 25-615-4-2. OPERATIONAL CHECKED NORMAL. AIRCRAFT RETURN TOSDR 96522Slide · low pressureDURING SERVICE CHECK, FOUND TAIL EVACUATION SLIDE PRESSURE LOW. MAINTENANCE REMOVED AND REPLACED TAIL EVACUATION SLIDE.SDR 96UAL900709Slide · separatedDURING TIME CONTROLLED OVERHAUL, SLIDE FAILED DUE TO SEAM SEPARATION OF THE INFLATION TUBE. *S/D* UNIT SCRAPPED.SDR MWEA96519Slide · low pressureDURING SERVICE CHECK, FOUND FWD ENTRY EVAC SLIDE PRESSURE LOW. REPLACED FWD ENTRANCE DOOR EVAC SLIDE.SDR ASAA9680194Slide Bottle · low pressureLAX - DURING MAINTENANCE CHECK, THE R1 DOOR EMERGENCY EVACUATION SLIDE INFLATION BOTTLE PRESSURE WAS FOUND LOW. REPLACED THE EMERGENCY EVACUATION SLIDE. (M)SDR 96ZZZX5077Aspirator · damagedEVACUATION SLIDE DEFECTIVE. NO MALFUNCTION OCCURRED. DAMAGE WAS DISCOVERED DURING ROUTINE OVERHAUL. SUSPECT CAUSE: IMPROPER PACKING PROCEDURES CAUSING BOTH ASPIRATOR BODIES TO BE DEFORMED. ONE SO BADILY STRESSED, A WELD WAS BROKEN. RECOMMENDATION: ENSURESDR AALA961326Slide · low pressureTPA - DURING OVERNIGHT CHECK, FORWARD ENTRY DOOR EMERGENCY EVACUATION SLIDE BOTTLE PRESSURE NOTED OUT OF GREEN RANGE. REPLACED FORWARD ENTRY DOOR EMERGENCY EVACUATION SLIDE ASSEMBLY. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR 96UAL900687Center Tube · wornDURING TIME CONTROLLED OVERHAUL WEAR WAS FOUND IN THE CENTER INFLATION TUBE AND SLIDING SURFACE. PATCHED TUBE AND SLIDING SURFACE PER VENDOR MANUALSDR 96UAL900683Seam · separatedDURING SHOP OVERHAUL OF SLIDE REMOVED FOR EXPIRATION OF TIME, A SEAM SEPARATION OCCURRED. SCRAPPED UNIT.SDR 96UAL900682Seam · separatedDURING SHOP OVERHAUL OF SLIDE REMOVED FOR EXPIRATION OF TIME, A FLOOR SEAM UNDER THE SURVIVAL KIT SEPARATED. SCRAPPED UNIT.SDR MWEA96425Evac Slide · low pressDURING SERVICE CK, FOUND FWD GALLEY SERVICE DOOR EVAC SLIDE PRESSURE LOW. REPLACED GALLEY DOOR EVACUATION SLIDE.SDR AWXA960464Slide · malfunctionedLAX/PHX - FLT 2274 - R-2 DOOR SLIDE INADVERTENTLY DEPLOYED, BUT DID NOT INFLATE IN LAX. INSTALLED R-2 DOOR SLIDE PER CARD R1C25304. PART TOTAL CYCLES, 7,527. (X)SDR UPS96421035Escape Slide · improperly instINSPECTION TYPE, ESCAPE SLIDE INOP. CABLES DISCONNECTED ALSO SLIDE IS NOT ON ITS MOUNT, FWD SIDE. REINSTALLED ESCAPE SLIDE PER MM 25-68-02.SDR SCNA96241Slide Assy · inoperativeTHE L1 DOOR SLIDE REMOTE PRESS-TO-TEST INDICATOR LIGHT STAYS ON. BOTTLE PRESSURE CHECKS OK. REPLACED L1 DOOR SLIDE ASSEMBLY PER MM 52. INSPECTED SLIDE INSTALLATION AND OPS CHECKED REMOTE TEST SYSTEM.SDR TAOA089610Slide · deployedFLT ATTENDANT TRAINING, DEPLOYED SLIDE FROM FORWARD RIGHT GALLEY SERVICE DOOR. SLIDE INFLATION AND EMERGENCY LIGHTS CHECKED NORMAL. (M)SDR 96UAL900654Slide · punctureRIGHT OFF WING EVACUATION SLIDE WAS REMOVED FOR TIME CONTROLLED OVERHAUL. UNIT HAS PUNCTURE HOLES WHICH CORRESPOND WITH THE DOOR/PACKBOARD INSTALLATION BOLTS. UNIT REPAIRED BY OUTSIDE EQUIPMENT MANUFACTURER. AIRCRAFT AND INSTALLED EVACUATION SLIDES WERE CHECSDR 96UAL900633Upper Tube · porousUNIT RETURNED TO SHOP FOR SECOND TIME CONTROLLED OVERHAUL. UNIT HAS POROSITY ON THE UPPER INFLATION TUBE WHERE IT MEETS THE TOP TUBE. UNIT RETURNED TO MANUFACTURER FOR REPAIR.SDR 96UAL900625Slide · seam leakDURING SHOP OVERHAUL OF SLIDE REMOVED FOR TIME EXPIRATION, THE INFLATABLE PORTION DEVELOPED A SEAM LEAK. SCRAPPED UNIT.SDR SWAA960732Slide · deployedINADVERTENT SLIDE DEPLOYMENT AT FWD SERVICE DOOR. REPLACED SLIDE ASSEMBLY PER BOEING M/M.SDR TAOA079609Slide · low pressureL-1 EMERGENCY ESCAPE SLIDE AIR PRESSURE LOW. REPLACED L-1 SLIDE. (M)
Back to JASC 2565