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 95UAL900080Slide · failedSLIDE FAILED AIR RETENTION TEST. SCRAPPED SLIDE.SDR CAL950631Slide · low pressureIAH - FLT 0291 - INSPECTION FOUND THE AFT GALLEY DOOR EMERGENCY EVACUATION SLIDE WITH LOW PRESSURE DURING A PRE-FLIGHT CHECK. THE AFT GALLEY DOOR EMERGENCY EVACUATION SLIDE WAS REMOVED AND REPLACED. (X)SDR 95ZZZX5188Slide · inflatedJFK - NR 1L SLIDE BLOWN (SLIDE ACCIDENTALLY BLOWN - DOOR AND SLIDE OPERATED NORMALLY). REMOVED AND REPLACED NR 1L SLIDE/RAFT IAW MM 25-61-01.SDR JBXA089501Evac Slide · deployedRDU/FLL - FLT 33 - UPON ARRIVAL AT GATE, FLIGHT ATTENDANT LIFTED DOOR OPEN HANDLE WITHOUT DISARMING SLIDE. DOOR CONTACTED JETWAY, AND DID NOT FULLY OPEN. SLIDE UNRAVELED, BUT DID NOT DEPLOY DUE TO DOOR STRIKING JETWAY. AIRCRAFT FERRIED TO RDU WHERE SLIDE WASDR 95ZZZM620Escape Slide · tornESCAPE SLIDE AT POSITION L1 FRAYED AND TORN AT THE GIRT AREA. REMOVED AND REPLACED SLIDE, NOT RUBBING NOTED ON SCUFF PLATE.SDR ASAA9580162Evac Slide · defectiveANC - DURING GROUND SERVICING, THE EMERGENCY HANDLE ON THE AFT ENTRY DOOR WAS INADVERTENTLY PULLED WHICH JETTISONED THE TAILCONE. THE TAILCONE EMERGENCY EVACUATION SLIDE DID NOT DEPLOY AND THERE WAS NO DAMAGE TO THE TAILCONE. REINSTALLED THE TAILCONE AND REPSDR UPS803878Container · damagedWHILE ON GROUND, MAINTENANCE FOUND ESCAPE SLIDE CONTAINER CLIP BROKEN. REMOVED AND REPLACED ESCAPE SLIDE CONTAINER.SDR 95UAL900040Tube · failedSLIDE HAS POROSITY ON BOTH LT AND RT UPPER TOP TUBES, ASPIRATOR TUBE AREAS, AND ON THE ASPIRATOR TUBE SLEEVE. SCRAPPED SLIDE.SDR UPS803758Slide · frayedWHILE IN FOR C-CHECK, MAINTENANCE FOUND FWD ENTRY DOOR SLIDE GIRT FRAYED AND EXP DATE HAS THREE MONTHS LEFT. REPLACED ASSY IAW M/M 25-60-01.SDR MWEA95230Evac Slide · low pressureFOUND THE MAIN CABIN EMERGENCY EVAC DOOR SLIDE PRESSURE GAUGE JUST BELOW PRESSURE (IN THE RED). REPLACED THE FWD CABIN DOOR EVACUATION SLIDE.SDR JBXA950701Evac Slide · deployedFLT 167 - WHILE AT GATE ON 7-3-95, FLIGHT ATTENDANT LIFTED R-1 DOOR HANDLE TO 'CRACK' DOOR FOR CATERING. EVACUATION SLIDE WAS ARMED AND SLIDE DEPLOYED. NO INJURIES WERE REPORTED. AIRCRAFT WAS FERRIED BACK TO RDU WHERE SLIDE WAS REPLACED. (X)SDR AALA951176Seam · separatingORD - DURING SLIDE SHOP RECEIVING INSPECTION, EMERGENCY EVACUATION SLIDE, P/N 31073105, SEAMS AT BOTTLE HOLDER FOUND SEPARATING. REGLUED AND PATCHED BOTTLE HOLDER SEAMS DURING SHOP REPAIR PROCESS. (M)SDR 95ZZZX5191Slide · leakingIND - RIGHT NR 1 SLIDE IS ZERO PSI. REPLACED R-1 DOOR SLIDE, OK FOR SERVICE.SDR ASAA9580154Slide · low pressureSFO - DURING MAINTENANCE CHECK, THE L1 DOOR EMERGENCY EVACUATION SLIDE INFLATION BOTTLE PRESSURE WAS FOUND LOW. REPLACED THE L1 DOOR EMERGENCY EVACUATION SLIDE. (W)SDR MWEA95222Cable · detachedCREW REPORTS, GALLEY SERVICE DOOR GIRT BAR ATTACH CABLE CAME UNATTACHED. MAINTENANCE REATTACHED GIRT BAR CABLE, REINSTALLED SLIDE COVER. RETURNED A/C TO SERVICE.SDR AALA951139Slide · scrappedLAX - DURING SLIDE SHOP TEST DEPLOYMENT, EMERGENCY EVACUATION SLIDE HAD NUMEROUS LEAKS AT UPPPER TUBE AND SEAM AREAS. SCRAPPED EMERGENCY EVACUATION SLIDE. (W)SDR UPS803626Escape Slide · separatingWHILE IN C-CHECK MAINTENANCE, FOUND ESCAPE SLIDE CASE SEPARATING AT THE TOP. REPAIRED IAW SRM 51-1-2.SDR AALA951124Slide · scrappedLAX - DURING SHOP TEST DEPLOYMENT, EMERGENCY EVACUATION SLIDE FLOOR FOUND DETERIORATED AND SLIDE HAD POROSITY LEAKS. SCRAPPED EMERGENCY EVACUATION SLIDE. (M)SDR AALA951123Slide · scrappedLAX - DURING SHOP TEST DEPLOYMENT, EMERGENCY EVACUATION SLIDE FLOOR FOUND DETERIORATED. SCRAPPED EMERGENCY EVACUATION SLIDE. (M)SDR ASAA9580118Slide Bottle · low pressureSFO - DURING MAINTENANCE CHECK, THE R1 DOOR EMERGENCY EVACUATION SLIDE INFLATION BOTTLE PRESSURE WAS FOUND LOW. REPLACED THE R1 DOOR EMERGENCY EVACUATION SLIDE. (M)SDR ASAA9580114Evac Slide · failedOAK - DURING C-CHECK, THE FORWARD ENTRY DOOR EMERGENCY EVACUATION SLIDE EMERGENCY LIGHTS FAILED TEST. REPLACED THE EVACUATION SLIDE WITH A SERVICEABLE UNIT. (M)SDR 95UAL747034Aspirators · damagedAT DISASSEMBLY FOUND SUD SLIDE TURBO-FAN ASPIRATORS WITH BLADE DAMAGE. ADDITIONALLY, THE FLAPPER VALVE ROD FELL OUT. REPLACED 2 EACH TURBO FANS ASPIRATORS AND FLAPPER VALVE ROD.SDR 95UAL747033Slide · failedSPARE MED NR 3 SLIDE/RAMP INTERNAL BULKHEAD SEPARATED DURING INFLATION USING SHOP AIR. REPLACED UNIT.SDR 95ZZZX4138Escape Slide · malfunctionedLEFT AFT DOOR ESCAPE SLIDE DUE A SCHEDULED DEPLOYMENT BUT DID NOT DEPLOY CORRECTLY, IT WENT AFT OF THE FUSELAGE. REPLACED SLIDE.SDR ASAA9580112Slide Bottle · low pressureSEA - DURING MAINTENANCE CHECK, THE FORWARD ENTRY DOOR EMERGENCY EVACUATION SLIDE INFLATION BOTTLE PRESSURE WAS FOUND LOW. REPLACED THE FORWARD ENTRY DOOR EMERGENCY EVACUATION SLIDE. (M)SDR ORJA9547Lanyard · brokenMAIN ENTRY DOOR EMERGENCY SLIDE LANYARD BROKEN. REPLACED FORWARD ENTRY DOOR SLIDE LANYARD. (X)SDR 95ZZZW736Valve · failedMCI - DURING SHOP TEST, FOUND EVACUATION SLIDE, MFG P/N 7A127512, WOULD NOT MAINTAIN AIR PRESSURE. FOUND ASPIRATOR VALVE NOT PROPERLY CLOSING. REPAIRED ASPIRATOR VALVE. RETEST OF EVACUATION SLIDE OPERATION CHECKED NORMAL. (W)SDR ASAA9580109Evac Slide · failedSEA - DURING TRAINING DEMONSTRATION, THE L2 DOOR EMERGENCY EVACUATION SLIDE WAS DEPLOYED. AS THE SLIDE BEGAN TO DEPLOY, A RUPTURE OCCURRED AT THE UPPER END OF THE SLIDE. THE SLIDE CONTINUED TO DEPLOY BUT HAD A COMPLETE AIR LOSS. REPLACED THE L2 DOOR EMERGENSDR QXEA9500118Slide · low pressPDX - EVACUATION SLIDE HAS LOW PRESSURE. REPLACED SLIDE ASSY AND AIRCRAFT RETURNED TO SERVICE.SDR 95ZZZX6312Slide · malfunctionedDURING ESCAPE SLIDE OPENING OPERATION IAW ITEM 256120.06.1, FOUND NORMAL INFLATION UNTIL DOOR REACHES THE WING. FOUND QUICK DISCONNECT AIR BOTTLE WAS NOT FITTED TO THE SLIDE PIPE. PRESSURE GOES OUT, NO DEPLOYMENT. OPERATOR CONTROL NR 95/0BAH6/2.SDR 95ZZZX6309Slide · malfunctionedDURING ESCAPE SLIDE OPENING OPERATION IAW ITEM 256120.06.1, NORMAL SEQUENCE, BUT TOTAL DEPLOYEMENT TOO LONG. FOUND CENTRAL SCRATCH TWISTED WITH THE SLIDE. OPERATOR CONTROL NR 95/0BAH6/1.SDR MWEA95164Evac Slide · low pressureDURING ROUTINE INSPECTION, FOUND TAIL EVACUATION SLIDE PRESSURE LOW. REPLACED TAIL EVACUATION SLIDE. RETURNED A/C TO SERVICE.SDR ASAA9580070Slide · failedSEA - DURING MAINTENANCE CHECK, THE L1 DOOR EMERGENCY EVACUATION SLIDE PRESSURE WAS FOUND LOW. REPLACED THE EVACUATION SLIDE WITH A SERVICEABLE UNIT. (W)SDR 95UAL747021Bulkhead · failedSLIDE RAMP FAILED DURING FLAT FIRE IN SHOP. INTERNAL BULKHEAD FAILURE THE ENTIRE LENGTH OF SLIDE RAMP. SCRAPPED SLIDE RAMP.SDR 95ZZZX2635Cylinder · crackedON FILLING CYLINDER, A CRACK WAS SEEN ON NECK OF UNIT. THE PRESSURE WAS 2,000 PSI. UNIT WAS IMMEDIATELY DISCHARGED. UNIT WAS SENT TO AIR CRUISERS COMPANY FOR EVALUATION. SLIDE ASSEMBLY WAS RECEIVED BY EAM IN A DEPLOYED CONDITION. GAUGE ON CYLINDER ASSEMBLSDR TWRA9525Slide · brokenDURING 'A-2' SERVICE, FOUND 4R MED SLIDE SPRING LATCH, LOCATED ADJACENT TO THE ARMING PULLEY, BROKEN. REMOVED AND REPLACED 4R MED SLIDE. OPS CHECK OK. (W)SDR MWEA95153Evac Slide · low pressureDURING ROUTINE INSPECTION THE TAIL EVACUATION SLIDE PRESSURE WAS FOUND TO BE LOW. REMOVED AND REPLACED TAIL EVACUATION SLIDE AND RETURNED A/C TO SERVICE.SDR 95ZZZX6310Slide · malfunctionedDURING SLIDE SAMPLING OPERATION IAW ITEM 256120-06-1, ON NR 1 RIGHT DOOR, NORMAL OPERATION FOR DAMPER, PN 7010597000, PRESSURE 1,750 PSI (14 DEGREES CELSIUS), THE DOOR FAILED, STICKING IN MIDDLE OPENING POSITION WITH SLIDE INFLATION. THE GIRT BAR WAS IN NORMASDR 95ZZZX6308Slide · malfunctionDURING SLIDE SAMPLING OPERATION IAW ITEM 256120-06-1 ON NR 1 LEFT DOOR, NORMAL OPERATION FOR DOOR DAMPER, PN 70S5097000, PRESSURE 1,750 PSI (14 DEGREES CELSIUS), THE DOOR FAILED, STICKING IN MIDDLE OPENING POSITION WITH SLIDE INFLATION. AFTER 10 SECONDS, THE SDR 95UAL747019Slide · malfunctionedDURING INADVERTENT DEPLOYMENT, THE SUD SLIDE DID NOT FULLY INFLATE. REPLACED SLIDE. FLAPPER VALVE PIN WAS FOUND BROKEN. ADDITIONALLY, THE 410 POUND MECHANICAL RESTRAINT DID NOT SEPARATE. UNIT RETURNED TO VENDOR FOR REVIEW.SDR AALA950513Slide · failedORD - DURING SHOP TEST INFLATION, EMERGENCY EVACUATION SLIDE SEAM FAILED, SCRAPPED EMERGENCY EVACUATION SLIDE. (Z)SDR AALA950491Slide · failedLAX - DURING SHOP VISIT DEPLOYMENT, B767 EMERGENCY EVACUATION SLIDE HAD SLIDE SEAMS SEPARATING AND FLOOR LOOSE. SCRAPPED EMERGENCY EVACUATION SLIDE. (X)SDR MWEA95149Evac Slide · low pressureDURING ROUTINE DAILY INSPECTION THE GALLEY SERVICE DOOR EVACUATION SLIDE PRESSURE WAS FOUND TO BE LOW. REPLACED GALLEY SERVICE DOOR EVACUATION SLIDE. RETURNED A/C TO SERVICE.SDR 95ZZZW326Slide · detachedIND - FLT NR 975 - FORWARD ENTRY DOOR CHUTE FELL OUT OF ITS CASE AFTER PUSH OUT. REINSTALLED FORWARD CHUTE INTO CASE, SECURED NOW AND CHECKED OK.SDR AALA950425Slide · failedLAX - DURING SHOP VISIT DEPLOYMENT, EMERGENCY EVACUATION SLIDE HAD SEVERAL LARGE AREAS OF POROSITY LEAKS. SCRAPPED EMERGENCY EVACUATION SLIDE. (X)SDR AALA950423Slide · failedLAX - DURING SHOP VISIT DEPLOYMENT, EMERGENCY EVACUATION SLIDE HAD SEVERAL SEAMS LEAKING DUE TO MATERIAL DETERIORATION. SCRAPPED EMERGENCY EVACUATION SLIDE. (X)SDR AALA950417Slide · failedORD - DURING SHOP VISIT OVERPRESSURE CHECK, EMERGENCY EVACUATION SLIDE SEAM SEPARATED UNDER RUNWAY AND RUNWAY UNGLUED ON BOTTOM SIDE. SCRAPPED EMERGENCY EVACUATION SLIDE. (X)SDR 95ZZZX1193Escape Slide · fail testIND - DURING ROUTINE ESCAPE SLIDE OPERATIONAL CHECK, THE RT OVERWING SLIDE REMAINED ON TOP OF WING, ALL SECTIONS INFLATED, DOOR OPENED PROPERLY. SECTION OF VELCRO STRAPPING DID NOT LET LOOSE PREVENTING 3 BOTTOM SAETY WIRES (FUSE) FROM BREAKING. LARGE VELCRO SDR AALA950564Slide · leaksLAX - DURING SHOP VISIT DEPLOYMENT, B767 EMERGENCY EVACUATION SLIDE HAD SEVERAL LARGE AREAS WITH POROSITY LEAKS. SCRAPPED EMERGENCY EVACUATION SLIDE. (X)SDR AALA950317Slide · defectiveORD - DURING SHOP VISIT FOUND 2 RUNWAY SEAM SEPARATIONS OF 8 INCHES AND A FRAYED LATCH ASSEMBLY ON THE EMERGENCY EVACUATION SLIDE. ROUTED FOR REPAIR. (X)
Back to JASC 2565