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 9807339952Slide · low rpessureDURING LINE MAINTENANCE INSPECTION, FOUND MAIN CABIN DOOR EVACUATION SLIDE BOTTLE PRESSURE LOW. REPLACED SLIDE.SDR SWA980683Slide Bottle · lowDURING SCHEDULED RON CHECK, FOUND EMERGENCY EVAC, FWD SLIDE BOTTLE LOW. REMOVED AND REPLACED PER BOEING MM.SDR CALA9800684Slide · low pressureINSPECTION FOUND R-2 DOOR SLIDE PRESSURE AT ZERO. THE R-2 DOOR SLIDE WAS REMOVED AND REPLACED IAW MM 25-61-311.SDR AU981697Slide · malfunctioned(AUS) NR 1 DOOR SLIDE (RT SIDE) FAILED TO INFLATE CORRECTLY WHEN TEST FIRING WAS CARRIED OUT. APPEARS THE SLIDE FOULED ON THE DOOR BUSTLE.SDR 98UAL900149Tube · tornDURING SHOP OVERHAUL, THE SLIDE/RAFT DEVELOPED A TWO INCH TEAR IN THE LOWER TUBE UNDER THE GIRT AFTER THE FLAT FIRE TEST. SLIDE/RAFT SENT TO VENDOR FOR WARRANTY REPAIR.SDR 9806149967Slide · low pressureDURING LINE MAINTENANCE INSPECTION, FOUND TAIL CONE EVACUATION SLIDE BOTTLE LOW ON PRESSURE. REPLACED SLIDE.SDR 9805989913Slide Battery · dischargedDURING PERIODIC CHECK, FORWARD GALLEY DOOR EVACUATION SLIDE FAILED BATTERY TEST. REPLACED SLIDE.SDR 9805929988Slide Bottle · low pressureDURING LINE MAINTENANCE INSPECTION, FOUND AFT EVACUATION SLIDE BOTTLE LOW ON PRESSURE. REPLACED SLIDE.SDR SWAA980442Slide · out of dateDURING SCHEDULED CHECK, FOUND L-2 EMERGENCY EVACUATION SLIDE OUT OF DATE. REMOVED AND REPLACED PER BOEING MM.SDR UF6A980329Slide · looseSBN - FLT 5761 - FORWARD PAX DOOR EMERGENCY SLIDE PULLED LOOSE FROM DOOR. MAINTENANCE REMOVED AND REPLACED SLIDE. SYSTEM OPS CHECKED GOOD. (M)SDR AU980535Aspirator · fractured(AUS) RT AFT ESCAPE SLIDE ASPIRATOR NOZZLE DAMAGED DUE TO INCORRECT POSITIONING OF THE ASPIRATOR DURING PACKING. INVESTIGATION FOUND THAT THE LOWER CHAMBER ASPIRATOR P/N 60322-103J WAS DISTORTED AND OUT OF SHAPE RESULTING IN THE FRACTURE OF THE NOZZLE MANIFOLSDR 9804949931Battery · dischargedDURING PERIODIC CHECK, MAIN CABIN DOOR EVACUATION SLIDE FAILED BATTERY TEST. REPLACED SLIDE.SDR CALA9800537Slide · inoperativeINSPECTION FOUND THE R-3 DOOR SLIDE BOTTLE PRESSURE LIGHT ILLUMINATED. THE R-3 DOOR SLIDE WAS REMOVED AND REPLACED AND THE LIGHT TESTED NORMAL.SDR 98UAL900130Slide · damagedDURING THE SHOP OVERHAUL OF A SLIDE/RAFT REMOVED FOR TIME EXPIRATION THE RIGHT HAND GIRT ATTACHMENT, PART NUMBER 5A22883-2, WAS FOUND TO BE TEARING LOOSE FROM THE BOTTOM TUBE. SLIDE/RAFT SENT TO VENDOR FOR REPAIR.SDR SWAA980368Slide · out of dateDURING SCHEDULED C2 CHECK, FOUND L-2 EMERGENCY EVACUATION SLIDE OUT OF DATE. REMOVED AND REPLACED PER BOEING MM.SDR AU980795Packboard · corroded(AUS) RIGHT OVERWING ESCAPE SLIDE CONTAINED MINOR CORROSION ON THE PACKBOARD AND SMALL AREAS OF CORROSION. SEE MDR 98/0794 FOR SIMILAR DEFECT ON LT SLIDE. PART TOTAL CYCLES: 23,395.SDR AU980794Strip · corroded(AUS) LEFT OVERWING ESCAPE SLIDE CONTAINED EXTENSIVE CORROSION ALONG THE EDGE OF THE REINFORCEMENT STRIP WITH A LARGE AREA OF DELAMINATION ALONG THE LOWER EDGE OF THE PACKBOARD. PART TOTAL CYCLES: 26,474.SDR 9804389921Slide · low pressureDURNG MAINTENANCE INSPECTION, FOUND TAIL CONE EVACUATION SLIDE BOTTLE LOW ON PRESSURE. REPLACED SLIDE.SDR CA980317036Slide · torn(CAN) SLIDE DEPLOYED AS PART OF SAMPLING PROGRAM. DEPLOYMENT NORMAL UNTIL TIE BACK SEPARATION. PRESSURE LOST IN LOWER TUBE DUE TO 14 INCH TEAR AT RT EDGE OF LOWER GIRT ASSY.SDR 9804379912Slide · failedDURING PERIODIC CHECK, FOUND MAIN CABIN DOOR EVACUATION SLIDE BATTERY LOW. REPLACED SLIDE.SDR USAAD98056Slide · inoperativePIT - AFT ESCAPE SLIDE FAILED TO DEPLOY DURING OPERATIONAL TEST. MAINTENANCE REPLACED THE SLDIE ASSEMBLY. TWO ADDITIONAL OPERATIONAL TESTS WERE SCHEDULED. (M)SDR SWA980225Slide · low pressDURING WALKAROUND CHECK, FOUND AFT SERVICE DOOR EMERGENCY SLIDE PRESSURE LOW. REMOVED AND REPLACED PER BOEING MM.SDR QXEA9800243Slide · malfunctionESCAPE SLIDE HAS UNLASHED CORDS AND THE LANYARD IS NOT ATTACHED TO THE AIRCRAFT STRUCTURE. REPLACED SLIDE.SDR F3LA98007Slide · deployedDEN - UPON ARRIVAL FLIGHT CREW REPORTED R-1 SLIDE DEPLOYED WHEN FORWARD SERVICE DOOR WAS OPENED. MAINTENANCE REPLACED SLIDE ASSEMBLY. (M)SDR QXEA9800240Slide · low pressEMERGENCY ESCAPE SLIDE READS BELOW 2600 PSI AT 70 DEGREES F. FERRIED AIRCRAFT FROM SJC TO GEG. REPLACED ESCAPE SLIDE.SDR SWAA980204Slide · low pressDURING SC, FOUND FWD SERVICE DOOR ESCAPE SLIDE PRESS LOW. REPLACED PER BOEING M/M.SDR MWEA98278Slide · defectiveTHE MAIN DOOR SLIDE PRESSURE GAUGE INDICATES IN THE RED. MTC REPLACED SLIDE.SDR SWAA980215Slide · low pressDURING RON, FOUND AFT SERVICE DOOR ESCAPE SLIDE PRESS LOW. REPLACED PER BOEING M/M.SDR UF6A980303Slide · disconnectedAZO - FLT 5707 - GIRT BAR DISCONNECTED FROM SLIDE ON FORWARD PAX DOOR. MAINTENANCE REMOVED AND REPLACED EMERGENCY ESCAPE SLIDE. SYSTEM OPS CHECKED GOOD. (M)SDR CALA9800344Slide · low pressureINSPECTION FOUND THE L-1 DOOR EMERGENCY SLIDE PACK PRESSURE LOW. THE L-1 DOOR EMERGENCY SLIDE WAS REMOVED AND REPLACED.SDR CALA9800343Slide · low pressureINSPECTION FOUND THE L-3 DOOR EMERGENCY SLIDE PACK PRESSURE LOW. THE L-3 DOOR EMERGENCY SLIDE WAS REMOVED AND REPLACED.SDR 9803469925Slide · low pressureDURING LINE MAINTENANCE INSPECTION, FOUND TAILCONE EVACUATION SLIDE BOTTLE PRESSURE LOW. REPLACED SLIDE, CHECKED OK.SDR AALA980407Cable · brokenTUL - GIRT BAR LANYARD, CABLE BROKEN AT THE SLIDE RELEASE PAWL MECHANISM (OVERHAUL DUE 7-98). REMOVED AND REPLACED SLIDE PER MM. TST: 44,584 HOURS. CYCLES: 24,187. (X)SDR UF6A980213Slide · looseORD - FLT 5730 - FORWARDED PASSENGER DOOR EVACUATION SLIDE IS DISCONNECTED FROM GIRT BAR. MAINTENANCE REMOVED AND REPLACED EVACUATION SLIDE. SYSTEM OPS CHECKED GOOD. (M)SDR QXEA9800080Slide · low pressureESCAPE SLIDE PRESSURE LOW. REPLACED ESCAPE SLIDE ASSEMBLY, OPERATIONAL CHECKS GOOD.SDR SWAA980203Slide · low pressDURING WALKAROUND CHECK, FOUND AFT ENTRY DOOR ESCAPE SLIDE PRESS LOW. REPLACED PER BOEING M/M.SDR MWEA98187Slide · inoperativeDUE TO SEVERAL WRITEUPS ON THE AFT GALLEY SLIDE GIRT BAR DIFFICULT TO ARM/DISARM. REPLACED AFT GALLEY SLIDE.SDR UF6A980210Slide · failed testSBN - FORWARD PASSENGER DOOR EVACUATION SLIDE FAILED BATTERY FUNCTION TEST. MAINTENANCE REMOVED AND REPLACED EVACUATION SLIDE. (M)SDR HALA9800062O-Ring · failedFLT 158 - HNL - FORWARD SERVICE DOOR SLIDE DID NOT DEPLOY PRESS ZERO. INSPECTION OF BOTTLE REVEILED THE MAIN 'O' RING COULD HAVE CAUSED THE PRESSURE TO LEAK OUT OF THE BOTTLE. WHEN A NEW BOTTLE WAS INSTALLED AND SLIDE TESTED, IT DEPLOYED AS ADVERTISED. REMOSDR UPS98825716Bottle · low pressureINSPECTION TYPE-A, FOUND ESCAPE SLIDE BOTTLE PRESSURE BELOW MINIMUMS, GUAGE READ 2300 PSI. REMOVED AND REPLACED ESCAPE SLIDE PER MM 25-60-01.SDR 98ZZZX2074Slide · deployedON PRE-FLIGHT FLIGHT 1322 IN CUN, R-1 DOOR SLIDE INADVERTENTLY DEPLOYED ON THE GROUND. REMOVED AND REPLACED R-1 DOOR SLIDE ASSEMBLY.SDR 98ZZZM542Slide Assy · failedDOOR 3L SLIDE WAS DEPLOYED AS PART OF AIR JAMAICA'S SAMPLING PROGRAM. THE SLIDE WAS EJECTED BUT DID NOT INFLATE. AN ATTEMPT OF MANUAL INFLATION ALSO PROVED FUTILE. (M)SDR SWAA980104Slide · tornDURING SCHEDULED C3 CHECK, FOUND AFT ENTRY DOOR SLIDE GIRT BAR MATERIAL TORN/FRAYED. REPAIRED PER BOEING MM.SDR TWRA9806Slide · brokenDURING SCHEDULED SLIDE DEPLOYMENT AT 5L DOOR, SLIDE FAILED TO DEPLOY. ON INVESTIGATION FOUND LEFT SIDE RELEASE CABLE WOULD NOT PULL PIN OUT OF THE PACKBOARD DUE TO THREADER STRAP BROKEN OFF FROM CABLE. SLIDE WAS REPLACED. (M)SDR SWAA980116Slide · out of dateDURING SCHEDULED A-2 CHECK, FOUND FWD ENTRY DOOR SLIDE ASSY INSPECTION DUE. REPAIRED PER BOEING MM.SDR AALA980237Slide · defectiveORD - DURING OVERNIGHT MAINTENANCE CHECK, FOUND TAIL CONE EVACUATION SLIDE PRESSURE INDICATOR IN THE RED BAND. REPLACED TAIL CONE EVACUATION SLIDE. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR USAAD98022Slide · puncturedPIT - THE GALLEY SERVICE DOOR EMERGENCY SLIDE INFLATION BOTTLE PUNCTURED THE SLIDE DURING INFLATION. MAINTENANCE REPLACED THE SLIDE ASSEMBLY. (M)SDR SWAA980100Slide · low pressureDURING SCHEDULED A2, FOUND AFT ENTRY DOOR EMERGENCY EXIT SLIDE LOW PRESSURE. REMOVED AND REPLACED PER BOEING MM.SDR 9801369974Slide · low pressureDURING LINE MAINTENANCE INSPECTION, FOUND MAIN CABIN DOOR EVACUATION SLIDE BOTTLE LOW ON PRESSURE. REPLACED SLIDE.SDR 9801349304Slide · low pressureDURING LINE MAINTENANCE INSPECTION, FOUND TAIL COMPARTMENT EVACUATION SLIDE BOTTLE PRESSURE LOW. REPLACED SLIDE.
Back to JASC 2565