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 SWAA000274Slide · looseDURING SCHEDULED C3 CHECK, FOUND AFT ENTRY DOOR EVACUATION SLIDE GIRT ASSY OUT OF POSITION. REINSTALLED SLIDE ASSY PER MM.SDR SWAA000273Cable · misroutedDURING SCHEDULED C3 CHECK, FOUND FWD ENTRY DOOR EVACUATION SLIDE CABLE MISROUTED. REROUTED CABLE PER MM.SDR MWEA00071Slide · dislodgedGALLEY SERVICE DOOR EMERGENCY EVACUATION SLIDE COVER CAME LOOSE AT THE BOTTOM. MAINTENANCE REINSTALLED SLIDE COVER.SDR SWAA000255Slide · dislodgedFWD SERVICE DOOR EVACUATION SLIDE COMING OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR 0000395530Slide · dislodgedWHEN DOOR 1R WAS OPENED BY CATERING FOR GALLEY SERVICE, THE ESCAPE SLIDE FELL OUT. SLIDE DID NOT INFLATE. MAINTENANCE REPLACED THE DOOR EMERGENCY POWER RESERVOIR AND THE ESCAPE SLIDE.. OPERATIONAL CHECK OK.SDR SWAA000268Cover · looseDURING SCHEDULED 1/4D CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE GIRT BAR COVER ATTACH BRACKETS LOOSE. TIGHTENED ATTACH BRACKETS PER MM.SDR SWAA000267Cover · looseDURING SCHEDULED 1/4D CHECK, FOUND FWD ENTRY AND AFT SERVICE DOOR EVACUATION SLIDE PRESS IND VIEWING WINDOWS LOOSE. REMOVED AND REPLACED WINDOWS PER MM.SDR CA000222019Regulator · failed(CAN) SLIDE/RAFT HAD A 10 SECOND HUNG TIME ON TEST. CMM INDICATES 6 SEC MAX TIME DELAY. REGULATER REPAIRED AS PER CMM.SDR SWAA000263Bracket · looseDURING SCHEDULED C4 CHECK, FOUND FWD ENTRY DOOR EVACUATION SLIDE GIRT BAR STOWAGE BRACKET LOOSE. REMOVED AND REPLACED BRACKET FASTENER PER MM.SDR SWAA000260Slide · dislodgedFWD ENTRY DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR ASAA0080102Slide · will not testPHX - DURING 15K CHECK, THE L2 DOOR EMERGENCY EVACUATION SLIDE FAILED THE EMERGENCY LIGHT AMP TEST. REPLACED THE L2 DOOR EMERGENCY EVACUATION SLIDE ASSEMBLY. (M)SDR SWAA000254Indicator · dislodgedAFT SERVICE DOOR EVACUATION SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA000239Slide · dischargedDURING SCHEDULED 1/4D CHECK, FOUND FWD ENTRY DOOR EVACUATION SLIDE PRESS IND LOW. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR USAAD00026Slide · dischargedPIT - THE PASSENGER ENTRY DOOR EVACUATION SLIDE PRESSURE WAS BELOW LIMITS. MAINTENANCE REPLACED THE PASSENGER ENTRY DOOR EVACUATION SLIDE. (M)SDR UPS00831537Clip · brokenINSPECTION TYPE:N/A, MAIN CABIN ESCAPE SLIDE INOP, MOUNTING BRACKET BOTTOM CLIP BROKEN. REMOVED AND REPLACED CLIP AND INSTALLED ESCAPE SLIDE.SDR MWEA00040Slide · dislodgedAFT GALLEY DOOR SLIDE FELL OUT AFTER DISARMING. MAINTENANCE RE-INSTALLED SLIDE COVER.SDR TSAA200025046Slide · deployedFORWARD SERVICE DOOR EMERGENCY SLIDE CHUTE INADVERTENTLY DEPLOYED UPON INSTALLATION OF SHELL. REPLACED EMERGENCY SLIDE CHUTE. (M)SDR AT0000086Lanyard · disengagedFOUND ON TAXI OUT, R1 DOOR SLIDE LANYARD FELL OUT. STRAIGHTENED ARM AND ATTACHED PACK, REATTACHED PIN IAW DC9 MM 25-62-00.SDR SWAA000220Slide · looseFWD SERVICE DOOR EVACUATION SLIDE COMING OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR SWAA000208Indicator · dislodgedAFT SERVICE DOOR EVACUATION SLIDE PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA000210Indicator · dislodgedFWD SERVICE DOOR EVACUATION SLIDE PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA000209Slide · dislodgedFWD ENTRY DOOR EVACUATION SLIDE GIRT ASSY OUT OF POSITION. REINSTALLED SLIDE ASSY PER MM.SDR MWEA00038Slide · dislodgedGALLEY SERVICE DOOR EMERGENCY EVACUATION SLIDE FELL OFF. MAINTENANCE REINSTALLED SLIDE PACK.SDR SWAA000203Slide · dischargedDURING SCHEDULED RON, FOUND AFT SERVICE DOOR EVACUATION SLIDE PRESS IND LOW. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA000201Slide · dislodgedFWD SERVICE DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA000196Indicator · dislodgedDURING SCHEDULED SERVICE CHECK, FOUND AFT ENTRY DOOR EVACUATION SLIDE PRESS IND OUT OF VIEW. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA000194Slide · dislodgedFWD ENTRY DOOR EVACUATION SLIDE CAME OUT OF POSITION. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR GTIA000063Strap · missingDTW - AFT TAIL SLIDE HAS NO MANUAL DEPLOY STRAP.. OPENED TAIL SLIDE, FOUND MANUAL DEPLOY STRAP INSIDE, REROUTED STRAP IAW DC9 MM 25-61-01. (M)SDR SWAA000175Slide · dislodgedFWD SERVICE DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR AU000055Container · misinstalled(AUS) ESCAPE SLIDE INFLATION BOTTLE BAG INCORRECTLY INSTALLED. A FOREIGN OBJECT HAD PIERCED THE SLIDE RENDERING IT INOPERABLE IN THE EVENT OF AN EMERGENCY.SDR ASAA0080093Light · inoperativePHX - DURING 30K CHECK, THE L1 DOOR EMERGENCY EVACUATION SLIDE FAILED THE EMERGENCY LIGHT AMP TEST. REPLACED THE L1 DOOR EMERGENCY EVACUATION SLIDE ASSEMBLY. (M)SDR SWAA000187Slide · dischargedDURING SCHEDULED RON, FOUND AFT ENTRY DOOR EVACUATION SLIDE PRESSURE IND LOW. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR ASAA0080051Light · inoperativeOAK - DURING C-CHECK, THE L1 DOOR EMERGENCY EVACUATION SLIDE LIGHT WAS FOUND INOPERATIVE. REPLACED THE L1 DOOR EMERGENCY EVACUATION SLIDE ASSEMBLY. (M)SDR SWAA000168Slide · dischargedDURING SCHEDULED A2 CHECK, FOUND AFT ENTRY DOOR EVACUATION SLIDE PRESSURE IND LOW. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA000162Slide · dislodgedDURING SCHEDULED C4 CHECK, FOUND AFT ENTRY DOOR EVACUATION SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR USAASA00004Slide · will not testCLT - THE CREW INADVERTENTLY ACTIVATED THE FORWARD ENTRY DOOR SLIDE ON ARRIVAL AT THE GATE. THE SLIDE FAILED TO DEPLOY. MAINTENANCE REPLACED AND RIGGED THE SLIDE ASSEMBLY. (M)SDR SWAA000157Indicator · looseDURING SCHEDULED C3 CHECK, FOUND FWD ENTRY DOOR EVACUATION SLIDE PRESS IND VIEWING WINDOW LOOSE. SECURED VIEWING WINDOW PER MM.SDR MWEA00030Slide · dislodgedGALLEY SERVICE DOOR EMERGENCY EVACUATION SLIDE CAME LOOSE. MAINTENANCE REINSTALLED EVACUATION SLIDE.SDR MWEA00026Slide · dislodgedMAIN CABIN DOOR EMERGENCY EVACUATION SLIDE FELL OUT OF COVER. MAINTENANCE REINSTALLED SLIDE PACK INTO COVER.SDR SWAA000134Girt Bar · damagedFWD SERVICE DOOR EVACUATION SLIDE GIRT BAR DIFFICULT TO STOW IN CONTAINER. ADJUSTED GIRTBAR SLIDE BRACKET PER MM.SDR 2000UALA00049Slide · leakingDURING SHOP OVERHAUL PROOF PRESSURE TEST EVACUATION SLIDE MR 25699-447 FAILED TO HOLD AIR. THE LEAK WAS AT THE JOINT BETWEEN THE ASPIRATOR TUBE AND THE SLIDE MAIN TUBE. SENT SLIDE ASSEMBLY TO VENDOR FOR WARRANTY REPAIR.SDR SWAA000126Slide · dislodgedFWD SERVICE DOOR EVACUATION SLIDE COMING OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR MWEA00022Cover · dislodgedFORWARD GALLEY DOOR SLIDE COVER CAME OFF. MTC REINSTALLED GALLEY DOOR SLIDE COVER.SDR MWEA00021Slide · dislodgedGALLEY DOOR EMERGENCY EVACUATION SLIDE PACK CAME OUT OF COVER. MAINTENANCE REINSTALLED SLIDE PACK.SDR AU000127Slide · out of rig(AUS) RH NO3 DOOR ESCAPE SLIDE FAILED TO INFLATE. INFLATION BOTTLE CONTAINED THE CORRECT PRESSURE. INVESTIGATION FOUND THAT THE FAILURE WAS DUE TO THE SLOW OPERATION OF THE DOOR AND THE SLACK IN THE EPS CABLE DUE TO INCORRECT RIGGING.SDR SWAA000112Slide · dislodgedFWD ENTRY DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR MWEA00019Slide · dislodgedAFT GALLEY SERVICE DOOR SLIDE PACK NEEDS TO BE RESECURED. MAINTENANCE RE-INSTALLED SLIDE ASSEMBLY.SDR SWAA000104Indicator · obscuredDURING SCHEDULED C3 CHECK, FOUND FWD SERVICE DOOR EVACUATION SLIDE PRESS IND LENS OBSCURED. REMOVED AND REPLACED LENS ASSY PER MM.SDR SWAA000103Slide · dislodgedFWD ENTRY DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR 00FDEA00020Girt · frayingNR 89 - FWD ENTRY DOOR ESCAPE SLIDE GIRT IS FRAYING. REMOVED AND REPLACED FWD ENTRY DOOR ESCAPE SLIDE IAW FEDEX MM 25-60-015-2.
Back to JASC 2565