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 SWAA021097Slide · out of positionDURING SCHEDULED C2 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA021096Slide · out of positionDURING SCHEDULED C4 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA021094Cable · misroutedDURING SCHEDULED C3 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED CABLE PER MM.SDR SWAA021062Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR 0201683230Reservoir · brokenDURING 'L' CHECK, FOUND THE LEFT ESCAPE SLIDE CYLINDER CONTROL CABLE BROKEN. REPLACED THE LEFT ESCAPE SLIDE CYLINDER CONTROL CABLE RESERVOIR. OPERATIONAL CHECK GOOD.\N\N\NMANUFACTURER: AIRBUS\NMODEL: A319114SDR SWAA021044Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF THE CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA021065Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA021063Slide · frayedDURING SCHEDULED C4 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE GIRT BAR STRAP FRAYED. REPAIRED SLIDE PER MM.SDR SWAA021039Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER UPON ARRIVAL. REINSTALLED SLIDE PER MM.SDR AUS20020552Slide · faulty(AUS) DOOR 1L ESCAPE SLIDE LANYARD ATTACHMENT FROM BATTERY FIRING PIN FAULTY. SLIDE LIGHTING FAILED.SDR SWAA021045Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT OF THE CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA021058Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA021040Slide · deployedDURING SCHEDULED A1 CHECK, AFT SVC DOOR EMERGENCY EVAC SLIDE INADVERTENTLY DEPLOYED. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA021011Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA021010Bracket · looseFWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT BAR BRACKET LOOSE. SECURED BRACKET PER MM.SDR SWAA021008Slide · out of positionDURING SCHEDULED RON, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA021009Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA021007Fastener · looseDURING SCHEDULED BC2 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE CONTAINER UPPER FWD FASTENER LOOSE. REMOVED AND REPLACED EMERGENCY EVAC SLIDE CONTAINER FASTENER PER MM.SDR SWAA021000Slide · out of positionDURING SCHEDULED C4 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR ASAA0280170Lanyard · detachedSEA - DURING PREFLIGHT CHECK, L2 DOOR EMERGENCY SLIDE LANYARD WAS FOUND TO BE DETACHED. ATTACHED LANYARD. (M)SDR SWAA020973Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA020969Bracket · looseFWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT BAR BRACKET LOOSE. SECURED BRACKET PER MM.SDR SWAA020968Slide · out of positionDURING SCHEDULED C3 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA020965Fitting · corrodedDURING SCHEDULED D CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT BAR FWD FITTING CORRODED. REMOVED AND REPLACED GIRT BAR FITTING PER SRM.SDR SWAA020950Slide · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF THE CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA020934Slide · out of positionDURING SCHEDULED RON, FOUND BOTH AFT CABIN DOOR EMERGENCY EVAC SLIDE PRESS IND'S OUT OF VIEW. REPOSITIONED SLIDES PER MM.SDR SWAA020932Slide · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR AUS20020428Washer · misinstalled(AUS) LT ENTRY DOOR AND RT SERVICE DOOR EMERGENCY ESCAPE SYSTEM DEPLOYMENT BAR SEPARATION LINK WASHER INCORRECTLY POSITIONED IN RELATION TO THE CIRCLIP. FOUND DURING INSPECTION IAW AD/B767/163AND EI 767-025-0412. PERSONNEL/MAINTENANCE ERROR.SDR SWAA020939Slide · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA020938Bracket · looseFWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT BAR BRACKET LOOSE. SECURED BRACKET PER MM.SDR SWAA020931Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR AALA20020582Slide · malfunctionedMIA - FLT 68 - UPON ARRIVAL AT MIA, FORWARD ENTRY DOOR SLIDE PARTIALLY DEPLOYED AFTER DOOR OPENED. SLIDE WAS REMOVED FROM COMPARTMENT AND GIRT BAR BEFORE INFLATION OCCURRED. DOOR WAS DISARMED. INSPECTED SLIDE ARMING MECHANISM. OPERATION CHECKS GOOD. REPLASDR SWAA020922Slide · out of positionDURING SCHEDULED C3 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDR PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA020912Slide · out of adjustAFT ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA020907Slide · unserviceableDURING SCHEDULED SERVICE CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR GTIA020389Slide · unserviceableFLT 386 - R1 DOOR SLIDE PACK COMING UNPACKED. REMOVED AND REPLACED R1 EVACUATION SLIDE IAW MD 80. (M)SDR SWAA020911Slide · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF THE CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA020871Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA020878Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR USA2002F00004Cable · brokenFOUND OFFWING EMERGENCY ESCAPE SLIDE INFLATION RESERVOIR RELEASE CABLE END BROKEN OFF. MAINTENANCE REPLACED THE LEFT SIDE OFFWING ESCAPE SLIDE INFLATION RESERVOIR. OK FOR SERVICE.SDR DL757020482Reservoir · dischargedR1 DOOR HAD PARTIAL SLIDE DEPLOYMENT/ INSPECTED SLIDE NOT ACTIVATED. REINSTALLED SLIDE BACK ON DOOR PER MM. FOUND EMERGENCY POWER RESERVOIR EMPTY. INSTALLED AND RIGGED NEW RESERVOIR PER MM.SDR SWAA020863Slide · out of positionDURING SCHEDULED A1 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA020851Slide · unserviceableAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR 02042402Slide · bindingRight Wing escape slide failed to deploy for flight attendant training purposesl The metal bar that the lacing goes through caught on the lip of the slide compartment preventing the slide from deployiing completely. Cause of interference as yet undetermined buSDR 2002UALA00751Pipe · brokenDOOR 1R SLIDE-RAFT DEPLOYED AFTER PARKING AT GATE. SLIDE FELL ONTO JETWAY PREVENTING FULL DEPLOYMENT. THE FLIGHT ATTENDANT ROTATED DOOR HANDLE RATHER THAN ARM/DISARM LEVER CAUSING INADVERTENT DEPLOYMENT. SLIDE DEPLOYED, BUT DID NOT INFLATE. FURTHER INVESTISDR AWXA200200386Latch · out of adjustMCN - EMERGENCY EVACUATION - DURING C-16 CHECK THE L1 DOOR EMERGENCY ESCAPE SLIDE LATCH ASSEMBLY FAILED FUNCTIONAL TEST. MAINTENANCE TROUBLESHOT AND FOUND THE EMERGENCY ESCAPE SLIDE LATCH BRACKET OUT OF ADJUSTMENT; ADJUSTED LATCH BRACKET AND PERFORMED OPERATISDR AWXA200200378Latch · out of adjustMCN - EMERGENCY EVACUATION - DURING C-16 CHECK THE L2 DOOR EMERGENCY ESCAPE SLIDE LATCH ASSEMBLY FAILED FUNCTIONAL TEST. MAINTENANCE TROUBLESHOT AND FOUND THE EMERGENCY ESCAPE SLIDE LATCH BRACKET OUT OF ADJUSTMENT; ADJUSTED LATCH BRACKET PER BMM 25-61-35, PG SDR SWAA020841Slide · out of positionDURING SCHEDULED C3 CHECK, FOUND BOTH AFT CABIN DOOR EMERGENCY EVAC SLIDE PRESS IND'S OUT OF VIEW. REPOSITIONED SLIDES PER MM.SDR SWAA020840Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA020829Bracket · looseDURING SCHEDULED C1 CHECK, FOUND BOTH FWD CABIN DOOR EMERGENCY EVAC SLIDE GIRT BAR ATTACH BRACKET FASTENERS LOOSE. REMOVED AND REPLACED BRACKET FASTENERS PER SRM.
Back to JASC 2565