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 SWAA064396Door Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FWD CARGO DOOR CUTOUT AFT FRAME CRACKED AT NR 5 DOOR STOP. REPAIRED FRAME SECTION PER SRM.SDR KCSA061532Tension Tie · damagedMAIN DECK FUSELAGE TENSION TIE ATTACH BRACKET IS DAMAGED AT STA 900, LBL 36.SDR AWXA200601943Door Frame · crackedMCN - R-1 DOOR CUTOUT FRAME CRACKED AT FWD UPPER STOP PAD FITTING. REPLACED R-1 DOOR FWD UPPER FRAME IAW B737-300 SRM 51-40-02-0G, FIG 3, 6, 7, AND 8.SDR TSAA0653101Door Frame · damagedAFT CARGO DOOR CUT-OUT DAMAGED (LOWER AFT CORNER). ALOHA ECO 3622 ISSUED.SDR SIMA200632001Unknown · vibrationDISC - AIRFRAME SHUDDERED DURING FLIGHT SEVERAL TIMES. CREW REPORTED THAT IT FELT LIKE SEVERAL BIRDS HAD HIT THE LOWER FUSELAGE.SDR AMTA200600660Door Frame · corrodedFWD CARGO DOOR JAMB (LWR) HAS CORROSION SEVERAL AREAS FROM STA 560-620, RBL 27. REMOVED CORROSION FROM WEB AREA MAT THICKNESS .065 MAT LOSS .002 WITHIN LIMITS IAW SRM, REF 53-30-15 FOR CORROSION REMOVAL REMOVED CORROSION FROM CLIP AREA IAW SRM. MAT THICKNESSSDR TRAX200601009Support Beam · crackedCARGO DOOR TRACK SUPPORT BEAM AFT LOWER ANGLE IS CRACKED.SDR KCSA061507Tension Tie · crackedFUSELAGE TENSION TIE AFT C-CHANNEL IS CRACKED AT STA 900, RT SIDE INBOARD OF FUSELAGE FRAME.SDR KCSA061506Tension Tie · crackedFUSELAGE TENSION TIE AFT C-CHANNEL IS CRACKED AT STA 880, LT SIDE INBOARD OF FUSELAGE FRAME.SDR KCSA061504Shear Web · crackedFUSELAGE LT & RT TENSION TIE SLOPING SHEAR WEBS ARE CRACKED BETWEEN STA 820 & 840, ABOVE STR 12L & 12R.SDR KCSA061502Tension Tie · crackedFUSELAGE TENSION TIE AFT C-CHANNEL IS CRACKED AT RIGHT SIDE OF FRAME CONNECTION AREA, STA 820.SDR KCSA061520Tension Tie · crackedMAIN DECK TENSION TIE HAS .375 INCH CRACK ON AFT C-CHANNEL AT B.S.900, STR-9R.SDR KCSA061515Tension Tie · crackedMAIN DECK TENSION TIE AFT C-CHANNEL HAS A .25 INCH CRACK ABOVE STR 9L.SDR KCSA061513Tension Tie · crackedMAIN DECK TENSION TIE AFT C-CHANNEL HAS A .25 INCH CRACK AT BS 800, STR 12L.SDR KCSA061512Tension Tie · crackedMAIN DECK TENSION TIE AFT C-CHANNEL HAS .25 INCH CRACK AT BS 920, STR 9R.SDR LR7A06191Beam · crackedDURING SCHEDULED C6 CHECK PER JOB CARD HC5324, FOUND RT UPPER WHEEL WELL BOW BEAM CRACKED AT FS 557, WL202, RBL62. REPAIRED BOW BEAM IAW SMP583 53-40-14.SDR EVGR1113735Door Frame · corrodedCORROSION WAS FOUND AT THE AFT DOOR FRAME AT FUSELAGE STATION 255.5 JUST BELOW AND OUT BOARD OF THE DOOR SNUBBER MOUNT. DAMAGE WAS REPAIRED IAW SIRM PN 9839006C, DATED MARCH 2003, ATA 20-10-03 FIGURE 202, PAGES 204 AND 205 AND ATA 20-10-34, FIGURE 201, PAGES SDR SWAA064318Crease Beam · corrodedDURING SCHEDULED 18Y CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 460 TO BS 500B, LBL 70. REMOVED AND REPLACED CREASE BEAM WEB SECTION PER SRM.SDR 06FDEA03920Crease Beam · corrodedFOUND CORROSION ON CREASE BEAM WEB AT BS 720C PLUS 11" AND 720C PLUS 18", LBL 65, WL 208. REMOVED DAMAGE ON CREASE BEAM AT 720C PLUS 11 TO 720C PLUS 18, LBL 65, WL 208 AND REPAIRED IAW SRM 51-30-2.SDR SWAA064279Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO DOOR CUTOUT AFT FRAME CRACKED AT NR 5 DOOR STOP. REMOVED AND REPLACED FRAME SECTION PER ACO.SDR SWAA064278Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO DOOR CUTOUT FWD FRAME CRACKED AT NR 5 DOOR STOP. REMOVED AND REPLACED FRAME SECTION PER ACO.SDR 06FDEA03926Crease Beam · damagedFOUND CREASE BEAM TO BE MISDRILLED AT BS 720F AND 720E LBL 63, WL 208. REMOVED DAMAGE CREASE BEAM AT BS 720F TO 720E LBL 63 WL 208 AND REPAIRED IAW SRM 51-30-5, 51-30-6, AND 51-30-8.SDR 2006UALA02156Door Frame · crackedFWD CARGO DOOR CUT-OUT AFT FRAME CRACKED AT 2 EA LOCATION AT BS 492 NEAR STR S-24R. REMOVED DAMAGE. FABRICATED AND INSTALLED NESTED ANGLES REPAIR. REFERENCE AAR EA I060500 AND UA-EVA-60678.SDR 06FDEA03911Crease Beam · corrodedFOUND CORROSION ON CREASE BEAM WEB BS 720D - BS 720E, STR 17L. REMOVED DAMAGED CREASE BEAM WEB BS 720D-720E, STR 17L AND REPAIRED IAW SRM 51-10-2.SDR USAA061331Door Frame · crackedFWD SERVICE DOOR FWD STUB FRAME CRACKED. REMOVED DAMAGED FRAME AND FABRICATED REPAIR PARTS AND INSTALLED NEW FRAME IAW SRM 51-20-01, DEFECT SIZE: .125 INCH.SDR SWAA064258Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO DOOR CUTOUT AFT FRAME CRACKED AT UPPER INBOARD CORNER. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA064255Crease Beam · corrodedDURING SCHEDULED 18Y CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 420 TO BS 440, LBL 70. REMOVED AND REPLACED CREASE BEAM WEB SECTION PER SRM.SDR USAA061328Angle · crackedSTA 296 STR 17R FWD LOWER I/B ANGLE IN SERVICE DOOR FUSELAGE CUTOUT CRACKED. REMOVED CRACKED ANGLE AND INSTALLED NEW ANGLE IAW SRM 51-10-02, DEFECT SIZE: 3 INCHES.SDR USAA061313Angle · corrodedSTA 312 TO 360 AT ENTRY DOOR HAS CORROSION. REMOVE AND REPLACE IAW SRM 51-10-02 LEVEL 1 C53-107-02, DEFECT SIZE: 48 INCHES.SDR SWIA200617647Window Frame · crackedCOCKPIT BELOW LEFT DV WINDOW FRAME 10 CRACKED, DISCOVERED DURING C-CHECK INSPECTION. REPAIRED FRAME NR 10 BELOW LEFT DV WINDOW PER SRM 53-00-04 AND RII 53-800-1000.SDR DU4R2006673Housing · corrodedS/O 291025 N/R NR 24276 CORROSION ON TOP OF LAV SERVICING HOUSING BS 1681 TO BS 1701. FABRICATED AND INSTALLED CHANNEL 18.5 INCHES X 2 INCHES X 1INCH, CHANNEL 8 INCHES X 2.5 INCHES X .5 INCH AND 4 EA BRACKETS FROM 2024-T3 CLAD .032 INCH AND REPLACED DOOR P/N SDR SWAA064223Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO DOOR CUTOUT AFT FRAME CRACKED AT LOWER STOP FITTING. REMOVED AND REPLACED FRAME SECTION PER ACO.SDR PIDR2006045Structure · crackedFASTENER HOLES CRACKED AT THE UPPER HINGE CUTOUT AND LOWER HINGE CUTOUT OF THE LT FORWARD ENTRY DOOR. REPAIRED AREA IAW MESSAGE 1-232472835 WITH FAA DER APPROVED 8100-9 DATED NOV.3, 2006.SDR QXEA200602935Structure · damagedC3 PDX - BURN MARK ON RIVET AT STATION X301.00 BETWEEN STRINGER 16R. REPAIRED IAW SRM 51-42-00, 53-00-00, 51-21-10, AND 51-25-05.SDR QXEA200602934Structure · damagedC3 PDX - RIVET DAMAGE DUE TO LIGHTNING STRIKE AT STATION X20.00 STRINGER 24 LEFT HAND. REPAIRED IAW SRM 51-42-00, 53-00-00, 51-21-10, AND 51-25-05.SDR DU4R2006674Housing · corrodedS/O 291025 N/R 24877 CORROSION ON FRAME ON TOP OF LAV SERVICING HOUSING BS 1681 TO BS 1701. FABRICATED AND INSTALLED FRAME 17.3 INCH X 3.3 AND BEAM 4 INCHES X 1 INCH X 1 INCH AND 2 BRACKETS 1.3 INCH X 1.8 INCH AND 2 BRACKETS 2.5 INCHES X 1.5 INCH FROM 2024-T3 SDR SWAA064220Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO DOOR CUTOUT AFT FRAME CRACKED AT NR 5 DOOR STOP. REMOVED AND REPLACED FRAME SECTION PER ACO.SDR AWXA200601961Door Frame · crackedMCN - MAJOR REPAIR - R-1 DOOR 3RD AND 4TH FROM TOP, AFT DOOR STOP CUT-OUTS CRACKED APPROX .300" AND .375", BS 329, WL 232 - WL 424, RBL 50. REPAIRED R-1 DOOR 3RD AND 4TH FROM TOP, AFT DOOR STOP CUT-OUTS, BS 329, WL 232 - WL 424, RBL 50 IAW AWA ER 03-5200-063SDR DHL2006780104Door Frame · crackedNUMBER 2 LWR CARGO DOOR FRAME WEB IS CRACKED AT BS 950, STR 26R. REPAIRED NR 2 LOWER CARGO DOOR FWD FRAME WEB AT BS 950, STR 26R IAW SB727-53A0199 FIG 2. FAB REPAIR DOUBLER FROM P/N 7075-T6, .080, PO NR 9003505, APPROX DIM. 13.625" BY 4.5" IAW SB727-53A0199.SDR DHL2006780004Door Frame · crackedNUMBER 2 LWR CARGO DOOR FRAME WEB IS CRACKED AT BS 950, STR 26R. REPAIRED NR 2 LOWER CARGO DOOR FWD FRAME WEB AT BS 950, STR 26R IAW SB727-53A0199 FIG 2. FAB REPAIR DOUBLER FROM P/N 7075-T6, .080, PO# 9003505, APPROX DIM 13.625" BY 4.5" IAW SB727-53A0199. SSDR USAA061305Door Frame · crackedFWD CARGO DOOR FRAME AT STA 440 STR 24R LOWER O/B HOLE CRACKED. REMOVED DAMAGE FRAME AND INSTALLED NEW FRAME IAW DWG 6-15224, DEFECT SIZE: 1 INCH.SDR ABXA060294Door Frame · crackedLEFT AND RIGHT UPPER DOOR JAMBS ON AFT P-DOME WERE CRACKED. REPAIRED AREA IAW REA D953-54944.SDR QXEA200602990Stop Fitting · wornC4 PDX - RIGHT FORWARD EMERGENCY EXIT DOOR, ALL DOOR STOPS ON AIRFRAME HAVE WEAR. REPAIRED IAW RD8-52-349.SDR QXEA200602989Stop Fitting · wornC4 PDX - RIGHT CENTER EMERGENCY EXIT DOOR, ALL DOOR STOPS ON AIRFRAME HAVE WEAR. REPAIRED IAW RD8-53-126.SDR QXEA200602988Stop Fitting · wornC4 PDX - LEFT CENTER EMERGENCY EXIT DOOR, ALL DOOR STOPS ON AIRFRAME HAVE WEAR. REPAIRED IAW RD8-53-126.SDR TRAX200600964Beam · crackedFOUND UPPER CENTER BOX BEAM APPEARS CRACKED. REPAIRS MADE IAW BOMBARDIER REO 601R53-61-345. (CLOSED 11/07/06)SDR USAA061295Beam · corrodedFOUND BEAM CORROODED -Y254 AND Y254. REMOVED AND REPLACED PER SRM 51-72-11; CORROSION TASK JA-220-53500; LEVEL 1 DEFECT SIZE:SDR USAA061280Stop Fitting · crackedFOUND CRACK STA 294.5 UPPER FWD STOP FITTING. REMOVED DAMAGED PART AND REPLACED WITH NEW IAW SRM 51-10-02, DEFECT SIZE: .25".SDR TRAX200600955Doubler · crackedLT SIDE 640 DOUBLER CRACKED.SDR TRAX200600954Doubler · crackedRIGHT SIDE 640 DOUBLER CRACKED.
Back to JASC 5310