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 AU010204Reservoir · discharged(AUS) NO5 LH MAIN ENTRY DOOR EMERGENCY ESCAPE SLIDE INFLATION RESERVOIR PRESSURE BELOW LIMITS.SDR SWAA010532Cover · looseAFT SVC DOOR EMERGENCY EVAC SLIDE COVER LOOSE. SECURED COVER ASSY PER MM.SDR SWAA010516Indicator · out of toleranceDURING SCHEDULED SERVICE CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS INDICATOR OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE ASSY PER MM.SDR SWAA010512Indicator · out of toleranceDURING SCHEDULED A2 CHECK, FOUND AFT ENTRY & SVC DOOR EMERGENCY EVAC SLIDE PRESS INDICATOR OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE ASSY''''S PER MM.SDR SWAA010511Indicator · out of toleranceDURING SCHEDULED SERVICE CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE PRESS INDICATOR OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE ASSY PER MM.SDR SWAA010509Slide · out of adjFWD SVC DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. RE-ADJUSTED EVAC SLIDE ASSY PER MM.SDR SWAA010507Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE OUT OF CONTAINER. REINSTALLED EVAC SLIDE ASSY PER MM.SDR SWAA010401Slide · out of positionDURING SCHEDULED SERVICE CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REMOVED AND REPLACED EVAC SLIDE ASSY PER MM.SDR SWAA010494Slide · out of positionDURING SCHEDULED BC4 CHECK, FOUND FWD ENTRY DOOR EVACUATION SLIDE OUT OF ADJUST. REINSTALLED SLIDE ASSY PER MM.SDR SWAA010492Slide · out of positionFWD ENTRY DOOR EVACUATION SLIDE FELL OUT OF CONTAINER DURING DOOR OPENING. LATER AT BHM, CONTAINER CAME LOOSE FROM DOOR. REINSTALLED SLIDE ASSY AND SECURED CONTAINER TO DOOR PER MM.SDR SWAA010490Slide · out of positionAFT ENTRY DOOR EVACUATION SLIDE PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR ASAA0180072Lanyard · disconnectedLAX - DURING PRE-FLIGHT CHECK, L1 DOOR EMERGNECY SLIDE LANYARD WAS FOUND TO BE DETACHED. REATTACHED LANYARD BETWEEN GIRT BAR AND SLIDE COVER. (M)SDR SWAA010482Slide · out of adjDURING SCHEDULED C1 CHECK, FOUND AFT SVC AND ENTRY DOOR EMERGENCY EVAC SLIDE ASSYS OUT OF ADJUST. RE-ADJUSTED EVAC SLIDE ASSYS PER MM.SDR SWAA010475Slide · out of toleranceDURING SCHEDULED SERVICE CHECK, FOUND AFT ENTRY DOOR EVACUATION SLIDE PRESS INDICATOR OUT OF LIMITS. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA010470Slide · out of positionDURING CLOSING OF FWD ENTRY DOOR, EVACUATION SLIDE FELL OUT OF BRACKET. SECURED SLIDE ASSY AND COVER PER MM.SDR SWAA010469Slide · out of positionAFT SERVICE DOOR EVACUATION SLIDE PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR MWEA010157Slide · dislodgedAFT GALLEY SERVICE DOOR FELL OUT. MAINTENANCE REINSTALLED AFT GALLEY DOOR SLIDE.SDR SWAA010468Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED EVAC SLIDE ASSY PER MM.SDR 0100585532Slide · failedDURING SLIDE SHOP TEST, INFLATABLE SUB ASSEMBLY RUPTURED DURING FLAT FIRE PROCEDURE AT NORMAL OPERATING PRESSURE. INFLATABLE SEAMS FAILED AT UPPER TUBE LEFT AND RIGHT. NEW INFLATABLE SUB ASSEMBLY WAS INSTALLED.SDR SWAA010456Slide · out of toleranceDURING SCHEDULED C4 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE PRESS INDICATOR OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE ASSY PER MM.SDR SWAA010442Cable · misroutedDURING SCHEDULED C3 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT CABLE MISROUTED. REPOSITIONED CABLE PER MM.SDR SWAA010441Slide · out of adjDURING SCHEDULED C3 CHECK, FOUND AFT SVC & ENTRY DOOR EMERGENCY EVAC SLIDE ASSY''S OUT OF ADJUST. RE-ADJUSTED EVAC SLIDE ASSY''S PER MM.SDR SWAA010439Slide · out of adjFWD ENTRY DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. RE-ADJUSTED EVAC SLIDE ASSY PER MM.SDR ASAA0180056Lanyard · disconnectedANC - DURING PREFLIGHT CHECK, L2 DOOR EMERGENCY SLIDE LANYARD WAS FOUND TO BE DETACHED. REATTACHED LANYARD BETWEEN GIRT BAR AND SLIDE COVER. (M)SDR SWAA010427Slide · out of adjDURING SCHEDULED C1 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE ASSY OUT OF ADJUST. RE-ADJUSTED EVAC SLIDE ASSY PER MM.SDR SWAA010416Slide · out of toleranceFWD ENTRY DOOR EMERGENCY EVAC SLIDE PRESS OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE ASSY PER MM.SDR ASAA0180062Harness · failedOAK - DURING C09 C-CHECK, R1 DOOR EMERGENCY SLIDE HARNESS FAILED THE AMPERAGE CHECK. REMOVED AND REPLACED SLIDE ASSEMBLY. AMPERAGE CHECKED OK. (M)SDR SWAA010412Slide · out of adjDURING SCHEDULED C2 CHECK, FOUND FWD ENTRY DOOR EMEGRENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. RE-ADJUSTED EVAC SLIDE ASSY PER MM.SDR SWAA010411Cover · looseDURING SCHEDULED C2 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY RETAINER HOOKS LOOSE. REMOVED AND REPLACED EVAC SLIDE COVER ASSY PER MM.SDR SWAA010389Slide · out of toleranceAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE ASSY PER MM.SDR 01FDEA00093Clip · bentDURING ROUTINE INSP, FWD ENTRY DOOR EMERGENCY EVACUATION SLIDE CONTAINER RELEASE SPRING CLIPS BENT. *S/D* REMOVED AND REPLACED PER IAW BAC 727 MM 25-60-013-4.SDR SWAA010384Slide · out of positionDURING SCHEDULED C3 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE ASSY PER MM.SDR SWAA010382Slide · out of toleranceDURING SCHEDULED A1 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE PRESS OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE ASSY PER MM.SDR SWAA010392Slide · out of positionDURING SCHEDULED C3 CHECK, FOUND AFT SVC AND ENTRY DOOR EMERGENCY EVAC SLIDE PRESS INDICATORS OUT OF VIEW. REPOSITIONED EVAC SLIDE ASSY''S PER MM.SDR SWAA010378Slide · out of adjDURING SCHEDULED C2 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. RE-ADJUSTED EVAC SLIDE ASSY PER MM.SDR SWAA010375Slide · tornDURING SCHEDULED C3 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY TORN AT FWD END. REMOVED AND REPLACED EVAC SLIDE ASSY PER MM.SDR AUS20010927Slide · failed(AUS) SLIDERAFT SEAL FAILED DURING INFLATION TEST. SEAL SEPARATION OCCURRED IN THE UPPER CHAMBER AT THE INTERSECTION OF THE UPPERAND SIDE TUBES. LENGTH OF TEAR 304.8MM (12IN). SLIDE HAD BEEN SENT TO WORKSHOP FOR REPAIR FOLLOWING AN INCIDENT WITH MOBILE STAIRS.SDR SWAA010352Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE ASSY PER MM.SDR SWAA010349Slide · out of positionAFT SVC AND ENTRY DOOR EMERGENCY EVAC SLIDE PRESS INDICATORS OUT OF VIEW. REPOSITIONED SLIDE ASSY''S PER MM.SDR SWAA010362Cover · looseDURING SCHEDULED C1 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE CONTAINER LOOSE. SECURED CONTAINER PER MM.SDR SWAA010361Slide · out of positionDURING SCHEDULED C1 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE ASSY PER MM.SDR SWAA010355Slide · out of positionDURING SCHEDULED C2 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE ASSY PER MM.SDR 2001UALA00075Slide · failedDOOR 4 LEFT SLIDE PRESSURE LIGHT ON. CHECK OF SLIDE PRESSURE WITH OHM METER SHOWS 0 WHICH IS A BAD SLIDE. *S/D* THE SLIDE FROM AC 3056 WAS ROBBED AND INSTALLED ON AC 3058. WHEN 3058 LATER RETURNED TO ORD, THE SLIDE WAS REMOVED, A SERVICEABLE SLIDE WAS INSTSDR SWAA010328Slide · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE ASSY PER MM.SDR UPS01234852Bottle · dischargedINSPECTION TYPE:IN, GALLEY SLIDE PRESS AT LOWER LIMIT. REMOVED AND REPLACED GALLEY SLIDE ASSY, PRESS GOOD.SDR CALA0100093Girt Bar · corrodedINSPECTION FOUND L-1 DOOR ESCAPE SLIDE FORWARD AND AFT GIRT BAR SUPPORTS CORRODED AT STA 312 AND STA 344. THE GIRT BAR SUPPORTS WERE REMOVED AND REPLACED IAW SRM 51-10-2.SDR SWAA010322Slide · out of positionDURING SCHEDULED C4 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE ASSY PER MM.SDR SWAA010321Mount · looseDURING SCHEDULED C4 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE CONTAINER FWD MOUNT LOOSE. SECURED EVAC SLIDE MOUNT PER MM.SDR SWAA010293Slide · out of positionAFT ENTRY AND SVC DOOR EMERGENCY EVAC SLIDE PRESS INDICATORS OUT OF VIEW. RE-ADJUSTED EVAC SLIDE ASSY PER MM.SDR SWAA010310Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE OUT OF HOLDER. REINSTALLED EVAC SLIDE PER MM.
Back to JASC 2565