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 SWAA000810Slide · dischargedDURING SCHEDULED A1 CHECK, FOUND AFT ENTRY DOOR EVACUATION SLIDE PRESS INDICATOR LOW. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA000805Slide · dislodgedFWD ENTRY DOOR EVACUATION SLIDE CAME OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR AALA20000606Slide · deployedMIA - DURING OVERNIGHT MAINTENANCE, L1 ENTRY DOOR INADVERTENTLY DEPLOYED. SLIDE PARTIALLY DEPLOYED. REPLACED L1 DOOR SLIDE. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR MWEA00402Slide · looseAFT GALLEY SLIDE PULLED OUT OF CASE. MAINTENANCE REINSTALLED AFT GALLEY DOOR SLIDE.SDR SWAA000806Slide · dislodgedAFT SERVICE DOOR EVACUATION SLIDE PARTIALLY SEPARATED FROM CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR SWAA000800Slide · dislodgedAFT ENTRY DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. REINSTALLED SLICED ASSY PER MM.SDR TWAA0006702Slide · dischargedTHE ESCAPE SLIDE AT THE FORWARD LEFT CABIN DOOR LOST ITS PRESSURE. REPLACED THE SLIDE. CHECK-C 7-1-99 STL.SDR MWEA00379Slide · dislodgedAFTER LANDING IN MILWAUKEE, DURING TAXI AFT GALLEY DOOR SLIDE PACK FELL OUT FROM PLASTIC COVER. MAINTENANCE RESECURED AFT GALLEY SLIDE TO DOOR.SDR AU000379Slide · failed(AUS) DOOR 5R SLIDERAFT FAILED TO CORRECTLY INFLATE WHEN THE DOOR ONLYOPENED NINETY DEGREES. WHEN THE DOOR WAS MANUALLY OPENED THESLIDERAFT DEPLOYED CORRECTLY.SDR USAAF00032Slide · dischargedPHL - FOUND SLIDE PACK ON DOOR 1L APPEARING TO BE LOW. MAINTENANCE REPLACED FORWARD LEFT ENTRY DOOR ESCAPE SLIDE. CHECKS GOOD. (M)SDR MWEA00377Cover · dislodgedAFT GALLEY SLIDE COVER FELL OFF. MAINTENANCE REINSTALLED SLIDE COVER.SDR SWAA000770Slide · dischargedDURING SCHEDULED A1 CHECK, FOUND FWD SERVICE DOOR EVACUATION SLIDE PRESS INDICATOR LOW. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA000759Slide · dislodgedFWD ENTRY DOOR FELL OUT OF CONTAINER 3 TIMES, AT ONT FLT NR 1710, AT SMF FLT NR 1710 AND AT OAK FLT NR 1702. REINSTALLED SLIDE ASSY IN ALL THREE LOCATIONS PER MM.SDR SWAA000768Slide · dislodgedFWD ENTRY DOOR EVACUATION SLIDE COMING OUT OF CONTAINER. REINSTALLED SLIDE ASY PER MM.SDR SWAA000746Slide · dislodgedAFT ENTRY DOOR EVACUATION SLIDE FALLING OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR SWAA000743Slide · dislodgedDURING SCHEDULED C3 CHECK, FOUND FWD SERVICE DOOR EVACUATION SLIDE PRESSURE INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR MWEA00348Cable · disconnectedFOUND PIN, CONNECTING CABLE FROM GIRT BAR TO EMERGENCY EVACUATION SLIDE AT THE FORWARD ENTRY DOOR, CAME OUT. MAINTENANCE RE-INSTALLED PIN.SDR SWAA000736Slide · looseDURING SCHEDULED SPECIAL VISIT, FOUND FWD SERVICE DOOR EVACUATION SLIDE AFT GIRT BAR STOW BRACKET LOOSE AND RELEASE LATCH LOOSE. RESECURED BOTH ITEMS PER MM.SDR USAAD00059Slide · dischargedPHL - THE FORWARD SERVICE DOOR EMERGENCY EVACUATION SLIDE PRESSURE GAUGE INDICATED BELOW MINIMUMS. MAINTENANCE REPLACED THE FORWARD SERVICE DOOR EMERGENCY EVACUATION SLIDE. (M)SDR SWAA000724Girt Bar · out of adjDURING SCHEDULED C2 CHECK, FOUND FWD ENTRY DOOR EVACUATION SLIDE GIRT ASSY OUT OF ADJUSTMENT. REINSTALLED SLIDE ASSY PER MM.SDR CA000505026Slide · detached(CAN) FL 350, LIGHT TURBULENCE CREW HEARD A LOUD BANG FOLLOWED BY A WHISTLING SOUND FOR 20 MINUTES. UPON ARRIVAL THE LEFT HAND OVERWING ESCAPE SLIDE WAS MISSING. NEW SLIDE INSTALLED.SDR DL733000730Slide · deployedTHE R-1 DOOR SLIDE WAS INADVERTENTLY DEPLOYED. SLIDE INFLATED AND DEPLOYED CORRECTLY.SDR SWAA000723Slide · dislodgedFWD SERVICE DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR MWEA00342Slide · dislodgedFORWARD PASSENGER ENTRY DOOR EMERGENCY EVACUATION SLIDE COVER CAME DETACHED FROM CLIPS ON BOTTOM OF COVER. MAINTENANCE REINSTALLED SLIDE.SDR SWAA000709Girt Bar · out of adjDURING SCHEDULED C4 CHECK, FOUND BOTH FWD ENTRY AND SERVICE DOOR EVACUATION SLIDE GIRT ASSY OUT OF ADJUSTMENT. ADJUSTED BOTH GIRT ASSY PER MM.SDR SWAA000701Slide · dislodgedFWD ENTRY DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR MWEA00340Slide · overservicedAFT GALLEY SERVICE DOOR SLIDE PRESSURE GAGE SHOWS BOTTLE PRESSURE NEAR UPPER LIMITS. MAINTENANCE REMOVED AND REPLACED AFT GALLEY SLIDE WITH SERVICEABLE UNIT.SDR SWAA000697Indicator · out of positionDURING SCHEDULED C 2 CHECK, FOUND AFT ENTRY DOOR EVACUATION SLIDE PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA000694Slide · dislodgedFWD ENTRY DOOR EVACUATION SLIDE INDICATOR VIEWING GLASS BROKEN, LATER AT MDW THE SLIDE ASSY FELL OUT OF CONTAINER WHEN DOOR WAS CLOSING. R & R VIEWING GLASS AND REINSTALLED SLIDE ASSY PER MM.SDR SWAA000689Slide · dischargedDURING SCHEDULED C 3 CHECK, FOUND FWD SERVICE DOOR EVACUATION SLIDE PRESS INDICATOR LOW. R & R SLIDE ASSY PER MM.SDR SWAA000683Girt Bar · looseDURING SCHEDULED -C4- CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE GIRT BAR FLOOR ATTACH BRACKETS LOOSE. SECURED BRACKETS PER MM.SDR SWAA000681Slide · dislodgedFWD ENTRY DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR SWAA000680Indicator · dislodgedAFT SERVICE DOOR EVACUATION SLIDE PRESSURE INDICATOR OUT VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA000677Slide · dischargedDURING SCHEDULED SERVICE CHECK, FOUND FWD SERVICE DOOR EVACUATION SLIDE PRESSURE INDICATOR LOW. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA000676Indicator · dislodgedDURING SCHEDULED C2 CHECK, FOUND AFT ENTRY DOOR EVACUATION SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA000674Cable · out of positionDURING SCHEDULED -C3- CHECK, FOUND FWD ENTRY DOOR EVACUATION SLIDE RELEASE CABLE OUT OF POSITION. REPOSITIONED RELEASE ASSY PER MM.SDR ASAA0080240Slide · will not testOAK - DURING C-CHECK, THE TAILCONE EXIT EMERGENCY EVACUATION SLIDE FAILED THE EMERGENCY LIGHT AMP TEST. REPLACED THE TAILCONE EXIT EMERGENCY EVACUATION SLIDE ASSEMBLY. (X)SDR USAAD00048Slide · dischargedPHL - THE MAIN ENTRANCE DOOR EMERGENCY SLIDE INDICATED LOW PRESSURE. MAINTENANCE REPLACED THE EMERGENCY ESCAPE SLIDE. (M)SDR SWAA000667Girt Bar · out of adjDURING SCHEDULED C4 CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE GIRT OUT OF ADJUSTMENT. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA000662Handle · out of positionAFT SERVICE DOOR EVACUATION SLIDE RELEASE HANDLE OUT OF POSITION. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA000670Slide · dislodgedFWD SERVICE DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR MWEA00310Slide · dislodgedFOUND AFT GALLEY DOOR EMERGENCY EVACUATION SLIDE PACK DISLODGED FROM COVER. MAINTENANCE REINSTALLED SLIDE.SDR SWAA000654Girt Bar · wornDURING SCHEDULED C2 CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE GIRT ASSY WORN. R&R SLIDE ASSY PER MM.SDR SWAA000653Girt Bar · out of adjDURING SCHEDULED C2 CHECK, FOUND FWD SERVICE DOOR EVACUATION SLIDE GIRT ASSY OUT OF ADJUSTMENT. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA000652Lens · crackedDURING SCHEDULED C2 CHECK, FOUND FWD SERVICE DOOR EVACUATION SLIDE PRESSURE INDICATOR GLASS CRACKED. R&R SLIDE ASSY PER MM.SDR SWAA000641Slide · dischargedDURING SCHEDULED C3 CHECK, FOUND FWD SERVICE DOOR EVACUATION SLIDE PRESS IND LOW. R&R SLIDE ASSY PER MM.SDR SWAA000639Slide · dischargedDURING SCHEDULED SERVICE CHECK, FOUND FWD SERVICE DOOR EVACUATION SLIDE PRESSURE INDICATOR LOW. R&R SLIDE ASSY PER MM.SDR MWEA00309Slide · dislodgedFOUND FORWARD GALLEY DOOR EMERGENCY EVACUATION SLIDE DISLODGED FROM ITS COVER. MAINTENANCE REINSTALLED GALLEY DOOR SLIDE.SDR SWAA000617Slide · dischargedFWD SERVICE DOOR EVACUATION SLIDE COVER LOOSE AND PRESS INDICATOR LOW. R&R SLIDE ASSY AND SECURED COVER PER MM.SDR SWAA000629Indicator · out of positionDURING SCHEDULED C4 CHECK, FOUND AFT ENTRY DOOR EVACUATION SLIDE PRES IND OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.
Back to JASC 2565