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 DHL2006804532Frame · misdrilledMAIN CARGO COMPT FRAME 3EA MISDRILLED HOLES AT STA 260.000 L-10R. PERFORMED MAJOR REPAIR IAW FAA FORM 8110-3 DATED 01-31-06, DWG AA66-53-R05 REV IR DATED 01-16-06. CUT OUT DAMAGED SECTION AND FABRICATED REPAIR ANGLE (EXTRUSION BAC1505-1006477075T6511) FILLERSDR 06FDEA0517Frame · misdrilledBS 990 FRAME HAS A FIGURE 8 HOLE AT STR 5 RT. REPAIRED FRAME AT BS 990 IAW SRM 53-10-4.SDR 06FDEA0513Frame · corrodedCORROSION, UPPER FUSELAGE, BS 740 FRAME, AFT SIDE, STR 3L ATTACH CLIP HAS CORROSION. BS 740 FRAME, AFT SIDE STRINGER 3L CLIP CORROSION REMOVAL WITHIN LIMITS PER SRM 53-10-1.SDR SWAA060431Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE STUB FRAME CRACKED AT BS 188, STR 17R. REPAIRED FRAME PER SRM.SDR SWAA060430Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 9L. REPAIRED FRAME PER SRM.SDR AWXA200600432Frame · corrodedSAL - MAJOR REPAIR - DURING C11 CHECK DISCOVERED CORROSION ON FRAME AT BS 1540 FROM BL 14R TO BL 19R IN THE AFT CARGO COMPARTMENT. MAINTENANCE REMOVED CORROSION AND FOUND TO BE OUT OF SRM LIMITS. CUT OUT DAMAGED SECTION AND FABRICATED REPAIR PLATE AND SPLICESDR 2006UALA00185Frame · crackedCABIN FRAMES CRACKED BETWEEN STR 8R AND 9R AT STA 400, STA 787, STA 827, STA 867, STA 907 AND STA 927. REMOVED DAMAGE, ACCOMPLISHED A PERMANENT REPAIR PER MM 53-10-84 AND MM 53-11-99, INSTALLED REPAIR ANGLES AND FILLERS.SDR ASAA0610112Frame · dentedFUSELAGE FRAME DENTED AT SHEAR TIE LOCATION ABOVE STR 21L BS 440. FUSELAGE FRAME AT SHEAR TIE LOCATION ABOVE STR 21L, AT BSTA 440, REPAIRED IAW SRM 53-10-4, FIG 6.SDR QXEA200600532Rivet · missingYYC C3 FUSELAGE INTERIOR, HAS MISSING RIVET SIDE FRAME AT FUSELAGE STATION 797, STRINGER 13L. REPAIRED IAW CRJ700 SRM 51-42-21-001-001-A01.SDR ASAA0640092Frame · crackedFOUND DOUBLER ON FRAME CRACKED. REMOVED AND REPLACED DOUBLER PER SRM 51-40-05SDR ASAA0640091Frame · corrodedFOUND CORROSION ON FRAME. REMOVED AND REPLACED FRAME PER SRM 51-40-02.SDR 06FDEA0486Frame · dentedFRAME DENTED TWO PLACES BS 700 STR 22-25R. REPAIRED BS 700 FRAME IN TWO PLACES BETWEEN STR 22R - 23R AND BETWEEN S24R AND S25R IAW SRM 51-40-3.SDR 06FDEA0484Frame · dentedFRAME DENTED AT BS 580 BETWEEN STR 23L & STR 25L IN THE FWD CARGO COMPARTMENT. REPAIRED FRAME AT BS 580 BETWEEN STR 23L-25L IAW SRM 51-40-3.SDR SWAA060388Shear Tie · corrodedDURING SCHEDULED D CHECK, FOUND FUSELAGE SHEAR TIE CORRODED AT BS 500D, BETWEEN STR 26L TO STR 27L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR USAA060176Frame · corrodedY1292 10 INCHES AFT OF FRAME 66 CORRODED. PART REPLACED WITH SAME P/N PER SRM 51-72-11, DEFECT SIZE: 1 X 2 X .025 INCH.SDR USAA060177Frame · corrodedY1292 AT FRAME 68 CORRODED. PART REPLACED WITH SAME P/N PER SRM 51-72-11; CORROSION LEVEL 1; TASK JA-260-53500, DEFECT SIZE: 1 X 2 X .030 INCH.SDR USAA060188Frame · crackedBS 380 FRAME ABOVE STRINGERS 20L AND 21L CRACKED. REMOVED DAMAGE, FABRICATED AND INSTALLED PARTS IAW EA 97315, DEFECT SIZE: .50 INCH.SDR USAA060175Frame · corrodedY1292 AT FRAME 66 CORRODED. PART REPLACED WITH IDENT PART PER SRM 51-72-11; TASK JA-260-43500; CORROSION LEVEL 1, DEFECT SIZE: 1 X 2 X .030 INCH DEEP.SDR 06FDEA0468Frame · damagedFWD CARGO PIT AFT FRAME STA 959 IS DAMAGED FROM PREVIOUS REPAIR. REPAIRED FRAME IAW EA 8-5310-91333, FUSELAGE - FWD LOWER CARGO DOOR JAMB STA 959 CHORD AND SKIN - REPAIR AND DC10 SRM 51-39-01 PG 5 STEP 10 VOL II AND DC10 SRM 53-50-00 FIG 22 SHEET 9 VOL I.SDR AT0700069Frame · crackedLEFT CANTED FRAME HAS A CRACK STA 1178. INSTALLED ANGLE REPAIR ON LEFT CANTED FRAME AT STA 1178 LONG 16. MATERIAL USED 0.080 7075.0 10 .5" X 2.5" IAW B717 SRM 51-40-02 AND SRM 51-41-01. HEAT TREATED TO T-6 PER AVBORNE 98PMS.247PS.01.SDR SWAA060375Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 294.5, RBL 56, WL 208. REPAIRED FRAME PER SRM.SDR SWAA060374Shear Tie · corrodedDURING SCHEDULED D CHECK, FOUND FUSELAGE SHEAR TIE CORRODED AT BS 867, STR 24R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA060372Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 9R. REPAIRED FRAME PER SRM.SDR QXEA200600524Fastener · missingYYC C3 MAIN AVIONICS DOOR INTERNAL HAS MISSING FASTENER ON FRAME 5 INCHES FROM FORWARD END AND 4 INCHES FROM LEFT SIDE. REPAIRED IAW CRJ700/900 SRM 51-42-21-001-001-A01.SDR DHL2006804537Frame · corrodedAFT CARGO COMPT BILGE FORMER CORRODED STA 1180.000 L-35R. REMOVED FASTENERS IAW SRM 51-1-20D. REMOVED CORROSION FROM FORMER AT STA 1180.000 L-35R IAW SRM 51-1-8 PG 17-18. FOUND OUT OF LIMITS IAW SRM 53-2-0 PG 2P. CUT OUT CORRODED SECTION AND FABRICATED FORSDR 06FDEA0440Frame · damagedBS 640, RBL 3 WHILE WORKING CARD N00935 FOUND FRAME AT BS 640 RBL 3 DAMAGED. *S/D* REMOVED DAMAGE FROM FRAME, FABRICATED ALODINED PRIMED & INSTALLED REPAIR PER SRM 51-40-3.SDR 06FDEA0439Frame · dentedBS 640 RBL 13 WHILE WORKING CARD N00935 FOUND FRAME AT BS 640 RBL 13 DAMAGED. *S/D* REMOVED DAMAGE FROM FRAME, FABRICATED, ALODINED, PRIMED & INSTALLED REPAIR PARTS ON FRAME PER SRM 51-40-3.SDR 06FDEA0436Frame · dentedFRAME DENTED AT BS 660 STR 22R IN FWD CARGO COMPARTMENT. *S/D* REPAIRED FRAME AT BS 660 STR 22R IAW SRM 51-40-3.SDR 06FDEA0435Frame · dentedFRAME DENTED AT BS 680 BELOW STR 22L IN FWD CARGO COMPARTMENT. *S/D* REPAIRED FRAME AT BS 680 BELOW STR 22L IAW SRM 51-40-3.SDR 06FDEA0434Frame · dentedFRAME DENTED AT BS 600 BETWEEN STR 22L AND 25L FWD CARGO BAY. *S/D* REPAIRED DENT BS 600 BETWEEN STR 22L & 25L IAW SRM 51-40-3, SRM 51-10-1 FIG 1.SDR 06FDEA0432Frame · dentedN00519 FRAME DENTED AT BS 520 BETWEEN STR 22L AND STR 24L IN THE FWD CARGO COMPARTMENT. REPAIRED FRAME AT BS 520 BETWEEN STR 22L-STR 24L IAW SRM 51-40-3.SDR 06FDEA0425Frame · dentedAFT CARGO FRAME DENTED AT BS 1110 STR 25R. *S/D* CUT OUT DENTED SECTION OF BS 1110 FROM 25R-26R, 1 X 3 INCH. REPAIRED FRAME PER SRM 51-40-3 USING 7075-T6 .063 LOT 666612.SDR 06FDEA0433Frame · dentedFRAME DENTED AT BS 560 BETWEEN STR 24L & STR 25L FWD CARGO BAY. REPAIRED FRAME BS 560 FETWEEN STR 24L & STR 25L IAW SRM 51-40-3.SDR 06FDEA0428Frame · misinstalledBS 1010 FRAME HAS FASTENERS WITH INSUFFICIENT SPACING AT STRINGER 5 RIGHT. FABRICATED AND INSTALLED FRAME REPAIR BS 1010 STR 5R IAW SRM 53-10-4.SDR SWAA060354Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 9L. REPAIRED FRAME PER SRM.SDR SWAA060353Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 9L. REPAIRED FRAME PER SRM.SDR USAA060170Frame · corrodedFOUND CORROSION FRAME C66 - Y765 ATTACH HOLE. REMOVED AND REPLACED PER SRM 51-72-11, DEFECT SIZE: 1" BY 1" APPROX .040" DEEP.SDR SWAA060389Frame · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE FRAME CRACKED AT R1 DOOR CUTOUT, BS 291.5, STR 16R. MX FERRY TO DAL FOR REPAIRS. REPAIRED FRAME PER SWA EA.SDR 2006UALA00146Frame · crackedFRAME CRACKED AT STA 663.75 STR 2R UPPER LOBE. REMOVED CRACK, ACCOMPLISHED REPAIR PER SRM 53-00-07 REPAIR 9, INSTALLED REPAIR ANGLES AND FILLER.SDR ASAA0640068Frame · corrodedPAE: WHILE WORKING ON CARD NR 4989822, FOUND CORROSION ON FAIL SAFE ANGLE/ CHORD. REMOVED AND REPLACED FAIL SAFE CHORD IAW SRM. (K)SDR 06FDEA0417Frame · dentedN00608 AFT CARGO FRAME DENTED AT BS 1130, STR 26R. REPAIRED PER SRM 51-40-3.SDR 06FDEA0416Frame · dentedAFT CARGO FRAME DENTED AT BS 1110, STR 26L. REPLACED PER SRM 51-40-3, 51-10-2, 51-30-2.SDR 06FDEA0415Frame · dentedFRAME DENTED AT BS 500 BETWEEN STR 23R AND STR 24R IN THE FWD CARGO COMPARTMENT. DENTS IN FRAME AT BS 500 BETWEEN STR 23R & 24R IN FLANGE & RADIUS FOUND TO BE OUT OF LIMITS. REMOVED DAMAGED AREA FABRICATED REPAIR PARTS, ALODINED & PRIMED ALL WORK DONE IAW SRMSDR SWAA060340Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 9R. REPAIRED FRAME PER SRM.SDR SWAA060339Shear Tie · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE SHEAR TIE CORRODED AT BS 500C, BETWEEN STR 26R TO STR 27R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA060338Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 767, STR 9R. REPAIRED FRAME PER SRM.SDR SWAA060337Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 847, STR 9L. REPAIRED FRAME PER SRM.SDR SWAA060336Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 807, STR 9L. REPAIRED FRAME PER SRM.SDR USAA060156Frame · crackedFOUND FRAME CRACKED, BS 601 LBL 64.5. TRIMMED AND DRILLED FILLER IAW EA 97284 DEFECT SIZE: .250.SDR ASAA0640066Frame · damagedPAE: DAMAGED FRAME AT BSTA 500A, RBL 22, UNDER SIDE OF UPPER FLANGE. REPAIRED FRAME AT BSTA 500A, RBL 22, IAW SRM. (K)
Back to JASC 5311