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 SWAA001999Bottle · dischargedFWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND LOW. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA001992Indicator · out of positionDURING SCHEDULED C1 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. RE-ADJUSTED SLIDE ASSY PER MM.SDR SWAA001981Indicator · out of positionDURING SCHEDULED C2 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. ADJUSTED SLIDE ASSY PER MM.SDR SWAA001988Cable · misroutedDURING SCHEDULED C1 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE CABLE MIS-ROUTED. ROUTED AFT SVC DOOR SLIDE CABLE PER MM.SDR ASAA0080638Lanyard · disconnectedSEA PRIOR TO FLIGHT 571 THE L1 DOOR SLIDE LANYARD WAS FOUND TO BE DETACHED. RECLIPPED THE L1 DOOR LANYARD.SDR SWAA001953Nut · looseDURING SCHEDULED C2 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE MOUNT BOLT LOOSE AND WORN. REMOVED AND REPLACED ANCHOR NUT PER MM.SDR SWAA001957Bottle · dischargedDURING SCHEDULED A2 CHECK, FOUND FWD ENTRY EMERGENCY EVAC SLIDE PRESSURE IND BELOW LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR 2000UALA00586Tube · leakingMR25716-505, (P/N 62773-317), EVACUATION SLIDE/RAFT DOOR 3 LT FAILED AIR RETENTION TEST DURING ROUTINE SHOP OVERHAUL. UNIT HAS A SEAM LEAK IN THE LOWER TUBE OF THE INFLATABLE. PROBABLE CAUSE OF THE SEAM LEAK WAS A MANUFACTURING DEFECT. LOWER TUBE HAD A WRINSDR SWAA001952Girt Bar · out of adjDURING SCHEDULED C2 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE OUT OF ADJUSTMENT. ADJUSTED GIRT ASSY PER MM.SDR 2000UALA00580Tube · tornP/N 7A1479-13 EVACUATION SLIDE/RAFT DOOR 2 LT FAILED FLAT FIRE TEST IN HOME SHOP DURING SLIDE/RAFTS ROUTINE OVERHAUL. UPPER TUBE DEVELOPED A TEAR IN THE LT UPPER CROSSOVER TUBE AT THE BOTTOM CORNER. THE CAUSE OF THE TEAR APPEARS TO BE DAMAGE TO THE TUBE MATESDR 0003725645Rod End · brokenDURING MAINTENANCE CHECK, FOUND THE NR 4 LEFT DOOR GIRT BAR OPERATING MECHANISM ROD END BROKEN OFF AT FOWARD SIDE OF DOOR. MAINTENANCE REPLACED THE ROD END AND ADJUSTED THE DOOR. OPERATIONAL CHECK OK.SDR SWAA001946Slide · dislodgedFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR SWAA001944Indicator · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY ASSY PER MM.SDR SWAA001940Bracket · corrodedDURING SCHEDULED D-CHECK, FOUND FWD ENTRY DOOR GIRT BAR FLOOR BRACKET ATTACHMENT PLATES CORRODED AT BS 312 & 344, LBL 50.SDR SWAA001937Indicator · out of positionDURING SCHEDULED A1 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER SRM.SDR 00FDEA00708Light · inoperativeDURING ROUTINE INSP, FWD ENTRY DOOR EMERGENCY ESCAPE SLIDE LIGHT FOUND INOP. REMOVED BROKEN WIRE AND REPLACED LIGHT BULB PER IAW FEDEX MM 33-50-21.SDR ASAA0080633Battery · dischargedOAK - DURING SCHEDULED C-CHECK, THE L1 DOOR EMERGENCY EVACUATION SLIDE FAILED LAMP BATTERY TEST. REMOVED AND REPLACED SLIDE, SYSTEM OPERATES NORMALLY. (M)SDR 2000UALA00577Bottle · dischargedRT OVERWING BOTTLE PRESS INDICATION INOP DURING TEST NR 2 OF SQUIB TEST PANEL ON P-61. *S/D* INSTALLED NEW BOTTLE.SDR SWAA001912Bracket · looseDURING SCHEDULED C3 CHECK, FOUND FWD ENTRY AND FWD SVC DOOR GIRT BAR FLOOR BRACKETS LOOSE. SECURED BRACKETS PER MM.SDR 2000UALA00574Battery · failedSLIDE PRESSURE DOOR 4R NO TEST. *S/D* THE REASON FOR SLIDE PRESSURE FAILURE AT DOOR 4 WAS INDICATION AND NOT SLIDE PRESSURE. THIS CONDITION WAS CORRECTED BY REPLACING THE TEST INDICATOR BATTERY PACK.SDR SWAA001892Indicator · out of positionDURING SCHEDULED C2 CHECK, FOUND AFT SVC EMERGENCY EVAC SLIDE PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA001891Bottle · dischargedDURING SCHEDULED SERVICE CHECK, FOUND FWD ENTRY EMERGENCY EVAC SLIDE PRESS INDICATOR LOW. REMOVED AND REPLACED FWD ENTRY SLIDE PER MM.SDR SWAA001878Strap · looseDURING SCHEDULED C4 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT STRAP PLAYOUT EXCESSIVE. REINSTALLED SLIDE ASSY PER MM.SDR 0003569754Bottle · dischargedSLIDE ASSEMBLY WAS RECEIVED BY SLIDE SHOP WITH PRESSURE BOTTLE READING ZERO PSI. THIS WOULD HAVE BEEN A FAILURE IF DEPLOYED.SDR SWAA001867Slide · dislodgedAFT SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA001860Slide · out of adjAFT SVC DOOR EMERGENCY EVAC SLIDE OUT OF ADJUSTMENT. ADJUSTED SLIDE ASSY PER MM.SDR SWAA001858Slide · dislodgedFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR USAAD00151Bottle · dischargedBDL - THE AFT LEFT SERVICE DOOR EVACUATION SLIDE INFLATION BOTTLE HAD LOW PRESSURE. MAINTENANCE REPLACED THE AFT LEFT SERVICE DOOR EVACUATION SLIDE. (M)SDR DL76L001855Power Supply · inoperativeDURING PDC, FOUND RT SLIDE SQUIB NOT TESTING. REPLACED BATTERY PACK FOR M962, TEST NORMAL.SDR SWAA001829Indicator · out of positionAFT SVC DOOR EVACUATION SLIDE PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR 0003416612Slide · failedDURING SLIDE SHOP TEST AT OPERATING PRESSURE, A MULTIPLE SEAM FAILURE OF THE LOWER AIR HOLDING SILL TUBE OCCURRED AT THE GIRT END. SLIDE WILL BE OVERHAULED AND RECEIVE A NEW INFLATABLE.SDR UPS00433771Slide · out of positionINSPECTION TYPE:N/A, ON DEPARTURE CREW EVAC SLIDE W/N RELEASE FROM AFT POSITION TO FWD LOCK POSITION. *S/D* REPOSITIONED SLIDE TO CORRECT POSITION.SDR SWAA001786Indicator · out of positionAFT ENTRY DOOR EVACUATION SLIDE PRESSURE INDICATOR OUT OF VIEW. ADJUSTED SLIDE PER MM.SDR SWAA001765Slide · dislodgedAFT SERVICE DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. REPOSITIONED SLIDE PER MM.SDR SWAA001757Indicator · out of positionDURING SCHEDULED C1 CHECK, FOUND AFT ENTRY DOOR SLIDE INDICATOR OUT OF POSITION. ADJUSTED SLIDE PER MM.SDR 0003396615Slide · rupturedDURING ''L'' CHECK, DOOR 2R SLIDE SCHEDULED FOR CHANGE WAS DEPLOYED FOR NORMAL DEPLOYMENT TEST. SLIDE DEPLOYED AND OPERATED NORMALLY. AFTER AN ADDITIONAL (APPROXIMATELY) 30 MINUTES SLIDE RUPTURED AT UPPER TUBE SEAM AND PARTIALLY DEFLATED. REPLACED SLIDE.SDR 0003406615Slide · rupturedDURING ''L'' CHECK, DOOR 1R SLIDE SCHEDULED FOR CHANGE WAS DEPLOYED FOR NORMAL DEPLOYMENT TEST. SLIDE DEPLOYED AND OPERATED NORMALLY. AFTER AN ADDITIONAL (APPROXIMATELY) 30 MINUTES SLIDE RUPTURED AT UPPER TUBE SEAM AND PARTIALLY DEFLATED. REPLACED SLIDE.SDR SWAA001738Slide · dislodgedFWD DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR DLM88001771Bottle · dischargedON SERVICE CHECK FOUND LOW BOTTLE PRESSURE ON TAIL CONE EMERGENCY ESCAPE SLIDE. REPLACED SLIDE.SDR AALA20001489Slide · crackedSFO - DURING OVERNIGHT MAINTENANCE, LEFT OVERWING SLIDE GIRT BAR LOOSE FROM ATTACH CLAMPS. REPLACED SLIDE ASSEMBLY. SYSTEM, GROUND CHECKED NORMAL OPERATION. (M)SDR MALA000557Slide · deployedWHILE OPENING PASSENGER DOOR SLIDE DROPPED PARTIALLY ON TO FLOOR. MAINTENANCE FOUND SLIDE DEPLOYED, INSTALLED NEW SLIDE TO FWD PAX DOOR. ALL CHECKS GOOD AT THIS TIME.SDR SWAA001707Slide · dislodgedFWD ENTRY DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR SWAA001705Slide · dislodgedFWD ENTRY DOOR EVACUATION SLIDE FELL OUT OF CONTAINER INADVERTENTLY. REINSTALLED SLIDE ASSY PER MM.SDR SWAA001703Slide · dislodgedDURING SCHEDULED C1 CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE ASSY PER MM.SDR SWAA001708Indicator · out of positionBOTH AFT DOOR EVACUATION SLIDE PRESSURE INDICATORS OUT OF VIEW. REPOSITIONED BOTH SLIDES PER MM.SDR 00FDEA00638Cover · crackedDURING ROUTINE INSP, THE EMERGENCY ESCAPE SLIDE COVER FOUND CRACKED IN SEVERAL PLACES. REPAIRED COVER PER IAW B727 SRM 51-40-8.SDR DLM88001725Slide · dislodged1R DOOR SLIDE PACK FELL OUT OF DOOR ONTO CABIN FLOOR, PINS IN PACK PULLED OUT. REPLACE PACK, NO DEPLOYMENT OF SLIDE AND SLIDE WAS NOT SECURED TO GIRT BAR. SLIDE FELL OUT OF PACK WHEN DOOR CLOSED.SDR USAAD00143Strap · brokenPIT - ONE TAILCONE EVACUATION SLIDE COVER HOLD DOWN STRAP WAS FOUND BROKEN. MAINTENANCE REPLACED THE STRAP. (M)SDR SWAA001686Slide · dislodgedAFT SERVICE DOOR EVACUATION SLIDE PARTIALLY OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR SWAA001681Slide · dislodgedFWD ENTRY DOOR EVACUATION SLIDE INADVERTENTLY FELL OUT OF CONTAINER. REINSTALLED SLIDE ASSY.
Back to JASC 2565