JASC 5310
Service difficulty reports · 38,573
Reports filed under 5310 · Fuselage Main, Structure, 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 jasc_code = '5310' 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 = '5310' 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 CA951116004Tail Post · broken(CAN)TAIL POST BROKEN COMPLETELY THROUGH AT A LOCATION JUST BELOW THE RUDDER STOP PIN. SUBMITTER BELIEVES THAT THE TYPE OF OPERATION MAY HAVE CONTRIBUTED TO THE FAILURE - GLIDER TOW PLANE.SDR 9516229608Fitting · corrodedDURING D-CHECK, FOUND CORROSION ON THE JACK SUPPORT FITTING. REPLACED FITTING PER SRM 51-01 AND DWG 59-17491. DUE TO INCORRECT AIRCRAFT NUMBER, ALL OTHER REFERENCES; MODEL NUMBER, SERIAL NUMBER, ETC HAVE BEEN CHANGED RESPECTIVELY.SDR 95FDEA01443Frame · corrodedCORROSION FOUND ON BS 740 FRAME AT LBL 3. DISCOVERED ADDITIOINAL CORROSION FROM STR 1L - 3L. MECHANICALLY REMOVED CORROSION FROM FRAME FLANGE. CUT OUT DAMAGED SKIN AT BS 742, LBL 3. REPAIRED FRAME AND SKIN PER FEDEX EA NR 7-5310-25835.SDR 96ZZZX1857Structure · corrodedDURING C- AND D-CHECKS, FOUND INTERCOSTAL, SKIN, AND LONGERON CORRODED AT AFT CARGO COMPARTMENT LONGERON 29R. REPAIRED IAW DC9 SRM CH 53. AIRCRAFT TT: 51,653. AIRCRAFT TC: 57,610.SDR AALA951687Deck Plate · corrodedAFW - DECK PLATE AT STA 1680 AND STA 1720 HAS CORROSION REMOVED ON UPPER SURFACE AT VARIOUS BL LOCATIONS. MATERIAL REMAINING IS BEYOND SRM ALLOWABLE LIMITS. REPAIRED PER MRB 757-602. TST, 15,867.21 HRS. CYCLES, 5,989. (X)SDR DLM88953442Structure · damagedA/C DAMAGED BY RAMP PERSONNEL RT SIDE 2 FT FWD OF WATER SERVICE PANEL 8 INCHES BELOW FLOOR LINE. REPAIRED PER SRM 53-04 PG 218A.SDR P5CA9500361Structure · damagedCRACK AND DENTS IN THE FLOOR COVER SHEET METAL BETWEEN BS 1780 AND BS 1800, LBL 45 AND LBL 35. REPAIRED PER BOEING SRM 53-10-23.SDR P5CA9500359Structure · damagedCRACK AND BEND IN FLOOR RIB, GOUGE, AND HIT IN FLOOR COVER SHEET METAL BETWEEN BS 1760 AND BS 1780, RBL 25 AND RBL 45. REPAIRED PER BOEING SRM 51-40-03.SDR UPS203361Frame · crackedWHILE IN SI CHECK, MAINTENANCE FOUND CRACK IN FRAME ABOVE SHEAR TIE BS 1166 BETWEEN STRINGER 29 RT AND 30 RT. REMOVED AND INSTALLED NEW FRAME IAW SRM 51-10-1, 51-20-1, 53-10-1.SDR 95ZZZX4160Structure · corrodedDURING A C-CHECK INSPECTION, FOUND SEVERAL STRINGERS AND DOUBLERS CORRODED IN LOWER BELLY AREA FROM STA 320 - STA 360. INTERNAL DOUBLER CORRODED ON SKIN PANEL STA 351 TO STA 360, STR 27L TO STR 27R. STRINGER SEGMENT CORRODED STA 351 TO STR 360, STR 26R. FRAMSDR UPS202945Press Box · corrodedWHILE IN 'C' CHECK, MAINTENANCE FOUND CORROSION ON RT PRESSURE BOX AT BS 740-758. REPLACED PRESS BOX SKIN PER SRM 53-10-1, 51-20-1, 51-10-2.SDR 95ZZZX2256Fuselage · bird strikeBIRD STRIKE ON APPROACH AT 4000 AGL. BIRD STRUCK FUSELAGE LEFT SIDE, FORWARD OF LEFT NOSE BAGGAGE DOOR. NOSE BAGGAGE DOOR BENT OPEN AND BIRD ENTERED BAGGAGE AREA. AIRCRAFT INSPECTED AND NOSE DOOR SECURED FOR FERRY FLIGHT TO MSP. TTAF 20485.8. TTAC 21451.SDR MALA954407Constant Sect · crackedDURING SCHEDULED MAINTENANCE IN MSP, THE CONSTANT SECTION RELIEF RADIUS AT RIGHT FS 144.22 WAS FOUND TO BE CRACKED. REPAIRS WERE COMPLETED BY FABRICATING AND INSTALLING A REPAIR DOUBLER IAW FAC SRM 53-90-20 PAGES 83-85. (W)SDR PLGA330954Structure · corrodedDURING C-CHECK, INSPECTION FOUND STRUCTURE WITH MINOR CORROSION BETWEEN STATION 231 AND STATION 288. CLEANED CORRODED AREA IAW SAAB SRM CHAPTER 51-70-40 AND APPLIED PROTECTIVE TREATMENT IAW SAAB SRM CHAPTER 51-20-40. SEALED AREA IAW SAAB SRM CHAPTER 51-20-50SDR 95ZZZX1998Constant Section · crackedMSP - DURING SCHEDULED MAINTENANCE INSPECTION, MECHANICS FOUND THE RT LOWER CONSTANT SECTION CRACKED AT RELIEF RADIUS. REPAIR WAS COMPLETED BY STOP DRILLING THE CRACK, FABRICATING AND INSTALLING A REPAIR DOUBLER IAW FAC SRM 53-90-20, REPAIR NR 19.SDR HEEA954571Tub · mis mfgAFT TRANSITION AREA TOO LARGE AND RIGHT HAND RAIL TOO LOW. TIME SINCE REPAIR 0:00.SDR HEEA954466Tub · mis mfgREMOVED SHELL ASSY FROM CRATE. FOUND AREA NEAR R/H NAV. LIGHT HOLE, ON INSIDE SKIN HAVING A GOUGE (HOLE) IN SKIN, WHICH WAS FILLED WITH ADHESIVE AND ADDED INSERT. FOUND INSIDE SKIN POLISHED DUE TO EXCESSIVE SEALANT DROPPINGS, CAUSING PROTECTIVE COATING TO BESDR HEEA954370Brace · corrodedBRACES CORRODED.SDR DL72S950720Lt Box · corrosionAT HMV, FOUND CORROSION UNDER SEALANT AT RW L/E LT BOX AT STR 15R CABIN. FABRICATED REPAIR PER SRM 53-30-3.SDR 95ZZZX802Structure · corrodedWHEN AIRCRAFT'S INTERIOR WAS REMOVED TO FACILITATE FUSELAGE FRAME REPAIR, CORROSION WAS FOUND ON ALL OF THE 4130 STEEL FUSELAGE STRUCTURE THAT WAS COVERED BY THE INSULATION. THE INSULATION APPEARED TO BE ORIGINAL FACTORY INSTALLATION, IT WAS FIBERGLASS BATT TSDR ABXA9500197Skin · corrodedDURING D-CHECK ACCEPTANCE INSPECTION, FOUND CORROSION ON A SKIN REPAIR ON AFT FUSELAGE SKIN FROM FS 996 TO FS 1034 AT LONGERON 23 LEFT. REPAIRED AFT FUSELAGE SKIN IAW ABX REA D953-10834-MR.SDR DL72S950446Torque Box · crackedDURING LETTER CHECK INSPECTION, THE UPPER CHORD AT RBL 20 RUNNING FORE/AFT IN THE AFT VENTRAL STAIRWAY TORQUE BOX WAS FOUND CRACKED AT STA. 1273. IN ORDER TO GAIN ACCESS FOR REPAIR OF THE CHORD, THE I/B WEB WAS CUT BETWEEN STA 1253 AND STA 1273. BOTH THE WEBSDR AWXA9500014Chord · corrodedPHX - FLT 602 - DURING C-7 INSPECTION, FOUND UPPER SURFACE OF R2 DOOR INNER CHORD CORRODED BEYOND CLEAN UP LIMITS. REMOVED AND REPLACED INNER CHORD PER SRM 51-40-02 (W)
Back to JASC 5310