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 UPS00434183Forging · corrodedINSPECTION TYPE:C, CORROSION FOUND UNDER MAIN DECK WINDOW FORGING AT BS 560 TO 580 LT. CORROSION REMOVED FOUND TO BE WITHIN LIMITS.SDR UPS00434172Forging · corrodedINSPECTION TYPE:C, CORROSION FOUND UNDER WINDOW FORGING AT BS 220 - 240 LT. WINDOW FORGING REMOVED. CORROSION REMOVED FROM FORGING AND SKIN DOUBLER IAW SRM 56-20-01 AND 56-10-01. FORGING RE-INSTALLED.SDR UPS00434206Forging · corrodedINSPECTION TYPE:C, CORROSION FOUND UNDER MAIN DECK WINDOW FORGING AT BS 760 TO 780 RT. CORROSION REMOVED IAW SRM AND FOUND TO BE WITHIN SRM LIMITS.SDR UPS00434205Forging · corrodedINSPECTION TYPE:C, CORROSION FOUND UNDER MAIN DECK WINDOW FORGING AT BS 740 TO 760 RT. CORROSION REMOVED IAW SRM AND FOUND TO BE WITHIN SRM LIMITS.SDR UPS00434204Forging · corrodedINSPECTION TYPE:C, CORROSION FOUND UNDER MAIN DECK WINDOW FORGING AT BS 720 TO 740 RT. CORROSION REMOVED IAW SRM AND FOUND TO BE WITHIN SRM LIMITS.SDR UPS00434203Forging · corrodedINSPECTION TYPE:C, CORROSION FOUND UNDER MAIN DECK WINDOW FORGING AT BS 700 TO 720 RT. CORROSION REMOVED IAW SRM 53-10-01 AND FOUND TO BE WITHIN SRM LIMITS.SDR UPS00434202Forging · corrodedINSPECTION TYPE:C, CORROSION FOUND UNDER MAIN DECK WINDOW FORGING AT BS 680 TO 700 RT. CORROSION REMOVED IAW SRM AND FOUND TO BE WITHIN SRM LIMITS.SDR UPS00434201Forging · corrodedINSPECTION TYPE:C, CORROSION FOUND UNDER MAIN DECK WINDOW FORGING AT BS 660 TO 680 RT. CORROSION REMOVED IAW SRM, FOUND TO BE WITHIN SRM LIMITS.SDR UPS00434200Forging · corrodedINSPECTION TYPE:C, CORROSION FOUND UNDER MAIN DECK WINDOW FORGING AT BS 640 TO 660 RT. CORROSION REMOVED IAW SRM, FOUND TO BE WITHIN SRM LIMITS.SDR UPS00434199Forging · corrodedINSPECTION TYPE:C, CORROSION FOUND UNDER MAIN DECK WINDOW FORGING AT BS 620 TO 640 RT. CORROSION REMOVED IAW SRM, FOUND TO BE WITHIN SRM LIMITS.SDR UPS00434198Forging · corrodedINSPECTION TYPE:C, CORROSION FOUND UNDER MAIN DECK WINDOW FORGING AT BS 600 TO 620 RT. CORROSION REMOVED, FOUND OUTSIDE LIMITS REF MRR UPS00434380 FOR REP AIR DETAILS.SDR UPS00434197Forging · corrodedINSPECTION TYPE:C, CORROSION FOUND UNDER MAIN DECK WINDOW FORGING AT BS 580 TO 600 RT. CORROSION REMOVED IAW SRM, FOUND TO BE WITHIN SRM LIMITS.SDR UPS00434196Forging · corrodedINSPECTION TYPE:C, CORROSION FOUND UNDER MAIN DECK WINDOW FORGING AT BS 560 TO 580 RT. CORROSION REMOVED IAW SRM, FOUND TO BE WITHIN SRM LIMITS.SDR UPS00434195Forging · corrodedINSPECTION TYPE:C, CORROSION FOUND UNDER MAIN DECK WINDOW FORGING AT BS 540 TO 560 RT. CORROSION REMOVED IAW SRM, FOUND TO BE WITHIN SRM LIMITS.SDR UPS00434194Forging · corrodedINSPECTION TYPE:C, CORROSION FOUND UNDER MAIN DECK WINDOW FORGING AT BS 520 TO 540 RT. CORROSION REMOVED IAW SRM, FOUND TO BE WITHIN SRM LIMITS.SDR UPS00434193Forging · corrodedINSPECTION TYPE:C, CORROSION FOUND UNDER MAIN DECK WINDOW FORGING AT BS 760 TO 780 LT. CORROSION REMOVED IAW SRM 53-10-02 AND FOUND INSIDE SRM LIMITS.SDR UPS00434192Forging · corrodedINSPECTION TYPE:C, CORROSION FOUND UNDER MAIN DECK WINDOW FORGING AT BS 740 TO 760 LT. CORROSION REMOVED IAW SRM 53-10-02 AND FOUND WITHIN SRM LIMITS.SDR UPS00434190Forging · corrodedINSPECTION TYPE:C, CORROSION FOUND UNDER MAIN DECK WINDOW FORGING AT BS 700 TO 720 LT. CORROSION REMOVED IAW SRM 51-30-02, FOUND TO BE WITHIN SRM LIMITS.SDR UPS00434189Forging · corrodedINSPECTION TYPE:C, CORROSION FOUND UNDER MAIN DECK WINDOW FORGING AT BS 680 TO 700 LT. CORROSION REMOVED IAW SRM 53-10-02 AND FOUND TO BE WITHIN SRM LIMITS.SDR UPS00434188Forging · crackedINSPECTION TYPE:C, CORROSION FOUND UNDER MAIN DECK WINDOW FORGING AT BS 660 TO 680 LT. WINDOW FORGING REMOVED IAW SRM 51-30-02. CORROSION REMOVED FROM SKIN DOUBLER AND STRINGERS IAW SRM 53-30-01. CORROSION REMOVED FROM WINDOW FORGING IAW SRM 56-20-01. CRACSDR UPS00434187Forging · corrodedINSPECTION TYPE:C, CORROSION FOUND UNDER MAIN DECK WINDOW FORGING AT BS 640 TO 660 LT. CORROSION REMOVED, FOUND TO BE WITHIN SRM LIMITS.SDR UPS00434186Forging · corrodedINSPECTION TYPE:C, CORROSION FOUND UNDER MAIN DECK WINDOW FORGING AT BS 620 TO 640 LT. CORROSION REMOVED, FOUND TO BE WITHIN LIMITS.SDR UPS00434185Forging · corrodedINSPECTION TYPE:C, CORROSION FOUND UNDER MAIN DECK WINDOW FORGING AT BS 600 TO 620 LT. CORROSION REMOVED, FOUND TO BE WITHIN LIMITS.SDR UPS00434184Forging · corrodedINSPECTION TYPE:C, CORROSION FOUND UNDER MAIN DECK WINDOW FORGING AT BS 580 TO 600 LT. CORROSION REMOVED, FOUND TO BE WITHIN LIMITS.SDR UPS00434182Forging · corrodedINSPECTION TYPE:C, CORROSION FOUND UNDER MAIN DECK WINDOW FORGING AT BS 540 TO 560 LT. CORROSION REMOVED IAW SRM 51-10-01 AND FOUND INSIDE LIMITS.SDR UPS00434181Forging · corrodedINSPECTION TYPE:C, CORROSION FOUND UNDER MAIN DECK WINDOW FORGING AT BS 520 TO 540 LT. WINDOW FORGING REMOVED IAW SRM 51-30-02, CORROSION REMOVED FROM SKIN DOUBLER AND STRINGERS 20 AND 22 IAW SRM 53-10-01, CORROSION REMOVED FROM WINDOW FORGING IAW SRM 56-20-SDR UPS00434180Forging · corrodedINSPECTION TYPE:C, CORROSION FOUND UNDER MAIN DECK WINDOW FORGING AT BS 380 TO 400 LT. WINDOW FORGING REMOVED IAW SRM 51-30-02, CORROSION REMOVED FROM SKIN DOUBLER AND STR 20 AND 22 IAW SRM 53-10-01. CORROSION REMOVED FROM WINDOW FORGING IAW SRM 56-20-01, SSDR UPS00434179Forging · corrodedINSPECTION TYPE:C, CORROSION FOUND UNDER MAIN DECK WINDOW FORGING AT BS 360 TO 380 LT. WINDOW FORGING REMOVED IAW SRM 51-30-02, CORROSION REMOVED FROM SKIN DOUBLER AND STR 20 AND 22 IAW SRM 53-10-01, CORROSION REMOVED FROM WINDOW FORGING IAW SRM 56-20-01. SSDR UPS00434178Forging · corrodedINSPECTION TYPE:C, CORROSION FOUND UNDER MAIN DECK WINDOW FORGING AT BS 280 TO BS 300 LT. WINDOW FORGING REMOVED IAW SRM 51-30-02. CORROSION REMOVED FROM SKIN DOUBLER IAW SRM 51-10-01. CORROSION REMOVED FROM WINDOW FORGING IAW 5-20-01. FORGING INSTALLED IASDR USAA001701Crease Beam · crackedCLT - Q-4, BEAM WEB CRACKED 1.5 INCHES AT LEFT CREASE BEAM STA 616. REPLACED WEB PER SRM 51-10-02. (X)SDR USAA001702Crease Beam · corrodedCLT - Q-4, CREASE BEAM WEB CORRODED, 50 INCH, CORROSION LEVEL 1, LEFT CREASE BEAM STA 621. REPLACED WEB PER SRM 51-10-02. (X)SDR AWXA0000725Shear Tie · crackedC-CHECK, SHEAR TIE CRACKED AT FS 400 STR 14R. REMOVED DAMAGED SECTION IAW 737 SRM 51-10-1, FABED SHEAR TIE IAW 737 SRM 53-10-4, INSTALLED REPAIR PARTS IAW 737 SRM 53-10-4.SDR TWAA0016022Structure · corrodedDURING CHECK-C MAINT, FOUND CORROSION ON LAV SERVICE PANEL BACK SIDE, AROUND FILL LINES AT STATION 1320L. REMOVED CORROSION PER SPM 80-01 AND REPLACED PANEL. TREATED WITH PAINT. INSTALLED PER ARA 17160 AND SRM 51-30-3 HI-LOKS. LONGERON SPLICE PER 53-02 FIGSDR PCAA0010067Structure · crackedMDT- DURING ROUTINE FLEET INSPECTION, REAR FUSELAGE STRUCTURE WAS FOUND CRACKED AT FRAME 4 STRINGER 4 RIGHT SIDE. CRACK WAS REPAIRED IN ACCORDANCE WITH DEHAVILLAND REPAIR DRAWING RD 8-55-199. AIRCRAFT WAS THEN RETURNED TO SERVICE.SDR PCAA0009067Structure · crackedMDT- DURING ROUTINE FLEET INSPECTION, REAR FUSELAGE STRUCTURE WAS FOUND CRACKED AT FRAME 4 STRINGER 4 RIGHT SIDE. CRACK WAS REPAIRED IN ACCORDANCE WITH DEHAVILLAND REPAIR DRAWING RD 8-55-199. AIRCRAFT WAS THEN RETURNED TO SERVICE.SDR P2EA00293Door Frame · crackedSJO - DURING Q-CHECK, FOUND THE R-1 DOOR CUT OUT LOWER CORNER AT BS 315 WITH CRACK. L = 1.50 INCHES. W = 0.002 INCH. REPAIRED THE R-1 DOOR CUT OUT LOWER CORNER AT BS 315 IAW BOEING SRM 53-30-3 FIG 26. (X)SDR QXEA0003008Rivet · crackedPDX- LEFT HAND NOSE LANDING GEAR BAY WALL HAS A SECOND CRACK TWO RIVETS FORWARD OF CRACK CALLED OUT ON NON ROUTINE 210-227. FORWARD OF FRAME 3050. REPAIRED IAW HORIZON AIR EA 4-53-1391.SDR MWEA00863Shear Tie · corrodedMKE - FOUND SHEAR TIE AT STATION 160 ON FORWARD SIDE OF FRAME IS CORRODED FROM LONGERON 27 LEFT TO 29 LEFT. FABRICATED AND INSTALLED SHEAR TIE. (M)SDR MWEA00864Shear Tie · corrodedMKE - SHEAR TIE AT STATION 160 ON FORWARD SIDE OF FRAME IS CORRODED FROM LONGERON 27 RIGHT TO 29 RIGHT. FABRICATED AND INSTALLED SHEAR TIE. (M)SDR CALA0001504Shear Tie · corrodedSHEAR TIE CORRODED AT FS 1193 FROM LONG 2 TO 4L. REMOVED AND REPLACED SHEAR TIE PER SRM 51-30-5.SDR USAA001680Crease Beam · crackedCLT - Q-4, CREASE BEAM WEB CRACKED 1 INCH AT STA 578 RT FLOOR LEVEL STR 17. REPLACED WITH WEB PER SRM 51-10-2. (X)SDR PCAA0010066Structure · crackedMDT- DURING FLEET INSPECTION, REAR FUSELAGE STRUCTURE WAS FOUND CRACKED AT FRAME 4 STRINGER 4 LEFT AND RIGHT SIDES IN APU AREA. CRACKS WERE REPAIRED IN ACCORDANCE WITH DEHAVILLAND REPAIR DRAWING RD 8-55-199. AIRCRAFT WAS THEN RETURNED TO SERVICE.SDR SWAA001933Crease Beam · crackedDURING SCHEDULED 1/2D CHECK, FOUND CREASE BEAM SHEAR WEB CRACKED AT BS 927 - 951, RBL 57, WL 208. REPAIRED CREASE BEAM PER SRM.SDR PCAA0009066Structure · crackedMDT- DURING FLEET INSPECTION, REAR FUSELAGE STRUCTURE WAS FOUND CRACKED AT FRAME 4 STRINGER 4 LEFT AND RIGHT SIDES IN APU AREA. CRACKS WERE REPAIRED IN ACCORDANCE WITH DEHAVILLAND REPAIR DRAWING RD 8-55-199. AIRCRAFT WAS THEN RETURNED TO SERVICE.SDR 00FDEA00711Shear Tie · crackedDURING ROUTINE INSP, THE SHEAR TIE CLIP AT BS 990, STR 4L & 6L FOUND CRACKED. REMOVED AND REPLACED FAB PER IAW BAC 727 SRM 51-20-1, 51-30-2.SDR 00FDEA00700Shear Tie · crackedDURING ROUTINE INSP, SHEAR TIE CLIP AT BS 1050, STR 6L FOUND CRACKED. REMOVED AND REPLACED, FAB PER IAW BAC 7S7 SRM 51-20-1, 51-30-2.SDR SWAA001928Shear Tie · crackedDURING SCHEDULED 1/2D CHECK, FOUND CRACKED SHEAR TIE AT BS BS 400, STR 13R - 14R. REPAIRED SHEAR TIE PER SRM.SDR SWAA001926Shear Tie · crackedDURING SCHEDULED D-CHECK, FOUND SHEAR TIE CRACKED AT BS 400, STR 13R - 14 R. REPAIRED SHEAR TIE PER SRM.SDR UPS00833858Shear Tie · corrodedINSPECTION TYPE:C1, STA 1760 LONG 28L - 28R 8 SHEAR TIES ARE CORRODED BEYOND LIMITS. REMOVED, FABRICATED, AND REPLACED SHEAR TIES IAW 5612148, AND SRM 51-1-21.SDR DL73E001942Door Frame · crackedTHE FWD FRAME OF THE C2 CARGO DOOR WAS FOUND WITH A 1 INCH CRACK IN THE UPPER AND LOWER FRAME WEBS AT THE FRAME LAP SPLICE ABOVE THE NR 3 STOP. THE CRACK WAS STOP DRILLED AND REPAIRED WITH TWO TITANIUM REPAIR ANGLES ON A TIME-LIMITED BASIS PER ER/A 378809-1
Back to JASC 5310