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 SWAA022975Cable · misroutedDURING SCHEDULED C1 CHECK, FOUND BOTH AFT ENTRY AND AFT SVC DOOR EMERGENCY EVAC SLIDE RELEASE CABLES MISROUTED. REROUTED CABLES PER MM.SDR SWAA022972Slide · out of positionDURING SCHEDULED C3 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR DLM90021448Bottle · dischargedFIRST CLASS GALLEY SLIDE BOTTLE PRESS IS LOW. REPLACED GALLEY DOOR SLIDE PER M/M SYCLED DOOR ARM AND DISARM OK.SDR SWAA022965Slide · looseDURING SCHEDULED C3 CHECK, FOUND AFT ENTRY DOOR EVACUATION SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA022964Cable · misroutedDURING SCHEDULED C3 CHECK, FOUND FWD ENTRY DOOR EVACUATION SLIDE RELEASE CABLE MISROUTED. REINSTALLED CABLE PER MM.SDR 2003UALA00044Slide · deployedRIGHT UPPER DECK SLIDE DEPLOYED IN THE AIRCRAFT. BOTH SLIDE BOTTLES FIRED. NO DEFECTS FOUND ON SLIDE BOTTLE REGULATORS. SAFETY BURST DISK IN TACT. NO CORROSION, MATERIAL FLAW OR DAMAGE FOUND ON RUPTURE DISK. SLIDE DESTROYED AS A RESULT OF DEPLOYMENT IN CABSDR SWAA022958Slide · wornDURING SCHEDULED C2 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE OUT OF POSITION AND GIRT ASSY WORN. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA022957Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA022945Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA022934Slide · out of positionDURING SCHEDULED RON, FWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA022947Slide · out of positionDURING SCHEDULED C2 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA022922Retainer · looseAFT ENTRY DOOR EMERGENCY EVAC SLIDE GIRT BAR RETAINER LOOSE. SECURED RETAINER PER MM.SDR SWAA022919Slide · out of positionDURING SCHEDULED SPECIAL VISIT, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA022923Slide · deployedFWD ENTRY DOOR EMERGENCY EVAC SLIDE DEPLOYED WHEN OPENING DOOR. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA022921Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SROM200200021Slide · tornDURING C CHECK INSPECTION WHILE PERFORMING L2 ESCAPE SLIDE TEST PER TASK CARD SLIDE DEPLOYED, INFLATED THEN DEFLATED BECAUSE OF TORN SEAM.SDR SWAA022917Slide · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR YENA200234Indicator · inoperativeRT OVERWING SLIDE ARMED INDICATION INOP. PLACED ON MEL 25-60-04. CLEANED PROX SWITCH. OPS CHECK GOOD IAW AMM 25-60-00.SDR SWAA022916Cable · frayedDURING SCHEDULED C1 CHECK, FOUND AFT ENTRY DOOR EVACUATION SLIDE CABLE FRAYED. REMOVED AND REPLACED CABLE PER MM.SDR SWAA022912Slide · looseDURING SCHEDULED C2 CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA022911Cable · misroutedDURING SCHEDULED C2 CHECK, FOUND FWD SERVICE DOOR EVACUATION SLIDE CABLE MISROUTED. REROUTED CABLE PER MM.SDR SWAA022895Cable · misroutedAFT SVC DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED CABLE PER MM.SDR SWAA022901Cable · misroutedDURING SCHEDULED C4 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED CABLE PER MM.SDR SWAA022891Slide · out of positionDURING SCHEDULED C4 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR ASAA0280623Lanyard · disconnectedSEA - DURING PREFLIGHT CHECK, LANYARD BETWEEN GIRT BAR AND SLIDE COVER WAS FOUND DISCONNECTED. REATTACHED LANYARD. (M)SDR SWAA022874Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA022873Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA022871Slide · out of positionDURING SCHEDULED RON, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR USAASA02105Flap · out of positionTHE SLIDE FOR DOOR L1 WOULD NOT REMAIN ARMED. MAINTENANCE REPOSITIONED THE GIRT FLAP ON THE GIRT BAR TO ELIMINATE FRICTION. THE SLIDE ARMING OF THE L1 DOOR NOW OPERATIONALLY CHECKS OK.SDR SWAA022870Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA022868Cable · misroutedDURING SCHEDULED C2 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED CABLE PER MM.SDR SWAA022864Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA022855Cable · misroutedDURING SCHEDULED C2 CHECK, FOUND AFT ENTRY DOOR EVACUATION SLIDE CABLE MISROUTED. REROUTED SLIDE CABLE PER MM.SDR SWAA022853Bracket · looseDURING SCHEDULED 1/4D CHECK, FOUND FWD ENTRY DOOR GIRT BAR BRACKETS LOOSE. SECURED BRACKETS PER MM.SDR ASAA0280622Lanyard · detachedSJC - DURING PREFLIGHT CHECK, L2 DOOR EMERGENCY SLIDE LANYARD WAS FOUND TO BE DETACHED. REATTACHED LANYARD. (M)SDR SWAA022852Slide · looseDURING SCHEDULED C3 CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE PRESSURE INDICATOR OUT OF ADJUSTMENT. ADJUSTED SLIDE PER MM.SDR SWAA022849Slide · looseDURING SCHEDULED C2 CHECK, FOUND BOTH AFT DOOR EVACUATION SLIDE PRESSURE INDICATORS OUT OF VIEW. REPOSITIONED BOTH AFT DOOR SLIDES PER MM.SDR SWAA022844Cable · misroutedDURING SCHEDULED C2 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED CABLE PER MM.SDR SWAA022836Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR U30A200200031Slide Raft · failedDURING A PLANNED INTENTIONAL DEPLOYMENT OF THE LEFT AFT (L2) SLIDE / RAFT ASSY, THE SLIDE / RAFT ASSY FAILED TO DEPLOY PROPERLY. FULL INFLATION AND DEPLOYMENT WAS NOT ACHIEVED. NOTE: THE DOOR ASSIST BOTTLE PRESSURE AND THE SLIDE / RAFT BOTTLE PRESSURE WERE VERSDR SWAA022835Slide · misroutedDURING SCHEDULED C2 CHECK, FOUND BOTH FWD ENTRY AND AFT SVC DOOR EMERGENCY EVAC SLIDE CABLES MISROUTED. REROUTED CABLES PER MM.SDR SWAA022817Bracket · looseDURING SCHEDULED C3 CHECK, FOUND LOOSE FASTENER AT FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT BAR ATTACH BRACKET. REMOVED AND REPLACED FASTENER PER SRM.SDR SWAA022816Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA022815Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA022812Slide · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA022814Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA022813Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND BOTH CABIN ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY'S OUT OF ADJUST. ADJUSTED SLIDES PER MM.SDR SWAA022831Slide · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT OF CONTAINER WHEN OPENING DOOR. REINSTALLED SLIDE PER MM.SDR SWAA022806Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA022803Retainer · looseDURING SCHEDULED C2 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT BAR RETAINER LOOSE. SECURED RETAINER PER MM.
Back to JASC 2565