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 SWAA091769Crease Beam · corrodedDURING SCHEDULED 20Y CHECK, FOUND LT CREASE BEAM WEB CORRODED BETWEEN BS 380 TO BS 400, LBL 65. REPAIRED WEB PER SRM.SDR SWAA091765Crease Beam · corrodedDURING SCHEDULED 20Y CHECK, FOUND LT CREASE BEAM WEB CORRODED BETWEEN BS 500C TO BS 500D, LBL 65. REPAIRED BEAM PER SRM.SDR SWAA091764Crease Beam · corrodedDURING SCHEDULED 20Y CHECK, FOUND LT CREASE BEAM CORRODED BETWEEN BS 460 TO BS 480, LBL 65. REPAIRED BEAM PER SRM.SDR AALA20090331TUL39Pan · crackedRIGHT WINDOW PAN CRACKED AT STATION 946 LOWER CORNER. REMOVED CRACKED TAB AND INSTALLED DOUBLER PER AARD 53-10-00-25.SDR FDEA200903161443Structure · misrepairedFUSELAGE, PREVIOUS REPAIR FOUND LOCATED BTW FR 23 AND FR 24 BTW STGR 49 RT AND 52 RT. REPAIR REQUIRES EVALUATION FOR MAJOR/MINOR EVALUATION AND IF REPAIR WAS ACCOMPLISHED USING FAA APPROVED DATA. REPAIR EVALUATED AND FOUND NOT TO CONFORM TO EXISTING FEDEX EASDR FDEA200903161401Crossbeam · misrepairedN542 - FUSELAGE - PREVIOUS REPAIR IN CROSSBEAM LOCATED BETWEEN FR 36 AT Y1680. REPAIR REQUIRES EVALUATION FOR MAJOR/MINOR DETERMINATION AND IF IT WAS ACCOMPLISHED USING FAA APPROVED DATA. REPAIR EVALUATED AND FOUND NOT TO CONFORM TO AN SRM REPAIR. NEW REPAISDR FDEA200903161400Crossbeam · misrepairedN544 - FUSELAGE - PREVIOUS REPAIR AT CROSSBEAM LOCATED BETWEEN FR 37 AT Y1680. REPAIR REQUIRES EVALUATION FOR MAJOR/MINOR DETERMINATION AND IF IT WAS ACCOMPLISHED USING FAA APPROVED DATA. REPAIR WAS EVALUATED AND FOUND NOT TO CONFORM TO AN SRM REPAIR. NEW RSDR ASAA0944772Stop Fitting · gougedFWD CARGO DOOR 2ND STOP FITTING FROM TOP DOWN FWD SIDE IS GOUGED. REMOVED AND REPLACED STOP FITTING.SDR FDEA200903160931Door Frame · dentedFOUND DENT AND SCRATCH IN FUSELAGE DOOR CUT OUT FRAME, C 59A. REPAIR PERFORMED BY CUT OUT THE DAMAGED FRAME AND INSTALLING FRAME COUPLING IAW DRAWING R539-70138, APPROVED BY RAS /EFW/9000148/2008 AND EA 6-5310-120181.SDR FDEA200903160929Beam · corrodedFOUND CORROSION IN AREA OF BULK CARGO DOOR AROUND STRUCTURE ON BEAM 10, C 67-69. REPAIR PERFORMED BY REPLACEMENT OF PART IAW SRM 51-72-10.SDR AALA20090317TUL37Pan · damagedLEFT WINDOW RING PAN AT STATION 886 LEFT, LOWER ATTACH HOLES HAVE DEEP BLEND OUTS. INSTALLED STRAP DOUBLERS PER ESO 80559 DATED 03/13/09.SDR USAA2009041390868Strap · crackedSAL - C22 - MAJOR REPAIR - CRACK ON REAR STRAP AT FORWARD FRAME OF FORWARD ENTRY DOOR AT BS 306.5, S13L. REPAIRED REAR STRAP AT FORWARD FRAME OF FORWARD ENTRY DOOR AT BS 306.5, S13L IAW US AIRWAYS EA 132328.SDR ASAA0944837Door Frame · damagedR1 DOOR FWD LOWER CORNER STUB FRAME MISDRILLED. REMOVED STUB FRAME, RECEIVED, LOCATED AND INSTALLED NEW STUB FRAME IAW B737 400 SRM 51 40 02.SDR DLM88090415Strap · corrodedTHE AFT CARGO DOOR LOWER JAMB MAIN FRAME STRAP AT FS 1212 WAS CORRODED IN SEVERAL LOCATIONS. A 0.063 INCH 7075-T6 REPAIR STRAP WAS INSTALLED OVER SEVERAL BLENDS ON THE LOWER END. THE UPPER PART OF THE PRODUCTION STRAP WAS SPLICED WITH 0.25 INCH 7075-T6 MATESDR DLM88090408Beam · corrodedDURING HMV3 EXFOLIATION CORROSION WAS FOUND ON MID CARGO COMPARTMENT DOOR JAMB LOWER BEAM. BEAM WAS REPAIRED IAW SRM 53-05 FIG 123SDR DLM88090406Beam · corrodedDURING HMV3 EXFOLIATION CORROSION WAS FOUND ON FWD CARGO COMPARTMENT DOOR JAMB LWD BEAM. BEAM WAS REPAIRED IAW SRM 53-05D FIG 804D.SDR SWAA091703Crease Beam · crackedDURING SCHEDULED 24Y CHECK, FOUND LT CREASE BEAM WEB CRACKED BETWEEN BS 636 TO BS 639, BETWEEN LBL 67 TO LBL 71. REMOVED AND REPLACED WEB PER SRM.SDR SWAA091680Crease Beam · crackedDURING SCHEDULED 24Y CHECK, FOUND RT CREASE BEAM I/B CHORD CRACKED AT BS 616, WL 208. REPAIRED CHORD PER SRM.SDR AALA20090402TUL10Door Frame · crackedFORWARD ENTRY DOOR CUTOUT AFT FRAME WEB TANG IS CRACKED AT LONGERON 11L STATION 208. REPLACED WEB TANG DOUBLER PER AARD 53-10-00-11.SDR AALA20090402TUL09Pan · crackedTOP AFT FLANGE CRACKED ON LEFT WINDOW PAN AT STATION 1079. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20090402TUL08Pan · crackedFORWARD UPPER FLANGE ON LEFT WINDOW PAN CRACKED AT STATION 1212. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR SWAA091686Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD FRAME OF AFT CARGO DOOR CUTOUT CRACKED AT BS 794. REMOVED AND REPLACED FRAME SECTION PER ACO.SDR AALA20090402TUL07Pan · crackedFORWARD UPPER TANG CRACKED ON LEFT WINDOW PAN AT STATION 1098. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR SWAA091572Crease Beam · corrodedDURING SCHEDULED 24Y CHECK, FOUND LT CREASE BEAM WEB CORRODED AT BS 370, BETWEEN LBL 61 TO LBL 63. REPAIRED WEB PER SRM.SDR A6WA200940119Crossbeam · crackedCROSSBEAM AT FS 280.00, LBL 9.00, WL 72.00 IS CRACKED IN THE LOWER RADIUS, CRACK LENGTH IS .600 INCH LONG. CROSSBEAM REPAIRED IAW REO 601R-53-11-171, SCHEME A. (K)SDR SWIA200921152Beam · crackedBOX BEAM UPPER ANGLE AT FS 640 UPPER LEFT SIDE CRACKED. AD COMPLIANCE, REPLACED CRACKED ANGLE PER SRM.SDR SWAA091538Crease Beam · corrodedDURING SCHEDULED 20Y CHECK, FOUND RT CREASE BEAM CORRODED BETWEEN BS 747 TO BS 797, WL 208. REPAIRED BEAM PER SRM.SDR SWAA091532Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND AFT CARGO DOOR CUTOUT FWD FRAME CRACKED. REPAIRED FRAME PER ACO.SDR A6WA200940118Crossbeam · crackedCROSSBEAM AT FS 280.00, RBL 9.00, WL 72.00 IS CRACKED IN LOWER RADIUS. CRACK LENGTH IS .700 INCH LONG. CROSSBEAM AT FS 280.00, RBL 9.00, WL 72.00 IN LOWER RADIUS REPAIRED IAW REO 601R-53-11-171. REV D REPAIR SCHEME A. (K)SDR SWAA091507Door Frame · crackedDURING SCHEDULED 8Y CHECK, FOUND R1 DOOR FRAME CRACKED AT BS 294. REPAIRED FRAME PER SRM.SDR SWAA091475Crease Beam · corrodedDURING SCHEDULED 8Y CHECK, FOUND RT CREASE BEAM CORRODED BETWEEN BS 947 TO BS 986. REMOVED AND REPLACED BEAM PER SRM.SDR SWAA091471Crease Beam · crackedDURING SCHEDULED 24Y CHECK, FOUND CREASE BEAM WEB CRACKED BETWEEN BS 597 TO BS 578, STR 17L. REMOVED AND REPLACED WEB PER SRM.SDR SWAA091464Crease Beam · corrodedDURING SCHEDULED SPV CHECK, FOUND RT CREASE BEAM WEB CORRODED BETWEEN BS 887 TO BS 907. REPAIRED WEB PER SRM.SDR IPXA09555313Door Frame · damagedINSPECTION TYPE:C ("04 ITEM") FWD CARGO DOOR JAM AT STA 620 HAS 2EA MISDRILLED HOLES HOLES IN WEB & CHORD. REMOVED DAMAGED BRACKET PER SRM 51-40-02. DIM OF DAMAGE HOLES: A UPPER HOL .330" ORIG HOLE .250 B LWR HOLE .315 IRUG GIKE .250 PER DRW NT143N8522. REMSDR ASAA0944624Stop Fitting · scratchedFWD CARGO DOOR STOP PIN FITTING AT AFT BOTTOM CORNER IS SCRATCHED. REPAIRED PER ATS ER 09 1826 AND ASA 800 52EA 00790 BY BLENDING AREA AND RE-APPLYING PROTECTIVE FINISH.SDR SWAA091408Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FWD CARGO DOOR FWD LOWER SIDE FRAME DOUBLER CRACKED. REMOVED AND REPLACED FRAME ASSY PER SRM.SDR FDEA200903040839Beam · corrodedFWD CARGO COMP AREA INSP SEVERE CORROSION WITH EXFOLIATION ON BEAM. REPAIRED AREA IAW SRM 53-00-01, FIG 9, SHT 7, VOL I.SDR USAA2009030490506Door Frame · crackedCLT - Q4 - MAJOR REPAIR - CRACK AT MAIN ENTRY DOOR LOWER AFT DOOR BEAM NEXT TO NR 8 STOP FITTING. REPLACED LOWER AFT DOOR BEAM IAW B737 SRM 51-10-01 & BOEING DRAWING 50-7945.SDR DLM88090596Door Frame · corrodedEXFOLIATION CORROSION ON LOWER DOOR JAMB BTW STA Y=636 TO Y=693. DOORJAMB REPAIRED IAW SRM 53-05 FIG 123.SDR DLM88090366Support Beam · crackedSUPPORT BEAM CRACKED AFT SIDE OF AIR STAIR CUTOUT, STA 1494. REPAIRED PER SRM 51-30-02 ON ATS CARD 01481.SDR SWAA091358Door Frame · crackedDURING SCHEDULED 26Y CHECK, FOUND FUSELAGE FRAME CRACKED AT R1 DOOR LOWER HINGE CUTOUT, BS 291, WL 231. REPAIRED FRAME PER EA.SDR C2XA09TY040Door Frame · corrodedAIRCRAFT IN FOR A 5C INSPECTION WHEN CORROSION WAS FOUND ON THE SERVICE DOOR CUTOUT FRAME NEAR THE AFT LOWER ROLLER. MAINTENANCE REPAIRED FRAME 22 IAW EC5310--01464. COMPLIED WITH COLD WORKING AND FINAL REAM OF LOWER TWO AFT SERVICE DOOR STOPS IAW EA 5310-01SDR IPXA09154892Door Frame · dentedMULTIPLE DOOR FRAME DENTS BULK CARGO DOOR. INSTALLED DOOR PER 52-34-11-04 EXCEPT STEPS 2D (2) ELECT BONDING. 2D (5) CORROSION PREVENTATIVE PASTE 2E TEST AND 2F CLOSE UP COMPLETED REMAINING STEPS PER MM 52-34-11-04. THIS CLEARS DEF 396040.SDR FDEA200903030825Crossbeam · corrodedFOUND CORROSION ON CROSSBEAM C 62 RT. REPAIR PERFORMED BY REPLACEMENT OF PART IAW SRM 51-72-10.SDR DLM88090326Doubler · corrodedTHE AFT CARGO LWR THRESHOLD DOOR SURROUND DOUBLER HAD CORROSION ALONG THE UPPER EDGE. THE SKIN WAS BLENDED TO 0.023 INCH AT FS 1194 AND WAS TRIMMED OUT. THE SKIN WAS BLENDED TO 0.044 INCH AT FS 1175 AND WAS LEFT AS IS. A REPAIR DOUBLER WAS INSTALLED FROM 11SDR C2XA09SH070Door Frame · corrodedSHV - DURING C-CHECK CARGO DOOR CUTOUT LWR BEAM AREA CORRODED IN SEVERAL PLACES. MAINTENANCE REMOVED AND REPLACED CARGO DOOR LOWER BEAM IAW EMB-145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED TO RETURN TO SERVICE.SDR ASAA0944526Crease Beam · corrodedAREAS CORROSION ON INNER CREASE BEAM LT SIDE BS 500C-520. REMOVED AND REPLACED CREASE BEAM.SDR AALA20090304TUL03Crease Beam · corrodedCREASE ANGLE CORRODED RIGHT SIDEWALL STATION 312 TO 340. REPLACED CREASE ANGLE PER SRM 51-10-02-0G.SDR DU4R2009307Door Frame · corrodedS/O 312003 N/R 37999 DURING SCHEDULED INSPECTION, FOUND CORROSION ON RT A/C BAY DOOR FRAME I/B JUST AFT OF FWD ATTACH POINT.SDR AALA20090316TUL04Door Frame · crackedFORWARD ENTRY DOOR JAMB IS CRACKED AT FASTENER, LONGERON 11 LEFT AT STATION 207. REMOVED DAMAGE AND INSTALLED DOUBLER PER AARD 53-10-00-11.
Back to JASC 5310