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 SWAA021440Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF THE CONTAINER WHILE OPENING THE DOOR. REINSTALLED SLIDE PER MM.SDR GTIA020732Slide · dislodgedFLL - FLT 1751A - FOUND ESCAPE SLIDE AT L2 DOOR CAME LOOSE. REINSTALLED ESCAPE SLIDE AT L2 DOOR IAW MD80 MM 25-62-00. (M)SDR SWAA021441Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND BOTH AFT CABIN DOOR EMERGENCY EVAC SLIDE GIRT ASSY'S OUT OF ADJUST. ADJUSTED SLIDE'S PER MM.SDR SWAA021448Slide · out of positionFWD SERVICE DOOR EMERGENCY EVAC SLIDE FELL OUT OF THE CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA021433Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF THE CONTAINER IN JETWAY. REINSTALLED SLIDE PER MM.SDR SWAA021418Slide · out of positionDURING SCHEDULED PM CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR 2002FA0000813Slide · twistedDURING AN EMERGENCY EVACUATION DEMONSTRATION REQUIRED BY FAR PART-125, THE RT FORWARD EMERGENCY ESCAPE SLIDE INFLATED IN A TWISTED CONDITION WHICH POSITIONED THE SLIDE IN A VERTICAL POSITION RENDERING IT UNUSABLE. A PHONE CALL TO THE MANUFACTURER REVEALED THSDR AT0200066Slide · out of positionSLIDE PACK FELL OFF DOOR L1. REINSTALLED SLIDE PACK IAW MM 25-62.SDR GTIA020725Slide · dislodgedFLL - FLT 258 - SLIDE PACK SEPARATED FROM HOUSING. INSTALLED SLIDE PACK IAW MD80 MM 25-62-00. NO DEFECTS NOTED AT THIS TIME. (M)SDR SWAA021405Slide · out of positionFWD SERVICE DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA021400Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUSTED. ADJUSTED SLIDE PER MM.SDR SWAA021397Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT OF THE CONTAINER. REINSTALLED SLIDE PER MM.SDR AT0200067Slide · out of positionR1 DOOR SLIDE PACK FELL OUT OF POSITION. REINSTALLED R1 SLIDE.SDR SWAA021377Slide · out of adjustAFT ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR GTIA020687Slide · out of positionDTW - FOUND L2 DOOR SLIDE PACK FELL OFF DOOR AND GOT DAMAGED. REMOVED AND REPLACED L2 DOOR SLIDE PACK IAW MD80 MM 25-62-00. (M)SDR SWAA021379Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR USA2002F00057Slide · intermittentTHE FORWARD CABIN, RIGHT SIDE, EMERGENCY ESCAPE SLIDE WAS DIFFICULT TO ARM AND INTERMITTENTLY INDICATED DISARMED. MAINTENANCE REPLACED THE EMERGENCY ESCAPE SLIDE. OPERATIONAL CHECKED OK.SDR SWAA021380Slide · out of positionDURING SCHEDULED C4 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA021370Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA021368Slide · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF THE CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA021367Slide · out of positionDURING SCHEDULED C4 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA021366Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND BOTH CABIN SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY'S OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA021365Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND ALL 4 CABIN DOOR EMERGENCY EVAC SLIDE GIRT ASSY'S OUT OF ADJUST. ADJUSTED SLIDES PER MM.SDR SWAA021369Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR AALA20020922Slide · dislodgedIND - FLT 2076 - FIRST CLASS GALLEY DOOR SLIDE FELL OUT AND DID NOT DEPLOY SUCCESSFULLY. AIRCRAFT HAS BEEN INSPECTED AND FOUND TO BE IN SAFE CONDITION FOR FERRY FLIGHT FROM IND TO DFW FOR REPAIRS. REPLACED FIRST CLASS GALLEY DOOR SLIDE. SYSTEM GROUND CHECKESDR SWAA021354Cable · misroutedDURING SCHEDULED C1 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED CABLE PER MM.SDR SWAA021347Slide · out of positionDURING SCHEDULED RON, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA021346Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF THE CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA021345Slide · crackedDURING SCHEDULED SERVICE CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND COVER CRACKED. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA021342Slide · looseFWD ENTRY DOOR EMERGENCY EVAC SLIDE LOOSE IN CONTAINER. SECURED SLIDE PER MM.SDR AWXA200200526Slide · deployedMEX - EMERGENCY EQUIPMENT - UPON ARRIVAL TO THE AIRCRAFT, PILOT REPORTED LT AFT DOOR SLIDE INFLATED AND STILL ATTACHED TO THE AIRCRAFT. MAINTENANCE ULTIMATLEY REMOVED AND REPLACED SLIDE.SDR SWAA021329Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR AWXA200200530Proximity Switch · wornLAX - EMERGENCY EQUIPMENT - DURING INSPECTION THE R-1 DOOR SLIDE GIRT BAR ENGAGEMENT LIGHT WAS FOUND INOPERATIVE.MAINTENANCE REMOVED AND REPLACED GIRT BAR PROXIMITY SWITCHES PER MM 25-66-11. OPERATIONAL CHECK WAS NORMAL.SDR SWAA021320Slide · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA021319Slide · looseAFT SVC DOOR EMERGENCY EVAC SLIDE LOOSE IN CONTAINER. SECURED SLIDE PER MM.SDR SWAA021321Slide · unserviceableAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA021313Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA021315Slide · looseDURING SCHEDULED RON, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE LOOSE IN CONTAINER. SECURED SLIDE PER MM.SDR SWAA021314Slide · looseSVC DOOR EMERGENCY EVAC SLIDE LOOSE IN CONTAINER. SECURED SLIDE PER MM.SDR GTIA020664Slide · out of positionLAX - AFT GALLEY DOOR OPENED BY CLEANERS, SLIDE PACK FELL OFF. RESTOWED AFT GALLEY DOOR SLIDE PACK. OPS CHECK IAW MM 25-00-00. (M)SDR SWAA021308Slide · deployedDURING SCHEDULED RON, FWD SVC DOOR EMERGENCY EVAC SLIDE INADVERTENTLY DEPLOYED. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA021307Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT BAR NOT ALIGNED WITH RETAINER BRACKETS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA021306Slide · out of adjustFWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA021303Slide · out of positionDURING SCHEDULED C4 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR MEX2002187Slide · out of adjustFLT 170 - MEX-TIJ - CAPTAIN REPORTED THAT THE DOOR NR 1 SLIDE WAS NOT ARMED. DURING CHECK WAS DETECTED THAT THE ARMED LIGHT WAS INOPERATIVE AND THE ACTIVATION MECHANISM WAS IN AN ABNORMAL POSITION. TECHNICAL PERSONNEL TRIED TO REMOVED THE DOOR COVER AND THE SDR SWAA021305Slide · looseFWD ENTRY DOOR EMERGENCY EVAC SLIDE LOOSE IN CONTAINER. SECURED SLIDE PER MM.SDR SWAA021304Slide · out of positionDURING SCHEDULED C4 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA021300Bracket · looseDURING SCHEDULED C1 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT BAR AFT HOOK FASTENER LOOSE. INSTALLED FASTENER PER MM.SDR SWAA021291Slide · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR ASAA0280202Lanyard · detachedSEA - DURING PREFLIGHT CHECK, R1 DOOR EMERGENCY SLIDE LANYARD WAS FOUND TO BE DETACHED. ATTACHED LANYARD. (M)
Back to JASC 2565