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 USAA061043Structure · corrodedBS 270 LBL 11 TO RBL 11. INSTALLED REPAIR STRAP AND TAPERED SHIMS IAW EA 97957, DEFECT SIZE: 24 INCHES.SDR UPS06448122Plate · damagedINSPECTION TYPE:C M/D LT BS 940 TENSION TIE FWD CHANNEL ATTACHED S/STEEL PLATE SHORT EDGE MARGIN AT I/B UPPER AND LOWER FASTENER HOLE. M/D LT BS 940 TENSION TIE FWD CHANNEL ATTACHED S/STEEL PLATE REPAIRED AS PER RS R53-25-35491. CONTINUE INSPECTION ARE REQUISDR UPS06448121Tension Tie · damagedINSPECTION TYPE:C M/D LT BS 940 FRAME TO TENSION TIE CONNECTION FOUND FASTENER HOLE OVAL AT TENSION TIE FWD CHANNEL. M/D LT BS 940 FRAME TO TENSION TIE FWD CHANNEL REPAIRED AS PER RS R53-25-35491. CONTINUE INSPECTION IS REQUIRED AS PER RS R53-25-35491 AND UPSDR UPS06448119Plate · damagedINSPECTION TYPE:C M/D LT BS 860 TENSION TIE FWD CHANNEL ATTACHED S/STEEL PLATE SHORT EDGE MARGIN AT I/B LOWER FASTENER HOLE. BS 860 LT TENSION TIE FWD CHANNEL ATTACHED S/STEEL PLATE AND ALUMINUM STRAP REPLACED AS PER RS R53-28-35574. CONTINUE INSP ARE REQUIRSDR UPS06448086Tension Tie · crackedINSPECTION TYPE:C M/D RT BS780 FRAME AT TENSION TIE CONNECTION FOUND 1 HOLE CRACK AT TENSION TIE AFT CHANNEL. CRACK LENGTH 1.25". M/D RT BS 780 TENSION TIE AFT CHANNEL REPAIRED AT O/B OF RT VERT POST TO RT MOST O/B AREA AS PER RS R53-25-35540. CONTINUE INSPESDR UPS06448069Doubler · crackedINSPECTION TYPE:C M/D RT BS920 FRAME AT TENSION TIE CONNECTION FOUND 1 HOLE CRACK AT WEB DOUBLER, CRACK LENGTH 0.040". M/D BS 820 RHS FRAME ATTACHED DOUBLER BETWEEN STR 9R TO STR 12R AREA REPLACED AND INSTALLED AS PER SRM 51-10-01 PG 9 AND 51-30-02 AND RS R53SDR UPS06448068Tension Tie · crackedINSPECTION TYPE:C M/D LT BS900 FRAME TO TENSION TIE CONNECTION FOUND CRACK AT TENSION TIE FWD CHANNEL 1 HOLE, CRACK LENGTH 0.030". M/D LT BS 900 TENSION TIE FWD CHANNEL REPAIRED AS PER RS R53-25-35559 CONTINUE INSPECTION IS REQUIRED AS PER RS R53-25-35559 ANDSDR UPS06448067Tension Tie · crackedINSPECTION TYPE:C M/D BS 900 LT SIDE TENSION TIE TO FRAME CONNECTION FASTENER HOLE FOUND CRACK AT AFT TENSION TIE. CRACK THROUGH THICKNESS. M/D BS 900 LT SIDE TENSION TIE AFTER CHANNEL REPAIRED AS PER RS R53-25-35559. CONTINUE INSPECTION IS REQUIRED AS PER SDR UPS06448065Tension Tie · crackedRT BS 900 FRAME AT TENSION TIE CONNECTION FOUND 1 HOLE CRACK AT TENSION TIE AFT CHANNEL, CRACK LENGTH 0.030". BS 900 FRAME ATTACHED TENSION TIE RT AFT CHANNEL CRACKED HOLE OVERSIZED TO 0.278" BY INCREMENT AS PER EO B747-5310-23715 APP D AND BOLT INSTALLED AS SDR UPS06447903Plate · damagedINSPECTION TYPE-C, M/D LT BS780 TENSION TIE FWD CHANNEL ATTACHED STANLESS STEEL PLATE 4EA HOLE OVAL AT OB AREA. M/D LT BS 780 TENSION TIE FWD CHANNEL ATTACHED STANLESS STEEL PLATE REPLACED AND INSTALLED IAW SRM 51-10-01PG9 AND EO B747-5310-23715 APPENDIX C.SDR ASAA0680844Beam · corrodedAFT CARGO BAY DOOR CUTOUT LOWER BEAM CORRODED. REPLACED BEAM PER SRM 51 10 4 51 30 2 AND 51 30 5.SDR USAA061036Door Frame · crackedFWD CARGO DOOR CUTOUT, AFT FRAME AT LOWER STOP PAD CRACKED. REMOVE DAMAGE, INSTALL FILLERS AND DOUBLERS IAW EA 97869, DEFECT SIZE: .275 INCH.SDR UPS06448120Plate · damagedINSPECTION TYPE:C M/D BS860 RT TENSION TIE FWD CHANNEL ATTACHED S/STEEL PLATE SHORT EDGE MARGIN AT I/B LOWER FASTENER HOLE AREA AND AT NR 12 COUNT FROM O/B UPPER ROW FASTENER HOLE. M/D BS 860 RT TENSION TIE FWD CHANNEL ATTACHED S/STEEL PLATE REPAIRED AND ALUMSDR UPS06448105Plate · damagedBS 940 RT TENSION TIE FWD CHANNEL ATTACHED S/STEEL PLATE SHORT EDGE MARGIN (SEM) AT I/B LOWER FASTENER HOLE AREA. BS 940 RT TENSION TIE FWD CHANNEL ATTACHED S/STEEL PLATE REPAIRED AS PER RS R53-25-35491. CONTINUED INSPECTIONS ARE REQUIRED AS PER RS R53-25-35SDR UPS06448070Plate · damagedINSPECTION TYPE:C M/D BS 820 RT TENSION TIE FWD CHANNEL ATTACHED S/STEEL PLATE SHORT EDGE MARGIN (SEM) AT I/B UPR FASTENER HOLE AREA. M/D BS 820 RT TENSION TIE FWD CHANNEL ATTACHED S/STEEL PLATE REPAIRED AS PER RS R53-25-35562. CONTINUE INSPECTION IS REQUIRESDR UPS06448066Plate · damagedBS 900 RT TENSION TIE FWD CHANNEL ATTACHED S/STEEL PLATE SHORT EDGE MARGIN (SEM) AT I/B UPPER 1 HOLE AND LOWER I/B 2 HOLE AREA. BS 900 RT TENSION TIE FWD CHANNEL ATTACHED S/STEEL PLATE REPAIRED AND ALUMINUM STRAP REPLACED AS PER RS R53-25-35559. CONTINUE INSSDR F3LA200600098Beam · corrodedDURING C-4 CHECK, INSPECTION REPORTED CORROSION AND HOLE THROUGH Y254 BEAM AT FR20 FWD ENTRY CENTER. FOUND CORRODED AREA TO BE OUT OF LIMITS PER SRM 53-11-14, FIG 104. CUT OUT AND REMOVED CORRODED SECTION FROM TOP FLANGE OF FLOOR SUPPORT PER SRM 53-11-14, FISDR SWAA062949Door Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO DOOR CUTOUT, FWD FRAME CRACKED AT NR 5 DOOR STOP. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR USAA061030Door Frame · crackedSTA 440 LOWER DOOR STOP O/B CORNER CRACKED. CUT OUT DAMAGE, INSTALLED DOUBLER REPAIR IAW EA 97905, DEFECT SIZE: .5 INCH.SDR USAA061029Door Frame · crackedFWD FRAME FWD CARGO DOOR CUTOUT CRACKED. REMOVED DAMAGE AND INSTALLED REPAIR PARTS IAW EA 97907, DEFECT SIZE: .50 INCH.SDR USAA061022Angle · wornRIGHT SKATE ANGLE AT VERT FIN HAS WEAR. INSTALLED REPAIR PARTS IAW TR 53-20-05A, DEFECT SIZE: 2 INCHES.SDR USAA061020Door Frame · crackedAFT CARGO, FWD DOOR FRAME, 3RD STOP PAD FTG DOWN FROM TOP AT FASTENER HOLE CRACKED. INSTALLED FACTORY NEW FRAME AND REINFORCING DOUBLER IAW SRM 51-10-02, DEFECT SIZE: .250 INCH.SDR SWAA062911Door Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FWD CARGO DOOR CUTOUT, FWD FRAME CRACKED AT NR 5 DOOR STOP. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR ASAA0640833Door Frame · corrodedAFT CARGO BAY DOORWAY FRAME CORRODED. REMOVED AND REPLACED FRAME PER SRM 51-40-02 AND DWG 65 47959.SDR ASAA0640832Retainer · corrodedCORROSION IN RIGHT AFT OVERWING EXIT LWR SEAL RETAINER. REMOVED AND REPLACED LWR SEAL RETAINER PER SRM 51-40-02.SDR QXEA200602046Stop Fitting · chafedPDX - C4 CARGO DOOR APERATURE TOP AFT STOP FITTING CHAFED/WORN. REPAIRED IAW RD 8-53-104.SDR QXEA200602043Stop Fitting · chafedPDX - C4 CARGO DOOR APERATURE TOP FORWARD STOP FITTING CHAFED/WORN. REPAIRED IAW RD 8-53-104.SDR QXEA200602042Stop Fitting · chafedPDX - C4 CARGO DOOR APERATURE BOTTOM FORWARD STOP FITTING CHAFED/WORN. REPAIRED IAW RD 8-53-104.SDR QXEA200602036Unknown · corrodedPDX - C4 MILD FRETTING CORROSION ON UNDERSIDE OF PANEL 261JT. REPAIRED IAW RD 8-53-3366 AND DHC-8-200 SRM 51-20-36.SDR QXEA200602035Unknown · corrodedPDX- C4 MILD FRETTING CORROSION ON UNDERSIDE OF PANEL 261GT. REPAIRED IAW RD 8-53-3366 AND DHC-8-200 SRM 51-20-36.SDR QXEA200602034Unknown · corrodedPDX - C4 MILD FRETTING CORROSION ON UNDERSIDE OF PANEL 261NT. REPAIRED IAW RD 8-53-3366 AND DHC-8-200 SRM 51-20-36.SDR MALA060501Door Frame · corrodedCOCKPIT DOOR POST, AT LBL 10.5 IS CORRODED OUT OF LIMITS. THE DAMAGE HAS BEEN REPAIRED IAW MESABA EO S53185. REF EAMS WORK ORDER 214210 TASK 1517.SDR QXEA200602037Structure · damagedPDX - C4 MULTIPLE STRAP BUCKLE NICKS ON LOWER LEFT FUSELAGE AT LOWER FORWARD CARGO DOOR CORNER. REPAIRED IAW DHC-8-200 SRM 51-40-11, 51-20-16 AND SRM 51-20-26.SDR USAA061013Door Frame · crackedAFT CARGO, FWD DOOR FRAME, 3RD STOP PAD FTG DOWN FROM TOP AT FASTENER HOLE. INSTALLED FACTORY NEW FRAME AND REINFORCING DOUBLER IAW SRM 51-10-02, DEFECT SIZE: .250 INCH.SDR Y2PA200600015Structure · corrodedCORROSION FOUND AT STATION 897, LONGERON 24L TO BE OUT OF LIMITS. REQUIRES ADDITIONAL REVIEW TO DETERMINE REPAIR.SDR SWAA062821Door Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FWD CARGO DOOR CUTOUT, AFT FRAME CRACKED AT LOWER DOOR STOP. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA062810Door Frame · corrodedDURING SCHEDULED 10Y CHECK, FOUND FWD CARGO DOOR CUTOUT, AFT FRAME CORRODED AT BS 492, RBL 26 TO RBL 37. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA062803Crease Beam · crackedDURING SCHEDULED 10Y CHECK, FOUND CREASE BEAM WEB CRACKED AT LT BS 188 TO LT BS 196, WL 207. REMOVED AND REPLACED CREASE BEAM WEB PER SRM.SDR UPS06847673Finger Doubler · corrodedFOUND CORROSION UNDER FINGER DOUBLER FLT DECK SUBFLOOR STA -67 TO -80 RBL-20. FABRICATED AND INSTALLED FINGER DOUBLER FLT DECK SUB FLOOR STA -67 TO -80 RBL-20 IAW SRM 53-03-01, AND SRM 51-1-20D.SDR AWXA200601446Crossbeam · corrodedSAL - FOUND CORROSION ON CROSSBEAM LOCATED FS 68 + 3" -Y 1292 PASSENGER CABIN RT SIDE. REPLACED CROSSBEAM LOCATED FS 68 TO FS 69 - Y 1292 PASSENGER CABIN RT SIDE IAW A319 51-72-11 PAGE 1-2.SDR TRAX200600570Support Beam · crackedENG SUPPORT BEAM AT LT FWD (LOWER) PNL CRACKED FROM BOLT TO EDGE OF PNL OPENING.SDR USAA061009Frame · corrodedFOUND CORROSION AT NUT PLATE HOLES, Y505 FRAME 12-14. DEFECTIVE PART REPLACED WITH IDENTICAL PART PER SRM 51-72-11; CORR TASK JA-220-53500; LEVEL 1 DEFECT SIZE: 1/8" BY 1/8"SDR QXEA200602041Nut Plate · corrodedPDX - C4 UPPER TCAS ANTENNA NUT PLATES CORRODED. REPLACED IAW DHC-8-200 SRM 51-40-11.SDR AWXA200601451Shear Plate · corrodedSAL - FOUND CORROSION ON PLATE LOCATED FS 69 TO FS 70 -Y 1732 PASSENGER CABIN RT WEB PLATE REPLACED FROM FS 69 TO FS 70 -Y 1732 IAW A319 SRM 51-72-11.SDR AWXA200601445Crossbeam · corrodedSAL - FOUND CORROSION ON CROSSBEAM LOCATED AT FS 67 + 13" - Y 1292 PASSENGER CABIN RT SIDE. REPLACED CROSSBEAM LOCATED FS 66 TO FS 68 -Y 1292 PASSENGER CABIN RT SIDE IAW SRM A319 51-72-11 PAGE 1-2.SDR 06FDEA2749Door Frame · crackedMAIN CARGO BAY, FWD SERVICE DOOR CUTOUT FWD FRAME IS CRACKED AT BS 380 RBL 65 WL 209. REPAIRED FRAME PER SRM 51-40-3.SDR SWAA062741Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO DOOR CUTOUT, AFT FRAME CRACKED AT NR 5 DOOR STOP. REMOVED AND REPLACED FWD FRAME SECTION PER SRM.SDR SWAA062740Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO DOOR CUTOUT, FWD FRAME CRACKED AT NR 5 DOOR STOP. REMOVED AND REPLACED FWD FRAME SECTION PER SRM.SDR SWAA062739Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND AFT CARGO DOOR CUTOUT, FWD FRAME CRACKED AT NR 5 DOOR STOP. REMOVED AND REPLACED FWD FRAME SECTION PER SRM.SDR USAA06998Door Frame · crackedFOUND FRAME CRACKED BS 492.4 S-24R AT DOORSTOP FOOTPRINT. CUT OUT DAMAGE, FABRICATED REPAIR DOUBLERS IAW EA 97947, DEFECT SIZE: .6".
Back to JASC 5310