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 DL764030384Bulb · burned outDOOR 4R SLIDE ARM LIGHT INOPERATIVE. RELAMPED SAMESDR SWAA030918Indicator · out of positionDURING SCHEDULED C4 CHECK, FOUND BOTH AFT CABIN DOOR EMERGENCY EVAC SLIDES PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDES PER MM.SDR USAASA03035Fitting · damagedTHE OPERATIONAL TEST OF THE FORWARD GIRT BAR FITTING ON THE L1 DOOR DURING SCHEDULED MAINTENANCE WAS FOUND UNSATISFACTORY. MAINTENANCE REMOVED THE GIRT BAR FITTING, CLEANED ALL OF THE COMPONENTS, AND THEN INSTALLED THE GIRT BAR FITTING BACK INTO ITS ORIGINAL SDR GTIA030274Slide · dislodgedPBI - FLT 330 - LEFT SIDE PACK FELL OFF. REINSTALLED SLIDE/COVER. (M)SDR USAASA03033Slide · defectiveDURING TROUBLESHOOTING FOR AN 'EPSU EXT LOAD FWD L' FAULT MESSAGE, FOUND THE FORWARD RIGHT EMERGENCY ESCAPE SLIDE ALSO DEFECTIVE FOR HIGH RESISTANCE OF THE SLIDE LIGHTS. MAINTENANCE REPLACED THE R1 SLIDE. OK FOR SERVICE. (M)SDR SWAA030920Indicator · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA030898Indicator · out of positionDURING SCHEDULED C4 CHECK, FOUND AFT SERVICE DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA030894Indicator · out of positionAFT SERVICE DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA030882Girt Bar · out of adjustDURING SCHEDULED C4 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA030880Slide · dislodgedFWD ENTRY DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT OF CONTAINER WHEN OPENING THE DOOR. REINSTALLED SLIDE PER MM.SDR SWAA030879Girt Bar · out of adjustAFT ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA030891Girt Bar · out of adjustDURING SCHEDULED C4 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA030871Slide · dislodgedFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA030867Lens · looseAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND COVER LENS LOOSE. SECURED COVER LENS PER MM.SDR USAASA03032Slide · malfunctionedTPA - FAULT MESSAGE, 'EPSU EXT LOAD FWD L', RESULTED DURING THE EMERGENCY LIGHTS TEST. MAINTENANCE REPLACED THE FORWARD LEFT EMERGENCY ESCAPE SLIDE DUE OT SLIDE LIGHT FAILURE. ALSO, REPLACED THE FORWARD RIGHT SLIDE DUE TO HIGH SLIDE LIGHT HARNESS RESISTANCE.SDR SWAA030866Slide · dislodgedFWD ENTRY DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR UPS03840429Slide · deterioratedINSPECTION TYPE: PFLT, CREW ENTRY DOOR ESCAPE SLIDE COMING APART. RE-ATTACHED CREW ENTRY ESCAPE SLIDE COVER & SECURED TO DOOR.SDR AWXA200300386Reservoir · dischargedPHX - EES - FLT 0046 - L-2 DOOR EMERGENCY SLIDE PULLED FROM BONNET WITH GIRT STILL ATTACHED, ASSIST BOTTLE DISCHARGED AND SLIDE HANDLE FOUND ENGAGED. MAINTENANCE REINSTALLED L-2 DOOR SLIDE IAW BMM 25-66-01-404. REMOVED AND REPLACED DOOR ASSIST BOTTLE IAW BMMSDR WRLA200308Bottle · dischargedPRIOR TO SLIDE RAFT DEPLOYMENT EGAT ADVISED THAT THE BOTTLE PRESSURE OF THE SLIDE RAFT INDICATED ZERO. THE PRESS TO TEST SYSTEM INDICATED NORMAL. THE SLIDE RAFT WAS DEPLOYED TO VERIFY PROPER DEPLOYMENT. THE SLIDE DEPLOYED BUT FAILED TO INFLATE. THE PRESS TSDR MEX2003137Arm · jammedCAPTAIN REPORTED THAT WAS NOT POSSIBLE TO ARM THE EMERGENCY SLIDE OF DOOR NR 4 IT WAS JAMMED. AIRCRAFT WAS SENT TO THE HANGAR WHERE WAS TESTED AND ADJUSTED THE MECHANISM WAS ADJUSTED IAW MM 52-11-20, ALL CORRECT. (M)SDR SWAA030839Indicator · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA030829Slide · looseFWD SERVICE DOOR EMERGENCY EVAC SLIDE LOOSE IN CONTAINER. SECURED SLIDE PER MM.SDR SWAA030814Girt Bar · out of adjustDURING SCHEDULED C1 CHECK, FOUND AFT SERVICE DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA030812Slide · out of positionDURING SCHEDULED C1 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR ASAA0380318Lanyard · disconnectedSEA PREFLIGHT CHECK, FOUND LEFT AFT SERVICE (L-2) DOOR EMERGENCY SLIDE LANYARD WAS FOUND DISCONNECTED. RECONNECTED LANYARD. (M)SDR WX030003Cover · debondedDURING A ROUTINE TURN IN SLC, FLT ATTEND OPENED AFT SERVICE DOOR & OBSERVED SLIDE TO BE UNSECURE. EMERGENCY MX CALLED OUT. FOUND SLIDE & COVER TO BE LOOSE. SLIDE & COVER WERE RESECURED & A/C RETURNED TO SERVICE. ON FOLLOWING TURN IN RNO, SERVICE DOOR WAS ASDR SWAA030825Cable · misroutedDURING SCHEDULED C2 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED CABLE PER MM.SDR USAABA03013Slide · malfunctionedDURING A RE-CHECK OF THE RIGHT MID DOOR SLIDE INFLATION TEST, THE SLIDE DID NOT INFLATE WHEN THE LANYARD WAS ACTUATED. WHEN THE SLIDE WAS REMOVED FROM THE AIRCRAFT AND MAINTENANCE ATTEMPTED TO DEPRESSURIZE THE INFLATION BOTTLE, THE BOTTLE FIRED AND THE SLIDE SDR SWAA030821Girt Bar · out of adjustDURING SCHEDULED C3 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA030820Fitting · looseDURING SCHEDULED C2 CHECK, FOUND FWD SERVICE DOOR EMERGENCY EVAC SLIDE GIRT BAR ATTACH FITTING FASTENERS LOOSE. SECURED ATTACH FITTING PER MM.SDR SWAA030816Indicator · out of positionAFT SERVICE DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA030803Gauge · out of positionFWD SERVICE DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA030808Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND BOTH FWD CABIN DOOR EMERGENCY EVAC SLIDE ASSY'S OUT OF ADJUST. ADJUSTED SLIDES PER MM.SDR SWAA030805Gauge · out of positionDURING SCHEDULED C2 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA030804Slide · looseFWD SERVICE DOOR EMERGENCY EVAC SLIDE LOOSE IN CONTAINER. REINSTALLED SLIDE PER MM.SDR ASAA0380303Lanyard · disconnectedSEA PREFLIGHT CHECK, FOUND FORWARD RIGHT SERVICE (R1) DOOR EMERGENCY SLIDE LANYARD WAS FOUND DISCONNECTED. RECONNECTED LANYARD. (M)SDR ASAA0380304Lanyard · disconnectedLAX - PREFLIGHT CHECK, FOUND FORWARD LEFT PASSENGER L1 DOOR EMERGENCY SLIDE LANYARD WAS FOUND DISCONNECTED. RECONNECTED LANYARD. (M)SDR DHL2003364007Slide · malfunctionedSTARBOARD SIDE SLIDE WILL NOT ARM. REMOVED DEBRIS FROM AFT SLIDE ENGAGEMENT SLOT. OPS CHECKED OK PER 52-10-11.SDR GTIA030248Slide · dislodgedFLL - FLT 765 - L1 SLIDE PACK FELL OFF. RE-INSTALLED L1 SLIDE PACK. (M)SDR SWAA030765Girt Bar · out of adjustDURING SCHEDULED C2 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA030747Slide · damagedFWD ENTRY DOOR EMERGENCY EVAC SLIDE PRESS INDICATOR OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA030772Girt Bar · out of adjustDURING SCHEDULED C3 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA030768Indicator · out of positionFWD SERVICE DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA030760Slide · dislodgedFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA030773Cable · misroutedDURING SCHEDULED C2 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED CABLE PER MM.SDR SWAA030761Slide · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR AALA20030399Bottle · malfunctionedDURING OVERNIGHT MAINTENANCE, EMERGENCY EXIT FORWARD ENTRY SLIDE DID NOT INFLATE. REPLACED EMERGENCY EXIT SLIDE DOOR ASSIST BOTTLE AND REINSTALLED SLIDE. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR GTIA030243Slide · dislodgedEMERGENCY SLIDE PACK FELL OFF. REINSTALLED LANYARD SLIDE CHECK OK. (M)SDR DL76G030323Battery · dischargedWHILE PERFORMING AN ETOPS PRE-DEPARTURE CHECK THE EMERGENCY ESCAPE LEFT OVERWING SLIDE SQUIB FAILED. REPLACED BATTERY CHECKS GOOD.SDR 0300691236Reservoir · dischargedDURING SLIDE SHOP TEST FOUND RESERVOIR COMPLETELY DEFLATED. FIRING LANYARD WAS INTACT. CAUSE OF CYLINDER DEFLATION COULD NOT BE DUPLICATED. INSTALLED OVERHAULED CYLINDER AND RETURNED SLIDE TO SERVICE.
Back to JASC 2565