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 USAAD97193Slide · failedPIT - THE TAILCONE INADVERTENTLY DEPLOYED BUT THE EMERGENCY EVACUATION SLIDE DID NOT. MAINTENANCE REPLACED THE TAILCONE ASSEMBLE DUE TO DAMAGE AND THE EMERGENCY EVACUATION SLIDE FOR NOT DEPLOYING. (M)SDR SWAA970969Slide · low pressDURING SCHEDULED RON CHECK, FOUND AFT ENTRY DOOR ESCAPE SLIDE PRESSURE LOW\N\NREPLACED PER BOEING M/MSDR 9720639993Slide · low pressureDURING LINE MAINTENANCE INSPECTION, FOUND MAIN CABIN DOOR EVACUATION SLIDE BOTTLE PRESSURE LOW. REPLACED SLIDE.SDR 9720649606Battery · dischargedDURING PERIODIC CHECK, MAIN CABIN DOOR EVACUATION SLIDE FAILED BATTERY TEST. REPLACED SLIDE.SDR 9720629903Battery · dischargedDURING PERIODIC CHECK, FORWARD GALLEY SERVICE DOOR EVACUATION SLIDE FAILED BATTERY TEST. REPLACED SLIDE, OPERATIONAL CHECK OK.SDR 9720369903Battery · dischargedDURING PERIODIC CHECK, FORWARD ENTRY DOOR EVACUATION SLIDE FAILED BATTERY TEST. REPLACED SLIDE.SDR 9720379928Slide Bottle · low pressureDURING LINE MAINTENANCE INSPECTION, FOUND TAIL CONE EVACUATION SLIDE BOTTLE LOW ON PRESSURE. REPLACED SLIDE.SDR TWRA97187Slide Strap · brokenWHILE ATTEMPTING A SLIDE/RAFT DEMONSTRATION FOR A GROUP OF FLIGHT ATTENDANTS AT JFK, THE SLIDE FAILED TO DEPLOY DUE TO GRID LANYARD STRAP SNAPPED IN HALF (SLIDE NOT MOUNTED AT THE DOOR ATTACHED TO FLOOR BRACKET). REMOVED SLIDE AND SHIPPED TO VENDOR FOR EVALUASDR AU971400Actuator · faulty(AUS) DOOR 1R ESCAPE SLIDE DOOR ACTUATOR FAULTY. ACTUATOR DID NOT OPEN THE DOOR CORRECTLY WITH THE SLIDE PUSHING THE DOOR FULLY OPEN. IT WAS ALSO NOTICED THAT THE EMERGENCY EQUIPMENT FELL OUT OF THE SLIDE. THE SLIDE DEPLOYED FULLY.SDR ASAA9780258Slide · failed testOAK - DURING C-CHECK, THE TAIL CONE EMERGENCY EVACUATION SLIDE FAILED THE EMERGENCY LIGHT AMP TEST. REPLACED THE TAIL CONE EMERGENCY EVACUATION SLIDE ASSEMBLY. (X)SDR 9720069611Slide · low batteryDURING PERIODIC CHECK, FOUND FORWARD SERVICE DOOR EMERGENCY EVACUATION SLIDE BATTERY LOW. REPLACED SLIDE.SDR SWAA970960Slide · low pressureDURING SCHEDULED A1 CHECK, FOUND AFT ENTRY DOOR ESCAPE SLIDE PRESSURE LOW. REPLACED PER BOEING M/M.SDR 9720006614Evac Slide · failedDURING DOOR EVACUATION SLIDE CHECK, DOOR 3R EVACUATION SLIDE DID NOT FULLY INFLATE. REPLACED DOOR 3R EVACUATION SLIDE. OPERATIONAL CHECK GOOD.SDR UPS97824772Slide · damagedINSPECTION TYPE-N/A, EMERGENCY ESCAPE SLIDE GIRT BAR HAS BEEN PULLED OUT TO FAR FROM STORAGE AREA AND NEEDS TO BE REPLACED. EMERGENCY SLIDE DEFERRED PER MMOC CONTR NR D-140201. SLIDE REMOVED AND STOWED IN THE BELLY COMPARTMENT 32. COURIER SEATS TAPED REF EOSDR TWAA9712701Slide · deployedSTL - WHILE PARKED AT THE GATE THE TAILCONE EMERGENCY ESCAPE SLIDE WAS INADVERTENTLY DEPLOYED BY SECURITY PERSONNEL. THE SLIDE FUNCTIONED PROPERLY. REMOVED AND REPLACED SLIDE, MFG P/N 100506-201, MANUFACTURED BY BF GOODRICH COMPANY. (M)SDR VJ970329Emergency Slide · low pressureMAIN CABIN EMERGENCY DOOR SLIDE PRESSURE 26 PSI. REPLACED SLIDE IAW MM 25-60 AND ACCOMPLISHED REQUIRED INSPECTION.SDR ASAA9740081Slide · out of limitsPDX - DURING MAINTENANCE CHECK THE L2 DOOR EVAC SLIDE PRESSURE GAUGE WAS FOUND TO BE READING OUT OF LIMITS. MAINTENANCE REPLACED THE L2 DOOR EVAC SLIDE AND GAUGE INDICATED NORMAL. PART TOTAL CYCLES, 315. (X)SDR GTIA9700384Slide · low pressDTW - AFT EVACUATION SLIDE READING LOW ON PRESSURE. REMOVED AND REPLACED AFT EVACUATION SLIDE. ALL WORK DONE IAW DC-9 MM 25-62-1. RII INSPECTION PERFORMED. (M)SDR SWAA970903Slide · looseDURING WALKAROUND CHECK, FOUND FWD SERVICE DOOR ESCAPE SLIDE WOULD NOT REMAIN SECURED IN CONTAINER. REPLACED PER BOEING M/M.SDR 97UAL900778Slide Door · missingOVERWING ESCAPE SLIDE LOST IN FLIGHT. *S/D* FORWARD LATCH OF OFF WING ESCAPE SLIDE COMPARTMENT DOOR NOT LATCHED. TYPE II MAINTENANCE REPAIRS ACCOMPLISHED ON A/C. IMPLEMENTING SB 757-25-0182, OFF WING SLIDE COMPARTMENT DOOR LATCH MOD AND SENSOR RELOCATION.SDR ASAA9780247Emerg Evac Slide · low pressurePDX - DURING MAINTENANCE CHECK, THE R1 DOOR EMERGENCY EVACUATION SLIDE INFLATION BOTTLE PRESSURE WAS FOUND LOW. REPLACED THE R1 DOOR EMERGENCY EVACUATION SLIDE ASSEMBLY. (M)SDR CALA9701432Slide · low pressureL-1 DOOR SLIDE PRESSURE LOW. REMOVED AND REPLACED L-1 DOOR SLIDE ASSEMBLY IN ACCORDANCE WITH MM 25-61-311.SDR 97UAL900768Tube · failedDURING THE SHOP OVERHAUL OF AN EVACUATION SLIDE REMOVED FOR TIME EXPIRATION IT FAILED THE PROOF TEST. THERE WAS A SEAM SEPARATION OF OVER 8 FEET ON THE LEFT TOP TUBE STARTING AT THE UPPER INTERNAL BULKHEAD AND GOING DOWN TOWARD THE SLIDE FOOT IN THE CROUCH ARSDR 9718959610Slide · low batteryDURING PERIODIC CHECK, SERVICE DOOR EVACUATION SLIDE FAILED BATTERY TEST. REPLACED SLIDE.SDR 97UAL900752Tube · tornDURING SHOP OVERHAUL OF SLIDE, REMOVED FOR EXPIRATION OF TIME THE TOP TUBE DID NOT FULLY INFLATE. FOUND A 40 INCH TEAR IN UPPER CROSS OVER TUBE FROM RIGHT SIDE OF GIRT TO RIGHT UPPER TUBE. SLIDE SENT TO VENDOR FOR REPAIR.SDR DLL15971943Slide · brokenTHE L3 DOOR EMERGENCY SLIDE PACK FULLY DISENGAGED FROM THE DOOR BUT DID NOT DEPLOY DURING ROUTINE OPERATIONAL CHECK. FOUND BOTH PRIMARY RELEASE CABLE PAWL PLATES BROKEN. REF MM 25-61-01 PAGE 409/410 DETAIL E. REPLACED SLIDE.SDR ASAA9780225Inflation Bottle · low pressureLAX - DURING MAINTENANCE CHECK, THE L2 DOOR EMERGENCY EVACUATION SLIDE INFLATION BOTTLE PRESSURE WAS FOUND LOW. REPLACED THE L2 DOOR EMERGENCY EVACUATION SLIDE ASSEMBLY. (M)SDR SWAA970902Slide · low pressDURING WALKAROUND CHECK, FOUND AFT ENTRY DOOR ESCAPE SLIDE PRESSURE LOW. REPLACED PER BOEING M/M.SDR 97UAL900737Slide · low pressureDOOR 2R SLIDE PRESSURE LOW. *S/D* REPLACED EVACUATION SLIDE.SDR CA971016014Overwing Slide · missing(CAN) LEFT HAND OVERWING SLIDE FOUND MISSING ON ARRIVAL. SLIGHT DAMAGE TO FLAP AND FILET FAIRING WAS NOTED. NEW OVERWING SLIDE ASSEMBLY INSTALLED AND SYSTEM REACTIVATED.SDR CALA9701383Slide · inoperativeTHE UPPER DECK CREW DOOR EMERGENCY SLIDE ONLY PARTIALLY INFLATED DURING TEST WHILE AIRCRAFT WAS IN C-CHECK. MAINTENANCE NOTED THAT THE SLIDE BOTTLE HAD DISCHARGED. *S/D* INSPECTION OF THE SLIDE BY THE VENDOR FOUND DAMAGE TO THE PACKBOARD ASSEMBLY, THE INFLASDR 97UAL900736Tube · failed testDURING OVERHAUL OF SLIDE REMOVED FOR TIME EXPIRATION THE LOWER TUBE FAILED THE AIR RETENTION TEST. FAILURE DUE TO POROSITY IN THE LOWER TUBE INFLATABLE MATERIAL. SLIDE SENT TO VENDOR FOR REPAIR.SDR ASAA9780208Cable · brokenPDX - DURING MAINTENANCE CHECK, THE R1 DOOR EMERGENCY EVACUATION SLIDE GIRT BAR ATTACH CABLE WAS FOUND BROKEN. REPLACED THE CABLE ASSEMBLY. (M)SDR ASAA9780204Inflation Bottle · high pressurePDX - DURING MAINTENANCE CHECK, THE L1 DOOR EMERGENCY EVACUATION SLIDE INFLATION BOTTLE PRESSURE WAS FOUND HIGH. REPLACED THE L1 DOOR EMERGENCY EVACUATION SLIDE ASSEMBLY. (M)SDR SWAA970849Slide · high pressDURING WALKAROUND CHECK, FOUND AFT SERVICE DOOR SLIDE PRESSURE EXCESSIVE. REPLACED SLIDE PER BOEING M/M.SDR SWAA970848Slide · out of dateDURING SCHEDULED RON CHECK, FOUND AFT SERVICE DOOR SLIDE DUE FOR REMOVAL. REPLACED SLIDE PER BOEING M/M.SDR SWAA970847Slide · wornDURING SCHEDULED C3, FOUND AFT GALLEY DOOR SLIDE PACK MATERIAL WORN OFF AT AFT END OF GIRT BAR. REPLACED SLIDE PER BOEING M/M.SDR 9717769927Slide · low pressureDURING LINE MAINTENANCE INSPECTION, FOUND FORWARD GALLEY DOOR EVACUATION SLIDE BOTTLE LOW ON PRESSURE. REPLACED SLIDE.SDR 9717199954Slide Battery · dischargedDURING PERIODIC CHECK, FOUND MAIN CABIN DOOR EVACUATION SLIDE BATTERY LOW. REPLACED SLIDE.SDR ASAA9780195Inflation Bottle · low pressurePDX - DURING MAINTENANCE CEHCK, THE L2 DOOR EMERGENCY EVACUATION SLIDE INFLATION BOTTLE PRESSURE WAS FOUND LOW. REPLACED THE L2 DOOR EMERGENCY EVACUATION SLIDE ASSEMBLY. (M)SDR TWRA97173Evac Slide · failedUPPER DECK, CREW EVACUATION SLIDE DID NOT DEPLOY ON OPS CHECK. REMOVED AND REPLACED CREW EVACUATION SLIDE PER WORK CARD TC 25-664-1. (AIRCRAFT RETURNED TO SERIVCE 9-5-97).SDR 9716769979Slide · low batteryDURING PERIODIC CHECK, FOUND MAIN CABIN DOOR EVACUATION SLIDE BATTERY LOW. REPLACED SLIDE.SDR SWAA970816Slide · low pressureDURING SCHEDULED TERMINAL CHECK, FOUND R1 SLIDE PRESSURE LOW. REPLACED SLIDE ASSEMBLY PER BOEING M/M.SDR SWAA970813Slide · malfunctionedDURING SCHEDULED TERMINAL CHECK, FOUND THAT FWD ENTRY SLIDE GIRT BAR WOULDN'T REMAIN IN FLOOR BRACKET. REPLACED SLIDE ASSEMBLY PER BOEING M/M.SDR AALA971745Slide · defectiveDFW - DURING OVERNIGHT CHECK, AIRCRAFT TAIL CONE INADVERTENTLY DEPLOYED BY CABIN SERVICE AND EMERGENCY EVACUATION SLIDE DID NOT DEPLOY. REPLACED AFT EMERGENCY EVACUATION SLIDE AND TAIL CONE ASSEMBLY. SYSTEM GROUND CHECKED, NORMAL OPERATION. (X)SDR CALA9701252Slide · low pressureTHE CREW FOUND L-1 DOOR EMERGENCY SLIDE PRESSURE LOW. THE L-1 DOOR SLIDE WAS REMOVED AND REPLACED PER MM 25-60-15.SDR CALA9701248Slide · low pressureTHE CREW FOUND THE L-3 DOOR SLIDE LOW PRESSURE LIGHT ILLUMINATED. THE L-3 DOOR SLIDE WAS REMOVED AND REPLACED IAW MM 25-61-02.SDR ASAA9780187Inflation Bottle · low pressureOAK - DURING C-CHECK, THE TAILCONE EMERGENCY EVACUATION SLIDE INFLATION BOTTLE PRESSURE WAS FOUND LOW. REPLACED THE TAILCONE EMERGENCY EVACUATION SLIDE ASSEMBLY. (M)SDR 97UAL900663Tube · separatedDURING SHOP OVERHAUL OF SLIDE REMOVED FOR TIME EXPIRATION, A 16 INCH SEAM SEPARATION OCCURRED IN THE RIGHT HAND DOG LEG TUBE. THE AREA AROUND THE SEPARATION WAS CLEANED AND THE SEAM REPAIRED.SDR 97UAL900669Shaft · twistedDURING SHOP OVERHAUL OF SLIDE, REMOVED FOR TIME EXPIRATION. THE SLIDE FAILED TO INFLATE TO MANUFACTURER'S SPECIFICATIONS. UPON DISASSEMBLY OF THE BOTTLE VALVE THE SHAFT WAS FOUND TO BE TWISTED. *S/D* REPLACED BOTTLE VALVE.
Back to JASC 2565