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 SWAA031245Indicator · damagedFWD SVC DOOR EMERGENCY EVAC SLIDE PRESSURE INDICATOR OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR USAASA03060Girt Bar · damagedTHE FORWARD GALLEY SLIDE ARMING LEVER DOES NOT ARM SMOOTHLY, AND DOES NOT ALWAYS INDICATE ARMED. MAINTENANCE ADJUSTED THE FLAP ON THE GIRT BAR. OPERATIONALLY CHECKS OK. (M)SDR SWAA031248Indicator · out of positionDURING SCHEDULED C4 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA031228Indicator · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA031241Indicator · out of positionDURING SCHEDULED SPECIAL VISIT, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA031234Cable · misroutedDURING SCHEDULED C4 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED CABLE PER MM.SDR USAASA03059Slide · destroyedTHE RT FORWARD SLIDE FELL APART WHEN COVER WAS REMOVED. MAINTENANCE REPLACED THE ESCAPE SLIDE. OK FOR SERVICE. (M)SDR GTIA030414Bracket · damagedSLIDE PACK BRACKET ON R-1 DOOR WILL NOT HOLD SLIDE PACK GIRT BAR. REPOSITIONED AFT GIRT BAR HOOK ON R-1 SLIDE PACK. GIRT BAR OPERATION NORMAL. (M)SDR SWAA031212Girt Bar · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT BAR ATTACH FITTINGS (FWD AND AFT) CORRODED. REMOVED AND REPLACED BOTH ATTACH FITTINGS PER MM.SDR SWAA031197Girt Bar · out of adjustDURING SCHEDULED C2 CHECK, FOUND FWD ENTRY DOOR EVACUATION SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE ASSY PER MM.SDR SWAA031193Bottle · dischargedFWD ENTRY DOOR EVACUATION SLIDE PRESSURE INDICATION OUT OF LIMITS. REMOVED AND REPLACED FWD ENTRY DOOR SLIDE ASSY PER MM.SDR USAASA03056Bottle · dischargedTHE FORWARD SERVICE DOOR SLIDE PRESSURE WAS FOUND LOW. MAINTENANCE REPLACED THE R1 SLIDE. OK FOR SERVICE. (M)SDR USAASA03055Slide · damagedPHL - THE AFT RIGHT SLIDE WAS FOUND UNRAVELED DURING MAINTENANCE. MAINTENANCE REPLACED THE AFT RIGHT SLIDE. OK FOR SERVICE. (M)SDR SWAA031199Indicator · out of positionDURING SCHEDULED C3 CHECK, FOUND FWD ENTRY DOOR EVACUATION SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE ASSY PER MM.SDR SWAA031195Indicator · out of positionDURING SCHEDULED C4 CHECK, FOUND AFT ENTRY DOOR EVACUATION SLIDE PRESS INDICATOR OUT OF VIEW. ADJUSTED SLIDE ASSY PER MM.SDR SWAA031185Indicator · out of positionDURING SCHEDULED C4 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR CALA0300270Slide · dischargedINSPECTION FOUND THE R-1 DOOR SLIDE PRESSURE LOW. THE EMERGENCY DOOR SLIDE WAS REMOVED AND REPLACED IAW MM 25-62-00.SDR CA030528013Slide · deployed(CAN) LT O/H WING CHUTE WAS ACCIDENTALLY DEPLOYED BY FLT OPS DURING A TRAINING SESSION. THE CHUTE DID NOT DEPLOY COMPLETELY. THE LOWER SECTION OF THE CHUTE WAS PREVENTED FROM COMPLETE DEPLOYMENT BY THE IB SIDE. CONFIRMED, OPERATOR NEVER CHANGED OR REMOVED THISDR SWAA031173Indicator · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA031171Indicator · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA031187Cable · misroutedDURING SCHEDULED C2 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED CABLE PER MM.SDR USAASA03054Lanyard · cutTHE LEFT AFT DOOR SLIDE LANYARD WAS FOUND FRAYED AND CUT. MAINTENANCE REPLACED THE LEFT AFT SLIDE. OK FOR SERVICE. (M)SDR 2003UALA00399Fitting · separatedDOOR 3R GIRT BAR SHOE FITTING SEPARATED FROM GIRT BAR ASSEMBLY. REINSTALLED SHOE ASSY.SDR SWAA031159Cable · frayedDURING SCHEDULED C2 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE CABLE FRAYED. REMOVED AND REPLACED CABLE PER MM.SDR SWAA031174Indicator · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR USAASA03053Slide · damagedTHE LEFT AFT ENTRY DOOR SLIDE WAS FOUND TO BE UNRAVELING. MAINTENANCE REPLACED THE LEFT AFT ENTRY DOOR SLIDE OK FOR SERVICE. (M)SDR USAASA03052Slide · malfunctionedTHE LT FORWARD ENTRY DOOR SLIDE WILL NOT ARM. THE ARMING LEVER SPRINGS BACKUP AFTER ARMING. MAINTENANCE REMOVED, INSPECTED, THEN INSTALLED THE SAME SLIDE BACK ONTO THE LEFT FORWARD ENTRY DOOR. NO DEFECTS WERE NOTED. THE GIRT BAR AREA AT DOOR FRAME CORNERS SDR USAASA03051Slide · dislodgedTHE FORWARD LEFT ENTRY DOOR ESCAPE SLIDE/RAFT WAS FOUND SEPARATING FROM THE MOUNTING. MAINTENANCE REPLACED THE ESCAPE SLIDE. OK FOR SERVICE. THE REPAIR SHOP FOUND THAT THE SLIDE REQUIRED REPACKING. THE SLIDE WAS REPACKED AND RETURNED TO SERVICE. (M)SDR SWAA031162Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA031156Indicator · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA031144Bottle · dischargedDURING SCHEDULED PM CHECK, FOUND AFT ENTRY DOOR EVACUATION SLIDE PRESS IND LOW. REMOVED AND REPLACED EVACUATION SLIDE PER MM.SDR SWAA031158Indicator · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR USAASA03049Girt Bar · damagedBOS - DURING INSPECTION, THE L1 GIRT BAR WAS FOUND TO HAVE IMPROPER CLEARANCE WITH THE DOUBLER/STOP. MAINTENANCE REPLACED THE GIRT BAR. THE INSTALLATION WAS INSPECTED AND FOUND SERVICEABLE. (M)SDR SWAA031148Indicator · out of positionDURING SCHEDULED C4 CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE OUT OF ADJUST. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA031135Indicator · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA031133Indicator · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA031132Indicator · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR CALA0300261Carriage · looseTHE RT OFF WING ESCAPE SLIDE CARRIER FAILED TO OPERATE/DEPLOY DURING TEST. THE RT OFFWING SLIDE CARRIER OPERATING CRANK ASSEMBLY WAS FOUND TO HAVE EXCESSIVE PLAY. ALL PINS AND BEARINGS WERE REPLACED IN THE CRANK HANDLE IAW MM 25-65-00.SDR CALA0300260Slide · looseTHE RT OVERWING SLIDE PACK WAS FOUND UNLACED AT TOP DURING SYSTEM CHECK. THE SLIDE PACK WAS REPLACED IAW MM 25-65-00.SDR USAASA03046Girt Bar · failedBOS - DURING INSPECTION OF THE AFT RIGHT SLIDE/RAFT GIRT BAR, THE GIRT BAR WAS FOUND TO HAVE IMPROPER CLEARANCE BETWEEN THE DOUBLER/STOP AND THE GIRT BAR. MAINTENANCE REPLACED THE AFT RIGHT SLIDE/RAFT GIRT BAR. OK FOR SERVICE. (M)SDR SWAA031139Hook · brokenDURING SCHEDULED C1 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT BAR FWD RETAINER HOOK BROKEN. REMOVED AND REPLACED RETAINER HOOK PER MM.SDR SWAA031138Lens · missingDURING SCHEDULED C1 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND VIEWING WINDOW LENS MISSING. INSTALLED VIEWING WINDOW LENS PER MM.SDR SWAA031137Slide · looseDURING SCHEDULED C1 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE LOOSE IN CONTAINER. SECURED SLIDE PERE MM.SDR SWAA031134Indicator · out of limitsAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR 03FDEA00779Slide · failedWHILE PERFORMING W/C E65210-7-5000 PT 1 OPERATIONAL CHECK OF DOOR L1- DOOR SLIDE LACES FAILED. REMOVED AND REPLACED LT CREW/PAX ENTRY DOOR EMERGENCY EVACUATION SLIDE IAW A300600.SDR SWAA031128Indicator · out of limitsAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA031123Indicator · out of positionBOTH AFT CABIN DOOR EMERGENCY EVAC SLIDE PRESS IND'S OUT OF VIEW. REPOSITIONED AFT CABIN DOOR SLIDES PER MM.SDR SWAA031136Slide · dislodgedFWD ENTRY DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT OF THE CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA031126Hook · looseDURING SCHEDULED C3 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT BAR FWD RETAINER HOOK LOOSE. SECURED FWD RETAINER HOOK PER MM.SDR SWAA031125Cable · misroutedDURING SCHEDULED C3 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED CABLE PER MM.
Back to JASC 2565