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 ASAA0180170Slide · out of positionSEA - DURING PRE-FLIGHT CHECK, FOUND R1 SLIDE PACK OFF DOOR. REINSTALLED SLIDE PACK IN DOOR SHROUD. (M)SDR ASAA0180171Harness · failedOAK - DURING C-CHECK, FOUND L1 DOOR EMERGENCY SLIDE HARNESS FAILED VOLTAGE CHECK. REPLACED L1 DOOR EMERGENCY SLIDE WITH SERVICEABLE SLIDE. (M)SDR USAAD01109Lanyard · deterioratedPHL - THE FORWARD SERVICE DOOR EVACUATION SLIDE LANYARD WAS DETERIORATED. MAINTENANCE REPLACED THE LANYARD ASSEMBLY. (M)SDR SWAA011468Slide · out of adjDURING SCHEDULED BC1 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED EMERGENCY EVAC SLIDE PER MM.SDR 0101845511Slide · failedEMERGENCY DOOR 3L ESCAPE SLIDE DID NOT DEPLOY WHEN DOOR WAS OPENED DURING DEPLOYMENT SAMPLING. THE SLIDE DID DEPLOY WHEN RESERVE HANDLE WAS PULLED. MAINTENANCE REPLACED DOOR 3L ESCAPE SLIDE ASSEMBLY.SDR SWAA011459Slide · out of positionDURING SCHEDULED C1 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EMERGENCY EVAC SLIDE PER MM.SDR SWAA011435Retainer · looseDURING SCHEDULED 1/4D CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT BAR HOOK LOOSE. SECURED GIRT BAR HOOK PER MM.SDR SWAA011433Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EMERGENCY EVAC SLIDE PER MM.SDR SWAA011432Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EMERGENCY EVAC SLIDE PER MM.SDR SWAA011431Slide · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EMERGENCY EVAC SLIDE PER MM.SDR SWAA011405Slide · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EMERGENCY EVAC SLIDE PER MM.SDR SWAA011430Slide · out of positionDURING SCHEDULED C2 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EMERGENCY EVAC SLIDE PER MM.SDR SWAA011413Slide · unserviceableDURING SCHEDULED SERVICE CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED EMERGENCY EVAC SLIDE PER MM.SDR SWAA011412Slide · unserviceableDURING SCHEDULED 1/4D CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED EMERGENCY EVAC SLIDE PER MM.SDR SWAA011409Slide · out of adjDURING SCHEDULE C2 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE OUT OF ADJUSTMENT. RE-ADJUSTED EMERGENCY EVAC SLIDE PER MM.SDR SWAA011397Slide · unserviceableAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA011384Slide · unserviceableDURING SCHEDULED C3 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED EMERGENCY EVAC SLIDE PER MM.SDR SWAA011381Slide · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF THE CASE. REINSTALLED SLIDE PER MM.SDR SWAA011378Slide · out of adjDURING SCHEDULED C3 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE OUT OF ADJUSTMENT. ADJUSTED SLIDE ASSY PER MM.SDR 2001UALA00939Slide · deployedRT OVERWING SLIDE DEPLOYED.SDR SWAA011380Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF THE CASE. REINSTALLED SLIDE PER MM.SDR SWAA011355Slide · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EMERGENCY EVAC SLIDE PER MM.SDR SWAA011354Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EMERGENCY EVAC SLIDE PER MM.SDR SWAA011353Slide · deployedFWD ENTRY DOOR EMERGENCY EVAC SLIDE INADVERTENTLY DEPLOYED. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA011352Slide · unserviceableAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED EMERGENCY EVAC SLIDE PER MM.SDR SWAA011344Slide · unserviceableAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. R&R EMERGENCY EVAC SLIDE PER MM.SDR SWAA011336Retainer · looseDURING SCHEDULED C1 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT BAR HOOK LOOSE. SECURED GIRT BAR HOOK PER MM.SDR SWAA011343Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF THE CASE. REINSTALLED SLIDE PER MM.SDR SWAA011342Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF THE CASE. REINSTALLED SLIDE PER MM.SDR SWAA011341Slide · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRES IND OUT OF VIEW. REPOSITIONED EMERGENCY EVAC SLIDE ASSY PER MM.SDR SWAA011335Retainer · looseDURING SCHEDULED C4 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT BAR HOOK LOOSE. SECURED GIRT BAR HOOK PER MM.SDR SWAA011334Retainer · looseDURING SCHEDULED C1 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT BAR HOOK LOOSE. SECURED GIRT BAR HOOK PER MM.SDR SWAA011333Retainer · looseDURING SCHEDULED C2 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT BAR HOOK LOOSE. SECURED GIRT BAR HOOK PER MM.SDR SWAA011325Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF THE CASE. REINSTALLED SLIDE PER MM.SDR SWAA011327Slide · out of positionDURING SCHEDULED C2 CHECK, FOUND AFT ENTRY & AFT SVC DOORS EMERGENCY EVAC SLIDES PRES IND OUT OF VIEW. REPOSITIONED EMERGENCY EVAC SLIDES PER MM.SDR SWAA011326Slide · unserviceableAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRES IND OUT OF LIMITS. R&R EMERGENCY EVAC SLIDE PER MM.SDR SWAA011312Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF THE CASE. REINSTALLED SLIDE IN CASE PER MM.SDR SWAA011315Slide · out of positionAFT ENTRY DOOR AND AFT SVC DOOR EMERGENCY EVAC SLIDES PRES IND OUT OF VIEW. REPOSITIONED EMERGENCY EVAC SLIDES PER MM.SDR SWAA011313Slide · unserviceableAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRES IND OUT OF LIMITS. R&R EMERGENCY EVAC SLIDE PER MM.SDR SWAA011309Retainer · looseDURING SCHEDULED C2 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT BAR HOOK LOOSE. SECURED GIRT BAR HOOK PER MM.SDR SWAA011307Retainer · looseDURING SCHEDULED C2 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT BAR HOOK LOOSE. RESECURED GIRT BAR HOOK PER MM.SDR SWAA011306Slide · out of positionDURING SCHEDULED C1 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRES IND OUT OF VIEW. REPOSITIONED EMERGENCY EVAC SLIDE ASSY PER MM.SDR SWAA011303Slide · out of positionDURING SCHEDULED C1 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRES IND OUT OF VIEW. REPOSITIONED EMERGENCY EVAC SLIDE ASSY PER MM.SDR SWAA011273Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRES IND OUT OF VIEW. REPOSITIONED EMERGENCY EVAC SLIDE ASSY PER MM.SDR SWAA011275Slide · unserviceableFWD SVC DOOR EMERGENCY EVAC SLIDE PRES IND OUT OF LIMITS. R&R EMERGENCY EVAC SLIDE PER MM.SDR SWAA011262Slide · unserviceableFWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. R&R EMERGENCY EVAC SLIDE PER MM.SDR SWAA011249Slide · unserviceableFWD ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. R&R EMERGENCY EVAC SLIDE PER MM.SDR USAAD01084Slide · unserviceableMCO - THE AFT SERVICE DOOR EVACUATION SLIDE INFLATION BOTTLE PRESSURE WAS LOW. MAINTENANCE REPLACED THE AFT SERVICE DOOR EVACUATION SLIDE. (M)SDR SWAA011251Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EMERGENCY EVAC SLIDE ASSY PER MM.SDR SWAA011248Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED EMERGENCY EVAC SLIDE PER MM.
Back to JASC 2565