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 0501406717Frame · corrodedDURING L-CHECK FOUND CORROSION ON FRAME LOWER CHORD AT BS 400 BETWEEN S40L AND S41L. REPAIRED PER EA 67-165239.SDR SWIA200515486Angle · crackedANGLE AT FS 640.00 CRACKED BETWEEN STR 9 AND STR 12L, ITEM FOUND AT ROUTINE INSPECTION. REPLACED LT SIDE REINFORCEMENT ANGLE AT FS 640 BETWEEN STR 9 AND 12 IAW SRM 51-42-06 AND 51-42-13.SDR SWAA052505Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE STUB FRAME CRACKED AT BS 188, RT SIDE, WL 208. REPAIRED STUB FRAME PER SRM.SDR 0501346717Frame · crackedDURING L-CHECK FOUND CRACKS IN FRAME AT BS 380 S24L. REPAIRED PER EA 67-165232.SDR 0501336717Frame · crackedDURING L-CHECK FOUND CRACK IN FRAME AT BS 400 S23L. REPAIRED PER EA 67-165233.SDR SWAA052487Shear Tie · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE SHEAR TIE CORRODED AT BS 947, RBL 18. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR CALA0500267Frame · crackedINSPECTION FOUND A .5 INCH CRACK IN LT MAIN FRAME BELOW MAIN DECK FLOOR AT STA 616, S18L TO S19L. A FILLER AND ANGLE REPAIR WAS INSTALLED IAW ECRA 5311-01158, PAGE 1-9.SDR USAA051022Frame · crackedBFM - Q2 - FLAME, 2.45 INCH LT, CRACKED FWD CARGO FRAME BS 500 BL 0. TRIM OUT CRACK, FAB REPAIR, INSTALLED DOUBLER IAW EA. (K)SDR 05FDEA02497Frame · bentFRAME BENT STA 1070 STR 25L - 2L. REMOVED DAMAGED AREA, FABRICATED REPAIR ANGLE, TREATED AND PRIMED, INSTALLED REPAIR IAW SRM 51-30-2, 51-40-3, 51-10-2.SDR SWAA052470Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CHORD CRACKED AT BS 616, LBL 65, WL 200. REPAIRED FRAME CHORD PER BFG ER.SDR ASAA0540395Frame · crackedCRACKED FRAME AT BIN RAIL STA 400. REPAIRED CRACKED FRAME AT BIN RAIL BSTA 400, STR 8L- 9L IAW SRM. (K)SDR ASAA0540394Frame · crackedCRACKED FRAME AT BIN RAIL STA 440. REPAIRED CRACKED FRAME AT BIN RAIL BSTA 440, STR 8L-9L IAW SRM. (K)SDR ASAA0540398Frame · crackedPAE - FOUND CRACKED FRAME AT BIN RAIL STATION 400 BETWEEN STRINGER 8R-9R. REPAIRED CRACKED FRAME AT BIN RAIL STATION 400 BETWEEN STRINGER 8R-9R IAW 737-400 SRM 53-00-07. (M)SDR ASAA0540397Frame · crackedPAE - FOUND CRACKED FRAME. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR IAW 737-400 SRM 53-00-07. (M)SDR ASAA0540396Frame · crackedPAE - FOUND CRACKED FRAME. REPAIRED CRACKED FRAME IAW 737-400 SRM 53-00-07. (M)SDR ASAA0540414Frame · corrodedCORROSION ON FRAME WEB BSTA 796, STR 24R. REMOVED CORROSION, OUT OF LIMITS AND REPAIRED IAW SRM. (K)SDR ASAA0540404Frame · crackedCRACKED FRAME AT BIN RAIL BSTA 360, BETWEEN STR 7L AND 8L. REPAIRED IAW SRM. (K)SDR ASAA0540403Frame · crackedCRACKED FRAME AT BIN RAIL BSTA 747, STR 4L AND BL 0. REPAIRED SRM. (K)SDR ASAA0540401Frame · crackedCRACKED FRAME AT BSTA 480 BIN RAIL, STR 8R-9R. REPAIRED IAW SRM. (K)SDR ASAA0540393Frame · crackedCRACKED FRAME AT BIN RAIL STA 440. REPAIRED CRACKED FRAME AT BIN RAIL BSTA 440, STR 8L - 9L IAW SRM. (K)SDR UPS05845421Spar · crackedINSPECTION TYPE:C1 RIGHT KEEL BEAM AT FS 857 2.5 INCH CRACK ON LWR SPAR. STOP DRILLED CRACK AT XCW 4.0 IAW SRM 51-1-20D NDT HFEC IAW NDTSPM 06-10-01.001 NO CRACKS NOTED BEYOND STOP DRILL. FABRICATED FILLERS VERTICAL FILLERS AND -136 ANGLE AND STIFFENERS AND ISDR MALA050657Frame · chafedDURING 4Y/2Y INSPECTION IN BNA, FOUND FRAME AT FS 464, RT SIDE IS CHAFED AND HAS BEEN REPAIRED IAW MESABA EO 53310.SDR UPS05845241Frame · crackedFRAME ON 62 DOOR OPENING IS CRACKED INSIDE OPENING RT SIDE. FAB`D DOUBLER AND REPAIRED IAW SRM 53-05-01 AND 51-1-21A.SDR 05FDEA02474Frame · damagedWHILE WORKING FED EX EA 7-5330-72293B PT2, FOUND DOUBLE HOLES IN FRAME AND C-CHANNEL AT 620 RBL 8 W/L 304. (OPEN)SDR 05FDEA02473Frame · damagedWHILE WORKING FED EX EA 7-5330-72293B PT2, FOUND FASTENER HOLES ON EDGE OF C-CHANNEL FRAME BS 620 STR 2 RT. REPAIRED PER SRM 53-10-1.SDR 05FDEA02472Frame · damagedWHILE WORKING FED EX EA 7-5330-72293B PT2, FOUND DOUBLE HOLE IN FRAME "C' CHANNEL AND SUPPORT AT BS 620 LBL 22 WL 300. REPAIRED C-CHANNEL, BS 620, LBL 22 PER FED-EX EA 7-5330-62327.SDR 05FDEA02471Frame · damagedWHILE WORKING FED EX EA 7-5330-72293B PT 2 FOUND DOUBLE HOLE IN FRAME 620 LBL 7 AND LBL 8 W/L 298. FRAME REPLACED PER FED-EX EA 7-5330-92326.SDR SWAA052462Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 20R. REPAIRED FRAME PER SWA EA.SDR SWAA052456Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE FRAME INNER CHORD CRACKED AT BS 348.2, STR 15L. REMOVED AND REPLACED INNER FRAME CHORD PER SRM.SDR SWAA052455Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 303, STR 10L. REPAIRED FRAME PER SWA EA.SDR IXXA05SMN181SFrame · corrodedDURING ROUTINE C-CHECK INSPECTION, FWD CARGO CMPT FRAME CORRODED, STA 80.000, L-26L. PERFORMED MAJOR REPAIR. REMOVED FASTENERS. REMOVED CORROSION. FOUND OUT OF LIMITS. REMOVED FRAME SEGMENT (CORRODED). PERFORMED NDT INSPECTION. NO CRACK, CORROSION FOUNDSDR IXXA05SMN180SFrame · crackedDURING ROUTINE C-CHECK INSPECTION, FWD ACCY CMPT- FRAME CRACKED, STA 55, L-24R. PERFORMED MAJOR REPAIR. REMOVED FASTENERS. TRIMMED OUT DAMAGED AREA. PERFORMED NDT INSPECTION. NO CRACK CORROSION FOUND AROUND TRIMMED AREA. FABRICATED NEW SEGMENT FRAME (EXTSDR 05FDEA02450Frame · crackedMAIN CABIN AT FRAME 46 LT CRACKED APPROX 4 INCHES.SDR 05FDEA02440Frame · unknownREPAIR LOCATED AT APPROX BS 1010 TO 1016 BETWEEN 23L AND 24L, PREVIOUS REPAIR AT STA 1010 TO 1016 BETWEEN STR 23L AND 24L NEEDS ENG EVALUATION TO DETERMINE IF MAJOR OR MINOR AND IF REPAIR IS IAW WITH FAA APPROVED DATA. NO ENGINEERING NEEDED. THIS REPAIR WAS SDR GTIA050236Frame · crackedFTW - AFT ACCY 3RD FROM AFT MAIN CANT FRAME WEB CRACKED AND ATTACHED ANGLE INSIDE CRACKED. CUT OUT DAMAGED AREA. FABRICATED REPAIR DOUBLER AND FILLER. TREATED, PRIMED AND INSTALLED REPAIR DOUBLER AND FILLER. (M)SDR SWAA052403Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 303.9, LBL 58, WL 216. REPAIRED FRAME PER BFG ER.SDR SWAA052402Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAMES CRACKED AT BS 360, BS 400, BS 440 AND BS 500A, STR 8R TO STR 9R. REPAIRED FRAMES PER SRM.SDR SWAA052401Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAMES CRACKED AT BS 380, BS 400 AND BS 440, STR 8L TO STR 9L. REPAIRED FRAMES PER SRM.SDR ASAA0540389Frame · corrodedYXX: DURING C-CHECK, FOUND FWD CARGO BILGE CORRODED ON FRAME AT BS 500D. REPAIRED IAW SRM. (K)SDR SWAA052384Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAMES CRACKED AT BS 787 AND BS 867, STR 8R TO STR 9R. REPAIRED FRAMES PER SRM.SDR SWAA052383Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAMES CRACKED AT BS 787 AND BS 867, STR 8L TO STR 9L. REPAIRED FRAMES PER SRM.SDR SWAA052382Frame · corrodedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 440, STR 23R TO STR 25R. REPAIRED FRAME PER SRM.SDR SWAA052381Frame · corrodedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 492.4, RBL 28. REPAIRED FRAME PER SRM.SDR SWAA052376Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 492, STR 24R. REPAIRED FRAME PER BFG ER.SDR SWAA052375Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE STUB FRAME CRACKED AT BS 188, LT SIDE, WL 208. REMOVED AND REPLACED STUB FRAME PER SRM.SDR 05FDEA02380Frame · dentedFORWARD CARGO BAY, FRAME IS DENTED AT BS 580 BETWEEN STRINGER LT 24 AND LT 23. REPAIRED PER SRM 51-40-3. [CLOSED]SDR ABXA050191Frame · crackedFRAME 1104 CANTED CRACKED AT LONGERON 14 RIGHT AND LONGERON 15 RIGHT. REMOVED AND REPLACED FRAME IAW DC-9 SRM 51-30-5.SDR 05FDEA02344Frame · crackedRIGHT DROOP L/E INTERNAL SIDE FOUND CRACKED FORMER ON UPPER EDGE AT XORS 299. REPAIR PER SRM 53-00-01 FIG 8 SHEET 1, 3, 4.SDR 05FDEA02338Frame · damagedRT SIDE AT STA 1119 FROM L NR 44 TO 50 FOUND 1EA NEW FRAME ABOUT 33 INCHES LONG WITH TWO SPLICE ANGLES. ACCOMPLISH REPAIR PER EA 8-5310-87669.SDR USAA050992Frame · crackedCLT, Q6 FRAME, 1.4 INCH CRACK, BS 616 RT BOTTOM OF FRAME INNER CHORD BS 616 RT. REMOVED DAMAGE, INSTALLED FILLER AND DOUBLER IAW TR 53-62-01. (K)
Back to JASC 5311