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 SWAA021676Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF THE CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA021670Slide · out of positionDURING SCHEDULED RON, FWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF THE CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA021668Bracket · looseFWD SVC DOOR EMERGENCY EVAC SLIDE LOOSE. SECURED SLIDE SUPPORT BRACKET PER MM.SDR SWAA021659Slide · deployedFWD ENTRY DOOR EMERGENCY EVAC SLIDE DEPLOYED. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA021650Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA021649Slide · unserviceableDURING SCHEDULED RON, FOUND BOTH SVC DOOR EMERGENCY EVAC SLIDE PRESS INDICATORS OUT OF LIMITS. REMOVED AND REPLACED BOTH SVC DOOR SLIDES PER MM.SDR SWAA021647Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA021663Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA021661Slide · out of positionDURING SCHEDULED C4 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA021620Slide · out of positionDURING SCHEDULED C3 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR AWXA200200646Cover · delaminatedPHX - EMERGENCY ESCAPE EQUIPMENT - DURING POST FLIGHT INSPECTION THE EDGE OF THE LT OVERWING DUAL LANE SLIDE COVER WAS FOUND DELAMINATING. MAINTENANCE REMOVED AND REPLACED THE LT OVERWING ESCAPE SLIDE PACK ASSEMBLY IAW T/C R1A25301.SDR SWAA021622Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA021621Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA021605Slide · unserviceableAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR USAASA02065Slide · bulgedTHE AFT LEFT SLIDE COVER WILL NOT STAY ON. MAINTENANCE FOUND THE AFT LEFT SLIDE LACING LOOSENED UP AND SLIDE BULGING, NOT ALLOWING SLIDE COVER TO STAY ON. REPLACED THE AFT LEFT SLIDE ASSEMBLY. OK FOR SERVICE.SDR SWAA021608Slide · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER WHEN DOOR WAS OPENED. REINSTALLED SLIDE PER MM.SDR SWAA021597Slide · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA021598Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA021594Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA021601Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR UPS02838815Slide · out of positionINSPECTION TYPE:N/A ESCAPE SLIDE GIRT BAR WOULD NOT ENGAGE. REPACKED AND INSTALLED EVACUATION SLIDE ON MAIN CABIN DOOR IAW DC8-MM 25-60-01.SDR ASAA0280223Lanyard · disconnectedPHX - DURING PRE-FLIGHT CHECK, THE AFT SERVICE DOOR EMERGENCY SLIDE LANYARD WAS FOUND TO BE DETACHED. REATTACHED LANYARD. (M)SDR SWAA021570Slide · out of positionDURING SCHEDULED C3 CHECK, FOUND BOTH AFT CABIN DOOR EMERGENCY EVAC SLIDE PRESS IND'S OUT OF VIEW. REPOSITIONED SLIDES PER MM.SDR SWAA021565Nut Plate · missingDURING SCHEDULED RON, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE CONTAINER ATTACH NUT PLATE MISSING. INSTALLED NUT PLATE AND REINSTALLED SLIDE PER MM.SDR SWAA021562Slide · deployedFWD ENTRY DOOR EMERGENCY EVAC SLIDE INADVERTENTLY DEPLOYED AT GATE. REMOVED AND REPLACED SLIDE PER MM.SDR AALA20021003Bottle · dischargedORD - R1 DOOR SLIDE BOTTLE INDICATES ZERO PSI. REPLACED SLIDE ASSEMBLY. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR SWAA021569Slide · looseAFT SVC DOOR EMERGENCY EVAC SLIDE LOOSE IN CONTAINER. SECURED SLIDE PER MM.SDR SWAA021547Slide · unserviceableFWD ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR 0202329943Slide · malfunctionedTAIL CONE WAS ACCIDENTALLY DROPPED AND THE EVACUATION SLIDE DID NOT DEPLOY. MAINTENANCE REINSTALLED THE SLIDE AND CHECKED THE INSTALLATION. ALSO, THE DAMAGE TO THE TAIL CONE WAS TEMPORARILY REPAIRED TO ALLOW THE AIRCRAFT TO BE FERRIED TO MEM.SDR SWAA021545Cable · misroutedDURING SCHEDULED C1 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE GIRT BAR CABLE MISROUTED. REROUTED GIRT BAR CABLE PER MM.SDR SWAA021548Slide · looseDURING SCHEDULED RON, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE LOOSE IN CONTAINER. SECURED SLIDE PER MM.SDR SWAA021540Slide · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF THE CONTAINER. REINSTALLED SLIDE PER MM.SDR ASAA0280221Lanyard · disconnectedBUR - DURING PREFLIGHT CHECK, THE L1 DOOR EMERGENCY SLIDE LANYARD WAS FOUND TO BE DETACHED. REATTACHED LANYARD. (M)SDR TSAA0225160Slide · defectiveDURING A ROUTINE TRAINING EXERCISE AND AFTER SUCCESSFUL SLIDE DEPLOYMENT, THE SLIDE ASSEMBLY EXPLODED AT THE SEAM. NO HARM TO PERSONNEL. REMOVED AND REPLACED SLIDE; CONTINUED WITH EXERCISE. SLIDE SENT TO VENDOR FOR EVALUATION.SDR ZW0A0207301SlideTHE RIGHT SIDE FWD CABIN DOOR EVACUATION SLIDE BOTTLE PRESSURE WAS LOW. REPLACED THE SLIDE. CHECK-C 11-29-01 MCI. --CLOSED--SDR GTIA020786Lanyard · missingFLL - LS DOOR EVACUATION SLIDE LANYARD ASSEMBLY MISSING. INSTALLED LANYARD ASSY ON L2 EVACUATION SLIDE IAW MD80 MM 25-62-00. (M)SDR SWAA021532Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND BOTH FWD CABIN DOOR EMERGENCY EVAC SLIDE GIRT BAR ASSY'S OUT OF ADJUST. ADJUSTED BOTH FWD SLIDES PER MM.SDR SWAA021528Slide · unserviceableDURING SCHEDULED SERVICE CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA021517Cable · disconnectedDURING SCHEDULED C3 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT BAR LANYARD CABLE DISCONNECTED. CONNECTED CABLE PER MM.SDR SWAA021529Slide · out of positionDURING SCHEDULED PM CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR USAASA02061Slide · malfunctionedDCA - THE RIGHT OVERWING EMERGENCY EXIT SLIDE INDICATES DISARMED. MAINTENANCE ARMED THE RIGHT OVERWING EMERGENCY EXIT SLIDE. OK FOR SERVICE. (M)SDR SWAA021495Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF THE CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA021494Slide · out of positionDURING SCHEDULED SERVICE CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA021491Slide · unserviceableDURING SCHEDULED A2 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA021496Slide · deployedFWD SVC DOOR EMERGENCY EVAC SLIDE INADVERTENTLY DEPLOYED. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA021482Slide · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA021460Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA021459Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA021446Slide · unserviceableDURING SCHEDULED PM CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA021457Slide · out of positionDURING SCHEDULED SERVICE CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.
Back to JASC 2565