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 SWAA001480Slide · dislodgedFWD ENTRY DOOR EVACUATION SLIDE FELL OUT OF CONTAINER WHEN F/A OPENED DOOR. REINSTALLED SLIDE ASSY PER MM.SDR SWAA001478Slide · dislodgedFWD ENTRY DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR AALA006125Slide · looseSJC - AFT GALLEY SERVICE DOOR SLIDE IS LOOSE. SECURED AFT GALLEY DOOR. SLIDE LANYARD CHECKS OK. (M)SDR AALA006124Cover · looseRNO - FORWARD GALLEY DOOR SLIDE COVER LOOSE. SECURED SLIDE COVER FORWARD GALLEY DOOR. (M)SDR SWAA001464Indicator · out of positionAFT ENTRY DOOR EVACUATION SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA001450Slide · dislodgedFWD ENTRY DOOR EVACUATION SLIDE DROPPED OUT OF CASE, BOTH BAR ENDS DISSENGAGED FROM ACFT BRACKETS. REINSTALLED SLIDE ASSY PER MM.SDR SWAA001447Slide · misinstalledFWD ENTRY DOOR EVACUATION SLIDE NOT PROPERLY STOWED. REINSTALLED SLIDE ASSY PER MM.SDR CA000829004Slide · deployed(CAN) CABIN CREW INFORMED. FLIGHT CREW F USUAL NOISE IN VICINITY OF ROW 11, SUSPECT, LEFT HAND DITCHING DAM DEPLYMENT, VISUALLY CONFIRMED BY THE CABIN CREW. FLIGHT CONTINUED TO DESTINATION AIRPORT AT REDUCED AIRSPEED 190 KTS. 26 MAY 2000 LEFT HAND DITCHING DAMSDR SWAA001430Slide · deployedFWD ENTRY DOOR EVACUATION SLIDE DEPLOYED INADVERTENTLY. REINSTALLED SLIDE ASSY PER MM.SDR SWAA001429Indicator · out of positionAFT ENTRY DOOR EVACUATION SLIDE PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR TWAA0012103Bottle · dischargedTHE LEFT SIDE NUMBER 2 CABIN DOOR SLIDE PRESSURE WAS LOW. REPLACED THE SLIDE. CHECK-C7-13-00 MCI.SDR DL767001427Slide · misinstalledR1 CABIN DOOR SLIDE NOT PROPERLY ATTACHED TO DOOR. REPLACED R1 DOOR SLIDE PER M/M, OPS CHECKS NORMAL.SDR 2000UALA00450Slide · leakingDURING ROUTINE SHOP OVERHAUL, DOOR 1 LEFT HAND SLIDE RAFT (P/N: 62771-117, S/N 0234) FAILED AIR RETENTION TEST. FOUND SEAM LEAK IN THE BOTTOM TUBE. LEAK IS IN RIGHT HAND DOG LEG TUBE FLANGE TO LOWER MAIN TUBE. SLIDE/RAFT (P/N: 62421-109, S/N 0234) SENT TO VSDR SWAA001410Indicator · out of positionAFT SERVICE DOOR EVACUATION SLIDE PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR USAAD00117Slide · failedPHL - THE AFT LEFT SERVICE DOOR WAS INADVERTENTLY OPENED, WITH THE GIRT BAR ATTACHED, BUT THE EMERGENCY ESCAPE SLIDE DID NOT INFLATE. MAINTENANCE INSTALLED THE SLIDE TO BE CONFIGURED FOR AUTOMATIC INFLATION. OKAY FOR SERVICE. (X)SDR MALA000486Slide · dislodgedUPON CLIMBOUT, 1L SLIDE FELL OUT OF IT'S HOLDER, DID NOT OPEN DOOR AFTER SLIDE MOVED. MAINTENANCE REMOVED AND REPLACED SLIDE ASSEMBLY.SDR MALA000387Slide · deployedFORWARD PASSENGER DOOR SLIDE BLOWN. MAINTENANCE REPLACED FORWARD PASSENGER DOOR SLIDE WITH SERVICEABLE UNIT, (P/N D31050-105). ALL CHECKS GOOD.SDR SWAA001384Slide · looseWHILE PROVISIONING FOUND FWD SERVICE DOOR EVACUATION SLIDE FALLING OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR MWEA00594Slide · detachedEWR - FLT 279 - FORWARD ENTRANCE DOOR ESCAPE SLIDE HOLDER WAS DETACHED AT BOTTOM. REINSTALLED RETAINING PIN IN CLIP. (M)SDR SWAA001363Slide · dislodgedFWD ENTRY DOOR EVACUATION SLIDE ACCIDENTALLY DISLODGED FROM CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR SWAA001355Slide · deployedTHIS IS AN AMENDED REPORT ORIGINALLY SUBMITTED 7-24-200, (OPERATOR CONTROL NUMBER SWAA01346). PROVISIONING POPPED AFT SERVICE DOOR EVACUATION SLIDE, BAR WAS STILL ATTACHED. REMOVED AND REPLACED DOOR SLIDE PER MM.SDR GTIA000263Slide · dislodgedUPON ARRIVAL OF A/C, FLIGHT ATTENDANT OPENED FORWARD L-1 DOOR AND ESCAPE SLIDE FELL TO GROUND. INSPECTED SLIDE PACK, NOTIFIED M/C AND INSPECTION. RE-INSTALLED SLIDE PACK ON L-1 DOOR IAW CH 25. (M)SDR SWAA001357Slide · dislodgedAFT ENTRY DOOR EVACUATION SLIDE INADVERTENTLY FELL OUT. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA001356Cover · looseFWD SERVICE DOOR EVACUATION SLIDE SHELL OPENED WHEN DOOR WAS OPENED. RE-INSTALLED SLIDE ASSY PER MM.SDR GTIA000262Slide · dislodgedDTW - AFT GALLEY DOORSLIDE PACK DOOR FELL OFF. RE-INSTALLED AFT GALLEY SLIDE PACK AS PER MD-80 MM 25-62-00. (M)SDR MALA000443Slide · dischargedFWD PAX EMERGENCY SLIDE PRESSURE IN RED ZONE. MAINTENANCE REPLACED RT FWD SERVICE DOOR EMERGENCY SLIDE.SDR SWAA001346Slide · deployedINADVERTENT AFT SERVICE DOOR EVACUATION SLIDE DEPLOYMENT. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA001383Slide · dislodgedAFT SERVICE DOOR EVACUATION SLIDE CAME OUT OF CONTAINER AS PROVO TRUCK PULLED AWAY FROM ACFT. REINSTALLED SLIDE ASSY PER MM.SDR UPS00833394Lanyard · brokenINSPECTION TYPE:N/A, SLIDE COVER LANYARD BROKEN AT CABLE (SLIDE AT ENTRY DOOR). REPLACED MAIN ENTRY DOOR SLIDE COVER LANYARD AND SECURED SLIDE LANYARD INSTALLED PER IPC 25-62-00.SDR SWAA001342Slide · dislodgedTHIS IS AN AMENDED REPORT ORIGINALLY SUBMITTED 7-16-00, (OPERATOR CONTROL NUMBER SWAA00-1301). FWD ENTRY DOOR EVACUATION SLIDE FELL OUT WHEN DOOR OPENED. RE-INSTALLED SLIDE ASSY PER MM.SDR SWAA001341Slide · dislodgedTHIS IS AN AMENDED REPORT ORIGINALLY SUBMITTED 7-16-00, (OPERATOR CONTROL NUMBER SWAA00-1299). FWD ENTRY DOOR EVACUATION SLIDE PARTIALLY PULLED FROM CONTAINER WHEN DOOR OPENED. DID NOT DEPLOYED. RE-INSTALLED SLIDE ASSY PER MM.SDR SWAA001340Slide · deployedTHIS IS AN AMENDED REPORT ORIGINALLY SUBMITTED 7-15-00, (OPERATOR CONTROL NUMBER SWAA00-1298). INADVERTENTLY DEPLOYED FWD ENTRY DOOR EVACUATION SLIDE. RESECURED SLIDE ASSY TO DOOR PER MM.SDR SWAA001338Girt Bar · out of adjDURING SCHEDULED 1/2D CHECK, FOUND AFT SERVICE AND ENTRY DOOR EVACUATION SLIDE GIRT ASSY OUT OF ADJUST. RE-INSTALLED SLIDE ASSY PER MM.SDR SWAA001334Indicator · out of positionDURING SCHEDULED C1 CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA001333Girt Bar · out of adjDURING SCHEDULED C1 CHECK, FOUND AFT ENTRY DOOR EVACUATION SLIDE GIRT ASSY OUT OF ADJUST. REINSTALLED SLIDE ASSY PER MM.SDR ASAA0080472Slide · failedPHX - DURING 30K CHECK, THE R1 DOOR EMERGENCY EVACUATION SLIDE FAILED THE EMERGENCY LIGHT AMP TEST. REPLACED THE R1 DOOR EMERGENCY EVACUATION SLIDE ASSEMBLY. (M)SDR SWAA001329Indicator · out of positionDURING SCHEDULED C4 CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR AALA20001176Slide · malfunctionedJFK - DURING OVERNIGHT MAINTENANCE, L4 SLIDE RAFT GO-NO-GO INDICATOR OUT OF LIMITS. REPLACED L4 SLIDE. SYSTEM GROUND CHECKED, NORMAL OPERATION. (X)SDR SWAA001313Girt Bar · out of adjDURING SCHEDULED C2 CHECK, FOUND FWD SERVICE DOOR EVACUATION SLIDE GIRT ASSY OUT OF ADJUST. RE-INSTALLED SLIDE ASSY PER MM.SDR SWAA001309Indicator · out of positionFWD SERVICE DOOR EVACUATION SLIDE PRESSURE INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA001305Indicator · out of positionAFT SERVICE DOOR EVACUATION SLIDE PRESSURE INDICATOR OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR 00FDEA00472Cover · crackedDURING ROUTINE INSPECTION, FWD ENTRY DOOR EMERGENCY ESCAPE SLIDE LWR CASE FOUND CRACKED AT BOTH SIDES OF STOW HOOKS. REMOVED AND REPLACED WELD PER IAW BAC 5975, MM 25-60-13.SDR 00FDEA00466Battery Pack · crackedDURING ROUTINE INSPECTION, FWD ENTRY DOOR ESCAPE SLIDE LIGHT BATTERY PACK FOUND CRACKED. REMOVED AND REPLACED PER IAW MM 33-50-112.SDR SWAA001301Slide · dislodgedFWD ENTRY DOOR EVACUATION SLIDE FELL OUT OF CONTAINER INADVERTENTLY, (STILL ARMED WHEN DOOR OPENED). RE-INSTALLED SLIDE ASSY PER MM.SDR SWAA001300Indicator · out of positionAFT ENTRY DOOR EVACUATION SLIDE PRESSURE INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA001299Slide · dislodgedFWD ENTRY DOOR EVACUATION SLIDE FELL OUT OF CONTAINER INADVERTENTLY, (STILL ARMED WHEN DOOR OPENED). RE-INSTALLED SLIDE ASSY PER MM.SDR AU000600Slide · wrong part(AUS) ON REMOVAL OF THE LT 'OFF' WING SLIDE, IT WAS DISCOVERED THAT THE SLIDE TYPE SHOULD NOT HAVE BEEN FITTED TO A -300 SERIES AIRCRAFT- A SINGLE LANE SLIDE WAS FITTED IN LIEU OF A DUAL LANE SLIDE. PERSONNEL/MAINTENANCE ERROR.SDR SWAA001298Slide · dislodgedFWD ENTRY DOOR EVACUATION SLIDE FELL OUT OF CONTAINER INADVERTENTLY, (STILL ARMED WHEN DOOR OPENED). RE-INSTALLED SLIDE ASSY PER MM.SDR SWAA001280Slide · dislodgedFWD SERVICE DOOR EVACUATION SLIDE FELL OUT OF CONTAINER INADVERTENTLY. REINSTALLED SLIDE ASSY PER MM.SDR 2000UALA00393Slide · deployedDOOR NR 2 RIGHT INADVERTENT SLIDE DEPLOYMENT. *S/D* THE SLIDE DEPLOYED NORMALLY. SLIDE WAS REPLACED PRIOR TO RETURNING AIRCRAFT TO SERVICE.
Back to JASC 2565