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 USAAD98015Slide · slow to operateBOS - AFT ESCAPE SLIDE REQUIRED 15 SECONDS TO DEPLOY DURING TEST. MAINTENANCE REPLACED THE SLIDE ASSY. (M)SDR 9801149902Slide · low pressureDURING LINE MAINTENANCE INSPECTION, FOUND MAIN CABIN DOOR EVACUATION SLIDE LOW ON PRESSURE. REPLACED SLIDE.SDR 9801129923Slide · low pressureDURING LINE MAINTENANCE INSPECTION, FOUND GALLEY DOOR EVACUATION SLIDE BOTTLE LOW ON PRESSURE. REPLACED SLIDE.SDR ASAA9880012Bottle · low pressurePDX - DURING MAINTENANCE CHECK, THE R1 DOOR EMERGENCY EVACUATION SLIDE INFLATION BOTTLE PRESSURE WAS FOUND LOW. REPLACED THE R1 DOOR EMERGENCY EVACUATION SLIDE ASSEMBLY. (M)SDR 9801009914Slide · low pressureDURING LINE MAINTENANCE INSPECTION, FOUND AFT TAIL CONE EVACUATION SLIDE BOTTLE PRESSURE LOW. REPLACED SLIDE, OPERATIONAL CHECK NORMAL.SDR QXEA9800025Slide · low pressureEMERGENCY ESCAPE SLIDE PRESSURE BELOW MINIMUM. REPLACED EMERGENCY ESCAPE SLIDE.SDR 9800929954Slide · low pressureDURING LINE MAINTENANCE INSPECTION, FOUND TAIL CONE EVACUATION SLIDE LOW ON PRESSURE. REPLACED SLIDE.SDR SWAA980036Slide · deployedAT GATE, FWD SERVICE DOOR SLIDE ACCIDENTALLY DEPLOYED. REMOVED AND REPLACED SLIDE ASSEMBLY PER BOEING M/M.SDR VJ9800005Slide · low pressureGALLEY DOOR EMERGENCY SLIDE PRESSURE INDICATES LOW. REPLACED R1 DOOR SLIDE IAW MM 25-60 AND PERFORMED REQUIRED INSPECTIONS.SDR CALA9800006Slide · low pressureINSPECTION FOUND THE R-1 DOOR SLIDE PRESSURE LOW. THE R-1 DOOR SLIDE WAS REMOVED AND REPLACED.SDR SWAA980007Slide · low pressDURING SCHEDULED A1, FOUND AFT ENTRY EMERGENCY SLIDE PRESSURE BELOW SERVICEABLE LIMIT. REPLACED PER BOEING M/M.SDR 6500239965Slide Battery · dischargedDURING PERIODIC CHECK, MAIN CABIN DOOR EVACUATION SLIDE BATTERY PACK FAILED TEST. REPLACED SLIDE, OPERATIONAL CHECK OK.SDR SWAA980004Slide · deployedAT GATE, FWD ENTRY DOOR ESCAPE SLIDE ACCIDENTALLY DEPLOYED. REPLACED SLIDE ASSEMBLY PER BOEING M/M.SDR AU980070Reservoir · mismanufactured(AUS) UPPER DECK ESCAPE SLIDE UPPER TUBE INFLATION BOTTLE INCORRECTLY INSTALLED RESULTING IN FLATTENED DISCHARGE LINES. FOUND DURING WORKSHOP INSPECTION FOLLOWING REMOVAL FROM AIRCRAFT.SDR UF6A980103Slide · failed testSBN - AFT PASSENGER DOOR EVACUATION SLIDE BATTERY FAILED FUNCTIONAL TEST. MAINTENANCE REMOVED AND REPLACED EVACUATION SLIDE. SYSTEM OPS CHECKED GOOD. (M)SDR 9800193232Slide · defectiveDURING INSPECTION OF PASSENGER DOOR EVACUATION SLIDE PACK RELEASE CABLE, FOUND DEFECTIVE CABLES ON SLIDES AT FORWARD RIGHT, AFT RIGHT, AND LEFT DOORS. REPLACED CABLES ON SLIDES AT AFT DOORS AND REPLACED SLIDE ASSEMBLY AT FORWARD DOOR.SDR UF6A971228Escape Slide · failedSBN - UNSATISFACTORY FUNCTIONAL TEST OF THE ESCAPE SLIDE BATTERY PACK. MAINTENANCE REMOVED AND REPLACED THE FORWARD PASSENGER DOOR ESCAPE SLIDE. (M)SDR SWAA971067Slide · low pressureDURING WALKAROUND CHECK, FOUND FWD ENTRY DOOR SLIDE PRESS LOW. REPLACED PER BOEING M/M.SDR USAASB97352Slide · deployedPHL - FORWARD SERVICE DOOR ESCAPE SLIDE DEPLOYED WHILE CLOSING THE DOOR AT THE GATE. MAINTENANCE REMOVED AND REPLACED THE FORWARD SERVICE DOOR ESCAPE SLIDE (PN D31591-475) AND INSPECTED THE CONTAINER/SLIDE OVER FOR FIT AND WEAR. NO MECHANICAL DISCREPANCIES NSDR SWAA971065Slide · low pressureDURING WALKAROUND CHECK, FOUND FWD ENTRY DOOR SLIDE PRESS LOW. REPLACED PER BOEING M/M.SDR 98ZZZX686Slide · failedDURING FLIGHT CREW TRAINING, THE EMERGENCY EVACUATION SLIDE MOUNTED TO THE R-2 DOOR FAILED TO INFLATE. THE EVACUATION SLIDE ASSY HAS BEEN SENT TO THE LAST OVERHAUL/REPAIR AGENCY FOR EVALUATION. ON 12-26-97, THE EMERGENCY EVACUATION SLIDE FAILED TO INFLATE DUSDR 97UAL900893Slide · malfunctionedDOOR 2L SLIDE DID NOT DEPLOY.SDR 9724399961Battery · dischargedDURING PERIODIC CHECK, FOUND MAIN CABIN EVACUATION SLIDE BATTERY PACK LOW. REPLACED SLIDE.SDR 9724249918Slide · low pressureDURING LINE MAINTENANCE INSPECTION, FOUND RIGHT FORWRD CABIN DOOR EVACUATION SLIDE LOW ON PRESSURE. REPLACED SLIDE.SDR AALA972485Slide · low pressureORD - DURING OVERNIGHT CHECK, FORWARD ENTRY EMERGENCY EVACUATION SLIDE BOTTLE PRESSURE LOW. REPLACED FORWARD GALLEY EMERGENCY EVACUATION SLIDE. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR 98ZZZM163Escape Slide · misinstalledDURING PREFLIGHT, FOUND R1 SLIDE COVER GIRT BAR BRACKET LOOSE, UPON INSPECTION AND REPAIR FOUND ESCAPE SLIDE IMPROPERLY PACKED UNABLE TO RECLOSE COVER. REPAIRED COVER AND REPLACED ESCAPE SLIDE IAW M 25-81-00 SRM 51-40-8.SDR 97UAL900881Valve · frozenDURING THE SHOP OVERHAUL OF AN EVACUATION SLIDE REMOVED FOR EXPIRATION OF TIME, THE UNIT FAILED TO FLAT FIRE. MECHANIC PULLED THE FIRING LINE WITH A FORCE OF 20 LBS AND THE BOTTLE VALVE DID NOT OPEN. THE BOTTLE VALVE MANUFACTURER (CARLTON) HAS THE VALVE, (P/SDR 97UAL900876O-Ring · erodedEVACUATION SLIDE AT DOOR 1L SELF DEPLOYED WITHIN A STORED AIRPLANE. O-RING (P/N 1A2313-3) IN THE BOTTLE VALVE FAILED DUE TO EROSION.SDR AALA972376Slide · defectiveSFO - AT GATE, RIGHT HAND OVERWING SLIDE WAS INADVERTENTLY DEPLOYED AND DEPLOYMENT WAS SUCCESSFUL. REPLACED RIGHT HAND OVERWING SLIDE. SYSTEM GROUND CHECKED, NORMAL OPERATION. (X)SDR W8PA971521Cable · misroutedCHECK AFT LEFT DOOR EMERGENCY SLIDE RELEASE CABLE FOR PROPER ROUTING. CABLE IMPROPERLY ROUTED DURING AIRCRAFT MANUFACTURE. REROUTED CABLE PER MAINT MANUAL CHAPTER 25-61-35.SDR AALA962302Slide · defectiveLAS - AT GATE, FLIGHT ATTENDANT FAILED TO DISARM L1 DOOR AND SLIDE FELL OUT OF PACK, BUT DID NOT SUCCESSFULLY DEPLOY. REPLACED L1 SLIDE. SYSTEM GROUND CHECKED, NORMAL OPERATION. (X)SDR 97UAL900867Valve · defectiveDURING ROUTINE SHOP MAINTENANCE, EVACUATION SLIDE FAILED TO INFLATE. UPON PARTIAL DISASSEMBLY OF THE BOTTLE VALVE BODY THE COUPLING PIN (P/N 10003-0005-293) WAS FOUND TO BE BADLY BENT AND SHAFT (P/N B18116-1) WAS SPREAD. THE BOTTLE VALVE WAS REPLACED.SDR CA971223010Slide · deployed(CAN) ACCIDENTAL ACTUATION OF DOOR NR 1L WITH SLIDE ENGAGED RESULTED IN SLIDE UNRAVELLING AND DOOR ASSIST SYSTEM ACTUATED. THE ARMING LEVER SAFETY PIN WAS INSERTED WITHOUT MOVING LEVER TO THE DISARM POSITION.SDR AALA972294Slide · defectiveIAD - AT GATE, L2 SLIDE FELL OUT BUT DID NOT SUCCESSFULLY DEPLOY. REPLACED L2 SLIDE. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR SWAA971033Slide · fell outDURING WALKAROUND INSPECTION, FWD SERVICE DOOR ESCAPE SLIDE FELL FROM ITS HOLDER. REPLACED SLIDE ASSEMBLY PER BOEING M/M.SDR 97UAL900842Slide · disassembledAT DEPARTURE TIME FOUND APPROXIMATELY 15 FEET OF GREEN CORD HANGING OUT OF DOOR 4R. SLIDE REPLACED. *S/D* CAUSE UNKNOWN. REPLACED DOOR SLIDE.SDR DLM88972487Slide · failedAFT GALLEY DOOR SLIDE DID NOT DEPLOY WHEN DOOR WAS OPENED ACCIDENTLY SLIDE WAS ARMED. REPLACED DOOR SLIDE.SDR 98ZZZX934Slide · deployedDURING PRE-FLIGHT, R-1 DOOR ESCAPE SLIDE DEPLOYED AND INFLATED. INSIDE COVER OF DOOR FELL OFF. R-1 DOOR ESCAPE SLIDE REMOVED AND REPLACEDSDR 9722509619Slide · low pressureDURING LINE MAINTENANCE INSPECTION, FOUND TAIL CONE EVACUATION SLIDE LOW ON PRESSURE. REPLACED SLIDE.SDR 9722499931Slide · low pressureDURING LINE MAINTENANCE INSPECTION, FOUND TAIL CONE EVACUATION SLIDE LOW ON PRESSURE. REPLACED SLIDE, CHECKED OK.SDR 97UAL900846Regulator · corrodedDURING SHOP OVERHAUL OF SLIDE REMOVED FOR EXPIRATION OF TIME THE REGULATOR VALVE AREA AND PISTON WAS FOUND TO BE BADLY CORRODED. REPLACED REGULATOR.SDR 97UAL900845Regulator · corrodedDURING SHOP OVERHAUL OF SLIDE REMOVED FOR EXPIRATION OF TIME THE REGULATOR BODY AREA, SPRING AND PISTON WERE FOUND TO BE CORRODED. REPLACED REGULATOR.SDR 97UAL900844Regulator · corrodedDURING SHOP OVERHAUL OF SLIDE REMOVED FOR EXPIRATION OF TIME THE REGULATOR BODY AREA WAS FOUND TO BE BADLY CORRODED. *S/D* REPLACED REGULATOR.SDR 97UAL900827Slide · will not testLEFT OVERWING SLIDE SYSTEM WILL NOT TEST IN EITHER SYSTEM 1 OR 2. *S/D* ACCOMPLISHED CHECK PER MEL 25 360. GROUND CHECK GOOD. SYSTEM RETURNED TO NORMAL. REPLACED RELAYS K1, K5.SDR SWAA971012Slide · low pressDURING SERVICE CHECK, FOUND FWD SERVICE DOOR SLIDE PRESSURE LOW. REPLACED PER BOEING M/M.SDR ASAA9710114Bottle · press lowANC - DURING MAINTENANCE CHECK, THE R2 DOOR EVACUATION SLIDE PRESSURE WAS FOUND TO BE LOW. MAINTENANCE REPLACED THE R2 DOOR EVACUATION SLIDE AND GAUGE INDICATED NORMAL. (M)SDR SWAA971011Slide · deployedWHILE DEPLANING, AFT ENTRY DOOR SLIDE DEPLOYED. REPLACED PER BOEING M/M.SDR SWAA970981Slide · low pressDURING TERMINAL CHECK, FOUND AFT ENTRY DOOR SLIDE PRESSURE BELOW MINIMUM. REPLACED SLIDE ASSEMBLY PER BOEING M/M.SDR 97ZZZX5151Slide · failed testNR 4R DOOR SLIDE/RAFT DID NOT BLOW PROPERLY - SN 1355. SLIDE RAFT ROUTED TO SHOP FOR OVERHAUL. SLIDE/RAFT FAILED DURING FAA CERTIFICATION DRILL FOR OAI.SDR 97ZZZX5150Slide · failed testNR 2L DOOR SLIDE/RAFT DID NOT BLOW PROPERLY - SN 2258, SLIDE/RAFT ROUTED TO SHOP FOR OVERHAUL. SLIDE/RAFT FAILED DURING FAA CERTIFICATION DRILL FOR OAI.
Back to JASC 2565