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 GTIA020642Slide · out of positionFLL - FLT 258 - L1 DOOR SLIDE PACK FELL OFF. REMOVED AND REPLACED L1 DOOR SLIDE PACK IAW MD80 MM 25-62-00. NO DEFECTS NOTED AT THIS TIME. (M)SDR SWAA021281Slide · out of positionDURING SCHEDULED C4 CHECK, FOUND BOTH AFT CABIN DOOR EMERGENCY EVAC SLIDE PRESS IND'S OUT OF VIEW. REPOSITIONED SLIDES PER MM.SDR SWAA021261Slide · looseFWD SVC DOOR EMERGENCY EVAC SLIDE LOOSE IN CONTAINER. SECURED SLIDE PER MM.SDR SWAA021254Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA021262Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA021258Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA021257Slide · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA021290Slide · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR CALA0200329Bottle · dischargedTHE R1 DOOR SLIDE BOTTLE PRESSURE WAS FOUND AT ZERO DURING SLIDE INSPECTION. THE R1 DOOR SLIDE WAS REMOVED AND REPLACED IAW MM 25-60-10.SDR AUS20020553Battery · faulty(AUS) LT AND RT SIDE ESCAPE SLIDE SQUIB BATTERY PACKS FAULTY.SDR SWAA021269Slide · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT OF THE CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA021256Cable · misroutedDURING SCHEDULED C1 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED CABLE PER MM.SDR SWAA021255Cable · misroutedDURING SCHEDULED C3 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED CABLE PER MM.SDR SWAA021260Slide · out of positionDURING SCHEDULED C4 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA021239Slide · unserviceableFWD ENTRY DOOR EVACUATION SLIDE PRESS INDICATOR OUT OF LIMITS. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR USAASA02052Slide · reads lowTHE L2 DOOR ESCAPE SLIDE INDICATES LOW PRESSURE. MAINTENANCE REPLACED THE L2 DOOR ESCAPE SLIDE. OK FOR SERVICE.SDR AUS20020528Slide · faulty(AUS) DOOR 2R ESCAPE SLIDE FAILED TO INFLATE DURING FUNCTIONAL TEST.SLIDE INFLATED USING THE MANUAL INFLATION SYSTEM. SLIDE LIGHTINGALSO INOPERATIVE.SDR SWAA021229Slide · out of positionDURING SCHEDULED C3 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA021217Slide · looseFWD ENTRY DOOR EMERGENCY EVAC SLIDE LOOSE IN CONTAINER. SECURED SLIDE PER MM.SDR SWAA021216Slide · looseFWD SVC DOOR EMERGENCY EVAC SLIDE LOOSE IN CONTAINER. SECURED SLIDE PER MM.SDR ASAA0280196Lanyard · disconnectedSEA - DURING PREFLIGHT CHECK, L2 DOOR EMERGENCY SLIDE LANYARD WAS FOUND TO BE DETACHED. ATTACHED LANYARD. (M)SDR 377PA0001Slide · unserviceableL1 DOOR SLIDE PRESSURE LOW. REMOVED AND REPLACED SLIDE.SDR SWAA021218Slide · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA021214Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF THE CONTAINER INADVERTENTLY. REINSTALLED SLIDE PER MM.SDR SWAA021206Slide · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR USAABB02107Slide · tornPHL - DURING AN SLIDE INFLATION OPERATIONAL CHECK ON THE L3 DOOR, THE SLIDE TORE IN THE THRESHOLD AREA. THE TEAR EMANATED FROM THE CENTER OF THE MATERIAL AND PROGRESSEDOUT TOWARD THE EDGES. THE EDGES OF THE SLIDE REMAINED INTACT. THE SLIDE INFLATED PROPERLYSDR USA2002F00064Slide · tornDURING A SLIDE INFLATION OPERATIONAL CHECK ON THE LEFT 3 DOOR, THE SLIDE TORE IN THE THRESHOLD AREA. THE TEAR EMINATED FROM THE CENTER OFT HE MATERIAL AND PROGRESSED OUT TOWARD THE EDGES. THE EDGES OF THE SLIDE REMAINED INTACT. THE SLIDE INFLATED PROPERLY ASDR GTIA020616Slide · out of positionMCO - FLT 927 - FOUND L1 SLIDE PACK CAME OFF DOOR WHEN IT WAS OPENED. REINSTALLED L1 SLIDE PACK. (M)SDR SWAA021215Slide · looseFWD SVC DOOR EMERGENCY EVAC SLIDE LOOSE IN CONTAINER. SECURED SLIDE PER MM.SDR SWAA021205Slide · unserviceableAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA021202Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND BOTH FWD CABIN DOOR EMERGENCY EVAC SLIDE GIRT ASSY'S OUT OF ADJUST. ADJUSTED SLIDES PER MM.SDR ASAA0280194Lanyard · disconnectedSEA - DURING PREFLIGHT CHECK, R1 DOOR EMERGENCY SLIDE LANYARD WAS FOUND TO BE DETACHED. ATTACHED LANYARD. (M)SDR SWAA021194Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA021186Slide · unserviceableDURING SCHEDULED SERVICE CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA021184Slide · out of adjustFWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA021195Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA021188Retainer · looseDURING SCHEDULED C4 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE CASE RETAINER LOOSE. REMOVED AND REPLACED CASE RETAINER PER MM.SDR SWAA021204Slide · out of adjustFWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR ASAA0280193Lanyard · disconnectedSEA - DURING PREFLIGHT CHECK, R2 DOOR EMERGENCY SLIDE LANYARD WAS FOUND TO BE DETACHED. ATTACHED LANYARD. (M)SDR SWAA021168Slide · deployedDURING SCHEDULED RON, FWD ENTRY DOOR EMERGENCY EVAC SLIDE INADVERTENTLY DEPLOYED. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA021175Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR 0201821232Tube · wornDURING ROUTINE FUNCTIONAL CHECK, UPPER INFLATION TUBE FAILED TO INFLATE FULLY DUE TO KINKED AND WORN HOSE. THESE WERE NOT REPLACED ON PREVIOUS OVERHAUL PER S/B 25-293 DATED 10/97.SDR ASAA0280187Lanyard · detachedSAN - DURING PREFLIGHT CHECK, R1 DOOR EMERGENCY SLIDE LANYARD WAS FOUND TO BE DETACHED. ATTACHED LANYARD. (M)SDR SWAA021116Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA021124Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT OF THE CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA021115Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND BOTH AFT CABIN DOOR EMERGENCY EVAC SLIDE GIRT ASSY'S OUT OF ADJUST. ADJUSTED SLIDES PER MM.SDR SWAA021107Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR ASM2002F00004Slide · failedON ARRIVAL, FLIGHT ATTENDANT REPORTED THE AFT GALLEY SLIDE WAS LOCKED AND UNABLE TO UNLOCK. WHEN INSPECTED BY THE MECHANIC THE SLIDE COVER SEPARATED FROM THE DOOR. THE COVER SLIDE WAS REINSTALLED ON THE DOOR, THE BAR WAS REPOSITIONED AND THE SAFETY PIN WAS RSDR GTIA020511Slide · out of positionSJU - L1 DOOR EMERGENCY ESCAPE SLIDE PACK FELL OFF. REINSTALLED L1 EMERGENCY ESCAPE SLIDE PACK. (M)SDR ASM2002F00001Slide · deployedWHILE IN TRANSIT, THE MECHANIC TRIED TO ADJUST THE BAR OF THE AFT GALLEY SLIDE AND IT WAS DEPLOYED. THE AIRCRAFT FERRIED TO MEXICO BECAUSE NO SLIDE WAS AVAILABLE AT THE STATION. BARS AND FASTENERS WERE LUBRICATED AND ADJUSTED AND THE SLIDE WAS REPLACED IAW M
Back to JASC 2565