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 USAABB99006Shear Pin · shearedAMS - FLT 42 - ON TOUCH DOWN AT AMS, THE RIGHT OVERWING SIDE DEPLOYED. MAINTENANCE FOUND THE OVERWIG DOOR LATCH ACTUATOR SQUIBS HAD NOT FIRED, BUT THE PIN THAT SHEARS WHEN THE ACTUATOR SQUIB FIRES (ALLOWING THE LATCHES TO OPEN) HAD SHEARED. IT IS NOT KNOWN WSDR 99ZZZX1274Slide · failedDURING MAINTENANCE SERVICE CHECK, FOUND LEFT AFT (L2) DOOR EMERGENCY EVACUATION SLIDE RESERVOIR PRESSURE LOW. REPLACED SLIDE ASSEMBLY.SDR 99UAL900112Tube · leakingSLIDE FAILED AIR RETENTION TEST DURING SHOP VISIT. *S/D* POROSITY CAUSED SEAM LEAK. UNIT WAS SENT TO VENDOR FOR EVALUATION AND REPAIR.SDR 99UAL900111Tube · leakingSLIDE FAILED AIR RETENTION TEST DURING SHOP VISIT. *S/D* POROSITY CAUSED SEAM LEAK. UNIT WAS SENT TO VENDOR FOR EVALUATION AND REPAIR.SDR 99UAL900110Tube · leakingSLIDE FAILED AIR RETENTION TEST DURING SHOP VISIT. *S/D* POROSITY CAUSED SEAM LEAK. UNIT WAS SENT TO VENDOR FOR EVALUATION AND REPAIR.SDR 99UAL900107Tube · leakingSLIDE FAILED AIR RETENTION TEST DURING SHOP VISIT. *S/D* POROSITY CAUSED SEAM LEAK. UNIT WAS SENT TO VENDOR FOR EVALUATION AND REPAIR.SDR SWAA990199Slide · low pressDURING SCHEDULED CHECK, FOUND L1 AND 2 SLIDE PRESSURES LOW. REMOVED AND REPLACED BOTH SLIDES PER BOEING M/M.SDR 20000510AP002Slide · deployedDURING GROUND HANDLING, A CLEANER UNINTENTIONALLY ACTIVATED THE R1 DOOR WITH THE ESCAPE SLIDE HANDLE IN ARMED POSITION. SLIDE FULLY DEPLOYED AND DOOR ASSIST BOTTLE BLOWN. REPLACED SLIDE, RAFT ASSY AT R1 DOOR PER MM 25-66-01 AND REPLACED THE DOOR ASSIST BOTTLSDR 20000424AP018Slide · deployedDURING GROUND HANDLING, A CLEANER UNINTENTIONALLY ACTIVATED THE R1 DOOR WITH THE ESCAPE SLIDE HANDLE IN ARMED POSITION. SLIDE FULLY DEPLOYED AND DOOR ASSIST BOTTLE BLOWN. REPLACED SLIDE -AFT ASSY AT R1 DOOR PER MM 25-66-01 AND REPLACED THE DOOR ASSIST BOTTLESDR SWAA990179Slide · deployedFORWARD ENTRY SLIDE INADVERTENTLY DEPLOYED AT GATE AFTER ENGINE SHUTDOWN. REMOVED AND REPLACED FWD ENTRY SLIDE ASSY PER M/M.SDR SWAA990178Slide · low pressDURING SCHEDULED A1 CHECK, FOUND FWD ENTRY DOOR SLIDE PRESSURE LOW. REPLACED PER BOEING M/M.SDR QXEA9900292Bottle · low pressurePDX - ESCAPE SLIDE BOTTLE PRESSURE IS LOW. REMOVED AND REPLACED ESCAPE SLIDE IAW FOKKER MM 25-60-01, PAGE 201, PARAGRAPH 2A AND 2B.SDR CA990330009Slide · failed(CAN) ESCAPE SLIDE FAILED TO DEPLOY, LEFT AFT DOOR.SDR 99ZZZM208Slide · blownFLT 6001 - SFO - L1- DOOR SLIDE INADVERTENTLY INFLATED/DEPLOYED. REPLACED L-1 DOOR SLIDE. (M)SDR MALA976309Slide · deployedFRONT LEFT PAX DOOR ESCAPE SLIDE DEPLOYED. MAINTENANCE REPLACED FORWARD PAX DOOR SLIDE IAW 25-40-11-401, OPS CHECK GOOD.SDR TWAA9901504Slide · low pressTHE FORWARD LEFT CABIN DOOR EVACUATION SLIDE BOTTLE PRESSURE WAS LOW. REPLACED THE SLIDE. CHECK-C 1-4-99 MCI.SDR ORJA9944Slide · failedAT PHX, R-1 DOOR EMERGENCY SLIDE FAILS. SLIDE LIGHT BATTERY OK PER MM 25-62-05. REPLACED EMERGENCY SLIDE ASSY WITH SERVICEABLE SLIDE ASSY. (X)SDR ASAA9980026Slide · failed testOAK - DURING C-CHECK, THE R1 DOOR EMERGENCY EVACUATION SLIDE FAILED THE EMERGENCY LIGHT AMP TEST. REPLACED THE R1 DOOR EMERGENCY EVACUATION SLIDE ASSEMBLY. (M)SDR 99ZZZX724Aspirator · contaminatedRECEIVING INSPECTION FOUND ONE EACH ASPIRATOR WAS COVERED WITH PIECES OF WHITE ADHESIVE TAPE. THIS TAPE COVERING THE ASPIRATOR WILL PREVENT THE AMBIENT AIR FROM BEING INJESTED THROUGH THE OPENING OF THE ASPIRATOR (RT) CAUSING THE SLIDE/RAFT TO HAVE A LOW INFLSDR 99ZZZX836Slide · deployedSFO - FLT 8165 - L-1 SLIDE DEPLOYED BY R1 FLIGHT ATTENDANTS. REPLACED L-1 SLIDE. (X)SDR CALA9900019Slide · failedL2 DOOR SLIDE SEMI DEPLOYED. DOOR OPENED WITH GIRT BAR INSTALLED. SLIDE FELL OUT ONTO JETWAY. DOOR POWER ASSIST BOTTLE DISCHARGED. REMOVED AND REPLACED SLIDE AND ASSIST BOTTLE PER 25-66-01 AND 52-11-22.SDR SWAA990108Slide · low pressureDURING SCHEDULED SC CHECK, FOUND L2 DOOR EMERGENCY SLIDE PRESSURE LOW. REPLACED SLIDE PER BOEING M/M.SDR 99ZZZX2699Slide · looseMKE - FLT 619 - RIGHT FORWARD EVACUATION SLIDE NEAR DEPLOYMENT. REMOVED AND REPLACED SLIDE.SDR 99ZZZM550Slide · out of positionRIGHT FORWARD EVAC SLIDE NEAR DEPLOYMENT. REMOVED AND REPLACED SLIDE. (M)SDR UPS99428385Attach Chord · misriggedINSPECTION TYPE-N/A, DURING SHOP VISIT FOUND THE ATTACH CHORD TIED TO THE SHORT LOOP. PLACED THE ATTACHED CHORD THROUGH THE SHORT LOOP, ATTACHING THE ATTACH CHORD TO THE CONE AND REINSTALLING PIN PER BF GOODRICH OVERHAUL MANUAL 25-68-03.SDR SWAA990059Slide · low pressureDURING SCHEDULED SC CHECK, FOUND FWD ENTRY DOOR SLIDE PRESSURE LOW. REMOVED AND REPLACED SLIDE PER BOEING M/M.SDR SWAA990058Slide · low pressureDURING PREFLIGHT CHECK, FOUND AFT ENTRY DOOR SLIDE PRESSURE LOW. REMOVED AND REPLACED SLIDE PER BOEING M/M.SDR SWAA990057Slide · low pressureDURING PREFLIGHT CHECK, FOUND AFT SERV DOOR SLIDE PRESSURE LOW. REMOVED AND REPLACED SLIDE PER BOEING M/M.SDR ASAA9980008Slide · defectiveOAK - DURING C-CHECK, THE TAILCONE EXIT EMERGENCY EVACUATION SLIDE LIGHT TEST FIXTURE WAS FOUND MISSING. REPLACED THE TAILCONE EXIT EMERGENCY EVACUATION SLIDE ASSEMBLY. (M)SDR TWAA9900301Slide · leaking airTHE FORWARD LEFT CABIN DOOR EVACUATION SLIDE WAS FOUND WITH DEPLETED BOTTLE PRESSURE. REPLACED THE SLIDE ASSEMBLY. CHECK-C 7-15-98 MCI.SDR 99ZZZM279Slide · malfunctionedAIRCRAFT PARKED AT GATE, NO PASSENGERS, THE L-2 SLIDE CAME PARTIALLY OUT OF THE DOOR. FOUND CLEVIS PIN FOR DETACH HANDLE AT FLOOR LINE, WITH BROKEN SAFETY. SLIDE WAS REPLACED. (M)SDR SWAA990004Slide · deployedDURING SCHEDULED SC CHECK, FWD SERVICE DOOR EMERGENCY ESCAPE SLIDE WAS INADVERTANTLY DEPLOYED. REMOVED AND REPLACED SLIDE PER BOEING M/M.SDR 99ZZZM548Slide · out of positionWHILE INSPECTIONG GIVE BAR MECHANISM ON FORWARD PASSENGER DOOR SLIDE PARTIALLY DEPLOYED. REMOVED AND REPLACED FORWARD PASSENGER DOOR SLIDE IAW MM. (M)SDR SWAA983152Slide · low pressDURING SCHEDULED C2 CHECK, FOUND R2 DOOR SLIDE PRESSURE LOW. REPLACED PER BOEING M/M.SDR USAAD98218Slide · failedPIT - DURING A FUNCTIONAL CHECK, THE TAIL CONE EMERGENCY EVACUATION SLIDE FAILED TO DEPLOY AUTOMATICALLY. MAINTENANCE REPLACED THE TAIL CONE EMERGENCY EVACUATION SLIDE ASSEMBLY. (M)SDR MWEA981155Slide · low pressureFORWARD ENTRY DOOR EVACUTATION SLIDE PRESSURE LOW. REMOVED AND REPLACED FORWARD ENTRY DOOR EVACUATION SLIDE.SDR USAABB98115Cable · brokenBWI - DURING GROUND OPERATIONS, THE L4 DOOR WAS OPENED FROM THE OUTSIDE TO SERVICE THE AIRCRAFT. TEH DOOR HAD NOT BEEN DISARMED. THE SLIDE DEPLOYMENT SEQUENCE WAS INITIATED. MAINTENANCE FOUND THAT THE DOOR DISARM CABLE HAD BROKEN, AND REPLACED IT. (M)SDR ASAA9880256Slide · malfunctionedOAK - DURING C-CHECK, THE L2 DOOR EMERGENCY EVACUATION SLIDE FAILED THE EMERGENCY LIGHT AMP TEST. REPLACED THE L2 DOOR EMERGENCY EVACUATION SLIDE ASSEMBLY. (M)SDR CA990125013Escape Slide · failed(CAN) DURING FUNCTIONAL TEST OF NR 2 ESCAPE SLIDE, THE SLIDE FAILED TO INFLATE CORRECTLY. DEPLOYMENT WAS SATISFACTORY, BUT THE ASPIRATOR VALVE FAILED TO FUNCTION CORRECTLY AND THE INFLATION AIR ESCAPED PAST THEM BOTH ALLOWING THE SLIDE TO DEFLATE RAPIDLY. INSDR AU981683Clip · sheared(AUS) ON REMOVAL OF THE LT 'OFF WING' ESCAPE SLIDE, THE RELEASE STRING TENSION BAR WAS FOUND ADRIFT WITHIN THE SLIDE COMPARTMENT. FURTHER INVESTIGATION FOUND THE ATTACHMENT BEARING P-CLIPS (7 OFF) SHEARED.SDR ASAA9880249Bottle · low pressureLAX - PRIOR TO DEPARTURE OF FLIGHT 84, CREW REPORTED THE L1 DOOR EMERGENCY EVACUATION SLIDE INFLATION BOTTLE PRESSURE WAS LOW. REPLACED THE L1 DOOR EMERGENCY EVACUATION SLIDE ASSEMBLY. (M)SDR MALA976250Slide · deployedMAIN CABIN DOOR EMERGENCY SLIDE PARTIALLY DEPLOYED. MAINTENANCE REPLACED FORWARD PASSENGER DOOR SLIDE. ALL CHECKS GOOD.SDR SWAA982992Slide · failedDURING SCHEDULED A1 CHECK, FOUND FWD ENTRY DOOR EMERGENCY ESCAPE SLIDE PRESSURE LOW. REPLACED PER BOEING M/M.SDR USAASA98001Cable · twistedRDU - FLIGHT ATTENDANT OPENED THE L1 DOOR WHILE IT WAS STILL ARMED. THE SLIDE FELL OUT OF THE DOOR PACK, BUT DID NOT INFLATE. MAINTENANCE FOUND THE CABLING WAS ENTANGLED AROUND THE NECK OF THE GAS BOTTLE. THE SLIDE WAS INFLATED AND WORKED PROPERLY. ALL OTSDR SWAA982984Slide · failedDURING SCHEDULED ANNUAL SAMPLE ESCAPE SLIDE OPERATIONAL CHECK, SLIDE (S/N 18471679) FAILED TO DEPLOY SUCCESSFULLY. SLIDE FELL ONTO ENTRYWAY FLOOR. SLIDE WAS THEN POSITIONED MANUALLY OUT OF THE ENTRYWAY AND PROPERLY INFLATED. REPLACED SLIDE ASSEMBLY PER BOEISDR SWAA982980Slide · damagedDURING SCHEDULED ANNUAL SAMPLE EMERGENCY ESCAPE SLIDE OPERATIONAL CHECK PROGRAM, SLIDE, S/N 2825, FAILED DEPLOYMENT CHECK DUE TO A HOLE. REPLACED PER BOEING M/M.SDR USAAD98204Harness · stiffPIT - DURING A FUNCTIONAL CHECK, THE TAIL CONE EMERGENCY EVACUATION SLIDE FAILED TO DEPLOY AUTOMATICALLY. MAINTENANCE REPLACED THE TAIL CONE EMERGENCY EVACUATION SLIDE ASSEMBLY. INVESTIGATION IN PROGRESS TO DETERMINE REASON FOR NOT DEPLOYING AUTOMATICALLY. SDR MALA976234Slide · malfunctionedMAIN PASSENGER DOOR SLIDE PARTIALLY DEPLOYED WHEN DOOR WAS OPENED. MAINTENANCE REPLACED FORWARD PASSENGER DOOR ESCAPE SLIDE REF RJ-85 AMM 25-60-11 401. OPS/SECURITY CHECK GOOD.SDR ASAA9880222Slide · failedOAK - DURING 15K CHECK, THE TAILCONE EMERGENCY EVACUATION SLIDE FAILED THE EMERGENCY LIGHT AMP TEST. REPLACED THE TAILCONE EMERGENCY EVACUATION SLIDE ASSEMBLY. (M)SDR 98UAL900631Material · leakingSLIDE FAILED AIR RETENTION DURING SHOP TEST. *S/D* UNIT WAS SENT TO THE VENDOR FOR EVALUATION AND REPAIR. THE SLIDE LEAKED DUE TO POROSITY OF THE INFLATABLE MATERIAL, AND WAS BEYOND REPAIR.
Back to JASC 2565