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 SWAA030111Slide · out of adjustDURING SCHEDULED BC1 CHECK, FOUND R2 DOOR ESCAPE SLIDE OUT OF ADJUSTMENT. ADJUSTED ESCAPE SLIDE PER MM.SDR SWAA030103Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND THE R1 DOOR ESCAPE SLIDE OUT OF ADJUSTMENT. ADJUSTED THE R1 DOOR ESCAPE SLIDE PER M/M.SDR SWAA030100Slide · unserviceableFWD SERVICE DOOR EVACUATION SLIDE PRESSURE INDICATION LOW. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA030099Slide · out of positionFWD ENTRY DOOR EVACUATION SLIDE FELL OUT OF CONTAINER INADVERTENTLY. REINSTALLED SLIDE ASSY PER MM.SDR SWAA030098Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND AFT ENTRY DOOR EVACUATION SLIDE PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA030092Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND AFT ENTRY DOOR ESCAPE SLIDE OUT OF ADJUSTMENT. REPOSITIONED ESCAPE SLIDE PER M/M.SDR SWAA030078Slide · out of adjustAFT SERVICE DOOR EVACUATION SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR AWXA200300044Slide · deployedWHILE PARKED AT GATE AT IAD L-1 DOOR PARTIALLY DEPLOYED. L-1 DOOR ARM/DISARM LEVER WOULD NOT MOVE MORE THAN 1/2 AN INCH. DOOR INDICATED DISARMED ON ECAM BUT WAS ACTUALLY STILL ARMED. FLIGHT ATTENDANT OPENED DOOR BELIEVING DOOR WAS DISARMED WHEN SLIDE BEGAN DEPSDR ASAA0380066Lanyard · disconnectedSEA - DUIRNG PREFLIGHT CHECK, FOUND FORWARD SERVICE R-1 DOOR SLIDE LANYARD BETWEEN HAD BECOME DISCONNECTED. REATTACHED LANYARD. (M)SDR C1HA200382001Slide · dislodgedL2 DOOR SLIDE OUT OF CONTAINER. REINSTALLED L2 SLIDE IN CONTAINER IAW MM 26-60, OK FOR SERVICE.SDR AWXA200300026Slide · failedPHX - EMERGENCY EVACUATION - DURING INSPECTION THE FORWARD FLIGHT ATTENDANT PANEL EMERGENCY SYSTEM TEST FAILED FOR L-1 DOOR. MAINTENANCE REMOVED AND REPLACED DEFECTIVE L-1 DOOR SLIDE IAW T/C R1C25304, EMERGENCY SYSTEM TEST GOOD.SDR USAASA03003Slide · malfunctionedBOS - RECEIVED 'EPSU EXT LOAD FWD L' MESSAGE DURING THE EMERGENCY LIGHT TEST. MAINTENANCE REPLACED THE L1 DOOR ESCAPE SLIDE. OPERATIONALLY CHECKED OK. (M)SDR SWAA030060Cover · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE COVER FELL OFF. REINSTALLED COVER PER MM.SDR SWAA030059Slide · looseAFT SVC DOOR EMERGENCY EVAC SLIDE LOOSE IN CONTAINER. SECURED SLIDE PER MM.SDR SWAA030058Cable · misroutedDURING SCHEDULED C2 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED CABLE PER MM.SDR SWAA030057Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND BOTH FWD ENTRY AND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY'S OUT OF ADJUST. ADJUSTED SLIDES PER MM.SDR SWAA030041Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR ABXA030028Slide · damagedMAIN ENTRY DOOR L1 SLIDE DAMAGED. INSTALLED MAIN ENTRY DOOR EMERGENCY SLIDE IAW MM.SDR SWAA030032Slide · out of positionDURING SCHEDULED SERVICE CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA030042Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR AWXA200300015Bottle · dischargedFLIGHT CREW REPORTED A RED CAUTION LIGHT ON CIDS PANEL. MAINTENANCE PLACED LT OVERWING SLIDE ON MEL 25-60-05, COND. 2 SLIDE BOTTLE PRESSURE INOPERATIVE. SLIDE BOTTLE PRESSURE WAS VERIFIED IN THE GREEN AND AIRCRAFT DEPARTED AS SCHEDULED. UPON RETURN TO PHX MAINSDR SWAA030036Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA030044Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR GTIA030014Pin · dislodgedLGA - FLT 1865 - FOUND TAIL COMPARTMENT SLIDE COVER PINS OUT ON RIGHT SIDE AND HALF OUT ON LEFT SIDE. REINSTALLED TAIL COMPARTMENT SLIDE COVER PINS LEFT AND RIGHT SIDE. (M)SDR SWAA030003Cable · misroutedDURING SCHEDULED C2 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE RELEASE CABLE MISROUTED. REROUTED CABLE PER MM.SDR SWAA030002Slide · unserviceableAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA030001Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER WHEN OPENING DOOR. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA023049Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA023048Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA023045Slide · out of positionDURING SCHEDULED C1 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA023042Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA023039Slide · unserviceableDURING SCHEDULED PM CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA023035Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA023032Slide · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR 2003F00076Girt Bar · out of adjustL-1 DOOR WILL NOT DISARM FROM INSIDE THE AIRCRAFT. ADJUSTED GIRT BAR IAW MM. OPERATIONAL CHECK NORMAL.SDR SWAA023015Slide · out of positionDURING SCHEDULED SERVICE CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR GTIA021311Slide · out of positionFLT 945 - ACY - L1 SLIDE PACK FELL OUT ON TAXI. REINSTALLED L1 DOOR SLIDE PACK IAW MM 25-62-00. (M)SDR SWAA023021Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA023006Slide · out of positionDURING SCHEDULED RON, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR 2002F01123Lanyard · out of positionFLIGHT NR 155, PRIOR TO PUSHBACK RIGHT NR 1 DOOR SLIDE WOULD NOT ENGAGE. MAINTENANCE FOUND LANYARD IN GIRT BAR TRACK. REMOVED AND STOWED LANYARD, OPS CHECK GOOD.SDR ASAA0280666Lanyard · disconnectedLAS - DURING PREFLIGHT CHECK, R-1 DOOR EMERGENCY SLIDE LANYARD WAS FOUND TO BE DETACHED. REATTACHED LANYARD. (M)SDR USAASB02226Slide · twistedPIT - DURING ANNUAL OPERATIONAL CHECK OF THE FORWARD RIGHT SERVICE DOOR ESCAPE SLIDE, THE SLIDE TWISTED TO THE RIGHT WHILE INFLATING. MAINTENANCE WAS UNABLE TO REPOSITION SLIDE TO NORMAL POSITION UNTIL AFTER PARTIAL DEFLATION. SLIDE WAS UNUSABLE IF IN AN EMESDR SWAA022992Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA022983Cable · misroutedDURING SCHEDULED C3 CHECK, FOUND BOTH AFT CABIN DOOR EMERGENCY EVAC SLIDE RELEASE CABLES MISROUTED. REROUTED CABLES PER MM.SDR SWAA022978Slide · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR ASAA0280665Lanyard · disconnectedSJC - DURING PREFLIGHT CHECK, R-1 DOOR EMERGENCY SLIDE LANYARD WAS FOUND TO BE DETACHED. REATTACHED LANYARD. (M)SDR SWAA022986Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND ALL FOUR CABIN DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDES PER MM.SDR SWAA022981Slide · out of positionDURING SCHEDULED C1 CHECK, FOUND AFT ENTRY DOOR EMERGENCY SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA022970Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA022988Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.
Back to JASC 2565