N586US, cancelled Aug 13, 2007
Service difficulty reports · 98
Matched to this aircraft by N-number and event date, checked against the reported serial number, make and model. Newest first.
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 n_number = 'N586US' AND deregistration_id = 'N586US-2007-08-13' 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 n_number = 'N586US' AND deregistration_id = 'N586US-2007-08-13' 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 USAA010725Angle · crackedPIT - FOUND ANGLE CRACKED 1.5 INCH, BS 616 BELOW S17L. CUT OUT DAMAGE, INSTALLED FILLER AND DOUBLER PER TYPICAL REPAIR 53-62-01. (M)SDR USAA010727Angle · crackedPIT - FOUND ANGLE CRACKED .5 INCH, BS 454 AT OUTBOARD FLOOR PANEL SUPPORT ANGLE. MANUFACTURED NEW CLIP AND INSTALLED, HEAT TREAT. (M)SDR USAA010726Angle · crackedPIT - FOUND ANGLE CRACKED 1.5 INCHES, BS 616 BELOW STRINGER S17R. REMOVED DAMAGED, INSTALLED FILLER AND DOUBLER PER TYPICAL REPAIR 53-62-01. (M)SDR USAA010707Web · crackedPIT - FOUND WEB CRACKED .5 INCH, FORWARD PRESSURE BULKHEAD STATION 178. REPLACED WEB. (M)SDR USAA010701Frame · crackedPIT - FOUND FRAME CRACKED .5 INCH, BS 380 AT S8R. REMOVED DAMAGE, INSTALLED FILLER AND DOUBLER PER SRM 53-00-07 FIG 201. (M)SDR USAA010702FramePIT - FOUND INDICATION BY HFEC IS DOUBLE FLUSH RIVET, BS 380 AT S8L. CUT OUT DAMAGE, INSTALLED FILLERS AND DOUBLER PER SRM 53-00-07 PAGE 203-206. (M)SDR USAA010705Web · crackedPIT - FOUND WEB CRACKED .5 INCHES LONG, STATION 178 BULKHEAD ANTENNA MOUNT RIGHT. FILLER, DOUBLER, SHIMS PER SRM 53-10-08 FIG 211. (M)SDR USAA010706Web · crackedPIT - FOUND WEB CRACKED .25 INCH, BS 178 BULKHEAD LOWER LT ANTENNA MOUNT. FILLER, DOUBLERS, SHIMS PER SRM 53-10-08 FIG 211. (M)SDR USAA010703StringerPIT - FOUND STRINGER CUT TO FASCILITATE CLIP REMOVAL, BS 967 AT S25L. SPLICED STRINGER PER SRM 53-00-3. (M)SDR USAA010697Structure · corrodedPIT - FOUND CORROSION 1 INCH BY 6 INCH, LT WING 7211 OPENING. CORROSION LEVEL 1, TASK NR C53-300-01. CLEANED CORROSION, ROTO PEENED, TREATED PER SRM 57-20-01 PAGE 213-216. (M)SDR USAA010696Structure · corrodedPIT - FOUND CORROSION 1 INCH BY 4 INCH AREA, LT WING 7204L OPENING. CORROSION LEVEL 1, TASK NR C57-300-01. CLEANED CORROSION, ROTO PEENED, TREATED PER SRM 57-20-01 PAGES 213-216. (M)SDR USAA010695Structure · corrodedPIT - FOUND MATING SURFACE 1 INCH BY 3 INCH, LT WING 7213L OPENING. CORROSION LEVEL 1, TASK NR C57-300-01. CLEANED CORROSION, ROTO PEENED, TREATED PER SRM 57-20-01 PAGES 213-216.SDR USAA010693Structure · corrodedPIT - FOUND MATING SURFACE 1 INCH BY 4 INCH AREA OF CORROSION, LT WING 7202L OPENING. CORROSION LEVEL 1 TASK NR C57-300-01. CLEANED CORROSION, ROTO PEENED, TREATED PER SRM 57-20-01 PAGES 213-216. (M)SDR USAA010692Structure · corrodedPIT - FOUND MATING SURFACE CORRODED 1 INCH BY 5 INCH AREA, LT WING 7210L OPENING. CORROSION LEVEL 1, TASK NR C57-300-01. CLEANED CORROSION ROT PEENED, TREATED PER SRM 57-20-01 PAGES 213-216. (M)SDR USAA010689Web · corrodedPIT - FOUND WEB CORRODED 2 INCHES BY 3 INCHES, BS 947.5 TO 986.5, CORROSION LEVEL 1, TASK NR C53-202-01. REMOVED CORROSION, TREAT, PRIME, FABRICATE NEW SECTIONS AND INSTALLED. (M)SDR USAA0100690Structure · corrodedPIT - FOUND MATING SURFACE CORRODED, 1 INCH BY 6 INCH AREA, LEFT WING 7217L OPENING. CORROSION LEVEL 1, TASK NR C57-300-01. CLEANED CORROSION, ROTO PEENED, TREATED PER SRM 57-20-01, PAGES 213-216. (M)SDR USAA010691Structure · corrodedPIT - FOUND MATING SURFACE CORRODED 1 INCH BY 3 INCHES, LT WING 7214L. CORROSION LEVEL 1, TASK NR C57-300-01. CLEANED CORROSION, ROTO PEENED, TREATED PER SRM 57-20-01 PGS 213-216. (M)SDR USAA010687Seat Track · corrodedPIT - FOUND SEAT TRACK CORRODED 1 INCH BY 4 INCHES, LT INBOARD AFT OF BS 344. CORROSION LEVEL 1, TASK NR C53-107-01. CUT OUT DAMAGE, INSTALLED NEW AND SPLICE PER SRM 53-00-52, FIG 203. (M)SDR USAA010717Web · crackedPIT - FOUND WEB CRACKED .5 INCH, AT BL0 B5712 BELOW FLOORBEAM CAP, LEFT SIDE. INSTALLED REPAIR DOUBLERS PER EA 71067. (M)SDR USAA010719Frame · crackedPIT - FOUND FRAME CRACKED 1 INCH, BS 867 BETWEEN 58L-59L. INSTALLED DOUBLER PER T/R 53-10-14. (M)SDR USAA010720Angle · crackedPIT - FOUND ANGLE CRACKED 1 INCH, STATION 540 LEFT WING ROOT 2 INCHES ABOVE STRINGER. REMOVED DAMAGED AREA, INSTALLED FILLER, REPAIR ANGLE PER TR 53-50-03. (M)SDR USAA010721Angle · crackedPIT - FOUND ANGLE CRACKED 1 INCH, STATION 540 RIGHT WING ROOT 2 INCHES ABOVE STRINGER 22R. REMOVED DAMAGE, INSTALLED FILLER AND REPAIR ANGLE PER TR 53-50-03. (M)SDR USAA010722Skin · delaminatedPIT - FOUND WING LEADING EDGE DELAMINATED 6 INCHES BY 8 INCH AREA, LEFT WING LEADING EDGE AT STATION 559. REMOVED DAMAGED LAYERS, DRILLED OUT BRACKET FOR MOUSE TRAP PER SRM 51-70-17. (M)SDR USAA010698Angle · corrodedPIT - FOUND ANGLE PLATE ATTACH 2 INCHES BY 6 INCH, BETWEEN 767 AND 793 FORWARD SIDE OF AFT CARGO DOOR OPEN. CORROSION LEVEL 1, TASK C53-208-01. CLEANED CORROSION FROM ANGLE AND REPAIRED ANGLE PLATE PER SRM 51-21-21. (M)SDR USAA010593Frame · corrodedPIT - FOUND UPPER CHORD CORRODED 1 INCH BY 3 INCHES CORROSION, BS 967. CORROSION LEVEL 1, TASK NR C53-107-02. CLEAN/TREAT/PRIME AND INSTALL STRAP PER EA 70646 IAW SRM 53-00-51. (M)SDR USAA010592Frame · corrodedPIT - FOUND UPPER CHORD CORRODED 1 INCH BY 4 INCHES, BS 986.5. CORROSION LEVEL NR 1, TASK NR C53-107-02. CLEAN/TREAT/PRIME, ALSO CUT OUT DAMAGE SPLICE IN NEW STRUCTURE PER TYP REPAIR 53-60-01. (M)SDR USAA010591Floorbeam · corrodedPIT - FOUND FLOORBEAM CORRODED .5 INCH BY 1 FOOT, STATION 344 UNDER FLOORBOARD NR 8. SPLICED IN BEAM REPAIR. (M)SDR USAA010590Beam · corrodedPIT - FOUND BEAM CORRODED 4 AREAS 2 INCHES, SUPPORT FOR FLOORBOARD NR 6. CORROSION LEVEL 1, TASK NR 53-107-02. SPLICED IN BEAM SECTION THAT WAS BLENDED BEYOND LIMITS PER SRM 53-10-51. (M)SDR USAA010729Beam · crackedPIT - FOUND BEAM CRACKED .5 INCH, BL0 FLOORBEAM AT BS 712. MANUFACTURED AND INSTALLED FILLERS AND DOUBLER PER EA 71067 AND SRM 51-70-13. (M)SDR USAA010694Web · corrodedPIT - FOUND WEB PANEL CORRODED 1 INCH BY 10 INCHES, STATION 956.5 TO 967. CORRODED LEVEL 1, TASK NR C53-202-01. MFG WEB PANEL FROM STATION 947.5 TO 967 PER SRM 51-20-01/51-40-01/51-30-01/51-20-05. (M)SDR USAA010699Clip · corrodedPIT - FOUND SKIN CLIP CORRODED 1 INCH BY 4 INCH AREA EXFOLIATED, SKIN CLIP AFT SIDE STATION 967 STRINGER 25L AND 26L. CORROSION LEVEL 2, TASK NR C53-208-01. REMOVED AND REPLACED WITH SECTION OF NEW SKIN CLIP PER SRM 53-00-03. (M)SDR USAA010688Floorbeam · corrodedPIT - FOUND TOP FLANGE ENTIRE LENGTH OF FLOORBEAM CORRODED 1 INCH BY 2 INCHES, FLOORBEAM STATION 986.5. CORROSION LEVEL 1, TASK C53-107-02. TOP SECTION OF FLOORBEAM REPLACED ENTIRE LENGTH WITH BOEING KIT NR 6132505 PER TYPICAL REPAIR 53-60-01. (M)SDR USAA010700Angle · corrodedPIT - FOUND Z-ANGLE CORRODED 1 INCH BY 6 INCHES, AT DOOR SILL OF AFT ENTRANCE DOOR. CORROSION LEVEL 1, TASK NR C53-107-01. DEFECTIVE PART REPLACED WITH IDENTICAL PART NR. (M)SDR USAA010730Beltframe · crackedPIT - FOUND BELTFRAME CRACKED .25 INCH, STATION 633 S2L. INSTALLED DOUBLER PER 53-00-7 FIG 209. (M)SDR USAA010731Beam · crackedPIT - FOUND BEAM CRACKED 1 INCH, BS 867 BETWEEN S8L AND S9L. REMOVED DAMAGE, INSTALLED DOUBLER PER TYPICAL REPAIR 53-10-14. (M)SDR USAA010732Frame · crackedPIT - FOUND FRAME CRACKED .75 INCH, BS 867 BETWEEN S8R AND S9R. CUT OUT DAMAGE AND INSTALLED DOUBLER PER TYPICAL REPAIR 53-10-14. (M)SDR USAA010686Web · corrodedPIT - FOUND WEB PANEL CORRODED 12 INCHES BY 48 INCHES AT NUT PLATE, AFT CARGO DOOR WEB PLATE. CORROSION LEVEL 1, TASK C53-202-01. REMOVED CORRODED WEB PANEL AND REPLACED WITH NEW PANEL PER DRWG NR 65-47957. (M)SDR USAASB99019Windshield · crackedIND - FLT125 - AT FL350, THE CAPTAIN NOTICED AN AREA OF SEVERAL SMALL CRACKS IN THE OUTER PANE AT THE TOP CENTER OF THE FIRST OFFICERS FORWARD WINDSHIELD. QUICK REFERENCE HANDBOOK PROCEDURES WERE FOLLOWED. FLIGHT DIVERTED TO PIT AND LANDED WITHOUT FURTHER INSDR USAA980484Skin · crackedTPA - DURING CX-6 CHECK VISUAL INSPECTION VERIFIED BY EDDY CURRENT, FOUND A .125 INCH CRACK IN EXTERIOR SKIN STATION 380 BL 0. INSTALLED DOUBLER PER EA 62686 SB 737-53-1117 REV 2. (M)SDR USAASB98248Battery Pack · dischargedROC - MAINTENANCE FOUND SEVERAL EMERGENCY LIGHTS HAD FAILED AFTER 30 SECONDS OF OPERATION. MAINTENANCE REMOVED AND REPLACED DISCHARGED BATTERY PACKS IN POWER SUPPLIES M1133 AND M1137. OPERATIONAL CHECK. (M)SDR USAASB98211Light · inoperativePIT - MAINTENANCE FOUND THE FLOOR PROXIMITY EMERGENCY LIGHT AT SEAT ROW 5C INOP. MAINTENANCE REMOVED AND REPLACED THE BUTTON LIGHT COVER AT SEAT ROW 5C. OPERATIONAL CHECK GOOD. (M)SDR USAASB97308Battery Charger · failedSFO - MAINTENANCE FOUND THE EMERGENCY PATH EXIT LIGHT INOP. MAINTENANCE RELAMPED BULB WITH NO HELP. WIRES CHECKED GOOD FROM CHARGER ASSY TO BULB. REMOVED AND REPLACED BATTERY CHARGER ASSY. OPS CHECK GOOD. (M)SDR USAASB97231Pmc · failedALB - FL 749 - ON TAKEOFF, NR 2 ENGINE PERIODICALLY SURGED. CREW LEVELED OFF AT 4,000 FEET AND RETURNED TO FIELD AT ALB. A/C LANDED WITHOUT FURTHER INCIDENT. REPLACED NR 2 ENGINE POWER MANAGEMENT CONTROL PER MM 73-21-04. RAN ENGINE, OPS CHECKED OK IN ALL PSDR USAASB97194Battery Charger · failedTPA - FL 1425 - MAINTENANCE FOUND THE MID CABIN BULLNOSE EMERGENCY EXIT LIGHT ON THE RIGHT SIDE INOP. MAINTENANCE REMOVED AND REPLACED THE BATTERY CHARGER ASSEMBLY. OPERATIONAL CHECK GOOD. (M)SDR USAA970223Floor Beam · corrosionCLT - DURING Q-4 CHECK VISUAL INSPECTION, FOUND CORROSION AROUND CLIP-NUT HOLES STA 986 FLOOR BEAM. CORROSION LEVEL 2. STRAP REPAIR AS REQUIRED PER TYPICAL REPAIR DOCUMENT 53-10-01A. (X)SDR USAA970224Shear · crackedCLT - DURING Q-4 CHECK VISUAL INSPECTION, FOUND 2 INCH CRACK BS 616 AT CREASE BEAM INTERSECTION (RT) RBBL 70 CREASE BEAM SHEAR WEB. INSTALLED REPAIR SECTION SRM 51-10-12. (M)SDR USAASB97097Power Unit · inoperativePHL - DURING ANNUAL OPERATIONAL CHECK OF THE FORWARD MAIN ENTRY DOOR ESCAPE SLIDE, THE SLIDE DEPLOYED NORMALLY, BUT THE SLIDE MOUNTED LIGHTS FAILED TO ILLUMINATE. SLIDE OPERATIONAL CHECK FAILED. MAINTENANCE FOUND THE POWER UNIT ASSEMBLY FOR THE SLIDE MOUNTEDSDR USAASB96127Supply Duct · blownDEN - FLT 600 - DURING CRUISE, CREW REPORTED A FUSELAGE VIBRATION AT ROW 9 A, B, C. CAPTAIN CONTACTED MAINTENANCE CONTROL VIA ACARS AND TOGETHER THEY COULD NOT PINPOINT A CLEAR CAUSE OF THE VIBRATION. A DECISION WAS MADE TO DIVERT TO DEN WHERE THE FLIGHT LAN
Back to N586US, cancelled Aug 13, 2007