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 FDEA200901190265Door Frame · crackedCRACK INDICATION FOUND ON HOLE NR B ON FIRST SKIN LAYER IN MAIN CARGO DOOR LOWER JAMB NR 2 FITTING DURING OPEN HOLE HIGH FREQUENCY EDDY CURRENT INSPECTION.SDR FDEA200901190264Door Frame · crackedCRACK INDICATION FOUND ON HOLE NR A ON SECOND SKIN LAYER IN MAIN CARGO DOOR LOWER JAMB NR 7 FITTING DURING OPEN HOLE HIGH FREQUENCY EDDY CURRENT INSPECTION.SDR FDEA200901190263Door Frame · crackedCRACK INDICATION FOUND ON HOLE NR D ON FIRST SKIN LAYER IN MAIN CARGO DOOR LOWER JAMB NR 2 FITTING DURING OPEN HOLE HIGH FREQUENCY EDDY CURRENT INSPECTION.SDR FDEA200901190262Door Frame · crackedCRACK INDICATION FOUND ON HOLE NR C ON FIRST SKIN LAYER IN MAIN CARGO DOOR LOWER JAMB NR 2 FITTING DURING OPEN HOLE HIGH FREQUENCY EDDY CURRENT INSPECTION.SDR FDEA200901190260Door Frame · crackedCRACK INDICATION FOUND DURING HIGH FREQUENCY EDDY CURRENT OPEN HOLE INSPECTION ON DIAMETER 0.460 INCH HOLES AT MAIN CARGO DOOR LOWER JAMB NR 4 SUPPORT FITTING AT HOLE NR A AND NR B.SDR FDEA200901190259Support Fitting · crackedCRACK INDICATION FOUND DURING HIGH FREQUENCY EDDY CURRENT OPEN HOLE INSPECTION ON DIAMETER 0.460 INCH HOLES AT MAIN CARGO DOOR LOWER JAMB NR 6 SUPPORT FITTING AT HOLE NR A, NR. B, NR C AND NR D. REMOVED AND REPLACED AS PER SRM 51-31-01 VOL. II. AND REPSDR FDEA200901190258Door Frame · crackedCRACK INDICATION FOUND DURING HIGH FREQUENCY EDDY CURRENT OPEN HOLE INSPECTION ON DIAMETER 0.460 INCH HOLES AT MAIN CARGO DOOR LOWER JAMB NR 3 SUPPORT FITTING AT HOLE NR A, NR C AND NR D. CRACKED NR 3 SUPPORT FITTING AT MAIN CARGO DOOR LOWER JAMB AREA REMSDR FDEA200901190257Fitting · crackedCRACK INDICATION FOUND DURING HIGH FREQUENCY EDDY CURRENT OPEN HOLE INSPECTION ON DIAMETER 0.460 INCH HOLES AT MAIN CARGO DOOR LOWER JAMB NR 2 SUPPORT FITTING AT HOLE NR A, NR B, NR C AND NR D. CRACKED NR 2 SUPPORT FITTING AT MAIN CARGO DOOR LOWER JAMB ARSDR FDEA200901190256Door Frame · crackedCRACK INDICATION FOUND DURING HIGH FREQUENCY EDDY CURRENT OPEN HOLE INSPECTION ON DIAMETER 0.460 INCH HOLES AT MAIN CARGO DOOR LOWER JAMB NR 1 SUPPORT FITTING AT HOLE NR A, NR B, NR C AND NR D.SDR FDEA200901190255Support Fitting · crackedCRACK INDICATION FOUND DURING HIGH FREQUENCY EDDY CURRENT OPEN HOLE INSPECTION ON DIAMETER 0.460 INCH HOLES AT MAIN CARGO DOOR LOWER JAMB NR 7 SUPPORT FITTING AT HOLE NR A, NR B, NR C AND NR D.SDR FDEA200901190254Door Frame · crackedCRACK INDICATION FOUND DURING HIGH FREQUENCY EDDY CURRENT OPEN HOLE INSPECTION ON DIAMETER 0.460 INCH HOLES AT MAIN CARGO DOOR LOWER JAMB NR 5 SUPPORT FITTING AT HOLE NR A.SDR FDEA200901190236Crossbeam · damagedTO LESS EDGE DISTANCE IN CROSS BEAM COUPLING AT C 64 RT REPAIR PERFORMED BY REPLACEMENT OF 2 ANGLES IAW SRM 51-72-10.SDR IXXA09SMN001SDoor Frame · crackedDURING ROUTINE C CHECK INSPECTION, FOUND "A" CARGO DOOR FORWARD LOWER JAMB CORNER CRACKED. REMOVED FASTENERS AS NEEDED TO PERFORM REPAIR. REMOVED DAMAGED AREA. PERFORMED NDT INSPECTION. NO CRACK, NO CORROSION. FABRICATED DOUBLERS, FILLER. CLEANED, TREATESDR USAA2009021390336Crease Beam · corrodedMCN C1 MAJOR REPAIR NR 6186665 CORROSION CREASE BEAM CHORD BETWEEN BS760 TO BS780, S17L, LBL64. REPAIRED CREASE BEAM CHORD BETWEEN BS760 TO BS780, S17L, LBL64 IAW US AIRWAYS EA NR 130190.SDR USAA2009021390335Crease Beam · corrodedMCN C1 MAJOR REPAIR NR 6186663 CORROSION CREASE BEAM CHORD BETWEEN BS655 TO BS665, S17L. REPAIRED CREASE BEAM CHORD BETWEEN BS655 TO BS665, S17L, LBL64 IAW US AIRWAYS EA NR 130190.SDR USAA2009021390332Crease Beam · corrodedMCN C1 MAJOR REPAIR NR 6186665 CORROSION CREASE BEAM CHORD BETWEEN BS760 TO BS780, S17L, LBL64. REPAIRED CREASE BEAM CHORD BETWEEN BS760 TO BS780, S17L, LBL64 IAW EA NR 130190.SDR USAA2009021390331Crease Beam · corrodedMCN C1 MAJOR REPAIR NR 6186663 CORROSION CREASEBEAM CHORD BETWEEN BS655 TO BS665, S17L. REPAIRED CREASEBEAM CHORD BETWEEN BS655 TO BS665, S17L, IAW EA NR 130190.SDR USAA2009012990230Crease Beam · corrodedMCN - C12 - MAJOR REPAIR - EXFOLIATION CORROSION ON RIGHT CREASE BEAM INNER CHORD AT BS 680, RBL 63. REPLACED RIGHT CREASE BEAM INNER CHORD AT BS 680, RBL 63 IAW B757 SRM 51-40-02.SDR FDEA200901150213Failsafe · corrodedRIGHT AFT CREW/PAX DOOR CUT OUT HAS 24.5 INCH OF FRETTING CORROSION ON THE OUTER FACE OF THE FAILSAFE RING AT THE UPPER PORTION OF THE CUT OUT, BETWEEN FRAME 73A AND FRAME 75A. ONE SPOT IS AT THE AFT CORNER AND IS 1.250 INCH BY 0.250 INCH BEGINNING AT THE FWDSDR FDEA200901150211Failsafe · corrodedLEFT AFT PAX/CREW DOOR HAS APPROX 30 PLACED OF CORROSION ON THE FACE OF THE FAILSAFE RING, LOWER PORTION OF THE CUT OUT. 2 PLACES OF CORROSION ON THE EDGE OF THE INNER PLATE, JUST FWD OF FRAME 75A, INBD OF THE FAILSAFE RING. REMOVED CORROSION FROM INNER PLSDR ASAA0944221Seal Depressor · crackedMAIN CARGO DOOR DEPRESSOR ON FRAME CUTOUT UPPER EDGE IS CRACKED. REMOVED DEPRESSOR FABRICATED NEW AND INSTALLED PER PEMCO DRAWING.SDR SWAA090331Strap · brokenDURING SCHEDULED 16Y CHECK, FOUND RT CREASE BEAM SPLICE STRAP BROKEN AT BS 531. REMOVED AND REPLACED SPLICE STRAP PER SRM.SDR DALA1168470668Door Frame · damagedFUSELAGE -SECTION 46 DOOR NR 4 AFT FRAME BODY STATION 1. REPAIRED IAW EA 06-465922-03, ME02.SDR AALA200910579Casting · corrodedCORROSION ON DOOR JAMB,FORWARD LOWER CASTING. REPLACED WITH NEW CASTING.SDR SWAA090299Crease Beam · corrodedDURING SCHEDULED 16Y CHECK, FOUND RT CREASE BEAM CORRODED BETWEEN BS 313 TO BS 324. REPAIRED BEAM PER SRM.SDR AALA2009021300101Beam · corrodedCORROSION ON DOOR BEAM IN MID CARGO AT STATION 636 TO 693. INSTALLED DOUBLER PER AARD 53-10-00-3.SDR SWAA090241Crease Beam · corrodedDURING SCHEDULED 16Y CHECK, FOUND LT CREASE BEAM CORRODED AT BS 895, STR 17L. REPLACED CREASE BEAM PER SRM.SDR SWAA090266Crease Beam · corrodedDURING SCHEDULED 8Y CHECK, FOUND R2 DOOR ENTRY WAY CREASE BEAM CORRODED BETWEEN BS 967 TO BS 986. REMOVED AND REPLACED BEAM PER SRM.SDR IPXA09855489Doubler · gougedINSPECTION TYPE:SV EFN 81419911045, EVALUATION AND DISPOSITION REQUIRED OF ORIGINAL NRC 3 40540. MAIN CARGO DOOR AFT JAMB DOUBLER GOUGED FS 270. REPLACED DOUBLER PER DC8 SRM 53-2-0 FIG 23 SHT 1, REV 78.SDR IPXA09855427Cover · gougedINSPECTION TYPE:SV EFN 81419911045 MAIN CARGO DOOR AFT JAMB COVER SHOWS SIGNS OF GOUGING. FABRICATED NEW FILLER AND DOUBLER IAW DC8 SRM 53-2-0 FIG 23 SHT 1. INSTALLED FILLER AND DOUBLER IAW DC8 SRM 53-2-0 FIG 23 SHT 1.SDR SWIA200921299Door Frame · crackedDURING C-CHECK, PASSENGER DOOR FRAME CRACKED. REPLACED FRAME PER SRM.SDR SWAA090210Crease Beam · corrodedDURING SCHEDULED SPV CHECK, FOUND RT CREASE BEAM WEB CORRODED AT BETWEEN BS 380 TO BS 400. REPAIRED BEAM PER SRM.SDR WRLA2009008Door Frame · corrodedDOOR FRAME RT 3 FWD LOWER CORNER CORROSION FOUND DURING INSPECTION. REWORKED CORROSION PER SRM 53-50-02 FIG 18 REV 40. INSTALLED REPAIR PARTS PER SRM 53-50-00 FIG 18 REV 40.SDR SWIA200921192Window Post · crackedLEFT WINDSHIELD SIDE POST LOWER END AFT CLIP CRACKED. C-CHECK, REPAIRED PER SRM.SDR SWIA200921191Window Post · crackedRIGHT WINDSHIELD SIDE POST AFT MOUNT CLIP CRACKED. C-CHECK, REPAIRED PER SRM.SDR USAA2009012690160Door Frame · crackedSAL - C3 - MAJOR REPAIR - CRACK ON WEB AT PASSENGER/CREW DOOR CUTOUT AT FR68 TO FR69, S23L. REPLACED WEB AT PASSENGER/CREW DOOR CUTOUT AT FR68 TO FR69, S23L IAW A320 SRM 51-72-11.SDR SWIA200921185Structure · corrodedC-CHECK, STRUCTURE AT WL73.0 FS 409 TO FS 559 CORRODED. REPAIRED PER REO.SDR FDEA200901090110Door Frame · gougedFWD LOWER CARGO COMPARTMENT DOOR CUT OUT FWD FRAME IS GOUGED ON THE AFT SIDE OF FRAME 20 BETWEEN STRINGER 34R AND 35R. COMPLIED WITH E.A. 6-5310-127915.SDR FDEA200901090109Crease Beam · corrodedMAIN CABIN, STA 1220-1240, RT OTBD CREASE BEAM CHORD HAS CORROSION. COMPLIED REPAIR OF RT OTBD CREASE BEAM STA 1220-1240 IAW EA NR F-5310-123914. MAJOR REPAIR NO FOLLOW-UP REQUIRED.SDR SWIA200921295Rib · crackedC-CHECK, PULLED RIVETS AND CRACKED FLANGE ON FUSELAGE AUX RIB. REPAIRED PER SRM.SDR SWIA200921292Buttstrap · damagedC-CHECK, CABIN AFT AREA CENTER BUTTSTRAP DAMAGED. REPLACED BUTTSTRAP PER SRM.SDR AALA200910582Stop Fitting · crackedSTOP PAD BRACKET CRACKED. REMOVED AND REPLACED CASTING PER ESO 80174.SDR AALA200910580Stop Fitting · crackedSTOP PAD CRACKED. REMOVED AND REPLACED CASTING, PER ESO80174.SDR SWAA090163Crease Beam · corrodedDURING SCHEDULED 16Y CHECK, FOUND RT CREASE BEAM CORRODED AT BETWEEN BS 727E TO BS 747. REMOVED AND REPLACED BEAM PER SRM.SDR SWAA090158Crease Beam · corrodedDURING SCHEDULED 16Y CHECK, FOUND RT CREASE BEAM WEB BETWEEN BS 727D TO 727E CORRODED. REMOVED AND REPLACED BEAM PER SRM.SDR SWAA090154Crease Beam · corrodedDURING SCHEDULED 16Y CHECK, FOUND AFT GALLEY DOOR CREASE BEAM CORRODED BETWEEN BS 947 TO BS 1008. REMOVED AND REPLACED BEAM PER SRM.SDR SWAA090151Crease Beam · corrodedDURING SCHEDULED 16Y CHECK, FOUND CREASE BEAM CORRODED AT BS 727B, STR 17R. REMOVED AND REPLACED BEAM PER SRM.SDR SWAA090150Crease Beam · corrodedDURING SCHEDULED 16Y CHECK, FOUND CREASE BEAM CORRODED BETWEEN BS 777 TO BS 784, STR 17R. REMOVED AND REPLACED BEAM PER SRM.SDR SWAA090148Crease Beam · corrodedDURING SCHEDULED 16Y CHECK, FOUND LT AFT CREASE BEAM CORRODED BETWEEN BS 950 TO BS 990, WL 208. REPAIRED BEAM PER SRM.SDR SWAA090133Crease Beam · corrodedDURING SCHEDULED 16Y CHECK, FOUND LT CREASE BEAM CORRODED AT BETWEEN BS 233 TO BS 307. REPAIRED BEAM PER SRM.
Back to JASC 5310