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 U30A20030034Slide · malfunctionedAIRCRAFT IN C CHECK AT YWG. DURING AN INTENTIONAL DEPLOYMENT OF THE R2 PAX/CREW DOOR SLIDE/RAFT, THE SLIDE/RAFT FAILED TO DEPLOY PROPERLY. THE DISCHARGE RIPCORD HAD TO BE PULLED MANUALLY. ONCE THE RIPCORD WAS MANUALLY PULLED, THE SLIDE/RAFT INFLATED IN NORMAL SDR SWAA032067Indicator · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA032066Indicator · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR DL757030867Control Cable · seizedRT OFF WING SLIDE MANUAL DEPLOYMENT CABLE FOUND SEIZED DURING OPN 6740, OFF WING SLIDE DEPLOYMENT SYSTEM TEST. CABLE 580-242-024 REPLACED ON NR 1170. AC UNDERGOING HMV-2 AT THE TIME OF DISCOVERY.SDR SWAA032072Indicator · out of positionDURING SCHEDULED C4 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA032069Indicator · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR RYN2004F00009Attach Fitting · corrodedAT (C) CHECK FOUND AFT CABIN NR 2 RT DOORWAY, FORWARD GIRT BAR ATTACH FITTING PLATE, WITH CORROSION. REMOVED AND REPLACED FORWARD GIRT BAR ATTACH FITTING PLATE ON AFT CABIN NR 2 RT DOORWAY.SDR SWAA032061Girt Bar · out of adjustDURING SCHEDULED C1 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR UPS03141228Light · inoperativeCREW DISCOVERED EVAC SLIDE LIGHT (WARNING LIGHT) INOPERATIVE. DEFERRED UNDER MEL 52-73-01 01 W/CONTROL NR M266526 PLACARD INSTALLED.SDR ASAA0380591Lanyard · disconnectedON PREFLIGHT CHECK, FOUND FORWARD PAX L1 DOOR EMERGENCY SLIDE LANYARD WAS FOUND DISCONNECTED. RECONNECTED LANYARD. (M)SDR ASAA0380590Lanyard · disconnectedPREFLIGHT CHECK, FOUND FORWARD PAX L1 DOOR EMERGENCY SLIDE LANYARD WAS FOUND DISCONNECTED. RECONNECTED LANYARD. (M)SDR GTIA030679Slide · dislodgedREAR L-2 SLIDE FELL OFF DOOR. RE-INSTALLED L-2 SLIDE ON DOOR. (M)SDR SWAA032052Slide · dislodgedAFT SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA032062Bottle · lowDURING PREFLIGHT INSP, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND LOW. REMOVED AND REPLACED SLIDE PER MM.SDR GTIA030677Slide · dislodgedMCO - FLT 1304 - L-2 SLIDE FELL OFF DOOR. RE-INSTALLED L-2 SLIDE ON TO DOOR. (M)SDR ASAA0380588Lanyard · disconnectedPREFLIGHT CHECK, FOUND FORWARD SERVICE R1 DOOR EMERGENCY SLIDE LANYARD WAS FOUND DISCONNECTED. RECONNECTED LANYARD. (M)SDR SWAA032059Indicator · out of positionDURING SCHEDULED SERVICE CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA032025Indicator · out of positionDURING SCHEDULED SERVICE CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA032023Fitting · looseFWD SVC DOOR EMERGENCY EVAC SLIDE GIRT BAR LOOSE IN FLOOR ATTACH FITTINGS. ADJUSTED FITTINGS PER MM.SDR SWAA032022Slide · dislodgedDURING SCHEDULED RON, FWD SVC DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA032019Indicator · out of positionDURING SCHEDULED C1 CHECK, FOUND BOTH AFT CABIN DOOR EMERGENCY EVAC SLIDE PRESS INDICATORS OUT OF VIEW. REPOSITIONED SLIDES PER MM.SDR SWAA032029Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA032027Fitting · looseDURING SCHEDULED C4 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT BAR FLOOR ATTACH FITTINGS LOOSE. SECURED ATTACH FITTINGS PER MM.SDR CALA0300519Slide · out of adjustTHE RT OFF WING SLIDE SYSTEM FAILED DURING FUNCTION TEST WHILE AIRCRAFT WAS IN (C) CHECK AT LTN. THE DOOR AND SLIDE CARRIER FAILED TO DEPLOY DURING FUNCTION TEST AS PRESCRIBED BY CO WORK CARD 19-2560-1-7602(MPD-25-65-00-05B, MRB-25-020. THE LOCK FITTING, CONTRSDR AALA20030996Slide · failedTECHNICIAN OBSERVED EMERGENCY ESCAPE SLIDE FAILED TO DEPLOY PROPERLY. SLIDE WAS TIED IN A KNOT AFTER INFLATION. BOTTLE PRESSURE WAS GOOD, EVERYTHING ELSE APPEARED TO BE NORMAL. REPLACED SLIDE PACK. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR USAASA03110Release Cable · incorrectPHL - THE AFT SERVICE DOOR EMERGENCY ESCAPE SLIDE WAS FOUND TO HAVE AN INCORRECT RELEASE CABLE INSTALLED DURING INSPECTION. MAINTENANCE REPLACED THE SLIDE ASSEMBLY. OK FOR SERVICE. (M)SDR USAASA03111Release Cable · incorrectPHL - THE FORWARD ENTRY DOOR EMERGENCY ESCAPE SLIDE WAS FOUND TO HAVE AN INCORRECT RELEASE CABLE INSTALLED DURING INSPECTION. MAINTENANCE REPLACED THE FORWARD LEFT EMERGENCY ESCAPE SLIDE ASSEMBLY. OK FOR SERVICE. (M)SDR SWAA032020Girt Bar · out of adjustDURING SCHEDULED C2 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA032001Indicator · out of positionDURING SCHEDULED A1 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA031992Indicator · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR ASAA0380579Lanyard · disconnectedPREFLIGHT CHECK, FORWARD SERVICE R-1 DOOR EMERGENCY SLIDE LANYARD WAS FOUND DISCONNECTED. RECONNECTED LANYARD. (M)SDR SWAA032010Indicator · out of positionDURING PREFLIGHT INSP, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR 801DM0012Spring · failedL1, R1, L4, AND R4 GIRT BAR LEAF SPRINGS FAILED INSPECTION LIMITS PRESCRIBED IN MM-7200-03-00917 AND PACE MAINTENANCE ORDER NO. B-757-52-21003. REPLACED L1, R1, L4, AND R4 GIRT BAR LEAF SPRINGS AND OPS CHECKED IAW CMM 25-66-14 AND MM 25-66-10.SDR AMTA200301131Slide · malfunctionedR-1 DOOR WOULD NOT ARM BEFORE FLIGHT. REMOVED AND REPLACED R-1 DOOR SLIDE PER M-11-25-36. OPS CHECK GOOD. (M)SDR SWAA032005Slide · looseFWD ENTRY DOOR EMERGENCY EVAC SLIDE LOOSE IN CONTAINER. SECURED SLIDE PER MM.SDR SWAA031966Slide · out of positionDURING SCHEDULED A2 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR SWAA031963Indicator · out of positionFWD SERVICE DOOR EMERGENCY EVAC SLIDE PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA031961Slide · dislodgedFWD SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR USAASA03105Release Cable · incorrectCLT - THE AFT ENTRY DOOR EMERGENCY ESCAPE SLIDE WAS FOUND TO HAVE AN INCORRECT RELEASE CABLE INSTALLED DURING INSPECTION. MAINTENANCE REPLACED THE SLIDE ASSEMBLY. OK FOR SERVICE. THE REPAIR SHOP INSTALLED THE PROPER RELEASE CABLE ON THE SLIDE AND RETURNED TSDR UIEA200300054Slide · misinstalledDURING FC02 CHECK AT AMS, AN INSPECTION OF LEFT U/D TYPE 'A' DOOR THE TECHICIAN NOTICED THAT THE SLIDE DEPLOYMENT HOOK WOULD NOT ENGATE THE SLIDE DEPLOYMENT LINK. THE FIRST OBSERVATION WAS THAT THE SLIDE OUTER COVER (INBOARD SIDE) WAS NOT FLUSH WITH THE DOOR SDR SWAA031964Slide · deployedDURING SCHEDULED SERVICE CHECK, FWD SVC DOOR EMERGENCY EVAC SLIDE DEPLOYED. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA031959Indicator · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA031942Slide · looseAFT ENTRY DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. SECURED SLIDE ASSY INTO CONTAINER PER MM.SDR ASAA0380570Lanyard · disconnectedSAN PREFLIGHT CHECK, FOUND FORWARD PAX L-1 DOOR EMERGENCY SLIDE LANYARD WAS FOUND DISCONNECTED. RECONNECTED LANYARD. (M)SDR USAASA03103Release Cable · wrong partTHE FORWARD LEFT ENTRY DOOR EMERGENCY ESCAPE SLIDE WAS FOUND TO HAVE AN INCORRECT RELEASE CABLE INSTALLED DURING INSPECTION. MAINTENANCE REPLACED THE FORWARD LEFT EMERGENCY ESCAPE SLIDE ASSEMBLY. OK FOR SERVICE. THE REPAIR SHOP INSTALLED THE PROPER RELEASE SDR SWAA031962Slide · looseAFT SVC DOOR EMERGENCY EVAC SLIDE LOOSE IN CONTAINER. SECURED SLIDE PER MM.SDR SWAA031943Slide · looseAFT SERVICE DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. SECURED SLIDE INTO CONTAINER PER MM.SDR USAASA03107Release Cable · incorrectPHL - THE AFT SERVICE DOOR EMERGENCY ESCAPE SLIDE WAS FOUND TO HAVE AN INCORRECT RELEASE CABLE INSTALLED DURING INSPECTION. MAINTENANCE REPLACED THE SLIDE ASSEMBLY. OK FOR SERVICE. THE REPAIR SHOP INSTALLED THE PROPER RELEASE CABLE ON THE SLIDE AND RETURNEDSDR USAASA03100Release Cable · wrong partTHE AFT RIGHT EMERGENCY ESCAPE SLIDE WAS FOND TO HAVE AN INCORRECT RELEASE CABLE INSTALLED DURING INSPECTION. MAINTENANCE REPLACED THE SLIDE ASSEMBLY. OK FOR SERVICE. THE REPAIR SHOP INSTALLED THE PROPER RELEASE CABLE ON THE SLIDE AND RETURNED THE SLIDE TO SDR SWAA031958Slide · out of limitsDURING SCHEDULED RON, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.
Back to JASC 2565