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 SWAA013403Slide · out of positionAFT ENTRY DOOR EVACUATION SLIDE PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA013401Slide · out of positionDURING SCHEDULED C4 CHECK, FOUND R2 DOOR EVACUATION SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA013397Slide · out of adjFWD ENTRY DOOR EVACUATION SLIDE OUT OF ADJUST. READJUSTED SLIDE ASSY PER MM.SDR AALA20012172Slide · defectiveATL - DURING OVERNIGHT MAINTENANCE, FORWARD GALLEY DOOR SLIDE PARTIALLY DEPLOYED. REPLACED FORWARD GALLEY DOOR SLIDE. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR SWAA013381Slide · unserviceableAFT SERVICE DOOR EVACUATION SLIDE PRESS INDICATOR LOW. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA013382Slide · out of adjDURING SCHEDULED C1 CHECK, FOUND FWD SERVICE DOOR EVACUATION SLIDE OUT OF ADJUST. ADJUSTED SLIDE ASSY PER MM.SDR SWAA013369Cable · out of positionDURING SCHEDULED C1 CHECK, FOUND FWD ENTRY DOOR EVACUATION SLIDE RELEASE CABLE OUT OF POSITION. REPOSITIONED CABLE PER MM.SDR SWAA013364Slide · out of positionDURING SCHEDULED C2 CHECK, FOUND BOTH AFT CABIN DOOR EVACUATION SLIDE PRESSURE INDICATORS OUT OF VIEW. REPOSITIONED BOTH SLIDE PER MM.SDR DLM88011949Lanyard · brokenL2 DOOR SLIDE LANYARD BROKEN. INSTALLED NEW LANYARD.SDR SWAA013351Slide · out of adjDURING SCHEDULED C2 CHECK, FOUND AFT ENTRY DOOR EVACUATION SLIDE PRESSURE INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA013340Slide · out of adjAFT SERVICE DOOR EVACUATION SLIDE OUT OF ADJUST. ADJUSTED SLIDE ASSY PER MM.SDR SWAA013352Slide · tornDURING SCHEDULED 1/4D CHECK, FOUND AFT ENTRY DOOR EVACUATION SLIDE GIRT ASSY TORN. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA013350Slide · unserviceableDURING SCHEDULED RON, FOUND AFT ENTRY DOOR EVACUATION SLIDE PRESS INDICATION LOW. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA013344Cable · frayedDURING SCHEDULED C1 CHECK, FOUND AFT ENTRY DOOR EVACUATION SLIDE CABLE FRAYED. REMOVED AND REPLACED CABLE PER MM.SDR SWAA013330Slide · deployedDURING SCHEDULED RON, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE INADVERTENTLY DEPLOYED. REMOVED AND REPLACED SLIDE PER MM.SDR DHL2001363027Slide · unserviceableESCAPE SLIDE PRESSURE GAUGE IS IN THE RED, NO GO. R&R ESCAPE SLIDE PER M/M 25-61-12.SDR SWAA013345Slide · out of adjDURING SCHEDULED BC3 CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE PRESS INDICATOR OUT OF VIEW. ADJUSTED SLIDE PER MM.SDR SWAA013329Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA013334Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA013321Slide · out of positionDURING SCHEDULED C2 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA013314Cable · misroutedFWD SVC DOOR EMERGENCY EVAC SLIDE GIRT BAR RETAINING CABLE IMPROPERLY ROUTED. REROUTED CABLE PER MM.SDR SWAA013313Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR AUS20011329Girt Bar · misinstalled(AUS) FORWARD ENTRY DOOR ESCAPE SLIDE GIRT BAR ATTACHED UPSIDE DOWN. PERSONNEL/MAINTENANCE ERROR.SDR SWAA013299Slide · deployedFWD ENTRY DOOR EMERGENCY EVAC SLIDE INADVERTENTLY DEPLOYED AT THE GATE. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA013298Slide · unserviceableFWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA013296Cable · misroutedAFT ENTRY DOOR EMERGENCY EVAC SLIDE GIRT BAR RETAINING CABLE IMPROPERLY ROUTED. REROUTED CABLE PER MM.SDR SWAA013336Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR DLM88011913Pin · pulledL1 DOOR SLIDE CABLE PINS PULLED. REPLACED SLIDE.SDR SWAA013294Slide · out of positionDURING SCHEDULED BC1 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR ASAA0180309Lanyard · disconnectedLAX - DURING PREFLIGHT CHECK, L-2 DOOR EMERGENCY SLIDE LANYARD WAS FOUND DETACHED FROM SLIDE COVER. REATTACHED LANYARD TO SLIDE COVER. (M)SDR SWAA013288Slide · unserviceableDURING SCHEDULED 1/4D CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA013279Slide · unserviceableAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA013278Slide · deployedFWD ENTRY DOOR EMERGENCY EVAC SLIDE INADVERTENTLY DEPLOYED UPON ARRIVAL. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA013255Slide · out of positionFWD ENTRY DOOR EVACUATION SLIDE FELL OUT OF CONTAINER INADVERTENTLY. RE INSTALLED SLIDE PER MM.SDR SWAA013265Slide · out of positionDURING SCHEDULED C1 CHECK, FOUND BOTH AFT CABIN DOOR EMERGENCY EVAC SLIDE PRESS INDICATORS OUT OF VIEW. REPOSITIONED SLIDES PER MM.SDR ASAA0180307Wire Harness · failedOAK - DURING C-CHECK, FORWARD SERVICE (R-1) DOOR EMERGENCY SLIDE HARNESS FAILED SYSTEM CHECK. REPLACED EMERGENCY SLIDE. SYSTEM CHECKED OK. (M)SDR SWAA013247Slide · out of positionDURING SCHEDULED C2 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA013244Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR ASAA0180305Lanyard · disconnectedSFO - DURING PRE-FLIGHT CHECK, L-1 DOOR EMERGENCY SLIDE LANYARD WAS FOUND DETACHED FROM SLIDE COVER. REATTACHED LANYARD TO SLIDE COVER. (M)SDR SWAA013222Slide · out of adjDURING SCHEDULED C3 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT OUT OF ADJUST. REPOSITIONED SLIDE PER MM.SDR USAABA01016Slide · malfunctionedPHL - DURING AN OPERATIONAL TEST OF THE R2 DOOR SLIDE, THE SLIDE DID NOT FREE ITSELF FROM THE SHELL AND DID NOT INFLATE AUTOMATICALLY. ONCE MAINTENANCE PERSONNEL JOSTLED THE SLIDE, THE SHELL FELL AWAY AND THE SLIDE INFLATED NORMALLY AND HELD PRESSURE. NO DEFSDR ASAA0180304Lanyard · disconnectedSEA - DURING PRE-FLIGHT CHECK, R-1 DOOR EMERGENCY SLIDE LANYARD WAS FOUND DETACHED FROM SLIDE COVER. REATTACHED LANYARD TO SLIDE COVER. (M)SDR AWXA200100608Slide · deployedSJC - GROUND DAMAGE - FLT 548 - "C" - WHILE AT GATE, ECAM DOOR PAGE DISPLAYED LEFT OVER WING EMERGENCY ESCAPE SLIDE NOT ARMED; MAINTENANCE WAS CALLED AND ALSO VERIFIED LEFT OVER WING EXIT LIGHT WAS NOT ILLUMINATED. WHILE ATTEMPTING TO RESET THE L/H OVER WING ESDR SWAA013212Slide · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA013211Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR UPS01237341Slide · unsecureINSPECTION TYPE:N/A ESCAPE SLIDE CAME OFF WHEN CREW CLOSED DOOR. SLIDE RE-INSTALLED NOTE: SLIDE DID NOT DEPLOY.SDR SWAA013195Slide · unserviceableAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA013184Slide · unserviceableDURING SCHEDULED SERVICE CHECK, FOUND FWD SERVICE DOOR EVACUATION SLIDE PRESS IND LOW. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA013182Slide · out of adjAFT SERVICE DOOR EVACUATION SLIDE OUT OF ADJUST. ADJUSTED SLIDE ASSY PER MM.SDR SWAA013186Clip · looseDURING SCHEDULED C1 CHECK, FOUND BOTH FWD DOOR EVACUATION SLIDE GIRT BARS CLIP HOOKS LOOSE. SECURED BOTH CLIP HOOKS PER MM.
Back to JASC 2565