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 SWAA012924Slide · out of positionAFT SERVICE DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA012931Slide · out of positionDURING SCHEDULED C2 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA012928Fastener · looseDURING SCHEDULED C2 CHECK, FOUND LOOSE FASTENER AT FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT BAR RETAINING HOOK. SECURED GIRT BAR HOOK PER MM.SDR SWAA012927Slide · dirtyDURING SCHEDULED C2 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND WINDOW DIFFICULT TO SEE THROUGH. CLEANED WINDOW PER MM.SDR SWAA012926Fastener · looseDURING SCHEDULED C2 CHECK, FOUND LOOSE FASTENER AT FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT BAR RETAINING HOOK. SECURED GIRT BAR HOOK PER MM.SDR SWAA012922Slide · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR GTIA011097Slide · failedFTW - TAILCONE DOOR SLIDE DEPLOYMENT SYSTEM FAIL TEST ESCAPE SLIDE, BECAME UNPACKED DURING TEST. REMOVED TAIL SLIDE IAW MD80 MM 25-61-00. INSTALLED SLIDE IAW MD80 MM 25-62-01 PERFORMED OPERATIONAL CHECK TAIL CONE SLIDE DEPLOYMENT SYSTEM PER SPIRIT AIRLINES TSDR SWAA012920Fastener · looseFWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT BAR RETAINING HOOK HAS LOOSE FASTENER. REMOVED AND REPLACED GIRT BAR FASTENER PER SRM.SDR AALA20011949Slide · defectiveDFW - FLT 1732 - AFT DOOR SLIDE INADVERTENTLY DEPLOYED. SLIDE PARTIALLY DEPLOYED. REPLACED AFT DOOR SLIDE. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR 0103795522Slide · rupturedDURING SLIDE SHOP TEST, INFLATABLE SUB ASSEMBLY SEAM RUPTURED AT NORMAL OPERATING PRESSURE. NEW INFLATABLE SUB ASSEMBLY WAS INSTALLED.SDR SWAA012893Slide · out of adjFWD ENTRY DOOR EMERGENCY EVAC SLIDE OUT OF ADJUSTMENT. ADJUSTED SLIDE PER MM.SDR AUS20011131Slide · misinstalled(AUS) LT OFF WING ESCAPE SLIDE FITTED TO AIRCRAFT. SLIDE HAD BEEN FITTED FOLLOWING INADVERTANT FIRING OF THE FITTED SLIDE. THE SLIDE FITTED WAS FOR A -238 SERIES AIRCRAFT.SDR USAAD01175Slide · unserviceablePIT - THE L2 SERVICE DOOR EMERGENCY EVACUATION SLIDE INFLATION BOTTLE PRESSURE WAS LOW. MAINTENANCE REPLACED THE EMERGENCY EVACUATION SLIDE. (M)SDR UPS01M37188Slide · will not testINSPECTION TYPE:IN M224780 LOW PRESSURE LIGHT WILL NOT TEST. REPLACED SLIDE/RAFT ASSY PER MM 25-61-01. OPS CHECKS NORMAL.SDR SWAA012894Slide · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA012890Slide · out of positionDURING SCHEDULED C1 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR UPS01M37186Battery · dischargedINSPECTION TYPE:IN REF M 224780 LT ESCAPE SLIDE BOTTLE LOW LIGHT WILL NOT TEST. REMOVED AND REPLACED BATTERIES FOR LOW PRESS TEST LIGHT IAW 25-61-01, CHECKS GOOD.SDR SWAA012898Slide · out of adjDURING SCHEDULED C4 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA012873Slide · looseAFT ENTRY DOOR EMERGENCY EVAC SLIDE FASTENER LOOSE ON SLIDE CONTAINER. SECURED CONTAINER PER MM.SDR SWAA012872Slide · unserviceableFWD ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR AUS20011096Slide · misrigged(AUS) ESCAPE SLIDE INCORRECTLY RIGGED. DEPLOY CABLE ROUTED OVER THE RAFT INSTEAD OF BEHIND.SDR SWAA012860Slide · out of positionFOUND FWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR ASAA0180287Harness · failedOAK - DURING C-CHECK, AFT (REAR) DOOR EMERGENCY SLIDE HARNESS FAILED SYSTEM CHECK. REPLACED EMERGENCY SLIDE. SYSTEM CHECKED OK. (M)SDR 0103739853Slide · inoperativeDURING LINE CHECK, DISCOVERED RESERVOIR TO BE AT ZERO PSI. REPLACED THE SLIDE AND RETURNED REMOVED SLIDE TO SHOP FOR REPAIR.SDR SWAA012853Slide · looseFWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT BAR LOOSE. SECURED GIRT BAR PER MM.SDR SWAA012847Slide · looseDURING SCHEDULED C2 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT BAR FLAP LOOSE. ADJUSTED GIRT BAR FLAP.SDR SWAA012859Slide · looseFOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE OUT OF ADJUSTMENT. REPOSITIONED SLIDE PER MM.SDR DL72W011676Slide · unserviceableDURING LAYOVER CHECK, FOUND EMERGENCY SLIDE 2 LEFT PRESSURE LOW. REPLACED SLIDE.SDR SWAA012832Slide · looseFWD ENTRY DOOR EMERGENCY EVAC SLIDE LOOSE. SECURED SLIDE PER MM.SDR SWAA012831Slide · looseAFT ENTRY DOOR EMERGENCY EVAC SLIDE GIRT BAR LANYARD LOOSE. SECURED LANYARD PER MM.SDR SWAA012852Slide · looseAFT ENTRY DOOR EMERGENCY EVAC SLIDE LOOSE. SECURED SLIDE PER MM.SDR SWAA012844Slide · out of positionDURING SCHEDULED C2 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA012830Slide · out of positionDURING SCHEDULED C4 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR UPS01M37187Light · will not testINSPECTION TYPE:IN LT ESCAPE SLIDE LOW PRESS WARNING LIGHT INOP WILL NOT TEST.SDR SWAA012826Slide · unserviceableDURING SCHEDULED A1 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA012814Window · missingAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND VIEWING WINDOW MISSING. INSTALLED VIEWING WINDOW PER MM.SDR SWAA012809Slide · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA012798Bracket · looseFWD SVC DOOR EMERGENCY EVAC SLIDE RETENTION BAR BRACKET LOOSE. R&R BRACKET PER MM.SDR 0103783244Slide · leakingDURING SLIDE SHOP TEST, FAILED LEAK CHECK. OVERHAULED AND REPAIRED PER AIR CRUISERS MAINTENANCE MANUAL PA 15609 AND PACKING PUBLICATION 26657.SDR SWAA012806Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA012808Hook · looseDURING SCHEDULED C4 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT BAR HOOK LOOSE. SECURED HOOK PER MM.SDR SWAA012801Slide · looseDURING SCHEDULED C2 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE VEIWING WINDOW LOOSE. SECURED WINDOW PER MM.SDR SWAA012807Slide · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA012792Slide · out of positionDURING SCHEDULED C2 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR GTIA010974Lanyard · brokenL1 DOOR EMERGENCY EXIT DOOR EVACUATION SLIDE CABLE ATTACH TO GIRT BAR BROKEN. REMOVED AND REPLACED LANYARD ASSY ON L1 DOOR IAW MM CH 25-60-00. (M)SDR SWAA012774Bracket · looseFWD ENTRY DOOR EMERGENCY EVAC SLIDE CONTAINER RH ATTACH BRACKET LOOSE. SECURED BRACKET PER MM.SDR 2001UALA02104Slide · cutDOOR 1 RT SLIDE/RAFT P/N 62771-118, S/N 0284 FOUND TO HAVE 5 CUTS IN INFLATABLE. CUTS FOUND DURING SHOP OVERHAUL OF THE UNIT. THERE WERE 3 CUTS IN TOP TUBE AND 2 IN BOTTOM TUBE ON RT SIDE OF SLIDE/RAFT ABOVE BOTTOM TUBE RELIEF VALVE. CUTS IN THE INFLATABLE ASDR SWAA012775Slide · looseAFT SVC DOOR EMERGENCY EVAC SLIDE LOOSE. SECURED SLIDE PER MM.SDR SWAA012773Slide · looseFWD ENTRY DOOR EMERGENCY EVAC SLIDE LOOSE. SECURED SLIDE PER MM.SDR SWAA012769Slide · out of adjAFT SVC DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.
Back to JASC 2565