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 SWAA030506Slide · unserviceableDURING SCHEDULED C2 CHECK, FOUND FWD SERVICE DOOR EVACUATION SLIDE PRESSURE INDICATION LOW. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA030504Cover · looseAFT ENTRY DOOR EVACUATION SLIDE COVER LOOSE. SECURED SLIDE COVER PER MM.SDR SWAA030501Cable · misroutedDURING SCHEDULED C3 CHECK, FOUND FWD ENTRY DOOR EVACUATION SLIDE RELEASE CABLE MISROUTED. REROUTED SLIDE RELEASE CABLE PER MM.SDR SWAA030495Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND BOTH ENTRY DOOR EVACUATION SLIDES OUT OF ADJUST. REPOSITIONED BOTH SLIDES PER MMSDR SWAA030490Bracket · corrodedDURING SCHEDULED D CHECK, FOUND FWD ENTRY DOOR EVACUATION SLIDE BIRT BAR ATTACH FLOOR BRACKETS CORRODED. REMOVED AND REPLACED BRACKETS PER SRM.SDR SWAA030483Slide · out of adjustAFT SERVICE DOOR EVACUATION SLIDE PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA030481Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE ASSY LOOSE. ADJUSTED SLIDE PER MM.SDR SWAA030471Slide · out of positionFWD SERVICE DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA030470Slide · looseFWD SERVICE DOOR EVACUATION SLIDE ASSY LOOSE. ADJUSTED SLIDE ASSY PER MM.SDR MEX2003055Girt Bar · stuckAIRCRAFT RETURNED TO PLATFORM DUE TO LEFT AFT SLIDE DOOR NR 4 WAS NOT ARMED, ARMED AND DISARMED SYSTEM, AFT SLIDE DOOR 4 WAS CHECKED AND IT WAS STUCK. AIRCRAFT WAS SENT TO THE HANGAR. EMERGENCY MECHANISM WAS ADJUSTED IAW MM, TEST CORRECT.SDR SWAA030494Cover · looseAFT ENTRY DOOR EVACUATION SLIDE COVER LOOSE. SECURED EVACUATION SLIDE COVER PER MM.SDR SWAA030464Slide · out of adjustAFT SVC DOOR EMERGENCY EVAC SLIDE ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA030461Slide · unserviceableDURING WALK AROUND INSP, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA030455Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND BOTH FWD CABIN DOOR EMERGENCY EVAC SLIDE ASSY'S OUT OF ADJUST. ADJUSTED SLIDE ASSY'S PER MM.SDR SWAA030456Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA030442Cable · misroutedDURING SCHEDULED C3 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED CABLE PER MM.SDR SWAA030454Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA030453Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND ALL CABIN DOOR EMERGENCY EVAC SLIDE ASSY'S OUT OF ADJUST. ADJUSTED SLIDES PER MM.SDR SWAA030452Bracket · looseDURING SCHEDULED C3 CHECK, FOUND BOTH FWD CABIN DOOR EMERGENCY EVAC SLIDE GIRT BAR ATTACH BRACKETS LOOSE. SECURED ATTACH BRACKETS PER MM.SDR UPS03840246Bottle · dischargedESCAPE SLIDE AIR PRESSURE GAUGE IN THE RED. EMERGENCY ESCAPE SLIDE CYLINDER PRESSURE WITHIN SERVICEABLE LIMITS PER MM 25-60-01 TEMPERATURE COMPENSATION CHART.SDR UPS03140247Bottle · dischargedMAIN CABIN DOOR SLIDE LOW PRESSURE DEF M255139. REPLACED MAIN CABIN DOOR SLIDE W/REF TO AMM 25-61-21--401. SATISFACTORY TAG 779646.SDR SWAA030445Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA030443Cable · damagedDURING SCHEDULED C4 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE CABLE DAMAGED. REMOVED AND REPLACED SLIDE CABLE PER MM.SDR SWAA030439Bracket · misinstalledAFT SVC DOOR EMERGENCY EVAC SLIDE GIRT BAR FLOOR HOLD DOWN BRACKET INSTALLED BACKWARD. INSTALLED FLOOR BRACKET CORRECTLY PER MM.SDR UPS03840238Slide · looseESCAPE SLIDE NOT SECURE AND GIRT BAR NOT TOTALLY IN SLIDE SLEEVE. SECURED ESCAPE SLIDE TO BRACKET WITH CAMLOCK FASTENER. REPOSITIONED GIRT BAR IN SLIDE SLEEVE. OK TO CONTINUE.SDR SWAA030431Slide · out of positionDURING SCHEDULED RON, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA030414Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA030410Slide · unserviceableDURING SCHEDULED A1 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA030409Fitting · looseAFT ENTRY DOOR EMERGENCY EVAC SLIDE GIRT BAR FLOOR FITTING LOOSE. SECURED GIRT BAR FITTING PER MM.SDR SWAA030436Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA030429Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA030413Slide · out of adjustDURING SCHEDULED BC4 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA030412Cable · misroutedDURING SCHEDULED C1 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED CABLE PER MM.SDR AWXA200300198Control Cable · brokenDURING C-04 CHECK THE LT OVER WING ESCAPE SLIDE RESERVOIR BOTTLE FLEXIBLE CONTROL CABLE ASSEMBLY WAS FOUND TO HAVE A BROKEN END FITTING. MAINTENANCE REMOVED AND REPLACED THE LT OVER WING ESCAPE SLIDE RESERVOIR BOTTLE.SDR SWAA030395Slide · out of positionDURING SCHEDULED C4 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA030391Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR AMTA200300224Slide · deployedL1 DOOR SLIDE INADVERTANTLY SEMI-DEPLOYED BY CONTRACT COMPANY. REMOVED AND REPLACED L1 DOOR SLIDE IAW MM 25-61-01A, OPS CHECK NORMAL. (M)SDR GTIA030168Lanyard · brokenLT 1 DOOR EVACUATION SLIDE LANYARD BROKEN. REMOVED BROKEN LANYARD. REPLACED L1 DOOR EVACUATION SLIDE LANYARD.SDR ASAA0380132Lanyard · disconnectedSEA - DURING LINE CHECK, FOUND EMERGENCY SLIDE LANYARD 'NOT ROOTED' (DISCONNECTED) AT AFT LEFT SERVICE L-2 DOOR. 'ROOTED', REATTACHED, LANYARD. (M)SDR SWAA030358Cable · misroutedDURING SCHEDULED C1 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED CABLE PER MM.SDR SWAA030357Slide · out of positionDURING SCHEDULED C1 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA030353Slide · missingFWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT BAR SPACER BUSHINGS MISSING. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA030355Slide · out of positionDURING SCHEDULED C4 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR ASAA0380128Lanyard · disconnectedLAX - DURING PREFLIGHT CHECK, FOUND RIGHT FORWARD (R-1) SERVICE DOOR GIRT-TO-SLIDE COVER LANYARD DISCONNECTED. REATTACHED LANYARD. (M)SDR SWAA030333Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA030342Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA030326Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. REMOVED AND REPLACED SLIDE GIRT ASSY PER MM.SDR SWAA030323Slide · deployedFWD SVC DOOR EMERGENCY EVAC SLIDE INADVERTENTLY DEPLOYED. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA030322Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA030304Slide · unserviceableFWD ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.
Back to JASC 2565