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 QXEA2013022200455Frame · corrodedFRAME FLANGES AND WEB OF FR 94.8 STR 33-31S HAVE CORROSION. REMOVED CORROSION FROM NR 5 SEAT TRACK IAW SRM 51-21-00-00-02, REV 12. CONTINUED REMOVING CORROSION FROM SEAT TRACK NR 5 IAW SRM REV 12 53-20-49-02-02. MECHANICALLY MEASURED SEAT TRACK NR 5 DEEPESTSDR CALA2013022500126Frame · crackedFUSELAGE FRAME AT BS 867 BETWEEN STRINGER 8R AND 9R SHOWS CRACK INDICATION AT INNER FASTENER OF AIR CONDITION OUTLET SUPPORT ATTACHMENT BRACKET NOTED REF STEP 4 OF EA 5310-04716, DEV D OP 1. INSTALLED FRAME REPAIR AT STA 867 STRINGER 8R TO 9R IAW EA 5310 -0471SDR CALA2013022200123Frame · crackedFUSELAGE FRAME AT BS 747 BETWEEN STRINGER 8 AND 9L SHOWS CRACK INDICATIONS REPAIRED IAW EA5310-047 16, REV D.SDR CALA2013022200122Frame · crackedFUSELAGE FRAME AT BS 747, BETWEEN STRINGER 8-9R SHOWS CRACK INDICATIONS. REPAIRED FRAME STA 747 AT STR 8R AND 9R IAW EA 5310-04716, REV D, OP1 SEE FLEET CYCLE FOR ALL WORK PERFORMED.SDR CALA2013022200117Frame · crackedFUSELAGE FRAME BS 867 BETWEEN STR 8 AND 9L HAS A CRACK INDICATION. REPAIRED IAW EA 5310-04716, REV D, OP 1.SDR ASOA20130222266Frame · corrodedFRAME 65, LOWER EXTERNAL SURFACE HAS 2 AREAS OF CORROSION ADJACENT TO LOWER BAGGAGE DOOR GUIDE. REMOVED CORROSION, FABRICATED AND INSTALLED DOUBLER.SDR SWAA2013040814500Frame · crackedRIGHT BS 715 FRAME CRACKED. REMOVED AND REPLACED FRAME IAW SRM.SDR SWAA2013040814499Frame · crackedRIGHT BS 696 FRAME CRACKED. REMOVED AND REPLACED FRAME IAW SRM.SDR SWAA2013040814498Frame · crackedLEFT BS 715 FRAME CRACKED. REMOVED AND REPLACED FRAME IAW SRM.SDR SWAA2013040814497Frame · crackedLEFT BS 696 FRAME CRACKED. REMOVED AND REPLACED FRAME IAW SRM.SDR SWAA2013032013878Frame · corrodedFRAME CORRODED AT BS 974, BETWEEN L28R - L30L. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA2013031813742Frame · crackedFRAME CRACKED AT BS 696, RBL 54.5. REMOVED AND REPLACED FRAME IAW DWG AND SRM.SDR SWAA2013031813731Frame · crackedFRAME CRACKED AT BS 674, STR 2L. REMOVED AND REPLACED FRAME IAW SRM.SDR SWAA2013030813486Frame · crackedFUSELAGE FRAME CRACKED AT STA 674, LBL 54.5. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA2013030613374Frame · crackedFUSELAGE FRAME CRACKED AT BS 727B, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2013030613373Frame · crackedFUSELAGE FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2013030613372Frame · crackedFUSELAGE FRAME CRACKED AT BS 480 STR 8R. REPAIRED FRAME IAW EA.SDR QXEA2013022100511Spar · chafedCENTER WING FRONT SPAR UPPER CAM LOC RECEPTACLE FLANGE BETWEEN RT WING STA YW45 AND RT STA YW60 IS CHAFED. SMOOTHED CHAFE DAMAGE IAW SRM 57-10-05-02-01, REV 12, CONFIRMED AFFECTED AREAS CRACK FREE REF NTM 51-00-04-910-801 PTI 051-00-06-910-801, PT 1, REV 7. SDR QXEA2013022100510Spar · chafedCENTER WING FRONT SPAR UPPER CAM LOC RECEPTACLE FLANGE BETWEEN LT WING STA YW45 AND LT STA YW60 IS CHAFED. SMOOTHED CHAFE DAMAGE IAW SRM 57-10-05-02-01 R12. CONFIRMED AFFECTED AREAS CRACK FREE REF NTM 51-00-04-910-801 & 51-00-06-910-801, PT 1, REV 7. FOUNDSDR SWAA2013030413243Frame · crackedFUSELAGE FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2013030413301Frame · crackedFUSELAGE FRAME CRACKED AT AIR CONDITIONING BRACKET A ATTACHMENT BS 520, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2013030413300Frame · crackedFUSELAGE FRAME CRACKED AT AIR CONDITIONING BRACKET ATTACHMENT BS 400, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2013030413299Frame · crackedFUSELAGE FRAME CRACKED AT AIR CONDITIONING BRACKET ATTACHMENT BS 500C, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2013030113212Frame · crackedFUSELAGE FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2013030113211Frame · crackedFUSELAGE FRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2013030113210Frame · crackedFUSELAGE FRAME CRACKED AT BS 727D, STR 8R. REPAIRED FRAME IAW EA.SDR CALA2013022200121Frame · crackedFUSELAGE FRAME AT BS 727B BETWEEN STRINGER 8 AND 9R SHOW CRACK INDICATIONS AT INNER FASTENER OF AIR CONDITION OUTLET SUPPORT ATTACHMENT BRACKET. FABRICATED AND INSTALLED REPAIR FRAME AND DOUBLER AT STA BETWEEN STRINGER 8R AND 9R IAW EA 5310-04716, REV D.SDR QXEA2013022100398Frame · corrodedFRAME FLANGES AT FR 176 STR 32-30P HAVE CORROSION. REMOVED 1 EA RIVET TO FOM AND REMOVED CORROSION IAW SRM 51-42-05-02-01, 53-00-00-02-09 REV 12 AND DISPLACED WIRES IAW AMM 20-30-26-910-801, REV 40. PRIOR TO CORROSION REMOVAL REMOVED AN ADDITIONAL 6 RIVETS ISDR QXEA2013022100396Frame · corrodedFRAME FLANGES AT FR 94.8 STR 32-29P HAVE CORROSION. REMOVED 16 RIVETS TO FAM IAW SRM 51-42-05-02-01, REV 12, REMOVED CORROSION IAW SRM 51-21-00-00-02, REV 12. VERIFIED AFFECTED AREA TO BE CRACK FREE, REF NDTM PT 6, TASK 51-00-01-250-801, REV 8. MINIMUM TSDR QXEA2013022100395Frame · corrodedFRAME FLANGE OF FR 94.8 STR 31S HAS CORROSION. REMOVED 12 RIVETS TO FOM IAW SRM 51-42-05-02-01, REV 12, REMOVED CORROSION IAW SRM 51-21-00-00-02, REV 12. VERIFIED AFFECTED AREAS TO BE CRACK FREE REF NDTM PT 6, TASK 51-00-01-250-801, REV 8. MIN THICKNESS REMSDR NACA20130221019Beltframe · corrodedCORROSION ON BELT FRAME ATTACH BS 328 S27R. CORROSION ON BELTFRAME ATTACH STA 328 STR 27R REMOVED AND FOUND TO BE BEYOND LIMITS. REPAIRED IAW B737200 SRM 53104 FIGURE 6 PG 1315 REV 105.SDR SWAA2013022813173Frame · crackedFRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2013022813172Frame · crackedFRAME CRACKED AT BS 727B, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2013022813171Frame · crackedFRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2013022713142Frame · crackedFUSELAGE FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2013022713141Frame · crackedFUSELAGE FRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2013022713140Frame · crackedFUSELAGE FRAME CRACKED AT BS 727D, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2013022713139Frame · crackedFUSELAGE FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME IAW EA.SDR DALA13008670990Frame · corrodedFOUND CORROSION ON S 1212 FRAME FROM LONGERON 26R TO LONGERON 28R AFT FACE. NO PREVIOUS BLEND OUT MRB 53-019-02. COMPLIED WITH STEPS OF DELTA PRI ER/A 508143-14, REV O.SDR DALA13008660990Frame · corrodedFOUND CORROSION ON BS 1155 FRAME LONGERON 26R FORWARD FACE. COMPLIED WITH ALL STEPS OF PRI ER/A 508143-14 REV O.SDR CALA2013022200120Frame · crackedFUSELAGE FRAME AT STA 400, BETWEEN STRINGER 8L AND 9L SHOWS CRACK INDICATION AT INNER FASTENER OF AIR CONDITIONING OUTLET SUPPORT ATTACHMENT BRACKET. REF STEP 4 OF EA 5310-04716, REV D, OP 1 REPAIRED AS EA 5310-04716, REV D, OP 1 SEE FLEET CYCLE FOR ALL WORK SDR CALA2013022200119Frame · crackedFUSELAGE FRAME AT BS 480 BETWEEN STRINGER 8L AND 9L SHOWS CRACK INDICATION AT INNER FASTENER OF AIR CONDITIONING OUTLET SUPPORT ATTACHMENT BRACKET. NOTE, REF STEP 4 OF EA 5310-04716 RED OP 1 REPAIRED IAW EA 5310-04716, REV D, OP1 SEE FLEET CYCLE FOR ALL WORK SDR UALA2013022101043Frame · crackedTENSION TIE FAILSAFE CHORD CRACKED AT 2 FASTENER HOLES, BS 1140 LT. MAJOR REPAIR ACCOMPLISHED. CUT OUT DAMAGED AREA. SPLICED IN NEW SECTION OF FRAME SEGMENT PER SRM 53-40-07, REPAIR 2.SDR AALA20130221011Frame · corrodedWING TO BODY ATTACH FRAME STATION 1200, RIGHT BUTTLINE 40 IS CORRODED. INSTALLED NEW FRAME PER B757 SRM 51-40-02 AND AARD 51-00-05-1.SDR CA130221003Frame · cracked(CAN) UPON TAKING OFF, NOTICED SOMETHING WAS NOT FEELING RIGHT. LANDED AGAIN, SOMETHING DID NOT FEEL RIGHT. WHEN I GOT TO THE DOCK, I ASKED THE DOCK HAND IF HE HEARD SOMETHING WIERD, HE DID. THE SAME FEELING HAPPENED ALSO AT PREVIOUS STATIONS WHEN I LANDED.SDR SWAA2013031813719Frame · corrodedFRAME CORRODED AT BS 927, BETWEEN LONGERON 30L TO 29L. REMOVED AND REPLACED FRAME IAW SRM.SDR SWAA2013031813716Frame · corrodedFRAME CORRODED AT BS 908, L30. REMOVED AND REPLACED FRAME IAW SRM.SDR SWAA2013030413247Frame · corrodedFRAME CORRODED AT BS 540, STR 10R. REPAIRED SPLICE IAW SRM.SDR SWAA2013030413246Frame · corrodedFRAME CORRODED AT BS 540, STR 9L. REPAIRED FRAME IAW SRM.SDR QXEA2013022000400Frame · corrodedFRAME FLANGES AT FR 196 STR 32-30S HAVE CORROSION. REMOVED 11 RIVETS AND REMOVED CORROSION IAW SRM 53-00-00-02-09, REV 12. VERIFIED AFFECTED AREAS TO BE CRACK FREE REF NDTM PART 6, TASK 51-00-01-250-801, REV 9. MINIMUM THICKNESS REMAINING NOTED BETWEEN STRIN
Back to JASC 5311