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 FOTR2111712656Frame · dentedAFT CARGO COMPARTMENT HAS DENTS AT STA 1010 BETWEEN STR 25R AND 24R. REPAIRED ON FASI WO 21117, NR 12656.SDR FOTR2111712657Frame · dentedAFT CARGO COMPARTMENT- DENT ON FRAME STA 1030 BETWEEN STR 25R AND 24R. REPAIRED ON FASI WO 21117, NR 12657.SDR FOTR2111712661Frame · dentedAFT. CARGO COMPARTMENT- DENT ON FRAME AT STA 1010 AT STR 25L. REPAIRED ON FASI WO 21117, NR 12661.SDR FOTR2111712507Frame · dentedFWD CARGO COMPARTMENT- DENT AT STA 700 BETWEEN STR 23L AND 22L. REPAIRED ON FASI WO21117, NR 12507.SDR FOTR2111712341Frame · dentedFWD CARGO COMPARTMENT-DENT AT STA 520 LT, STR 23L. REPAIRED ON FASI WO 21117, NR 12341.SDR QXEA2011072500594Frame · corrodedFRAME X1.000 LOWER FLANGE HAS CORROSION BETWEEN STRINGERS 31P AND 32P. REMOVED CORROSION IAW RD 8/4-53-2344. MINIMUM REMAINING THICKNESS .048", CONFIRMED CRACK FREE REF NTM 51-00-02-250-801 AND 51-00-01-250-801. FOUND TO BE WITHIN LIMITS IAW RD 8/4-53-2344.SDR FDEA201107232921Frame · crackedRIGHT FRAME, BS 760.95 CRACK IN WEB PILOT HOLE. REPAIRED RT FRAME BS 760.95 IAW EO 7-5310-7-3367 PT 9.SDR FDEA201107232920Frame · crackedRT FRAME BS 760.95, CRACK IN 2ND HOLE ABOVE FLOOR AND CRACK IN 3RD HOLE ABOVE FLOOR. REPAIRED RT FRAME BS 760.95 IAW FED EX EO 7-5310-7-3367 PT9.SDR UIEA2011072300386Frame Splice · crackedA CRACKED HOLE WAS DETECTED ON THE RT BULKHEAD FRAME SPLICE FITTING. THE CRACK (APPROX. 0.03 INCH LONG) IS REMOVED BY OVERSIZING THE HOLE THROUGH THE STACKS TO 0.341 INCH. THE HOLE ON THE SPLICE FITTING ONLY IS OVERSIZED TO 0.505 INCH TO PROVIDE AN INSURANCE SDR FDEA201107232919Frame · damagedUPPER LOBE STRUCTURE FRAME HAS DOUBLED DRILLED HOLE AT STA 800 BET. STR 2L & STR 3L. FOUND TO BE OUT OF LIMITS IAW SRM-51-40-06, BETWEEN STR 2L-3L, CUT OUT DAMAGED FRAME AND INSTALLED SPLICES AND FRAME IAW SRM-53-00-07, REPAIR 3. MAJOR REPAIR "CAT B"SDR SWIA201130330Frame · corrodedC-CHECK, HEAVY CORROSION ON BOTTOM FRAME FS 364 LBL 18 TO RBL 18 FORWARD TOP FRAME. REPAIRED BOTTOM FRAME STATION FS 364 LBL 18 TO RBL 18 FORWARD TOP FRAME.SDR GLBA20110722HFrame · crackedMAJOR REPAIR - DURING A SCHEDULED ROUTINE INSPECTION MAINTENANCE FOUND A CRACK IN THE CARGO DOOR UPPER FRAME AT FS 509.50 BETWEEN STRINGERS 3L & 4L, 3.75" IN LENGTH. MAINTENANCE REPAIRED THE AFFECTED AREA AND PERFORMED ALL REQUIRED RII INSPECTIONS IAW EO 11-1SDR UIEA2011072200376Frame · crackedDURING THE PRESENT C4-CHECK, CRACKS WERE FOUND AT BS 480 SIDE BETWEEN S-27L AND S-28L. BOTH CRACKS WERE REPORTED AT 2 FASTENER HOLES RUNNING FWD WITH LENGTHS 0.25" AND 0.125" RESPECTIVELY. (CARRIED OUT A CATEGORY B REPAIR BASED ON SRM 53-30-03, FIG 1 (WITH SUSDR QXEA2011072700604Frame · corrodedFRAME X176.000 LOWER FLANGE HAS CORROSION ABOVE STRINGER 31P AND 32P. BLENDED CORROSION IAW RD 8/4-53-2344. BLEND FOUND TO BE WITHIN LIMITS IAW RD 8/4-53-2344. ALODINED, PRIMED, AND PAINTED IAW RD 8/4-53-2344.SDR QXEA2011072700603Frame · corrodedFRAME X28.000 LOWER FLANGE HAS CORROSION ABOVE STRINGER 25P JUST BELOW FWD LT PAX DOOR THRESHOLD. REMOVED CORROSION IAW Q400 51-21-00-00-01. MINIMUM REMAINING THICKNESS .037" FOUND TO BE OUT OF LIMITS IAW RD 8/4-53-2344. REMOVED CORRODED ANGLE IAW SRM 51-42-SDR QXEA2011072700602Frame · corrodedFRAME X8.000 LOWER FLANGE HAS CORROSION ABOVE STRINGER 25P JUST BELOW FWD PAX DOOR THRESHOLD. REMOVED CORROSION IAW RD 8/4-53-2344. MINIMUM REMAINING THICKNESS .043" FOUND TO BE OUT OF LIMITS IAW RD 8/4-53-2344. REMOVED CORRODED ANGLE IAW SRM 51-42-05-02-01SDR FDEA201107212882Frame · damagedDURING REMOVAL OF REPAIR ON FR 13 RAS/AS/305/95 ISSUE A, FRAME 13 FOUND DAMAGED. REPLACED ON EA 6-5315-150936.SDR QXEA2011072700601Frame · corrodedFRAME X19.400 LOWER FLANGES HAVE CORROSION BETWEEN STRINGER 30S AND 32S. REMOVED CORROSION FROM AFFECTED AREA IAW SRM 51-21-00-00-02 AND RD 8/4-53-2344. MINIMUM REMAINING THICKNESS .037" FOUND TO BE IN LIMITS OF RD 8/4-53-2344. TREATED, PRIMED AND PAINTED ISDR SWAA115293Frame · crackedDURING SCHEDULED 16Y CHECK FOUND, FRAME INNER CHORD CRACKED AT BS 296.4, STR 7R. REPAIRED CHORD IAW EO AND EA.SDR SWAA115292Frame · crackedDURING SCHEDULED 16Y CHECK FOUND, FRAME INNER CHORD CRACKED AT BS 616, STR 17L. REPAIRED CHORD IAW EO AND EA.SDR SWAA115282Frame · corrodedDURING SCHEDULED 16Y CHECK FOUND, FRAME CORRODED AT BS 727E BETWEEN STR 25L TO STR 27L. REPAIRED FRAME IAW EA AND DWG.SDR SWAA115280Frame · corrodedDURING SCHEDULED 16Y CHECK FOUND, FRAME CORRODED AT BS 727B, BETWEEN STR 27R TO STR 27L. REPAIRED FRAME IAW EA.SDR SWAA115279Frame · corrodedDURING SCHEDULED 16Y CHECK FOUND, FRAME CORRODED AT BS 500, STR 26R. REPAIRED FRAME IAW EA.SDR SWAA115278Frame · crackedDURING SCHEDULED 16Y CHECK FOUND, FRAME CRACKED AT BS 616, WL 230. REPAIRED FRAME IAW EA.SDR SWAA115275Frame · crackedDURING SCHEDULED 16Y CHECK FOUND, FRAME CRACKED AT BS 312, BETWEEN STR 23R TO STR 24R. REPAIRED FRAME IAW SRM.SDR IPXA11568125Frame · misinstalledINSPECTION TYPE:C-CK, MAIN CARGO COMPARTMENT FRAME AT STA 580 BETWEEN STRINGER 15R AND 14R FREE FLANGE HAS RIVETS WITH INSUFFICIENT SPACING. REPAIRED FRAME IAW EA 1107641R.SDR DU4R2011006Frame · corrodedAFT PIT BS 787 AT STR 29L AFT LOWER SIDE OF FRAME WEB CORRODED.SDR DU4R2011005Frame · corrodedAFT PIT CORROSION ON FRAME AT BS 767, STR 29L, FWD FACE.SDR QXEA2011072200587Frame · corrodedFRAME SECTION UNDER LOWER CARGO DOOR SEAL AT STA 765 HAS LIGHT CORROSION AROUND FASTENER HOLE. REMOVED CORROSION IAW SRM 51-21-00-00-02. CONFIRMED AFFECTED AREAS CRACK FREE CONDITION REF NTM 51-00-02-250-801. UT REMAINING THICKNESS MEASURED .063" REF NTM 51SDR QXEA2011072200586Frame · corrodedFRAME X94.800 LOWER FLANGES HAVE CORROSION BETWEEN STRINGERS 30P AND 32P. REMOVED CORROSION IAW RD 8/4-53-2344. MINIMUM REMAINING THICKNESS MEASURED .041". CONFIRMED CRACK FREE CONDITION REF NTM 51-00-02-250-801 AND 51-00-01-250-801. BLENDED AREA IS WITHISDR QXEA2011072200585Frame · corrodedFRAME X94.800 LOWER FLANGES HAVE CORROSION BETWEEN STRINGERS 30S AND 32S. REMOVED CORROSION IAW SRM 51-21-00-00-01. MINIMUM REMAINING THICKNESS MEASURED .039". CONFIRMED CRACK FREE CONDITION REF NTM 51-00-02-250-801 AND 51-00-01-250-801. BLENDED AREA IS WSDR QXEA2011072200584Frame · corrodedFRAME X116.000 LOWER FLANGES HAVE CORROSION BETWEEN STRINGERS 30S AND 32S. REMOVED CORROSION IAW RD 8/4-53-2344. MINIMUM REMAINING THICKNESS MEASURED .047". CONFIRMED CRACK FREE CONDITION REF NTM 51-00-02-250-801 AND 51-00-01-250-801. BLENDED AREA IS WITHISDR QXEA2011072200583Frame · corrodedFRAME X136.000 LOWER FLANGES HAVE CORROSION BETWEEN STRINGERS 30S AND 32S. REMOVED CORROSION IAW RD 8/4-53-2344. MINIMUM REMAINING THICKNESS MEASURED .044". CONFIRMED CRACK FREE CONDITION REF NTM 51-00-02-250-801 AND 51-00-01-250-801. BLENDED AREA IS WITHISDR QXEA2011072200582Frame · corrodedFRAME X156.000 LOWER FLANGES HAVE CORROSION BETWEEN STRINGERS 30S AND 32S. REMOVED CORROSION IAW RD 8/4-53-2344. MINIMUM REMAINING THICKNESS MEASURED .045". CONFIRMED CRACK FREE CONDITION REF NTM 51-00-02-250-801 AND 51-00-01-250-801. BLENDED AREA IS WITHISDR QXEA2011072200581Frame · corrodedFRAME X216.000 LOWER FLANGES HAVE CORROSION BETWEEN STRINGERS 30S AND 32S. REMOVED CORROSION IAW RD 8/4-53-2344. MINIMUM REMAINING THICKNESS MEASURED .046". CONFIRMED CRACK FREE CONDITION REF NTM 51-00-02-250-801 AND 51-00-01-250-801. BLENDED AREA IS WITHSDR QXEA2011072200575Frame · corrodedFRAME X216.000 LOWER FLANGES HAVE CORROSION BETWEEN STRINGERS 30P AND 32P. REMOVED CORROSION IAW SRM 53-23-44. MINIMUM REMAINING THICKNESS MEASURED .045". CONFIRMED CRACK FREE CONDITION REF NTM 51-00-02-250-801 AND 51-00-01-250-801. BLENDED AREA IS WITHIN SDR QXEA2011072200578Frame · corrodedFRAME X281.000 LOWER FLANGE HAS CORROSION BETWEEN STRINGERS 31S AND 32S. REMOVED CORROSION IAW SRM 8/4-53-2344. MINIMUM REMAINING THICKNESS MEASURED .045". CONFIRMED CRACK FREE CONDITION REF NTM 51-00-02-250-801 AND 51-00-01-250-801. BLENDED AREA IS WITHISDR QXEA2011072200579Frame · corrodedFRAME X413.000 LOWER FLANGE HAS CORROSION BETWEEN STRINGERS 30S AND 31S. REMOVED CORROSION IAW 51-21-00-00-02. MINIMUM REMAINING THICKNESS MEASURED .060". CONFIRMED CRACK FREE CONDITION REF NTM 51-00-02-250-801 AND 51-00-01-250-801. BLENDED AREA IS WITHINSDR QXEA2011072200576Frame · corrodedFRAME X258.500 LOWER FLANGES HAVE CORROSION BETWEEN STRINGERS 31S AND 32S. REMOVED CORROSION IAW SRM 8/4-53-2344. MINIMUM REMAINING THICKNESS MEASURED .044". CONFIRMED CRACK FREE CONDITION REF NTM 51-00-02-250-801 AND 51-00-01-250-801. BLENDED AREA IS WITHSDR QXEA2011072200574Frame · corrodedFRAME X196.000 LOWER FLANGES HAVE CORROSION BETWEEN STRINGERS 30P AND 32P. REMOVED CORROSION IAW SRM 51-21-00-00-02. MINIMUM REMAINING THICKNESS MEASURED .044". CONFIRMED CRACK FREE CONDITION REF NTM 51-00-02-250-801 AND 51-00-01-250-801. BLENDED AREA IS WSDR QXEA2011072200573Frame · corrodedFRAME X196.000 LOWER FLANGES HAVE CORROSION BETWEEN STRINGERS 30S AND 32S. REMOVED CORROSION IAW SRM 51-21-00-00-02. MINIMUM REMAINING THICKNESS MEASURED .046". CONFIRMED CRACK FREE CONDITION REF NTM 51-00-02-250-801 AND 51-00-01-250-801. BLENDED AREA IS SDR QXEA2011072200572Frame · corrodedFRAME X176.000 LOWER FLANGES HAVE CORROSION BETWEEN STRINGERS 30S AND 32S. REMOVED CORROSION IAW RD 8/4-53-2344. MINIMUM REMAINING THICKNESS MEASURED .044". CONFIRMED CRACK FREE CONDITION REF NTM 51-00-02-250-801 AND 51-00-01-250-801. BLENDED AREA IS WITHISDR QXEA2011072200564Frame · corrodedFRAME X341.000 LOWER FLANGES HAVE CORROSION BETWEEN STRINGERS 30P AND 31P. BLENDED CORROSION IAW RD 8/4-53-2344. MINIMUM REMAINING THICKNESS MEASURED .056". CONFIRMED CRACK FREE CONDITION REF NTM 51-00-02-250-801 AND 51-00-01-250-801. BLENDED AREA IS WITHISDR QXEA2011072200563Frame · corrodedFRAME X401.000 LOWER FLANGES HAVE CORROSION BETWEEN STRINGERS 31S AND 32S. BLENDED CORROSION IAW RD 8/4-53-2344. MINIMUM REMAINING THICKNESS MEASURED .064". CONFIRMED CRACK FREE CONDITION REF NTM 51-00-02-250-801 AND 51-00-01-250-801. BLENDED AREA IS WITHISDR QXEA2011072200562Frame · corrodedFRAME X401.000 LOWER FLANGES HAVE CORROSION BETWEEN STRINGERS 30P AND 32P. BLENDED CORROSION IAW RD 8/4-53-2344. MINIMUM REMAINING THICKNESS MEASURED .063". CONFIRMED CRACK FREE CONDITION REF NTM 51-00-02-250-801 AND 51-00-01-250-801. BLENDED AREA IS WITHISDR QXEA2011072200561Frame · corrodedFRAME FLANGE AT STA 489.5 RT STR 31 HAS CORROSION. BLENDED CORROSION IAW RD 8/4-53-2344. MINIMUM REMAINING THICKNESS MEASURED .055". CONFIRMED CRACK FREE CONDITION REF NTM 51-00-02-250-801 AND 51-00-01-250-801. BLENDED AREA IS WITHIN LIMITS OF RD 8/4-53-2SDR QXEA2011072200560Frame · corrodedFRAME X94.800 LOWER FLANGES HAVE CORROSION BETWEEN STRINGERS 30S AND 32S. BLENDED CORROSION IAW SRM 51-21-00-00-01. MINIMUM REMAINING THICKNESS MEASURED .039". CONFIRMED CRACK FREE CONDITION REF NTM 51-00-02-250-801 AND 51-00-01-250-801. BLEND IS WITHIN LSDR QXEA2011072200559Frame · corrodedFRAME X136.000 LOWER FLANGES HAVE CORROSION BETWEEN STRINGERS 30S AND 32S. BLENDED CORROSION IAW RD 8/4-53-2344. MINIMUM REMAINING THICKNESS MEASURED .044". CONFIRMED CRACK FREE CONDITION REF NTM 51-00-02-250-801 AND 51-00-01-250-801. BLEND IS WITHIN LIMITSDR QXEA2011072200558Frame · corrodedFRAME X216.000 LOWER FLANGES HAVE CORROSION BETWEEN STRINGERS 30S AND 32S. BLENDED CORROSION IAW RD 8/4-53-2344. REMAINING THICKNESS MEASURED .046". CONFIRMED CRACK FREE CONDITION REF NTM 51-00-02-250-801 AND 51-00-01-250-801. BLEND IS WITHIN LIMITS OF RDSDR QXEA2011072200557Frame · corrodedFRAME X94.800 LOWER FLANGES HAVE CORROSION BETWEEN STRINGERS 30P AND 32P. BLENDED CORROSION IAW RD 8/4-53-2344. REMAINING THICKNESS MEASURED .041". CONFIRMED CRACK FREE CONDITION REF NTM 51-00-02-250-801 AND 51-00-01-250-801. BLEND IS WITHIN LIMITS OF RD 8
Back to JASC 5311