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 SWAA000088Slide · looseFWD ENTRY DOOR EVACUATION SLIDE GIRT SKIRT HANGING DOWN. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA000090Slide · dislodgedDURING SCHEDULED RON, FOUND AFT SERVICE DOOR EVACUATION SLIDE PRESS IND OUT OF VIEW. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA000080Slide · dislodgedAFT ENTRY DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR SWAA000073Cable · misroutedDURING SCHEDULED C1 CHECK, FOUND AFT ENTRY DOOR EVACUATION SLIDE CABLE IMPROPERLY ROUTED. REROUTED CABLE PER MM.SDR SWAA000072Bracket · looseDURING SCHEDULED C1 CHECK, FOUND AFT SERVICE DOOR FWD GIRT BAR ATTACH BRACKET LOOSE. TIGHTENED BRACKET PER MM.SDR SWAA000066Girt Bar · out of adjustAFT SERVICE DOOR GIRT BAR DIFFICULT TO STOW. REPOSITIONED SLIDE LANYARD PER MM.SDR SWAA000068Slide · dislodgedFWD ENTRY DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR F3LA00003Battery · dischargedDEN - DURING C-3 CHECK INSPECTION, REPORTED AFT ENTRY DOOR ESCAPE SLIDE BATTERY FAILED BATTERY CHECK. MAINTENANCE REPLACED AFT ENTRY DOOR ESCAPE SLIDE. (M)SDR 20000427AP002Clip · brokenDURING PREFLIGHT, FOUND THE GALLEY DOOR SLIDE GIRT RETAINER BAR CLIP BROKEN. REPLACED GALLEY DOOR SLIDE GIRT BAR RETAINER. A/C RETURNED TO SERVICE. (M)SDR USAAD00008Slide · failedPIT - DURING AN EMERGENCY EVACUATION SLIDE FUNCTIONAL TEST, THE MAIN ENTRY DOOR SLIDE COVER LATCH FAILED TO RELEASE. MAINTENANCE ACTION PENDING. (X)SDR SWAA000057Slide · deployedDURING SCHEDULED SERVICE CHECK, FWD ENTRY DOOR EVACUATION SLIDE INADVERTENTLY DEPLOYED. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR MWEA00011Slide · dislodgedAFT GALLEY SERVICE DOOR EMERGENCY EVACUATION SLIDE DROPPED OUT OF CONTAINMENT PACKAGE. MAINTENANCE REINSTALLED SLIDE PACK.SDR MWEA00009Slide · dislodgedAFT GALLEY SERVICE DOOR PACK FELL OUT. MAINTENANCE REINSTALLED SLIDE PACK.SDR SWAA000038Slide · looseFWD ENTRY DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR SWAA000044Bracket · crackedDURING SCHEDULED C1 CHECK, FOUND AFT SERVICE DOOR FWD SLIDE SUPPORT BRACKET CRACKED. REMOVED AND REPLACED BRACKET PER MM.SDR MWEA00008Cover · dislodgedGALLEY SERVICE DOOR EMERGENCY EVACUATION SLIDE COVER FELL OFF. MAINTENANCE REINSTALLED SLIDE COVER.SDR 20000406SH060Slide · mismanufacturedGIRT ASSEMBLY WAS FABRICATED FROM AN UNKNOWN FABRIC AND IDENTIFIED WITH THE MANUFACTURER''S (BFG) P/N AND WITHOUT THE MANUFACTURER''S INSPECTION STAMP AND INSPECTION DATE. THIS PART IS BEING CONSIDERED AS A SUSPECTED UNAPPROVED PART SINCE IT DOES NOT MEET THESDR SWAA000036Slide · saggingDURING SCHEDULED C3 CHECK, FOUND AFT ENTRY DOOR EVACUATION SLIDE GIRT OUT OF POSITION. REINSTALLED SLIDE ASSY PER MM.SDR SWAA000034Clip · looseDURING SCHEDULED C1 CHECK, FOUND FWD ENTRY DOOR EVACUATION SLIDE GIRT BAR RETENSION CLIPS LOOSE. REMOVED AND REPLACED CLIPS FASTENERS PER MM.SDR AT0000012Slide · looseL-2 SLIDE KNOCKED OFF BY CATERING CART. RE-INSTALLED L-2 SLIDE.SDR AALA006014Slide · dislodgedLAS - FORWARD DOOR SLIDE PACK FELL OUT. INSPECTED AND REINSTALLED DOOR SLIDE ON LEFT FORWARD ENTRY DOOR. (M)SDR MWEA00004Cover · looseFORWARD ENTRY DOOR EMERGENCY SLIDE COVER CAME LOOSE WHEN OPENING DOOR IN MKE. MTC REINSTALLED FORWARD EMERGENCY DOOR SLIDE COVER.SDR USAASA00001Power Supply · failedLGA - FOUND RIGHT OVERWING SLIDE ARMED LIGHT STAYS ON AND ECAM SHOWS SLIDES AMBER. MAINTENANCE REPLACED THE RIGHT OVERWING EMERGENCY POWER SUPPLY UNIT. SLIDE ARMED LIGHT AND ECAM DISPLAY NORMAL. EMERGENCY POWER SUPPLY UNIT BITE CHECK OK. (M)SDR SWAA000012Battery Pack · dischargedDURING SCHEDULED SERVICE CHECK, FOUND AFT SERVICE EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA000011Slide · dischargedDURING SCHEDULED SERVICE CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE PRESS INDICATOR LOW. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR AALA006002Slide · dislodgedNRO - FORWARD GALLEY DOOR SLIDE FELL OUT. CONTAINER HOLDING IT SOMETIMES WOULD NOT LATCH SHUT. RE-INSTALLED FORWARD GALLEY DOOR SLIDE. OPS CHECK GOOD. (X)SDR SWAA000017Slide · looseFWD SERVICE DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR SWAA992151Slide · looseAFT SERVICE DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. INSTALLED SLIDE ASSY PER MM.SDR MWEA99916Slide Cover · detachedFORWARD ENTRY DOOR SLIDE COVER CAME OFF. MTC REINSTALLED ENTRY DOOR SLIDE COVER AS REQUIRED.SDR ASAA9980339Slide · will not testPHX - DURING 30K CHECK, THE L2 DOOR EMERGENCY EVACUATION SLIDE FAILED THE EMERGENCY LIGHT AMP TEST. REPLACED THE L2 DOOR EMERGENCY EVACUATION SLIDE ASSEMBLY. (M)SDR USAAD99188Slide · won't testPIT - THE TAILCONE EMERGENCY EVACUATION SLIDE FAILED TO AUTO DEPLOY, MANUAL DEPLOYMENT NORMAL. MAINTENANCE REPLACED THE TAILCONE EMERGENCY EVACUATION SLIDE. (M)SDR SWAA992144Indicator · movedDURING SCHEDULED C1 CHECK, FOUND AFT ENTRY DOOR EVACUATION SLIDE PRESSURE INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR UPS99831236Slide · inoperativeINSPECTION TYPE:N/A, L-1 DOOR EVAC SLIDE INOP REF M183941.SDR AWXA9900496Slide · deployedDOOR L-2 SLIDE PARTIALLY DEPLOYED. REMOVED AND REPLACED L-2 DOOR SLIDE.SDR USAAD99183Slide · dischargedATL - FOUND FORWARD ENTRY DOOR ESCAPE SLIDE PRESSURE BELOW MINIMUMS. MAINTENANCE REPLACED THE EMERGENCY ESCAPE SLIDE. (M)SDR USAAD99187Slide · malfunctionedPIT - THE AFT SERVICE DOOR EMERGENCY EVACUATION SLIDE FAILED TO INFLATE IN ALLOCATED TIME DUE TO DELAYED START OF INFLATION AFTER DOOR OPENING. MAINTENANCE REPLACED THE SLIDE ASSEMBLY. (M)SDR SWAA992133Slide · looseFWD ENTRY DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR MWEA99912Slide · dischargedGALLEY DOOR EVACUATION SLIDE PRESSURE LOW. MAINTENANCE REPLACED GALLEY DOOR EVACUATION SLIDE.SDR 20000424AP044Slide · deployedFLT 2312 - ORD - INADVERTENT DEPLOYMENT OF L-2 ESCAPE SLIDE. REPLACED L-2 ESCAPE SLIDE. (M)SDR USAAD99186Escape Slide · failedPIT - DURING ANNUAL OPERATIONAL CHECK OF THE AFT SERVICE DOOR ESCAPE SLIDE, THE ESCAPE SLIDE DID NOT INITIALLY INFLATE AS THE ESCAPE SLIDE HUNG ON GIRT BAR SEVERAL MINUTES UNTIL BEING JIGGLED, THEN INFLATED. ALSO, THE ESCAPE SLIDE MOUNTED EMERGENCY LIGHTS FAISDR SWAA992121Slide · looseFWD ENTRY DOOR EVACUATION SLIDE FALLING OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR UPS99831230Slide · looseLOAD SUPERVISOR OPENED MAIN ENTERANCE DOOR AND SLIDE FELL OUT. REINSTALLED EVAC SLIDE IAW MM 25-60-01 PG 202-204.SDR SWAA992127Indicator · movedAFT SERVICE DOOR EVACUATION SLIDE PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR AT9900903Slide · looseR-1 SLIDE NEEDS TO BE SECURED IN COMPARTMENT. REMOVED R-1 DOOR SLIDE AND RESECURED IAW 737 MM 25-61-30.SDR SWAA992115Slide · looseAFT ENTRY DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR GTIA9901236Slide · looseLGA - FLT 403 - GALLEY PACK SLIDE FELL OFF. RETURNED TO GATE ON LEG 2. REINSTALLED SLIDE PACK AND COVER IAW 25-62-00. (M)SDR SWAA992110Indicator · movedDURING SCHEDULED C3 CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE PRESSURE INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA992103Cable · misinstalledDURING SCHEDULED C1 CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE RELEASE CABLE OUT OF POSITION. RE-ROUTED CABLE PER MM.SDR SWAA992102Slide · looseFWD SERVICE DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR 2000ZZZX42Reservoir · wrong partEVACUATION SLIDE RECEIVED IN FOR REPAIR. INSPECTION REVEALED THE RESERVOIR INSTALLED IS NOT PER THE MFG (BFG) DRAWING, P/N 4A3192. THE RESERVOIR DOES NOT HAVE THE BF GOODRICH P/N 4A3192-4 IDENTIFIED ON THE RESERVOIR IDENTIFICATION LABEL. THIS RESERVOIR IS B
Back to JASC 2565