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 SWAA032446Cable · misroutedDURING SCHEDULED C2 CHECK, FOUND L2 DOOR EVACUATION SLIDE RELEASE CABLE MISROUTED. REROUTED CABLE PER MM.SDR ASAA0380703Lanyard · disconnectedSEA PREFLIGHT CHECK, FOUND FORWARD SERVICE R1 DOOR EMERGENCY SLIDE LANYARD WAS FOUND DISCONNECTED. CABLE TO SLIDE FORWARD GALLEY ENTRANCE IS BROKE. RECONNECTED LANYARD, REINSTALLED TOGGLE R-1 DORO SLIDE. (M)SDR P9R2003F00001Slide · dislodgedL1 DOOR SLIDE-RAFT OUT OF CASING. INSTALLED L1 SLIDE-RAFT IAW BMM 52-11. HARNESS ASSEMBLY PN 416N25035.(K)SDR SWAA032434Slide · out of adjustL2 DOOR EVACUATION SLIDE OUT OF ADJUST. READJUSTED SLIDE ASSY PER MM.SDR SWAA032429Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND R1 DOOR EVACUATION SLIDE OUT OF ADJUST. REPOSITIONED SLIDE PER MM.SDR AWXA200301464Cable · brokenPHX - EES - DURING P-09 CHECK THE CABLE END WAS FOUND BROKEN ON THE RT OVERWING SLIDE BOTTLE. MAINTENANCE REMOVED AND REPLACED RT OVERWING SLIDE RESERVOIR ASSEMBLY IAW AMM 25-62-46.SDR AWXA200301463Cable · brokenPHX - EES - DURING P-09 CHECK THE CABLE END WAS FOUND BROKEN ON THE LT OVER WING SLIDE BOTTLE. MAINTENANCE REMOVED AND REPLACED LT OVERWING SLIDE RESERVOIR ASSEMBLY IAW AMM 25-62-46.SDR AWXA200301344Slide · faultyPHX - EEL - DURING INSPECTION EMERGENCY LIGHT TEST FAILED STEP 7 OF T/C R1A25301. MAINTENANCE REMOVED AND REPLACED L-1 DOOR SLIDE IAW T/C R1C25304, OPERATIONAL CHECK WAS GOOD.SDR GTIA030877Girt Bar · out of adjustLGA - R1 DOOR GIRT BAR HOLDER WILL NOT HOLD GIRT BAR. ADJUSTED GIRT BAR HOLDER, OPS CHECK NORMAL. (M)SDR ASAA0380701Lanyard · disconnectedPDX PREFLIGHT CHECK, FOUND FORWARD PAX L1 DOOR EMERGENCY SLIDE LANYARD WAS FOUND DISCONNECTED. RECONNECTED LANYARD. (M)SDR GTIA030878Clip · brokenDTW - FLT 461 - R1 DOOR SLIDE COVER RIGHT GIRT BAR CLIP BROKEN. REMOVED BROKEN CLIP. INSTALLED NEW CLIP ASSY. (M)SDR SWAA032421Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND R1 DOOR EVACUATION SLIDE OUT OF ADJUSTMENT. REINSTALLED SLIDE PER MM.SDR SWAA032415Slide · looseR2 DOOR EVACUATION SLIDE LOOSE. REINSTALLED SLIDE ASSY PER MM.SDR GTIA030869Cable · detachedFOUND R1 DOOR COVER RELEASE CABLE NOT ATTACHED TO GIRT BAR. ATTACHED CABLE TO GIRT BAR. (M)SDR YENA200332Bottle · dischargedL2 SLIDE RAFT BOTTLE PRESSURE LOW FOUND DURING WEEKLY CHECK. REMOVED AND REPLACED L2 SLIDE RAFT IAW 25-62-44.SDR 757BJ0001Spring · failedR1, R2, AND L4 GIRT BAR LEAF SPRINGS FAILED INSPECTION PER BOECOM M-7200-03-00917 AND PACE AIRLINES MO NR B757-52-21003. REPLACED LEAF SPRINGS PER MM 25-66-14.SDR GTIA030868Girt Bar · detachedORD - FOUND L1 GIRT BAR DEATTACHED. RESECURED L-1 GIRT BAR, OPS CHECK NORMAL. (M)SDR SWAA032367Indicator · out of positionR1 DOOR EVACUATION SLIDE PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA032365Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND L1 DOOR EVACUATION SLIDE OUT OF ADJUST. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA032362Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND BOTH L1 AND R1 DOOR EVACUATION SLIDES OUT OF ADJUST. REPOSITIONED SLIDE ASSY'S PER MM.SDR 2004UALA00725O-Ring · leakingLOW BOTTLE PRESSURE. BOTTLE TO VALVE O-RING DETERIORATED. REPLACED CYLINDER ASSY.SDR SWAA032358Slide · looseDURING SCHEDULED C3 CHECK, FOUND BOTH R1 AND L2 DOOR EVACUATION SLIDES OUT OF ADJUST. REINSTALLED SLIDES PER MM.SDR SWAA032351Slide · out of adjustDURING SCHEDULED PM CHECK, FOUND L2 DOOR EVACUATION SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA032342Slide · dislodgedR2 DOOR EVACUATION SLIDE FALLING OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR 751PA0024Spring · failedL1, R1, AND L4 DOOR GIRT BAR LEAF SPRINGS FAILED INSPECTION IAW MM-7200-03-00917 AND PACE MO NR B757-52-21003. REPLACED LEAF SPRINGS IAW MM 25-66-14.SDR GTIA030864Slide · dislodgedDTW - FOUND L1 DOOR SLIDE PACK FELL OFF. INSTALLED L1 DOOR EVACUATION SLIDE. NO DISCERPANCIES NOTED. (M)SDR SWAA032347Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND R1 DOOR EVACUATION SLIDE OUT OF ADJUST. REINSTALLED SLIDE ASSY PER MM.SDR SWAA032344Indicator · out of limitsDURING SCHEDULED PM CHECK, FOUND L2 DOOR EVACUATION SLIDE PRESS IND OUT OF VIEW. REPOSTIONED SLIDE ASSY PER MM.SDR SWAA032338Slide · looseDURING SCHEDULED C4 CHECK, FOUND R2 DOOR EVACUATION SLIDE OUT OF ADJUST. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA032334Slide · looseL2 DOOR EVACUATION SLIDE PRESS INDICATOR OUT OF POSITION. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA032350Cable · misroutedDURING SCHEDULED C4 CHECK, FOUND L2 DOOR EVACUATION SLIDE RELEASE CABLE MISROUTED. REROUTED CABLE PER MM.SDR ASAA0380687Lanyard · disconnectedPREFLIGHT CHECK, FOUND FORWARD SERVICE R1 DOOR EMERGENCY SLIDE LANYARD WAS FOUND DISCONNECTED. RECONNECTED LANYARD. (M)SDR USAABA03037Slide · malfunctionedDURING THE ANNUAL SLIDE DEPLOYMENT CHECK, THE R2 DOOR SLIDE DID NOT DEPLOY AUTOMATICALLY. THE SLIDE DID FUNCTION NORMALLY WHEN DEPLOYED MANUALLY. NO DEFINITIVE REASON FOR THE AUTOMATIC FAILURE WAS FOUND. SUBSEQUENT SLIDE DEPLOYMENTS WERE FREE OF THIS DISCRESDR SWAA032318Slide · lowL1 DOOR EVACUATION SLIDE PRESS IND LOW. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA032317Slide · looseL1 DOOR EVACUATION SLIDE OUT OF ADJUST. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA032309Slide · out of positionDURING SCHEDULED C1 CHECK, FOUND L2 DOOR EVACUATION SLIDE OUT OF POSITION AND RELEASE CABLE MISROUTED. REPOSITIONED SLIDE ASSY AND REROUTED CABLE PER MM.SDR SWAA032306Slide · out of positionR1 DOOR EVACUATION SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR AALA20031162Girt Bar · out of rigMAINTENANCE OBSERVED DURING THE ACCOMPLISHMENT OF B-CHECK CARD 2403, THE L2 DOOR SLIDE S/N A-4018 AND R2 DOOR SLIDE S/N A-5725 GIRT BARS BEING IN THE SHIPPING POSITION, RATHER THAN BEING ATTACHED TO THE GIRT BAR CARRIER. THE L2 AND R2 SLIDE WERE CORRECTED PERSDR DL777031107Slide · unsecureUPON OPENING L2 DOOR, SLIDE CAME UNLATCHED. DID NOT DEPLOY. REINSTALLED SAME.SDR SWAA032294Slide · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR ASAA0380686Lanyard · disconnectedPREFLIGHT CHECK, FOUND FORWARD SERVICE R-1 DOOR EMERGENCY SLIDE LANYARD WAS FOUND DISCONNECTED. RECONNECTED LANYARD. (M)SDR SWAA032299Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT OF CONTAINER WHEN OPENING THE DOOR. REINSTALLED SLIDE PER MM.SDR SWAA032293Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA032285Slide · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR CA52003F00000Hose · crushedTHE ESCAPE SLIDE WAS RECEIVED. THE INFLATION HOSE HAD BEEN BROKEN, AND THE RELIEF VALVE HAD CUT THROUGH THE FABRIC. THIS DAMAGE WAS CAUSED BY EXCESSIVE FORCE DURING PACKING. THE ESCAPE SLIDE WOULD NOT HAVE OPERATED. IT IS NOT KNOW WHO CARRIED OUT THE PREVSDR SWAA032268Slide · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA032265Slide · unserviceableDURING SCHEDULED RON, FOUND L1 DOOR EVACUATION SLIDE PRESS IND LOW. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA032259Slide · out of positionR1 DOOR EVACUATION SLIDE OUT OF ADJUST. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA032258Slide · out of positionDURING SCHEDULED RON, FOUND R1 DOOR EVACUATION SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA032269Slide · out of positionDURING SCHEDULED 1/4D CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.
Back to JASC 2565