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 F3LA99047Battery · dischargedDEN - DURING C-CHECK INSPECTION REPORTED L-2 EMERGENCY ESCAPE SLIDE BATTERY FAILED VOTLAGE TEST. REPLACED L-2 EMERGENCY ESCAPE SLIDE. CYCLES: 2,724. (X)SDR UF6A990547Slide · failedSBN - AFT BAGGAGE DOOR SLIDE FAILED FUNCTIONAL TEST. MAINTENANCE MANUALLY DEPLOYED SLIDE AND REMOVED AND REPLACED. (M)SDR 99UAL900300Tube · tornEVACUATION SLIDE ON DOOR 1 LEFT WAS DEPLOYED DURING LAX MAINTENANCE CHECK. WITHIN TWENTY MINUTES OF DEPLOYMENT SLIDE WENT FLAT. *S/D* UNIT WAS SENT TO VENDOR FOR EVALUATION AND REPAIR. VENDOR FOUND A .75 INCH PUNCHER IN THE LOWER TUBE THAT DEVELOPED INTO ASDR F3LA99046Battery · dischargedDEN - DURING C-CHECK, INSPECTION REPORTED L-1 EMERGENCY ESCAPE SLIDE BATTERY FAILED VOLTAGE TEST. REPLACED L-1 EMERGENCY ESCAPE SLIDE. CYCLES: 2,724. (X)SDR SWAA990851Slide · failedDURING SCHEDULED RON, FOUND AFT ENTRY DOOR EVACUATION SLIDE SHOWS LOW PSI. REMOVED AND REPLACEDR SLIDE ASSY PER MM.SDR SWAA990850Slide · deterioratedDURING SCHEDULED BC3 CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE STRAP DETERIORATED. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA990846Slide · damagedFWD ENTRY DOOR GIRT VELCRO TORN ON ESCAPE SLIDE ASSY. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR CA950929008Valve · failed(CAN) INFLATION CYLINDER AND VALVE ASSY SENT OUT FOR OVERHAUL AND INCORPORATION OF SB 210-25-13. VALVE REINSTALLED AND RECHARGED. DURING RECHARGE, THE VALVE BLEW APART AT 2,000 PSI, CREATING A LIFE THREATENING SITUATION. THE FAILURE OCCURRED AT THE THREADEDSDR MALA976448Slide · failedTHE MAIN PASSENGER DOOR SLIDE LAYING ON THE JETWAY DIDN'T INFLATE. MAINTENANCE REPLACED SLIDE. ALL WORK DONE PER AVRO MM 25. ALL CHECKS GOOD.SDR SWAA990832Slide · failedDURING SCHEDULED SERVICE CHECK, FOUND AFT GALLEY DOOR EVACUATION SLIDE GAUGE READING BELOW LIMITS. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR 99ZZZX2465Pins · bentDURING PRE-FLIGHT, FOUND SOME PARACHUTE PINS PULLED AND BENT ON THE NR R3 SLIDE. REMOVED AND REPLACED SLIDE PER MM. (X)SDR MALA976447Slide · deployedRIGHT FORWARD SLIDE PARTIALLY DEPLOYED. MAINTENANCE REPLACED SLIDE PACK ASSEMBLY IAW AMM 25-60-11.SDR CA990521019Slide · misadjusted(CAN) RIGHT OVERWING SLIDE FAILED TO OPEN WHEN TESTED. ACTUATING CABLE EITHER TOO LONG OR TOO SHORT, YET TO BE DETERMINED.SDR SWAA990795Cable · out of positionDURING SCHEDULED C1 CHECK, FOUND FWD SERVICE DOOR SLIDE PACK CABLE ROUTED INCORRECTLY. REROUTED CABLE PER MM.SDR TWAA9906403Slide · low pressureTHE FORWARD GALLEY DOOR EVACUATION SLIDE PRESSURE WAS LOW. REPLACED THE SLIDE. CHECK-C 7-4-98 STL.SDR CALA9900438Wire · disconnectedDOOR 1 AND 3 RT LOW PRESSURE LIGHT SLIDE BOTTLES DONT WORK. REINSTALLED TERMINALS WIRE LIGHT SLIDE ON DOOR 1 AND 3 RIGHT SIDE. PERFORMED TEST PER MM 25-60-00.SDR AU990387Pin · failed(AUS) SLIDE RAFT UPPER SHEAR PIN FAILED TO SHEAR DURING INFLATION. FULL DEPLOYMENT OF THE SLIDE COULD NOT OCCUR.SDR TWAA9905202Slide · low pressTHE FWD LEFT SIDE CABIN DOOR ESCAPE SLIDE BOTTLE PRESSURE WAS LOW. REPLACED THE ESCAPE SLIDE.SDR SWAA990658Slide · low pressureLEFT AFT ENTRY DOOR EMERGENCY EVACUATION SLIDE, BOTTLE PRESSURE LOW. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR ASAA9980075Bottle · low pressurePDX - DURING MAINTENANCE CHECK, THE TAILCONE EXIT EMERGENCY EVACUATION SLIDE INFLATION BOTTLE PRESSURE WAS FOUND LOW. REPLACED THE TAILCONE EXIT EMERGENCY EVACUATION SLIDE ASSEMBLY. (M)SDR SWAA990648Slide · pressure lowDURING SCHEDULED SERVICE CHECK, FOUND R1 DOOR SLIDE PRESSURE LOW. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA990620Slide · low pressureFWD ENTRY DOOR ESCAPE SLIDE BOTTLE PRESSURE IS LOW. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA990640Slide · detachedFWD SERVICE DOOR EMERGENCY EVACUATION SLIDE FELL OUT. REPACKED SLIDE PER MM.SDR SWAA990605Slide · low pressureL-2 DOOR EVACUATION SLIDE BOTTLE PRESSURE LOW. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA990549Slide · low pressureL2 DOOR SLIDE PRESSURE GAUGE IN RED. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR 99UAL900159Door · not latchedRETURNED TO BOS DUE TO LEFT OVERWING SLIDE DOOR INDICATION. *S/D* INSPECTED PER MM 25-65-00 AND FOUND SLIDE DOOR AFT LATCH NOT LOCKED. RESET ROUND CRANK HANDLE AND SLIDE DOOR LATCHES PER MM 25-65-00.SDR CKSA99003Slide · deployedON ARRIVING AT AIRCRAFT FOR PREFLIGHT, FOUND UPPER DECK CREW DOOR OPEN, CREW ESCAPE SLIDE PARTIALLY DEPLOYED. THE FOLLOWING WAS DETERMINED: SLIDE WAS IN PROPER POSITION FOR DEPLOYMENT, DOOR WAS FOUND OPEN WITH DOOR HANDLE IN ARMED POSITION, SLIDE BOTTLE TO DESDR SWAA990470Slide · press lowAFT ENTRY DOOR SLIDE HAS LOW PRESSURE. REMOVED AND REPLACED AFT ENTRY DOOR SLIDE PER MM.SDR SWAA990459Slide · disengagedDURING OVERNIGHT CHECK, FOUND FWD ENTRY DOOR SLIDE POPPED OUT OF RETAINER. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA990453Slide · low pressureFWD SERVICE DOOR SLIDE PRESSURE IS LOW. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA990446Slide · press lowDURING OVRNIGHT CHECK, FOUND L-1 DOOR EVAC SLIDE LOW AT 2700 PSI. REMOVED AND REPLACED SLIDE PER MM.SDR MALA976367Slide · deployedUPON BOARDING NOTICED THE RIGHT FORWARD CABIN DOOR SLIDE PARTIALLY DEPLOYED, BLOWN BY CATERING. MAINTENANCE REPLACED SLIDE, ALL CHECKS GOOD.SDR CALA9900206Slide · low pressureTHE R-3 DOOR EMERGENCY SLIDE LOW PRESSURE INDICATOR LIGHT WAS FOUND ILLUMINATED DURING A PRE-DEPARTURE CHECK. THE R-3 DOOR EMERGENCY SLIDE WAS REMOVED AND REPLACED IAW MM 25-61-02, PAGE 201-208.SDR SWAA990432Slide · disengagedFORWARD ENTRY ESCAPE SLIDE FELL OUT WHILE TRYING TO CLOSE DOOR FOR DEPARTURE. RESTOWED SLIDE ASSY PER MM.SDR DL767990442Slide · deployedLT OVERWING SLIDE DEPLOYED IN FLIGHT PASSING THRU FL 12 OUT OF ATL. MTC OBSERVED LINKAGE ON DOOR RELEASE MECHANISM, FOUND THIRD LINKAGE FROM FORWARD EDGE BENT AND BROKEN, CAUSING CENTER TWO LATCHES TO RELEASE. FORWARD AND AFT LATCHES WERE FOUND INTACT WITH DSDR DL767990432Slide · detachedPASSING 21,000 FT MSL, FLT ATTENDANTS COMPLAINED OF LOUD NOISE. ALSO, HAD EICAS MSG LT SLIDE DOOR AND OVERHEAD DISCREET EMERG DOORS. AIR TURNBACK TO ATL. FOUND LT OVERWING SLIDE PANEL AND SLIDE DEPARTED AIRCRAFT. SEVERAL SMALL ABRASIONS AROUND SURROUNDING SDR SWAA990399Slide · low pressureDURING SCHEDULED CHECK, FOUND AFT ENTRY EVACUATION SLIDE INDICATOR IS IN THE RED BAND. REPLACED SLIDE ASSY PER MM.SDR 99ZZZM306Slide · draggingBOTTOM OF SLIDE COVER DRAGS ON DOOR FRAME WHEN 1R ENTRY DOOR IS OPENED. REMOVED AND REPLACED R1 DOOR SLIDE IAW MM 25-66-01, DOOR OPENS AND CLOSES FINE, OK DOOR SERVICE. (M)SDR AT9900141Cable · brokenFOUND THE R-1 DOOR SLIDE (LANYARD ASSEMBLY) PULL CABLE BROKEN. REMOVED AND REPLACED THE DOOR SLIDE CABLE LANYARD AND RETURNED THE AIRCRAFT TO SERVICE IAW MM 25-60.SDR SWAA990346Slide · looseDURING PREFLIGHT, FOUND FWD ENTRY DOOR SLIDE WOULD NOT REMAIN SECURED. REPLACED PER BOEING M/M.SDR SWAA990328Slide · out of positionFWD ENTRY DOOR SLIDE WILL NOT STAY SECURE. REMOVED AMD REPLACED FWD ENTRY DOOR SLIDE PER M/M, GROUND OPS CK'S NORMAL.SDR TWAA9902703Slide · air leakTHE FWD LT CABIN DOOR ESCAPE SLIDE WAS FOUND WITH LOW AIR BOTTLE PRESSURE. REPLACED THE SLIDE PER MC82501. CHECK-C 3-30-98 STL.SDR TWRA9907Slide · cutR2 MED SLIDE RAFT EXPIRATION DATE WA COMING DUE, THE SLIDE RAFT WAS USED FOR TRAINING PURPOSES AND INFLATED INTENTIONALLY. DURING SLIDE DEPLOYMENT THE SLIDE WAS FOUND TO BE CUT AND LEAKING AT THE BAS. EVACUATION WAS COMPLETED PRIOR TO THE RAFT DEFLATING. LISDR 99UAL900113Tube · leakingSLIDE FAILED AIR RETENTION TEST DURING SHOP VISIT. *S/D* POROSITY CAUSED SEAM LEAK. UNIT WAS SENT TO VENDOR FOR EVALUATION AND REPAIR.SDR SWAA990261Slide · low pressDURING SCHEDULED A1 CHECK, FOUND AFT RT DOOR SLIDE PRESSURE LOW. REMOVED AND REPLACED SLIDE PER BOEING M/M.SDR 99ZZZX1477Slide · deployedMSP - FLT 987 - AT GATE, RIGHT HAND AFT R2 DOOR SLIDE DEPLOYED. REMOVED AND REPLACED RIGHT HAND R2 AFT DOOR SLIDE.SDR SWAA990258Slide · out of positionDURING PREFLIGHT CHECK, FOUND AFT SERVICE DOOR SLIDE OUT OF POSITION. REINSTALLED SLIDE PER BOEING M/M.SDR AT9900096Slide · low pressureAFT TAIL CONE SLIDE PRESSURE IS LOW. REMOVED AND REPLACED TAIL CONE SLIDE IAW MM 25-62-1.SDR 99UAL900108Tube · leakingSLIDE FAILED AIR RETENTION TEST DURING SHOP VISIT. *S/D* POROSITY CAUSED SEAM LEAK. UNIT WAS SENT TO VENDOR FOR EVALUATION AND REPAIR.SDR 99UAL900096Slide · malfunctionedDOOR 2L OPENED WITH SLIDE IN ARMED POSITION. SLIDE HAD PARTIAL DEPLOYMENT. *S/D* FLIGHT ATTENDANT OPENED DOOR HANDLE IN ARMED POSITION, HEARD POP SOUND WHICH WAS THE SLIDE LACES SNAPPING. SLIDE HAD DROPPED 1-2 INCHES AT WHICH TIME SHE CLOSED DOOR HANDLE. SH
Back to JASC 2565