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 SWAA2013010311094Frame · crackedFRAME AT STA 737 RT IS CRACKED BELOW CUSP WELL. ACCOMPLISHED EA 17-53-03955.SDR CALA2012123100893Frame · crackedCRACK INDICATION AT INBD RIVET HOLE IN FRAME BS 747. FRAME REPAIRED IAW EA 5310-04716, REV D, OP 1.SDR CALA2012123100892Frame · crackedFRAME BS 867L BETWEEN STRINGERS 8 AND 9L HAS A CRACK AT RIVET ATTACH BRACKET. REPAIRED CRACKED FRAME, REF EA 5310-04716, OP 01.SDR CALA2012123100891Frame · crackedCRACK INDICATION AT INBD RIVET HOLE IN FRAME BS 520 BETWEEN STRINGERS 8 AND 9R. REPAIRED IAW EA 5310-04716, REV D, OP 1.SDR SWAA2013011011325Frame · corrodedCARGO COMPARTMENT BILGE SIDE OF FRAME CORRODED AT BS 787, BETWEEN RBL 9 TO RBL 14. REMOVED AND REPLACED FRAME IAW SRM.SDR CALA2012123100890Frame · crackedCRACK INDICATION AT INBD RIVET HOLE, IN FRAME BS 440. REPAIRED IAW EA 5310-04716, REV D, OP 1.SDR CALA2012122800887Frame · crackedCRACK INDICATION AT INBD RIVET HOLE ON FRAME BS 727A BETWEEN STR 8 AND 9L. FRAME REPAIRED IAW EA 5310-04716, REV D, OP 1.SDR CALA2012122800886Frame · crackedCRACK INDICATION AT INBD RIVET HOLE ON FRAME, BS 500C BETWEEN STR 8 AND 9R. FRAME REPAIRED IAW EA 5310-04716 OP 1, REV D.SDR CALA2012122800885Frame · crackedCRACK INDICATION AT RIVET HOLE, FRAME BS 500A BETWEEN STRINGERS 8 AND 9R. INSTALLED REPAIR DOUBLERS ON FRAME IAW EA 5310-047 16, REV D OP 1.SDR CALA2012122800889Frame · crackedFRAME, BS 747 BETWEEN STRINGERS 8 & 9L HAS A CRACK AT ATTACH BRACKET. REPAIRED FRAME AS REQUIRED IN EA 5310-04716, REV D.SDR CALA2012122800888Frame · crackedLEFT FUSELAGE FRAME, BS 787 BETWEEN STRINGERS 8 AND 9L HAS CRACK AT RIVET ATTACH BRACKET. REMOVED DAMAGE AND INSTALLED DOUBLERS REF EA5310-04716, REV D.SDR ASOA2013012302885Frame · corrodedFRAME FS 333.00 FROM STR 25L-25R IS CORRODED. REMOVED LOWER FRAME SECTION IAW SRM 51-42-21 AND SRM 51-42-06. LOCATED & DRILLED NEW SERVICEABLE FRAME SECTION IAW SRM CH 51-40-11. INSTALLED NEW SERVICEABLE LOWER FRAME SECTOR IAW SRM 51-42-06 AND 51-42-21.SDR ASOA2013012302884Frame · corrodedFS 349.00 FROM STR 25L TO 25R IS CORRODED. REMOVED FS 349 LOWER FRAME SECTION IAW SRM 51-42-06. INSTALLED NEW SERVICEABLE FRAME SECTION IAW SRM 51-42-06.SDR SWIA201232596Frame · corrodedCORROSION FRAME LOWER FLANGE AT FS 295 STR 26L. (C-CHECK) REPAIRED CORRODED AREA OF FRAME LOWER FLANGE AT FS 295 STR 26L.SDR CALA2012122800884Frame · crackedCRACK INDICATION AT INBD RIVET HOLE OF FRAME, BS 400. REPAIRED FRAME IAW 5310-04716.SDR CALA2012122800882Frame · crackedFRAME, BS 380 BETWEEN STRINGERS 8 AND 9L HAS CRACKED AT RIVET ATTACH BRACKET. REMOVED DAMAGES AREA AND FABRICATED AND INSTALLED REPAIR ANGLE IAW EA5310-04716, REV D.SDR CALA2012122700881Frame · crackedCRACK INDICATION AT INBD RIVET HOLE FRAME BS 400 BETWEEN STRINGER 8 AND 9R. REPAIRED IAW EA 5310-04716, REV D, OP 1.SDR CALA2012122700880Frame · crackedCRACK INDICATION AT INBD RIVET HOLE FRAME BS 380 REPAIRED IAW EA 5310-04716, REV D, OP 1.SDR CALA2012122700879Frame · crackedLEFT FUSELAGE FRAME BS 500C, BETWEEN STRINGERS 8 AND 9L HAS CRACKED AT RIVET ATTACH BRACKET. CUT OUT DAMAGED AREA, FABRICATED AND INSTALLED REPAIR DOUBLERS IAW EA 5310-04716, REV D, FIG 3.SDR CALA2012122700878Frame · crackedLEFT FUSELAGE FRAME, BS 727D BETWEEN STRINGERS 8 AND 9L HAS CRACKED AT RIVET ATTACH BRACKET. FABRICATED AND INSTALLED REPAIR ANGLES IAW EA 5310-04716, REV D.SDR R61A201212260763Frame · crackedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND UPPER FLANGE FRAME 81 AT STRINGER 28R CRACKED. MAINTENANCE REMOVED DAMGED AREA AND REPAIRED FRAME 81 IAW ETD 2012-170-018766-A REV A. "MAJOR REPAIR" THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR DALA12017130937Frame · crackedCRACKED FRAME BS 1485. FRAME REPAIRED IAW SRM DRD 53-03D, FIG 48.SDR SIMA20121224001Doubler · crackedDURING MBV INSPECTION, QC FOUND FRAME 23 REPAIR DOUBLER CRACKED BETWEEN STRINGERS 15R AND 16R. REMOVED PREVIOUS REPAIR PARTS, FABRICATED AND INSTALLED NEW REPAIR PARTS IAW EO EM-53MR-1808.SDR SWAA2013011111367Frame · crackedCRACK ON I/B FLANGE OF FRAME AT STA 295, RBL 55 AND WL 208. REPAIRED FRAME FLANGE AT BS 295, RBL 55, WL 208 IAW ER 12-03768 & EA 1-753-21425.SDR ASOA20121223150Frame · corrodedDURING C-CHECK FRAME 50 WAS FOUND TO BE CORRODED BETWEEN STRINGERS 18-19L. MX REMOVED THE CORROSION AND PERFORMED A DOUBLER REPAIR IAW EC5310-01651. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR SWAA2013013012104Frame · crackedCRACK WERE FOUND ON LOWER STUB FRAME BS 294.5 AND STR 16R TO STR 17R. REPLACED STUB FRAME LOCATED BS 294.5 AND BETWEEN STR 15R TO STR 17R IAW SRM B737-300 51-10-02 ITEM 8 AND FASTENERS INSTALLED IAW SRM B737-300 51-40-02 AND DRAWING 65-45807.SDR USAA2013012300008Frame · corrodedQ6 CHECK - LEVEL 2 EXFOLIATION CORROSION ON FUSELAGE FRAME AT BS 787, RBL 13. REPAIRED FUSELAGE FRAME AT BS 787, RBL 13 IAW B737 SRM 53-00-07-2R-10, FIG 201.SDR SWAA2013010711227Frame · crackedCRACK ON FRAME LOCATED BS 344 BETWEEN STR 21L TO STR 22L IN E/E COMP. REPLACED FRAME LOCATED BS 344 BETWEEN STR-21L TO STR 28L IN E/E COMP IAW SRM B737-300 51-10-02 PART 8, 51-40-02 AND DWG 65-45815.SDR SWAA2012122810940Frame · crackedFRAME CRACKED AT SKIN UPPER LEG UNDER S10R LAP STA 500D. REMOVED AND REPLACED IAW SRM AND DWG.SDR HNAA2012122101128Frame · corrodedCORROSION FOUND ON FORWARD SPAR FRAME AT STR 33P, RT SIDE OF CENTER. BLENDED CORROSION IAW RD 8-53-12757. COMPLIED WITH EDDY CURRENT INSPECTION. NO DEFECTS NOTED.SDR HNAA2012122101125Spar · corrodedCORROSION FOUND ON FORWARD SPAR MAIN FRAME BETWEEN STR 31S AND 32S ON FORWARD SIDE. BLENDED CORROSION IAW RD8-53-12757. COMPLIED WITH EDDY CURRENT INSPECTION. NO CRACKS NOTED AT THIS TIME.SDR SWAA2013020112219Frame · corrodedFRAME CORRODED AT BS 277, STR 26L. REPAIRED FRAME IAW EO.SDR FDEA201212204346Frame · crackedFWD PIT, BS 640 FRAME WEB, S22-23R, CRACKED. FOUND OUT OF LIMITS IAW NDTM PT 6, 51-00-19 . REMOVED FRAME IAW SRM 51-40-02 . FABRICATED IAW DRAWING 143N1024. INSTALLED FRAME IAW 51-40-02 & DRAWING 143N1011. MAJOR REPAIR.SDR SWAA2013020712385Frame · corrodedFRAME STRUCTURE STA 947 LBL 6 TO 8, FLANGE BELOW BULKHEAD CORRODED. REPAIRED FRAME IAW EA.SDR ASOA2013011502795Beam · corrodedCORROSION ON PAX DOOR AFT FRAME LOWER TRANSVERSE BEAM AT FS 349.00. REPAIRED IAW REO 601R-53-21-2392. THIS REPAIR IS CLASSIFIED AS A MAJOR REPAIR IAW SOP 5702.SDR ASOA2013011502794Frame · corrodedCORROSION ON FRAME AT FS 349 BETWEEN STR 26L AND 26R. REMOVED LOWER FRAME SECTION FS 349 IAW SRM 51-42-06 AND 51-42-21. LOCATED AND DRILLED NEW SERVICEABLE LWR FRAME SECTION AT FS 349 AND INSTALLED FRAME IAW SRM 51-40-21, 51-42-06, 51-42-21.SDR ASOA2013011502793Frame · corrodedCORROSION ON FRAME AT FS 314.7 BETWEEN STR 26L AND STR 26R. REMOVED LOWER SECTION OF FRAME AT FS 319.00, STR 24L-24R IAW SRM 51-42-06 & 51-42-21. LOCATED & DRILLED HOLES COMMONT TO SKIN AND SPLICE & NEW SERVICEABLE FRAME SECTOR PN 601R32003-61 IAW SRM 51-40-SDR ASOA2013011502792Frame · corrodedCORROSION ON FRAME AT FS 310.00 BETWEEN S26L AND 26R. REPAIRED IAW SRM 51-42-06 AND 51-42-21.SDR SWAA2013010711218Frame · corrodedLOWER FLANGE OF FRAME CORRODED AT BS 827, BETWEEN STR 27L TO STR 27R. REPAIRED FRAME IAW SRM.SDR SWAA2013010711212Frame · corrodedLOWER FLANGE OF FRAME CRACKED AT BS 787 BETWEEN STR 26R TO 27R. REPAIRED FRAME IAW SRM.SDR SWAA2013010311112Frame · crackedPASSENGER CABIN STA 747 FRAME CRACKED AT INBOARD FASTENER NEAR STRINGER 8L. REPAIRED FRAME IN PASSENGER CABIN AT STA 747 NEAR STRINGER 8L WITH A RIVETED NESTED ANGLE REPAIR AS PER EA 1-A53-12114 REV 2 ALL WORK PERFORMED ON EA 1-A53-12114 REV 2.SDR SWAA2013010311110Frame · crackedMAIN CABIN FRAME CRACKED AT STA-867 BELOW STR-8L AT PSU RAIL. REPAIRED FRAME IN MAIN CABIN AT STA 867 BELOW STR 8L AT THE PSU RAIL WITH A RIVETED NESTED ANGLE REPAIR PER EA 1 A-53-12114 REV 2. ALL WORK ACCOMPLISHED ON EA 1-A53-12114 REV 2.SDR SWAA2013010311109Frame · crackedPASSENGER CABIN STA 787 FRAME CRACKED AT INBOARD FASTENER NEAR STRINGER 8L. REPAIRED FRAME IN PASSENGER CABIN AT STA 787 BELOW STRINGER 8 WITH A RIVETED NESTED ANGLE REPAIR PER EA 1-A53-12114 REV 2. ALL WORK PERFORMED ON EA 1-A53-12114 REV 2.SDR SWAA2013010311108Frame · crackedMAIN CABIN FRAME CRACKED AT STA-727D BELOW STR-8L AT PSU RAIL. INSTALLED FRAME REPAIR AT STA 727 "D" BETWEEN STRINGER 8L AND 9L IAW EA 1-A53-12114 REV 2.SDR SWAA2013010211047Frame · crackedMAIN CABIN FRAME CRACKED AT STA-440 BELOW STR-8L AT PSU RAIL. REPAIRED FRAME IN MAIN CABIN AT STA 440 BELOW STR 8L AT THE PSU RAIL WITH A RIVETED NESTED ANGLE REPAIR PER EA 1-A53-12114 REV 2. ALL WORK ACCOMPLISHED ON EA 1 A53-12114 REV 2.SDR SWAA2013010211046Frame · crackedMAIN CABIN FRAME CRACKED AT STA-787 BELOW STR-8R AT PSU RAIL. REPAIRED MAIN CABIN FRAME AT STA 787 BELOW STRINGER 8L BY INSTALLING NESTED ANGLES IAW EA 1-A53-12114 REV 2.SDR SWAA2013010211045Frame · crackedMAIN CABIN FRAME CRACKED AT STA-727D BELOW STR-8R AT PSU RAIL. REPAIRED MAIN CABIN FRAME AT STA 727D BELOW STRINGER 8R BY INSTALLING NESTED ANGLE IAW EA 1-A53-12114 REV 2.SDR SWAA2013010211044Frame · crackedMAIN CABIN FRAME CRACKED AT STA-500A BELOW STR-8L AT PSU RAIL. INSTALLED FRAME REPAIR AT FSTA 500A BETWEEN STRINGER 8L AND STRINGER 9L IAW EA 1-A53-12114 REV 2.SDR SWAA2013010211043Frame · crackedMAIN CABIN FRAME CRACKED AT STA-400 BELOW STR-8L AT PSU RAIL. REPAIRED FRAME IN MAIN CABIN AT SAT 400 BELOW STR 8L AT THE PSU RAIL WITH A RIVETED NESTED ANGLE REPAIR PER EA 1-A53-12114 REV 2 ALL WORK ACCOMPLISHED ON EA 1-A53-12114 REV 2.SDR SWAA2013010211042Frame · crackedMAIN CABIN FRAME CRACKED AT STA-480 BELOW STR-8R AT PSU RAIL. REPAIRED MAIN CABIN FRAME AT STA 480 BELOW STR 8R AT PSU RAIL BY INSTALLING RESTED ANGLE IAW EA.
Back to JASC 5311