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 AALA20030705Slide · deployedFORWARD ENTRY ESCAPE SLIDE PARTIALLY DEPLOYED WHEN THE DOOR WAS OPENED, DID NOT INFLATE. GIRT BAR FELL OUT AS DOOR WAS BEING OPENED. REPLACED FORWARD ENTRY ESCAPE SLIDE. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR SWAA031420Indicator · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA031419Indicator · out of limitsAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR ZW0A0305501Slide · dislodgedAFTER CHECK-C AND DURING A MINI CABIN EVACUATION DEMONSTRATION THE ESCAPE SLIDE AT THE RIGHT SIDE NUMBER 2 DOOR DID NOT INFLATE BUT FELL TO THE FLOOR. THE GIRT BAR WAS WITH THE SLIDE.SDR ZW0A0305502Slide · deployedAFTER CHECK-C AND DURING A MINI CABIN EVACUATION THE ESCAPE SLIDE AT THE LEFT SIDE NUMBER 4 CABIN DOOR DEPLOYED AND INFLATED, BUT FELL TO THE GROUND. THE GIRT BAR WAS WITH THE SLIDE.SDR USAABA03020Aspirator · crushedCLT - SHOP FOUND THE SLIDE ASPIRATOR CRUSHED DURING INSPECTION. MAINTENANCE REPLACED THE ASPIRATOR. DAMAGE TO THE ASPIRATOR IS ATTRIBUTED TO ORIGINAL PACKING AT THE FACTORY. (M)SDR GTIA030484Lanyard · brokenR1 SLIDE PACK BROKEN. RESECURED LANYARD ON R1 DOOR SLIDE PACK. NO DEFECTS NOTED AT THIS TIME. (M)SDR USAASA03069Slide · malfunctionedNO EMERGENCY LIGHTS DID NOT ILLUMINATE ON THE AFT RIGHT SLIDE WHEN THE SLIDE WAS DEPLOYED FOR AN OPERATIONAL CHECK. MAINTENANCE REPLACED THE ESCAPE SLIDE. OPERATIONALLY CHECKED EMERGENCY LIGHTS SYSTEM. OK FOR SERVICE. (M)SDR SWAA031403Indicator · out of positionDURING SCHEDULED SERVICE CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA031384Indicator · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE PRESSURE INDICATOR OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA031390Fitting · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE FWD AND AFT GIRT BAR ATTACH FITTINGS CORRODED. REMOVED AND REPLACED ATTACH FITTINGS PER SRM.SDR SWAA031387Container · looseDURING SCHEDULED C4 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE CONTAINER LOOSE. SECURED CONTAINER PER MM.SDR SWAA031386Girt Bar · out of adjustDURING SCHEDULED C4 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA031385Cable · misroutedDURING SCHEDULED C4 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED CABLE PER MM.SDR SWAA031374Slide · dislodgedAFT SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA031379Indicator · out of positionDURING SCHEDULED C3 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA031375Slide · dislodgedFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR AWXA200300720Girt Bar · damagedFLIGHT CREW REPORTED THE L-4 DOOR SLIDE ARMING HANDLE JAMS, DOOR EVACUATION SLIDE ARMING LEVER DIFFICULT TO POSITION TO ENGAGE POSITION. MAINTENANCE FOUND GIRT BAR FORWARD TANG BROKEN, REMOVED AND REPLACED L-4 DOOR SLIDE ASSEMBLY IAW T/C R1C25602, OPERATIONAL SDR AUS20030634Slide · failed(AUS) DOOR NR 1 RT SLIDE RAFT FAILED.SDR SWAA031366Indicator · out of positionDURING SCHEDULED C4 CHECK, FOUND BOTH AFT CABIN DOOR EMERGENCY EVAC SLIDE PRESS IND'S OUT OF VIEW. REPOSITIONED SLIDES PER MM.SDR WRLA200315Slide · malfunctionedDURING A FUNCTIONAL CHECK OF RT FORWARD DOOR SLIDE ASSY (R1) DOOR FAILED TO OPEN TO ITS FULL TRAVEL. DOOR PNEUMATIC ACCUMULATOR BOTTLE NOTED TO HAVE BEEN AT LOW SIDE OF ITS GREEN SERVICING INDICATION BAND. THE DOOR WAS CLOSED AND THE DOOR PNEUMATIC ACCUMULATSDR SWAA031347Slide · dislodgedDURING SCHEDULED RON, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REMOVED AND REPLACED SLIDE PER MM.SDR USAASA03064Bottle · reads lowA CABIN INTERCOMMUNICATION DATA SYSTEM RED LIGHT ILLUMINATED FOR THE MID RIGHT SERVICE DOOR ESCAPE SLIDE INFLATION RESERVOIR. MAINTENANCE REPLACED THE MID RIGHT SERVICE DOOR ESCAPE SLIDE INFLATION RESERVOIR. BITE CHECKED OK. (M)SDR USAASA03065Slide · looseTHE LEFT MID ENTRY DOOR SLIDE COVER WAS FOUND LOOSE. MAINTENANCE FOUND THE SLIDE PACK SAGGING, AND HOLDING THE BUSTLE AWAY FROM LATCH. REPLACED THE SLIDE PACK AND ADJUSTED THE SLIDE COVER. OK FOR SERVICE. (M)SDR AWXA200300697Slide · tornDURING C-04 CHECK FOUND THE R-2 DOOR SLIDE LACING TORN. MAINTENANCE REMOVED AND REPLACED THE R-2 DOOR SLIDE IAW T/C R1C25304MT-82.SDR AMTA200300773Container · looseFOUND DOOR L2 SLIDE CONTAINER LOOSE. SECURED 2L DOOR CONTAINER. OK FOR SERVICE. (M)SDR SWAA031330Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR UPS03140850Light · inoperativeREF M26073 EVAC SLIDE WARNING LIGHT INOP. PERFORMED TEST P/N ASPCU TEST OK, WARNING LIGHT RESET OK THIS CLEARS M260973.SDR USAASA03061Slide · malfunctionedTHE DIRECTIONAL GUIDANCE LIGHTS DID NOT WORK DURING OPERATIONAL TEST OF AFT RIGHT SERVICE DOOR ESCAPE SLIDE. MAINTENANCE REPLACED THE AFT RIGHT SERVICE DOOR ESCAPE SLIDE. OPERATIONALLY CHECKS OK. (M)SDR AMTA200300769Cover · dislodgedFOUND R-1 DOOR SLIDE FALLING OUT OF COVER. RESTOWED SLIDE IN COVER, OK FOR FLIGHT. (M)SDR SWAA031326Slide · out of positionDURING SCHEDULED C3 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE OUT OF POSITION AND CABLE MISROUTED. REPOSITIONED SLIDE AND REROUTED CABLE PER MM.SDR SWAA031317Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA031316Slide · out of positionDURING SCHEDULED C4 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA031315Slide · out of positionDURING SCHEDULED C4 CHECK, FOUND BOTH AFT CABIN DOOR EMERGENCY EVAC SLIDE PRESS IND'S OUT OF VIEW. REPOSITIONED SLIDES PER MM.SDR SWAA031313Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA031312Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA031305Slide · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE GIRT BAR ASSY OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR SWAA031304Slide · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA031320Slide · out of positionDURING SCHEDULED C4 CHECK, FOUND BOTH AFT CABIN DOOR EMERGENCY EVAC SLIDE PRESS IND'S OUT OF VIEW. REPOSITIONED SLIDES PER MM.SDR SWAA031301Cable · misroutedDURING SCHEDULED C2 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED CABLE PER MM.SDR SWAA031300Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR AWXA200300679Slide · leakingFLIGHT CREW REPORTED R-2 DOOR SLIDE PRESSURE INDICATOR NOT IN THE GREEN AREA. MAINTENANCE REMOVED AND REPLACED R-2 DOOR SLIDE IAW T/C R1C25304, OPERATIONAL CHECK WAS GOOD.SDR SWAA031291Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND BOTH FWD CABIN DOOR EMERGENCY EVAC SLIDE GIRT ASSY'S OUT OF ADJUST. ADJUSTED SLIDES PER MM.SDR SWAA031288Slide · unserviceableDURING SCHEDULED RON, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR DLM88030526Slide · unserviceableL2 SLIDE FEEL OUT OF DOOR WHEN DOOR WAS OPENED. FOUND SLIDE STILL ARMED INFLATED WHILE HANGING BUT DID NOT OPEN. REPLACED SLIDE PER MM.SDR SWAA031284Slide · unserviceableDURING SCHEDULED SPECIAL VISIT, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA031268Slide · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA031259Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR AWXA200300670Slide · faultyDOOR EMERGENCY ESCAPE SLIDE ARM LIGHT IS INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE R-1 DOOR EMERGENCY ESCAPE SLIDE IAW T/C R1C25304, OPERATIONAL CHECK WAS GOOD.SDR GTIA030415Slide · dislodgedDTW - FLT 461 - L1 SLIDE FELL OFF NOW IN SPIRIT PLUS. INSTALLED L1 SLIDE. (M)
Back to JASC 2565