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 SWAA012476Slide · out of positionDURING SCHEDULED C1 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE PER MM.SDR UIEA01096Slide · failedDURING C-CHECK IN FRA, THE UPPER DECK SLIDE WOULD NOT DEPLOY DURING TEST. FOUND 2 RELEASE PINS ON THE PACK BOARD LOWER HORIZONTAL BAR NOT PULLED. THE RELEASE PINS WERE ROTATED AND CAUGHT ON THE EDGE OF THE RELEASE PIN CAUSING THEM TO GET CAUGHT IN THE OPENINSDR UPS01836761Bar · stuckINSPECTION TYPE:PFLT EVACUATION SLIDE BAR STUCK IN THE EVAC SLIDE, UNABLE TO ARM SLIDE. REPLACED EVAC SLIDE.SDR C1HA200193019Latch · out of adjNR 1 LEFT SLIDE NOT INTACT. KEEPS FALLING OUT. ADJUSTED LATCH AND RESECURED SLIDE IN CONTAINER IN ACCORDANCE WITH 25-60-15.SDR USAAD01157Lanyard · out of positionIND - THE TAIL CONE EVACUATION SLIDE COVER WAS NOT ATTACHED AT THE AFT HINGE POINTS AND THE MANUAL DEPLOY LANYARD WAS NOT ROUTED PROPERLY. MAINTENANCE ATTACHED THE TAIL CONE EVACUATION SLIDE COVER AND ROUTED THE MANUAL DEPLOY LANYARD PROPERLY. (M)SDR SWAA012480Slide · looseAFT ENTRY DOOR EMERGENCY EVAC SLIDE PARTIALLY PULLED FROM CONTAINER. REINSTALLED EVAC SLIDE PER MM.SDR SWAA012464Slide · out of positionDURING SCHEDULED C4 CHECK, FOUND BOTH AFT DOOR EMERGENCY EVAC SLIDES PRESS IND OUT OF VIEW. REPOSITIONED SLIDES PER MM.SDR SWAA012442Slide · out of adjDURING SCHEDULED C4 CHECK, FOUND EMERGENCY EVAC SLIDES OUT OF ADJUST AT BOTH GALLEY DOORS. ADJUSTED EVAC SLIDES PER MM.SDR C1HA200193018Latch · failed1L DOOR SLIDE NEEDS TO BE FIXED SO IT STAYS IN. BOX KEEPS FALLING OUT OF BOTTOM. REPLACED SLIDE LATCH ASSEMBLY. OPS CHECKS GOOD.SDR SWAA012463Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED EVAC SLIDE PER MM.SDR SWAA012465Slide · out of positionBOTH AFT DOOR EMERGENCY EVAC SLIDES PRESS IND OUT OF VIEW. REPOSITIONED SLIDES PER MM.SDR SWAA012452Slide · deployedDURING SCHEDULED RON, FWD SVC DOOR EMERGENCY EVAC SLIDE INADVERTENTLY DEPLOYED. R&R EVAC SLIDE PER MM.SDR USAAD01155Slide · failedPIT - THE AFT SERVICE DOOR EVACUATION SLIDE FAILED TO DEPLOY DURING A FUNCTIONAL TEST. MAINTENANCE REPLACED THE EVACUATION SLIDE. (M)SDR USAAD01156Slide · failedPIT - THE TAIL CONE EVACUATION SLIDE FAILED TO DEPLOY DURING A FUNCTIONAL TEST. MAINTENANCE REPLACED THE EVACUATION SLIDE. (M)SDR SWAA012469Fitting · looseDURING SCHEDULED 1/4D CHECK, FOUND BOTH ENTRY DOOR EVAC SLIDE GIRT BAR FLOOR ATTACH FITTINGS LOOSE. R&R ATTACH FITTING FASTENERS PER SRM.SDR GTIA010961Slide · improperFTW - TAILCONE EMERGENCY EVACUATION SLIDE PACKED IMPROPERLY. REMOVED TAILCONE EMERGENCY EVACUATION SLIDE, INSTALLED EMERGENCY EVACUATION SLIDE IAW MD-80 25-62-00. (M)SDR SWAA012421Slide · out of adjDURING SCHEDULED C4 CHECK, FOUND FWD SERVICE DOOR EVACUATION SLIDE OUT OF ADJUST. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA012399Slide · looseFWD SVC DOOR EMERGENCY EVAC SLIDE LOOSE. SECURED SLIDE PER MM.SDR SWAA012398Slide · unserviceableAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA012426Slide · looseFWD SVC DOOR EMERGENCY EVAC SLIDE LOOSE. SECURED EVAC SLIDE PER MM.SDR SWAA012473Bracket · corrodedDURING SCHEDULED D CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE FLOOR BRACKET CORRODED. R&R EVAC SLIDE FLOOR BRACKET PER SRM.SDR SWAA012403Slide · out of adjDURING SCHEDULED C2 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR AUS20010924Tube · corroded(AUS) OFF WING ESCAPE SLIDERAFT PNEUMATIC BALL LOCK TUBE CONNECTOR CORRODED AND END SEPARATED FROM THE BALL LOCK.SDR SWAA012373Slide · out of adjDURING SCHEDULED C2 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE OUT OF ADJUSTMENT. ADJUSTED SLIDE PER MM.SDR SWAA012372Slide · out of adjDURING SCHEDULED C2 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE OUT OF ADJUSTMENT. ADJUSTED SLIDE PER MM.SDR 2001UALA01766Plug · looseLEFT EMERGENCY ESCAPE SQUIB DID NOT TEST IN TEST 1. ALL TEST IN TEST 2. FOUND CANNON PLUG ON SQUIB LOOSE, REINSTALLED CANNON PLUG, AND PERFORMED SQUIB TEST. TESTED NORMAL IN BOTH LEFT AND RIGHT IN TEST 1 AND 2.SDR SWAA012355Slide · unserviceableDURING SCHEDULED RON, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA012354Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED EVAC SLIDE PER MM.SDR SWAA012348Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF THE CONTAINER. REINSTALLED EVAC SLIDE PER MM.SDR SWAA012331Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE PER MM.SDR MALA010654Slide · deployedON FLIGHT NR 3544, FWD LT SLIDE DEPLOYED. MAINTENANCE REPLACED FWD PAX DOOR EVAC SLIDE P/N D31050-105, S/N ON 1419 IAW AMM 25-60-11, OPS AND SECURITY CHECK GOOD.SDR ASAA0180245Lanyard · disconnectedSEA - DURING PRE-FLIGHT CHECK, R1 DOOR EMERGENCY SLIDE LANYARD ASSEMBLY LATCH WAS FOUND TO BE DETACHED FROM SLIDE COVER. REINSTALLED LATCH ON COVER. (M)SDR 2001UALA01767SwitchLEFT EMERGENCY ESCAPE SLIDE SQUIB TEST FAILED IN #1 TEST POSITION. CLEANED TEST SWITCH, SLIDE SQUIB CHECK OK.SDR SWAA012333Slide · out of positionDURING SCHEDULED C2 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE PER MM.SDR SWAA012332Slide · out of positionDURING SCHEDULED C2 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE PER MM.SDR SWAA012330Slide · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED EVAC SLIDE PER MM.SDR SWAA012309Slide · unserviceableAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR ASAA0180243Lanyard · disconnectedSEA - DURING PRE-FLIGHT CHECK, L-1 DOOR EMERGENCY SLIDE LANYARD WAS FOUND TO BE DETACHED FROM SLIDE COVER LATCH. REATTACHED LANYARD BETWEEN GIRT BAR AND DOOR SLIDE COVER LATCH. (M)SDR SWAA012273Slide · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED EVAC SLIDE PER MM.SDR SWAA012259Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. INSTALLED EVAC SLIDE PER MM.SDR SWAA012270Slide · out of positionDURING SCHEDULED SERVICE CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE PER MM.SDR SWAA012244Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE PER MM.SDR SWAA012242Slide · deployedAFT SVC DOOR EMERGENCY EVAC SLIDE FELL OUT AND DEPLOYED. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA012241Slide · out of positionDURING SCHEDULED C4 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE PER MM.SDR SWAA012245Girt Bar · out of positionDURING SCHEDULED C2 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUSTMENT. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA012243Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED EVAC SLIDE PER MM.SDR SWAA012238Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REINSTALLED EVAC SLIDE PER MM.SDR SWAA012232Slide · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED EVAC SLIDE PER MM.SDR SWAA012230Slide · out of positionDURING SCHEDULED C3 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE PER MM.SDR SWAA012228Slide · out of positionDURING SCHEDULED C1 CHECK, FOUND BOTH AFT CABIN DOOR EMERGENCY EVAC SLIDE PRESS INDICATORS OUT OF VIEW. REPOSITIONED BOTH EVAC SLIDES PER MM.
Back to JASC 2565