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 SWAA113325Frame · corrodedDURING SCHEDULED 24Y CHECK FOUND CORROSION FWD CARGO COMPARTMENT ON FRAME, BS 500A END BETWEEN STR 28R TO STR 28L. REPAIRED PER SRM.SDR GLBA20110418FFrame · crackedMAJOR REPAIR - DURING A SCHEDULED ROUNTINE INSPECTION MAINTENANCE FOUND THE RH FUSELAGE FRAME AT F.S. 456 AND STRINGER 9AR CRACKED .15" IN LENGTH. MAINTENANCE REPAIRED THE AFFECTED AREA AND PERFORMED ALL REQUIRED RII INSPECTIONS I.A.W. EO 11-1900-53-023. MATERSDR GLBA20110418GFrame · crackedMAJOR REPAIR - DURING A SCHEDULED ROUNTINE INSPECTION MAINTENANCE FOUND THE RH FUSELAGE FRAME AT F.S. 456 AND STRINGER 10R CRACKED .2" IN LENGTH. MAINTENANCE REPAIRED THE AFFECTED AREA AND PERFORMED ALL REQUIRED RII INSPECTIONS I.A.W. EO 11-1900-53-025. MATERISDR AALA20110418TUL05Frame · corrodedCORROSION ON FRAME 110 LONGERON 30. REPAIRED PER SRM 53-02-00 FIGURE 1B.SDR SWAA112855Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME PER EA.SDR SWAA112854Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER EA.SDR SWAA112853Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER EA.SDR SWAA112852Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER EA.SDR CALA2011041800295Frame · crackedSUPPORT TASK - PAX CABIN HAS CRACKS ON NR 727B FRAME BETWEEN STR 8R AND 9R. REPAIRED FRAME AT STA 727 B BETWEEN STR 8 R AND 9 R REF EA 5310-04716 REV C.SDR CALA2011041800294Frame · crackedSUPPORT TASK - PAX CABIN HAS CRACKS ON FRAME NR 440 BETWEEN STR 8R AND 9R. REPAIRED FRAME PER EA 5310-04716 REV-C.SDR CALA2011041800293Frame · crackedSUPPORT TASK PZX CABIN HAS CRACKED 380 FRAME BETWEEN STR 8R & 9R. REPAIRED FRAME PER EA 5310-04716 REV C.SDR 3S8R2011041600014Frame · corrodedFRONT UPPER ANGLE OF FRAME AT FS X5295 CORRODED. TO BE REPLACED WITH NEW.SDR IPXA1566614Frame · dentedINSPECTION TYPE:C3, AFT PIT STA 1620 FRAME IS DENTED ABOVE STR 26R. REPAIRED FRAME STA 1620 ABOVE STR 26R IAW SRM 53-00-07-2R-5 AND EA 110 397.SDR IPXA11566598Frame · dentedINSPECTION TYPE:C3, AFT PIT STA 1580 FRAME IS DENTED BETWEEN STR 21R AND 22R. REMOVED DAMAGE AND REPAIRED FRAME SECTION IAW EA 110396.SDR IPXA11566586Frame · damagedINSPECTION TYPE:C3, AFT PIT STA 1380 LOWER FRAME DOUBLER UPPER SURFACE HAS TOOLING DAMAGE. REPLACED AFT PIT STA 1380 FRAME SECTION IAW SRM 51-40-02, DWG 146N1010 , DWG 146N8511 AND DWG 65-88700.SDR USAA2011050291727Frame · crackedCLT - Q2 CHECK - CRACK ON FRAME AT BS 907, BETWEEN STR 8L TO 9L. REPAIRED FRAME AT BS 907, BETWEEN STR 8L TO 9L IAW EA 102739.SDR AALA20110416TUL03Frame · crackedCANT FRAME AFT ACCY STATION 1510 CRACKED. INSTALLED DOUBLER PER SRM 53-14-04.SDR AALA20110416TUL02Frame · crackedCRACK IN FRAME STATION 1510. INSTALLED DOUBLER PER SRM 53-01-00.SDR USAA2011051791869Frame · crackedCLT - Q2 - CRACK IN FUSELAGE FRAME STUB BEAM AT BS 706, LBL 46. REPAIRED FUSELAGE FRAME STUB BEAM AT BS 706, LBL 46 IAW EA 102886.SDR USAA2011051791866Frame · crackedCLT - Q2 - CRACK ON FUSELAGE FRAME AT BS 787 BETWEEN S8R TO S9R. REPAIRED FUSELAGE FRAME AT BS 787 BETWEEN S8R TO S9R IAW EA 102903.SDR ABXA2011041536Fitting · corrodedDURING AIRCRAFT HEAVY MAINTENANCE VISIT TO ILN, MAINTENANCE & ENGINEERING SERVICES, MAINTENANCE REPORTED CORROSION FINDINGS LOCATED IN POCKET AREAS OF THE AFT FACE AND FLANGES OF THE LEFT FUSELAGE SIDE FRAME FITTING AT STA 955. THE CORROSION JUST FORWARD OF TSDR FDEA201104151502Frame · corrodedAFT LOWER CARGO FLOOR FRAME AT STA 1460 STR 29L TO 30 CORRODED AT LOWER SECTION OF FRAME. REMOVED CORROSION ON FRAME STA 1460. BLENDED AREA ORIG MATERIAL .063 MATERIAL LOSS .015 REMAINING .048. FOUND TO BE OUT OF LIMITS IAW SRM 53-00-07, FIG 101, DETAIL ISDR USAA2011041591504Frame · crackedCLT - C4 - CRACK ON FRAME WEB EXISTING DOUBLER AT BS 303.9, S17L. REPLACED FRAME WEB DOUBLER AT BS 303.9, S17L IAW EO 5311-01025.SDR DALA1609040664Frame · dentedFUSELAGE-DENT IN FORWARD ACCESSORY COMPARTMENT FRAME AT BS 231.25, BL 0.0.SDR FDEA201104141480Frame · crackedDURING ACCOMPLISHMENT OF WORK CARD E6-5310-7-5013C PART 1, FUSELAGE FRAME NR 47 LT RADIUS FITTING FOUND CRACKED. REPAIRED AS PER E.O. 6-5310-7-5013C PART 1 &, SERVICE BULLITINS A300-53-6029 R08 AND A300-53-6144 R01. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-10SDR DALA1125969871Frame · crackedAFT ACCESSORY CANTED FRAME 1303 CRACKED AT L16L LT SIDE. REMOVED CRACK IAW 53-03 FIG 4. CRACK REMOVED HFEC USING ZETECPER NDT SPM 06-10-01. RECEIVED MAT .040 7075T6 MAT ID .050 7075T6 MAT ID .063 7075T6. FABBED FILLER, ANGLE SPLICE IAW 53-03 FIG 4. TREATSDR SWAA112802Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME PER EA.SDR SWAA112801Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER EA.SDR SWAA112765Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 639, LBL 47. REPAIRED FRAME PER SRM AND BAC DWG.SDR SWAA112764Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 520, STR 14L. REPAIRED FRAME PER ER AND EA.SDR SWAA112761Frame · corrodedDURING SCHEDULED 22Y CHECK, FOUND FRAME CHORD LOWER CORRODED AT BS 227.8, BETWEEN BL 0 TO RBL 5. REPAIRED CHORD PER EA.SDR SWAA2014100832772Frame · crackedFRAME ANGLE CRACKED AT BS 727 WL 201. REPAIRED FRAME IAW EA.SDR USAA2011041991550Frame · crackedCLT - Q2 CHECK - CRACKED FRAME INNER CHORD AT BS 616, STR 18L. REPAIRED FRAME INNER CHORD AT BS 616, STR 18L IAW TYPICAL REPAIR 737-5362-10-0023.SDR ASOA201100760Frame · crackedLEFT BS 718 FRAME IS CRACKED AT S11-12L. REPLACED FRAME IAW SRM 51-42-06, 51-42-21.SDR SWAA112742Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 296.4, STR 7R. REPAIRED FRAME PER EO.SDR SWAA112737Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 807, BETWEEN STR 25L TO STR 26L. REPAIRED FRAME PER SRM.SDR SWAA112724Frame · corrodedDURING SCHEDULED 22Y CHECK, FOUND FRAME CORRODED AT BS 867, BETWEEN STR 27R TO STR 27L. REPAIRED FRAME PER SRM.SDR CALA2011041300281Frame · damagedSUPPORT TASK: FWD CARGO COMPT, STA 620 AT RBL-28, FRAME HAS A MIS-DRILLED HOLE NEXT TO EXISTING FASTENER HOLE. INSTALLED REPAIR ACCOMPLISHED REF PER EC/RA 5310-05374 AT STA 620 RBL 28 AND INITIAL A DIP TO ACCOMPLISH A PERMANENT REPAIR WITHIN 24 MONTHS OF APRSDR SWAA112711Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 380, STR 16R. REPAIRED FRAME PER ER AND EA.SDR SWAA112701Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED BETWEEN BS 787 TO BS 847, STR 25R. REPAIRED FRAME PER SRM.SDR SWAA112700Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 807, BETWEEN BS 807, BETWEEN STR 27R TO STR 27L. REPAIRED FRAME PER SRM.SDR SWAA112698Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND AFT CARGO COMPARTMENT FRAME CORRODED AT BS 907, BETWEEN STR 27R TO STR 27L. REPAIRED FRAME PER SRM.SDR SWAA112697Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 907, BETWEEN STR 27R TO STR 27L. REPAIRED FRAME PER SRM.SDR SWAA112696Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 727D, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME PER SRM.SDR SWAA112695Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 727D, BETWEEN STR 26R TO STR 27R. REPAIRED FRAME PER SRM.SDR SWAA112694Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 927, BETWEEN STR 27L TO STR 27R. REPAIRED FRAME PER SRM.SDR SWAA112677Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 303, STR 16L. REPAIRED FRAME PER SI AND ACOSDR SWAA112676Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 727A, STR 17L. REPAIRED FRAME PER ER AND EA.SDR SWAA112661Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 500, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME PER SRM.SDR SWAA112637Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 947.5, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME PER SRM.
Back to JASC 5311