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 SWAA991925Slide · tornDURING SCHEDULED SERVICE CHECK, FOUND AFT ENTRY DOOR EVACUATION SLIDE GIRT FABRIC TORN. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA991924Slide · saggingDURING SCHEDULED SERVICE CHECK, FOUND FWD ENTRY DOOR EVACUATION SLIDE GIRT ASSY EXTENDING OUT OF LIMITS. ADJUSTED SLIDE PER MM.SDR SWAA991923Brackets · corrosionDURING SCHEDULED 1/2D CHECK, FOUND FWD ENTRY AND SERVICE DOOR EVACUATION SLIDE GIRT BAR FLOOR ATTACH BRACKETS CORRODED. REMOVED AND REPLACED BRACKETS PER MM.SDR SWAA991917Slides · saggingDURING SCHEDULED SERVICE CHECK, FOUND FWD ENTRY AND AFT SERVICE DOOR EVACUATION SLIDE GIRT ASSY'S EXTENDING OUT OF LIMITS. ADJUSTED SLIDES PER MM.SDR SWAA991916Slides · saggingDURING SCHEDULED SERVICE CHECK, FOUND BOTH FWD DOOR EVACUATION SLIDE GIRT ASSY'S EXTENDING OUT OF LIMITS. ADJUSTED SLIDES PER MM.SDR SWAA991912Slide Assy · saggingDURING SCHEDULED SERVICE CHECK, FOUND BOTH FWD DOOR EVACUATION SLIDE GIRT ASSY'S EXTENDING OUT OF LIMITS. ADJUSTED SLIDE ASSY'S PER MM.SDR SWAA991911Slide Assy · saggingDURING SCHEDULED SERVICE CHECK, FOUND FWD ENTRY AND AFT SERVICE DOOR EVACUATION SLIDE GIRT ASSY'S EXTENDED OUT OF LIMITS. ADJUSTED BOTH SLIDE ASSY'S PER MM.SDR SWAA991910Slide Assy · ring pulledDURING SCHEDULED C2 CHECK, FOUND FWD SERVICE DOOR EVACUATION SLIDE GIRT BAR CHAIN ATTACH RING PULLED APPART. REMOVED AND REPLACED SLIDE ASSY.SDR SWAA991905Brackets · incorrect instalAFT ENTRY DOOR EVACUATION SLIDE GIRT BAR RETAINING BRACKETS INCORRECTLY INSTALLED. REINSTALLED BRACKETS PER MM.SDR 99ZZZX4310Hose · wrong partEVACUATION SLIDE/RAFT RECEIVED WITH INCORRECT HOSES. CORRECT HOSES P/N SHOULD BE 720111-101. NOTE: THIS UNIT WAS LAST OVERHAULED IN 6-98.SDR AALA991696Girt Bar · brokenSFO - DURING OVERNIGHT MAINTENANCE, RIGHT SLIDE PACK RELEASE BAR BRACKETS BROKEN. REPLACED RIGHT SLIDE PACK. SYSTEM GROUND CHECK NORMAL OPERATION. (M)SDR SWAA991875Slide · out of positi0nDURING SCHEDULED SERVICE CHECK, FOUND FWD SERVICE DOOR EVCUATION SLIDE GIRT ASSY EXTENDING OUT OF LIMITS. ADJUSTED SLIDE ASSY PER MM.SDR RAAA99E4080Mount · stickingEMERGENCY EVACUATION SLIDE AT PAX ENTRY DOOR, STICKING IN FLOOR SLOT. LUBRICATED EVAC SLIDE MOUNTS, OPERATION CHECKED NORMAL.SDR AALA996039Slide · looseSJC - MAIN ENTRY DOOR SLIDE STARTED TO COME OUT OF CASE. REINSTALLED LATCH. (M)SDR SWAA991817Slide · deployedFWD ENTRY DOOR EVACUATION SLIDE INADVENTENTLY DEPLOYED. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA991800Slide · failedAFT ENTRY EVACUATION SLIDE PRESS IND LOW. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR CA991210031Slide Raft · failed(CAN) R1 DOOR SLIDE/RAFT FAILED TO DEPLOY ON TEST. PACKBOARD SPEED LACING DID NOT RELEASE. UNIT REPLACED.SDR SWAA991760Slide · looseDURING SCHEDULED C3 CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE GIRT DRAGGING ON FLOOR. REINSTALLED SLIDE ASSY PER MM.SDR SWAA991753Chain · brokenFWD ENTRY DOOR EVACUATION SLIDE LATCH CHAIN BROKEN. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR AU991044Slide · failed(AUS) LEFT UPPER DECK ESCAPE SLIDE FAILED TO FULLY DEPLOY DUE TO THE FORWARD BELLCRANK CONTACTING A DOOR FITTING.SDR SWAA991741Cable · out of positionDURING SCHEDULED C CHECK, FOUND AFT ENTRY DOOR SLIDE GIRT BAR CABLE OUT OF POSITION. REROUTED SLIDE CABLE PER MM.SDR SWAA991737Indicator · out of positionAFT SERVICE DOOR EVACUATION SLIDE PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA991725Slide · deployedDURING SCHEDULED SPECIAL VISIT, FWD SERVICE DOOR EVACUATION SLIDE INADVERTENTLY DEPLOYED. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA991723Bottle · dischargedDURING SCHEDULED SERVICE CHECK, FOUND FWD SERVICE DOOR EVACUATION SLIDE BOTTLE PRESSURE LOW. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR 9904381161Slide · malfunctionedDURING CRUISE DOOR 1L EMERGENCY EVACUATION SLIDE PARTIALLY INFLATED AND BROKE OUT OF THE COVER. THE SLIDE WAS PUNCTURED TO DEFLATE AND MOVED OUT OF GALLEY AREA. FLIGHT CONTINUED TO DTW AND LANDED WITHOUT INCIDENT. MAINTENANCE REPLACED THE SLIDE, COVER, AND SDR AALA996020Evac Slide · openRNO - AFT GALLEY SLIDE PACKS NEEDS TO BE STOWED. REINSTALLED SLIDE COVER IN AFT GALLEY PER MM. (M)SDR EISA99174Slide · failedTAILCONE SLIDE DEPLOYMENT BOTTLE LOW PRESSURE. REPLACED SLIDE. (M)SDR DL76L992225Charger · inoperativeLEFT EMERGENCY ESCAPE SPOILER SQUIB WOULD NOT TEST ON TEST 2. REPLACED CHARGER, TEST CHECKS OK.SDR DL76L992224Battery · inoperativeRIGHT EMERGENCY ESCAPE SLIDE SQUIB WOULD NOT TEST ON TEST 1. REPLACED BATTERY, TEST CHECKS OK.SDR ASAA9980201Slide · won't testPHX - DURING C-CHECK, THE R1 DOOR EMERGENCY EVACUATION SLIDE FAILED THE EMERGENCY LIGHT AMP TEST. REPLACED THE R1 DOOR EMERGENCY EVACUATION SLIDE ASSEMBLY. (M)SDR SWAA991640Slide · tornDURING SCHEDULED RON, FOUND AFT ENTRY DOOR EVACUATION SLIDE TORN ON AFT SIDE. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA991638Cable · misroutedDURING SCHEDULED C3 CHECK, FOUND FWD ENTRY DOOR EVACUATION SLIDE RELEASE CABLE IMPROPERLY ROUTED. REROUTED CABLE PER MM.SDR SWAA991629Cable · frayedDURING SCHEDULED C4 CHECK, FOUND AFT ENTRY EVACUATON SLIDE RELEASE CABLE FRAYED. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR TWAA9913204Slide · wornWHILE PARKED AT THE GATE THE NUMBER 4 CABIN DOOR ON THE RT SIDE OF THE AIRCRAFT WAS OPENED WHILE THE ESCAPE SLIDE WAS ARMED. THE ESCAPE SLIDE DID NOT FULLY DEPLOY. REPLACED THE ESCAPE SLIDE. CHECK-C 2-20-99 LAX.SDR SWAA991593Cable · misinstalledDURING SCHEDULED C1 CHECK, FOUND AFT ENTRY DOOR EVACUATION SLIDE CABLE ROUTED INCORRECTLY. ROUTED CABLE CORRECTLY PER MM.SDR TWAA9913001Slide · wornDURING PREFLIGHT, FOUND THE ESCAPE SLIDE AT THE FORWARD RT SIDE DOOR HAD DISCONNECTED AND WAS STARTING TO COME APART. REPLACED THE SLIDE. CHECK-C 12-23-98 STL.SDR SWAA991566Slide · out of positionAFT SERVICE DOOR EVACUATION SLIDE PRESSURE INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA991555Slide · low pressAFT SERVICE DOOR EVACUATION SLIDE PRESS IND LOW. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA991559Slide · deployedFWD SERVICE DOOR EVACUATION SLIDE DEPLOYED ACCIDENTALLY. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA991558Slide · deployedFWD SERVICE DOOR EVACUATION SLIDE DEPLOYED ACCIDENTALLY. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR EISA99167Slide · low pressureFORWARD R2 EMERGENCY SLIDE LOW PRESSURE. REMOVED AND REPLACED R2 EMERGENCY SLIDE IAW 25-60-0. (M)SDR DLM88992091Slide · deployedTAIL CONE AND SLIDE FOUND DEPLOYED. REPLACED SLIDE AND REINSTALLED TAIL CONE. DEPLOYMENT WAS SUCCESSFUL.SDR MALA976580Slide · deployedFORWARD LEFT PAX DOOR EMERGENCE ESCAPE SLIDE DEPLOYED. MAINTENANCE REPLACED EVACUATION SLIDE, OPS CHECK GOOD IAW AVRO AMM 25-60-11-401.SDR 9904073236Cable · brokenUPON ARRIVAL AT THE GATE, THE LEFT REAR CABIN DOOR WAS OPENED WITH THE SLIDE ARMED BUT SLIDE DID NOT DEPLOY. MAINTENANCE REPLACED THE SLIDE PACK ASSEMBLY DUE TO A BROKEN SLIDE PACK RELEASE CABLE.SDR MALA976571Slide · deployedFORWARD LEFT CABIN DOOR SLIDE DEPLOYED. MAINTENANCE REPLACED ESCAPE SLIDE IAW 25-60-11.SDR MALA976563Slide · malfunctionedSLIDE FOR FORWARD LEFT DOOR PARTIALLY DEPLOYED. MAINTENANCE REPLACED FWD PAX DOOR SLIDE IAW AMM 25-60-11. SEC CHECK GOOD.SDR AWXA9900300Slide · deployedON ARRIVAL AT GATE SLIDE AT L-1 DEPLOYED WHEN DOOR WAS OPENED, DID NOT INFLATE. REMOVED AND REPLACED SLIDE.SDR AALA991310Slide · defectiveSFO - DURING OVERNIGHT MAINTENANCE, INADVERENT SLIDE DEPLOYMENT OF OVERWING SLIDE AT DOOR R-3. SLIDE DEPLOYED ON THE WING BUT DID NOT DEPLOY TO THE GROUND. REPLACED OVERWING SLIDE AT R-3 DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR SWAA991463Slide · deployedDURING SCHEDULED RON, AFT ENTRY EVACUATION SLIDE DEPLOYED ACCIDENTALLY. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA991452Slide · low pressFWD SERVICE DOOR EVACUATION SLIDE PRESS OUT OF LIMITS. REMOVED AND REPLACED SLIDE ASSY PER MM.
Back to JASC 2565