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 97ZZZX2991Slide · damagedLEFT FORWARD EVACUATION SLIDE PACK-BOARD STRUCTURE WAS TORN AND SLIDE PARTIALLY PULLED FROM DOOR. REPLACED SLIDE.SDR AU970642Cable · frayed(AUS) FORWARD ENTRY DOOR ESCAPE SLIDE LATCH CABLE FRAYED IN AREA OF SWAGED BALL END TERMINALSDR TWRA97104Slide · inoperativeWHILE ATTEMPTING A SLIDE/RAFT DEMONSTRATION FOR A GROUP OF FLIGHT ATTENDANTS AT JFK, SLIDE P/N D30440-103 S/N 0509 MOUNTED AT 2R DOOR FAILED TO DEPLOY. REMOVED SLIDE AND PLACED IN QUARANTINE PENDING INVESTIGATION. A SERVICEABLE SLIDE WAS INSTALLED. (M)SDR AU970571Slide · failed(AUS) DOOR L1 ESCAPE SLIDE INADVERTENTLY DEPLOYED - SLIDE WOULD NOT INFLATESDR AWXA9700274Slide · blownCAPTAIN CALLED AT PUSH TIME WITH OVERWING SLIDE NOT SHOWING ARMED ON ECAM. REMOVED HANDLE ACCESS PANEL AND SLIDE ARMED LIGHT DID NOT COME ON. FOUND THE PIN THAT ARMS SLIDE JAMMED. PINNED DOOR SLIDE BOTTLE IN AFT PIT FOR LEFT WING SLIDE. WENT TO INSTALL PINSDR ASAA9780069Slide · failed testOAK - DURING C-CHECK, THE TAILCONE EMERGENCY EVACUATION SLIDE EMERGENCY LIGHTS FAILED TEST. REPLACED THE TAILCONE EMERGENCY EVACUATION SLIDE. (M)SDR ASAA9780068Slide · failed testOAK - DURING C-CHECK, THE L2 DOR EMERGENCY EVACUATION SLIDE EMERGENCY LIGHTS FAILED TEST. REPLACED THE L2 DOOR EMERGENCY EVACUATION SLIDE. (M)SDR 97UAL900333Slide · malfunctionedDOOR 1L SLIDE DID NOT INFLATE AUTOMATICALLY, SLIDE WAS MANUALLY DEPLOYED. CAUSE OF FAILURE TO AUTO-INFLATE UNKNOWN. HOME SHOP DISASSEMBLED AND INSPECTED SLIDE ASSEMBLY AND FOUND NO DEFECT.SDR DL757970753Slide · dischargedDURING GROUND SERVICING, R-1 DOOR SLIDE FELL OUT OF HOLDER DUE TO FLIGHT ATTENDENT NOT DISARMING DOOR SLIDE AND DOOR WAS OPENED FROM OUTSIDE BY CATERING. THE OUTSIDE HANDLE DID NOT DISARM THE DOOR EITHER. THE DOOR DISARM CABLE WAS RIGGED PER MAINTENANCE MANSDR EISA97085Slide · low pressureFORWARD ENTRY DOOR EMERGENCY SLIDE PRESSURE LOW. REPLACED FORWARD EMERGENCY SLIDE IAW MM CHAPTER 25. (M)SDR TWAA9750005Slide · deployedSTL - FLT 422 - WHILE AIRCRAFT WAS PARKED AT GATE, A VENDOR INADVERTENTLY DEPLOYED L-1 DOOR EMERGENCY ESCAPE SLIDE, WHICH FUNCTIONED PROPERLY. REMOVED AND REPLACED L-1 DOOR SLIDE, MFG P/N 100504-201, MANUFACTURED BY BF GOODRICH CO. (M)SDR AALA970747Slide · malfunctionedTUL - FOUND LEFT FORWARD ENTRY DOOR EVACUATION SLIDE DEPLOYED PER CARD 4993 DEFLATED TO AN UNUSABLE CONDITION IN LESS THAN 15 MIN, APPROX 8 MIN PER ITEM NR 7. FLAPPER VALVES LEAKING. REMOVED AND REPLACED SLIDE OR CARD 4493 ITEM. (M)SDR TWRA9765Slide · deployedWHILE CHECKING L2 DOOR WARNING LIGHT SWITCH AT CGK, THE SLIDE RAFT DEPLOYED AND THE DOOR ASSIST BOTTLE DEPLETED. DEFERRED ITEM PER MEL 25-10-B PER LOG PAGE 60589 ITEM 1. (M)SDR MZZA97081Cable · frayedKUL - NRC 826112. R1 CABIN DOOR ESCAPE SLIDE LATCH ASSY CABLE FRAYED. REMOVED AND REPLACED ESCAPE SLIDE CABLE ASSY IAW MM 25-60-15. (X)SDR MZZA97080Cable · frayedKUL - NRC 826113. L1 CABIN DOOR ESCAPE SLIDE LATCH ASSY CABLE FRAYED. REMOVED AND REPLACED ESCAPE SLIDE LACH ASSY IAW MM 25-60-15. (X)SDR GTIA9700274Slide · fell offDTW - FLT 566 - GALLEY SERVICE DOOR SLIDE PACK CAME OFF. REPLACED GALLEY DOOR SLIDE PACK IAW DC9 MM 25-61. OPS CHECK GOOD. (M)SDR 9707229916Evac Slide · low pressureDURING LINE MAINTENANCE INSPECTION, FOUND TAIL CONE EVACUATION SLIDE BOTTLE RPESSURE LOW. REPLACED SLIDE.SDR 9706659878Evac Slide · low pressureDURING LINE MAINTENANCE INSPECTION, FOUND TAIL EVACUATION SLIDE BOTTLE PRESSURE LOW. REPLACED SLIDE.SDR 9706649960Evac Slide · low pressureDURING LINE MAINTENANCE INSPECTION, FOUND GALLEY DOOR EVACUATION SLIDE BOTTLE PRESSURE, TO BE LOW. REPLACED SLIDE.SDR 9706469881Slide · low pressureDURING LINE MAINTENANCE INSPECTION, FOUND TAIL CONE SLIDE PRESSURE LOW. REPLACED SLIDE.SDR ASAA9780047Bottle · low pressurePDX - DURING MAINTENANCE CHECK, THE R1 DOOR EMERGENCY EVACUATION SLIDE INFLATION BOTTLE PRESSURE WAS FOUND LOW. REPLACED THE R1 DOOR EMERGENCY EVACUATION SLIDE. (M)SDR ASAA9780046Slide · failed testOAK - DURING C-CHECK, THE L2 DOOR EMERGENCY EVACUATION SLIDE EMERGENCY LIGHTS FAILED TEST. REPLACED THE L2 DOOR EMERGENCY EVACUATION SLIDE. (M)SDR AU970329Slide · failed(AUS) RH UPPER DECK ESCAPE SLIDE FAILED TO FULLY DEPLOY DURING TEST DUE TO THE FAILURE OF THE FUSEABLE LINKS/BOLTS TO RELEASE THE INFLATED SLIDESDR CALA9700312Slide · leakingTHE LT AFT GALLEY SLIDE PACK BEGAN TO DEPRESSURIZE DURING ARMING OF SLIDE. THE SLIDE WAS REMOVED AND REPLACED IAW MM 25-60-0.SDR 9704759956Slide · low pressureDURING PERIODIC CHECK, FOUND TAIL COMPARTMENT EVACUATION SLIDE WITH LOW BOTTLE PRESSURE. REPLACED SLIDE.SDR AU970390Slide · faulty(AUS) DOOR 2R ESCAPE SLIDE GROUND MAINTENANCE SAFETY PIN FOUND INSTALLED IN ACTUATION MECHANISM - PERSONNEL/MAINTENANCE ERRORSDR 9704539948Slide · low batteryDURING PERIODIC CHECK, MAIN CABIN DOOR EVACUATION SLIDE FAILED BATTERY TEST. REPLACED SLIDE.SDR 9704549925Slide · low pressureDURING LINE MAINTENANCE INSPECTION, FOUND TAIL EVACUATION SLIDE BOTTLE PRESSURE LOW. REPLACED SLIDE.SDR 9704529993Slide · low batteryDURING PERIODIC CHECK, MAIN CABIN DOOR EVACUATION SLIDE FAILED BATTERY TEST. REPLACED SLIDE.SDR ASAA9710017Slide Bottle · low pressureSEA - DURING SCHEDULED MAINTENANCE, THE L1 DOOR EMERGENCY EVACUATION SLIDE INFLATION BOTTLE PRESSURE WAS FOUND LOW. REPLACED THE EMERGENCY EVACUATION SLIDE. (M)SDR 97UAL900161Inflation Hose · looseSLIDE/RAFT REMOVED FOR TIME CONTROLLED OVERHAUL. INFLATION HOSES FOUND LOOSE AT ASPIRATOR CONNECTION. SLIDE MAY HAVE NOT INFLATED FULLY IF DEPLOYED. INFLATION HOSES TIGHTENED. THIS IS SECOND INCIDENT OF LOOSE INFLATION HOSES. UNITED WILL CONDUCT A SAMPLESDR 97UAL900164Inflate Tube · tornSLIDE/RAFT REMOVED DUE TO INADVERTENT DEPLOYMENT. DURING DEPLOYMENT, SLIDE/RAFT STRUCK OBJECT CAUSING TEARING OF THE CENTER INFLATION TUBE AND CROSS TUBE. SLIDE RAFT REPAIRED AND OVERHAULED BY B.F. GOODRICH, ONTARIO. MAJOR REPAIR APPROVED BY THE LOS ANGELESSDR 9704119906Slide · low pressureDURING LINE MAINTENANCE INSPECITON, FOUND AFT EMERGENCY EXIT EVACUATION SLIDE PRESSURE LOW. REPLACED SLIDE.SDR AU970720Slide · faulty(AUS) DOOR 1L AND 1R ESCAPE SLIDES HAD MAINTENANCE PINS FITTED -PERSONNEL/MAINTENANCE ERRORSDR VJ970122Slide · malfunctionedCHECKED REAR EVACUATION SLIDE FOR PROPER SERVICING. AS PRECAUTIONARY MEASURE, REMOVED AND REPLACED TAILCONE SLIDE PER MM 25-60. (M)SDR 97UAL900137Slide · porousSLIDE REMOVED FROM AIRCRAFT FOR TIME CONTROLLED OVERHAUL. UNIT FAILED AIR RETENTION DUE TO POROSITY ON THE UPPER AND LOWER TUBE. SCRAPPED INFLATABLE UNIT, REPLACED WITH NEW.SDR 97UAL900136Girt · wornSLIDE REMOVED FROM AIRCRAFT FOR A TIME CONTROLLED OVERHAUL. DURING CHECK, CHAFE DAMAGE WAS NOTED IN THE SLIDE GIRT AND INFLATABLE. DAMAGE APPEARS TO BE CAUSED BY THE BACKBOARD RELEASE LATCHES. *S/D* NOTIFIED LOCAL BOEING FIELD REPRESENTATIVE. REPAIRED CHASDR USAABB97018Slide · malfunctionedPHL - FL11, ON ARRIVAL IN PHL, THE LEFT FORWARD DOOR WAS OPEN WITH THE ESCAPE SLIDE STILL IN THE ARMED POSITION. THE SLIDE DID NOT DEPLOY. MAINTENANCE REPLACED THE SLIDE. AN EVALUATION BY THE SLIDE SHOP AND ENGINEERING COULD NOT DETERMINE THE CAUSE FOR THE SDR AALA970340Slide · failed testJFK - DURING OVERNIGHT CHECK, EMERGENCY EVACUATION SLIDE/RAFT AT L4 DOOR DID NOT PASS LIGHTING SYSTEM FUNCTIONAL CHECK. REPLACED EMERGENCY EVACUATION SLIDE/RAFT AT L4 DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR 9703139944Slide Battery · dischargedDURING PERIODIC CHECK, THE SERVICE DOOR EVACUATION SLIDE FAILED BATTERY TEST. REPLACED SLIDE.SDR 97UAL900135Hose · looseSLIDE REMOVED FROM THE AIRCRAFT DUE TO LOW BOTTLE PRESSURE. DURING BOTTLE REPLACEMENT, INFLATION HOSES WERE LOOSE AT THE ASPIRATOR CONNECTION. SLIDE MAY HAVE NOT DEPLOYED. TIGHTENED HOSES. CONTACTED BF GOODRICH WHICH LAST OVERHAULED SLIDE.SDR GTIA9700194Cable · frayedYIP - GALLEY DOOR EVACUATION SLIDE CABLE FRAYED AT TOGGLE. REPLACED CABLE. (X)SDR ASAA9710010Evac Slide · wornSEA - DURING CHECK, THE FORWARD ENTRY DOOR EMERGENCY ESCAPE SLIDE GIRT LOWER SIDE WAS FOUND TO BE WORN IN FABRICATED. REPLACED FORWARD ENTRY DOOR EMERGENCY ESCAPE SLIDE. (M)SDR 9702959917Slide Battery · dischargedDURING PERIODIC CHECK, GALLEY SERVICE DOOR EVACUATION SLIDE FAILED BATTERY TEST. REPLACED SLIDE.SDR 9702939917Slide Battery · dischargedDURING PERIODIC CHECK, MAIN CABIN DOOR EVACUATION SLIDE FAILED BATTERY TEST. REPLACED SLIDE.SDR AU970171Slide · faulty(AUS) SAFETY SLIDE DID NOT DEPLOY DURING TEST - INVESTIGATION FOUND THE SAFETY PIN STILL INSTALLED - SLIDE OPERATED MANUALLY WHEN SAFETYPIN WAS REMOVED - PERSONNEL/MAINTENANCE ERRORSDR 97UAL900125Velcro Strap · wornSLIDE DOOR 1R VELCRO WILL NOT HOLD GIRT BAR. GIRT STRAP VELCRO LOOP MATERIAL (ATTACHED TO SLIDE BOTTLE) WAS WORN. REPLACED SLIDE. CURRENT MODIFICATION IN PROCESS WILL ELIMINATE GIRT STRAPS.SDR 97UAL900118Slide Bottle · low pressureDOOR 2L SLIDE PRESSURE APPROXIMATELY 2700 PSI. SLIDE PRESSURE BOTTLE APPEARED TO BE COLD SOAKED. PRESSURE READ NORMAL AT ROOM TEMPERATURE.SDR SWAA970185Slide · low pressDURING SCHEDULED SERVICE CHECK, FOUND RIGHT AFT SERVICE DOOR SLIDE PRESSURE LOW. REPLACED SLIDE PER BOEING M/M.SDR 97UAL900115Slide Bottle · low pressureEMERGENCY SLIDE AT DOOR 1 RT READS LOW ON PRESSURE. READS 2800 AT 70 DEGREES. SLIDE PRESSURE BOTTLE APPEARED TO BE COLD SOAKED. PRESSURE READS NORMAL AT ROOM TEMPERATURE.
Back to JASC 2565