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 SWAA061649Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT FWD CARGO DOOR CUTOUT, AT NR 5 DOOR STOP FITTING. REPAIRED FRAME PER EA.SDR ASAA0640590Frame · corrodedFOUND CORROSION ON FRAME. INSTALLED REPAIR DOUBLER PER SRM 51 70 11.SDR ASAA0640578Frame · corrodedFOUND AFT CARGO FRAME HAS CORROSION. FABRICATED AND INSTALLED REPLACEMENT FRAME PER SRM 51 40 02.SDR A6WA200640199Frame · crackedLEFT SIDE FS 640 FRAME DOUBLER IS CRACKED IN RADIUS APPROX .6 INCH LONG AT WL 119, STRINGER 10L. MAINTENANCE REMOVED CRACKED DOUBLER AREA WAS MODIFIED AND REPAIRED WHILE INCORPORATING SB 601R-53-059 REV F.SDR A6WA200640198Frame · crackedRIGHT SIDE FS 640 FRAME DOUBLER IS CRACKED IN RADIUS APPROX .8 INCHES LONG AT WL 119, STRINGER 10R. MAINTENANCE REMOVED CRACKED DOUBLER AREA WAS MODIFIED AND REPAIRED WHILE INCORPORATING SB 601R-53-059 REV F. (M)SDR DHL2006754507Frame · corrodedAFT CARGO COMPT, FRAME AT STA 990 IS CORRODED ON FWD SIDE BETWEEN STR 29L - 28L. CUT AWAY CORRODED SHEAR TIE FROM FRAME STA 990 AT STR 29R IAW B727 SRM 53-10-4 FIG 12, FAB FILLER 1.0 X 4.1 7075.T0 .063 PO 9602827 AND SHEAR TIE 10 X 5 7075 0. PO 9002827 IAW B7SDR QXEA200601335Rivet · corrodedPDX: C3. CORROSION AROUND THE RIVETS ON THE LOWER FLANGE OF THE FRAME LOCATED ABOUT X47 BETWEEN STRINGER 29L AND 31L. MAINTENANCE REPAIRED IAW Q400 SRM 51-21-00, SRM 53-20-15, Q400 RD 8/4-53-017, NDTM PART 6, 51-00-01-250-801, SRM 51-42-00, SRM 51-42-05, EA 6SDR 2006UALA00947Frame · dentedRAMP REPORTS CARTS CONTACTED RT FUSELAGE RESULTING IN DENT.SDR UPS06847093Frame · crackedINSPECTION TYPE:C1 D-PIT STA 1340 BETWEEN L30R-31R FRAME CRACKED AND CORRODED. CUT OUT DAMAGED AREA STA 1340 FRAME BETWEEN L30R-L31R IAW 51-1-21D, FABRICATED AND INSTALLED REPAIR SPLICES AND FRAME SEGMENT AT STA 1340 BETWEEN L30R-L31R IAW SRM 53-02-00 FIG 2, SDR DU4R2006454Frame · wornFOUND WORN AREA ON FRAME AT FS 1401 ABOVE LONGERON 21 RIGHT. REPAIRED BY FABRICATING AND INSTALLING FRAME FLANGE REPAIR 20" X 9.0" FROM 7075-T6 .063 AND 13" X 1.0" X .600" FROM 7075-T6 .050" IAW DC-9/MD-80 53-03D PG 5 FIG 4, 53-01 AND 51-30-2.SDR 2006UALA00941Frame · crackedBODY STATIONS FRAMES ARE CRACKED, STA 380 STR 8R, STA 440 STR 8R, STA 867 STR 8R AND STA 827 STR 8L.SDR 2006UALA00937Frame · crackedFRAMES CRACKED AT STA 787 STR 8R, STA 907 STR 8L AND STA 907 AT STR 8R.SDR IXXA06SMN133SFrame · misdrilledDURING C CHECK, FOUND MAIN CARGO COMPT FRAME FLANGE HOLE MISDRILLED AT STA 200.000 BETWEEN LONGERONS 14 RT AND LONGERON 15 RT. PERFORMED MAJOR REPAIR IAW FAA FORM 8110-3 NR 06242 DATE 05-18-06, SEMAN DRAWING NR ED 4220 DATE 05-12-06. REMOVED DAMAGED CLIP, DCSDR IXXA06SMN117SFrame · crackedC CHECK, FOUND RT AFT LWR CARGO COMPART FRAME CRACKED 1" AT STA 1520.000 BETWEEN LONGERON 21 LT AND LONGERON 22 LT. PERFORMED MAJOR REPAIR IAW DC8 SRM 53-2-0 FIG 2 SHEET 5 TR 53-125 DATE 08-31-01. REMOVED FASTENERS IAW DC8 SRM 51-1-21, DC8 SRM 51-1-20D. TRISDR AWXA200600867Frame · crackedMCN - DURING C11 CHECK DISCOVERED FRAME CRACKED, .750 INCHES, AT FASTENER HOLE AT BS 1380, SEVEN INCHES ABOVE THE LOWER FORWARD CORNER OF AFT CARGO DOOR OPENING. MAINTENANCE REMOVED DAMAGED SECTION IAW BOEING 757-200 SRM 53-00-07-2R2. FABRICATED REPAIR PLATESDR 2006UALA00927Frame · crackedFOUND CABIN FRAME CRACKED BS 867 STR 8R.SDR 06FDEA1802Frame · dentedFOUND FRAME DENT AT BS 720 LBL 8 WL 156. REPAIRED FRAME BS 720 LBL 8 IAW SRM 51-40-3.SDR 06FDEA1795Frame · dentedFOUND FRAME AT BS 540 IS DENTED AND GOUGE BETWEEN STR 22-24LT. REPARIED FRAME PER SRM 51-40-3.SDR 06FDEA1794Frame · dentedFOUND FRAME AT BS 580 BETWEEN STR 22L-24L HAS DENT. REPAIRED FRAME PER SRM 51-40-3.SDR 06FDEA1792Frame · damagedFOUND AFT CARGO BAY DOUBLE HOLE IN FRAME WEB STA 990 2" ABOVE STR 26R. REPAIRED DOUBLE HOLE IN FRAME IAW FED EX EA 7-5310-100553.SDR UPS06846986Fitting · crackedINSPECTION TYPE:C1 FRAME FITTING CRACKED AT FS 832, RT SIDE 19 INCHES ABOVE FLOOR PLANE. REMOVED FITTING AT STA 832 IAW SRM 51-1-20D, FABRICATED AND INSTALLED FRAME FITTING AT FS 832 IAW SRM 51-1-20D, AND DWG 3779874.SDR UPS06846984Attach Fitting · crackedINSPECTION TYPE:C1 FRAME ATTACH FITTING CRACKED AT STA 1180 L17R. REMOVED CRACKED FITTING AT FRAME STA 1180 L17R IAW SRM 51-1-20D, DRILLED REPLACEMENT FITTING AND INSTALLED AT STA 1180 L17R IAW SRM 51-1-20D.SDR ASAA0640574Frame · gougedFOUND DEEP GOUGE ON RADIUS OF FRAME. REMOVED AND REPLACED FRAME PER SRM 51 40 02.SDR 06FDEA1779Frame · dentedFRAME AT BS 680 BETWEEN STR 24L - 25L HAS DENT. *S/D* REPAIRED FRAME PER SRM 51-40-3.SDR ABXA060181Frame · crackedFRAME CRACKED AT LOWER END FS 658, LEFT SIDE. INSTALLED REPAIR ANGLE P/N: 5924337-13 AND 5924337-23 IAW DC9 SRM 53-03.SDR ABXA060182Frame · crackedFRAME CRACKED AT LOWER END FS 639, LEFT SIDE. INSTALLED REPAIR ANGLE P/N: 5924337-11 AND 5924337-24 IAW DC9 SRM 53-03.SDR SWAA061576Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8R. REPAIRED FRAME SECTION PER SRM.SDR SWAA061575Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME SECTION PER SRM.SDR SWAA061574Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, AT STR 8L AND STR 8R. REMOVED AND REPLACED FRAME SECTIONS PER SRM.SDR SWAA061573Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, AT STR 8L AND STR 8R. REMOVED AND REPLACED FRAME SECTIONS PER SRM.SDR 06FDEA1748Frame · dentedMAIN DECK COMPARTMENT FRAME FOUND WITH DENT AT LT BS 1681, LONGERON 12L. DENTED AREA REPAIR CARRIED OUT AS PER SRM 53-30-00.SDR 06FDEA1747Frame · dentedMAIN DECK COMPARTMENT FRAME FOUND WITH DENT AT RT BS 1701, LONGERON 12R. DENTED AREA REPAIR CARRIED OUT AS PER SRM 53-30-00.SDR USAA060677Frame · crackedSTA 500A BETWEEN S-8R AND S-9R CRACKED. REMOVED CRACKED AREA, IAW TR 53-10-20D, DEFECT SIZE: .25 INCH.SDR USAA060665Frame · crackedSTA 440 DAMAGED. REMOVED DAMAGE AND INSTALLED REPAIR DOUBLER IAW 53-10-20D, DEFECT SIZE: .25 INCH.SDR AWXA200600859Frame · crackedMCN - DURING C19 CHCK DISCOVERED VERTICAL FRAME WEB CRACKED, .25 INCHES, AT BS 180, WL 180 AND BL 17.1L. MAINTENANCE REMOVED DAMAGED SECTION OF THE 17.1 VERTICAL WEB IAW BOEING 737-300 SRM 53-10-05-2R12. FABRICATED REPAIR WEB IAW BOEING 737-300 SRM 53-10-05-SDR ASAA0680564Frame · corrodedFOUND AFT CARGO BAY FRAME CORRODED. REPLACED DAMAGED SECTION WITH A REPAIR SPLICE PER SRM 53 03 FIG 2A.SDR CALA0600155Frame · crackedINSPECTION FOUND A .25 INCH CRACK IN LEFT MAIN FRAME BELOW MAIN DECK AT STA 616, LBL 60 TO LBL 61. THE MAIN FRAME WAS REPAIRED IAW ECRA 5311-01158.SDR SWAA061559Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 9L. REPAIRED FRAME SECTION PER SRM.SDR SWAA061558Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED BS 827, STR 9L. REPAIRED FRAME SECTION PER SRM.SDR SWAA061557Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME SECTION PER SRM.SDR SWAA061556Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 9L. REPAIRED FRAME SECTION PER SRM.SDR SWAA061555Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 9L. REPAIRED FRAME SECTION PER SRM.SDR SWAA061554Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 9R. REPAIRED FRAME SECTION PER SRM.SDR SWAA061553Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 9R. REPAIRED FRAME SECTION PER SRM.SDR SWAA061552Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 616, RBL 60, WL 200. REPAIRED FRAME SECTION PER ER.SDR 2006UALA00908Frame · damagedAFT PIT BODY FRAME UPPER FLANGE CHORD STRAP IS BROKEN OFF AT LAST FASTENER BS 727A RBL18 WL 154.SDR UPS06447030Strap · crackedINSPECTION TYPE:C M/D RIGHT BS 800 FRAME INNER FLANGE BETWEEN S26R-17R FOUND 1EA FASTENER LOCATION CRACKED AT FRAME STRAP. CRACK LENGTH 1.25 INCH. REPAIRED AS PER RS R53-10-35484 AND UPS EO B747-5310-24451-A.SDR UPS06447000Frame · crackedINSPECTION TYPE:C M/D LEFT BS 434 FRAME AT S26L FOUND 2EA HOLE CRACKED AT FRAME WEB AND AFT WEB DOUBLER. CRACK LENGTH 0.040 INCH. M/D LEFT BS 434 FRAME WEB & DOUBLER REPAIRED BETWEEN STR 23 TO STR 30 AREA AS PER SRM 53-10-04 FIG 99.SDR UPS06446978Frame · crackedINSPECTION TYPE:C M/D RIGHT BS434 FRAME S26R AREA FOUND 2EA HOLE CRACKED AT AFT WEB DOUBLER. CRACK LENGTH .125 AND .0625 INCH. M/D RIGHT BS 434 FRAME WEB DOUBLER REPAIRED AT BETWEEN STR 23 TO S30 AREA AS PER SRM 53-10-04 FIG 9.SDR UPS06446971Attach Bracket · crackedINSPECTION TYPE:C M/D BS 434 FRAME ATT BRACKET AT S26R FWD FOUND CRACKED. CRACK LENGTH .25 INCH. BRACKET REPLACED AS PER SRM 51-10-01 PG 9, 51-30-05 AND INSTALLED AS PER SRM 51-30-02.
Back to JASC 5311