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 SWAA075879Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 559, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075882Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA075874Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA075890Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 947 STR 18R AND STR 18L. REPAIRED FRAME PER SRM.SDR DHL2007742054Frame · dentedDENT, AFT PIT AT FRAME BS 1070 ABOVE STRINGER 26R. CUT OUT DAMAGED AREA APPROXIMATE DIMENSTION 1: BY 1: IAW B-727 SRM 51-40-2 FIGURE 1. FABRICATED FRAME REPAIR DOUBLER FROM 7075-0 0.071" PO NR 724711 APPROXIMATE DIMENSION 10" BY 4.5" IAW B-727 SRM 51-40-2 FISDR HEER118276Spar Cap · crackedFORWARD SPAR CAP ANGLE AT TOP OF THE DRIVESHAFT TUNNEL IS CRACKED AT TOP OF THE LAST LARGE HL64-8 PIN. CONTACTED MFG FOR 8110 REPAIR.SDR SWAA075855Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500D, STR 22R. REPAIRED FRAME PER SRM.SDR SWAA075847Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA075846Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075842Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 8L AND STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA075841Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 559, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075843Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L AND STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA075844Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075845Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 706, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA075853Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8L. REPAIRED FRAME PER SWA EA.SDR QXEA200801885Frame · corrodedPDX - C4 CHECK - CORROSION AROUND RIVET BUCKTAIL ON FORWARD SIDE OF FRAME AT STATION 704 AND Z133 LEFT BAY AFT OF AFT PASSENGER ENTRYWAY. BLENDED CORRODED AREA, INSPECTED, REMAINED WITHIN LIMITS AND NO CRACKS NOTED. RESTORED FINISH TO REPAIR AREA.SDR QXEA200701797Gusset · gougedPDX - C4 INSPECTION, AFT CARGO COMPARTMENT RIGHT FRAME X 819.102 GUSSET IS GOUGED AT Z113. BLENDED DAMAGED AREA AND FOUND TO BE WITHIN LIMITS IAW DHC-8-400 SRM 51-14-00. MATERIAL REMOVED .077. HFEC AREA NO CRACKS. ETCHED AND ALODINE AREA AND PAINTED.SDR USAA920071250Frame · crackedMCN - MAJOR REPAIR - C20 CHECK - CRACKED FRAME, BS 663, S3L - S3R. REPAIRED FRAME, BS 663, S3L - S3R IAW B737 SRM 53-00-07-2R-9 FIGURE 201.SDR USAA920071214Frame · crackedCLT - MAJOR REPAIR - C18 CHECK, CRACKED FRAME, BS 727E, S8L - S9L. REPAIRED FRAME, BS 727E, S8L - S9L IAW USAIRWAYS TYPICAL REPAIR 53-10-20E.SDR DHL2007742050Frame · corrodedEXFOLIATED CORROSION AFT PIT FRAME BS 1050 ABOVE STRINGER 22L ALSO ABOVE 21L. CUT OUT DAMAGED AREA (DIMENSION 4.5" BY 3.5"). FABRICATED REPAIR ANGLE FROM 7075-0 0.071" PO NR 7247111 (DIMENSION 15.25" BY 4.5") AND REPAIR FILLER FROM 7075-T6 0.063" PO NR 90059SDR 07FDEA04916Frame · crackedFWD PIT, PREVIOUS UNREPAIRED DAMAGE FRAME CRACKED AT BS 700 AND BETWEEN STR 18R AND 19R REPAIRED FRAME 700 AT STRINGER 18 TO19 RT REF FED EX EA NR 7-5310-113118 AND BOEING DWG 65-15938, 65-82614-9, 65-17664-50. TREATED AND PRIMED PARTS REF SRM 51-10-2. IDENTSDR 07FDEA04915Frame · crackedAFT PIT BODY FRAME WEB IS CRACKED AT TOOLING HOLE BS 970, STR 26L - 27L REMOVED ASSOCIATED PARTS TO FRAME 970 SECTION, REMOVED DAMAGE SECTION OF FRAME FROM STR 27R TO STR 24L AND 25L. FABRICATED NEW FRAME SECTION, HEAT TREATED, ALODINED AND PRIMED, PAINTED ANSDR 07FDEA04913Angle · corrodedAFT CARGO BS 970 LOWER FRAME ANGLE CRACKED BETWEEN STR 26L-27L REMOVED LOWER FRAME ANGLE. FABRICATED REPAIR ANGLE AND REINSTALLED LOWER FRAME REPAIR AND INSTALLED LOWER REPAIR ANGLE. REF SRM 51-40-3/ FIG NR 1/ PAGES 1-6 AND SRM 51-30-02. REPAIR IS CLASSIFSDR 07FDEA04910Frame · crackedFWD PIT, PREVIOUS UNREPAIRED DAMAGE FRAME CRACKED AT BS 720, STR 19R REPAIRED FRAME 720 BTW STR 18R AND 19R REF FED EX EA 7-5310-113119, SRM 51-40-3 FIG 1 SRM 51-30-2 PG 2 51-30-5 PG 1 BOEING DWG 65-82614-12, 65-17664-50. TREATED AND PRIMED REF SRM 51-10-2 PSDR USAA920071242Frame · crackedCLT - MAJOR REPAIR - C16 CHECK, CRACKED FRAME, BS 787, S8R - S9R. REPAIRED FRAME, BS 787, S8R - S9R IAW USAIRWAYS EA 100048 AND TYPICAL REPAIR 53-10-20E.SDR USAA920071240Frame · crackedCLT - MAJOR REPAIR - C16 CHECK, CRACKED FRAME, BS 847, S8L - S9L. REPAIRED FRAME, BS 847, S8L - S9L IAW USAIRWAYS EA 100048 AND TYPICAL REPAIR 53-10-20E.SDR 07FDEA04902Frame · crackedINT CAC CRACK ON FRAME. PERFORMED FRAME REPAIR IAW SRM 53-30-00 VOL I FIG 7.SDR SWAA075823Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER SWA EA.SDR USAA920071241Frame · crackedCLT - MAJOR REPAIR - C16 CHECK, CRACKED FRAME, BS 827, S9R. REPAIRED FRAME, BS 827, S9R IAW USAIRWAYS EA 100048 AND TYPICAL REPAIR 53-10-20E.SDR DL76S071528Frame · crackedFATIGUE CRACKS IN SKIN AND BULKHEAD CHORD STRAP AT FS 1725.5 AND S-7R. CUT OUT CRACKED MATERIAL AND INSTALLED DOUBLERS.SDR SWAA075824Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075806Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075807Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 597, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075808Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8R. REPAIRED FRAME PER SWA EA.SDR DHL2007742059Frame · crackedFUSELAGE STATION 303.9 FRAME WEB IS CRACKED AT STRINGER 15 WEB CUT OUT AND STRINGER 16 WEB CUT OUT AND CRACK INDICATION AT INBOARD CHORD WEB CUT OUT VERIFIED BY NDT. REMOVED CRACKED PARTS IAW B-727 SRM 51-30-2 AND SB727-53A-0153 REV 7. LOCATED AND DRILLED NESDR USAA920071244Frame · crackedCLT - MAJOR REPAIR - C16 CHECK, CRACKED FRAME, BS 663, S1R. REPAIRED FRAME, BS 663, S1R IAW USAIRWAYS EA 100046.SDR 2007UALA04775Frame · crackedFWD ENTRY DOOR LOWER FWD CORNER HAS CRACK IN FRAME. REPLACED LOWER FORWARD FRAME.SDR 07FDEA04880Frame · misrepairedDURING REPAIR ASSESSMENT PROGRAM AN EXISTING REPAIR ON FRAME CAP AT STA 840 BETWEEN LONG NR 50R AND 50L WAS FOUND NOT IN COMPLIANCE WITH APPROVED DATA. REPAIR HAS BEEN REPLACED WITH A NEW ONE IAW SRM 53-30-00, FIG 5, VOL I.SDR 07FDEA04877Frame · misrepairedDURING REPAIR ASSESSMENT PROGRAM AN EXISTING REPAIR ON FRAME CAP AT STA 879 BETWEEN LONG NR 47R AND 47L WAS FOUND NOT IN COMPLIANCE WITH APPROVED DATA. REPAIR HAS BEEN REPLACED WITH A NEW IAW SRM 53-30-00, FIG 5, VOL I.SDR 07FDEA04876Frame · misrepairedDURING REPAIR ASSESSMENT PROGRAM AN EXISTING REPAIR ON FRAME CAP AT STA 824 BETWEEN LONG NR 50R AND 50L WAS FOUND NOT IN COMPLIANCE WITH APPROVED DATA. REPAIR HAS BEEN REPLACED WITH A NEW ONE IAW SRM 53-30-00, FIG 5, VOL I.SDR 07FDEA04875Frame · misrepairedDURING REPAIR ASSESSMENT PROGRAM AN EXISTING REPAIR ON FRAME CAP AT STA 859 BETWEEN LONG NR 50R AND 50L WAS FOUND NOT IN COMPLIANCE WITH APPROVED DATA REPAIR HAS BEEN REPLACED WITH A NEW ONE IAW SRM 53-30-00, FIG 5, VOL I.SDR DHL2007742056Frame · dentedDENT AT FRAME BS 950D ABOVE STRINGER 26L. CUT OUT DAMAGED AREA IAW SRM 53-10-4 FIGURE 1. FABRICATED NEW FRAME REPAIR IAW SRM 53-10-4 FIGURE 1. HEAT TREATED FRAME REPAIR TO T6 CONDITION IAW FORM 1115 REV 11. LOCATED AND DRILLED NEW FRAME REPAIR IAW SRM 53-SDR DHL2007742053Frame · dentedDENT AFT PIT AT FRAME BS 1050 ABOVE STRINGER 26R. REMOVED FASTENERS AS REQUIRED FOR ACCESS IAW SRM 51-30-2. CUT OUT DAMAGED AREA DIMENSION 1" BY 1.5: AND FABRICATED REPAIR ANGLE IAW SRM 51-40-3 AND M/I 53-10-2 FIGURE 9. HEAT TREATED MATERIAL TO T6 0.071 COSDR DHL2007742018Frame · dentedDENT AT FRAME BS 950D ABOVE STRINGER 26L AFT PIT. CUT OUT DAMAGE AREA DIMENSION IAW B-727 SRM 53-10-4 FIGURE 1. FABRICATED NEW FRAME REPAIR IAW FORM FAS 1115 REV 11. LOCATED AND DRILLED NEW FRAME REPAIR IAW B-727 SRM 53-10-4 FIGURE 1 AND 51-30-5. TREATED ASDR 2007UALA04753Frame · dentedAFT PIT STA 1460 BETWEEN STR 25L AND 26L FRAME DENTED. REMOVED DAMAGED AREA, FABRICATED REPAIR, AND INSTALLED A NEW DOUBLER.SDR SWAA075754Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME PER SWA EA.SDR 07FDEA04857Frame · damagedDURING MODIFICATION MD10 TO ACF (ADVANCED COMMON FLIGHT DECK), AVIONIC COMPT AT STA 449 RT AND X= -10 FRAME WITH HOLE OVALIZED PERFORMED REPAIR FOR SRM 53-30-00 FIG 4 VOL I.SDR DHL2007742055Frame · dentedMULTIPLE DENTS AFT PIT FRAME BS 950F BETWEEN STRINGER 26L AND 25L. CUT OUT DAMAGED AREAS (2 EACH DIMENSION 1" BY 1"). FABRICATED REPAIR ANGLE FROM 7075-0 0.080" PO NR 9005665 (DIMENSION 17" BY 5.5") IAW B-727 SRM 53-10-2 FIGURE 5 AND 51-40-3 FIGURE 1. HEAT SDR USAA920071235Frame · crackedCLT - MAJOR REPAIR - C18 CHECK, CRACKED FRAME, BS 807, S8L - S9L. REPAIRED FRAME, BS 807, S8L - S9L IAW USAIRWAYS EA 100048 AND TYPICAL REPAIR 53-10-20E.SDR 2007UALA04729Frame · dentedAFT PIT FRAME STA 1520 STR 26L DENTED. MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGE. FABRICATED & INSTALLED REPAIR ANGLE.
Back to JASC 5311