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 ASAA0180189Slide · failedOAK - DURING C-CHECK, AFT REAR DOOR EMERGENCY SLIDE HARNESS FAILED SYSTEM CHECK. REPLACED EMERGENCY SLIDE PER T/C 24653002. SYSTEM CHECKED OK. (M)SDR SWAA011645Slide · out of positionDURING SCHEDULED C4 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EMERGENCY EVAC SLIDE PER MM.SDR SWAA011644Slide · out of positionDURING SCHEDULED C1 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EMERGENCY EVAC SLIDE PER MM.SDR SWAA011640Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EMERGENCY EVAC SLIDE PER MM.SDR USAASA01021Slide · tornTPA - DURING AN OPERATIONAL TEST OF THE AFT RIGHT SERVICE DOOR EMERGENCY ESCAPE SLIDE, THE SLIDE DID NOT INFLATE DUE TO A LARGE TEAR IN THE SLIDE. MAINTENANCE REPLACED THE SLIDE. OK FOR SERVICE. (M)SDR C1HA200182008Slide · out of positionL-1 DOOR ESCAPE SLIDE FALLS OUT OF DOOR HOLDER. INSPECTED AND REINSTALLED, CKS GOOD.SDR SWAA011624Slide · unserviceableDURING SCHEDULED A1 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. Removed and replaced EMERGENCY EVAC SLIDE PER MM.SDR SWAA011612Slide · out of positionDURING SCHEDULED RON CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EMERGENCY EVAC SLIDE PER MM.SDR SWAA011606Slide · out of positionDURING SCHEDULED C3 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EMERGENCY EVAC SLIDE PER MM.SDR SWAA011610Slide · out of adjDURING SCHEDULED C2 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUSTMENT. ADJUSTED SLIDE ASSY PER MM.SDR SWAA011609Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA011600Slide · unserviceableAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED EMERGENCY EVAC SLIDE PER MM.SDR DL757010870Slide · deployed3R DOOR SLIDE DEPLOYED. REPLACED 3R DOOR SLIDE.SDR SWAA011597Slide · unserviceableDURING SCHEDULED RON CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED EMERGENCY EVAC SLIDE PER MM.SDR SWAA011594Screw · missingFWD ENTRY DOOR EMERGENCY EVAC SLIDE, SCREW MISSING FROM RETAINING HOLDER. INSTALLED SCREW PER MM.SDR SWAA011588Slide · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EMERGENCY EVAC SLIDE PER MM.SDR SWAA011584Slide · out of positionDURING SCHEDULED C4 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EMERGENCY EVAC SLIDE PER MM.SDR SWAA011576Slide · out of adjAFT SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUSTMENT. ADJUSTED AFT SVC DOOR EMERGENCY EVAC SLIDE ASSY PER MM.SDR SWAA011575Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EMERGENCY EVAC SLIDE PER MM.SDR AUS20010550Cable · out of adj(AUS) NO1 RH DOOR SLIDE FAILED TO DEPLOY DURING TEST. INVESTIGATION FOUND THE DOOR EMERGENCY POWER RESERVOIR FIRING CABLE OUT OFADJUSTMENT AND FAILING TO RUPTURE THE DISC OF THE EPS BOTTLE. THE EPS CABLE WAS ADJUSTED AND THE SLIDE DEPLOYED NORMALLY.SDR AUS20010549Cable · frayed(AUS) LH AND RH AFT MAIN ENTRY DOOR ESCAPE SLIDE RELEASE CABLES CONTAINED BROKEN STRANDS. FOUND DURING INSPECTION IAW AD/B737/42, FAA AD 90-12-11 AND EI 734-025-0086 REV09.SDR SWAA011577Slide · out of positionDURING SCHEDULED C3 CHECK, FOUND AFT ENTRY DOOR & AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS INDICATORS OUT OF VIEW. REPOSITIONED BOTH EMERGENCY EVAC SLIDES PER MM.SDR SWAA011574Slide · unserviceableDURING SCHEDULED SERVICE CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED EMERGENCY EVAC SLIDE PER MM.SDR C1HA200182007Slide · out of positionL-1 DOOR SLIDE COMES OUT OF CASING. SECURED SLIDE IN COVER PER 52-12-00.SDR C1HA200182005Slide · out of positionDURING FLIGHT L-1 DOOR SLIDE FELL ON FLOOR. REPACKED AND HUNG L-1 DOOR SLIDE.SDR SWAA011560Cable · frayedDURING SCHEDULED C1 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE GIRT BAR CABLE FRAYED. REMOVED AND REPLACED GIRT BAR CABLE PER MM.SDR SWAA011558Slide · out of adjFWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED EMERGENCY EVAC GIRT ASSY PER MM.SDR SWAA011557Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. INSTALLED EMERGENCY EVAC IN CONTAINER PER MM.SDR SWAA011553Slide · out of adjDURING SCHEDULED C3 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EMERGENCY EVAC SLIDE PER MM.SDR SWAA011552Slide · unserviceableDURING SCHEDULED SERVICE CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED EMERGENCY EVAC SLIDE PER MM.SDR SWAA011551Slide · deployedFWD ENTRY DOOR EMERGENCY EVAC SLIDE INADVERTENTLY DEPLOYED. REMOVED AND REPLACED EMERGENCY EVAC SLIDE PER MM.SDR SWAA011536Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EMERGENCY EVAC SLIDE PER MM.SDR SWAA011543Slide · out of adjDURING SCHEDULED C3 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUSTMENT. ADJUSTED EMERGENCY EVAC SLIDE GIRT ASSY PER MM.SDR SWAA011542Slide · out of adjDURING SCHEDULED C3 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE OUT OF ADJUSTMENT. ADJUSTED EMERGENCY EVAC SLIDE PER MM.SDR SWAA011538Slide · out of positionDURING SCHEDULED C1 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EMERGENCY EVAC SLIDE PER MM.SDR SWAA011537Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED EMERGENCY EVAC SLIDE PER MM.SDR SWAA011522Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED EMERGENCY EVAC SLIDE PER MM.SDR SWAA011513Slide · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EMERGENCY EVAC SLIDE PER MM.SDR SWAA011512Slide · out of adjFWD ENTRY & FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT BARS CONTACT DOOR FRAME WHEN DOORS ARE OPENED. REMOVED AND REPLACED EMERGENCY EVAC SLIDES AND CONTAINERS PER MM.SDR SWAA011523Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EMERGENCY EVAC SLIDE PER MM.SDR SWAA011504Slide · out of adjDURING SCHEDULED C4 CHECK, FOUND AFT ENTRY & AFT SVC DOORS EMERGENCY EVAC SLIDE GIRT ASSY OUT OF AJUSTMENT. ADJUSTED EMERGENCY EVAC SLIDE GIRT ASSY''''S PER MM.SDR SWAA011503Slide · out of adjDURING SCHEDULED C4 CHECK, FOUND FWD SVC & FWD ENTRY DOORS EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUSTMENT. ADJUSTED EMERGENCY EVAC SLIDE GIRT ASSY''S PER MM.SDR DL757010807Slide · out of positionEMERGENCY SLIDE COVER AT R1 DOOR FELL OFF. MAINTENANCE FOUND SLIDE COVER AND SLIDE SEPARATED FROM DOOR. MAINTENANCE REINSTALLED SLIDE AND COVER ONTO THE R1 DOOR. NO ONE PRESENT HAD AN EXPLANATION AS TO WHY THE SLIDE FELL OFF.SDR SWAA011505Slide · unserviceableFWD ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED EMERGENCY EVAC SLIDE PER MM.SDR SWAA011501Slide · out of positionDURING SCHEDULED A1 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EMERGENCY EVAC SLIDE PER MM.SDR SWAA011502Slide · out of adjDURING SCHEDULED C3 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUSTMENT. ADJUSTED EMERGENCY EVAC SLIDE GIRT ASSY PER MM.SDR SWAA011479Mount · looseDURING SCHEDULED C3 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE MOUNT LOOSE. SECURED MOUNT PER MM.SDR SWAA011478Slide · deployedAFT SVC DOOR EMERGENCY EVAC SLIDE INADVERTENTLY DEPLOYED. REMOVED AND REPLACED EMERGENCY EVAC SLIDE PER MM.SDR SWAA011477Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EMERGENCY EVAC SLIDE PER MM.SDR 2001UALA00782Tube · unserviceableSLIDE/RAFT D30665-105 TOP INFLATION TUBE RT SIDE SEAM FAILED DURING PROOF PRESSURE TEST. TOP TUBE HAS A 4 FOOT SEAM RIP ON RT SIDE ABOVE THE REDUCER BULKHEAD FROM THE FAILURE. UNIT IS BEING SENT TO THE VENDOR FOR REPAIR.
Back to JASC 2565