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 SWAA022590Slide · deployedFWD SVC DOOR EMERGENCY EVAC SLIDE DEPLOYED WHILE OPENING DOOR. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA022586Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA022589Slide · out of positionDURING SCHEDULED C2 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA022588Slide · unserviceableDURING SCHEDULED RON, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA022570Cable · misroutedDURING SCHEDULED C1 CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE RELEASE CABLE MISROUTED. REROUTED CABLE PER MM.SDR SWAA022579Slide · out of positionDURING SCHEDULED C1 CHECK, FOUND FWD ENTRY DOOR EVACUATION SLIDE RELEASE CABLE FITTING TO COVER GAP OUT OF LIMITS. REPOSTIONED FITTING PER MM.SDR SWAA022578Slide · out of positionDURING SCHEDULED C1 CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE PRESSURE IND DATA PLATE OUT OF POSITION. REPOSTIONED DATA PLATE PER MM.SDR ASAA0280479Lanyard · disconnectedDURING PREFLIGHT CHECK LANYARD BETWEEN GIRT BAR AND SLIDE COVER WAS FOUND DISCONNECTED. REATTACHED LANYARD.SDR SWAA022567Slide · out of positionBOTH FWD CABIN DOOR EMERGENCY EVAC SLIDES PRESS IND OUT OF VIEW. REPOSITIONED SLIDES PER MM.SDR SWAA022558Slide · looseFWD SVC DOOR EMERGENCY EVAC SLIDE LOOSE IN CONTAINER. SECURED SLIDE PER MMSDR SWAA022553Cable · misroutedDURING SCHEDULED CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY CABLE MISROUTED. REROUTED CABLE PER MM.SDR SWAA022551Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER WHEN OPENING THE DOOR. REMOVED AND REPLACED SLIDE PER MM.SDR ASAA0280448Lanyard · disconnectedDURING PREFLIGHT CHECK LANYARD BETWEEN GIRT BAR AND SLIDE COVER WAS FOUND DISCONNECTED. REATTACHED LANYARD.SDR SWAA022550Slide · out of positionDURING SCHEDULED RON, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR 2002F00975Slide · deployedLEFT WING OFF WING ESCAPE SLIDE DEPLOYED. MAINTENANCE REMOVED AND REPLACED ESCAPE SLIDE IAW 757 AMM 25-65-01.SDR SWAA022534Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA022532Slide · unserviceableAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA022526Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA022531Slide · out of positionDURING SCHEDULED A2 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA022530Cable · misroutedDURING SCHEDULED C2 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT BAR CABLE MISROUTED. REROUTED CABLE PER MM.SDR ASAA0280404Harness · failedDURING C CHECK, FORWARD SERVICE DOOR EMERGENCY SLIDE HARNESS FAILED SYSTEM CHECK. REPLACED EMERGENCY SLIDE. SYSTEM CHECKED, OK.SDR SWAA022510Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA022509Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT OF THE CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA022520Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA022512Cable · misroutedDURING SCHEDULED C1 CHECK, FOUND AFT ENTRY AND FWD SVC DOOR EMERGENCY EVAC SLIDE CABLES MISROUTED. REROUTED CABLES PER MM.SDR SWAA022494Slide · out of positionDURING SCHEDULED PM CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR ASAA0280425Lanyard · disconnectedDURING PREFLIGHT CHECK, LANYARD BETWEEN GIRT BAR AND SLIDE COVER, BECAME DISCONNECTED. REATTACHED LANYARD.SDR SWAA022495Slide · looseFWD ENTRY DOOR EMERGENCY EVAC SLIDE VIEWING WINDOW LOOSE. SECURED VIEWING WINDOW PER MM.SDR SWAA022493Slide · out of positionDURING SCHEDULED C1 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA022492Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR UPS02839800Slide · inoperativeMAIN CABIN EXIT SLIDE INOP M247198. REPLACED SLIDE CONTAINER AND SLIDE PER MM-25-60-01SDR ASAA0280424Lanyard · disconnectedDURING PREFLIGHT CHECK, LANYARD BETWEEN GIRT BAR AND SLIDE COVER, BECAME DISCONNECTED. REATTACHED LANYARD.SDR USAABB02182Slide · malfunctionedPHL - DURING THE ANNUAL SLIDE OPERATIONAL CHECK OF THE L1 DOOR, THE SLIDE INFLATED BUT DEPLOYED IN A CROOKED MANNER. MAINTENANCE PERSONNEL STATED THE THE VELCRO ON THE LEFT SIDE OF THE SLIDE DID NOT RELEASE PROPERLY, FORCING THE SLIDE TO CANT TO THE RIGHT SIDSDR SWAA022456Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA022455Slide · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA022464Bracket · shearedDURING SCHEDULED C4 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT BAR HOOK BRACKET HAS 1 ATTACH RIVET SHEARED. REMOVED AND REPLACED RIVET PER SRM.SDR SWAA022488Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA022457Slide · out of positionAFT SVC DOOR EMERGENCY EVAC PRESS IND OUT OF VIEW AND VIEWING WINDOW LOOSE. REPOSITIONED SLIDE AND SECURED WINDOW PER MM.SDR SWAA022475Slide · unserviceableFWD ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA022444Slide · unserviceableFWD ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA022443Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT OF CONTAINER WHILE OPENING DOOR. REINSTALLED SLIDE PER MM.SDR SWAA022477Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA022476Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND BOTH FWD CABIN DOOR EMERGENCY EVAC SLIDE GIRT ASSY'S OUT OF ADJUST. ADJUSTED SLIDES PER MM.SDR 751PA0006SlideR3 door slide bottle pressure is low. R&R R3 door slide IAW 757MM 25-66-03.SDR P5CA0200704Slide · failedRIGHT UPPER DECK ESCAPE SLIDE DEPLOYED ACCIDENTLY, BUT DID NOT DEPLOY FULLY, AND DOOR BOTTLE DISCHARGED. SLIDE ASSY REMOVED & REPLACED PER 25-68-07, PG 601, DOOR AIR BOTTLE REMOVED & REPLACED PER MM 25-68-08 AND PRESSURE CARTRIDGE PER 52-23-15.SDR SWAA022441Cable · misroutedDURING SCHEDULED C4 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT CABLE MISROUTED. REROUTED CABLE PER MM.SDR SWAA022471Slide · out of positionFWD ENTRY DOOR EMERGENCY EXIT EVAC SLIDE INADVERTENTLY FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA022433Slide · out of positionDURING SCHEDULED A1 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA022432Slide · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA022438Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.
Back to JASC 2565