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 SWAA992097Slide · looseFWD ENTRY DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. INSTALLED SLIDE ASSY PER MM.SDR ASAA9980331Bottle · dischargedPDX - DURING MAINTENANCE CHECK, THE TAILCONE EXIT EMERGENCY EVACUATION SLIDE INFLATION BOTTLE PRESSURE WAS FOUND LOW. REPLACED THE TAILCONE EXIT EMERGENCY EVACUATION SLIDE ASSEMBLY. (M)SDR MWEA99910Slide · looseFORWARD PASSENGER DOOR ESCAPE SLIDE PULLED FROM COVER. MTC REPACKED FORWARD DOOR SLIDE.SDR SWAA992077Slide · looseAFT SERVICE DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR DL767992832Battery · dischargedDURING SQUIB TEST, LT ESCQPE SLIDE DID NOT ILL WHILE PRESSING TEST 1 AND RT ESCAPE SLIDE DID NOT ILL WHILE PRESSING TEST 2. REPLACED LT OVERWING SLIDE POWER SUPPLY AND BATTERY. OPS CHECK NORMAL.SDR MWEA99907Cover · looseSLIDE ON GALLEY DOOR NEEDS TO BE REINSTALLED. MTC REINSTALLED SLIDE ON GALLEY DOOR.SDR SWAA992057Slide · dischargedAFT SERVICE DOOR EVACUATION SLIDE PRESS IND LOW. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR 99UAL900643Slide · deployedDOOR NR 2 RIGHT HAND SLIDE PACKAGE DEPLOYMENT CABLE SEVERED. *S/D* LATCH CABLE WAS FOUND FRAYED, NOT SEVERED. REPLACED SLIDE ASSY PER MAINTENANCE MANUAL.SDR SWAA992040Lens · looseAFT SERVICE DOOR EVACUATION SLIDE PRESSURE INDICATOR LENS LOOSE. SECURED LENS ASSY PER MM.SDR SWAA992042Slide · shiftedAFT ENTRY DOOR EVACUATON SLIDE PRESSURE INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA992039Slide · looseFWD SERVICE DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. INSTALLED SLIDE ASSY PER MM.SDR MWEA99897Slide · looseGALLEY DOOR SLIDE COVER LOOSE. MTC SECURED LOOSE SLIDE COVER.SDR DL733992709Slide · deployedWHILE REPOSITIONING A/C TO GATE FOR FIRST FLIGHT DEPARTURE, R1 SLIDE WAS INADVERTENTLY DEPLOYED DUE TO GIRT BAR APPARENTLY SHIFTED AND WHEN OPS ATTEMPTED TO BOARD A/C GIRT BAR GOT CAUGHT ON DOOR FRAME AND DEPLOYED WHEN DOOR WAS OPENED FULLY. MTC FERRY A/C TO SDR SWAA992033Cable · mislocatedDURING SCHEDULED C3 CHECK, FOUND AFT ENTRY AND SERVICE DOORS EVACUATION SLIDE RELEASE CABLES OUT OF POSITION. REROUTED CABLES PER MM.SDR AT9900890Slide · looseAFT CABIN DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. REPLACED L-2 DOOR EVACUATION SLIDE IAW MM 25-61 AND RES 99-9330.SDR SWAA992026Slide · looseFWD SERVICE DOOR EVACUATION SLIDE COMING OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR MWEA99870Slide · deployedCATERING INADVERTENTLY OPENED GALLEY DOOR BEFORE DISCONNECTING THE SLIDE, PULLING SLIDE AND SLIDE COVER PARTIALLY OUT. MTC REINSTALLED SLIDE AND SLIDE COVER.SDR SWAA992014Release Ring · damagedDURING SCHEDULED C2 CHECK, FOUND FWD SERVICE DOOR EVACUATION SLIDE RELEASE RING MISSING SOLDER. SOLDERED RING PER MM.SDR MWEA99869Slide · detachedGALLEY SERVICE DOOR EMERGENCY EVACUATION SLIDE CAME OFF DOOR. MAINTENANCE REINSTALLED SLIDE AND COVER.SDR SWAA992011Slide · dischargedDURING SCHEDULED SERVICE CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE PRESSURE INDICATOR LOW. REMOVED AND REPLACED SLIDE ASSY.SDR SWAA992003Slide · looseFWD ENTRY DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. INSTALLED SLIDE ASSY PER MM.SDR 99UAL900625Sensor · dirtyRETURNED TO EWR DUE TO EICAS WING SLIDE MESSAGE. LEFT OFF-WING SLIDE COMPARTMENT DOOR FOUND CLOSED. DOOR SENSOR S283T006-10 WAS FOUND TO BE DIRTY. SENSOR WAS CLEANED, AND TESTED GOOD.SDR 99UAL900628Light · inoperativeTHE 3L SLIDE PRESS TO TEST LIGHT INOP.SDR SWAA991999Slide · dischargedDURING SCHEDULED C1 CHECK, FOUND FWD ENTRY DOOR EVACUATION SLIDE PRESSURE INDICATOR LOW. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR MWEA99866Slide · looseTHE AFT GALLEY SIDE SLIDE COVER FELL OFF. MAINTENANCE REINSTALLED SLIDE COVER.SDR MWEA99861Slide · looseGALLEY SERVICE DOOR EMERGENCY ESCAPE SLIDE COVER WAS LOOSE AND DETACHED FROM BOTTOM OF DOOR. MAINTENANCE RE-ATTACHED SLIDE TO COVER.SDR SWAA991996Indicator · dislodgedFWD SERVICE DOOR EVACUATION SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA991977Indicator · dislodgedAFT ENTRY DOOR EVACUATION SLIDE PRESSURE INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR MWEA99850Slide · looseTHE FORWARD GALLEY DOOR EMERGENCY EVACUATION SLIDE CAME OUT OF ITS COVER. MAINTENANCE REINSTALLED SLIDE AND COVER.SDR SWAA991980Slide · tornDURING SCHEDULED SPECIAL VISIT FOUND, AFT ENTRY DOOR EVACUATION SLIDE GIRT ASSY TORN. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA991974Bracket · looseFWD SERVICE DOOR EVACUATION SLIDE GIRT BAR AFT MOUNT BRACKET LOOSE. REMOVED AND REPLACED BRACKET ASSY PER MM.SDR SWAA991965Indicator · dislodgedAFT SERVICE DOOR EVACUATION SLIDE PRESSURE INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR AT9900840Slide · looseFOUND L1 DOOR EMERGENCY SLIDE PACK LOOSE. SECURED L1 DOOR EMERGENCY SLIDE PACK IAW B737 MM 25-61.SDR SWAA991972Slide · looseFWD ENTRY DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR SWAA991970Slide · wornDURING SCHEDULED SERVICE CHECK, FOUND AFT ENTRY DOOR EVACUATION SLIDE GIRT VELCRO WORN. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR MWEA99849Slide · looseGALLEY SERVICE DOOR EMERGENCY ESCAPE SLIDE WAS DETACHED FROM HOUSING. MAINTENANCE REINSTALLED SLIDE.SDR DL76G992597Squib · failedDURING L/O CHECK, RT OVERWING SLIDE SQUIB FAILED TO TEST. DURING T/S SLIDE WAS BLOWN. A/C WAS FERRIED ON FLT 9933/24 TO REPLACE SLIDE AND WORK ON SQUIB SYS.SDR SWAA991953Indicator · movedAFT SERVICE DOOR EVACUATION SLIDE PRESSURE INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA991961Slide · looseFWD ENTRY DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. INSTALLED SLIDE ASSY PER MM.SDR SWAA991951Slide · looseAFT ENTRY DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. INSTALLED SLIDE ASSY PER MM.SDR SWAA991950Indicator · movedFWD SERVICE DOOR EVACUATION SLIDE PRESSURE INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA991943Slide · looseFWD ENTRY DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. INSTALLED SLIDE ASSY PER MM.SDR 2000ZZZM87Angle · out of adjustAFTER ARRIVING AT SFB AIRPORT AND PRIOR TO THE DISEMBARKATION OF PASSENGERS AN INADVERTENT DEPLOYMENT OF THE L-1 DOOR SLIDE OCCURRED. THE FLT ATTENDANT HAD OPENED THE L1 DOOR AND SECURED THE DOOR IN THE OPEN POSITION WHEN THE SLIDE PACK COVER FELL OFF. THIS SDR ASAA9980266Slide · will not testOAK - DURING C-CHECK, THE R1 DOOR EMERGENCY EVACUATION SLIDE FAILED THE EMERGENCY LIGHT AMP TEST. REPLACED THE R1 DOOR EMERGENCY EVACUATION SLIDE ASSEMBLY. (X)SDR SWAA991938Indicator · movedAFT ENRTY DOOR EVACUATION SLIDE PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA991936Slide · looseFWD ENTRY DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA991929Slide · out of viewAFT SERVICE DOOR EVACUATION SLIDE PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA991922Slide · ind out of viewAFT ENTRY DOOR EVACUATION SLIDE PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA991921Slides · saggingDURING SCHEDULED SERVICE CHECK, FOUND FWD ENTRY AND AFT SERVICE DOOR GIRT ASSY'S EXTENDING OUT OF LIMITS. ADJUSTED SLIDES PER MM.SDR SWAA991920Slides · saggingDURING SCHEDULED A1 CHECK, FOUND FWD SERVICE AND BOTH AFT DOOR EVACUATION SLIDE GIRT ASSY'S EXTENDING OUT OF LIMITS. ADJUSTED SLIDE ASSY'S PER MM.
Back to JASC 2565