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 SWAA010797Slide · out of adjFWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. RE-ADJUSTED EVAC SLIDE ASSY PER MM.SDR SWAA010795Slide · out of positionAFT ENTRY AND SVC DOOR EMERGENCY EVAC SLIDE PRESS INDICATORS OUT OF VIEW. REPOSITIONED EVAC SLIDE ASSY''S PER MM.SDR SWAA010794Slide · out of positionWHEN CLOSING AFT ENTRY DOOR, EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR UPS01835291Slide · looseINSPECTION TYPE:IN, ESCAPE SLIDE NEEDS REPACKING. RESECURED SLIDE TO DOOR.SDR SWAA010772Slide · out of toleranceFWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE ASSY PER MM.SDR SWAA010771Slide · out of positionDURING SCHEDULED RON CHECK, AFT ENTRY DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT OF CONTAINER. REINSTALLED EVAC SLIDE ASSY PER MM.SDR UPS01835287Slide · unsecureINSPECTION TYPE:PFLT, DOOR SLIDE NEEDS TO BE RESECURED. REINSTALLED SLIDE.SDR GTIA010069Slide · out of positionDTW - FLT 506 - L1 SLIDE PACK FELL OFF DOOR. REINSTALLED SLIDE PACK REF MD-80 MM 25-62-00. (M)SDR SWAA010753Slide · frayedDURING SCHEDULED 1/4D CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY FRAYED AT INBD EDGES. REMOVED AND REPLACED EVAC SLIDE ASSY PER MM.SDR UPS01835280Slide · out of positionINSPECTION TYPE:IN, ESCAPE SLIDE NEEDS TO BE PUT BACK IN SLIDE CASE. RE-SECURED ESCAPE SLIDE IN CASE.SDR GTIA010063Lanyard · detachedTPA - SLIDE PACK RELEASE LANYARD NOT ATTACHED. RE-ATTACHED RELEASE LANYARD THROUGH GIRT BAR MM 25-62-00. (M)SDR SWAA010738Slide · out of adjDURING SCHEDULED SERVICE CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. RE-ADJUSTED EVAC SLIDE ASSY PER MM.SDR SWAA010734Slide · out of adjAFT SVC DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. REMOVED AND REPLACED EVAC SLIDE ASSY PER MM.SDR SWAA010762Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR DL757010395Girt Bar · brokenL 4 DOOR GIRT BAR BROKEN AND GUST ASSIST BOTTLE ACTIVATED C/A REPLACED L 4 DOOR GIRT BAR AND DOOR ASSIST BOTTLE. REPLACED L4 DOOR SLIDE PRECAUTIONARY. (IT DID NOT DEPLOY,DUE TO MALFUNCTIONING GIRT BAR.) ORIGINAL PROBLEM WAS FLT ATT COULD NOT ARM L4 DOOR. SDR SWAA010731Slide · frayedDURING SCHEDULED 1/4D CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY FRAYED & STRAPS UNGLUED. REMOVED AND REPLACED EVAC SLIDE ASSY PER MM.SDR SWAA010728Slide · out of adjFWD SVC DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE ASSY PER MM.SDR ASAA0180101Lanyard · disconnectedSEA - DURING PRE-FLIGHT CHECK, R-1 DOOR EMERGENCY SLIDE LANYARD WAS FOUND TO BE PULLED OUT OF PLACE. REINSTALLED LANYARD PROPERLY. (M)SDR SWAA010719Slide · out of adjDURING SCHEDULED C4 CHECK, FOUND AFT SVC AND FWD ENTRY DOOR EMERGENCY EVAC SLIDES OUT OF ADJUST. RE-ADJUSTED EVAC SLIDE ASSY''S PER MM.SDR SWAA010715Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FALLING OUT OF CONTAINER. REINSTALLED EVAC SLIDE ASSY PER MM.SDR SWAA010729Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED EVAC SLIDE ASSY PER MM.SDR SWAA010700Slide · out of toleranceFWD ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE ASSY PER MM.SDR SWAA010714Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED EVAC SLIDE ASSY PER MM.SDR SWAA010683Slide · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE ASSY PER MM.SDR MWEA010280Cover · defectiveTAIL CONE SLIDE COVER DID NOT COME OFF PER WORK CARD FOR TAIL CONE DROP. REMOVED AND REPLACED TAIL CONE SLIDE COVER AND TAIL CONE SLIDE.SDR AU010210Slide · failed(AUS) NR 1 RT MAIN ENTRY DOOR ESCAPE SLIDE FAILED TO FULLY DEPLOY. INVESTIGATION FOUND THAT THE SLIDE EXHAUST VALVE WAS STUCK OPEN AND THE VALVE ELEMENT HAD BROKEN AWAY FROM THE VALVE BODY.SDR SWAA010692Slide · out of positionDURING SCHEDULED C4 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE ASSY PER MM.SDR SWAA010677Slide · out of adjDURING SCHEDULED C2 CHECK, FOUND AFT ENTRY AND SVC DOOR EMERGENCY EVAC SLIDE ASSY''S OUT OF ADJUST. RE-ADJUSTED EVAC SLIDE ASSY''S PER MM.SDR SWAA010658Indicator · out of positionDURING SCHEDULED C3 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE ASSY PER MM.SDR SWAA010656Indicator · out of positionDURING SCHEDULED SERVICE CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE ASSY PER MM.SDR SWAA010646Bracket · out of adjAFT ENTRY DOOR EMERGENCY EVAC SLIDE ASSY WOULD NOT ARM. ADJUSTED GIRT BRACKET ASSY PER MM.SDR SWAA010652Slide · looseAFT SVC DOOR EMERGENCY EVAC SLIDE ASSY LOOSE. SECURED SLIDE ASSY PER MM.SDR SWAA010599Indicator · out of toleranceDURING SCHEDULED SERVICE CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE ASSY PER MM.SDR ASAA0180090Latch · unlatchedBUR - DURING PRE-FLIGHT CHECK, R1 DOOR EMERGENCY SLIDE PACK COVER LATCH WAS FOUND UNLATCHED. RE-LATCHED SLIDE PACK COVER. (M)SDR ASAA0180089Girt Bar · inoperativeLAX - DURING PRE-FLIGHT CHECK. L-2 DOOR EMERGENCY SLIDE GIRT BAR WAS FOUND TO BE IMPROPERLY INSTALLED. RE-INSTALLED GIRT BAR PROPERLY. (M)SDR SWAA010589Slide · out of adjDURING SCHEDULED C3 CHECK, FOUND FWD ENTRY AND SVC DOOR EMERGENCY EVAC SLIDE ASSY''S OUT OF ADJUST. RE-ADJUSTED EVAC SLIDE ASSY''S PER MM.SDR 2001UALA00152Slide · cutDOOR 4 L/R SLIDE-RAFT (P/N 62774-413) HAS TWO CUTS IN THE INFLATABLE FOUND BY SHOP MECHANIC DURING UNPACKING FOR SHOP OVERHAUL VISIT. UNIT WAS LAST OVERHAULED BY THE VENDOR. UNIT WAS SENT TO VENDOR FOR WARRANTY REPAIR.SDR SWAA010577Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT OF CONTAINER. REINSTALLED EVAC SLIDE ASSY PER MM.SDR SWAA010573Slide · out of positionAFT ENTRY EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT OF CONTAINER. REINSTALLED EVAC SLIDE ASSY PER MM.SDR SWAA010572Slide · out of adjDURING SCHEDULED C2 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. RE-ADJUSTED EVAC SLIDE ASSY PER MM.SDR GTIA010044Slide · looseORD - FLT 781 - SLIDE PACK DOOR IS LOOSE. RE-INSTALLED SLIDE PACK ON L1 DOOR IAW MM 25-02-00. OPS CHECK OK. (M)SDR AALA016020Slide · looseFOUND FORWARD ENTRY DOOR SLIDE PACK LOOSE IN DOOR. PACK LOCATED ON JETBRIDGE. RE-INSTALLED FORWARD ENTRY DOOR SLIDE. (M)SDR SWAA010559Slide · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT OF CONTAINER. REINSTALLED EVAC SLIDE ASSY PER MM.SDR UPS01835062Bottle · dischargedINSPECTION TYPE:IN, CABIN DOOR EMERGENCY SLIDE BOTTLE PRESS LOW. REMOVED AND REPLACED CABIN DOOR EMERGENCY SLIDE AS PER MM 25-60-00.SDR SWAA010556Slide · out of adjDURING SCHEDULED C1 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. RE-ADJUSTED EVAC SLIDE ASSY PER MM.SDR SWAA010555Slide · out of adjDURING SCHEDULED C1 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. RE-ADJUSTED EVAC SLIDE ASSY PER MM.SDR SWAA010544Slide · out of adjFWD SVC DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. RE-ADJUSTED EVAC SLIDE ASSY PER MM.SDR ASAA0180082Lanyard · disconnectedLAX - DURING PRE-FLIGHT CHECK, R1 DOOR EMERGENCY SLIDE LANYARD WAS FOUND TO BE DETACHED. REATTACHED LANYARD BETWEEN GIRT BAR AND SLIDE COVER. (M)SDR SWAA010539Slide · out of adjDURING SCHEDULED C2 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. RE-ADJUSTED EVAC SLIDE ASSY PER MM.SDR UPS01835030Bracket · brokenINSPECTION TYPE:IN EVAC SLIDE BRACKET BROKEN (REFER TO M209762). REMOVED AND REPLACED BROKEN BRACKET ON SLIDE COVER. REINSTALLED SLIDE CHECKS OK. THIS CLEARS M209762.
Back to JASC 2565