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 SWAA020476Slide · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA020445Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA020444Bracket · looseDURING SCHEDULED C1 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR FLOOR ATTACH BRACKET LOOSE. SECURED BRACKET PER MM.SDR SWAA020438Slide · out of positionAFT SERVICE DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA020437Slide · frayedDURING SCHEDULED C4 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY FRAYING AT ROD ENDS. REMOVED AND REPLACED SLIDE PER MM.SDR YENA200205Slide · unserviceableR2 DOOR EMERGENCY SLIDE INDICATED LOW PRESSURE. REMOVED AND REPLACED R2 DOOR SLIDE IAW AMM CHAP 25-62-44.SDR SWAA020473Slide · out of adjustFWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR 02022701Pin · bindingWHILE OPENING LEFT OVERWING EXIT DURING C-CHECK THE SLIDE WAS INADVERTENTLY DEPLOYED DUE TO IMPROPER DE-ARMING PROCEDURES. SLIDE DID NOT PROPERLY DEPLOY DUE TO RETAINING PIN NOT RELEASING. SLIDE ASSEMBLY SENT OUT FOR OVERHAUL.SDR UPS02837729Fabric · frayedINSPECTION TYPE:PFLT EMERGENCY ESCAPE SLIDE GIRT BAR HAS FABRIC ATTACHMENT FRAYING. REMOVED AND REPLACED SLIDE.SDR AALA20020168Slide · failedLHR - FLT 87 - PRIOR TO DEPARTURE R-2 DOOR SLIDE INADVERTENTLY DEPLOYED WHEN OPENING DOOR FROM OUTSIDE. SLIDE FAILED TO INFLATE DUE TO LOW PRESSURE. REPLACED SLIDE ASSEMBLY AND RESERVOIR. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR ASAA0280053Lanyard · disconnectedSEA - DURNIG PRE-FLIGHT CHECK, R-1 DOOR EMERGENCY SLIDE LANYARD WAS FOUND TO BE DETACHED. REATTACHED LANYARD. (M)SDR AUS20020129Washer · missing(AUS) ESCAPE SLIDE DEPLOYMENT BAR AFT LINK WASHER MISSING. FOUND DURING INSPECTION IAW AD/B767/163 AND FAA AD 2001-26-19.SDR SWAA020412Slide · deployedFWD ENTRY DOOR EMERGENCY EVAC SLIDE DEPLOYED AT GATE. REMOVED AND REPLACED SLIDE AND CASE PER MM.SDR SWAA020399Slide · out of positionDURING SCHEDULED RON, FOUND AFT SERVICE DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA020400Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA020393Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR AT0200011Slide · defectiveR1 DOOR SLIDE GIRTH BAR WAS NOT SECURED AFTER FLIGHT AND SLIDE WAS DEPLOYED BY CLEANERS WHEN R1 DOOR OPENED. SLIDE WAS REPLACED 2ND TIME DUE TO FIRST SLIDE FACE PLATE ROTATED AND BAD FROM STOCK. REMOVED AND REPLACED SLIDE.SDR SWAA020378Slide · looseFWD SVC DOOR EMERGENCY EVAC SLIDE NOT SECURED IN CONTAINER. SECURED SLIDE PER MM.SDR SWAA020361Slide · unserviceableAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND LOW AND OUT OF VIEW. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA020365Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA020360Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MMSDR SWAA020354Slide · out of positionFWD SERVICE DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER INADVERTENTLY. REINSTALLED SLIDE PER MM.SDR SWAA020348Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND BOTH FWD CABIN DOOR EMERGENCY EVAC SLIDE GIRT ASSY'S OUT OF ADJUST. ADJUSTED SLIDES PER MM.SDR SWAA020347Bracket · looseDURING SCHEDULED 1/4D CHECK, FOUND LOOSE FASTENER, AT AFT SVC DOOR EMERGENCY EVAC SLIDE ATTACH BRACKET. SECURED BRACKET PER MM.SDR SWAA020352Slide · out of positionDURING SCHEDULED C4 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA020351Window · crackedDURING SCHEDULED C1 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND VIEWING WINDOW CRACKED. REMOVED AND REPLACED WINDOW PER MM.SDR SWAA020350Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA020346Slide · unserviceableFWD SVC DOOR EMERGENCY EVAC SLIDE PRESS INDICATOR LOW. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA020336Slide · out of positionDURING SCHEDULED C3 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA020339Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE ASSY PER MM..SDR SWAA020337Slide · out of positionDURING SCHEDULED C4 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA020324Slide · lowFWD ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND LOW. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA020316Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE ASSY PER MM.SDR SWAA020311Slide · out of positionDURING SCHEDULED CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA020310Bracket · missingDURING SCHEDULED C4 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY AFT BRACKET MISSING FASTENER. INSTALLED FASTENER PER MM.SDR SWAA020309Slide · looseDURING SCHEDULED C4 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE LOOSE. SECURED SLIDE PER MM.SDR SWAA020302Slide · unserviceableDURING SCHEDULED A2 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA020301Slide · looseFWD SVC DOOR EMERGENCY EVAC SLIDE LOOSE IN CONTAINER. SECURED SLIDE PER MM.SDR SWAA020299Bracket · brokenAFT SVC DOOR EMERGENCY EVAC SLIDE DOOR RETAINING BRACKET BROKEN. REPAIRED BRACKET PER MM.SDR SWAA020290Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED GIRT ASSY PER MM.SDR AT0200007Slide · out of positionGIRT BAR WOULD NOT LATCH AT R1 DOOR. REPOSITIONED SLIDE AT R1 DOOR.SDR AT0200009Slide · out of positionL1 DOOR SLIDE FELL ONTO JET WAY. REINSTALLED SLIDE.SDR SWAA020297Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED GIRT ASSY PER MM.SDR SWAA020281Slide · unserviceableAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND LOW. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA020284Bracket · looseDURING SCHEDULED C2 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR HOLDER LOOSE. SECURED GIRT BAR HOLDER PER MM.SDR SWAA020270Slide · unserviceableFWD SERVICE DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA020272Cable · misroutedDURING SCHEDULED C1 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED CABLE PER MM.SDR SWAA020271Slide · out of positionFWD SERVICE DOOR EMERGENCY EVAC SLIDE GIRT BAR DRAGGED AND PULLED SLIDE OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR UPS02M37560Slide · departedINSPECTION TYPE:N/A RT FWD ENTRY DOOR ESCAPE SLIDE DEPLOYED. REMOVED AND REPLACED R1 EVACUATION SLIDE/RAFT ASSY IAW MM 25-61-01.SDR SWAA020257Slide · out of positionDURING SCHEDULED C2 CHECK, FOUND BOTH AFT CABIN DOOR EMERGENCY EVAC SLIDE PRESS IND'S OUT OF VIEW. REPOSITIONED SLIDES PER MM.
Back to JASC 2565