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 JR2R2011111100581Frame · corrodedFRAME 364 HAS CORROSION BETWEEN STGR 27 AND 25R IN THE FWD E&E BAY. REPAIRED FRAME 364 IN FWD E&E BAY IAW MESA RO CRJ9-53-0855 AS ON AAR WO 1007307-1000-0018 AND MESA WO 711014235.SDR SWAA117830Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME IAW EA.SDR FDEA201111104868Frame · misrepairedFRAME AT BS 1400, STR 24-26L MISREPAIRED. R & R FRAME IAW SRM 51-40-02 AND DWG 146N1028. MAJOR REPAIR.SDR HNAA2011111000379Frame · corrodedCORROSION ON BACK SIDE OF FRAME JOINT STRAP BELOW LT MID EMERGENCY EXIT DOOR AT STA X370.80. CLEANED CORROSION, INSPECTED AND ALODINED JOINT STRAP. PRIMED AS REQUIRED.SDR HNAA2011111000378Frame · corrodedCORROSION ON FRAME MEMBER BELOW RT FORWARD EMERGENCY EXIT DOOR AT STA X252.30. REMOVED VERY MINOR CORROSION. CORROSION NOT PASSED THE PROTECTIVE COATING. ALODINED AND PRIMED WORKED AREA.SDR USAA2011111100004Frame · crackedC2 CHECK - CRACK IN FUSELAGE FRAME AT BS 500G, S21L. REPAIRED FUSELAGE FRAME AT BS 500G, S21L IAW B737 SRM 53-00-07-2R-13.SDR ASOA201102143Frame · corrodedFUSELAGE FRAME IS CORRODED AT ACFT BELLY CENTER LINE FS 333.SDR FDEA201111094831Frame · chafedCABIN FRAME AT BS STA 1280 BETWEEN STR 13L TO STR 14L FORWARD SURFACE CHAFED. REPAIRED IAW SRM 53-00-07. REPAIR 3, FIG 201, REV 104. REPAIR IS CLASSIFIED AS MAJOR.SDR QXEA2011110901206Frame · corrodedFRAME FLANGES HAVE CORROSION AT STA 196 BETWEEN STR 33-29P. REMOVED RIVETS IAW SRM 51-40-07-02-01, REMOVED CORROSION IAW SRM 51-21-00-00-02. MINIMUM REMAINING THICKNESS .042", FOUND TO BE WITHIN LIMITS IAW RD 8/4-53-2344. REPAIRED IAW RD 8/4-53-2344.SDR AALA20111108TUL04Frame · crackedTHE 1510 CANT FRAME CRACKED AT TAIL CONE ALIGNMENT PIN BELOW RIGHT LOWER TAIL CONE LATCH. INSTALLED DOUBLER PER EA MD80-53-020087 REVISION A.SDR AALA20111108TUL02Tab · crackedTAB ON FRAME IS CRACKED AT STATION 207, LONGERON 10 LEFT. INSTALLED REPAIR ANGLE DOUBLER AND FILLER PER AARD 53-10-00-11.SDR SWAA117772Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 500C, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME IAW SRM AND DWG.SDR SWAA117771Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 993.5, STR 17R. REPAIRED FRAME IAW EA.SDR SWAA117748Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 500B, BETWEEN STR 28L TO STR 28R. REPAIRED FRAME IAW SRM AND DWG.SDR SWAA117747Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 867, BETWEEN STR 26R TO STR 27R. REPAIRED FRAME IAW SRM.SDR HNAA2011110900350Frame · corrodedCORROSION FOUND ON FRAME AT ST X593 BETWEEN STR 30S AND 32S. NEED APPROVAL OF SRM 53-2021.SDR HEEA20111108456Frame · corrodedAFT LOWER FRAME ASSY WAS FOUND TO BE CORRODED. THE AFT LOWER FRAME WILL THEN BE REPAIRED IAW THE FAA-APPROVED REPAIR DATA.SDR QXEA2011111101209Frame · corrodedFRAME FLANGES HAVE CORROSION AT STATION 196 BETWEEN STRINGERS 33-29P. REMOVED RIVETS FOR CORROSION REMOVAL. REMOVED CORROSION IAW SRM 51-21-00-00-02. REMAINING THICKNESS OF .042". WITHIN LIMITS OF .040". ALODINED PRIMED AND PAINTED AREA AND CONFIRMED NO CRACKSDR FOTR2011110706431Frame · corrodedLIGHT SURFACE CORROSION AT FRAME BS 727E, AFT SIDE LWR RBL 3. REPAIRED ON FASI WO 21142, NR 06431.SDR CALA2011110800723Frame · crackedSUPPORT TASK: FUSELAGE FRAME STA 400RT BETWEEN STR 8RT AND STR 9RT CRACKED AT A/C OUTLET ASSY SUPPORT BRACKET FASTENER MOUNTING HOLE. REPAIRED FRAME REF EA 5310-04716 REV C OP 2.SDR CALA2011110800722Frame · crackedSUPPORT TASK: FUSELAGE FRAME STA 480 RT BETWEEN STR 8R AND STR 9R CRACKED AT A/C OUTLET ASSY SUPPORT BRACKET FASTENER MOUNTING BRACKET. REPAIRED FRAME REF EA 5310-04716 REV C OP 2.SDR CALA2011110800721Frame · crackedSUPPORT TASK: FUSELAGE FRAME STA 400 RT BETWEEN STR 8RT & STR 9RT CRACKED AT A/C OUTLET ASSY SUPPORT BRACKET FASTENER MOUNTING HOLE. REPAIRED FRAME REF EA 5310-04716 REV C OP 2.SDR SWAA117722Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 500C, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME IAW EA.SDR SWAA117721Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 480, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME IAW EA.SDR SWAA117720Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 400, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME.SDR SWAA117719Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 480, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME IAW EA.SDR SWAA117717Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA117705Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKD AT BS 188, STR 17L. REPAIRED FRAME IAW SRM.SDR SWAA117701Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 500C, BETWEEN STR 28L TO STR 28R. REPAIRED FRAME IAW AND DWG.SDR SWAA117700Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 500C, BETWEEN STR 27L TO STR 28L. REPAIRED FRAME IAW SRM AND DWG.SDR SWAA117699Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 500B, BETWEEN STR 27R TO STR 28R. REPAIRED FRAME IAW SRM AND DWG.SDR SWAA117698Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 500A, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME IAW SRM AND DWG.SDR SWAA117674Frame · corrodedDURING SCHEDULED 18Y CHECK, FOUND FRAME CORRODED AT BS 947, RBL 3. REPAIRED FRAME PER SRM.SDR UALA2011110706018Frame · corrodedCORROSION ON FRAME CAP AT STA 303, RBL 57. MAJOR REPAIR ACCOMPLISHED: CUT OUT DAMAGED T-CAP SECTION, INSTALLED NEW SECTION WITH 2 ANGLE DOUBLERS.SDR 29GA201111060611Frame · crackedDURING SCHEDULED ROUTINE STRUCTURAL INSPECTION DISCOVERED 1.0 INCH CRACK AT STRINGER 9AR CUTOUT ON FORMER AT FS 177.350. STOP DRILLED CRACK AND INSTALLED REPAIR DOUBLER.SDR USAA2011111100003Frame · crackedC2 CHECK - CRACK IN FUSELAGE FRAME AT BS 500C, S21L. REPAIRED FUSELAGE FRAME AT BS 500C, S21L IAW B737 SRM 53-00-07 REPAIR 13.SDR AALA20111106TUL02Frame · crackedTHE 1418 FRAME CRACKED AT LONGERON 2 LEFT. REPAIRED WITH REPAIR DOUBLER PER SRM 53-03-00 FIGURE 31A.SDR SWAA117636Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 500C, BETWEEN STR 26R TO STR 27R. REPAIRED FRAME IAW SRM AND DWG.SDR SWAA117635Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 500A, BETWEEN STR 28L TO STR 28R. REPAIRED FRAME IAW SRM AND DWG.SDR SWAA117634Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 907, BETWEEN STR 27L TO STR 27R. REPAIRED FRAME IAW SRM.SDR SWAA117624Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 482A, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME IAW SRM.SDR SWAA117615Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME INNER CHORD CRACKED AT BS 616, RBL 64. REPAIRED CHORD IAW EA.SDR SWAA117611Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 927, BETWEEN STR 18L TO STR 19L. REMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR USAA2011110700002Frame · crackedC2 CHECK - CRACK IN FUSELAGE FRAME AT BS 500C BETWEEN S21R TO S22R. REPAIRED FRAME AT BS 500C BETWEEN S21R TO S22R IAW B737 SRM 53-00-07 REPAIR 13.SDR DALA1166980695Frame · corrodedAFT CARGO FRAME DENTED 2 PLACES STA 1480 BETWEEN STR 25-26L. HFEC SURFACE/OPEN HOLE INSPIN REF TO NDTM PT 6,51-00-19& PT6,51-00-16 NO CRACKS NOTED AT CUTOUT OR OPEN HOLE AERA ASSET NR 11-545 CAL DUE 03/03/12 ENLARGED CUTOUT BY 0.040 AS AN INSURANCE CUT IAW B7SDR DALA1168880695Frame · dentedAFT CARGO FRAME DENTED ON UPPER FLANGE STA 1500 ABOVE STR 26L. DENT NOT ALLOWED ON FRAME FLANGE REF B757 SRM 53-00-07, REMOVED PRODUCTION SPLICE, TRIMMED OUT DAMAGED AREA, FABRICATED AND INSTALLED REPAIR IAW B757 SRM 53-00-07 DURING HMV AT ST AEROSPACE SAN ANSDR DALA1166990695Frame · corrodedAFT CARGO FRAME DENTED ON UPPER FLANGE STA 1500 ABOVE STR 26L. TRIMMED OUT THE DENTED AREA OF FRAME FLANGE ON STA 1500 ABOVE S26L IAW 757 SRM 53-00-07 STEP 1 FIG 201 REPAIRS PG 201 REQUEST NDT FOR HFEC INSP OF THE EDGE OF THE CUTOUT AND HFEC INSP OF ALL INITISDR DALA1164220695Frame · dentedAFT CARGO FRAME DENTED ON UPPER FLANGE STA 1500 ABOVE STR 26L.SDR QXEA2011110901199Frame · corrodedFRAME FLANGE HAS CORROSION AT STA 236 BETWEEN STRS 32-31S. REMOVED RIVETS AND BLENDED CORROSION IAW RD 8/4-53-2344. MINIMUM REMAINING THICKNESS .041", CONFIRMED CRACK FREE. FLANGES FOUND TO BE WITHIN LIMITS OF RD 8/4-53-2344. REPAIRED IAW RD 8/4-53-2344.SDR QXEA2011110901198Frame · corrodedFRAME FLANGES HAVE CORROSION AT STA 236 BETWEEN STRS 32-30P. REMOVED RIVETS AND BLENDED CORROSION IAW RD 8/4-53-2344. MINIMUM REMAINING THICKNESS .041", CONFIRMED CRACK FREE. FLANGES FOUND TO BE WITHIN LIMITS OF RD 8/4-53-2344. REPAIRED IAW RD 8/4-53-2344.
Back to JASC 5311