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 2004UALA00422Squib · failedRT OFF WING SLIDE SQUIB TEST NR 1 FAILS. REPLACED RIGHT OFF WING SLIDE BATTERY CHARGER AND BATTERY PACK. LATER REPLACEMENT OF RELAY P/N XD4L015 SUGGESTS THAT INTERMITTENT RELAY PROBLEM MAY HAVE CONTRIBUTED TO THIS EVENT AS WELL.SDR 2004UALA00720Bottle · dischargedZERO BOTTLE PRESSURE. PRESSURE RELEASE VALVE ON GAUGE INOP. PRESSURE GAUGE WAS REPLACED WHICH INCLUDED REPLACEMENT OF PRESSURE RELIEF VALVE.SDR SWAA041208Slide · out of adjustR2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R2 DOOR EVAC SLIDE PER MM.SDR P5CA0401079Slide · deployedUPPER DECK CREW RH DOOR ESCAPE SLIDE DEPLOYED. SLIDE REMOVED AND DEFERRED PER MEL 25-11-3.SDR USAASA04039Slide · inoperativeCLT - THE MAIN CABIN ENTRY DOOR WOULD NOT ARM. THE SLIDE ARMED LIGHT WOULD FLASH ON AND OFF ON ECAM DOOR DISPLAY. ALSO, THE HANDLE WAS SPONGY. MAINTENANCE REPLACED THE MAIN CABIN ENTRY DOOR SLIDE/RAFT. OK FOR SERVICE. (M)SDR SWAA041205Slide · out of adjustDURING SCHEDULED HC2 CHECK, FOUND L1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED L1 DOOR EVAC SLIDE PER MM.SDR SWAA041204Cable · misroutedDURING SCHEDULED C3 CHECK, FOUND L2 DOOR EVAC SLIDE CABLE MISROUTED. REROUTED SLIDE CABLE PER MM.SDR SWAA041207Slide · out of adjustR2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R2 DOOR EVAC SLIDE PER MM.SDR SWAA041188Slide · out of positionL1 DOOR EVAC SLIDE FELL OUT OF CONTAINER. REMOVED AND REPLACED L1 DOOR EVAC SLIDE PER MM.SDR SWAA041192Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND L2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED L2 DOOR EVAC SLIDE PER MM.SDR GTIA040338Slide · dislodgedFLL - FLT 433 - FOUND SLIDE PACK FELL OUT OF R1 DOOR INTO CABIN. SECURED SLIDE AT R1 DOOR. (M)SDR AMTA200400481Warning Light · illuminatedGIRT BAR ENGAGEMENT LIGHT ILLUMINATED WITH EVACUATION SLIDE ARMING LEVER IN DISARM POS AT ENTRY DOOR 2R. (M)SDR AALA20040488Slide · failedPHL - WHEN GROUND CREW WAS PREPARING TO TOW AIRCRAFT TO THE GATE THE RIGHT 1 GALLEY DOOR WAS OPENED BY GROUND CREW FROM THE INSIDE AND THE SLIDE FELL OUT. SLIDE DEPLOYED BY ONLY PARTIALLY INFLATING. FERRIED AIRCRAFT TO DFW FOR SLIDE REPLACEMENT. REPLACED R1SDR SWAA041150Slide · dislodgedR1 DOOR EVAC SLIDE FELL OUT OF CONTAINER, DID NOT DEPLOY. INSTALLED R1 DOOR EVAC SLIDE PER MM.SDR SWAA041143Slide · out of adjustR1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R1 DOOR EVAC SLIDE PER MM.SDR 2004UALA00722Disk · rupturedLOW BOTTLE PRESSURE. LEAK DETECTED AT THE RUPTURED DISK AT RELIEF HOLES. REPLACED DISK. OSV, WINSLOW, HAS ADDED ULTRASONIC LEAK DETECTION TO BOTTLE INSPECTION PROCESS.SDR SWAA041136Slide · out of adjustDURING SCHEDULED A1 CHECK, FOUND R2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R2 DOOR EVAC SLIDE PER MM.SDR 2004UALA00726O-Ring · leakingLOW BOTTLE PRESSURE. SLOW LEAK DETECTED IN VALVE SHAFT THROUGH THE PLATE AND COVER HOUSING. VALVE WAS OVERHAULED AND NEW O-RINGS AND BACKUP RINGS REPLACED.SDR SWAA041120Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND L2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED L2 DOOR EVAC SLIDE PER MM.SDR SWAA041119Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND L2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED L2 DOOR EVAC SLIDE PER MM.SDR SWAA041117Slide · out of adjustR2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R2 DOOR EVAC SLIDE PER MM.SDR USAABB04038Slide · out of adjustCLT - THE R4 DOOR EVACUATION SLIDE WILL NOT ARM. MAINTENANCE READJUSTED THE SLIDE AND LUBED THE GIRT BAR. (M)SDR SWAA041108Hook · looseDURING SCHEDULED 1/4D CHECK, FOUND L1 DOOR EVAC SLIDE GIRT BAR HOOKS LOOSE. SECURED L1 DOOR EVAC SLIDE GIRT BAR HOOKS PER MM.SDR SWAA041105Slide · out of adjustR1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R1 DOOR EVAC SLIDE PER MM.SDR GTIA040328Slide · dislodgedFLL - FLT 433 - L2 DOOR SLIDE FELL OFF. INSTALLED SLIDE ASSEMBLY. (M)SDR SWAA041099Slide · out of adjustL1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED L1 DOOR EVAC SLIDE PER MM.SDR 2004UALA00371Connector · looseLT OVERWING SLIDE SQUIB TEST FAILED. PROBLEM CAUSED BY LOOSE CONNECTORS. PROBLEM CLEARED BY RE-SEATING CONNECTORS ON BACK OF FLIGHT DECK PANEL.SDR UPS04M42210Switch · inoperativeINSPECTION TYPE:N/A R-1 DOOR ESCAPE SLIDE BATTERY PACK LT PUSH TO TEST SWITCH LT INOP. RELAMPED, NO HELP (BAD SWITCH). FOUND IND LAMP HOUSING BASE BROKEN FROM HOUSING. REPLACED DOOR SLIDE IND IN REF TO MD11 WDM 25-61-01. LIGHT TESTS NORMAL.SDR GTIA040330Retainer · brokenFLL - FOUND LEFT AFT SLIDE PACK COVER GIRT BAR RETAINING CLIP BROKEN. REMOVED AND REPLACED LEFT AFT SLIDEPACK COVER GIRT BAR RETAINING CLIP. OPS CHECK GOOOD. (M)SDR SWAA041092Slide · out of adjustR2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R2 DOOR EVAC SLIDE PER MM.SDR P9RA20040011Slide · deployedAIRCRAFT OVERNIGHT IN JFK. MAINTENANCE DISCOVERED R4 SLIDE DEPLOYED. EXACT CAUSE NOT KNOWN. SUSPECT OVERNIGHT CLEANING/CATERING CREW. REMOVED AND REPLACED SLIDE.SDR SWAA041084Girt Bar · looseDURING SCHEDULED 1/4D CHECK, FOUND R1 DOOR EVAC SLIDE GIRT BAR FWD FITTING RIVET, LOOSE. REMOVED AND REPLACED R1 DOOR EVAC SLIDE GIRT BAR FWD FITTING RIVET PER MM.SDR SWAA041082Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND R2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R2 DOOR EVAC SLIDE PER MM.SDR SWAA041081Slide · dislodgedL1 DOOR EVAC SLIDE FELL OUT OF CONTAINER, DID NOT DEPLOY. REINSTALLED L1 DOOR EVAC SLIDE PER MM.SDR SWAA041079Slide · out of adjustR1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R1 DOOR EVAC SLIDE PER MM.SDR 2005FA0000322Frangible Link · incorrectRECEIVED EVACUATION SLIDE FOR RECERTIFICATION. DURING DISASSY EACH FRANGIBLE LINKS (PN C19347-101, 4EA, PN C19347-102, 1EA, PN C19347-105, 2EA) WERE FOUND WITH (4) STRANDS OF BLACK NYLON THREAD SECURING EACH HALF OF FRANGIBLE LINK TOGETHER. FRANGIBLE LINKS WSDR 2005FA0000321Link · incorrectRECEIVED EVACUATION SLIDE FOR RECERTIFICATION. DURING DISASSY EACH FRANGIBLE LINKS (PN C19347-101, 4EA, PN C19347-102, 1EA, PN C19347-105, 2EA) WERE FOUND WITH (4) STRANDS OF BLACK NYLON THREAD SECURING EACH HALF OF FRANGIBLE LINK TOGETHER. FRANGIBLE LINKS WSDR 2005FA0000320Frangible Link · incorrectRECEIVED EVACUATION SLIDE FOR RECERTIFICATION. DURING DISASSY EACH FRANGIBLE LINKS (PN C19347-101, 4EA, PN C19347-102, 1EA, PN C19347-105, 2EA) WERE FOUND WITH (4) STRANDS OF BLACK NYLON THREAD SECURING EACH HALF OF FRANGIBLE LINK TOGETHER. FRANGIBLE LINKS WSDR 2005FA0000319Link · incorrectRECEIVED EVACUATION SLIDE FOR RECERTIFICATION. DURING DISASSY EACH FRANGIBLE LINKS (PN C19347-101, 4EA, PN C19347-102, 1EA, PN C19347-105, 2EA) WERE FOUND WITH (4) STRANDS OF BLACK NYLON THREAD SECURING EACH HALF OF FRANGIBLE LINK TOGETHER. FRANGIBLE LINKS WSDR 2005FA0000318Link · brokenRECEIVED EVACUATION SLIDE FOR RECERTIFICATION. DURING DISASSY, EACH FRANGIBLE LINK (PN C19347-101, 4EA, PN C19347-102, 1EA, PN C19347-105, 2EA), WERE FOUND WITH (4) STRANDS OF BLACK NYLON THREAD SECURING EACH HALF OF FRANGIBLE LINK TOGETHER. FRANGIBLE LINKS SDR 2005FA0000317Frangible Link · incorrectRECEIVED EVACUATION SLIDE FOR RECERTIFICATION. DURING DISASSY EACH FRANGIBLE LINKS (PNC19347-101, 4EA, PN C19347-102,1EA, PN C19347-105,2EA) WERE FOUND WITH (4) STRANDS OF BLACK NYLON THREAD SECURING EACH HALF OF FRANGIBLE LINK TOGETHER. FRANGIBLE LINKS WERESDR GTIA040329Bracket · looseDTW - FOUND GIRT BAR BRACKET ON FLOOR, DOOR L2 IS LOOSE. INSTALLED PROPER LENGTH SCREWS. (M)SDR GTIA040327Hinge · looseDTW - FLT 844 - FOUND L2 DOOR SLIDE PACK GIRT BAR HANDLE HINGES ARE LOOSE AND DO NOT HOLD GIRT BAR. FOUND GIRT BAR RETAINING BRACKET ON SLIDE COVER TO NEED ADJUSTING. ADJUSTED RETAINING BRACKET. NO FURTHER DEFECTS NOTED. (M)SDR GTIA040326Cable · dislodgedFOUND DOOR 1R EMERGENCY EXIT SLIDE HAS CABLES PROTRUDING FROM COVER. REPLACED SLIDE ASSEMBLY, DOOR 1R. (M)SDR USAASA04036Bottle · inoperativeFAILURE MESSAGE 'SLIDE BOTTLE MID R'. MAINTENANCE REPLACED THE MID RIGHT DOOR SLIDE INFLATION RESERVOIR. THE SHOP FOUND SOME LEAKING AT THE O-RING AT THE SLIDE BOTTLE NECK. REPLACED THE O-RING. (M)SDR USAASA04035Lanyard · damagedBFM - THE SLIDE GIRT BAR LANYARD CABLE BALLS DISENGAGED UPON INSTALLATION OF ESCAPE SLIDE ONTO AIRCRAFT. MAINTENANCE REPLACED THE EMERGENCY ESCAPE SLIDE. OK FOR SERVICE. (M)SDR SWAA041076Cable · looseDURING SCHEDULED C2 CHECK, FOUND R2 DOOR EVAC SLIDE GIRT BAR CABLE LOOSE. SECURED R2 DOOR EVAC SLIDE CABLE PER MM.SDR SWAA041075Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND L1 AND R1 DOOR EVAC SLIDES OUT OF ADJUST. ADJUSTED L1 AND R1 DOOR EVAC SLIDES PER MM.SDR SWAA041057Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND BOTH L2 AND R2 DOOR EVAC SLIDES OUT OF ADJUST. ADJUSTED BOTH L2 AND R2 DOOR EVAC SLIDES PER MM.SDR 2004UALA00361Slide · deployedAFT LEFT DOOR SLIDE PARTIALLY DEPLOYED WHEN DOOR OPENED FROM OUTSIDE. OPENING DOOR FROM OUTSIDE DID NOT INITIATE DEPLOYMENT. WHEN DOOR WAS OPENED, ONE SIDE OF SLIDE DROPPED BELOW DOOR DUE TO A LOOSE RESTRAINT STRAP. SAME SLIDE WAS REINSTALLED.
Back to JASC 2565