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 97UAL900664Tube · wornDURING SHOP OVERHAUL OF SLIDE/ RAFT REMOVED FOR TIME EXPIRATION, IT WAS FOUND THAT THE LOWER TUBE RELIEF VALVE HAD WORN A HOLE INTO THE LOWER TUBE. THE HOLE WAS REPAIRED WITH AN OUTSIDE PATCH.SDR 97UAL900641Slide · defectiveFORWARD ENTRY DOOR 1L SLIDE DEFECTIVE. *S/D* REPLACED 1L SLIDE WITH NEW SLIDE. HOME SHOP REPORTED THAT GIRT RESTRAINING BUNGEE ATTACH POINT REINFORCING PATCHES WERE FOUND TO BE DISBONDING.SDR 97UAL900634Valve · corrodedDURING OVERHAUL OF SLIDE, REMOVED FOR TIME EXPIRATION FOUND INFLATION FLOW CONTROL VALVE BODY (P/N 525S0002) AND SPRING (P/N 525S0003) CORRODED. REPLACED VALVE ASSEMBLY (P/N D18287107) COLD DOOR. A HEATER HAS NOT BEEN ADDED TO THE DOOR AS HAS BEEN DONE TO THSDR MWEA97741Slide · defectiveDURING TRANS CHECK, FOUND EMERG GALLEY SLIDE PRESS LOW. MTC REMOVED AND REPLACED SLIDE.SDR CALA9701231Slide · low pressureINSPECTION FOUND THE L-2 DOOR EMERGENCY SLIDE PACK PRESSURE LIGHT ILLUMINATED. THE L-2 DOOR SLIDE WAS REMOVED AND REPLACED.SDR ASAA9780180L2 Door · failed testOAK - 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 ASAA9780179Slide · failed testOAK - DURING C-CHECK, THE R1 DOOR EMERGENCY EVACUATION SLIDE FAILED THE EMERGENCY LIGHT AMPE TEST. REPLACED THE R1 DOOR EMERGENCY EVACUATION SLIDE ASSEMBLY. (M)SDR ASAA9780178Inflation Bottle · low pressureOAK - DURING C-CHECK, THE L1 DOOR EMERGENCY EVACUATION SLIDE INFLATION BOTTLE PRESSURE WAS FOUND LOW. REPLACED THE L1 DOOR EMERGENCY EVACUATION SLIDE ASSEMBLY. (M)SDR SWAA970784Slide · low pressDURING SERVICE CHECK, FOUND R1 FLOOR SLIDE PRESSURE LOW. REPLACED PER BOEING M/M.SDR SWAA970787Slide · low pressDURING SERVICE CHECK, FOUND R2 DOOR SLIDE PRESSURE LOW. REPLACED PER BOEING M/M.SDR MALA975655Escape Slide · looseDURING MAINTENANCE, THE PASSENGER ESCAPE SLIDE FELL OUT. MAINTENANCE REPLACED PASSENGER DOOR ESCAPE SLIDE ASSEMBLY IAW AVRO MM 25-60-11. (X)SDR SWAA970699Slide · low pressDURING A1 CHECK, FOUND R2 DOOR SLIDE PRESSURE LOW. REPLACED PER BOEING M/M.SDR AALA971436Slide · low pressureDFW - DURING OVERNIGHT CHECK, EMERGENCY EVACUATION SLIDE AT FORWARD SERVICE DOOR INDICATED LOW BOTTLE PRESSURE. REPLACED EMERGENCY EVACUATION SLIDE AT FORWARD SERVICE DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AWXA9700437Slide · deployed2-L DOOR SLIDE INADVERTENTLY DEPLOYED. REMOVED 2-L DOOR SLIDE, PLACED IN AFT PIT AND FERRIED TO PHX. REPLACED SLIDE ASSEMBLY.SDR SWAA970681Slide · low pressDURING WALKAROUD CHECK, FOUND R2 DOOR SLIDE PRESSURE LOW. REPLACED PER BOEING M/M.SDR DLL14971585Slide · malfunctionedFOUR RIGHT DOOR DID NOT OPEN AND THE SLIDE DID NOT DEPLOY DURING EVACUATION. FOUND 'T' HANDLE NOT FULLY DEPLOYED, OPS CHECK NORMAL.SDR 98ZZZM95Slide · deployedWITH A/C IN HANGAR FOR RON MX, REAR RT DOOR OPENED AND SLIDE WAS NOT DSIARMED AND WAS DEPLOYED DUE TO BEING UNSAFE. REMOVED AND REPLACED SLIDE. (M)SDR MWEA97715Slide · deployedDURING C-CHK, TAIL SLIDE INADVERTENTLY DEPLOYED. MTC REMOVED AND REPLACED TAIL SLIDE IAW AFT ACCESSORY PLACARD.SDR 9714969985Slide · low batteryDURING PERIODIC CHECK, MAIN CABIN DOOR EVACUATION SLIDE FAILED BATTERY TEST. REPLACED SLIDE.SDR SWAA970670Slide · low pressDURING WALKAROUNBD CHECK, FOUND FWD ENTRY DOOR SLIDE PRESS LOW. REPLACED PER BOEING M/M.SDR CALA9701161Slide · zero pressureINSPECTION FOUND THE R-2 DOOR ESCAPE SLIDE WITH ZERO PRESSURE. THE SLIDE WAS REMOVED AND REPLACED.SDR SWAA970692Slide · low pressDURING WALKAROUND CHECK, FOUND FWD ENTRY DOOR SLIDE PRESSURE LOW. MX FERRIED TO OAK. REPLACE PER BOEING M/M.SDR SWAA970650Slide · low pressDURING SCHEDULED SERVICE CHECK, FOUND AFT DOOR SLIDE PRESSURE BELOW MINIMUM. REPLACED SLIDE ASSEMLY PER BOEING M/M.SDR 97UAL900609Tube · failedDURING SHOP OVERHAUL OF SLIDE, THE LOWER TUBE FAILED THE AIR RETENTION TEST DUE TO POROSITY IN THE INFLATABLE MATERIAL. SLIDE SENT TO VENDOR FOR REPAIR OR REPLACEMENT.SDR SWAA970654Slide · low pressDURING WALKAROUND CHECK, FOUND AFT RIGHT DOOR SLIDE PRESS LOW. REPLACED PER BOEING M/M.SDR SWAA970631Slide · low pressureDURING WALKAROUND CHECK, FOUND FWD ENTRY DOOR SLIDE PRESSURE BELOW SERVICEABLE LIMITS. REPLACED PER BOEING M/M.SDR DLM88971413Slide · inflatedLT AFT GALLEY SLIDE FELL OUT AND INFLATED. REPLACED LT AFT GALLEY SLIDE.SDR 9713839603Slide · failed testDURING PERIODIC CHECK, MAIN CABIN DOOR EVACUATION SLIDE FAILED BATTERY TEST. REPLACED SLIDE.SDR ASAA9780145Inflation Bottle · low pressureONT - PRIOR TO DEPARTURE OF FLIGHT 383, CREW REPORTED, THE L1 DOOR EMERGENCY EVACUATION SLIDE INFLATION BOTTLE PRESSURE WAS FOUND LOW. REPLACED THE L1 DOOR EMERGENCY EVACUATION SLIDE ASSEMBLY. (M)SDR MWEA97632Evac Slide · failedDURING C-CHK, GALL DOOR EVAC SLIDE FAB DETERIORATED. MAINT REMOVED AND REPLACED SLIDE.SDR 97ZZZM870Slide · deployedFUNCTION CHECK SLIDE (BELOW) AND THEN REMOVE FOR DETAILED INSPECTION REF CHECK LS. REPORT TASK ON STEP 543 IN COMPUTER. AT INSTALLATION C/W COVER LATCH PULL CHECK COMPLIED WITH FUNCTION CHECK NR 3 POS (S/N 0389) SLIDE ASSEMBLY AND REMOVED FOR DETLD INSPECTIOSDR 9713569953Slide · failed testDURING PERIODIC CHECK, MAIN CABIN DOOR EMERGENCY EVACUATION SLIDE FAILED BATTERY TEST. REPLACED SLIDE.SDR USAAD97115Slide · malfunctionedPIT/RON - TAIL CONE ACCIDENTALLY DROPPED, ESCAPE SLIDE DID NOT DEPLOY. REPLACED ESCAPE SLIDE. (X)SDR CALA9701114Slide · low pressureINSPECTION FOUND THE TAILCONE EMERGENCY SLIDE PRESSURE LOW. THE TAILCONE SLIDE WAS REMOVED AND REPLACED IAW MM 25-62.SDR 9712539994Slide · failed testDURING PERIODIC CHECK, MAIN CABIN DOOR EVACUATION SLIDE FAILED BATTERY TEST. REPLACED SLIDE.SDR ASAA9780116Cable · brokenSEA - DURING MAINTENANCE CHECK, THE L1 DOOR EMERGENCY EVACUATION SLIDE GIRT BAR ATTACH CABLE WAS FOUND BROKEN. REPLACED THE CABLE ASSEMBLY. (M)SDR SWAA970556Slide · out of dateDURING SCHEDULED A1 CHECK, FOUND FWD SERVICE DOOR SLIDE OUT OF DATE. REMOVED AND REPLACED SLIDE PER BOEING M/M.SDR 97UAL900470Slide · fell offCATERERS PARTIALLY OPENED DOOR FOUR RIGHT, WITH DOOR ARMED, CAUSING SLIDE TO FALL OFF. *S/D* 757 HAS AN EMERGENCY ASSIST CYLINDER TO OPEN DOOR IN EMERGENCY (WITH SLIDE ARMED). AMIS WRITE UP IMPROPERLY REPORTED PARTIAL OPENING OF DOOR. SLIDE WAS BLOWN AND OSDR 97UAL900625Valve · failedEVACUATION SLIDE AT DOOR 4R INFLATED IN THE AIRPLANE DUE TO INFLATION BOTTLE DISCHARGE VALVE FAILURE. THE AIRPLANE HAD BEEN STORED IN LAS FOR 32 MONTHS. IT WAS NOT ECONOMICALLY FEASIBLE TO REPAIR THE SLIDE DUE TO THE DAMAGE THAT OCCURRED DURING DEPLOYMENT. SDR AWXA9700333Slide · deployedL-1 DOOR SLIDE ACCIDENTLY DEPLOYED ON PUSHBACK. REMOVED AND REPLACED SLIDE ASSEMBLY.SDR ASAA9780110Inflation Bottle · low pressureSEA - DURING MAINTENANCE CHECK, THE R1 DOOR EMERGENCY EVACUATION SLIDE INFLATION BOTTLE PRESSURE WAS FOUND LOW. REPLACED THE R1 DOOR EMERGENCY EVACUATION SLIDE. (M)SDR 9710819966Slide · battery failedDURING PERIODIC CHECK, FORWARD SERVICE DOOR EVACUATION SLIDE FAILED BATTERY TEST. REPLACED SLIDE.SDR AU970810Slide · faulty(AUS) NO3 MAIN ENTRY DOOR ESCAPE SLIDE DEFLATE DURING TEST - SUSPECT CAUSED BY TEARING OF THE FABRIC BY THE DOOR DUST SEAL PLASTIC RETAINER METAL CORNERSDR 9710469607Slide · low batteryDURING PERIODIC CHECK, FOUND MAIN CABIN DOOR EVACUATION SLIDE BATTERIES LOW. REPLACED SLIDE.SDR 9710459607Slide · low batteryDURING PERIODIC CHECK, FOUND RIGHT FORWARD SERVICE DOOR EVACUATION SLIDE BATTERIES LOW. REPLACED SLIDE.SDR AALA970973Slide · low pressureRDU - DURING OVERNIGHT CHECK, FOUND FORWARD ENTRY DOOR SLIDE BOTTLE PRESSURE LOW. REPLACED FORWARD ENTRY DOOR EMERGENCY EVACUATION SLIDE. SYSTEM GROUND CHECKED, NORMAL OPERATION. (X)SDR ORJA9772Slide · not securedUPON OPENING FORWARD PASSENGER DOOR, SLIDE FELL OUT OF CONTAINER. INSTALLED FORWARD PASSENGER SLIDE, IAW MM. (X)SDR 97UAL900423Slide · cutDURING SHOP OVERHAUL OF SLIDE REMOVED FROM DOOR 1R FOR TIME EXPIRATION, A CUT WAS FOUND ON THE SLIDING SURFACE. SLIDE/RAFT WAS SENT TO THE VENDOR FOR REPAIR.SDR 97UAL900422Slide · damagedDURING SHOP OVERHAUL OF SLIDE REMOVED FROM DOOR 1L FOR TIME EXPIRATION, A HOLE ON THE LOWER TUBE NEXT TO THE RELIEF VALVE WAS FOUND. SLIDE SENT TO THE VENDOR FOR REPAIR.SDR 9710249983Slide · low pressureDURING LINE MAINTENANCE INSPECTION, FOUND AFT EVACUATION SLIDE BOTTLE PRESSURE LOW. REPLACED SLIDE.
Back to JASC 2565