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 AALA20000868Slide · dischargedBOS - FLT 592 - DURING OVERNIGHT CHECK, L1 DOOR SLIDE PRESSURE OUT OF GREEN BAND. REPLACED SLIDE, SYSTEM GROUND CHECK NORMAL OPERATION. (M)SDR SWAA000953Slide · dislodgedFWD ENTRY DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR SWAA000952Indicator · out of positionDURING SCHEDULED C1 CHECK, FOUND AFT SERVICE DOOR PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA000948Indicator · out of positionDURING SCHEDULED C4 CHECK, FOUND BOTH AFT CABIN DOOR EVACUATION SLIDE PRESS INDICATORS OUT OF VIEW. REPOSITIONED BOTH AFT SLIDES PER MM.SDR SWAA000946Strap · wornFWD ENTRY DOOR EVACUATION SLIDE GIRT BAR RETAINING STRAP PAD WORN. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR AU000455Pin · misinstalled(AUS) ESCAPE SLIDERAFT INFLATION BOTTLE SAFETY PIN STILL FITTED. SLIDEWOULD NOT HAVE OPERATED WHEN REQUIRED. PERSONNEL / MAINTENANCE ERROR.SDR SWAA000942Slide · out of positionFWD ENTRY DOOR EVACUATION SLIDE MOVED OUT OF POSITION WHEN DOOR WAS OPENED. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA000940Bracket · brokenDURING SCHEDULED C1 CHECK, FOUND FWD ENTRY DOOR EVACUATION SLIDE FWD GIRT BAR ATTACH BRACKET BROKEN AT CONTAINER. REPAIRED BRACKET TO CONTAINER PER SRM.SDR SWAA000936Slide · misinstalledFWD SERVICE DOOR EVACUATION SLIDE NOT STOWED PROPERLY. REINSTALLED SLIDE ASSY PER MM.SDR UPS00432663Gas Generator · dischargedINSPECTION TYPE:N/A, FLIGHT DECK EMERGENCY EVAC SLIDE INOP. GAS GENERATOR DEPLETED. INSTALLED NEW GAS GENERATOR. PLACARD REMOVED.SDR TWAA0008101Slide · deployedAT THE GATE THE R4 DOOR EVACUATION SLIDE WAS INADVERTANTLY DEPLOYED BY AN OUTSIDE VENDOR. REPLACED SLIDE ASSEMBLY PER M57-25-09 AND M57-52-01. AC12 04-25-00 LAX.SDR ASAA0010065Bottle · dischargedANC - DURING MAINTENANCE CHECK, THE L1 DOOR SLIDE WAS FOUND TO HAVE LOW PRESSURE. REPLACED WITH SERVICEABLE SLIDE ASSEMBLY. ROUTED REMOVED SLIDE ASSEMBLY FOR INSPECTION AND REPAIR. (M)SDR MWEA00452Slide · dislodgedFORWARD ENTRANCE DOOR OPENED WITH GIRT BAR IN PLACE. RESECURED FORWARD ENTRANCE DOOR SLIDE PACK.SDR SWAA000928Slide · dischargedFWD ENTRY DOOR EVACUATION SLIDE PRESS INDICATOR LOW. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA000926Slide · dislodgedFWD ENTRY DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR 2000UALA00269Tube · leakingDURING SHOP OVERHAUL, SLIDE/RAFT (P/N 62774-414), (S/N 0224), TOP TUBE FAILED AIR RETENTION TEST. FOUND A SEAM LEAK AT SEAM JOINT BETWEEN TOP ASPIRATOR TUBE AND MAIN TOP TUBE (P/N 62424-408). UNIT RETURNED TO VENDOR FOR WARRANTY REPAIR. UNIT WAS LAST OVERHASDR 2000UALA00268Tube · leakingDURING SHOP OVERHAUL, SLIDE/RAFT (P/N 62772-213), (S/N 0264), TOP TUBE FAILED AIR RETENTION TEST. FOUND SEAM LEAK IN TOP TUBE (P/N: 62422-207), 15 INCHES FROM TOP TUBE ASPIRATOR. UNIT RETURNED TO VENDOR FOR WARRANTY REPAIR. UNIT WAS LAST OVERHAULED BY VENDOSDR 2000UALA00266Tube · will not testAFT DOOR SLIDE/RAFT LOWER TUBE FAILED PROOF PRESSURE TEST. *S/D* FOUND THE LOWER TUBE TO HAVE A SEAM FAILURE AT THE TOP END CROSSOVER TUBE. SENT UNIT TO VENDOR FOR REPAIR.SDR MWEA00449Slide · dislodgedGALLEY DOOR EMERGENCY ESCAPE SLIDE FELL OFF. MAINTENANCE REINSTALLED GALLEY DOOR EMERGENCY ESCAPE SLIDE.SDR CA000614002Slide · failed(CAN) AIRCRAFT 204, MAY 17/2000, TRENTON, LOG SEQUENCE 0511852. DURING SCHEDULED TEST DEPLOYMENT OF RT OVERWING SLIDE, IT FAILED TO DEPLOY. SLIDE WAS DEPLOYED BY FURTHER ACTUATION OF AUTOMATIC CABLE. SLIDE DID NOT FULLY INFLATE.SDR SWAA000907Indicator · out of positionAFT ENTRY DOOR EVACUATION SLIDE PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR CALA0000687Battery · dischargedTHE L-3 DOOR AND R-1 DOOR ESCAPE SLIDE LIGHTS TESTED DIM. THE SLIDE LIGHT BATTERY WAS REPLACED AT EACH DOOR AND OPERATION CHECKED GOOD IAW MM 25-61-01.SDR MWEA00446Slide · deployedPITTSBURG CRASH FIRE RESCUE INADVERTENTLY JETTISONED THE TAIL CONE AND SLIDE DEPLOYED. MAINTENANCE REINSTALLED TAIL CONE AND INSTALLED SERVICEABLE AFT SLIDE.SDR SWAA000905Slide · dislodgedFWD SERVICE DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR MALA000307Slide · deployedRIGHT REAR POSITION DOOR SLIDE PARTIALLY DEPLOYED. MX REPLACED REAR SLIDE (P/N31050-105). OPS CHECK GOOD.SDR SWAA000895Slide · dislodgedFWD SERVICE DOOR EVACUATION SLIDE FELL OUT OF CONTAINER WHILE ACFT WAS BEING PROVISIONED. INSTALLED SLIDE ASSY PER MM.SDR SWAA000894Indicator · out of positionAFT ENTRY DOOR EVACUATION SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR 2000UALA00247Tube · damagedDURING SCHEDULED SHOP FLAT FIRING TEST, SLIDE TOP TUBE FAILED TO HOLD AIR. SLIDE/RAFT (P/N 62772-214), (S/N 0229). SLIDE WAS UNDERGOING FIRST SCHEDULED OVERHAUL. *S/D* TOP TUBE ASPIRATOR FLAPPER (CHECK) VALVE WAS FOUND DAMAGED. ASPIRATOR (P/N 62510-101), SDR SWAA000888Girt Bar · out of adjDURING SCHEDULED C1 CHECK, FOUND FWD SERVICE DOOR EVACUATION SLIDE GIRT ASSY OUT OF ADJUSTMENT. REINSTALLED SLIDE ASSY PER MM.SDR SWAA000887Indicator · out of positionDURING SCHEDULED C1 CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR USAAD00073Slide · dischargedDAY - THERE WAS NO PRESSURE IN THE TAILCONE EMERGENCY EVACUATION SLIDE ASSEMBLY. MAINTENANCE REPLACED THE TAILCONE EMERGENCY EVACUATION SLIDE ASSEMBLY. (X)SDR SWAA000879Girt Bar · out of positionAFT SERVICE DOOR EVACUATION SLIDE GIRT BAR DIFFICULT TO REMOVE AND INSTALL INTO CONTAINER HOOKS. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA000878Slide · looseDURING SCHEDULED C3 CHECK, FOUND ALL FOUR ENTRY AND SERVICE DOOR EVACUATION SLIDE GIRT ASSY OUT OF ADJUSTMENT. REINSTALLED SLIDE ASSY PER MM.SDR SWAA000875Indicator · dislodgedFWD ENTRY DOOR EVACUATION SLIDE PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA000873Slide · dislodgedFWD ENTRY DOOR EVACUATION SLIDE FELL OUT OF CONTAINER DURING DOOR CLOSING. REINSTALLED SLIDE ASSY PER MM.SDR SWAA000861Indicator · dislodgedAFT ENTRY AND SERVICE DOOR EVACUATION SLIDE PRESSURE INDICATORS OUT OF VIEW. REPOSITIONED SLIDES PER MM.SDR SWAA000869Slide · looseDURING SCHEDULED C3 CHECK, FOUND FWD ENTRY, FWD SERVICE AND AFT SERVICE DOOR EVACUATION SLIDE GIRT ASSY''S OUT OF ADJUSTMENT. REINSTALLED SLIDES PER MM.SDR SWAA000865Indicator · dislodgedDURING SCHEDULED C4 CHECK, FOUND AFT SERVICE AND ENTRY DOOR EVACUATION SLIDE PRESS INDICATORS OUT OF VIEW. REINSTALLED SLIDES PER MM.SDR SWAA000863Slide · dislodgedFWD ENTRY DOOR EVACUATION SLIDE MOVED OUT OF POSITION WHEN DOOR WAS OPENED. REINSTALLED SLIDE ASSY PER MM.SDR SWAA000860Indicator · dislodgedDURING SCHEDULED C3 CHECK, FOUND FWD SERVICE DOOR EVACUATION SLIDE PRESSURE IND OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA000857Cable · frayedDURING SCHEDULED C1 CHECK, FOUND AFT ENTRY DOOR EVACUATION SLIDE RELEASE CABLE FRAYED. REMOVED AND REPLACED CABLE PER MM.SDR SWAA000848Slide · dislodgedFWD ENTRY DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR MWEA00415Slide · dischargedAFT GALLEY SERVICE DOOR EMERGENCY EVACUATION ESCAPE SLIDE PRESSURE FOUND LOW. MAINTENANCE REMOVED AND REPLACED ESCAPE SLIDE WITH A SERVICEABLE UNIT.SDR SWAA000843Slide · dislodgedDURING SCHEDULED C3 CHECK, FOUND AFT ENTRY DOOR EVACUATION SLIDE GIRT ASSY OUT OF POSITION. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA000842Slide · dislodgedDURING SCHEDULED C1 CHECK, FOUND FWD SERVICE DOOR EVACUATION SLIDE GIRT ASSY OUT OF POSITION. REPOSITIONED SLIDE ASSY PER MM.SDR USAAF00034Spring · brokenCLT - FOUND SERVICE DOOR GIRT BAR SLIDER HAS BROKEN SPRING. MAINTENANCE REPLACED THE SPRING IN SLIDER. CHECKS NORMAL. (M)SDR SWAA000823Slide · looseDURING SCHEDULED C1 CHECK, FOUND FWD SERVICE DOOR EVACUATION SLIDE GIRT ASSY OUT OF POSITION. REINSTALLED SLIDE ASSY PER MM.SDR SWAA000819Slide · dislodgedFWD ENTRY DOOR EVACUATION SLIDE CAME OUT OF CONTAINER AS DOOR WAS OPENED. REINSTALLED SLIDE ASSY PER MM.SDR ASAA0040061Slide · failedSEA - DURING C-CHECK, THE L-2 SLIDE FAILED TO INFLATE DURING TEST. REPLACED SLIDE ASSEMBLY. (M)SDR SWAA000816Slide · out of adjAFT ENTRY DOOR EVACUATION SLIDE OUT OF ADJUSTMENT. REINSTALLED SLIDE ASSY PER MM.
Back to JASC 2565