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 ASAA2012091193071Frame · corrodedFRAME LOWER LEG AT FS 500D BETWEEN S-28L AND S-27L CORRODED. REMOVED DAMAGED PORTION OF FRAME FS 500D BETWEEN S-28L AND S-27L. FABRICATED, LOCATED AND DRILLED IAW SRM 53-00-07, REPAIR 7.SDR ASAA2012091193070Frame · corrodedFRAME LOWER LEG AT FS 500 BETWEEN STR 28R AND 28L HAS CORROSION. REMOVED DAMAGED PORTION OF FRAME LEG FS 500 BETWEEN 5-28R AND S-28L. FABRICATED, LOCATED, AND DRILLED IAW 53-00-07, REPAIR 7.SDR IPXA2575544Frame · dentedINSPECTION TYPE: C, AFT CARGO FRAME DENTED AT BS BETWEEN S25-26R IS DENTED. REMOVED DAMAGE AND REPAIRED FRAME IAW EA121071, IEO B757-5310-48692-A.SDR IPXA2575543Frame · dentedINSPECTION TYPE: C, AFT CARGO FRAME AT BS 1500 STR 25L IS DENTED. REMOVED DAMAGED AND REPAIRED FRAME IAW SRM 53-00-07-2R 5, DETAIL III.SDR IPXA2575541Frame · dentedINSPECTION TYPE: C, AFT CARGO FRAME AT BS 1520, STR 25L IS DENTED. REMOVED DAMAGE AND REPAIRED FRAME IAW SRM 53-00-07-2R5, DETAIL 3.SDR IPXA2575540Frame · dentedINSPECTION TYPE: C, AFT CARGO PIT FRAME AT STA 1540 STR 26R IS DENTED. REMOVED DAMAGE & REPAIRED STA 1540 FRAME AT 26R IAW SRM 53-00-07-2R- 5, DETAIL 3.SDR UALA2012091205123Frame · crackedSTA 1140 LEFT FRAME 2 EA HOLES CRACKED AT TENSION TIE. REMOVED AND REPLACED FRAME IAW SRM 51-40-02.SDR UALA2012091205122Frame · crackedSTA 1120 LEFT FRAME 3 EA HOLES CRACKED AT TENSION TIE. REMOVED AND REPLACED FRAME IAW SRM.SDR UALA2012091205121Frame · crackedSTA 1120 RIGHT FRAME 1 EA HOLE CRACKED AT TENSION TIE. REMOVED AND REPLACED FRAME IAW SRM 51-40-02.SDR UALA2012091205118Frame · crackedSTA 1180 RIGHT FRAME 1 EA HOLE CRACKED AT TENSION TIE. REMOVED AND REPLACED FRAME IAW SRM 51-40-02.SDR SWAA2012091907740Frame · corrodedFRAME CORRODED AT BS 500B, BETWEEN STR 28L TO STR 27L. REPAIRED FRAME IAW SRM.SDR SWAA2012091907739Frame · corrodedFRAME CORRODED AT BS 500B, BETWEEN STR 27L TO STR 26L. REPAIRED FRAME IAW SRM.SDR SWAA2012091707658Frame · crackedFRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2012091707657Frame · crackedFRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2012091707656Frame · crackedFRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2012091707655Frame · crackedFRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME IAW EA.SDR QXEA2012091101054Frame · corrodedFRAME 32.4 HAS CORROSION BETWEEN STR 32-30P. CLEANED AND REMOVED FASTENERS AS NECESSARY IAW SRM 51-26-00-02-01 AND 51-40-07-02-01. REMOVED CORROSION IAW SRM 51-21-00-00-02. MIN REMAINING THICKNESS FLANGE .036 WEB .037, CONFIRMED AFFECTED AREA CRACK FREE ARESDR QXEA2012091101020Frame · corrodedFRAME 32.4 HAS CORROSION ON TOP CL. REMOVED RIVETS AS NECESSARY FOM IAW SRM 51-42-05-02-01. BLENDED CORROSION IAW SRM 51-21-00-00-02. MIN REMAINING THICKNESS .039", CONFIRMED AFFECTED AREA CRACK FREE REF NTM 51-00-04-910-801 PT 1 AND 51-00-06-910-801 PT 1. SDR QMLA2012091112150Frame · crackedTAILBOOM ATTACH FRAME, PN 407-030-027-101 WAS REPLACED BY UNITED ROTORCRAFT DUE TO CRACKING. A CRACK WAS DISCOVERED IN FRAME INSTALLATION ANGLE, PN 206-032-308-107 IN THE APEX OF THE BEND WHERE IT ATTACHES TO ABOVE MENTIONED TAILBOOM ATTACH FRAME. CRACKS IN SDR FDEA201209113289Frame · dentedDENT FOUND ON FRAME AT FR 20A RT AFT FACE AND BETWEEN STR 40 TO 41, LOWER SECTION, DENT AT FR 20A RT AFT FACE BETWEEN STR 40 TO STR 41 FOUND ACCEPTABLE IAW EA 6-5300-157946 AND RAS 70566040/003/2012. JPF ATTACHED, SHEET 1, STAGES 1-3.SDR FDEA201209113285Frame · dentedCABIN FRAME HAS A DENT BS 377, STR 6R. COMPLIED WITH EA F-5310-162465SDR CALA2012091100598Frame · gougedBOTTOM OF FRAME GOUGED. FRAME 294.5 AT S-3L. REPAIR FRAME STA 294.5 AT S3L REF SRM 53-00-07, REPAIR 1.SDR SWAA2012092107867Frame · crackedFRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2012092107866Frame · crackedFRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME IAW EA.SDR QXEA2012091001058Frame · corrodedCORROSION ON AFT SIDE OF FRAME 664.5 AT 24P. REMOVED CORROSION IAW SRM 51-21-00-00-02. MIN REMAINING THICKNESS NOTED .058", CONFIRMED AFFECTED AREA CRACK FREE REF NTM 51-00-04-910-801 PT 1 AND 51-00-06-910-801 PT 1. BLENDS WITHIN LIMITS IAW RD 8/4-53-4737. SDR QXEA2012091001022Frame · corrodedFRAME BS 176 HAS CORROSION BETWEEN STR 32-31S. CLEANED AREA AND REMOVED CORROSION IAW 51-26-00-02-01 AND RD 8/4-53-2344. TRIMMED DAMAGE FLANGE IAW RD 8/4-53-017. CONFIRMED AFFECTED AREA AND CUTOUT ARE CRACK FREE REF NTM 51-00-04-910-801 PT 1 AND 51-00-06-910SDR QXEA2012091001013Frame · corrodedFRAME 301 HAS CORROSION BETWEEN STR 31-29P. REMOVED RIVETS AS NECESSARY IAW SRM 51-42-05-02-01. REMOVED CORROSION IAW SRM 51-21-00-00-02. FOUND PREVIOUS REPAIR FLANGE TO BE OUT OF LIMITS IAW RD 8/4-53-2344. REMOVED EXISTING FRAME FLANGE REPAIR IAW SRM 51-4SDR F3LA2012091300786Frame · corrodedC-CHECK: FRAME 68-1292, RM 51-42-11, PARA 5 AND SRN 53-00-14 PB 101B.SDR QXEA2012091000997Frame · corrodedFRAME 258 HAS CORROSION BETWEEN STR 32-31P. BLENDED CORROSION IAW SRM 51-21-00-00-02. REMOVED RIVETS AS REQUIRED IAW SRM 51-42-05-02-01. POLISHED SURFACE REF RD 8/4-53-2344. MIN REMAINING THICKNESS FLANGE .036" WEB .038", CONFIRMED AFFECTED AREA CRACK FREESDR ERAA20120061Frame · crackedWHILE PERFORMING TASK CARD 5310/08A(1) FUSELAGE OUTER FRAME AT STATION 333.30 6L AND 6R WERE FOUND TO HAVE A CRACK EMINATING FROM THE LAST OUTBOARD RIVET. THE REPAIR WAS ACCOMPLISHED IAW RD8-53-4811 A GENERIC LOOSE ANGLE REPAIR FOR THE FUSELAGE FRAMES.SDR CALA2012091100597Frame · crackedLEFT FRAME STA 380 SHOW CRACK IND MFEC & HFEC INBD FASTENER. REPAIRED FRAME DAMAGE AT BS 380 LT IAW EA 5310-04716.SDR CALA2012091000584Frame · crackedLEFT FRAME BS 480 HAS A CRACK INDICATION, MFEC & HFEC INBD FASTENER. REPAIRED FRAME DAMAGE AT BS 480 LT EA5310-04716.SDR ASOA20120909100VFitting · corrodedDURING C-CHECK, FRAME 75 FITTING BETWEEN STR 2R-2L HAS CORROSION AT OTBD MAIN BOLT HOLES. MX PERFORMED REPAIR ON FRAME 75 FITTING BETWEEN STR 2R-2L IN IAW EC5310-01627 AND CPM 51-21-06. ACFT APPROVED FOR RETURN TO SERVICE.SDR IPXA12575608Frame · dentedINSPECTION TYPE: C, AFT CARGO COMPARTMENT FRAME DENTED, BS 1220, BETWEEN STRINGERS 25L AND 26L. REMOVED DAMAGE AND REPAIRED FRAME IAW EA 121051IR/ EO B757-5310-48711-A.SDR IPXA12575607Frame · dentedINSPECTION TYPE: C, AFT CARGO COMPARTMENT, FRAME DENTED, BS 1240, AT STRINGER 25L. REMOVED DAMAGE AND REPAIRED FRAME IAW EA 121052IR/EO B757-5310-48708-A.SDR IPXA2575546Frame · dentedINSPECTION TYPE: C, AFT CARGO FRAME DENTED BS 1320 BETWEEN STRINGERS 25 - 26L. REMOVED DAMAGE AND REPAIRED FRAME IAW SRM 53-00-07-2R5, DETAIL III.SDR IPXA2575545Frame · dentedINSPECTION TYPE: C, AFT CARGO FRAME DENTED STATION 1480, JUST ABOVE STRINGER 26L. REMOVED DAMAGE AND REPAIRED FRAME IAW SRM 53-00-07- 2R5, DETAIL III.SDR IPXA2575538Frame · dentedINSPECTION TYPE: C, AFT CARGO FRAME DENTED BS 1340 JUST BELOW STRINGER 26 L. REMOVED DAMAGE AND REPAIRED FRAME IAW SRM 53-00-04 -2R5, DETAIL 2.SDR DALA13040173101Frame · corrodedFRAME 20 CORRODED. OPENSDR IPXA12575606Frame · damagedINSPECTION TYPE: C, MAIN CARGO BS 1340 FRAME DAMAGE BETWEEN STR 15-16 RT. REPAIRED FRAME IAW EA 121058 IR AND EO B757-5310-48710-A.SDR SWAA2012092708085Frame · corrodedFRAME CORRODED AT BS 889, STR 30. REPAIRED FRAME IAW SRM.SDR CALA2012090700576Frame · crackedFRAME BS 727D SHOWS A CRACK INDICATION MFEC & HFEC INBD FASTENER PERFORMED REPAIR TO LT FRAME BS 727D, REF EA 5310-04716.SDR CALA2012090700583Frame · crackedFRAME BS 907 CRACKED AT FASTENER HOLE BETWEEN S8 - 9R. FRAME REPAIRED IAW ECRA 5310-05581.SDR CALA2012090700582Frame · crackedFRAME BS 907 BETWEEN STR 8-9L CRACKED. FRAME REPAIRED IAW ECRA 5310-05581.SDR CALA2012090700581Frame · crackedRT FRAME BS 827 SHOW CRACK INDICATIONS MFEC AND HFEC INBD FASTENER. INSTALLED REPAIR ANGLES IAW EA 5310-04716.SDR CALA2012090700580Frame · crackedLT FRAME BS 867 SHOW CRACK INDICATIONS. MFEC & HFEC INBD FASTENER. REPAIRED LT FRAME IAW EA5310-04716.SDR CALA2012090700579Frame · crackedLT FRAME, BS 827 SHOWS CRACK INDICATIONS MFEC AT HFEC INBD FASTENER. REPAIRED FRAME IAW 5310-04716- REV C.SDR CALA2012090700578Frame · crackedRT FRAME 727D SHOWS A CRACK INDICATION MFEC & HFEC INBD FASTENER REPAIRED DAMAGE IAW EA 5310-04716.SDR CALA2012090700577Frame · crackedRT FRAME BS 747 SHOW CRACK INDICATION MFEC AND HFEC INBD FASTENER REPAIRED DAMAGE IAW EA 5310-04716.SDR SWAA2012091207530Frame · crackedFRAME CRACKED AT BS 747R, STR 8R. REPAIRED FRAME IAW EA.
Back to JASC 5311