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 SWAA031775Indicator · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS INDICATOR OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA031781Slide · out of positionDURING SCHEDULED C2 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR GTIA030625Slide · looseSLIDE PACK ON R1 DOOR IS LOOSE. RESET SLIDE PACK AS REQUIRED ON R1 DOOR. (M)SDR USAASA03086Release Cable · incorrectBOS - THE AFT RIGHT EMERGENCY ESCAPE SLIDE WAS FOUND TO HAVE AN INCORRECT RELEASE CABLE INSTALLED DURING INSPECTION. MAINTENANCE REPLACED THE SLIDE ASSEMBLY. OK FOR SERVICE. (M)SDR SWAA031751Indicator · out of positionDURING SCHEDULED A1 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA031769Girt Bar · out of adjustDURING SCHEDULED C4 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR DLM88030723Lanyard · broken1R SLIDE LANYARD CABLE WORN THROUGH (BROKEN) AT GIRT BAR ATTACH POINT - REPLACED SAME.SDR SWAA031752Girt Bar · out of adjustDURING SCHEDULED C2 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA031749Slide · dislodgedFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA031747Indicator · out of limitsAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA031763Slide · dislodgedFWD ENTRY DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT OF CONTAINER WHEN OPENING THE DOOR. REINSTALLED SLIDE PER MM.SDR SWAA031740Slide · dislodgedDURING SCHEDULED RON, FWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER WHEN OPENING DOOR. REINSTALLED SLIDE PER MM.SDR ASAA0380549Lanyard · disconnectedPDX PREFLIGHT CHECK, AFT SERVICE (L-2) DOOR EMERGENCY SLIDE LANYARD WAS FOUND DISCONNECTED. RECONNECTED LANYARD. (M)SDR USAASA03106Release Cable · incorrectBOS - THE AFT SERVICE DOOR EMERGENCY ESCAPE SLIDE WAS FOUND TO HAVE AN INCORRECT RELEASE CABLE INSTALLED DURING INSPECTION. MAINTENANCE REPLACED THE SLIDE ASSEMBLY. OK FOR SERVICE. THE REPAIR SHOP INSTALLED THE PROPER RELEASE CABLE ON THE SLIDE AND RETURNEDSDR SWAA031819Slide · looseAFT SVC DOOR EMERGENCY EVAC SLIDE LOOSE IN CONTAINER. SECURED SLIDE PER MM.SDR AALA20031032Slide · failedSNA - FLT 1599 - FLIGHT ATTENDANT OPENED THE L2 DOOR WITHOUT DISARMING THE SLIDE. SLIDE SEPARATED FROM PACK. NO DEPLOYMENT OF INFLATION OF THE SLIDE. DOOR ASSIST BOTTLE WAS FOUND TO BE FLAT. REPLACED THE L2 DOOR SLIDE AND DOOR ASSIST BOTTLE. GROUND CHECKESDR SWAA031743Girt Bar · out of adjustDURING SCHEDULED C3 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA031742Girt Bar · out of adjustDURING SCHEDULED C3 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA031831Slide · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA031732Girt Bar · out of adjustDURING SCHEDULED C2 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA031729Cable · misroutedDURING SCHEDULED C1 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED CABLE PER MM.SDR AMTA200300986Slide · unsecureFLT 645 - ESCAPE SLIDE PACK IS HANGING LOOSE IN DOOR. RESECURED VELCRO STRIPS TO SLIDE BACKING PAN PER M/M 25-66-01, OK FOR SERVICE. (M)SDR SWAA031717Indicator · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE PRESS INDICATOR OUT OF VIEW. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA031716Indicator · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA031715Clip · looseFWD SVC DOOR EMERGENCY EVAC SLIDE GIRT BAR ATTACHMENT CLIPS LOOSE. SECURED ATTACHMENT CLIPS PER MM.SDR USAASA03084Slide · defectiveCLT - THE RIGHT SIDE AFT ENTRY DOOR SLIDE COVER WOULD NOT REMAIN INSTALLED. MAINTENANCE REPLACED THE RIGHT SIDE AFT ENTRY DOOR ESCAPE SLIDE, THEN INSTALLED COVER. OK FOR SERVICE. (M)SDR SWAA031718Slide · dislodgedDURING SCHEDULED RON, FWD ENTRY DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA031707Indicator · out of positionBOTH AFT CABIN DOOR EMERGENCY EVAC SLIDE PRESS INDICATORS OUT OF VIEW. REPOSITIONED SLIDES PER MM.SDR UPS03M41018Slide · deployedR1 DOOR SLIDE DEPLOYED. DEFERRED IAW MEL 52-10-3-2. DOOR IS INOPERATIVE, M263900 ASSIGNED. PLACARD INSTALLED.SDR AALA20030817Slide · failedUPON ARRIVAL R1 SLIDE FELL FROM COVER ASSEMBLY WHEN DOOR OPENED BY SKYCHEF CATERING. DOOR ASSIST BOTTLE DEPLETED. SLIDE DID NOT DEPLOY. REPLACED R1 SLIDE AND DOOR ASSIST BOTTLE. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR SWAA031696Slide · dislodgedAFT SVC DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT OF THE CONTAINER WHEN OPENING THE DOOR. REINSTALLED SLIDE PER MM.SDR SWAA031709Indicator · out of positionDURING SCHEDULED C4 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR DL76S030706Squib · failedEMERGENCY ESCAPE SQUIBS DO NOT TEST - REPLACED SQUIB BATTERY PACKSSDR SWAA031701Girt Bar · out of adjustDURING SCHEDULED C2 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA031692Slide · dislodgedAFT SVC DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT OF CONTAINER WHEN OPENING THE DOOR. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA031683Girt Bar · out of adjustAFT ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR ASAA0380544Lanyard · disconnectedPREFLIGHT CHECK, FORWARD PAX ENTRY L-1 DOOR EMERGENCY SLIDE LANYARD WAS FOUND DISCONNECTED. RECONNECTED LANYARD. (M)SDR SWAA031686Indicator · out of positionDURING SCHEDULED C1 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA031676Indicator · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR USAASA03083Cable · incorrectBOS - FOUND AN INCORRECT RELEASE CABLE ON THE FORWARD LEFT ESCAPE SLIDE DURING INSPECTION. MAINTENANCE REPLACED THE EMERGENCY ESCAPE SLIDE. OK FOR SERVICE. S/D - THE REPAIR SHOP INSTALLED THE PROPER RELEASE CABLE ON THE SLIDE AND RETURNED THE SLIDE TO SERVISDR USAASA03082Release Cable · incorrectCLT - THE FORWARD LEFT EMERGENCY ESCAPE SLIDE WAS FOUND TO HAVE AN INCORRECT CABLE INSTALLED DURING INSPECTION. MAINTENANCE REPLACED THE SLIDE ASSEMBLY. OK FOR SERVICE. THE REPAIR SHOP REPLACED THE RELEASE CABLE AND RETURNED TO SLIDE TO SERVICE. (M)SDR WX030011Cover · out of positionDURING A TURN IN LAS, CREW REPORTED THAT THE FORWARD SERVICE DOOR SLIDE PACK COVER CAME OFF. CONTRACT MAINTENANCE WAS CALLED OUT. THE SLIDE PACK COVER WAS RE-SECURED AND THE AIRCRAFT RETURNED TO SERVICE. (M)SDR SWAA031674Bracket · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE, BOTH FWD AND AFT GIRT BAR BRACKETS CORRODED. REMOVED AND REPLACED FWD AND AFT BRACKETS PER MM.SDR SWAA031672Indicator · out of limitsDURING SCHEDULED A1 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR ASAA0380542Lanyard · disconnectedPREFLIGHT CHECK, FORWARD SERVICE (R-1) DOOR EMERGENCY SLIDE LANYARD WAS FOUND DISCONNECTED. RECONNECTED LANYARD. (M)SDR GTIA030581Slide · disconnectedSLIDE PACK L1 DOOR OFF SLIDE PACK L2 DISCONNECTED. REMOVED AND RESECURED L1 AND L2 DOOR SLIDE PACKS. NO DEFECTS NOTED. (M)SDR SWAA031653Slide · out of positionDURING SCHEDULED SERVICE CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR SWAA031645Indicator · out of positionDURING SCHEDULED PM CHECK, FOUND BOTH AFT CABIN DOOR EMERGENCY EVAC SLIDES PRESS INDICATOR OUT OF VIEW. REPOSITIONED AFT CABIN DOOR SLIDES PER MMSDR SWAA031644Indicator · out of limitsFWD ENTRY DOOR EMERGENCY EVAC SLIDE PRESS INDICATOR OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR ASAA0380541Lanyard · disconnectedPREFLIGHT CHECK, FOUND FORWARD ENTRY L-1 DOOR EMERGENCY SLIDE LANYARD WAS FOUND DISCONNECTED. RECONNECTED LANYARD. (M)
Back to JASC 2565