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 MRKA9526Evac Slide · low pressREMOVED AND REPLACED EVACUATION SLIDE ON DOOR 1R DUE LOW PRESSURE. (W)SDR AALA950322Slide · damagedORD - DURING SHOP VISIT, EMERGENCY EVACUATION SLIDE GIRT BAR FOUND DETERIORIATED. EMERGENCY EVACUATION SLIDE INTRODUCED TO SHOP FOR REPAIR AND REPLACEMENT OF GIRT BAR. (W)SDR MWEA95134Evac Slide · slow to inflateDURING A TIME CHANGE FOR A TAIL SLIDE (3 YR INTERVAL), A FUNCTIONAL TEST OF THE SLIDE REVEALED A 20 SECOND HESITATION BEFORE THE SLIDE STARTED TO INFLATE. SLIDE SENT TO VENDOR FOR BENCH CHECK.SDR UF6A950210Escape Slide · low pressORD - FLT 5104 - RT REAR ESCAPE SLIDE HAS LOW PRESSURE. MAINTENANCE REPLACED ESCAPE SLIDE. (Z)SDR 95UAL747006Slide · failed testSLIDE FAILED AIR RETENTION SHOP TEST DUE TO POROSITY. ADDITIONALLY HOSES FROM CYLINDER TO SLIDE INCORRECTLY POSITIONED. SLIDE SCRAPPED.SDR AALA950237Slide · defectiveORD - DURING SHOP VISIT, FOUND HOLE IN EMERGENCY EVACUATION SLIDE AT LT BOTTOM CENTER AIR TUBE. SLIDE INTRODUCED TO SHOP FOR REPAIR. (W)SDR MWEA95122Evac Slide · low pressureDURING INSPECTION, THE TAIL EVACUATION SLIDE PRESSURE WAS FOUND TO BE LOW. REPLACED TAIL EVACUATION SLIDE. RETURNED A/C TO SERVICE.SDR AALA950196Slide · defectiveORD - DURING SHOP VISIT, EMERGENCY EVACUATION SLIDE GIRT FOUND UNGLUED APPROXIMATELY 1.0 INCH AT MATING SURFACE. SLIDE INTRODUCED TO SHOP FOR REPAIR. (X)SDR AALA950173Slide · defectiveORD - DURING SLIDE SHOP VISIT, DETACHABLE GIRT ASSEMBLY ONEMERGENCY EVACUATION SLIDE FOUND DETERIORIATED. SLIDE PROCESSED THROUGH SHIP FOR OVERHAUL, INCLUDING REPLACEMENT OF DETACHABLE GIRT ASSEMBLY. (W)SDR AALA950171Slide · scrappedORD - DURING SLIDE SHOP TEST DEPLOYMENT, EMERGENCY EVACUATION SLIDE SEAM AT GIRT TUBE FAILED. SCRAPPED EMERGENCY EVACUATION SLIDE. (W)SDR AALA950162Slide · defectiveORD - DURING SHOP VISIT, FOUND 6 INCH SEAM SEPARATION AT GIRT BAR END OF EMERGENCY EVACUATION SLIDE. ROUTED FOR REPAIR. (W)SDR AALA950166Slide · defectiveORD - DURING SHOP VISIT, FOUND GIRT COMING UNPLUGGED AT MATING SURFACE, ALSO HAD RUNWAY SEAM SEPARATION ON EMERGENCY EVACUATION SLIDE. ROUTED FOR REPAIR. (W)SDR AALA950165Slide · defectiveORD - DURING SHOP VISIT, FOUND GIRT COMING UNGLUED ON EMERGENCY EVACUATION SLIDE. ROUTED FOR REPAIR. (W)SDR AALA950164Slide · defectiveODR - DURING SHOP VISIT, FOUND 3 INCH SEAM SEPARATION AT BOTTOM LT CENTER OF EMERGENCY EVACUATION SLIDE. ROUTED FOR REPAIR. (W)SDR USAA950048Slide · faultyIND - ACCOMPLISHMENT OF JOB CARD J525-60-10 CALLS FOR SLIDE DEPLOYMENT. UPON DEPLOYMENT, SLIDE MOUNTED LIGHTS DID NOT ILLUMINATE. MAINTENANCE REMOVED AND REPLACED SERVICE DOOR EVACUATION SLIDE. (W)SDR UPS802086Escape Slide · low pressureMAINTENANCE REPORTED EVACUATION SLIDE BELOW LIMITS. REMOVED AND REPLACED EVAC SLIDE IAW 25-60-01.SDR CAL950038Slide · low pressureFLT NR 1524 - MSY - THE R-1 GALLEY DOOR SLIDE WAS FOUND WITH LOW PRESSURE DURING A PREFLIGHT CHECK. THE R-1 GALLEY DOOR SLIDE WAS REMOVED AND REPLACED. (Z)SDR MWEA95009Evac Slide · low pressureDURING ROUTINE INSPECTION, THE TAIL EVACUATION SLIDE PRESSURE WAS FOUND TO BE LOW. REPLACED TAIL EVACUATION SLIDE, RETURNED A/C TO SERVICE.SDR 95UAL747001Slide · defectiveDURING INADVERTENT DEPLOYMENT TOP TUBE DID NOT INFLATE DUE TO MECHANIC ATTEMPTING TO CLOSE DOOR DURING DEPLOYMENT. SLIDE/RAFT WAS TRAPPED IN DOORWAY. REPLACED SLIDE/RAFT. SENT REMOVED SLIDE/RAFT TO VENDOR FOR REPAIR.SDR DL767950116Power Supply · faultyDURING LAYOVER, RIGHT SIDE OVERWING EMERGENCY ESCAPE SLIDE SQUIB TEST 2 INOP. REPLACED RIGHT SQUIB POWER SUPPLY TEST NORMAL.SDR 94UAL737282Slide · failedDURING AIR RETENTION TEST OF AN AIRFORCE SLIDE, THE UNIT FAILED FOR POROSITY ALONG THE TUBES. SLIDE IS ON IT'S FIRST OVERHAUL. NOTIFIED THE AIRFORCE ABOUT THE FAILED UNIT.
Back to JASC 2565