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 IPXA3579094Frame · dentedINSPECTION TYPE:C-8, AFT CARGO LT SIDE FRAME DENTED BS 1460 STR 25L. REPAIRED DENTED FRAME IAW SRM 53-00-07-2R-5, FIG 201, DETAIL III.SDR IPXA3579093Frame · dentedINSPECTION TYPE:C-8, AFT CARGO LT SIDE FRAME DENTED BS 1600, STR. 25L. REPAIRED DENTED UPPER FLANGE OF FRAME IAW SRM 53-00-07-2R-5, FIG 201, DETAIL III.SDR IPXA3579045Frame · dentedINSPECTION TYPE:C8, AFT CARGO LT SIDE FRAME DENTED BS 1580 S25-26L. REPAIRED DENTED FRAME IAW SRM 53-60-07-2R AND 53-00-07-2R- 5, DETAIL III.SDR IPXA3579044Frame · dentedINSPECTION TYPE:C8, BULK CARGO COMPARTMENT FRAME DENTED BS 1500, STR 26R. REPAIRED FRAME IAW PF SRM 53-60-07-2R-1 AND 53-00-07-2R-5, DETAIL I.SDR IPXA3579038Frame · dentedINSPECTION TYPE:C-8, BULK CARGO COMPARTMENT FRAME DENTED AT BS 1560, STR 26-27R. REPAIRED DENTED FRAME IAW SRM 53-60-07-2R-1 AND 53-00-07-2R-5, DETAIL I.SDR FDEA201306181331Frame · dentedFRAME BS 1681, LONGERON 12L FOUND DENTED. REPAIRED IAW SRM 53-00-07 FIGURE 201 REPAIR 2 REVISION 52. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100 REVISION 116.SDR FDEA201306181329Frame · dentedFRAME BS 1701, LONGERON 12L FOUND DENTED. REPAIRED IAW SRM 53-00-07 FIGURE 201 REPAIR 2 REVISION 52. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100 REVISION 116.SDR FDEA201306181324Frame · chafedLEFT SUPPORT YOKE BS 535, LONGERON 21L FRAME FOUND CHAFED. REPAIRED IAW SRM 53-20-07 FIGURE 201 REPAIR 1 REVISION 52. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100 REVISION 116.SDR AALA20130618006Frame · dentedFRAME DENTED AT FORWARD PIT LT HAND SIDE BS 720 & STRINGER 24 LEFT. REMOVED DAMAGE & INSTALLED REPAIR ANGLE IAW SRM 51-40-09-0G & SRM 53-00-07-2R-5.SDR AALA20130618005Frame · damagedAFT PIT FRAME DENTED & PUNCTURE AT BS 1440 & STRINGER 25 LT. REMOVED DAMAGE & INSTALLED REPAIR SPLICE ANGLE & REPAIR STRINGER CLIP IAW SRM 53-00-07-2R-5 FIGURE 201 DETAIL III.SDR SWIA201333705Frame · corrodedC-CHECK, FRAME BS 985 CORRODED BETWEEN S23R AND 23L. BLENDED DAMAGE AND RESTORED FINISH INSTALLED FASTENERS.SDR CALA2013061900425Frame · crackedCABIN RT FUSELAGE FRAME HAS CRACK INDICATION AT STRINGER 8-9R BS 867 RT CABIN, REPAIRED IAW EC/RA 5310-05772.SDR DALA13029780978Frame · crackedA CRACK WAS FOUND AT LT SIDE TO FRAME AT BS 1497. REPAIR ACCOMPLISHED IAW ER/A 516104-14.SDR GLBA2013061800262Frame · crackedDURING A SCHEDULED ROUTINE INSPECTION, FOUND TWO CRACKS IN THE FUSELAGE FRAME ANGLE AT FS 150.00 & STRINGER 6L AT THE UPPER & LOWER A/S DOOR GAS STRUT MOUNT NUTPLATE AREA, 1" IN LENGTH. REPAIRED IAW EO 13-1900-53-046.SDR WRLA20130617596Frame · crackedCRACK AT BS 1265 RT FRAME WEB. ACCOMPLISH EA 10-5300-038, SECTION 3, INTERIM REPAIR. IAW DWG 624U0060 IN CONJUNCTION WITH IAI S/B 366-53-121. REPAIRED IAW EA: 10-5300-038, SECTION 3, REV. 0. CONDITION CHECKED NORMAL.SDR QXEA2013061701096Frame · corrodedAFTER REMOVAL OF JUNCTION BOXES AND RACKS TO WORK CORROSION ON THE UPPER FLANGE OF FRAME 32.4, FOUND LOWER FLANGE CORRODED STR 32P-31P. REMOVED CORROSION IAW SRM 51-42-05-02-01, 51-21-00-00-02 AND 53-00-00-02-09. FOUND OUT OF LIMITS IAW SRM 53-20-17-00-01. CSDR QXEA2013061701094Frame · corrodedFRAME 49.5 IS CORRODED BY STRINGER 31P. REMOVED CROSS BRACE, STRINGER CLIP AND STANCHION FOM IAW SRM 51-41-05-00-01 AND 51-42-05-02-01. STANCHION FOUND OUT OF LIMITS IAW SRM 53-20-43-00-01. FRAME FOUND OUT OF LIMITS IAW SRM 53-20-15-00-01. REMOVED FAME SEGSDR QXEA2013061701093Frame · corrodedFRAME 32.4, UPPER FLANGE IS CORRODED STR 31P-33. REMOVED CORROSION IAW SRM 51-42-05-02-01 AND 51-21-00-00-02. MIN THICKNESS NOTED .038" REF NTM 51-00-04-910-801 PT 1. FOUND OUT OF LIMITS IAW SRM 53-20-17-00-01. CONFIRMED CRACK FREE REF NTM 51-00-06-910-801,SDR CALA2013061700415Frame · crackedFRAME HAS CRACK INDICATION AT STRINGERS 8-9R, BS 400. FRAME REPAIRED IAW EC/RA 5310-05772.SDR CALA2013061700414Frame · crackedFRAME BETWEEN STRINGERS 8 AND 9L, BS 747, INBD FASTENERS HAS A CRACKED. FRAME REPAIRED IAW EC/RA 5310-05772.SDR SWAA2013070217860Frame · corrodedFRAME CORRODED AT BS 500B, BETWEEN STRINGER 28L TO STRINGER 28R. REPAIRED FRAME IAW SRM.SDR QXEA2013061601080Frame · corrodedFRAME 49.5, FLANGES ARE CORRODED STR 33-31S. REMOVED RIVETS FOM AND REMOVED CORROSION IAW SRM 51-42-05-02-01 AND 51-21-00-00-02. CONFIRMED CRACK FREE REF NTM 51-00-06-910-801, PT 1. APPLIED ALODINE AND PRIMER IAW SRM 51-21-10-02-01 AND 51-25-10-02-01. INSTSDR CALA2013061700423Frame · crackedMAIN CABIN AREA FRAME BS 500C CRACKED BETWEEN STRINGERS 8 - 9R, MFEC PROCEEDURE. REPAIRED FRAME IAW EA531 0-04716 REV E.SDR CALA2013061700412Frame · crackedMAIN CABIN AREA, FRAME BS 480 CRACKED BETWEEN STRINGERS 8 - 9R, MFEC PROCEDURE. REPAIRED IAW EA5310 -04176, REV E.SDR CALA2013061700411Frame · crackedMAIN CABIN AREA, FRAME BS 380 CRACKED BETWEEN STRINGERS 8 - 9R. REPAIRED IAW EA 53 10 -04716, REV E.SDR CALA2013061700410Frame · crackedMAIN CABIN AREA, FRAME BS 440 CRACKED BETWEEN STRINGERS 8 - 9L. REPAIRED FRAME IAW EA 53 10-04176, REV E.SDR SWAA2013072418540Frame · crackedFRAME OTBD CHORD CRACKED AT BS 727, STRINGER 18L. REPAIRED CHORD IAW EA.SDR SWAA2013072418539Frame · crackedFRAME OTBD CHORD CRACKED AT BS 727, STRINGER 18L, REPAIRED CHORD IAW EA.SDR USAA2013070800030Frame · distortedQ5 CHECK - DISTORTED HOLE IN FUSELAGE FRAME AT BS 787, S25R. REPAIRED FUSELAGE FRAME AT BS787, S25R IAW SRM 53-70-11-OG & EA 104910.SDR K11A2013061525001Frame · corrodedBS 950E PLUS 6 INCHES STUB FRAME CORROSION AFT SIDE BETWEEN 27-29R.SDR UALA2013061704169Frame · gougedA GOUGE AT STA 1640, ABOVE STR 9L. REPAIRED GOUGE AT BS1640 FRAME UPPER FLANGE APPROX 1.25" ABOVE STR 9L.SDR USAA2013061800015Frame · crackedQ4 CHECK - CRACK ON FUSELAGE FRAME AT BS312, S5L. REPAIRED FUSELAGE FRAME AT BS312, S5L IAW SRM 51-70-11-0G & EA 104882.SDR DALA1315410683Frame · dentedAFT CARGO FRAME DENTED ON THE UPPER FLANGE FWD RADIUS BETWEEN STRINGERS 26 AND 27L. REPAIRED IAW SRM 53-00-07, FIG 201, REPAIR 5, DETAIL I.SDR QXEA2013061501079Frame · corrodedFRAME 1.0 AFT SIDE IS CORRODED, STR 31P-32P. REMOVED CORROSION IAW SRM 51-21-00-00-02. MIN THICKNESS NOTED .046" REF NTM 51-00-04-910-801, PT 1. CONFIRMED CRACK FREE REF NTM 51-00-06-910-801, PT 1. APPLIED ALODINE AND PRIMER IAW SRM 51-21-10-02-01 AND 51-25SDR QXEA2013061501078Frame · corrodedFRAME 1.0 FLANGE IS CORRODED STR 31P-32P. REMOVED RIVETS AND CORROSION IAW SRM 51-42-05-02-01 AND 51-21-00-00-02. MIN THICKNESS NOTED .046" REF NTM 51-00-04-910-801 PT 1. CONFIRMED CRACK FREE REF NTM 51-00-06-910-801, PT 1. APPLIED ALODINE AND PRIMER, INSTSDR CALA2013061700409Frame · crackedMAIN CABIN AREA, FRAME BS 500A CRACKED BETWEEN STRINGER 8 - 9L. REPAIRED FRAME IAW EA 5310-04716, REV E.SDR CALA2013061700408Frame · crackedMAIN CABIN AREA, FRAME BS 400 CRACKED BETWEEN STRINGER 8 AND 9L , REPAIRED CRACKED AREA IAW EA 5310-04716, REV E.SDR SIMA20130615001Repair · crackedDURING HEAVY CHECK FOUND PREVIOUS REPAIR MATERIAL AT FRAME 23 BETWEEN STRINGER 15R AND STRINGER 16R CRACKED. THE ACFT WAS REMOVED FROM SERVICE. REPAIRED CRACK IAW AEA EO EM-53MR-1808. THE ACFT WAS RETURNED TO SERVICE.SDR SWAA2013072418537Frame · crackedFRAME OTBD CHORD CRACKED AT BS 727, STRINGER 18R. REPAIRED FRAME IAW EA.SDR FDEA201306141290Frame · misrepairedMAIN DECK CARGO BS 535, L19LT FRAME MISREPAIRED. REPAIRED IAW SRM 53-20-07, FIG 202, REPAIR 1, REV 52 EO 1-5100-7-5001, B3 PART 1. REPAIR CLASSIFIED MAJOR IAW GMM 6-2-100, REV 116.SDR FDEA201306141289Frame · misrepairedMAIN DECK CARGO BS 535, L24L FRAME MISREPAIRED. REPAIRED IAW SRM 53-20-07, FIG 201, REPAIR 1, REV 52, EO1-5100-7-5001, B3 PART 1. REPAIR CLASSIFIED MAJOR IAW GMM 6-2-100, REV 116.SDR UALA2013061404123Frame · crackedFRAME CRACKED BS 1160, LT AT TENSION TIE. R & R FRAME IAW SRM 51-40-02. MAJOR REPAIR.SDR FDEA201306141295Frame · corrodedFWD CARGO BS 760 S22-26L, FRAME CORRODED. REMOVED CORROSION IAW SRM 51-10-02. FOUND OUT OF LIMITS IAW SRM 53-00-07, FIG 101 DETAIL 2. REMOVED FRAME IAW SRM 51-40-02, LOCATED AND DRILLED IAW SRM 51-40-05. INSTALLED IAW SRM 51-40-02 AMD DWG 143N1017. MAJSDR USAA2013071500036Frame · crackedQ4 CHECK - CRACK ON FUSEALAGE FRAME WEB AT BS 727D, BETWEEN S27L TO S27R. REPAIRED IAW EA 104943.SDR ASOA2013071608669Frame · corrodedFRAME BS 605 CORRODED BETWEEN STRINGERS 26L AND 26R. REPAIRED IAW REO 601R-53-61-4938, REV, DATED 2013-06-19. MAJOR REPAIR.SDR UHLA2013061300239Frame · corrodedCORROSION ON LT FRAME 19 ON AND AROUND RIVETS. CUTOUT DAMAGE, FABRICATED REPAIR DOUBLER AND FILLER, INSTALLED.SDR DALA1315370683Frame · dentedDENT LOCATED ON THE INNER FREE FLANGE OF FUSELAGE FRAME BS 1440 ABOVE STRINGER 25. REPAIRED IAW SRM 53-00-07, FIG 201 REPAIR 5 DETAIL 3.SDR FDEA201306131284Frame · dentedAFT CARGO BAY BS 1400 S23L FRAME UPPER FLANGE DENTED. FRAME OUT OF LIMITS. R & R FRAME IAW SRM 51-40-02 AND DWG 146N1011. CLASSIFIED AS A CATEGORY A MAJOR REPAIR.SDR FDEA201306131281Frame · dentedAFT CARGO BAY RT SIDE BS 1340 S26R FRAME DENTED. FABRICATED NEW FRAME S24L TO 24R. INSTALLED NEW FRAME IAW SRM 51-40-02 & DWG 146N1008. MAJOR REPAIR.SDR ASOA2013071508651Frame · corrodedFRAME BS 349 CORRODED BETWEEN STRINGERS 26L AND 26R. REMOVED LOWER FRAME SECTOR IAW SRM 51-42-06 AND 51-42-21. LOCATED AND DRILLED NEW SERVICEABLE LWR FRAME SECTOR IAW SRM 51-40-11. INSTALLED NEW SERVICEABLE FRAME SECTOR LOWER IAW SRM 51-42-06 AND 51-42-21
Back to JASC 5311