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 SWAA032251Slide · unserviceableAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR USAABB03187Bellcrank · misinstalledPHL - L2 DOOR ARMED INDICATION INTERMITTENT. MAINTENANCE FOUND A LOWER GIRT BAR BELLCRANK INCORRECTLY INSTALLED A REPOSITIONED IT. (M)SDR ASAA0380636Lanyard · disconnectedLINE CHECK, FOUND FORWARD PAX L1 DOOR EMERGENCY SLIDE LANYARD WAS FOUND DISCONNECTED. RECONNECTED LANYARD. (M)SDR AWXA200301210Detector · inoperativeFLIGHT CREW REPORTED R-2 DOOR SLIDE NOT ARMED ON LOWER ECAM, SLIDE INDICATED ARMED AT DOOR. MAINTENANCE REMOVED AND REPLACED R-2 DOOR ARMING HANDLE PROXIMITY SWITCH (7WN2), ADJUSTMENT AND OPERATIONAL CHECK C/W IAW AMM SUBTASK 52-71-00-820-002.SDR SWAA032233Slide · out of positionR1 DOOR EVACUATION SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA032228Attach Fitting · looseDURING SCHEDULED C3 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR ATTACHMENT FITTING LOOSE. SECURED ATTACHMENT FITTING PER MM.SDR CALA0300580Connector · corrodedTHE LT EMERGENCY ESCAPE SLIDE FAILED TEST 1. TROUBLESHOOTING PER FIM 25-65-00 FOUND CANNON PLUG D40828 AT LT EMERGENCY HATCH DISARM PANEL HAD LITE SURFACE CORROSION ON SEVERAL PINS. THE CONNECTOR WAS CLEANED AND RECONNECTED AND SYSTEM TESTED NORMAL.SDR UPS03141375Warning System · malfunctionedWHEN TRYING TO ARM THE ESCAPE SLIDE HAD TO CYCLE THE ARMING LEVER 2 OR 3 TIMES IN ORDER TO GET THE SLIDE ARMED INDICATION ON THE ECAMS. SYSTEM TEST OK PER 52-73-14-4. THIS CLEARS M267914.SDR ASAA0380604Lanyard · disconnectedPREFLIGHT CHECK, FORWARD PASSENGER L-1 DOOR EMERGENCY SLIDE LANYARD WAS FOUND DISCONNECTED. RECONNECTED LANYARD. (M)SDR SWAA032225Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND AFT SVC DOOR EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA032227Slide · looseFWD SVC DOOR EMERGENCY EVAC SLIDE LOOSE IN CONTAINER. SECURED SLIDE PER MM.SDR SWAA032221Indicator · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA032219Girt Bar · out of adjustDURING SCHEDULED C4 CHECK, FOUND BOTH FWD CABIN DOOR EMERGENCY EVAC SLIDE GIRT ASSY'S OUT OF ADJUST. ADJUSTED BOTH CABIN DOOR SLIDES PER MM.SDR SWAA032194Indicator · out of limitsDURING SCHEDULED RON, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED AFT SVC DOOR EMERGENCY EVAC SLIDE PER MM.SDR SWAA032193Slide · deployedDURING SCHEDULED RON, AFT SVC DOOR EMERGENCY EVAC SLIDE INADVERTENTLY DEPLOYED. REMOVED AND REPLACED AFT SVC DOOR EMERGENCY ECAV SLIDE PER MM.SDR SWAA032210Indicator · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA032222Slide · dislodgedAFT SVC DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT OF THE CASE. REINSTALLED SLIDE PER MM.SDR SWAA032199Indicator · out of limitsDURING SCHEDULED SERVICE CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR ASAA0380600Lanyard · disconnectedSEA PREFLIGHT CHEC, AFT SERVICE R-2 DOOR EMERGENCY SLIDE LANYARD WAS FOUND DISCONNECTED. RECONNECTED LANYARD. (M)SDR 2003UALA00790Tube · failedDURING THE OVER-PRESSURIZATION TEST OF THE UPPER DECK SLIDE THE TOP TUBE FAILED. FAILURE OCCURRED AT 3.13 PSI. SLIDE WAS RETURNED TO THE OEM (GOODRICH) FOR ANALYSIS. UNABLE TO DETERMINE CAUSE OF FAILURE OR ACTION. PORTION OF THIS SLIDE HAS BEEN SCRAPPED.SDR SWAA032202Cable · misroutedDURING SCHEDULED C1 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED CABLE PER MM.SDR SWAA032201Cable · misroutedDURING SCHEDULED C1 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED CABLE PER MM.SDR SWAA032198Indicator · out of positionDURING SCHEDULED C1 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR USAABB03181Relay · faultyDURING SQUIB TEST 1, THE EMERGENCY ESCAPE SLIDE INDICATOR LIGHT REMAINED EXTINGUISHED. MAINTENANCE REPLACED THE SQUIB TEST 1 RELAY, K838. (M)SDR SWAA032178Indicator · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA032180Girt Bar · out of adjustDURING SCHEDULED C4 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA032177Slide · dislodgedFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR GTIA030715Lanyard · disconnectedLGA - FLT 381 - L1 DOOR SLIDE PACK LANYARD IS NOT ATTACHED. RE-INSTALLED L1 DOOR SLIDE PACK LANYARD. NO DEFECTS NOTED. (M)SDR SWAA032170Girt Bar · out of adjustFWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA032167Indicator · out of positionDURING SCHEDULED C4 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA032163Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR AALA20031067Slide · defectiveDFW - FLT 1128 - AIRCRAFT GROUND INTERRUPTED WITH SMOKE IN THE CABIN. EMERGENCY EVACUATION WAS EXECUTED BY DEPLOYING SLIDES. ALL PERSONS EVACUATED SAFELY. TAIL CONE SLIDE FAILED TO DEPLOY PROPERLY. SKYDROL NOTED DRIPPING UNDER AIRCRAFT. REPLACED TAIL SLIDSDR GTIA030713Slide · out of positionLGA - FLT 705 - SLIDE PACK FELL OFF L-1. FORWARD ENTRY DOOR SLIDE PACK FELL OFF WHEN OPENING DOOR AT ARRIVAL GATE. GIRT BAR LATCH ON THE FLOOR IS VERY DIRTY AND STICKY. REINSTALLED L1 DOOR SLIDE AND CHECKED GIRT BAR LATCHES FOR OPERATION, OPS NORMAL. (M)SDR SWAA032144Indicator · out of positionDURING SCHEDULED C2 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR AWXA200301087Reservoir · leakingDURING INSPECTION THE RT OVER WING EMERGENCY EVACUATION SLIDE BOTTLE WAS FOUND TO HAVE LOW PRESSURE. MAINTENANCE REMOVED AND REPLACED THE RT OVER WING EMERGENCY EVACUATION SLIDE BOTTLE IAW AMM 25-62-46-000-001, OPERATIONAL CHECK WAS GOOD. VENDOR TEARDOWN OF RSDR USAASA03115Release Cable · incorrectCLT - THE FORWARD RIGHT SERVICE DOOR EMERGENCY ESCAPE SLIDE WAS FOUND TO HAVE AN INCORRECT RELEASE CABLE INSTALLED DURING INSPECTION. MAINTENANCE REPLACED THE FORWARD RIGHT EMERGENCY ESCAPE SLIDE ASSEMBY. OK FOR SERVICE. (M)SDR USAASA03116Release Cable · incorrectBOS - THE AFT SERVICE DOOR EMERGENCY ESCAPE SLIDE WAS FOUND TO HAVE AN INCORRECT RELEASE CABLE INSTALLED DURING INSPECTION. MAINTENANCE REPLACED THE SLIDE ASSEMBLY. OK FOR SERVICE. (M)SDR USAABA03035Slide · defectivePHL - A TEST OF THE EMERGENCY LIGHTS INDICATED A FAULT FROM THE R4 DOOR EPSU. MAINTENANCE REPLACED THE R4 DOOR SLIDE. (M)SDR GTIA030686Slide · dislodgedFOUND L-2 DOOR SLIDE PACK FELL FROM DOOR. REMOVED AND REPLACED L-2 SLIDE PACK. (M)SDR USAABB03173Connector · looseTHE RIGHT OVERWING EXIT FAILED THE SQUIB TEST. MAINTENANCE FOUND A LOOSE CONNECTION (S1) ON THE M1136 CONTROL MODULE AND TIGHTENED IT. (M)SDR DL757030857Girt Bar · unsecureACFT PARKED AT GATE AND JUST PRIOR TO DEPARTURE FLT ATT CLOSED 3L CABIN DOOR AND NOTICED THAT THE GIRT BAR APPEARED ABNORMAL. MTC SECURED GIRT BAR ATTACH BRACKETS TO SLIDE ASSY AS PER MM.SDR SWAA032109Cable · misroutedDURING SCHEDULED C4 CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE RELEASE CABLE MISROUTED. REROUTED SLIDE RELEASE CABLE PER MM.SDR SWAA032097Clip · looseDURING SCHEDULED C2 CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE GIRT BAR CLIP ATTACH RIVET SHEARED. REPAIRED GIRT BAR CLIP PER SRM.SDR SWAA032093Indicator · out of positionAFT ENTRY DOOR EVACUATION SLIDE PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA032083Slide · out of positionDURING SCHEDULED PM CHECK, FOUND BOTH AFT DOOR EVAC SLIDES OUT OF POSITION. REPOSITIONED BOTH SLIDES PER MM.SDR SWAA032082Cable · misroutedDURING SCHEDULED C4 CHECK, FOUND AFT ENTRY DOOR EVAC SLIDE RELEASE CABLE MISROUTED. REROUTED CABLE PER MM.SDR SWAA032081Slide · out of positionFWD SERVICE DOOR EVACUATION SLIDE OUT OF POSITION. REINSTALLED SLIDE ASSY PER MM.SDR SWAA032077Slide · out of positionAFT ENTRY DOOR EVAC SLIDE OUT OF POSITION. REINSTALLED SLIDE ASSY PER MM.SDR 0301809927Slide · malfunctionedPER MAINTENANCE CONTROL ORDER 4721, AN OPERATIONAL CHECK OF THE TAIL CONE DEPLOYMENT WAS PERFORMED. FOUND SLIDE PACK DEPLOY STRAP DID NOT SNAP ON THE SLIDE ASSEMBLY AS DESIGNED. SLIDE WAS REPLACED AND THE AIRCRAFT RETURNED TO SERVICE.SDR USAASA03113Release Cable · incorrectPHL - THE FORWARD SERVICE DOOR EMERGENCY ESCAPE SLIDE WAS FOUND TO HAVE AN INCORRECT RELEASE CABLE INSTALLED DURING INSPECTION. MAINTENANCE REPLACED THE FORWARD RIGHT EMERGENCY ESCAPE SLIDE ASSEMBLY. OK FOR SERVICE. (M)
Back to JASC 2565