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 AALA20010156Slide · defectiveLGA- WHILE ON GROUND L1 DOOR INADVERTENTLY DEPLOYED. SLIDE PARTIALLY DEPLOYED. REPLACED L1 DOOR SLIDE. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR SWAA010295Slide · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE ASSY FELL OUT OF CONTAINER. REINSTALLED EVAC SLIDE ASSY PER MM.SDR SWAA010284Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE ASSY INADVERTENTLY FELL OUT OF CONTAINER. REINSTALLED EVAC SLIDE ASSY PER MM.SDR SWAA010280Slide · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE ASSY PER MM.SDR SWAA010279Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE ASSY FELL OUT OF CONTAINER. REINSTALLED EVAC SLIDE ASSY PER MM.SDR ASAA0180030Lanyard · disconnectedPDX - DURING PRE-FLIGHT CHECK, L1 DOOR EMERGENCY SLIDE LANYARD WAS FOUND TO BE DISCONNECTED FROM SLIDE COVER AND FROM GIRT BAR. RECONNECTED GIRT BAR TO BOTH THE SLIDE COVER AND GIRT BAR. (M)SDR SWAA010262Slide · out of adjDURING SCHEDULED C4 CHECK, FOUND EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED EVAC SLIDE ASSY PER MM.SDR A6WA200100013Slide · will not testLIGHTS ON EMERGENCY ESCAPE SLIDE NOT ILLUMINATE DUE TO PIN IN BATTERY NOT BEING PULLED OUT UPON DEPLOYMENT. SNAP THAT HOLDS PIN LANYARD BECAME DETACHED INSTEAD. MAINTENANCE REMOVED AND REPLACED EMERGENCY SLIDE ASSEMBLY.SDR USAAD01015Slide · dischargedPHL - THE GALLEY SERVICE DOOR EVACUATION SLIDE INFLATION BOTTLE PRESSURE WAS BELOW THE GREEN ARC. MAINTENANCE REPLACED THE EVACUATION SLIDE. (M)SDR SWAA010241Slide · out of adjDURING SCHEDULED C3 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. RE-ADJUSTED EVAC SLIDE ASSY PER MM.SDR TWAA0101604Bottle · dischargedTHE LEFT SIDE NUMBER 4 CABIN DOOR EVACUATION SLIDE HAD LOW BOTTLE PRESSURE. REPLACED THE SLIDE ASSEMBLY. CHECK-C 9-27-99 LAX.SDR AU010070Slide · faulty(AUS) RT MAIN ENTRY DOOR SLIDE FAILED TO CORRECTLY DEPLOY DURING TEST. THE SLIDE CAUGHT ON THE DOOR STRUCTURE SUSTAINING A SMALL PUNCTURE AND DAMAGING THE LOWER BUSTLE.SDR VW3R200100005Tube · damagedTHE EVACUATION SLIDE WAS RECEIVED WITH EXCESSIVE WEAR ON THE GIRT ASSEMBLY AND A ONE INCH HOLE WORN IN THE INFLATION TUBE NEXT TO THE GIRT. SLIDE WAS MANUFACTUED IN 07/1989. IF THIS SLIDE WERE NEEDED IN AN EMERGENCY IT WOULD NOT HAVE RETAINED AIR TO SUPPORT SDR SWAA010240Retainer · looseDURING SCHEDULED C3 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT RETAINER HOOK LOOSE. SECURED RETAINER HOOK PER MM.SDR SWAA010236Slide · dislodgedFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED EVAC SLIDE ASSY PER MM.SDR SWAA010223Retainer · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE RETENTION BAR HITTING FUSELAGE DURING DOOR CLOSING/OPENING. REMOVED AND REPLACED EVAC SLIDE COVER PER MM.SDR SWAA010222Bottle · dischargedDURING SCHEDULED RON CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE ASSY PER MM.SDR SWAA010221Indicator · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. RE-ADJUSTED EVAC SLIDE ASSY PER MM.SDR ASAA0180029Battery · dischargedPHX - DURING K-CHECK, AFT SERVICE DOOR EMERGENCY SLIDE LIGHTING HARNESS BATTERY WAS DETERMINED TO HAVE LOW VOLTAGE. REPLACED COMPLETE SLIDE ASSEMBLY. VOLTS/AMPS CHECKED OK. (M)SDR SWAA010229Bracket · looseDURING SCHEDULED C3 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT BRACKET LOOSE. SECURED GIRT BRACKET PER MM.SDR SWAA010214Slide · out of adjDURING SCHEDULED C1 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. REPOSITIONED EVAC SLIDE ASSY PER MM.SDR MWEA010114Slide · will not testTHE TAIL CONE SLIDE DEPLOYMENT CHECK FAILED WHEN TAIL CONE WAS RELEASED, THE EVACUATION SLIDE COVER DID NOT RELEASE. BLENDED CRACKED/TORN METAL FOUND AROUND GIRT BAR MOUNT HOLES AND FABRICATED AND INSTALLED REPAIR CATWALK DOUBLERS AND SHIMS. FABRICATED AND ISDR AALA20010181Slide · defectiveSJC - WHILE ON GROUND, R1 DOOR INADVERTENTLY DEPLOYED. SLIDE PARTIALLY DEPLOYED. REPLACED R1 DOOR SLIDE. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR SWAA010215Slide · out of adjDURING SCHEDULED C3 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. REPOSITIONED EVAC SLIDE ASSY PER MM.SDR SWAA010207Bottle · dischargedDURING SCHEDULED RON CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED AFT SLIDE PER MM.SDR SWAA010196Bracket · corrodedDURING SCHEDULED D-CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT BRACKET CORRODED. REMOVED AND REPLACED GIRT BRACKET PER SRM.SDR SWAA010204Retainer · looseDURING SCHEDULED C2 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT RETAINER HOOKS HAVE LOOSE RIVETS. SECURED GIRT RETAINER PER MM.SDR SWAA010184Screw · missingFWD ENTRY DOOR EMERGENCY EVAC SLIDE ASSY MISSING SCREW. INSTALLED SCREW INBOARD SIDE PER MM.SDR SWAA010180Indicator · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE ASSY PER MM.SDR SWAA010174Bottle · dischargedFWD ENTRY DOOR EMERGENCY EVAC SLIDE PRESS OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE ASSY PER MM.SDR SWAA010163Retainer · looseDURING SCHEDULED C1 CHECK, FOUND FWD SVC AND ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY RETAINER CLIPS LOOSE. SECURED GIRT ASSY RETAINERS PER MM.SDR SWAA010162Indicator · out of positionDURING SCHEDULED C2 CHECK, FOUND AFT SVC AND ENTRY DOOR EMERGENCY EVAC SLIDE PRESS INDICATORS OUT OF VIEW. REPOSITIONED EVAC SLIDE ASSY''S PER MM.SDR USAASA02009Cable Fitting · brokenDCA - THE LEFT OVERWING SLIDE INFLATION BOTTLE SIDE CABLE END WAS FOUND BROKEN. MAINTENANCE INSTALLED A NEW INFLATION BOTTLE ASSEMBLY AND CABLE END. OK FOR SERVICE. (M)SDR GTIA010015Slide · out of positionDTW - FORWARD SERVICE DOOR EVACUATION SLIDE CAME OFF. INSTALLED SLIDE PACK IAW MD-80 MM 25-62-00. NO DEFECTS NOTED AT THIS TIME. (M)SDR 20010207SG019Cable · brokenDURING ROUTINE C-CHECK, FOUND L2 DOOR EMERGENCY ESCAPE SLIDE DEPLOY RELEASE CABLE SAFETY STRING BROKEN AT PARACHUTE PIN. REPLACED SLIDE ASSEMBLY. (M)SDR 20010207SG018Cable · brokenDURING ROUTINE C-CHECK, FOUND L1 DOOR EMERGENCY ESCAPE SLIDE DEPLOY RELEASE CABLE BREAKAWAY STRING BROKEN AT PARACHUTE PINS. REPLACED ESCAPE SLIDE. (M)SDR SWAA010130Slide · out of adjDURING SCHEDULED PM CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE ASSY OUT OF ADJUST. RE-ADJUSTED EVAC SLIDE ASSY PER MM.SDR SWAA010129Bracket · corrodedDURING SCHEDULED D-CHECK, FOUND FWD ENTRY DOOR GIRT BAR ATTACH FLOOR BRACKETS CORRODED. REMOVED AND REPLACED GIRT BAR BRACKETS PER SRM.SDR SWAA010143Slide · out of adjDURING SCHEDULED C2 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED EVAC SLIDE ASSY PER MM.SDR SWAA010141Indicator · out of positionDURING SCHEDULED C3 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE ASSY PER MM.SDR SWAA010137Slide · detachedFWD ENTRY DOOR EMERGENCY EVAC SLIDE ASSY FELL OUT OF CONTAINER INADVERTENTLY. REINSTALLED EVAC SLIDE ASSY PER MM.SDR USAAD01052Handle · missingBWI - THE FORWARD GALLEY SERVICE DOOR EMERGENCY EVACUATION SLIDE MANUAL RELEASE WAS NOT ATTACHED TO THE LANYARD. MAINTENANCE SECURED THE MANUAL RELEASE. (M)SDR SWAA010119Bracket · looseDURING SCHEDULED 1/2D CHECK, FOUND FWD ENTRY DOOR GIRT ASSY FWD FLOOR BRACKET LOOSE. SECURED BRACKET PER MM.SDR SWAA010105Slide · detachedWHEN FWD SVC DOOR OPENED, EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT OF CONTANER (GIRT ASSY LEFT INSTALLED). REINSTALLED EVAC SLIDE ASSY PER MM.SDR SWAA010115Bracket · looseDURING SCHEDULED C3 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY BRACKET RIVETS LOOSE. SECURED GIRT BRACKET PER MM.SDR SWAA010107Slide · dislodgedAFT SVC DOOR EMERGENCY EVAC SLIDE ASSY FELL OUT OF CONTAINER. REINSTALLED EVAC SLIDE ASSY PER MM.SDR SWAA010101Slide · detachedAFT SVC DOOR EMERGENCY EVAC SLIDE ASSY FELL OUT OF CONTAINER. REMOVED AND REPLACED EVAC SLIDE ASSY PER MM.SDR SWAA010099Slide · out of adjAFT SVC AND ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. RE-ADJUSTED EVAC SLIDE ASSY''''S PER MM.SDR SWAA010098Indicator · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE ASSY PER MM.SDR SWAA010110Bottle · dischargedDURING SCHEDULED SERVICE CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND LOW. REMOVED AND REPLACED EVAC SLIDE ASSY PER MM.
Back to JASC 2565