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 SWAA000489Slide · dischargedDURING SCHEDULED C3 CHECK, FOUND FWD ENTRY DOOR EVACUATION SLIDE PRESS INDICATOR LOW. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA000480Indicator · dislodgedDURING SCHEDULED C2 CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA000485Girt Bar · out of adjDURING SCHEDULED C1 CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE GIRT OUT OF ADJUSTMENT. REINSTALLED SLIDE ASSY PER MM.SDR SWAA000463Girt Bar · out of adjDURING SCHEDULED C2 CHECK, FOUND FWD ENTRY AND AFT SERVICE DOOR EVACUATION SLIDE GIRT ASSY'S OUT OF ADJUSTMENT. REPOSITIONED SLIDES PER MM.SDR SWAA000468Girt Bar · out of adjDURING SCHEDULED SERVICE CHECK, FOUND FWD SERVICE DOOR EVACUATION SLIDE GIRT ASSY OUT OF ADJUSTMENT. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR 20000424SH006Slide · will not testWHILE PERFORMING A TEST ON EVACUATION SLIDE, FOUND THAT SLIDE COULD NOT BE ACTIVATED BECAUSE SAFETY PIN WAS STILL INSTALLED. UPON CHECKING REMAINING 3 SLIDES, FOUND THAT ALL HAD PINS INSTALLED. (X)SDR SWAA000460Indicator · dislodgedDURING SCHEDULED BC2 CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE PRESSURE INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA000451Indicator · dislodgedDURING SCHEDULED C2 CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE PRESSURE INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA000446Girt Bar · looseDURING SCHEDULED C4 CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE GIRT EXTENDED PAST LIMITS. REINSTALLED SLIDE ASSY PER MM.SDR CA000307009Support Bracket · bent(CAN) RELEASE ASSY BRACKET SUPPORT ASSY AND PIN SHIELD FOUND BENT DUE TO EXCESSIVE FORCE BEING DIRECTED ONTO THEM. THIS PREVENTED THE SHAFT FROM ROTATING AND THUS INHIBITED THE SUCCESSFUL DEPLOYMENT OF THE SLIDE.SDR AALA006045Slide · damagedLAX - L1 SLIDE HAS PIN HANGING OUT FROM SIDE OF SLIDE SHROUD. FOUND FIRING LANYARD AWAY FROM FIRING CASE. REPLACED SLIDE ASSY WITH SL 11041 S/N OFF 0967 S/N ON A-5521. (M)SDR SWAA000434Slide · dischargedDURING SCHEDULED SERVICE CHECK, FOUND FWD SERVICE DOOR EVACUATION SLIDE PRESSURE INDICATOR BELOW LIMITS. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR MALA000201Slide · dislodgedDURING DESCENT FLIGHT ATTENDANT NOTICE RIGHT FORWARD CABIN DOOR SLIDE WAS PARTIALLY OUT OF HOLDER & SITTING ON THE FLOOR. MAINTENANCE REPLACED FORWARD SERVICE DOOR SLIDE. AMM 25-60-11.SDR SWAA000423Bracket · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FWD SERVICE DOOR EVACUATION SLIDE GIRT BAR FLOOR MOUNT BRACKETS CORRODED. REMOVED AND REPLACED BRACKETS PER SRM.SDR SWAA000421Bracket · corrodedDURING SCHEDULED D-CHECK, FOUND FWD ENTRY DOOR EVACUATION SLIDE GIRT BAR FLOOR BRACKETS CORRODED. REMOVED AND REPLACED BRACKETS PER SRM.SDR 20001114SH021Slide · deployedJFK/GND - FLT JM 092 - AFTER ARRIVAL, FLIGHT ATTENDANT INADVERTENTLY OPENED THE R1 DOOR WITH SLIDE IN ARM POSITION. THE SLIDE, THEREAFTER, DEPLOYED. THE AIRCRAFT WAS REPOSITIONED, WHERE A NEW SLIDE WAS FITTED. THE AIRCRAFT WAS THEN DISPATCHED FOR SERVICE. SDR SWAA000418Fastener · looseDURING SCHEDULED C2 CHECK, FOUND FWD ENTRY AND SERVICE DOOR EVACUATION SLIDE GIRT BAR RETAINING BRACKET FASTENERS LOOSE. REMOVED AND REPLACED BRACKET FASTENERS PER SRM.SDR A6WA0000020Battery · dischargedNR 2 EVAC SLIDE LIGHTING BATTERY FAILS VOLTAGE CHECK. REMOVED AND REPLACED NR 2 SLIDE ASSY. (M)SDR SWAA000394Slide · dislodgedFWD ENTRY DOOR FELL OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR SWAA000393Slide · dislodgedFWD ENTRY DOOR SLIDE CAME OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR SWAA000392Indicator · dislodgedDURING SCHEDULED A2 CHECK, FOUND AFT ENTRY DOOR EVACUATION SLIDE IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA000391Hook · looseDURING SCHEDULED C3 CHECK, FOUND FWD ENTRY DOOR EVACUATION SLIDE AFT GIRT BAR HOOK LOOSE. SECURED HOOK PER MM.SDR SWAA000390Indicator · dislodgedDURING SCHEDULED C1 CHECK, FOUND AFT ENTRY DOOR EVACUATION SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA000389Cable · misroutedDURING SCHEDULED C1 CHECK, FOUND FWD SERVICE DOOR EVACUATION SLIDE RELEASE CABLE IMPROPERLY ROUTED. REROUTED CABLE PER MM.SDR AT0000159Slide · unsecureFOUND GALLEY DOOR SLIDE ASSEMBLY UNSECURED. CORRECTIVE ACTION: RESECURED R-1 DOOR SLIDE. IAW DC9 MM 25-61.SDR SWAA000377Girt Bar · saggingDURING SCHEDULED C1 CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE GIRT ASSY DRAGGING ON THRESHOLD. REPOSITIONED SLIDE ASSY PER MM.SDR MWEA00079Slide · dislodgedAFT GALLEY DOOR SLIDE IS OUT OF THE HOLDER. MAINTENANCE RE-INSTALLED SLIDE COVER.SDR ASAA0080185Slide · failedPHX - DURING 30K CHECK, THE TAILCONE EXIT EMERGENCY EVACUATION SLIDE FAILED THE EMERGENCY LIGHT AMP TEST. REPLACED THE TAILCONE EXIT EMERGENCY EVACUATION SLIDE ASSEMBLY. (M)SDR 0000512298Slide · deployedAT GATE, THE CATERING TRUCK OPENED WRONG SERVICE DOOR WHILE SLIDE WAS STILL ACTIVATED. UPON OPENING THE DOOR, THE SLIDE DID NOT DEPLOY. PHX MAINTENANCE FOUND HINGE POPPED OUT OF SLIDE COVER. MAINTENANCE REPAIRED THE COVER AND REINSTALLED SLIDE.SDR USAAD00035Slide · dischargedROC - THE TAIL CONE EVACUATION SLIDE PRESSURE WAS LOW. THE AIRCRAFT WAS FERRIED TO PIT TO CHANGE THE SLIDE ASSEMBLY. MAINTENANCE REPLACED THE TAIL CONE EVACUATION SLIDE. (M)SDR MWEA00077Slide · failed testAFT GALLEY EVACUATION SLIDE LIGHTS FAILED VOLTAGE CHECK. MAINTENANCE REPLACED AFT GALLEY EVACUATION SLIDE.SDR 0000466601Slide · deployedDURING LINE CHECK, DOOR 1R EVACUATION SLIDE PARTIALLY DEPLOYED BUT DID NOT INFLATE. REPLACED DOOR ASSIST BOTTLE AND SLIDE, OPERATIONAL CHECK GOOD.SDR SWAA000320Cable · misroutedDURING SCHEDULED C1 CHECK, FOUND AFT ENTRY DOOR EVACUATION SLIDE RELEASE CABLE MISROUTED. PROPERLY ROUTED RELEASE CABLE PER MM.SDR SWAA000317Bracket · looseDURING SCHEDULED C4 CHECK, FOUND AFT ENTRY AND SERVICE DOOR EVACUATION SLIDE AFT GIRT BAR FLOOR BRACKETS LOOSE. TIGHTENED BRACKETS PER MM.SDR CALA0000180Latch · brokenINSPECTION FOUND THE AFT GALLEY DOOR SLIDE GIRT BARLATCH BROKEN. A NEW GIRT BAR LATCH WAS INSTALLED.SDR SWAA000299Slide · dislodgedFWD ENTRY DOOR EVACUATION SLIDE FELL OUT OF CONTAINER WHEN DOOR CLOSED AT SLC AND AGAIN AT LAS. REINSTALLED FWD ENTRY DOOR SLIDE ASSY AFTER THE TWO INCIDENTS PER MM.SDR SWAA000297Indicator · out of positionAFT ENTRY DOOR EVACUATION SLIDE PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA000307Cable · brokenDURING SCHEDULED C1 CHECK, FOUND FWD ENTRY DOOR EVACUATION SLIDE GIRT BAR ATTACH CABLE ASSY BROKEN. REMOVED AND REPLACED CABLE ASSY PER MM.SDR 2000UALA00081Slide · deployedDOOR 5L SLIDE DEPLOYED DURING CONDITIONAL CHECK OF DOOR. BUSTLE REMOVED AND SLIDE WAS LOOSE, FELL TO FLOOR AND DEPLOYED INSIDE OF CABIN. *S/D* CENTER RELEASE MECHANISM WAS TRIGGERED DURING MAINTENANCE INSPECTION. SLIDE BUSTLE WAS REMOVED AND SLIDE DEPLOYEDSDR AU000225Lanyard · faulty(AUS) LT AND RT DOOR ESCAPE SLIDE LANYARDS INCORRECTLY FITTED. PERSONNEL / MAINTENANCE ERRORSDR AALA006033Slide · dislodgedRNO - AFT GALLEY EVAC SLIDE PACK FALLS OUT OF DOOR. REMOVED AND REPLACED AFT GALLEY SLIDE PER MM. (M)SDR SWAA000295Indicator · out of positionDURING SCHEDULED SERVICE CHECK AFT ENTRY AND SERVICE DOOR EVACUATION SLIDE PRESS INDS OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA000294Indicator · out of positionAFT SERVICE DOOR EVACUATION SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA000293Mount · looseDURING SCHEDULED SERVICE CHECK, FOUND FWD ENTRY DOOR EVACUATION SLIDE MOUNTING HARDWARE LOOSE. SECURED MOUNTING HARDWARE PER MM.SDR MWEA00075Cover · looseSPLIT PIN FOR FORWARD ENTRANCE DOOR EMERGENCY EVACUATION SLIDE COVER CAME OFF. MAINTENANCE REINSTALLED SLIDE COVER.SDR ASAA0080140Slide · will not testPHX - DURING 30K CHECK, THE L2 DOOR EMERGENCY EVACUATION SLIDE FAILED THE EMERGENCY LIGHT AMP TEST. REPLACED THE L2 DOOR EMERGENCY EVACUATION SLIDE ASSEMBLY. (X)SDR AALA006027Cable · frayedFORWARD ENTRANCE DOOR SLIDE LANYARD FRAYED. REMOVED AND REPLACED FORWARD ENTRANCE DOOR SLIDE LANYARD AS REQ''''D. (M)SDR TWAA0002801Lanyard · brokenTHE FORWARD LEFT CABIN ENTRANCE DOOR EMERGENCY ESCAPE SLIDE GIRT BAR CABLE WAS FOUND BROKEN. REPLACED THE LANYARD. CHECK-C 6-22-99 STL.SDR SWAA000277Slide · dislodgedFWD ENTRY DOOR EVACUATION SLIDE CAME OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR SWAA000275Indicator · dislodgedDURING SCHEDULED C2 CHECK, FOUND BOTH AFT ENTRY AND SERVICE DOOR EVACUATION SLIDE PRESS INDS OUT OF VIEW. REPOSITIONED BOTH SLIDE ASSY'S PER MM.
Back to JASC 2565