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 SWAA001278Indicator · out of positionDURING SCHEDULED SERVICE CHECK, FOUND BOTH AFT EVACUATION SLIDE PRESSURE INDICATORS OUT OF VIEW. REPOSITIONED SLIDE ASSY''S PER MM.SDR SWAA001277Bracket · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FWD SERVICE DOOR EVACUATION SLIDE GIRT BAR AFT FLOOR ATTACH BRACKET CORRODED. REMOVED AND REPLACED BRACKET PER MM.SDR SWAA001276Bracket · looseDURING SCHEDULED C3 CHECK, FOUND FWD ENTRY DOOR EVACUATION SLIDE GIRT BAR ATTACH BRACKETS LOOSE ON CONTAINER. SECURED BRACKETS PER MM.SDR SWAA001272Slide · deployedFWD SERVICE DOOR EVACUATION SLIDE DEPLOYED INADVERTENTLY, (STILL CONNECTED TO GIRT BAR FLOOR BRACKETS WHEN DOOR WAS OPENED). REMOVED AND REPLACED SLIDE ASSY PER MM.SDR ASAA0080432Slide · failedOAK - DURING C-CHECK, THE R1 DOOR EMERGENCY EVACUATION SLIDE FAILED THE EMERGENCY LIGHT AMP TEST. REPLACED THE R1 DOOR EMERGENCY EVACUATION SLIDE ASSEMLBY. (M)SDR ASAA0080431Slide · failedOAK - DURING C-CHECK, THE L2 DOOR EMERGENCY EVACUATION SLIDE FAILED THE EMERGENCY LIGHT AMP TEST. REPLACED THE L2 DOOR EMERGENCY EVACUATION SLIDE ASSEMBLY. (M)SDR ASAA0080430Slide · failedPHX - DURING 30K CHECK, THE L1 DOOR EMERGENCY EVACUATION SLIDE FAILED THE EMERGENCY LIGHT AMP TEST. REPLACED THE L1 DOOR EMERGENCY EVACUATION SLIDE ASSEMBLY. (M)SDR SWAA001263Indicator · out of positionDURING SCHEDULED C1 CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE PRESSURE INDICATOR LOW. REPOSITIONED SLIDE ASSY PER MM.SDR 20001017AP007Slide · dislodgedFLT 8162 - SFO - AFTER PARKING AT GATE AND FOLLOWING RYAN DOOR DISARMING PROCEDURES AND ALL CREW MEMBERS VERIFIED SLIDE DISARMED, FORWARD (LEFT) ENTRY DOOR SLIDE UNPACKED FROM DOOR. REPLACED SLIDE. (M)SDR 2000UALA00413Slide · deployedAFT GALLEY DOOR SLIDE WAS INADVERTENTLY DEPLOYED. *S/D* SLIDE INADVERTENTLY BLOWN BY CONTRACT CLEANERS.SDR MALA000384Slide · deployedEVACUATION SLIDE WAS DISCHARGED. CREW NEGLECTED TO DISARM THE SLIDE PRIOR TO OPENING DOOR. MAINTENANCE REMOVED BLOWN SLIDE FROM RT DOOR, INSPECTED AC AND FOUND IT SAFE FOR FERRY FLIGHT FROM STL TO MEM WITH RT SLIDE DISCHARGED. REMOVED AND REPLACED FWD RT ESSDR SWAA001248Slide · dischargedDURING SCHEDULED SERVICE CHECK, FOUND FWD ENTRY DOOR EVACUATION SLIDE PRESSURE INDICATION LOW. R&R SLIDE ASSY PER MM.SDR SWAA001247Girt Bar · out of adjFWD SERVICE DOOR EVACUATION SLIDE GIRT ASSY OUT OF ADJUSTMENT. REINSTALLED SLIDE ASSY PER MM.SDR 2000UALA00406Valve · leakingDURING SHOP OVERHAUL DOOR 1LH SLIDE/RAFT ASSEMBLY (P/N: 62771-117, S/N: 0021) FAILED AIR RETENTION TEST. FOUND THE BOTTOM TUBE INFLATE/DEFLATE VALVE (P/N B51007-2) LEAKING. REPLACED VALVE AND UNIT PASSED AIR RETENTION CHECK.SDR SWAA001264Slide · dislodgedFWD ENTRY DOOR EVACUATION SLIDE FELL OUT OF CONTAINER INADVERTENTLY. (GIRT BAR STILL HOOKED TO FLOOR). REINSTALLED SLIDE ASSY PER MM.SDR SWAA001228Girt Bar · out of adjDURING SCHEDULED BC4 CHECK, FOUND FWD SERVICE DOOR EVACUATION SLIDE GIRT ASSY OUT OF ADJUSTMENT. REINSTALLED SLIDE ASSY PER MM.SDR MALA000378Slide · dislodgedEVACUATION SLIDE ACCIDENTALLY FELL FROM MOUNTING. MAINTENANCE REPLACED EVAC SLIDE. SECURITY GOOD.SDR TWAA0010502Bottle · dischargedWHILE CLOSING THE FORWARD LEFT CABIN DOOR THE EVACUATION SLIDE BOTTLE DISCHARGED. THE SLIDE DID NOT DEPLOY. BOTTLE REPORTEDLY WAS CRACKED. REPLACED THE SLIDE ASSEMBLY. CHECK-C 5-24-00 JFK. ---CLOSED---SDR 00FDEA00426Slide · tornN 45 DURING ROUTINE INSPECTION, FWD ENTRY DOOR EMERGENCY ESCAPE SLIDE GIRT ASSY FOUND FRAYED & TORN. R&R GIRT ASSY IAW SRM 51-40-9.SDR SWAA001219Slide · dislodgedFWD ENTRY DOOR EVACUATION SLIDE INADVERTENTLY FELL OUT OF CONTAINER AS DOOR WAS OPENING. REINSTALLED SLIDE PER MM.SDR SWAA001209Slide · dislodgedFWD SERVICE DOOR EVACUATION SLIDE FELL OUT OF CONTAINER INADVERTENTLY AS PROVISONER WAS OPENING DOOR. REINSTALLED SLIDE ASSY PER MM.SDR TWAA0010701Cable · brokenTHE RT SIDE FWD ESCAPE SLIDE LANYARD WAS FOUND BROKEN. REPLACED THE LANYARD. CHECK-C 11-25-99 STL.SDR DL733001255Slide · dislodged1R DOOR ESCAPE SLIDE ON FLOOR. SLIDE PARTILLY DEPLOYED UPON REMOVAL. RPLD DOOR SLIDE.SDR SWAA001207Girt Bar · out of adjDURING SCHEDULED C1 CHECK, FOUND BOTH AFT DOOR EVACUATION SLIDE GIRT ASSY''S OUT OF ADJUST. REINSTALLED BOTH SLIDE ASSY''S PER MM.SDR SWAA001206Slide · dischargedDURING SCHEDULED SERVICE CHECK, FOUND FWD SERVICE DOOR EVACUATION SLIDE PRESS IND LOW. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR AWXA0000442Slide · deployedL2 DOOR OPENED AT GATE, WHILE SLIDE WAS ARMED. REPLACED SLIDE.SDR ASAA0080408Slide · failedPHX - DURING 30K CHECK, THE L2 DOOR EMERGENCY EVACUATION SLIDE FAILED THE EMERGENCY LIGHT AMP TEST. REPLACED THE L2 DOOR EMERGENCY EVACUATION SLIDE ASSEMLBY. (M)SDR SWAA001198Slide · dischargedAFT SERVICE DOOR EVACUATION SLIDE PRESSURE INDICATOR SHOWS A LOW CHARGE. R&R SLIDE ASSY PER MM.SDR SWAA001187Slide · looseDURING SCHEDULED RON CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE LOOSE FROM CONTAINER DUE TO INADVERTANT DROP. REINSTALLED SLIDE ASSY PER MM.SDR CA000714013Retainer · corroded(CAN) DURING SLIDE/RAFT REPLACEMENT, THE GIRT BAR RETAINER PLATE FOUND SPLIT IN HALF DUE TO EXCESSIVE CORROSION. PLATE REPLACED AND FLEET CAMPAIGN WILL BE DONE TO VERIFIED THE CONDITION OF THE PLATE AS PER SPECIAL INSPECTION 3-25-30 REV-0.SDR SWAA001199Slide · out of adjDURING SCHEDULED C1 CHECK, FOUND BOTH FWD DOOR EVACUATION SLIDES OUT OF ADJUSTMENT OF DOOR. REPOSITIONED BOTH SLIDE ASSY''S PER MM.SDR SWAA001191Slide · dislodgedAFT SERVICE DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR 2000UALA00400Slide · tornSLIDE/RAFT MR25612-032, MANUFACTURERS PART NUMBER D30665-105, SERIAL NUMBER A5824, MANUFACTURE DATE 12/93, DEVELOPED A SEAM TEAR OF OVER 3 FEET IN LENGTH. THE TEAR WAS IN THE LOWER TUBE ON THE MID SPAN CROSSOVER TUBE RIGHT HAND SIDE. THIS TEAR HAPPENED DURINSDR CALA0000996Slide · will not testTHE AFT TAILCONE SLIDE FAILED EMERGENCY SLIDE LIGHTS FUNCTIONAL TEST. THE SLIDE WAS REMOVED AND REPLACED IAW MM 25-62-00.SDR SWAA001174Slide · dischargedDURING SCHEDULED RON CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE PRESSURE LOW. R&R SLIDE ASSY PER MM.SDR SWAA001186Slide · dislodgedFWD ENTRY DOOR EVACUATION SLIDE FELL OUT OF CONTAINER AS DOOR WAS OPENING. REINSTALLED SLIDE ASSY PER MMSDR SWAA001164Indicator · out of positionAFT ENTRY DOOR EVACUATION SLIDE PRESS INDICATOR IS OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR 2000UALA00369Slide · leakingDURING SHOP OVERHAUL DOOR 4 RT SLIDE/RAFT ASSEMBLY (P/N: 62774-402, S/N: 0222) FAILED AIR RETENTION TEST. THE INFLATABLE ASSEMBLY (62424-402) TOP TUBE ASPIRATOR FLAPPER VALVE AND ASPIRATOR FLANGE WERE FOUND LEAKING (ASPIRATOR P/N: 62510-101). UNIT RETURNED TSDR 2000UALA00356Slide · tornDURING SHOP OVERHAUL OF EVACUATION SLIDE A MASSIVE FABRIC FAILURE WAS SUSTAINED AT THE RELIEF VALVE ASSEMBLY WHILE INFLATING UNIT TO PROOF PRESSURE. UNIT FAILED AT ABOUT 3.50 PSI. SLIDE ASSEMBLY SENT TO VENDOR FOR INVESTIGATION OF FAILURE AND WARRANTY REPAIRSDR ASAA0040084Bottle · dischargedSEA - DURING MAINTENANCE CHECK, THE L1 DOOR EVACUATION SLIDE BOTTLE WAS FOUND TO HAVE LOW PRESSURE. REPLACED THE L1 DOOR EVACUATION SLIDE ASSEMBLY. ROUTED THE SLIDE ASSEMBLY FOR INSPECTION AND REPAIR. (M)SDR SWAA001176Slide · dislodgedFWD SERVICE DOOR EVACUATION SLIDE DROPPED OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR SWAA001154Slide · dischargedFWD SERVICE DOOR EVACUATION SLIDE PRESSURE INDICATOR READS LOW. R & R SLIDE ASSY PER MM.SDR SWAA001153Slide · dislodgedFWD ENTRY DOOR EVACUATION SLIDE FELL OUT OF CONTAINER INADVERTENTLY (GIRT BAR IMPROPERLY STOWED). REINSTALLED SLIDE ASSY.SDR SWAA001148Slide · dischargedFWD ENTRY DOOR EVACUATION SLIDE PRESSURE INDICATOR READS LOW. R & R SLIDE ASSY PER MM.SDR AALA20000933Slide · malfunctionedEZE - WHILE ON GROUND, R1 DOOR SLIDE WAS UNSUCCESSFULLY INADVERTENTLY DEPLOYED. INSTALLED SLIDE AT R1 DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR SWAA001150Indicator · out of positionDURING SCHEDULED SERVICE CHECK, FOUND AFT ENTRY DOOR EVACUATION SLIDE PRESSURE INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA001145Slide · dischargedDURING SCHEDULED SERVICE CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE PRESSURE INDICATOR READING LOW. R & R SLIDE ASSY PER MM.SDR SWAA001135Slide · dislodgedAFT SERVICE DOOR EVACUATION SLIDE FELL OUT OF CONTAINER INADVERTENTLY. R & R SLIDE ASSY PER MM.SDR AU000520Slide · faulty(AUS) DOOR 5 RT ESCAPE SLIDE INFLATED WITH DOOR CLOSED AND LOCKED. SAFETY PIN STILL IN POSITION.SDR SWAA001116Slide · dislodgedFWD ENTRY DOOR EVACUATION SLIDE FELL OUT OF CONTAINER AS DOOR WAS CLOSING DUE TO GIRT BAR NOT PROPERLY STOWED. REINSTALLED SLIDE ASSY PER MM.
Back to JASC 2565