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 AU990952Cable · frayed(AUS) CABIN DOOR ESCAPE SLIDE COVER LATCH RELEASE CABLES FRAYED. THE ESCAPE SLIDES AFFECTED WERE LOCATED AT DOORS R1, R2, AND L2.SDR CA990907048Slide · detached(CAN) DURING CREW TRAINING, THE BAGGAGE DOOR ESCAPE CHUTE WAS DEPLOYED. AS THE FIRST CREW MEMBER DESCENDED, THE CHUTE STE SLIDE BODY DETACHED FROM THE DETACHMENT STRAP CAUSING THE CHUTE TO COLLAPSE. THE STITCHING BETWEEN THE SLIDE BODY AND THE A TRAP HAD FAISDR SWAA991401Slide · out of positionAFT ENTRY DOOR EVACUATION SLIDE PRESS GAUGE OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR GTIA9901086Slide · deployedL-1 DOOR SLIDE PACK FELL TO GROUND AND DEPLOYED. REPLACED L-1 DOOR SLIDE PACK IAW DC-9 MM 25-61-00. (M)SDR DL76P991803Slide · detachedLT AFT SERVICE DOOR SLIDE PACK ASSY DROPPED 6 INS OFF DOOR. REMOVED SLIDE AND INSTALL PIN. REPLACED LT AFT SERVICE DOOR SLIDE PACK. CKD OPERATION OF LT AFT DOOR OK. REMOVED AND REPLACED PIN CKD OP OF GIRT/ARM LEVER OK PER M/M.SDR SWAA991328Slide · low pressDURING SCHEDULED A1 CHECK, FOUND FWD SERVICE DOOR EVACUATION SLIDE PRESS LOW. REMOVED AND REPLACED SLIDE ASSY.SDR SWAA991324Cable · out of positionDURING SCHEDULED C3 CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE CABLE ROUTED INCORRECTLY. REROUTED SLIDE CABLE PER MM.SDR SWAA991312Slide · low pressDURING SCHEDULED SERVICE CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE PRESS LOW. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA991297Slide · low pressDURING SCHEDULED OVERNIGHT CHECK, FOUND FWD ENTRY DOOR EVACUATION SLIDE PRESS LOW. REMOVED AND REPLACED FWD ENTRY DOOR SLIDE ASSY PER MM.SDR SWAA991262Slide · deployedFWD SERVICE DOOR EVACUATION SLIDE ACCIDENTALLY DEPLOYED, AND LATER ON FELL OUT OF THE CONTAINER IN SLC. REMOVED AND REPLACED SLIDE ASSY, AND REINSTALLED SLIDE ASSY AT SLC PER MM.SDR DL757991719Lanyard · brokenL-4 SLIDE SAFETY LANYARD FOUND BROKEN DURING ACCOMPLISHMENT OF EO 6-71325-3AD. REPLACED SLIDE ASSY.SDR 99ZZZX3961Slide · deployedDEN - LEFT OVERWING SLIDE BLOWN. REPLACED LEFT HAND OVERWING SLIDE.SDR MWEA99446Slide · no pressureAFT ACCESSORY COMP EVACUATION SLIDE PRESSURE READS 0. REMOVED AND REPLACED AFT EVACAUTION SLIDE.SDR SWAA991233Slide · deployedAFT SERVICE DOOR EVACUATION SLIDE DEPLOYED ACCIDENTALY. REMOVED AND REPLACED AFT SERVICE DOOR EMERGENCY SLIDE ASSY PER MM.SDR CALA9900841Slide · low pressureINSPECTION FOUND RIGHT AFT SLIDE PRESSURE IN THE RED BAND. THE SLIDE WAS REMOVED AND REPLACED IAW MM 25-61-35.SDR SWAA991204Slide · low pressureAFT ENTRY EVACUATION SLIDE PRESS LOW. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA991193Slide · deployedFWD ENTRY DOOR EVACUATION SLIDE ACCIDENTALLY DEPLOYED. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR 99ZZZM712Slide · deployedFLT 9154 - SLC, LEFT NR 1 DOOR SLIDE DEPLOYED INADVERTENTLY. DEFERRED IN SLC CLEARED IN LAX. REPLACED ESCAPE SLIDE/RAFT PACK. (M)SDR 99ZZZX2962Seam · failedDURING FLIGHT ATTENDANT TRAINING, SLIDE INFLATED FOR APPROXIMATELY 10 MINUTES. SEAM AT UPPER AFT CORNER SPLIT, DEFLATING SLIDE.SDR SWAA991188Slide · low pressDURING SCHEDULED SERVICE CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE PRESS LOW. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA991145Slide · low pressFWD ENTRY DOOR EVACUATION SLIDE PRESS LOW. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR DL76L991513Slide · deployedTWENTY MIN AFTER REACHING TOP OF CLIMB FL310, LOUD NOISE HEARD IN R-1 DOOR AREA. AIR LEAK HEARD ON FWD EDGE OF R-1 DOOR. NO PROBLEM WITH PRESSURIZATION OR CABIN ALTITUDE. AFTER LANDING JFK DURING TAXI R-1 DOOR OPENED AND SLIDE DEPLOYED ON TAXI-WAY. REPLACESDR SWAA991135Slide · low pressureFWD ENTRY DOOR EVACUATION SLIDE PRESSURE BELOW LIMITS. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA991134Slide · low pressureDURING SCHEDULED SERVICE CHECK, FOUND FWD SERVICE DOOR EVACUATION SLIDE PRESSURE BELOW LIMITS. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA991114Cable · disconnectedDURING RON CHECK, FOUND FWD ENTRY DOOR EVACUATION SLIDE CABLE LOCK DISCONNECTED. RECONNECTED SLIDE CABLE LOCK. NO DEFECTS NOTED PER MM.SDR SWAA991110Fastener · missingDURING SCHEDULED C2 CHECK, FOUND FWD ENTRY DOOR EVACUATION SLIDE GIRT BAR REAR ATTACH BRACKET MISSING FASTENER. INSTALLED FASTENER PER MM.SDR DLM90991460Slide · unserviceableL1 DOOR SLIDE REMOVED FOR DOOR MTC AND SLIDE COVER LATCH WOULD NOT RELEASE AND AFTER SLIDE COVER OPENED FOUND PIN PULLED OUT. REPLACED SLIDE PACK.SDR SWAA991063Slide · deployedDURING SCHEDULED A1 CHECK, FWD SERVICE DOOR EVACUATION SLIDE ACCIDENTALLY DEPLOYED. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR AALA996047Pin · looseOKC - NR 8000-0019, R-1 DOOR EMERGENCY SLIDE DEPLOY PIN LOOSE. REMOVED AND REPLACED R-1 DOOR EMERGENCY ESCAPE SLIDE IAW MD80 MM 25-60-00. (M)SDR CA990719036Slide · deployed(CAN) ON APPROACH, LT WING SLIDE CAUTION WAS ANNUNCIATED, LIGHT WENT OUT AFTER SEVERAL SECONDS, SOME BUFFETING FELT, HANDLING NORMAL. FLIGHT ATTENDANT REPORTED PASSENGER SAW PIECES OF AIRCRAFT FALL OFF. LT WING SLIDE ASSY, LATCH RELEASE, NITROGEN CYL AND SLISDR AU990937Cylinder · leaking(AUS) UPPER DECK ESCAPE SLIDE INFLATION CYLINDER LEAKING AT THE HEAD FITTING. DEPLOYMENT ACTUATOR LEAKING OIL.SDR AU990936Valve · faulty(AUS) RIGHT UPPER DECK ESCAPE SLIDE TURBO-FAN FLAPPER VALVE BROKEN.SDR SWAA991027Slide · deployedDURING SCHEDULED RON CHECK, FWD ENTRY DOOR SLIDE WAS ACCIDENTALLY DEPLOYED. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR CA990729001Escape Slide · failed(CAN) ESCAPE SLIDE FAILED TO DEPLOY DURING TEST DUE TO JAMMING OF THE RELEASE LEVER ON THE EMERGENCY OPERATING CLYINDER. PERCUSSION MECHANISM INSPECTED AND TESTED PER MM.SDR SWAA991003Slide · low pressFWD ENTRY DOOR EVACUATION SLIDE PRESSURE BELOW LIMITS. REMOVED AND REPLACED SLIDE ASSY.SDR SWAA991008Slide · low pressDURING SCHEDULED SERVICE CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE PRESSURE BELOW LIMITS. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA990984Slide · brokenFWD ENTRY DOOR SLIDE GIRT BAR INNER PLASTIC SLEEVE BROKEN. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR MWEA99328Slide · out of positionAFT GALLEY SERVICE DOOR HARD TO OPEN BECAUSE OF SLIDE CASE HITTING DOOR. REPLACED EVACUATION SLIDE.SDR EISA99126Slide · failedFOUND TAILCONE SLIDE WILL NOT HOLD CHARGE. REPLACED TAILCONE SLIDE PER MM 25-62. (M)SDR 99UAL900311Slide · failedSLIDE/RAFT FAILED AIR RETENTION CHECK DURING OVERHAUL BY VENDOR. *S/D* POROSITY, DUE TO EXCESS MOISTURE, WAS THE CAUSE OF THE FAILED SLIDE/RAFT. VENDOR REPLACED THE INFLATABLE.SDR SWAA990962Slide · low pressDURING SCHEDULED SERVICE CHECK, FOUND AFT ENTRY DOOR EVACUATION SLIDE PRESS BELOW LIMITS. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA990961Fastener · shearedDURING SCHEDULED C3 CHECK, FOUND SHEARED FASTENER AT FWD ENTRY DOOR GIRT BAR ATTACH HANGER. REMOVED AND REPLACED FASTENER PER SRM.SDR SWAA990954Slide · low pressureDURING SCHEDULED A2 CHECK, FOUND FWD ENTRY DOOR ESCAPE SLIDE PRESSURE BELOW LIMITS. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR CA990707056Ditching Dam · deployed(CAN) DITCHING DAM DEPLOYED IN-FLIGHT. AIRSPEED SLOWED TO FLIGHT IN ROUGH AIR SPEED AND RETURNED TO BASE.SDR SWAA990923Slide · low pressDURING SCHEDULED SERVICE CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE PRESSURE BELOW LIMITS. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA990920Slide · low pressFWD SERVICE DOOR EVACUATION SLIDE PRESSURE BELOW LIMITS. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR 9901886623Slide · malfunctionedDURING SCHEDULED CHECK, DOOR 2R SLIDE DEPLOYED BUT DID NOT INFLATE. REPLACED SLIDE, OPERATIONAL CHECK GOOD.SDR F3LA99050Battery · dischargedDEN - DURING C-CHECK INSPECTION REPORTED R-2 EMERGENCY ESCAPE SLIDE BATTERY FAILED VOLTAGE TEST. REPLACED R-2 EMERGENCY ESCAPE SLIDE. CYCLES: 2,635. (X)SDR F3LA99049Battery · dischargedDEN - DURING C-CHECK INSPECTION REPORTED L-2 EMERGENCY ESCAPE SLIDE BATTERY FAILED VOLTAGE TEST. REPLACED L-2 EMERGENCY ESCAPE SLIDE. CYCLES: 2,660. (X)SDR F3LA99048Battery · dischargedDEN - DURING C-CHECK INSPECTION REPORTED L-1 EMERGENCY ESCAPE SLIDE BATTERY FAILED VOLTAGE TEST. REPLACED L-1 EMERGENCY ESCAPE SLIDE. CYCLES: 2,635. (X)
Back to JASC 2565