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 SWAA2012053104493Frame · corrodedFRAME CORRODED AT BS 360, BETWEEN LBL 5 TO RBL 4. REPAIRED FRAME IAW EA AND EO.SDR CALA2012051100338Frame · crackedFRAME CRACKED STA 727B AT S-9L. REPAIRED CRACKED FRAME AT FS 727B AT PSU RAIL ATTACH BRACKET REF EA 5310-04498, REV B, OP 2.SDR CALA2012051100337Frame · crackedFUSELAGE RT FRAME CRACKED, STA 907, BETWEEN STR 8 & AMP; 9. COMPLIED WITH FRAME REPAIR REF EA 5310-04498, REV B, OP 02.SDR CALA2012051100336Frame · crackedFUSELAGE RT FRAME CRACKED STA 360 BETWEEN STR 8 & AMP; 9. COMPLIED WITH FRAME REPAIR REF EA 5310-04498, REV B, OP 02.SDR CALA2012051100335Frame · crackedFUSELAGE RT FRAME CRACKED BS 440 BETWEEN STR 8 & AMP; 9. REPAIRED RT FRAME STA 440 BETWEEN. STR 8 & AMP; 9. REF EA 5310-04498, REV B, OP 02.SDR DALA1230780181Frame · crackedFS 1809.5 STR 5R FWD OUTER CHORD CRACKED APROX 7/8 INCH LENGTH. CUTOUT THE CRACK AREA AND REPAIRED AS PER B767-300 SRM 53-80-08 REPAIR 9, FIGURE 201, CAT B REPAIR.SDR IPXA12573699Frame · dentedC CHECK, MAIN CARGO BS 520 RT FRAME BETWEEN S16 & 17R FRAME DENTED. REPAIRED IAW EA 120654 IR AND EO B757-5310-47278-A.SDR SWAA2012052104173Frame · crackedFWD CARGO COMPARTMENT FRAME WEB CRACKED AT BS 520, STR 28R. REPAIRED FRAME IAW EA.SDR DALA1230529261Frame · corrodedFWD CARGO COMPT BILGE AREA STA 446 BETWEEN L29L-L30 WITH CORROSION. REMOVED CORROSION FOUND OUT OF LIMITS IN REF SRM 53-00-01. CUT FRAME SECTION STA 446 BETWEEN L26L AND L26R IN REF SRM 53-10-02 VOL II. LOCATED AND DRILLED NEW SECTION OF FRAME IN REF SRM 51SDR DALA1230409254Frame · corrodedAFT CARGO FRAME CORRODED AT STA 1288 LBL8. REPAIRED IAW MD90 SRM 53-10-02.SDR DALA1230399254Frame · corrodedAFT CARGO STA 1307 L28L TO L28R CORRODED. REPAIRED PER SRM VOL 1 53-10-02 FIG 7.SDR SWAA2012052904419Frame · corrodedFRAME CORRODED AT BS 767, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME IAW SRM.SDR IPXA12573701Frame · dentedINSPECTION TYPE:C, MAIN CARGO BS 600 RT FRAME BETWEEN STR 16 & 17R FRAME DENTED. REPAIRED IAW EA 120650 IR AND EO B757-5310-47280-A.SDR SIMA20120502008Frame · crackedDURING MBV INSPECTION FOUND FRAME 23 IN CRACKED AT STRINGR 15 RIGHT. THE AIRCRAFT WAS REMOVED FROM SERVICE. REPAIR OF FRAME 23 IAW EM-53MR-1808. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR DALA1230816818Frame · dentedDURING INSPECTION A DENT WAS DISCOVERED IN THE C2 CARGO COMPARTMENT LEFT SIDE BS 1520 - INNER FREE FLANGE. REMOVED DAMAGE AREA AND INSPECTED REF: B757 SRM 53-00-07 REPAIR 5. NO DISCREPANCIES NOTED. FABRICATED REPAIR, INSTALLED AND TREATED AREA.SDR DALA1230806818Frame · damagedDURING INSPECTION A DENT WAS DISCOVERED IN THE C2 CARGO COMPARTMENT LEFT SIDE BS 1420 - INNER FREE FLANGE. REMOVED DAMAGE AREA AND INSPECTED IAW SRM 53-00-07 REPAIR 5. NO DISCREPANCIES NOTED. FABRICATED REPAIR, INSTALLED AND TREATED AREA.SDR DALA1230439254Frame · dentedFWD CARGO FRAME DENTED AT BS 351 LONGERON 25L. REPAIRED IAW SRM 53-10-02 FIG 5.SDR DALA1230429254Frame · corrodedAFT CARGO BILGE AREA LOWER CORD CORRODED AT STA 1288 LBL 8. REPAIRED IAW SRM 53-10-02 FIG 2.SDR COMA2012051050038Frame · corrodedCORROSION ON FRAME AT FS 333.00 BETWEEN STGR 25R AND STGR 25L. REMOVED AND REPLACED LOWER FRAME SECTION AT FS 333.00 BETWEEN STGR 23R AND 23L IAW CRJ 200 SRM 51-40-11, 51-42-06 AND 51-42-21.SDR USAA2012050900004Frame · crackedFPBH VISIT - CRACK IN FUSELAGE FRAME AT BS 500F, S20R AT FEEDER CABLE HOLE. REPAIRED FUSELAGE FRAME AT BS 500F, S20R IAW B737 SRM 53-00-07 P.B. 2; REPAIR 13.SDR DALA1230061404Frame · crackedFS 903 LT BETWEEN STR 20L AND STR 21L FRAME CHORD CRACKED. CHORD CRACK REPAIR ACCOMPLISHED AS PER ERA 501545-14AD REV ORG SECTION 1.SDR DALA1230051404Frame · crackedFS 903 RT BETWEEN STR 20R AND STR 21L INNER CHORD CRACKED. TRIMMED OUT AND REPAIRED AS PER ERA 501546-14AD REV ORG SECTION 1.SDR SWAA2012052904415Frame · corrodedFRAME CORRODED AT BS 500C, BETWEEN STR 28L TO STR 28R. REPAIRED FRAME IAW SRM.SDR SWAA2012052904395Frame · corrodedFRAME CORRODED AT BS 500C, BETWEEN STR 27L TO STR 28L. REPAIRED FRAME IAW SRM.SDR FDEA201205071758Frame · burnedDURING MASKING AND PREPARATION OF CPC AT MAIN DECK CARGO UNDER FLOORBEAM AT BS 1481, X=-24. FOUND ADJACENT TO APU FEEDER CABLE FRAME CUTOUT AREA BURNED THROUGH. REPAIRED IAW EA 1-5310-160606 PART 1. REPAIR CLASSIFIED MINOR IAW GMM 6-2-100 REV 114.SDR DALA1230036306Doubler · crackedDURING INSPECTION FOUND CRACK AT THE TENSION TIE STATION STA1200 RT FRAME DOUBLER. MAINTENANCE REMOVED DOUBLER AND INSTALLED WITH NEW FRAME DOUBLER AS PER B747-400 SRM 51-40-02.SDR DALA1230026306Doubler · crackedDURING INSPECTION FOUND CABIN ZONE C LT STA 1200 TENSION TIE FRAME DOUBLER FOUND CRACKED. MAINTENANCE REMOVED DOUBLER AND INSTALLED NEW FRAME DOUBLER AS PER B747-400 SRM 51-40-02.SDR AALA20120507014Frame · crackedSTATION 727B RIGHT FRAME CRACKED AT ATTACH BRACKET. INSTALLED NESTED ANGLE REPAIR PER ECO J1159AD.SDR AALA20120507013Frame · crackedSTATION 727B LEFT FRAME CRACKED AT ATTACH BRACKET. INSTALLED NESTED ANGLE REPAIR PER ECO J1159AD.SDR AALA20120507012Frame · crackedSTATION 480 LEFT FRAME CRACKED AT ATTACH BRACKET. INSTALLED NESTED ANGLE REPAIR PER ECO J1159AD.SDR AALA20120507011Frame · crackedSTATION 867 RIGHT FRAME CRACKED AT ATTACH BRACKET. INSTALLED NESTED ANGLE REPAIR PER ECO J1159AD.SDR AALA20120507010Frame · crackedSTATION 400 RIGHT FRAME CRACKED AT ATTACH BRACKET. INSTALLED NESTED ANGLE REPAIR PER ECO J1159AD.SDR AALA20120507009Frame · crackedSTATION 500F RIGHT FRAME CRACKED AT ATTACH BRACKET. INSTALLED NESTED ANGLE REPAIR PER ECO J1159AD.SDR AALA20120507008Frame · crackedSTATION 500D RIGHT FRAME CRACKED AT ATTACH BRACKET. INSTALLED NESTED ANGLE REPAIR PER ECO J1159AD.SDR AALA20120507006Frame · crackedSTATION 500C RIGHT FRAME CRACKED AT ATTACH BRACKET. INSTALLED NESTED ANGLE REPAIR PER ECO J1159AD.SDR AALA20120507005Frame · crackedSTATION 480 RIGHT FRAME CRACKED AT ATTACH BRACKET. INSTALLED NESTED ANGLE REPAIR PER ECO J1159AD.SDR AALA20120507004Frame · crackedSTATION 500A RIGHT FRAME CRACKED AT ATTACH BRACKET. INSTALLED NESTED ANGLE REPAIR PER ECO J1159AD.SDR FDEA201205071759Frame · crackedRIGHT MAIN DECK CARGO FRAME 24, BENT AT SPLICE AND MISSING ONE FASTENER BETWEEN STR 8R AND 9R DEFECT MEASURES 2.5 INCHES LONG. AFTER REMOVAL OF FASTENERS AND REFORMING BENT SPLICE IAW SRM 51-40-21, AND SRM 51-26-00 PG 1, NDT VERIFIED A 2 INCH CRACK IN PREVSDR SWAA2012051604064Fitting · corrodedFRAME CLIP CORRODED AT BS 520, STR 28R. REMOVED AND REPLACED CLIP IAW BAC DWG.SDR DALA1230840984Frame · crackedFRAME 1510 CRACKED AT 2 O`CLOCK POSITION AT TAILCONE ALIGNMENT PIN. INSTALLED DOUBLER PER ER/A 503339-14.SDR ASOA20120506022Frame · corrodedDURING C-CHECK, CARGO FWD TRIANGLE AT FRAME 65 HAS LEVEL 2 CORROSION AROUND NUT PLATE. MX REPAIRED AND REINSTALLED CARGO FWD TRIANGLE AT FRAME 65 IAW EC5320-01479 AND SRM 51-40-02. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR DALA1240630918Frame · corrodedAFT CARGO FRAME HAS CORROSION FROM L23L-L28R AT BS 1322. CORROSION OUT OF LIMITS. REPLACED FRAME BS 1322 L30-L23R IAW SRM 51-30-2.SDR USAA2012052900032Frame · corrodedC2 CHECK - LEVEL 2 EXFOLIATION CORROSION FRAME CAP AT FR84, Z-490 BETWEEN Y310 TO Y1160. REPAIRED FRAME CAP AT FR84, Z-490 BETWEEN Y310 TO Y1160 IAW EA 202539 & EA 202532.SDR DALA1234220690Frame · dentedAFT CARGO FRAME DENTED AT BS 1600 S24-26R, FOUND TO BE OUT OF LIMITS. REMOVED DAMAGE. FABRICATED AND INSTALLED PER SRM 53-00-07 REPAIR 5 PG 201 FIG 210 PAR 10, 11.SDR DALA1234210690Frame · dentedAFT CARGO FRAME DENTED AT BS 1520 STR 24-26L. FOUND TO BE OUT OF LIMITS. REMOVED DAMAGE. FABRICATED AND INSTALLED PER SRM 53-00-07 REPAIR 5 PG 201 FIG 210 PAR 10,11.SDR DALA1234200690Frame · dentedAFT CARGO FRAME DENTED AT BS 1480 S24-26L, FOUND TO BE OUT OF LIMITS. REMOVED DAMAGE. FABRICATED AND INSTALLED AT PER SRM 53-00-07 REPAIR 5 PG 201 FIG 210 PAR 10,11.SDR AALA20120504015Frame · crackedCRACK AT STATION 480 STRINGERS 8 TO 9 LEFT. ACCOMPLISHED NESTED ANGLE REPAIR PER ECO J1159AD-0006.SDR AALA20120504014Frame · crackedCRACK AT STATION 400 LEFT STRINGERS 8 TO 9 LEFT. ACCOMPLISHED NESTED ANGLE REPAIR PER ECO J1159AD-0006.SDR QXEA2012050400366Frame · corrodedFRAME 258.5, FLANGE IS CORRODED STR 31P -32P. REMOVED 2 RIVETS FOM AND BLENDED CORROSION ON FRAME IAW RD 8/4-53-2344. MIN REMAINING THICKNESS .043", CONFIRMED CRACK FREE CONDITION REF NTM 51-00-06-910-801 AND 51-00-04-910-801 PT 1. FOUND BLEND TO BE WITHIN SDR QXEA2012050400365Frame · corrodedFRAME 301 FLANGE IS CORRODED STR 31P - 32P. REMOVED 3 RIVETS FOM AND BLENDED CORROSION ON FRAME IAW RD 8/4-53-2344. MIN REMAINING THICKNESS .044", CONFIRMED CRACK FREE CONDITION REF NTM 51-00-06-910-801 AND 51-00-04-910-801 PT 1. FOUND BLEND TO BE WITHIN LI
Back to JASC 5311