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 SWAA020597Chain · chafedDURING SCHEDULED C1 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE RELEASE CHAIN CHAFED. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA020595Lanyard · brokenFWD ENTRY DOOR EMERGENCY EVAC SLIDE LANYARD CHAIN BROKEN. REMOVED AND REPLACED SLIDE PER MM.SDR AALA20020328Bottle · lowORD - DURING OVERNIGHT MAINTENANCE, FOUND LOW BOTTLE FOR L4 DOOR EMERGENCY EXIT SLIDE. REPLACED SLIDE ASSEMBLY WITH SERVICEABLE UNIT. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20020326Bottle · lowORD - DURING OVERNIGHT MAINTENANCE, FOUND LOW BOTTLE FOR L4 DOOR EMERGENCY EXIT SLIDE. REPLACED SLIDE ASSEMBLY WITH SERVICEABLE UNIT. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR SWAA020589Slide · out of positionDURING SCHEDULED BC3 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA020588Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF THE CONTAINER. REINSTALLED SLIDE PER MM.SDR GTIA020490Slide · unsecureFTW - FOUND AFT FUSELAGE COMPARTMENT TAIL SLIDE UNPACKED. REMOVED SLIDE. TAIL CONE INSTALLED. (M)SDR USAABB02034Girt Bar · damagedCLT - GIRT BAR ENGAGEMENT LIGHT DID NOT ILLUMINATE WITH SLIDE ARMING LEVER IN THE ARMED POSITION (L1 DOOR). MAINTENANCE REINSTALLED THE GIRT BAR. (M)SDR SWAA020585Slide · unserviceableAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR AUS20020353Pin · installed(AUS) LT AND RT FORWARD DOORS AND LT AFT DOOR ESCAPE SLIDES HAD MAINTENANCE SAFETY PINS INSTALLED. PERSONNEL/MAINTENANCE ERROR.SDR ASAA0280074Lanyard · disconnectedANC - DURING PREFLIGHT CHECK, R-1 DOOR EMERGENCY SLIDE LANYARD WAS FOUND TO BE DETACHED. REATTACHED LANYARD. (M)SDR SWAA020574Cable · misroutedDURING SCHEDULED C3 CHECK, FOUND BOTH AFT CABIN DOOR EMERGENCY EVAC SLIDE CABLES MISROUTED. REROUTED CABLES PER MM.SDR SWAA020573Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND BOTH AFT CABIN DOOR EMERGENCY EVAC SLIDES DRAGGING WHEN CLOSING DOOR. ADJUSTED SLIDES PER MM.SDR SWAA020580Slide · out of adjustDURING SCHEDULED BC4 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM..SDR SWAA020579Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR ASAA0280073Lanyard · disconnectedSEA - DURING PREFLIGHT CHECK, R-1 DOOR EMERGENCY SLIDE LANYARD WAS FOUND TO BE DETACHED. REATTACHED LANYARD. (M)SDR AWXA200200250Reservoir · brokenPHX - ESCAPE SLIDE - "C" - DURING P-09 INSPECTION THE R/H OVERWING ESCAPE SLIDE BOTTLE CABLE WAS FOUND BROKEN AT THE HOOK UP POINT. MAINTENANCE REMOVED AND REPLACED THE R/H OVERWING SLIDE BOTTLE ASSEMBLY AND RESERVOIR IAW AMM 25-62-46-800-001.SDR SWAA020559Slide · out of positionDURING SCHEDULED C4 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA020558Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA020561Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT OF THE CONTAINER. REINSTALLED SLIDE PER MM.SDR GTIA020230Lanyard · detachedMYR - FLT 557 - FORWARD GALLEY ESCAPE SLIDE LANYARD IS OFF. REINSTALLED LANYARD ON FORWARD GALLEY ESCAPE SLIDE IAW MD80 MM 25-62-00. NO DEFECTS NOTED. (M)SDR SWAA020553Slide · out of positionDURING SCHEDULED C3 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR 2002F00508Slide · deployedL2 SLIDE INADVERTENTLY DEPLOYED AT THE GATE IN PVR. (M)SDR SWAA020549Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR USAABB02024Connector · dirtyMUC - RIGHT OVERWING ESCAPE SLIDE SQUIB FAILED TEST. MAINTENANCE CLEANED THE RIGHT BATTERY PACK CONNECTOR. (M)SDR SWAA020538Slide · out of positionAFT SERVICE DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA020535Slide · looseFWD ENTRY DOOR EMERGENCY EVAC SLIDE LOOSE. SECURED SLIDE PER MM.SDR SWAA020534Slide · unserviceableFWD ENTRY DOOR EVACUATION SLIDE PRESS IND OUT OF LIMIT. REMOVED AND REPLACED EVACUATION SLIDE ASSY PER MM.SDR SWAA020520Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND BOTH FWD CABIN DOOR EMERGENCY EVAC SLIDE GIRT STRAP PLAY OUTS OUT OF ADJUST. ADJUSTED SLIDES PER MM.SDR SWAA020518Slide · looseAFT SVC DOOR EMERGENCY EVAC SLIDE GIRT BAR STRAP LOOSE. SECURED SLIDE PER MM.SDR SWAA020514Slide · unserviceableDURING SCHEDULED C1 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA020512Slide · displacedFWD SVC DOOR EMERGENCY EVAC SLIDE DISPLACED FROM CASE WHEN DOOR CLOSED. REINSTALLED SLIDE PER MM.SDR SWAA020513Slide · displacedFWD ENTRY DOOR EMERGENCY EVAC SLIDE INADVERTANTLY FELL OUT OF THE CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA020511Slide · displacedFWD SVC DOOR EMERGENCY EVAC SLIDE DISPLACED FROM CASE WHEN DOOR CLOSED. REINSTALLED SLIDE PER MM.SDR SWAA020510Container · looseFWD ENTRY DOOR EMERGENCY EVAC SLIDE CONTAINER LOOSE. SECURED CONTAINER PER MM.SDR SWAA020505Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA020504Bracket · looseDURING SCHEDULED C2 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE GIRT BAR BRACKET HAS A BROKEN RIVET. REMOVED AND REPLACED RIVET PER SRM.SDR SWAA020492Slide · out of positionDURING SCHEDULED A2 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR ASAA0280063Lanyard · disconnectedSEA - LEFT AFT GALLEY DOOR EMERGENCY SLIDE LANYARD DISCONNECTED. REATTACHED LANYARD. (M)SDR SWAA020475Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA020472Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA020462Slide · unserviceableFWD SVC DOOR EMERGENCY EVAC SLIDE HAS LOW PRESS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA020461Slide · unserviceableAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR P2EA2002M012Housing · looseL1 DOOR SLIDE HOUSING FOUND LOOSE AT GATE AFTER FLIGHT. RESECURED HOUSING IAW MM 25-60.SDR SWAA020458Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND BOTH FWD CABIN DOOR EMERGENCY EVAC SLIDE GIRT BAR ASSY'S OUT OF ADJUST. ADJUSTED SLIDES PER MM.SDR ASAA0280058Lanyard · disconnectedSEA - FORWARD PASSENGER ENTRY L-1 DOOR EMERGENCY SLIDE LANYARD DISCONNECTED. REATTACHED LANYARD. (M)SDR AT0200029Slide · out of positionFORWARD L1 DOOR CHUTE FELL OUT OF CONTAINER. REINSTALLED SLIDE REF 25-62.SDR SWAA020456Slide · out of positionDURING SCHEDULED C1 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA020454Slide · out of positionDURING SCHEDULED C2 CHECK, FOUND BOTH AFT CABIN DOOR EMERGENCY EVAC SLIDE PRESS IND'S OUT OF VIEW. REPOSITIONED SLIDES PER MM.SDR SWAA020452Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.
Back to JASC 2565