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 SWAA031124Slide · dislodgedFWD ENTRY DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT OF THE CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA031120Lens · looseDURING SCHEDULED C3 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE COVER LENS LOOSE. SECURED LENS PER MM.SDR SWAA031114Girt Bar · damagedAFT SVC DOOR EMERGENCY EVAC SLIDE GIRT BAR WILL NOT STOW PROPERLY. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA031113Slide · dislodgedFWD ENTRY DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT OF THE CONTAINER. REINSTALLED SLIDE PER MM.SDR CALA0300253Slide · looseINSPECTION FOUND LT OVERWING SLIDE UNLACED AT TOP DURING SYSTEM OPERATION CHECK. THE SLIDE WAS REMOVED AND REPLACED IAW MM 25-65-01.SDR USAASA03043Girt Bar · failedWHILE ACCOMPLISHING THE OPERATIONAL TEST OF THE AFT LEFT PASSENGER DOOR SLIDE, THE GIRT BAR FAILED TO STAY ENGAGED IN THE FLOOR FITTINGS OF THE AIRCRAFT. THE FAILURE ALLOWED THE SLIDE TO DETACH FROM THE AIRCRAFT. THE SLIDE CONTINUED TO INFLATE AFTER IT LANDESDR CALA0300252Slide · looseINSPECTION FOUND LT OVERWING ESCAPE SLIDE UNLACED. THE SLIDE WAS REMOVED AND REPLACED IAW MM 25-60-00 AND WORK CARD 19-2560-1-0901.SDR SWAA031091Bottle · dischargedDURING SCHEDULED PM CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA031107Girt Bar · out of adjustDURING SCHEDULED C2 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR AWXA200300570Fitting · brokenMCN - EES - DURING C-01 CHECK THE LT OVERWING HATCH SLIDE BOTTLE CABLE FITTING WAS FOUND BROKEN. MAINTENANCE REMOVED AND REPLACED THE LT OVERWING HATCH SLIDE BOTTLE IAW AMM SUBTASK 25-62-46-020-050-A, AND 25-62-46-420-050-A, OPERATIONAL CHECK WAS GOOD IAW AMMSDR SWAA031095Girt Bar · looseDURING SCHEDULED 1/4D CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT BAR ATTACH FITTING LOOSE. SECURED ATTACH FITTING PER MM.SDR AWXA200300545Cable · frayedPHX - EES - DURING INSPECTION THE R-2 DOOR EMERGENCY ESCAPE SLIDE CABLE WAS FOUND FRAYED. MAINTENANCE REMOVED AND REPLACED THE R-2 DOOR EMERGENCY ESCAPE SLIDE CABLE IAW T/C I1C25009.SDR USAASA03041Girt Bar · inoperativeCLT - DURING INSPECTION, THE L2 DOOR WAS FOUND TO HAVE IMPROPER CLEARANCE BETWEEN DOUBLER/STOP AND GIRT BAR. MAINTENANCE REPLACED THE GIRT BAR. INSPECTED INSTALLATION AND FOUND SERVICEABLE. (M)SDR USAABB03072Lanyard · frayedFOUND FRAYED LANYARD ON R1 DOOR SLIDE. MAINTENANCE FOUND THAT THE COVER ATTACH LANYARD WAS FRAYED. THE SLIDE WAS REPLACED. (M)SDR SWAA031092Indicator · out of positionDURING SCHEDULED C1 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA031085Slide · dislodgedFWD ENTRY DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR AWXA200300534Slide · bindingFLIGHT CREW REPORTED THE R-1 DOOR EVACUATION SLIDE ARMING LEVER WAS BINDING. MAINTENANCE REMOVED AND REPLACED THE R-1 DOOR EMERGENCY EVACUATION SLIDE IAW AWA T/C R1C25602, OPERATIONAL CHECK OF R-1 DOOR ARMING LEVER WAS NORMAL. VENDOR OVERHAULED SLIDE, TEARDOSDR SWAA031069Slide · dislodgedUPON ARRIVAL TO THE GATE, FWD ENTRY DOOR EVACUATION SLIDE FELL OUT OF THE CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR SWAA031061Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA031060Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND BOTH AFT CABIN DOOR EMERGENCY EVAC SLIDE GIRT ASSY'S OUT OF ADJUST. ADJUSTED BOTH AFT CABIN DOOR SLIDES PER MM.SDR SWAA031054Slide · deployedFWD SVC DOOR EMERGENCY EVAC SLIDE INADVERTENTLY DEPLOYED WHEN OPENING DOOR. REMOVED AND REPLACED EMERGENCY EVAC SLIDE PER MM.SDR 159PL0030Bottle · dischargedL2 SLIDE PRESSURE READS ZERO. REMOVED AND REPLACED L2 SLIDE PER MM 25-61-311.SDR SWAA031059Cable · misroutedDURING SCHEDULED C3 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED CABLE PER MM.SDR SWAA031049Cable · misroutedDURING SCHEDULED C2 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED CABLE PER MM.SDR SWAA031039Girt Bar · out of adjustFWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA031052Hook · looseDURING SCHEDULED C2 CHECK, FOUND FWD SERVICE DOOR EMERGENCY EVACUATION SLIDE GIRT BAR AFT HOOK LOOSE. SECURED GIRT BAR HOOK PER MM.SDR SWAA031027Indicator · out of positionDURING SCHEDULED C3 CHECK, FOUND AFT ENTRY DOOR EVACUATION SLIDE PRESSURE INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA031005Slide · dislodgedAFT ENTRY DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR SWAA030998Indicator · out of positionAFT SERVICE DOOR EVACUATION SLIDE PRESS INDICATOR OUT OF POSITION. REPOSITIONED EVACUATION SLIDE ASSY PER MM.SDR SWAA031004Slide · dislodgedFWD SERVICE DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR SWAA030989Indicator · out of positionFWD ENTRY DOOR EMERGENCY EVACUATION SLIDE PRESSURE INDICATOR OUT OF LIMITS. REMOVED AND REPLACED EMERGENCY EVAC SLIDE PER MM.SDR SWAA030988Girt Bar · out of adjustAFT SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR AWXA200300464Bottle · reads lowPHX - EES - DURING INSPECTION THE R-4 DOOR MOUNTED EMERGENCY ESCAPE SLIDE NEEDLE WAS OUT OF GREEN BAND. MAINTENANCE REMOVED AND REPLACED THE R-4 DOOR EMERGENCY ESCAPE SLIDE IAW AWA T/C R1C25602.SDR SWAA030987Slide · dislodgedDURING SCHEDULED RON, FWD SVC DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA030982Girt Bar · out of adjustDURING SCHEDULED C3 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR USAABA03011Regulator · malfunctionedCLT - DURING SLIDE TESTING IN THE SHOP, THE SLIDE DID NOT INFLATE WHEN THE REGULATOR WAS ACTIVATED. AFTER APPLYING A SHARP RAP TO THE REGULATOR, THE SLIDE INFLATED NORMALLY. MAINTENANCE IN THE SHOP FOUND THE REGULATOR BORE SCORED WHICH WAS MOST LIKELY CAUSEDSDR USAABA03010Regulator · malfunctionedDURING SLIDE TESTING IN THE SHOP, THE SLIDE DID NOT INFLATE WHEN THE REGULATOR WAS ACTIVATED. AFTER APPLYING A SHARP RAP TO THE REGULATOR, THE SLIDE INFLATED NORMALLY. MAINTENANCE IN THE SHOP FOUND THE REGULATOR BORE SCORED WHICH WAS MOST LIKELY CAUSED BY CHSDR USAABA03012Regulator · failedDURING SLIDE TESTING IN THE SHOP, THE SLIDE DID NOT INFLATE WHEN THE REGULATOR WAS ACTIVATED. AFTER APPLYING A SHARP RAP TO THE REGULATOR, THE SLIDE INFLATED NORMALLY. MAINTENANCE IN THE SHOP FOUND THE REGULATOR BORE SCORED WHICH WAS MOST LIKELY CAUSED BY CHSDR UIEA200300022Cable · stuckDURING C-04 CHECK IN FRA AND WHILE PERFORMING AN OPERATIONAL CHECK OF THE INFLATABLE EVACUATION SYSTEM AT THE UPPER DECK DOOR RIGHT SIDE AS PER WO A230102GTI, THE SLIDE WAS LIFTED AND HAD FALLEN OUT OF THE DOOR FRAME. SUDDENLY THE SLIDE STOPPED ROTATING AND SSDR G5S2003F00001Slide · inoperativeINFLATABLE EVACUATION SYSTEM OF THE RIGHT UPPER DECK DOOR DOES NOT INFLATE PROPERLY. THE SLIDE WAS LIFTED AND HAS BEEN FALLEN OUT OF THE DOOR FRAME. SUDDENLY THE SLIDE STOPPED ROTATING AND STUCK. AFTER WAITING SEVERAL SECONDS THE MECHANIC OPENED THE VELCRO SDR G5S2003F00000Slide · inoperativeDURING AN OPERATIONAL CHECK OF THE INFLATABLE EVACUATION SYSTEM AT THE UPPER DECK DOOR RT, THE SLIDE WAS LIFED AND HAS BEEN FALLEN OUT OF THE DOOR FRAME. SUDDENLY THE SLIDE STOPPED ROTATING AND STUCK. AFTER WAITING SEVERAL SECONDS THE MECHANIC OPENED THE VELSDR SWAA030957Indicator · out of positionAFT SERVICE DOOR EMERGENCY EVACUATION SLIDE PRESSURE INDICATOR OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA030974Indicator · out of positionDURING SCHEDULED C4 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA030968Girt Bar · out of adjustDURING SCHEDULED C1 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA030965Girt Bar · out of adjustDURING SCHEDULED C4 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA030959Girt Bar · out of adjustDURING SCHEDULED C1 CHECK, FOUND BOTH FWD ENTRY AND FWD SERVICE DOOR EMERGENCY EVACUATION SLIDE GIRT ASSY'S OUT OF ADJUST. ADJUSTED SLIDES PER MM.SDR MALA030250Girt Bar · lack of lubeFA REPORTS LT FWD DOOR GIRT BAR IS HARD TO ENGAGE. LEFT FORWARD PASSENGER DOOR, IS DIFFICULT TO OPEN AND CLOSE. MAINTENANCE SWAPPED LT FRONT W/RT REAR SLIDES PN ON/OFF D31003-107. LT FRONT SN 1547. RIGHT REAR SN 1407. LUBED DOOR AND GIRT BARS. OPS CHECK GOODSDR SWAA030939Indicator · out of positionAFT SERVICE DOOR EMERGENCY EVACUATION SLIDE PRESSURE INDICATOR OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA030927Indicator · out of positionDURING SCHEDULED A1 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA030928Girt Bar · out of adjustDURING SCHEDULED C2 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.
Back to JASC 2565