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 SWAA011246Slide · out of adjDURING SCHEDULED C3 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE OUT OF ADJUSTMENT. READJUSTED EMERGENCY EVAC SLIDE PER MM.SDR SWAA011236Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EMERGENCY EVAC SLIDE ASSY PER MM.SDR SWAA011235Slide · looseFWD SVC DOOR EMERGENCY EVAC SLIDE LOOSE. RESECURED EVAC SLIDE CASE TO DOOR PER MM.SDR DLM11010676Slide · unserviceablePER SERVICE CK NR 3 INSPECTION INDICATED SLIDE AT R4 DOOR ABOVE GIRT BAR, THE CORDS WERE LOOSE AND THE SAFETY BROKEN ON THE PIN. REMOVED AND REPLACED R4 DOOR SLIDE. SN ON 0303 SN OFF 0430 DELTA PN 250007930.SDR SWAA011245Retainer · looseDURING SCHEDULED C4 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT BAR RETAINER LOOSE. SECURED RETAINER PER MM.SDR SWAA011227Slide · out of positionDURING SCHEDULED C1 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE ASSY PER MM.SDR SWAA011214Slide · unserviceableDURING SCHEDULED SERVICE CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. R&R EVAC SLIDE ASSY PER MM.SDR SWAA011209Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE ASSY PER MM.SDR GTIA010204Slide · out of positionL-1 DOOR SLIDE PACK FELL OFF OPENING DOOR AT GATE. RE-INSTALLED L1 DOOR SLIDE PACK IAW MM 25-60-00. NO OTHER DEFECTS NOTED AT THIS TIME. (M)SDR SWAA011220Slide · unserviceableDURING SCHEDULED D CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. R&R SLIDE ASSY PER MM.SDR SWAA011217Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE ASSY PER MM.SDR GTIA010213Slide · out of positionUPON ARRIVAL, RAMP AGENT OPENED L2 DOOR IN WHICH SLIDE FELL TO THE GROUND AND BUSTED SLIDE PACK SHELL. REMOVED AND REPLACE L2 SLIDE PACK IAW MD-80 MM 25-60-00. (M)SDR AU010377Slide · misinstalled(AUS) NR 1 LH MAIN ENTRY DOOR ESCAPE SLIDE SAFETY PIN INSTALLED. PERSONNEL/MAINTENANCE ERROR.SDR SWAA011205Slide · out of adjAFT SVC DOOR EMERGENCY EVAC SLIDE ASSY OUT OF ADJUST. READJUSTED EVAC SLIDE ASSY PER MM.SDR ASAA0180144Wire Harness · failedOAK - DURING C-CHECK, L1 DOOR EMERGENCY SLIDE HARNESS FAILED THE AMPERAGE CHECK. REPLACED L1 DOOR EMERGENCY SLIDE PER ASA TASK CARD 24425006. HARNESS CHECKED OK. (M)SDR GTIA010200Slide · out of positionDTW - FLT 572 - R1 DOOR SLIDE PACK FELL OFF. INSTALLED DOOR SLIDE PACK. REINSTALLED COVER AND LANYARD PIN IAW MD-80 MM 25-65-00. (M)SDR AU010361Slide · faulty(AUS) MAIN ENTRY DOOR ESCAPE SLIDE FAILED TO INFLATE DUE TO DAMAGE TO THE ASPIRATOR FLAPPER VALVE SUPPORT BRIDGE. INVESTIGATION FOUND THE BRIDGE TO BE LOOSE AND TWISTED PREVENTING THE FLAPPER VALVE HALVES FROM SEATING.SDR AU010355Slide · misinstalled(AUS) MAIN ENTRY DOOR ESCAPE SLIDE SAFETY PIN INSTALLED.SDR SWAA011169Slide · unserviceableDURING SCHEDULED SERVICE CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. R&R EVAC SLIDE ASSY PER MM.SDR SWAA011166Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED EVAC SLIDE ASSY PER MM.SDR N8TA01042304Ring · failedDURING OPERATIONAL TESTING OF THE SLIDE THE LATCH SPLIT RING FAILED. SLIDE DID NOT DEPLOY. INCORPORATED SB, LATCH ASSEMBLY MODIFICATION.SDR GTIA010115Slide · out of positionMCO - FLT 1599 - FOUND SLIDE PACK FELL OFF L2 DOOR. RE-INSTALLED L2 SLIDE PACK PER MM 25-62-00. (M)SDR SWAA011163Cable · misroutedDURING SCHEDULED C1 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT CABLE ASSY MISROUTED. REPOSITIONED CABLE ASSY PER MM.SDR SWAA011171Slide · out of adjDURING SCHEDULED C1 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. READJUSTED EVAC SLIDE ASSY PER MM.SDR SWAA011165Slide · out of positionAFT DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED EVAC SLIDE ASSY PER MM.SDR GTIA010108Cable · disconnectedR1 DOOR GIRT BAR CABLE DISCONNECTED. CONNECTED R1 GIRT BAR IAW MD80 MM 25-62-04. OPS CHECK GOOD, NO OTHER DEFECTS NOTED AT THIS TIME. (M)SDR GTIA010092Slide · out of positionFLL - FLT 783 - L2 SLIDE FELL OFF OF DOOR. RE-INSTALLED SLIDE. OPS CHECK OK, IAW MM 25-62-00. (M)SDR SWAA011156Container · looseAFT SERVICE DOOR EMERGENCY EVAC SLIDE CONTAINER CAME LOOSE. INSPECTED SLIDE & RESECURED CONTAINER.SDR SWAA011126Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED EVAC SLIDE ASSY PER MM.SDR DL75A010605Slide · dislodged3L ENTRY DOOR OPENED WHILE ARMED, SLIDE DID NOT DEPLOY, IT FELL ON SERVICE TRUCK - REPLACED SAMESDR SWAA011116Slide · unserviceableDURING SCHEDULED SERVICE CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE ASSY PER MM.SDR SWAA011111Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE ASSY PER MM.SDR SWAA011110Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE ASSY PER MM.SDR SWAA011119Bracket · looseDURING SCHEDULED C4 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE GIRT BAR FWD MOUNT BRACKET LOOSE. SECURED BRACKET PER SRM.SDR AU010351Slide · misinstalled(AUS) ESCAPE SLIDE FITTED TO DOOR LT 1 INCORRECTLY FITTED FOLLOWINGHEAVY MAINTENANCE. INSPECTION FOUND THAT THE SLIDE BAR WAS IN THE STOWED (TRANSPORT) POSITION AND WAS NOT CONNECTED TO THE GIRT BAR. FURTHER INVESTIGATION FOUND THAT THE ESCAPE SLIDES ONTHE OTSDR SWAA011095Bracket · brokenDURING SCHEDULED 1/2D CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE FWD ATTACH BRACKET BROKEN. R&R BRACKET PER MM.SDR ASAA0180133Lanyard · disconnectedRNO - DURING PREFLIGHT CHECK, R-1 DOOR EMERGENCY SLIDE LANYARD WAS FOUND TO BE DETACHED. RESECURED LANYARD. (M)SDR GTIA010091Slide · inoperativeFLT 781 - ORD - FOUND SLIDE PACK L2 INOPERATIVE. REPACKED L2 SLIDE IAW MM 25-65-00. (M)SDR SWAA011074Slide · unserviceableDURING SCHEDULED SERVICE CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED EVAC SLIDE ASSY PER MM.SDR SWAA011073Slide · unserviceableFWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE ASSY PER MM.SDR 2001UALA00450Battery Pack · dischargedLEFT OVERWING SLIDE SQUIB WILL NOT TEST. REPLACED LEFT HAND OVERWING SLIDE BATTERY PACK OP CHECKS GOOD.SDR ASAA0180119Harness · failedOAK - DURING C-CHECK, L-2 DOOR EMERGENCY SLIDE HARNESS FAILED THE AMPERAGE CHECK. REMOVED AND REPLACED L-2 DOOR SLIDE ASSEMBLY WITH SERVICEABLE ASSY. (M)SDR SWAA011063Slide · unserviceableDURING SCHEDULED C3 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. R&R EVAC SLIDE ASSY PER MM.SDR SWAA011047Slide · unserviceableDURING SCHEDULED SERVICE CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE ASSY PRESS IND OUT OF LIMITS. R&R EVAC SLIDE ASSY PER MM.SDR SWAA011044Slide · out of adjFWD DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. READJUSTED EVAC SLIDE ASSY PER MM.SDR SWAA011052Slide · out of adjDURING SCHEDULED C1 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. READJUSTED EVAC SLIDE ASSY PER MM.SDR SWAA011042Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE ASSY PER MM.SDR SWAA011022Slide · out of toleranceDURING SCHEDULED SERVICE CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE ASSY PER MM.SDR SWAA011034Slide · out of positionDURING SCHEDULED C4 CHECK, FOUND AFT ENTRY AND SVC DOOR EMERGENCY EVAC SLIDE PRESS INDICATORS OUT OF VIEW. REPOSITIONED EVAC SLIDE ASSY''S PER MM.SDR SWAA011033Slide · out of positionDURING SCHEDULED C1 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE ASSY PER MM.
Back to JASC 2565