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 CALA0800729Frame · crackedFRAME CRACKED AT STATION 440 BETWEEN S8R AND S9R. REPAIRED CRACKED FRAME BODY STATION 440 BETWEEN S-8 AND S-9 RIGHT PER EC/RA 5310-04806.SDR C2X2008F00013Frame · corrodedACFT 560 WAS IN FOR A 3C INSPECTION AND CORROSION WAS FOUND ON THE FRONT FRAME FORWARD FLANGE THAT HAD HOLES 9,24,24 AND 40 THAT WERE GREATER THAN THE R/R MANUAL LIMITS. EC 7220-01056 AND TVF5284 WAS ISSUED APPROVING THE REPAIR OF THE DAMAGE AND CONTINUED OPESDR ASAA0843206Frame · gougedFWD PIT FWD FRAME GOUGED BS 440 RBL 28 REPAIRED PER SRM 51 40 02SDR CALA0800728Frame · crackedLEFT SIDE STATION 907 FRAME CRACKED BETWEEN S-8 AND S-9 AT AIR CONDITIONING (A/C) A/C BRACKET INBOARD HOLE. REMOVED A/C BRACKET, CUT OUT DAMAGED AREA & REPAIRED FRAME AT STATION 907 LEFT BETWEEN S-8 AND S-9 PER EA5310-04498.SDR CALA0800727Frame · crackedLEFT SIDE STATION 827 FRAME CRACKED BETWEEN S-8 AND S-9 AT AIR CONDITIONING (A/C) BRACKET INBOARD HOLE. REMOVED A/C RAIL BRACKET, CUT OUT DAMAGED AREA AND REPAIRED FRAME AT STATION 827 LEFT BETWEEN S-8 AND S-9 PER EA5310-04498.SDR 2008UALA03912Frame · dentedFUSELAGE DENT FRAME 30 STRINGER 25R. *S/D* ACCOMPLISHED MAJOR REPAIR AT LCQ. INSTALLED DOUBLER REPAIR PER SRM 53-21-11 FIG 215.SDR 2008UALA03894Frame · dentedDENT IN UPPER LEG (INBOARD FLANGE) OF FUSELAGE FRAME BS 540, LBL 36. *S/D* ACCOMPLISHED MAJOR REPAIR AT GSO. TRIMMED OUT DAMAGE TO FRAME INNER FLANGE AND REMOVED EXISTING PRODUCTION SPLICE, FABRICATED A REPAIR ANGLE AND INSTALLED.SDR 2008UALA03893Frame · dentedDENT IN UPPER LEG (INBOARD FLANGE) OF FUSELAGE FRAME BS 520, LBL 36. *S/D* ACCOMPLISHED A MAJOR REPAIR AT GSO. TRIMMED OUT DAMAGE TO FRAME INNER FLANGE, REMOVED EXISTING PRODUCTION SPLICE, FABRICATED AND INSTALLED A REPAIR J-ANGLE.SDR 2008UALA03890Frame · dentedFUSELAGE DENT FRAME 30 STRINGER 25R. *S/D* ACCOMPLISHED MAJOR REPAIR AT LCQ. INSTALLED DOUBLER REPAIR PER SRM 53-21-11.SDR SWAA083973Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA083974Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA083975Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA083976Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 597, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA083977Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA083978Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR 08FDEA02956Frame · damagedFOUND DAMAGED HOLE AT C 40, BETWEEN P 5-6 RT REPAIR PERFORMED BY ENLARGING THE HOLE TO 6MM. PERFORM NDT FOR CRACK FREE CONDITION AND INSTALLING HL11VF8/HL70-8 FASTENER IAW RAS/DAHAM/4025121/2008 ISS A , APPROVED BY EA 6-5315-120079.SDR SWIA200819948Frame · corrodedFOUND CORROSION ON FUSELAGE FRAME NEAR DOOR HINGE. REPAIRED DAMAGED AREA IAW CRJ200 SRM 51-42-06 AND 51-42-13.
SDR UPS08552888Frame · dentedINSPECTION TYPE-C2, DENT IN FRAME INNER FLANGE STA 1580 BETWEEN STR25L-26L REPAIRED IAW SRM 53-00-7-2R5 MPI NR 19801.SDR UPS08552883Frame · dentedINSPECTION TYPE-C2, AFT CARGO BAY DENT IN FRAME INNER FLANGE STA 1500 BETWEEN STR25R-26R. REPAIRED IAW SRM 53-00-07-2R5 MPI # P19802.SDR UPS08552882Frame · dentedINSPECTION TYPE-C2, DENT IN FRAME INNER FLANGE STA 1560 STR26L. REPAIR IAW SRM 53-00-07-2R5 MPI NR P19803.SDR CALA0800721Frame · crackedRIGHT SIDE STA 380 FRAME CRACKED BETWEEN S-8 AND S-9 AT AIR CONDITIONING (A/C) BRACKET INBOARD HOLE. REMOVED A/C RAIL BRACKET CUTOUT DAMAGED AREA AND REPAIRED FRAME AT STA 380 RT BETWEEN S-9 AND S-9 PER EA 5310-04498.SDR CALA0800719Frame · crackedLEFT SIDE STA 747 FRAME CRACKED BETWEEN S-8 AND S-9 AT AIR CONDITIONING (A/C) BRACKET. REMOVED A/C RAIL BRACKET CUTOUT DAMAGED AREA AND REPAIRED FRAME AT STA 747 LT BETWEEN S-8 AND S-9 PER EA 5310-04498.SDR CALA0800716Frame · crackedLEFT SIDE STA 787 FRAME CRACKED BETWEEN S-8 AND S-9 AT AIR CONDITIONING (A/C) BRACKET INBOARD HOLE. REMOVED A/C RAIL BRACKET CUT OUT DAMAGED AREA AND REPAIRED FRAME AT STA 787 LT BETWEEN S-8 AND S-9 PER EA 5310-04498.SDR SWAA083965Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 767, STR 13R. REPAIRED FRAME PER SWA EA.SDR SWAA083968Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 887, STR 21R. REPAIRED FRAME PER SRM.SDR SWAA083967Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 13R. REPAIRED FRAME PER SWA EA.SDR SWAA083966Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 767, STR 14R. REPAIRED FRAME PER SWA EA.SDR SWAA083950Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 663, STR 1 AND STR 2R. REPAIRED FRAME PER SRM.SDR CALA0800710Frame · crackedRIGHT SIDE STATION 747 FRAME CRACKED BETWEEN S-8 AND S-9 AT AIR CONDITIONING (A/C) BRACKET INBOARD HOLE. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR ANGLES IAW EA5310-04498.SDR CALA0800708Frame · crackedLEFT SIDE STATION 440 FRAME CRACKED BETWEEN S-8 AND S-9 AT AIR CONDITIONING (A/C) BRACKET INBOARD HOLE. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR ANGLES AT LEFT SIDE FRAME STATION 440 BETWEEN S-8 AND S-9 PER EA5310-04498.SDR CALA0800707Frame · crackedRIGHT SIDE STATION 787 FRAME CRACKED BETWEEN S-8 AND S-9 AT AIR CONDITIONING (A/C) BRACKET INBOARD HOLE. REMOVED AIR CONDITIONING (A/C) RAIL BRACKET IAW EA5310-04498. CUT OUT DAMAGED AREA OF FRAME IAW EA 5310-04498. INSTALLED REPAIR ANGLES IAW EA 5310-04498SDR CALA0800706Frame · crackedLEFT SIDE STATION 482 FRAME CRACKED BETWEEN S-8 AND S-9 AT AIR CONDITIONING (A/C) BRACKET INBOARD HOLE. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR ANGLES AT STATION 482 LEFT FRAME BETWEEN S-8 AND S-9 PER EA5310-04498.SDR CALA0800705Frame · crackedLEFT SIDE STATION 400 FRAME CRACKED BETWEEN S-8 AND S-9 AT AIR CONDITIONING (A/C) BRACKET INBOARD HOLE. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR ANGLES AT STATION 400 LEFT FRAME BETWEEN S-8 AND S-9 PER EA5310-04498.SDR SIMA200819905Frame · dentedDURING A HMBV INSPECTION, THE RT SIDE FUSELAGE FRAME AT FS 686.888 WAS FOUND DENTED. STRAIGHTENED THE FRAME FLANGE. PERFORMED NDT OF FRAME FLANGE, NO CRACKS NOTED. FABRICATED A REPAIR DOUBLER USING AL 2024-T3. DRILLED, TREATED AND INSTALLED REPAIR DOUBLER.SDR 08FDEA02892Frame · corrodedIN THE CAC, THE FUSELAGE FRAME LOWER ANGLE IS CORRODED ON THE AFT SIDE AT STA 1119 FROM LONGERON 40R TO 41 R. FUSELAGE FRAME IN THE CAC, LOWER ANGLE CORROSION AT STA 1119, LONGERON 40R TO LONGERON 41R. FOUND TO BE OUT OF LIMITS. REMOVED "J" CHANNEL AS PART SDR 08FDEA02890Frame · gougedIN CAC FUSELAGE FRAME LOWER ANGLE IS GOUGED/DENTED ON THE AFT SIDE AT STA 1119 FROM LONGERON 36R TO 40R. FUSELAGE FRAME IN THE CAC, LOWER ANGLE GOUGE/DENT AT STA 1119, LONGERON 36R TO LONGERON 40R. FOUND TO BE OUT OF LIMITS. REMOVED "J" CHANNEL AS PART OF TSDR CALA0800717Frame · crackedRIGHT SIDE STA 400 FRAME CRACKED BETWEEN S-8 AND S-9 AT AIR CONDITIONING (A/C) BRACKET INBOARD HOLE. REPAIRED FRAME AT STA 400 S-8 AND S-9 PER EA 5310-04498.SDR CALA0800712Frame · crackedRIGHT SIDE STA 440 FRAME CRACKED BETWEEN S-8 AND S-9 AT AIR CONDITIONING (A/C) BRACKET INBOARD HOLE. REPAIRED CRACKED FRAME AT STA 440 BETWEEN S-8 AND S-9 PER EA 5310-04498.SDR SWAA083940Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA083939Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 277, STR 16R. REPAIRED FRAME PER SWA EA.SDR SWAA083941Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA083915Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 767, STR 13R. REPAIRED FRAME PER SWA EA.SDR SWAA083917Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, STR 13R. REPAIRED FRAME PER SWA EA.SDR SWAA083916Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 13R. REPAIRED FRAME PER SWA EA.SDR 08FDEA02905Frame · corrodedAIR COND BAY HAS CORROSION ON UPPER SURFACE OF "T" ON FR 39 BETWEEN STR 50 AND STR 51 RT SIDE. REMOVED AND REPLACED "T" SECTION FROM STRINGER 53 RHS TO STRINGER 49 RHS. THE NEW "T" SECTION HAS BEEN SPLICED WITH ANGLE ON AFT FACE AND PLATE ON FORWARD FACE. ISDR USAA920081384Frame · corrodedCLT - Q3-MAJOR REPAIR - LEVEL 2 CORROSION ON FORWARD SIDE OF FRAME WEB AT BS 203.3 RBL 4. REPLACED FRAME WEB BS 203.3 RBL 4, IAW US AIRWAYS EA 100558. (A)SDR F3LA200800465Frame · corrodedDURING C-CHECK INSP NOTED AFT CARGO COMPARTMENT INSIDE OF C2 DOOR SHORT ANGLE PIECE AT FRAME C59 HAS CORROSION. MAINT REMOVED SHORT ANGLE PIECE APPLIED PROTECTION TREATMENT FABRICATED NEW SHORT ANGLE TREATED, PRIMED AND PAINTED AND INSTALLED IAW SRM 51-72-11, SDR 2008UALA03873Frame · corrodedR2 DOOR SILL CORROSION AT FASTENER HOLE FRAME 66. *S/D* ACCOMPLISHED MAJOR REPAIR AT LCQ. INSTALLED REPAIR PER SRM 53-41-14.SDR SWAA083903Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA083865Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.
Back to JASC 5311