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 SWAA020282Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF THE CONTAINER AFTER LANDING. REINSTALLED SLIDE PER MM.SDR SWAA020261Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY LENGTH OUT OF ADJUST. ADJUSTED GIRT ASSY PER MM.SDR SWAA020248Clip · looseDURING SCHEDULED C4 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT BAR AFT RETAINER CLIP LOOSE. SECURED CLIP PER MM.SDR 2002UALA00183Slide · defectiveDURING EMERGENCY LIGHT TEST EXTERIOR LOAD AFT L MESSAGE WAS DISPLAYED. THE FAILURE MESSAGES INCLUDED COMM EMERGENCY R, EMERGENCY L, COMM AFT L, EXT LOADS AFT L. MOVED THE 2L SLIDE TO 2R TO ISOLATE THE PROBLEM. THEN REPLACED THE 2R SLIDE TO FIX THE PROBLEM ASDR SWAA020243Bracket · corrodedDURING SCHEDULED 1/4D CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT BAR AFT FLOOR BRACKET CORRODED. REMOVED AND REPLACED GIRT BAR BRACKET PER MM.SDR SWAA020232Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR AUS20020080Lanyard · incorrect(AUS) ESCAPE SLIDE LANYARD INCORRECT LENGTH.SDR SWAA020213Slide · out of positionDURING SCHEDULED C3 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA020193Slide · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF THE CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA020191Slide · unserviceableFWD ENTRY DOOR EVACUATION SLIDE PRESS INDICATOR LOW. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA020194Slide · unserviceableFWD ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA020212Slide · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA020197Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY LENGTH OUT OF ADJUST. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA020211Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA020195Slide · out of positionDURING SCHEDULED RON, FWD SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA020187Bracket · corrodedDURING SCHEDULED 1/2D CHECK, FOUND L1 DOOR EVACUATION SLIDE ATTACHED BRACKET CORRODED. REMOVED AND REPLACED BRACKET PER SRM.SDR SWAA020196Slide · out of positionDURING SCHEDULED RON, FWD SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF THE CONTAINER. REINSTALLED SLIDE PER MM.SDR ASAA0280011Lanyard · disconnectedSEA - DURING DISARMING OF R-1 SLIDE (IE UNCLIPPING AND STOWING GIRT BAR), LANYARD BETWEEN GIRT BAR AND SLIDE COVER BECAME DISCONNECTED. REATTACHED LANYARD. (M)SDR SWAA020153Slide · out of positionDURING SCHEDULED C3 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA020151Slide · unserviceableDURING SCHEDULED C1 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA020135Slide · defectiveFWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA020142Slide · out of positionDURING SCHEDULED C2 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA020137Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF THE CONTAINER WHEN DOOR CLOSED. REINSTALLED SLIDE PER MM.SDR SWAA020128Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF THE CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA020123Slide · out of adjDURING SCHEDULED C4 CHECK, FOUND BOTH AFT CABIN DOOR EMERGENCY EVAC SLIDES GIRT ASSY OUT OF ADJUST. ADJUSTED BOTH AFT SLIDES PER MM.SDR SWAA020122Hook · looseDURING SCHEDULED C1 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT BAR HOOK LOOSE. SECURED HOOK PER MM.SDR SWAA020116Girt Bar · out of adjDURING SCHEDULED C1 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED GIRT ASSY PER MM.SDR SWAA020108Slide · out of positionDURING SCHEDULED C1 CHECK, FOUND BOTH AFT CABIN DOOR EMERGENCY EVAC SLIDES PRESS IND OUT OF VIEW. REPOSITIONED SLIDES PER MM.SDR SWAA020084Slide · out of positionDURING SCHEDULED C3 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR DLM88030054Slide · deployedDURING CATERING OF SHIP 911 FOR FLT 1444/14, THE R1 DOOR SLIDE WAS DEPLOYED. CATERING STATES THAT WHEN THE DOOR WAS OPENED THE GIRT BAR CAUGHT ON THE INSIDE OF THE DOOR FRAME, HINGE SIDE PULLED THE SLIDE FROM THE BUSSLE WHERE IT THEN FELL ON TO THE CATERING SDR SWAA020074Slide · out of adjDURING SCHEDULED C2 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA020073Slide · out of adjAFT SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA020067Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA020060Bracket · looseDURING SCHEDULED C3 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT BAR CLIP BRACKETS LOOSE. TIGHTENED BRACKETS PER MM.SDR SWAA020059Slide · out of adjDURING SCHEDULED C3 CHECK, FOUND BOTH FWD CABIN DOOR EMERGENCY EVAC SLIDES OUT OF ADJUST. ADJUSTED SLIDES PER MM.SDR SWAA020042Slide · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA020034Slide · out of adjDURING SCHEDULED C1 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT PLAY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR ASAA0210001Cable · out of adjustANC - DURING MAINTENANCE CHECK, FOUND GIRT BAR DIFFICULT TO ARM AND DISARM. ADJUSTED CABLE AND LATCH ASSEMBLY THEN GIRT BAR ARMED NORMALLY. (M)SDR SWAA020055Slide · out of positionDURING SCHEDULED BC2 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR ZW0A0210301SlideON THE GROUND THE RIGHT SIDE NUMBER 1 CABIN DOOR ESCAPE SLIDE PARTIALLY DEPLOYED AFTER THE SLIDE WAS NOT DISARMED. THE AIRCRAFT OPERATED ONE LEG PER MEL AND THE SLIDE WAS THEN REPLACED. CHECK-C 9-23-00 LAX. --OPEN--SDR SWAA020006Slide · out of adjDURING SCHEDULED C3 CHECK, FOUND FWD SVC AND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT PLAY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR GTIA012166Bottle · lowDTW - AFT EVAC SLIDE BOTTLE PRESSURE LOW. REMOVED AND REPLACED AFT EVAC, SLIDE AS REQUIRED IAW MD80 MM 25-62-00. (M)SDR USAASA01073Bottle · lowCLT - FLT 61 EN ROUTE CLT-LGA, DURING PUSHBACK, A CABIN INTERCOMMUNICATION DATA SYSTEM WARNING CAME ON FOR AN OVERWING SLIDE BOTTLE. FLIGHT PUSHED BACK TO GATE. MAINTENANCE REPLACED THE LEFT OVERWING ESCAPE SLIDE BOTTLE. SYSTEM CHECKS GOOD. (M)SDR SWAA013427Slide · looseFWD ENTRY DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR ASAA0180317Lanyard · detachedPDX - DURING PREFLIGHT CHECK, L-1 DOOR EMERGENCY SLIDE GIRT BAR-TO-LATCH LANYARD WAS FOUND DETACHED. REATTACHED LANYARD. (M)SDR CALA0101043Slide · failedTHE L-1 DOOR SLIDE FAILED EMERGENCY SLIDE LIGHT TEST. THE SLIDE WAS REMOVED AND REPLACED IAW WORK CARD 08-2560-1-4300.SDR CALA0101042Slide · failedTHE R-1 DOOR SLIDE FAILED EMERGENCY SLIDE LIGHT TEST. THE SLIDE WAS REMOVED AND REPLACED IAW WORK CARD 08-2560-1-4300.SDR SWAA013419Slide · deployedFWD SERVICE DOOR EVACUATION SLIDE INADVERTATLYDEPLOYED. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA013417Slide · looseFWD ENTRY DOOR EVACUATION SLIDE FALLING OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR SWAA013414Slide · out of adjDURING SCHEDULED C2 CHECK, FOUND AFT ENTRY DOOR EVACUATION SLIDE OUT OF ADJUST. ADJUSTED SLIDE ASSY PER MM.
Back to JASC 2565