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 SWAA022437Cable · misroutedDURING SCHEDULED C1 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT CABLE MISROUTED. REROUTED CABLE PER MM.SDR GTIA021077Slide · out of positionORD - FLT 842 - FOUND ON PREFLIGHT, SLIDE PACK MAIN DOOR (L1) OFF. REINSTALLED SLIDE PACK. (M)SDR SWAA022405Cable · misroutedDURING SCHEDULED C4 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE GIRT CABLE MISROUTED. REROUTED CABLE PER MM.SDR UPS02139736Slide · failedDURING ESCAPE SLIDE FUNCTIONAL TEST, BATTERY CAPACITY AND BULB CONTINUITY FAILED TO PASS TEST REQ. REMOVED AND REPLACED EMERGENCY EVACUATION SLIDE PER A300 AMM 25-61-2 1-4.SDR ASAA0280368Lanyard · disconnectedSEA - LANYARD BETWEEN GIRT BAR AND SLIDE COVER BECAME DISCONNECTED. REATTACHED LANYARD. (M)SDR SWAA022392Slide · out of positionDURING SCHEDULED C2 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW AND CABLE MISROUTED. REPOSITIONED SLIDE AND REROUTED CABLE PER MM.SDR SWAA022391Cable · misroutedDURING SCHEDULED C2 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED CABLE PER MM.SDR SWAA022390Bracket · looseDURING SCHEDULED C2 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT BAR BRACKET LOOSE. SECURED BRACKET PER MM.SDR CA021016022Lock · failed(CAN) DURING DEPLOY TEST OF WING SLIDE ENCLOSURE LT DOOR FAILED TO RELEASE CENTER LOCK. DOOR PARTIALLY OPENED AND TORE CENTER LOCK OFF DOOR AND THEN FULLY DEPLOYED. SLIDE AND ENCLOSURE REPLACED.SDR SWAA022351Girt Bar · out of adjustDURING SCHEDULED C1 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR ASAA0280350Lanyard · disconnectedSEA - LANYARD BETWEEN GIRT BAR AND SLIDE COVER BECAME DISCONNECTED. REATTACHED LANYARD. (M)SDR ASAA0280348Slide · failedOAK - DURING LINE CHECK, THE TAILCONE WAS INADVERTENTLY RELEASED, AND WAS DAMAGED AS A RESULT OF THE FALL. THE AFT EMERGENCY ESCAPE SLIDE, RIGGED TO AUTOMATICALLY DEPLOY UPON TAILCONE RELEASE, DID NOT DEPLOY. INSPECTION OF THE ESCAPE SLIDE PACK AND ITS RIGGISDR SWAA022311Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA022310Slide · out of adjustDURING SCHEDULED BC4 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. REPOSITIONED SLIDE PER MM.SDR SWAA022309Slide · out of positionDURING SCHEDULED C4 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR USAASB02186Slide · malfunctionedDURING ANNUAL OPERATIONAL CHECK OF THE FORWARD RIGHT SERVICE DOOR ESCAPE SLIDE, THE SLIDE APPEARED TO HAVE PREMATURELY INFLATED AND BECAME TWISTED 90 DEGREES. DOOR BECAME DIFFICULT TO OPEN FULLY ONCE SLIDE BEGAN TO INFLATE. SLIDE OPERATIONAL CHECK FAILED. MSDR USA2002F00092Slide · failedDURING ANNUAL OPERATIONAL CHECK OF THE FORWARD RIGHT SERVICE DOOR ESCAPE SLIDE, THE SLIDE APPEARED TO HAVE PREMATURELY INFLATED AND BECAME TWISTED 90 DEGREES. DOOR BECAME DIFFICULT TO OPEN FULLY ONCE SLIDE BEGAN TO INFLATE. SLIDE OPERATIONAL CHECK FAILED. MSDR 0203375527Slide · failedWHILE PERFORMING SAMPLING DEPLOYMENT INSPECTION OF DOOR 4R EVACUATION SLIDE, THE LOWER LEFT SUPPORT RIB SEAM RIPPED OPEN. REPLACED THE SLIDE. OPERATIONAL CHECK OK.SDR SWAA022262Slide · out of positionDURING SCHEDULED RON, FWD ENTRY DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA022255Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA022232Slide · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA022225Slide · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA022224Slide · looseAFT SVC DOOR EMERGENCY EVAC SLIDE LOOSE IN CONTAINER. SECURED SLIDE PER MM.SDR SWAA022221Slide · looseFWD SVC DOOR EMERGENCY EVAC SLIDE LOOSE IN CONTAINER. SECURED SLIDE PER MM.SDR SWAA022195Slide · unserviceableDURING SCHEDULED RON CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA022191Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR MWEA020578Slide · defectiveTAILCONE EMERGENCY SLIDE WILL NOT DEPLOY WHEN TAILCONE IS DROPPED USING TAILCONE SLIDE. -- REMOVED TAILCONE PANEL, ADJUSTED FORWARD HOLD DOWN STRAP ON SLIDE COVER AND REINSTALLED TAILCONE.SDR SWAA022196Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT OF THE CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA022194Cable · misroutedDURING SCHEDULED C1 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED CABLE PER MM.SDR SWAA022172Slide · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA022171Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA022170Slide · unserviceableDURING SCHEDULED SERVICE CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR ASAA0280310Lanyard · disconnectedSEA - DURING PREFLIGHT CHECK, THE FORWARD SERVICE DOOR EMERGENCY SLIDE 'CLIP FELL OUT' LANYARD DISCONNECTED. REATTACHED LANYARD. (M)SDR SWAA022156Slide · unserviceableDURING SCHEDULED PM CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA022154Slide · out of positionDURING SCHEDULED C1 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA022151Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND BOTH SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSYS OUT OF ADJUST. ADJUSTED SLIDES PER MM.SDR SWAA022142Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST AND SLIDE CABLE MISROUTED. ADJUSTED SLIDE AND REROUTED CABLE PER MM.SDR SWAA022127Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. INSTALLED SLIDE PER MM.SDR SWAA022126Slide · looseFWD ENTRY DOOR EMERGENCY EVAC SLIDE LOOSE IN CONTAINER. SECURED SLIDE PER MM.SDR SWAA022130Slide · out of positionDURING SCHEDULED C1 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA022129Cable · misroutedDURING SCHEDULED C2 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED CABLE PER MM.SDR ASAA0280300Lanyard · detachedPDX - DURING PREFLIGHT CHECK, THE FORWARD DOOR EMERGENCY SLIDE 'ACTIVATION CABLE' LANYARD WAS FOUND TO BE LOOSE. REATTACHED LANYARD. (M)SDR AUS20021031Slide · faulty(AUS) ESCAPE SLIDE PACKING STRIP NOT REMOVED FOLLOWING OVERHAUL.PERSONNEL/MAINTENANCE ERROR.SDR DL76S021064Light · inoperative2L DOOR SLIDE LIGHT INOPERATIVE, RELAMPED - OPS NORMAL.SDR SWAA022116Slide · looseAFT SVC DOOR EMERGENCY EVAC SLIDE LOOSE IN CONTAINER. SECURED SLIDE PER MM.SDR SWAA022115Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA022114Cable · looseDURING SCHEDULED C1 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE CABLE LOOSE. SECURED SLIDE CABLE PER MM.SDR SWAA022113Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR USAASA02078Slide · shortedCLT - THE FORWARD EMERGENCY POWER SUPPLY UNIT INDICATED AN EXTERNAL LIGHT FAULT. MAINTENANCE REPLACED AN EMERGENCY POWER SUPPLY UNIT, HOWEVER, THE EXTERNAL LIGHT FAULT CONTINUED. THE FORWARD ESCAPE SLIDES WERE THEN REPLACED. SYSTEM OPERATIONALLY CHECKED OK.SDR DLM88021052Slide · dischargedFWD GALLEY DOOR SLIDE PRESSURE LOW . REPLACED SLIDE
Back to JASC 2565