JASC 5311
Service difficulty reports · 61,554
Reports filed under 5311 · Fuselage Main, Frame, 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 = '5311' 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 = '5311' 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 DHLA2009743DH560Frame · dentedUPPER FUSELAGE CARGO CABIN AT BS 720B BTWN S-16L AND S-17L FRAME WITH DENT. REPAIRED FRAME SECTION AT BS 720B BTWN S-15L AND S-17L IAW SRM 51-40-3 FIG 1.SDR DHLA2009743DH559Frame · damagedUPPER FUSELAGE CARGO CABIN BS 720D BTWN S-16L AND S-17L WITH HOLE. REPAIRED FRAME SECTION AT BS 720D BTWN S-15L AND S-17L IAW B727 SRM 51-40-3 FIG 1.SDR DHLA2009743DH558Frame · damagedUPPER FUSELAGE CARGO CABIN AT BS 720E BTWN S-16L AND S-17L FRAME WITH DOUBLE HOLE. REPAIRED FRAME SECTION AT BS 720E BTWN S-15L AND S-17L IAW B727 SRM 51-40-3 FIG 1.SDR DHLA2009743DH556Frame · dentedUPPER FUSELAGE CARGO CABIN AT BS 660 BTWN S-16R AND S-17R FRAME WITH DENT. REPAIRED FRAME SECTION AT BS 660 BTWN S-13R AND S-21R IAW B727 SRM 51-40-3 FIG 1.SDR DHLA2008743523Frame · damagedD-CHECK AT WO NR 5740, NR 5740-2-115, UPPER FUSELAGE PAX CABIN BS 620 BETWEEN STR 16R AND 17R FRAME WITH DOUBLE HOLE. REPAIRED FUSELAGE FRAME SECTION AT BS 620 BETWEEN STR 15R AND 17R DUE TO DOUBLE HOLE.SDR DHLA2008743528Frame · dentedD-CHECK, WO NR 5740, NR 5740-1-137 LOWER FUSELAGE AFT CARGO COMPARTMENT AT BS 970 STR 26L FRAME WITH DENT. REPAIRED FUSELAGE SECTION AT BS970 BETWEEN STR.25L AND 27L DUE TO DENT IAW SRM 51-40-3 FIG.1SDR DHLA2008743526Frame · damagedD-CHECK, WO NR 5740, NR 5740-2-85, UPPER FUSELAGE PAX CABIN STA 1090 BETWEEN STRINGERS 10 AND 11, 13 AND 14 RT FRAME INBD FLANGE WITH ENLONGATED HOLES. REPAIRED FUSELAGE FRAME SECTION AT BS1090 BETWEEN STR 10R AND STR 14R DO TO ELONGATED HOLES IAW SRM 53-10-4SDR DHLA2008743525Frame · dentedD-CHECK, WO NR 5350 NR 5350-2-98, UPPER FUSELAGE PAX CABIN AT BS 700 STR 16R AND 17R FRAME WITH DENT. REPAIRED FUSELAGE FRAME SECTION AT BS 700, BETWEEN STR 16R AND STR 17R DUE TO DENT IAW SRM 51-40-3 FIG.1.SDR DHLA2008743505Frame · damagedUPPER FUSELAGE CARGO CABIN AT BS 580 BETWEEN S-14R AND S-17R FRAME WITH DENT AND DOUBLE HOLE. REPLACED FRAME SECTION AT BS 580 BETWEEN S-12R AND S-18R DUE TO DOUBLE HOLES IAW B727SRM 51-10-1 PARA 7D.SDR MALA080196Frame · damagedFRAME DAMAGED AT STA 294 BETWEEN SL1617 AND SL1618. REPAIRED IAW EO NR S53152.SDR DHLA2009743DH562Frame · damagedUPPER FUSELAGE CARGO CABIN AT BS 910 BTWN S-4L AND S-5L FRAME WEB WITH DOUBLE HOLES. REPAIRED FRAME SECTION AT BS 910 BTWN S-2L AND S-7L IAW B727 SRM 53-10-4 FIG1.SDR DHLA2008743527Frame · damaged"D" CHECK, UPPER FUSELAGE PAX CABIN BS 1090 BETWEEN 13L & 14L FRAME I/B FLANGE WITH DOUBLE HOLES & DENT. REPAIRED FUSELAGE FRAME SECTION AT BS 1090 BETWEEN STR. 11L & STR.14L DUE TO DOUBLE HOLES & DENT IAW SRM 53-10-4 FIG.1SDR 2008UALA06439Frame · dentedAFT PIT FRAME DENTED STA 1540 AT STR 25R. MAJOR REPAIR ACCOMPLISHED. CUT OUT DAMAGED SECTION OF FRAME AND INSTALLED DOUBLER REPAIR.SDR 2008UALA06438Frame · dentedAFT PIT FRAME DENTED STA 1540 STR 22R. MAJOR REPAIR ACCOMPLISHED. CUT OUT DAMAGED SECTION OF PIT FRAME AND INSTALLED DOUBLER REPAIR.SDR AALA200810172Frame · crackedCRACK APPROXIMATELY 1 INCH IN LENGTH AT TOP OF OPENING FOR LEFT FORWARD OVERWING EXIT DOOR, FORWARD OF LATCH. STOP DRILLED AND DOUBLER INSTALLED PER SRM 53-05-00 FIGURE 32, SHEET 1.SDR AALA200810170Frame · crackedFRAME CRACKED AT 4 O`CLOCK POSITION STATION 1510, AT TAIL CONE ALIGNMENT PIN. INSTALLED DOUBLER PER ESO 80559 DATED 11/07/08.SDR 2008UALA06422Frame · dentedAFT PIT FRAME DENTED AT STA 1500, STR 25L TO 24L. MAJOR REPAIR ACCOMPLISHED. CUT OUT DAMAGED SECTION OF PIT FRAME AND INSTALLED DOUBLER REPAIR.SDR 2008UALA06421Frame · dentedAFT PIT FRAME DENTED STA 1580, STR 26R. MAJOR REPAIR ACCOMPLISHED. CUT OUT DAMAGED SECTION OF FRAME AND INSTALLED DOUBLER REPAIR.SDR 2008UALA06420Frame · dentedAFT PIT FRAME DENTED STA 1420, STR 25L TO 24L. MAJOR REPAIR ACCOMPLISHED. CUT OUT DAMAGED SECTION OF FRAME AND INSTALLED DOUBLER REPAIR.SDR 2008UALA06419Frame · dentedAFT PIT FRAME DENTED STA 1520 AT STR 21L - 22L. MAJOR REPAIR ACCOMPLISHED. CUT OUT DAMAGED FRAME SECTION AND INSTALLED DOUBLER REPAIR.SDR 2008UALA06418Frame · dentedAFT PIT FRAME DENTED STA 1400, STR 25L TO 24L. MAJOR REPAIR ACCOMPLISHED. CUT OUT DAMAGED SECTION OF FRAME AND INSTALLED DOUBLER REPAIR.SDR 2008UALA06417Frame · dentedAFT PIT FRAME DENTED STA 1360, STR 25R. MAJOR REPAIR ACCOMPLISHED. CUT OUT DAMAGED SECTION OF FRAME AND INSTALLED A DOUBLER REPAIR.SDR CALA0801043Frame · corrodedFRAME CORRODED STATION 907 AT S-27R. ROUTED OUT CORROSION FROM S-27R TO BL 0 STA 907 AND INSTALLED REPAIR PER SRM 53-00-07 FIG 201, REPAIR 10.SDR 08FDEA04789Frame · gougedMAIN CARGO DECK HAS GOUGE ON FRAME 47 3 INCH BELOW STR 12R BLENDED AREA IAW SRM 51-73-10, FOUND TO BE WITHIN LIMITS. PERFORMED HFEC IAW NTM 51-10-08 PT6, NO CRACK INDICATIONS NOTED. TREATED AND PRIMED IAW SRM 51-23-20.SDR 08FDEA04786Frame · gougedMAIN CARGO DECK HAS GOUGE ON FRAME 54 3 INCH BELOW STR.12L BLENDED AREA IAW SRM 51-73-10, FOUND TO BE WITHIN LIMITS. PERFORMED HFEC IAW NTM 51-10-08 PT6, NO CRACK INDICATIONS NOTED, TREATED AND PRIMED IAW SRM 51-23-20.SDR 08FDEA04785Frame · gougedMAIN CARGO DECK HAS GOUGE ON FRAME 54 3 INCHES BELOW STR 12R. BLENDED AREA IAW SRM 51-73-10, FOUND WITHIN LIMITS. HFEC IAW SRM 51-10-08 PT6, NO CRACKS FOUND. TREATED AND PRIMED IAW SRM 51-23-20.SDR 08FDEA04783Frame Splice · damagedMAIN CARGO DECK HAS DAMAGE ON FRAME 21 TRUSS SPLICE BETWEEN STR 8R AND STR 9R WITH SHEARED RIVETS ON STR 9R. REMOVED AND REPLACED TRUSS SPLICE AT FRAME 21 STR 8, STR 9, AND STR 13 IAW SRM 51-40-21. FABRICATED PARTS ON TRAVELERS T8/765472, T8/765399, T8/76547SDR DHLA2008745672Frame · crackedFRAME CRACKED IN FWD/LWR CARGO COMPARTMENT AT BS 600, BETWEEN STR 27R AND 28R. REMOVED, FABRICATED NEW FRAME SECTION, AND INSTALLED PER SRM 53-10-2 FIG 3, 51-10-1, AND 51-30-2, REF N/R 1-242.SDR CA081110003Spar · delaminated(CAN) DURING THE 6000 HOUR INSP DELAMINATIONS AND CRACKS WERE DISCOVERED ON THE SPAR BRIDGE. THE DELAMINATIONS AND CRACKS WERE FOUND ON THE RT SIDE ON THE AFT UPPER CORNER AT THE FILLET FROM BRIDGE TO SKIN INSIDE OF THE FUESLAGE AS VIEWED FROM THE GAS TANK ARESDR COMA0860458Frame · crackedLT FS 640 FRAME DOUBLER IS CRACKED BETWEEN STR 9 AND 12. REMOVED DAMAGED PARTS AND COMPLIED WITH MODIFICATION K601R36009-3 ON LT FS 640 FRAME AND DOUBLER PER SB601R-53-061 KIT DRWG. K601R36009 REV B AND 601R5361569 REV A.SDR COMA0860457Frame · crackedRT FS 640 FRAME DOUBLER IS CRACKED BETWEEN STR 9 AND 12. REMOVED DAMAGED PARTS AND COMPLIED WITH MODIFICATION K601R36009-4 ON RT FS 640 FRAME AND DOUBLER PER SB601R-53-061 KIT DRWG. K601R36009 REV B AND 601R5361569 REV A.SDR AALA200810151Frame · wornRIGHT FRAME 1497 WORN. INSTALLED DOUBLER ON 1497 FRAME PER SRM 53-10-00-15.SDR CALA0801037Frame · corrodedFRAME CORRODED AT STATION 807, S-25L TO S-27R. REMOVED AND REPLACED BOTTOM FRAME AT STATION 807 FROM STR 25 RT TO STR 23 LEFT PER SRM 51-40-02.SDR 2008UALA06401Frame · dentedAFT PIT FRAME DENTED STA 1340, STR 25L TO 24L. MAJOR REPAIR ACCOMPLISHED. CUT OUT DAMAGED FRAME SECTION AND INSTALLED DOUBLER REPAIR.SDR 08FDEA04769Frame · gougedMAIN CARGO DECK HAS DAMAGE ON FRAME 24 TRUSS SPLICE BETWEEN STR 8R AND STR 9R. REMOVED DAMAGED SPLICE IAW SRM 51-40-21AND REWORKED IAW SRM 51-26- 00, PERFORMED NDT CRACK TEST IAW NTM 51-10-08 PT 6. NO CRACK INDICATION NOTED, TREATED AND PRIMED IAW SRM 51-21SDR FDEA200811054763Frame · damagedAFTER REMOVAL OF DOUBLER FROM TV MONITOR SUPPORT AT BS 1000, FOUND SEVERAL HOLES IN FRAME. REMOVED DAMAGED SECTION OF FRAME, FABRICATED REPAIR PARTS AND INSTALLED REPAIR PARTS, BS 1000, S-5L-R, IAW SRM 53-00-07, REPAIR NR 3. THIS REPAIR IS CLASSIFIED AS A CAT.SDR 08FDEA04763Frame · damagedAFTER REMOVAL OF DOUBLER FROM TV MONITOR SUPPORT AT BS 1000, FOUND SEVERAL HOLES IN FRAME. REMOVED DAMAGED SECTION OF FRAME, FABBED REPAIR PARTS AND INSTALLED REPAIR PARTS, BS 1000, S-5L - S-5R, IAW SRM 53-00-07, REPAIR NR 3. THIS REPAIR IS CLASSIFIED AS A CSDR 08FDEA04762Frame · gougedMAIN CARGO DECK HAS GOUGE ON FRAME 28, 4.5 INCHES ABOVE STR 22L. REPAIR COMPLIED WITH ON EA 6-5310-123938.SDR 08FDEA04761Frame · gougedMAIN CARGO DECK HAS GOUGE ON FRAME 28, 1 INCH BELOW STR 19L. REPAIR COMPLIED WITH ON EA 6-5310-123938.SDR 08FDEA04759Frame · gougedMAIN CARGO DECK HAS GOUGE ON FRAME 28, 2.125 INCH BELOW STR 18L, REPAIR COMPLIED WITH ON EA 6-5310-123938.SDR 08FDEA04758Frame · gougedMAIN CARGO DECK HAS GOUGE ON FRAME 28, 3 INCHES ABOVE STR 18L. REPAIR COMPLIED WITH ON EA 6-5310-123938.SDR 08FDEA04751Frame · gougedMAIN CARGO DECK HAS GOUGE ON FRAME 28, 1 INCH ABOVE STR17 L. REPAIR COMPLIED WITH ON EA 6-5310-123938.SDR 08FDEA04743Frame · gougedMAIN CARGO DECK HAS GOUGE ON FR 28, 2.5 INCH ABOVE STR 14L. REPAIR COMPLIED WITH ON EA 6-5310-123938.SDR 08FDEA04741Frame · gougedMAIN CARGO DECK HAS GOUGE ON FRAME 28, 2.5 INCH ABOVE STR 21L. REPAIR COMPLIED WITH ON EA 6-5310-123938.SDR 08FDEA04738Frame · gougedMAIN CARGO DECK HAS GOUGE ON FR 28, 1 INCH ABOVE STR 20L. REPAIR COMPLIED WITH ON EA6-5310-123938.SDR 08FDEA04732Frame · bentMAIN CARGO DECK FR 59 BENT BELOW STR 13L 2 INCH TO 4 INCH. REWORKED THE UPPER FLANGE SECTION IAW SRM 51-26-00, PERFORMED HFEC INSPECTION IAW NTM 51-10-08 PT 6. NO CRACK INDICATIONS NOTED.SDR 08FDEA04731Frame · bentMAIN CARGO DECK HAS BENT FRAME 58 FROM STR 13L 4.5 INCH TOWARD STR 14L. REWORKED THE UPPER FLANGE SECTION IAW SRM 51-26-00, PERFORMED HFEC INSPECTION IAW NTM 51-10-08 PT 6. NO CRACK INDICATION NOTED.SDR CALA0801036Frame · crackedFRAME CRACKED AT STATION 360 ABOVE S-9L. REPAIRED FRAME PER EC/RA 5311-01430.SDR CALA0801035Frame · crackedFRAME CRACKED AT STATION 907 ABOVE S-9R. REPAIRED FRAME PER EA.5310-04498, OP 2.SDR 08FDEA04711Frame · gougedMAIN CABIN AT STA. 1600 BETWEEN STR2-5L HAS TOOLMARKS. REPAIRED FRAME BS 1600 S2-5L IAW SRM 53-00-07 REPAIR NR 1.THIS IS CATEGORY A REPAIR WITH NO FOLLOW-UP.
Back to JASC 5311