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 98UAL900527Valve · leakingDURING ROUTINE SHOP OVERHAUL OF A SLIDE/RAFT, THE TOP TUBE PRESSURE TEST VALVE BODY (P/N 831A0S), WAS FOUND TO BE LEAKING AT THE BASE OF THE VALVE BODY.SDR ASAA9880217Slide · failedLCQ - DURING 15K CHECK, THE L2 DOOR EMERGENCY EVACUATION SLIDE FAILED THE EMERGENCY LIGHT AMP TEST. REPLACED THE L2 DOOR EMERGENCY EVACUATION SLIDE ASSEMBLY. (M)SDR UPS98828050Container · damagedINSPECTION TYPE-N/A, ESCAPE SLIDE KEEPS FALLING OUT OF ITS CONTAINER. INSTALLED NEW CONTAINER AS REQUIRED, ESCAPE AND GRIP BAR OPS NORMAL.SDR CALA9801987Slide · failedTHE AFT GALLEY SERVICE DOOR SLIDE WAS INADVERTENTLY PULLED, BUT DID NOT DEPLOY. INSPECTION BY MAINTENANCE FOUND THE AFT GALLEY SERVICE DOOR SLIDE LANYARD PULLED AND PRESSURE AT ZERO. THE SLIDE WAS REMOVED AND REPLACED IAW MM 25-62-0.SDR EISA98250Slide · lowGALLEY DOOR SLIDE PRESSURE BELOW LIMITS. GENERATED FROM MAINTENANCE REPORT. REPLACED GALLEY DOOR SLIDE PER MM 25-62-0. (M)SDR SPAA9800008Slide · did not inflateR1 DOOR EMERGENCY ESCAPE SLIDE FAILED TO PROPERLY INFLATE DURING CREW TRAINING EXERCISE. THE EVACUATION SLIDE ASSEMBLY WAS ROUTED TO THE OVERHAUL VENDOR FOR EVALUATION. THE OVERHAUL VENDOR REPLACED THE REGULATOR VALVE ASSEMBLY, (P/N 3001-BN) AND INFLATION HOSDR 98UAL900508Slide · malfunctionedDOOR 1L SLIDE DEPLOYED AFTER ARRIVAL AT GATE. *S/D* FLIGHT CREW ACCIDENTALLY DEPLOYED THE SLIDE UPON ARRIVAL. SLIDE WAS REPLACED PER MM 40-25-62-44.SDR ASAA9840100Slide · damagedYVR - DURING PREFLIGHT FOR FLIGHT 654, CREW REPORTED THAT THE R1, R2, AND L2 DOOR EVACUATION SLIDE MANUAL INFLATION HANDLES WERE MISSING. REPLACED THE R1, R2, AND L2 DOOR EVACUATION SLIDES. (M)SDR AU981409Actuator · malfunctioned(AUS) OFF-WING ESCAPE SLIDE COMPARTMENT DOOR UNLATCHING ACTUATOR FAILED TO UNLATCH THE DOOR SUFFICIENTLY FOR DOOR DEPLOYMENT ACTUATORS TO OPERATE.SDR AU981534Door · delaminated(AUS) RIGHT OVERWING ESCAPE SLIDE ENCLOSURE DOOR DELAMINATED AT THE AFT LOWER CORNER. AREA OF DELAMINATION 2258.06 SQMM (3.5SQ INCH). FOUND DURING INSPECTION IAW AD/A320/061.SDR 98UAL900498Tube · tornSLIDE/RAFT FAILED PROOF TEST DURING UNIT OVERHAUL IN HOME SHOP, CAUSING A 6 FOOT TEAR IN THE TOP TUBE CENTER CROSSOVER TUBE. CAUSE COULD NOT BE DETERMINED. SENT UNIT TO VENDOR FOR EVALUATION AND REPAIR.SDR MWEA981005Slide · low pressureTHE GALLEY EMERGENCY SLIDE FORWARD FOUND WITH LESS THAN 500 PSI. MTC REMOVED AND REPLACED GALLEY DOOR EMERGENCY SLIDE.SDR AU981410Slide · failed(AUS) DOOR 1 RT SIDE ESCAPE SLIDE FAILED TO INFLATE CORRECTLY AND APPEARED TO CONTACT THE LOWER DOOR BUSTLE/HINGE CAUSING THE SLIDE TO TEAR.SDR NOCA2298Slide · malfunctionedON CREW TRAINING OF EMERGENCY EVACUATION, THE R-3 DOOR EVACUATION SIDE DID NOT DEPLOY AUTOMATICALLY ON DOOR OPENING, IT HAD TO BE MANUALLY DEPLOYED. ESCAPE SLIDE PART NR D31041, S/N 0474 WAS SENT TO AIR CRUISERS FOR INSPECTION AND EVALUATION. INSPECTION REVESDR ASAA9880202Slide · failedOAK - DURING C-CHECK, THE L2 DOOR EMERGENCY EVACUATION SLIDE FAILED THE EMERGENCY LIGHT AMP TEST. REPLACED THE L2 DOOR EMERGENCY EVACUATION SLIDE ASSEMBLY. (M)SDR 98UAL900491Disarm Light · malfunctionedDOOR 1 LEFT EMERGENCY ESCAPE SLIDE LIGHTS REMAIN ILLUMINATED IN THE ARMED AND DISARMED POSITION. *S/D* CYCLED DOOR ARM HANDLE SEVERAL TIMES AND FOUND LIGHT TO OPERATE NORMAL.SDR VJ9800508Slide · inoperativeTAIL CONE EMERGENCY ESCAPE SLIDE GAUGE READS IN THE RED. REPLACED TAIL CONE EVACUATION SLIDE ASSEMBLY IAW MM 25-60. PERFORMED REQUIRED INSPECTION.SDR AALA981837Slide · failedJFK - DURING OVERNIGHT MAINTENANCE, CHECK OF L3 DOOR SLIDE DEPLOYMENT WAS UNSUCCESSFUL. REPLACED L3 DOOR SLIDE. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR SCNA98112Slide · failed testDURING A LINE MAINTENANCE CHECK, THE R3 DOOR SLIDE PRESS TO TEST LIGHT WAS CONTINUOUSLY ILLUMINATED. FOUND SLIDE PRESSURE TO BE LOW AND REMOVED AND REPLACED THE EMERGENCY SLIDE IAW MM 256101. SLIDE PACK PRESSURE INDICATOR TESTS NORMAL.SDR DLM90981980Slide · deployedR1 DOOR SLIDE ACCIDENTLY DROPPED OUT OF DOOR CRADLE AND DEPLOYED. REPLACED DOOR SLIDE PER M/M.SDR 98ZZZX3986Slide · damagedATW - SLIDE FOUND DEFECTIVE. REMOVED AND REPLACED SLIDE, CHECKS GOOD.SDR 98ZZZM816Slide · malfunctionedIND - WHILE PERFORMING TASK CARD 25-016-01, "SLIDE DEPLOYMENT FOR L-4 DOOR", THE DOOR ASSIST DID NOT OPEN THE DOOR IN 2-6 SECONDS. HAD TO PUSH THE DOOR OPEN FOR SLIDE DEPLOYMENT. SUSPECTED SLIDE SHIFTED UNDER THE COVER CATCHING THE DOOR FRAME. A/C HAD P/C/WSDR VJ9800416Slide · contaminatedTAIL CONE EVAC SLIDE ASSY SATURATED WITH FOREIGN MATERIALS. REMOVED AND REPLACED TAIL CONE SLIDE ASSY.SDR 98UAL900461Slide · departedRIGHT WING SLIDE DEPARTED ON TAKEOFF.SDR GTIA9800106Slide · looseDTW - L-1 DOOR SLIDE PACK FELL OFF WHEN AIRCRAFT WAS AT GATE. RE-INSTALLED SLIDE PACK IAW MD80 MM 25-61-0. NO DEFECTS NOTED AT THIS TIME. (M)SDR ASAA9880179Slide · malfunctionedOAK - DURING C-CHECK, THE L2 DOOR EMERGENCY EVACUATION SLIDE FAILED THE EMERGENCY LIGHT AMP TEST. REPLACED THE L2 DOOR EMERGENCY EVACUATION SLIDE ASSEMBLY. (M)SDR USAAD98161Slide · failedPIT - THE AFT ESCAPE SLIDE MECHANISM FAILED TO DEPLOY THE SLIDE DURING FUNCTIONAL TEST. MAINTENANCE REPLACED THE SLIDE ASSY. (M)SDR MWEA98963Slide · crackedMKE - FOUND AFT SERVICE DOOR EVACUATION SLIDE BACK CASING CRACKED. REMOVED AND REPLACED EVACUATION SLIDE. (X)SDR ASAA9880175Slide · malfunctionedOAK - DURING CK CHECK, THE L1 DOOR EMERGENCY EVACUATION SLIDE FAILED THE EMERGENCY LIGHT AMP TEST. REPLACED THE L1 DOOR EMERGENCY EVACUATION SLIDE ASSEMBLY. (M)SDR ASAA9880171Bottle · dischargedPDX - DURING MAINTENANCE CHECK, THE R1 DOOR EMERGENCY EVACUATION SLIDE INFLATION BOTTLE PRESSURE WAS FOUND LOW. REPLACED THE R1 DOOR EMERGENCY EVACUATION SLIDE ASSY. (M)SDR USAAD98157Slide · failedPIT - THE AFT ESCAPE SLIDE MECHANISM FAILED TO DEPLOY SLIDE DURING FUNCTIONAL TEST. MAINTENANCE REPAIRED THE SLIDE RELEASE MECHANISM AND REPLACED THE SLIDE ASSY. (M)SDR USAABB98099Hinge · brokenPIT - ON WALK AROUND, MECHANIC FOUND RIGHT OVERWING SLIDE DOOR NOT FAIRED. MAINTENANCE REPLACED TWO BROKEN HINGES ON SLIDE DOOR. (M)SDR CKSA98512Slide · deployedUPON ARRIVAL AT A/C, FOUND L1 DOOR SLIDE LYING ON TOP OF AIRSTAIRS. DOOR OPENED INCORRECTLY BY OGDEN CATERING. REMOVED AND REPLACED L1 DOOR SLIDE ASSEMBLY IAW L1011 MM CHAPTER 25-61-01, OPS CHECK NORMAL IAW SAME.SDR ASAA9880170Bottle · dischargedSEA - PRIOR TO DEPARTURE OF FLT 376, CREW REPORTED THE L1 DOOR EMERGENCY EVACUATION SLIDE INFLATION BOTTLE PRESSURE WAS LOW. REPLACED THE L1 DOOR EMERGENCY EVACUATION SLIDE ASSY. (M)SDR ASAA9880169Bottle · dischargedLAX - DURING MAINTENANCE CHECK, THE R1 DOOR EMERGENCY EVACUATION SLIDE INFLATION BOTTLE PRESSURE WAS FOUND LOW. REPLACED THE R1 DOOR EMERGENCY EVACUATION SLIDE ASSY. (M)SDR ASAA9880168Slide · failedOAK - DURING 15K CHECK, THE L1 DOOR EMERGENCY EVACUATION SLIDE FAILED THE EMERGENCY LIGHT AMP TEST. REPLACED THE L1 DOOR EMERGENCY EVACUATION SLIDE ASSY. (M)SDR CALA9801571Light · inoperativeTHE R-1 DOOR EMERGENCY EVACUATION SLIDE FAILED SLIDE LIGHT TEST. THE R-1 DOOR SLIDE WAS REMOVED AND REPLACED.SDR 98ZZZX3988Slide · malfunctionedATW - FUNCTION CHECKED SLIDE (DEPLOY) AND THEN REMOVED FOR DETAILED INSPECTION. REF CHECKLIST. REPORT TASK ON STEP 543 IN COMPUTER. C/W DEPLOYMENT TEST IAW BAE 146 M. GEN W/C INST SERVICE SLIDE. REF W/C 892, SLIDE DEPLOYED TWISTED. REMOVED AND REPLACED WSDR VJ9800299Slide · inoperativeR-1 DOOR EVAC SLIDE ILLUMINATION LIGHTS DID NOT COME ON WHEN MX CHECKING SLIDE AFTER DEPLOY. PULLED LANDYARD AND LIGHT CAME ON. REPLACED THE SLIDE ASSY.SDR AU981160Lanyard · frayed(AUS) L2 PASSENGER DOOR ESCAPE SLIDE COVER RELEASE CABLE FRAYED. FOUND DURING INSPECTION IAW AD/B737/42.SDR GTIA9800101Slide · detachedMCO - FLT 501 - SLIDE PACK FELL OFF AFT ALLEY DOOR. REINSTALLED SLIDE PACK AS NECESSARY IAW MM 25-00-01. (X)SDR VJ9800285Slide · deployedINADVERTENT DEPLOYMENT OF THE L-2 DOOR SLIDE. FERRIED AIRCRAFT TO MCO, DOOR SLIDE WAS INSTALLED ON THE L-2 DOOR.SDR AU981224Slide · leaking(AUS) LEFT OFF-WING SLIDE RAMP LEAKING. DURING INSPECTION ONE SEAM ON THE UPPER INBOARD RAIL TUBE OPENED UP FOR APPROXIMATELY 406.4 MM (16 INCHES). PART TC: 25,709.SDR AU981223Slide · leaking(AUS) RIGHT OFF-WING ESCAPE SLIDE LEAKING. DURING INVESTIGATION OF THE LEAK, A PART OF THE SEAM APPROXIMATELY 152.4 MM (6 INCHES) IN LENGTH OPENED UP. PART TC: 24,484.SDR EISA98208Slide · failedPOST FLIGHT FOUND GALLEY EVAC SLIDE PRESSURE LOW. REMOVED AND REPLACED SLIDE ASSY MM 25-00 CHECKS OK. (M)SDR 98ZZZX3976Slide · damagedMKE - FLT 621 - LEFT FORWARD PASSENGER DOOR EMERGENCY SLIDE HAS DROPPED DOWN IN ITS OWN CONTAINER. REMOVED AND REPLACED LEFT FORWARD PASSENGER SLIDE IAW MM BATTERY EFF CHECK DUE 3-5-99. COVER LATCH PULL OFF TEST C/W. S/N OFF 0310. S/N ON 0340.SDR AALA981478Slide · defectiveORD - DURING OVERNIGHT CHECK, ENTRY DOOR SLIDE HAD LOW PRESSURE. REPLACED ENTRY DOOR SLIDE. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR TWAA9812702Slide · deployedPARKED ON THE GATE, THE AFT LEFT CABIN DOOR WAS OPENED FOR COOLING WITHOUT REMOVING THE ESCAPE SLIDE GIRT BAR. THE ESCAPE SLIDE ONLY PARTIALLY DEPLOYED. BOTTLE PRESSURE WAS REPORTED EMPTY. CHECK-C 11-16-97 MCI.SDR SWAA981500Slide · inoperativeDURING WALKAROUND CHECK, FOUND AFT ENTRY ESCAPE SLIDE GAUGE UNABLE TO READ. REMOVED AND REPLACED SLIDE PACK PER BOEING MM. PRESS READ NORMAL.SDR 98ZZZX3007Restraint · misinstalledEVACUATION SLIDE RECEIVED PACKED WITH SHEAR PIN RESTRAINTS INSTALLED. RECEIVING INSPECTION REVEALED THE SHEAR PIN RESTRAINTS WERE PREVIOUSLY ACTIVATED. THE TWO HALVES OF THE SHEAR PIN RESTRAINTS WERE RE-ATTACHED WING STEEL SAFETY WIRE. ONCE SHEAR PIN RESTRA
Back to JASC 2565