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 SWAA010102Slide · detachedFWD ENTRY DOOR EMERGENCY EVAC SLIDE ASSY FELL OUT OF CONTAINER. REINSTALLED EVAC SLIDE ASSY PER MM.SDR SWAA010100Slide · out of adjAFT ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. RE-ADJUSTED EVAC SLIDE ASSY PER MM.SDR SWAA010096Slide · detachedFWD SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER WHEN ARMED FOR TAXI. REINSTALLED EVAC SLIDE ASSY PER MM.SDR SWAA010082Indicator · out of toleranceDURING SCHEDULED PM CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE ASSY PER MM.SDR SWAA010092Slide · detachedAFT SVC DOOR EMERGENCY EVAC SLIDE ASSY FELL OUT OF CONTAINER. REINSTALLED EVAC SLIDE ASSY PER MM.SDR SWAA010086Indicator · out of positionDURING SCHEDULED C3 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE ASSY PER MM.SDR SWAA010078Slide · out of adjFWD ENTRY DOOR EMERGENCY EVAC SLIDE ASSY OUT OF ADJUST. REPOSITIONED SLIDE ASSY PER MM.SDR GTIA010011Slide · out of positionDTW - FLT 709 - FORWARD SLIDE PACK FELL OFF. REINSTALLED FORWARD SLIDE PACK IAW MD-80 MM 25-62-00. (M)SDR SWAA010075Cable · brokenDURING SCHEDULED C2 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY CABLE BROKEN. REPLACED CABLE PER MM.SDR SWAA010063Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE ASSY PER MM.SDR GTIA010002Slide · out of positionACY - FLT 953 - L1 DOOR EMERGENCY SLIDE PACK CAME OFF. REINSTALLED SLIDE, OPS CHECK GOOD IAW MM 25-62-0. (M)SDR AALA016003Slide · deployedAFT GALLEY DOOR EMERGENCY CHUTE WAS PARTIALLY DEPLOYED. INSTALLED NEW EMERGENCY CHUTE IAW THE MM. (M)SDR SWAA010076Indicator · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE ASSY PER MM.SDR TWAA0100602Slide · unserviceableON PREFLIGHT THE LEFT SIDE FWD CABIN DOOR ESCAPE SLIDE BOTTLE PRESSURE WAS READING ZERO. REPLACED THE SLIDE ASSEMBLY. CHECK-C 7-18-00 STL.SDR SWAA010047Slide · out of positionFWD SERVICE DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA010046Slide · out of positionFWD ENTRY DOOR EVACUATION SLIDE FELL OUT OF CONTAINER DURING DOOR CLOSING. REINSTALLED SLIDE PER MM.SDR SWAA010051Slide · dischargedDURING SCHEDULED A2 CHECK, FOUND AFT ENTRY DOOR EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR UPS01834592Slide · looseINSPECTION TYPE:N/A, ESCAPE SLIDE LOOSE. *S/D* RESECURED ESCAPE SLIDE AS NEEDED PER MM 25-60.SDR SWAA010022Slide · looseDURING SCHEDULED 1/4D CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS INDICATOR VIEW LENS LOOSE AND INDICATOR NOT VISIBLE. SECURED VIEW LENS PER MM.SDR SWAA010020Slide · dischargedDURING SCHEDULED A1 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE PRESS INDICATOR LOW. REMOVED AND REPLACED EVAC SLIDE ASSY PER MM.SDR SWAA010033Slide · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. REPOSITIONED EVAC SLIDE ASSY PER MM.SDR SWAA010029Slide · out of adjDURING SCHEDULED C3 CHECK, FOUND FWD SVC AND ENTRY DOORS EMERGENCY EVAC SLIDE GIRT ASSY''S OUT OF ADJUST. RE-ADJUSTED EVAC SLIDE ASSY''S PER MM.SDR AU010012Slide · damaged(AUS) NR 4 LT MAIN DOOR ESCAPE SLIDE TORN.SDR SWAA010021Slide · dischargedDURING SCHEDULED SERVICE CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS INDICATOR LOW. REMOVED AND REPLACED EVAC SLIDE ASSY PER MM.SDR MWEA010023Clip · missingFORWARD SERVICE DOOR SLIDE COVER RIGHT SIDE KEEPS COMING OFF. -- MAINTENANCE REATTACHED LOWER SLIDE COVER LANYARD CLIP.SDR 20010129CW020Slide Raft · misinstalledFOUND 8 FT LONG BY 2 INCHES WIDE, RED WEBBING STRAP TIED AROUND THE FOLDED INFLATABLE SLIDE/RAFT. IF THE UNIT WERE TO BE USED IN AN EMERGENCY, THE SLIDE WOULD NOT HAVE DEPLOYED PROPERLY.SDR SWAA010012Retainer · looseDURING SCHEDULED C1 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY RETAINER LOOSE. SECURED RETAINER PER MM.SDR AU010063Cable · frayed(AUS) L2 DOOR SLIDE ATTACHMENT CABLE FRAYED IN LOOP AREA.SDR SWAA010002Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE ASSY PER MM.SDR SWA010002Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA010014Slide · misinstalledFWD ENTRY DOOR EMERGENCY EVAC SLIDE ASSY FELL OUT OF CONTAINER. REINSTALLED EVAC SLIDE ASSY PER MM.SDR SWA002788Indicator · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE ASSY PER MM.SDR SWA002783Slide · deployedFWD SVC DOOR EMERGENCY EVAC SLIDE INADVERTENTLY DEPLOYED. REMOVED AND REPLACED EVAC SLIDE ASSY PER MM.SDR SWA002782Indicator · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE ASSY PER MM.SDR 20010205SG001Slide · deployedFLT 3175 - ORD - FLIGHT ATTENDANT INADVERTENTLY DEPLOYED L1 DOOR EMERGENCY ESCAPE SLIDE WHEN DOOR WAS OPENED. REMOVED AND REPLACED L1 DOOR ESCAPE SLIDE. SYSTEM OPERATED NORMAL. (M)SDR SWA002784Slide · dislodgedFWD SVC DOOR EMERGENCY EVAC SLIDE ASSY FELL OUT OF CONTAINER. REINSTALLED EVAC SLIDE ASSY PER MM.SDR SWA002780Slide · out of adjFWD SVC DOOR EMERGENCY EVAC SLIDE SLIDE ASSY OUT OF ADJUST. REPOSITIONED EVAC SLIDE ASSY PER MM.SDR SWA002779Indicator · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE ASSY PER MM.SDR SWA002778Indicator · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWA002770Slide · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE ASSY PER MM.SDR 2000UALA00824Slide · leakingLEFT HAND OFF WING SLIDE FAILED AIR RETENTION CHECK IN THE SHOP. HOLE WAS CUT BY ASPIRATOR DURING PACKING. SENT SLIDE TO VENDOR FOR REPAIR.SDR SPAA0000027Slide · unserviceableDURING PREFLIGHT INSPECTION, FOUND L-2 DOOR MOUNTED EVACUATION SLIDE CYLINDER PRESSURE LOW. REMOVED AND REPLACED EVACUATION SLIDE ASSEMBLY.SDR AU001280Cable · damaged(AUS) ESCAPE SLIDE RESERVOIR ASSEMBLY WIRE CONTROL INTERNAL CABLE DAMAGED (KINKED) AT THE END AND AT THE ROD TO CABLE SWAGE. DAMAGE ALSO TO THE END FITTING. FOUND DURING TESTING IAW WR 25-60/119.SDR SWAA002764Slide · detachedFWD SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR SWAA002757Indicator · out of positionDURING SCHEDULED C1 CHECK, FOUND AFT SVC AND ENTRY DOORS EMERGENCY EVAC SLIDE PRESS INDICATORS OUT OF VIEW. REPOSITIONED SLIDE ASSYS PER MM.SDR UPS00834571Bottle · dischargedINSPECTION TYPE:PFLT CREW PREFLT - EMERGENCY ESCAPE SLIDE PRESSURE LOW. SERVICED ESCAPE BOTTLE PER DC-8 MM 25-68-04SDR 0004646622Slide · inoperativeDURING SLIDE SHOP TEST, SLIDE FAILED TO DEPLOY IN NORMAL FLAT FIRE TEST. RESERVOIR VALVE HAD TO BE MANUALLY FIRED. INSTALLED MODIFIED RESERVOIR ASSEMBLY WITH -9 VALVE PER 66-00525-8-0164.SDR SWAA002741Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT OF CONTAINER WHEN DOOR WAS OPENED. REINSTALLED EVAC SLIDE MM.SDR AU001253Battery · faulty(AUS) LT AND RT ESCAPE SLIDE BATTERY PACK AND CHARGER ASSEMBLIES FAULTY.SDR SWAA002743Slide · out of adjEVAC SLIDE GIRT ASSY ON 3 OF 4 DOORS ARE OUT OF ADJUSTMENT. READJUSTED EVAC SLIDE ASSY PER MM.
Back to JASC 2565