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 SWAA040203Slide · out of adjustDURING SCHEDULED A2 CHECK, FOUND L2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED L2 DOOR EVAC SLIDE PER MM.SDR SWAA040202Slide · deployedR2 DOOR EVAC SLIDE INADVERTENT SLIDE DEPLOYMENT. REMOVED AND REPLACED R2 DOOR EVAC SLIDE PER MM.SDR SWAA040197Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND R2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R2 DOOR EVAC SLIDE PER MM.SDR SWAA040188Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND BOTH L2 AND R2 DOOR EVAC SLIDES OUT OF ADJUST. ADJUSTED BOTH L2 AND R2 DOOR EVAC SLIDES PER MM.SDR SWAA040187Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND R1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R1 DOOR EVAC SLIDE PER MM.SDR 2004UALA00415Squib · blownRT OVERWING SLIDE DOOR SQUIB BLOWN. SQUIB BLOWN IN CONJUNCTION WITH INADVERTANT SLIDE DEPLOYMENT. SQUIB REPLACED.SDR MALA040133Slide · dischargedDURING THE PREFLIGHT INSPECTION OF FLIGHT NR 3688, EVAC SLIDE PSI LOW IN NO GO RANGE NOTED BY FA. MAINTENANCE REPLACED EVAC SLIDE FOR DOOR 1R PN D31050-105 SN/OFF 0585 SN/ON 1184 IAW AMM 25-60.SDR SWAA040179Indicator · out of limitsR2 DOOR EVAC SLIDE PRESSURE IND OUT OF LIMITS. REMOVED AND REPLACED R2 DOOR EVAC SLIDE PER MM.SDR GTIA040014Slide · dislodgedORD - FLT 478 - L1 SLIDE PACK FELL OFF DOOR UPON OPENING IN ORD. REINSTALLED SLIDE PACK. (M)SDR GTIA040015Lanyard · misroutedFLL - FLT 980 - L1 AND L2 ESCAPE SLIDE GIRT BAR LANYARD ROUTED INCORRECTLY. REROUTED L1 AND L2 SLIDE GIRT BAR LANYARD. (M)SDR GTIA040013Lanyard · out of positionLGA - FOUND AFT TAILCONE SLIDE LEFT LANYARD NOT IN BRACKET. SECURED LANYARD IN BRACKET FOR TAILCONE SLIDE. OK FOR SERVICE. (M)SDR AWXA200400164Plate · corrodedLCQ - EES - DURING C-15 CHECK CORROSION WAS FOUND IN R-2 DOOR GIRT BAR FITTING ADAPTER PLATE BS 328, RBL 74. MAINTENANCE REMOVED AND REPLACED L-2 DOOR GIRT BAR FITTING ADAPTER PLATE IAW T/C C1D25006.SDR AWXA200400163Plate · corrodedLCQ - EES - DURING C-15 CHECK CORROSION WAS FOUND IN L-2 DOOR GIRT BAR FITTING ADAPTER PLATE BS 328, LBL 74. MAINTENANCE REMOVED AND REPLACED L-2 DOOR GIRT BAR FITTING ADAPTER PLATE IAW T/C C1D25006.SDR SWAA040180Slide · out of adjustR1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R1 DOOR EVAC SLIDE PER MM.SDR SWAA040174Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND R1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R1 DOOR EVAC SLIDE PER MM.SDR SWAA040170Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND L1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED L1 DOOR EVAC SLIDE PER MM.SDR C1HA200474002Slide · lowR-2 EVACUATION SLIDE READING BELOW LIMITS. REMOVED AND REPLACED R2 ESCAPE SLIDE PER CHAMPION AIR MM 25-60-15.SDR GTIA040087Slide · unsecureFTW - FOUND L1 DOOR SLIDE IS COMING UNPACKED. REPLACED L1 DOOR SLIDE. (M)SDR SWAA040166Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND R2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R2 DOOR EVAC SLIDE PER MM.SDR SWAA040163Bracket · crackedDURING SCHEDULED C1 CHECK, FOUND R2 DOOR EVAC SLIDE FWD MOUNT BRACKET CRACKED. REMOVED AND REPLACED BRACKET PER MM.SDR SWAA040161Cable · misroutedDURING SCHEDULED C2 CHECK, FOUND L2 DOOR EVAC SLIDE CABLE MIS-ROUTED. REROUTED L2 DOOR EVAC SLIDE CABLE PER MM.SDR SWAA040160Slide · dischargedR1 DOOR EVAC SLIDE PRESSURE IND LOW. REMOVED AND REPLACED R1 DOOR EVAC SLIDE PER MM.SDR GTIA040016Lanyard · detachedFLL - FLT 1443 - L1 SLIDE PACK NEEDS TO BE ATTACHED. REINSTALLED L1 SLIDE PACK LANYARD. (M)SDR SPAA0400068Pin · installedL-2 DOOR ESCAPE SLIDE DID NOT DEPLOY DURING CABIN CREW TRAINING EXERCISE. FOUND DISCHARGE BOTTLE SAFETY PIN INSTALLED. MAINTENANCE REMOVED SAFETY PIN, CREW TRAINING RESUMED, SLIDE DEPLOYED.SDR SWAA040145Slide · out of adjustR1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R1 DOOR EVAC SLIDE PER MM.SDR SWAA040142Cable · misroutedDURING SCHEDULED C3 CHECK, FOUND R2 DOOR EVAC SLIDE CABLE MISROUTED. REROUTED R2 DOOR EVAC SLIDE CABLE PER MM.SDR SWAA040141Slide · out of adjustR2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R2 DOOR EVAC SLIDE PER MM.SDR UPS04841716Slide · dislodgedESCAPE SLIDE FELL OUT OF PACK UPON CLOSING DOOR. STOWED FED SLIDE.SDR UPS04141717Switch · sticksCREW ENTRY DOOR SLIDE BUZZER SWITCH STICKS OCCASIONALLY WHEN PRESSED TO TEST. CLEANED CREW ENTRY DOOR SIDE WARNING BUZZER SWITCH WITH CONTACT CLEANER, TESTED A DOZEN, NO DEFECTS NOTED.SDR SWAA040131Slide · out of adjustR1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R1 DOOR EVAC SLIDE PER MM.SDR SWAA040127Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND L1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED L1 DOOR EVAC SLIDE PER MM.SDR SWAA040125Slide · out of adjustDURING SCHEDULED 1/4D CHECK, FOUND R2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R2 DOOR EVAC SLIDE PER MM.SDR AWXA200400052Sensor · faultyLCQ - EEL - DURING C-17 CHECK FOUND THE R-1 DOOR FORWARD & AFT GIRT BAR PROXIMITY SENSORS INOPERATIVE. MAINTENANCE REMOVED AND REPLACED BOTH FORWARD & AFT R-1 DOOR GIRT BAR PROXIMITY SENSORS IAW BMM 25-66-11, OPERATIONAL CHECK WAS GOOD.SDR SWAA040104Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND R1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R1 DOOR EVAC SLIDE PER MM.SDR SWAA040098Slide · out of adjustR2 DOOR EVAC SLIDES OUT OF ADJUST. ADJUSTED R2 DOOR EVAC SLIDES PER MM.SDR 2004UALA00027Battery · malfunctionedUPPER DECK RIGHT DOOR SLIDE BATTERY LIGHT PRESS TO TEST FUNCTION INOP. CHANGED BATTERIES.SDR SWAA040095Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND R2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R2 DOOR EVAC SLIDE PER MM.SDR SWAA040084Indicator · out of adjustCREW REPORTS R2 DOOR EVAC SLIDE GAUGE OUT OF ADJUST. ADJUSTED R2 DOOR EVAC SLIDE PER MM.SDR GTIA040008Clip · brokenDTW - FOUND GIRT BAR HOLD CLIP ON L2 DOOR BROKEN. REATTACHED GIRT BAR HOLD CLIP ON L2 DOOR. (M)SDR DL757040023Spring · wornON ARRIVAL F/A REPORTED R4 DOOR SLIDE DIFFICULT TO DISARM. FOUND GIRT BAR RETAINING SPRINGS WORN. REPLACED GIRT BAR PER MM, RII COMPLIED WITH.SDR AALA20040056Slide · failedTUL, DURING SCHEDULED HEAVY C-1 MAINTENANCE RT EMERGENCY ESCAPE SLIDE AT FORWARD GALLEY FAILED TEST TO DEPLOY AUTOMATICALLY WITHIN 10 SECONDS. MANUAL DEPLOY FUNCTION NORMAL. REMOVED RT FORWARD ESCAPE SLIDE FROM AIRCRAFT PER MM 25-66-01. SLIDE SENT TO SHOP SDR SWAA040080Slide · out of adjustDURING SCHEDULED PMC, FOUND R2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R2 DOOR EVAC SLIDE PER MM.SDR 2004UALA00020Slide · will not testLT OVERWING EXIT SLIDE DID NOT DEPLOY AUTOMATICALLY WHEN HATCH WAS REMOVED AND DID DEPLOY WHEN MANUAL OVERRIDE WAS ENGAGED. SLIDE BOTTLE ASSY INFLATION CABLE WAS FOUND KINKED INSIDE THE PULLEY OF THE WIRE CONTROL ASSY AND THE END OF CABLE WAS FOUND TWISTED. TSDR UPS04841700Slide · dislodgedEVACUATION SLIDE ON MAIN ENTRY DOOR FELL OUT OF THE CASE O/B CLIP. OK TO CONTINUE IN SERVICE IAW MEL 57-7-4.SDR SWAA040070Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND R2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R2 DOOR EVAC SLIDE PER MM.SDR SWAA040062Bottle · dischargedL2 DOOR EVACUATION SLIDE PRESS GAUGE IN THE RED. REMOVED AND REPLACED L2 DOOR EVAC SLIDE PER MM.SDR USAABB04004Attach Fitting · missingCLT - FOUND R4 DOOR SLIDE FORWARD GIRT BAR ATTACH FITTING MISSING. MAINTENANCE REPLACED THE GIRT BAR FITTING. (M)SDR WRLA200403Slide · failedDURING ROUTINE DEPLOYMENT CHECK OF L1 DOOR SLIDERAFT PER WORLD TASK CARD 101C-022, TIMCO W/O 107021, THE SLIDE RAFT DEPLOYED INWARD AS THE DOOR WAS APPROXIMATELY HALF OPEN. THE SLIDE DID NOT FALL OUT OF THE DOOR OPENING AS DURING NORMAL DEPLOYMENT. REMOVED ASDR UPS04M41786Slide · will not testINSPECTION TYPE:N/A R1 DOOR EVACUATION SLIDE PRESS TO TEST INOP DEFERRED M 273762 PER MEL 25-61-2 PLACARD. RELAMPED R1 DOOR SLIDE WARNING LIGHT MM 25-61-04. THIS CLEARS M 273762.SDR 04FDEA00048Slide · misinstalledUPON INCOMING INSPECTION FOUND ESCAPE SLIDE STILL HAD SAFETY STRAP FOR SHIPPING INSTALLED. REMOVED SAFETY STRAP PER FED EX M.M. 25-60-015-2
Back to JASC 2565