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 FDEA201305191018Frame · corrodedCABIN BS 1620, S16-17L, FRAME INBD EDGE FOUND CORRODED. REPAIRED IAW SRM 51-10-02, REV 108 AND STA EA 757-5362-08-E2214, REV.SDR SWAA2013052116292Frame · crackedAFT ALLY CANTED FRAME CRACKED AT STA 1189. R & R FRAME IAW SRM.SDR CALA2013052100326Frame · crackedCABIN FRAME CRACKED AT BS 867, BETWEEN S8-9R AROUND RIVET AT AIR CONDITIONING SUPPORT BRACKET. INSTALLED INTERIM REPAIR IAW ECRA 5310-05743.SDR CALA2013052100325Frame · crackedCABIN FRAME CRACKED, BS 827, BETWEEN S8-9R AROUND INBD RIVET AT AIR CONDITIONING OUTLET SUPPORT BRACKET. INSTALLED REPAIR IAW ECRA 5310-057 41.SDR CALA2013052100324Frame · crackedFRAME FOUND CRACKED AT INBD RIVET BS 827 AT LT AIR CONDITIONING RAIL BRACKET. INSTALLED REPAIR IAW EA 5310-04716, REV D, OP 01 AND ECRA 5310-05728.SDR C77A20130518018Frame · gougedDAMAGE FOUND ON RT SIDE OF REAR PRESSURE BULKHEAD RING BETWEEN STRINGERS 12R AND 13R. X=25278.0. BLENDED OUT DAMAGE IAW SRM PART II 51-40-01 AND 51-10-03.SDR ASOA2013061903832Frame · corrodedFRAME CORRODED AT FS 333 AND BETWEEN STR27 AND 26L. REPAIRED IAW SRM 57-21-06-001-001-A01 AND REO 690-53-21-468. CLASSIFIED AS A MAJOR REPAIR.SDR ASOA2013061903831Frame · corrodedFRAME CORRODED AT FS 333 AND BETWEEN STR 26 AND 27R. REPAIRED IAW SRM 51-21-06-001-001-A01 AND REO 690-53-21-468. CLASSIFIED AS A MAJOR REPAIR.SDR IPXA3578736Frame · dentedINSPECTION TYPE:C-16, AFT CARGO BAY INTERIOR SIDE BODY FRAME DENTED ON UPPER SURFACE BS1300, STR 25L-STR 26L. REPAIRED FRAME IAW REO G16286, EO B757-5310-50977-A.SDR ABXA20130517444Frame · corrodedUPPER CARGO RT SIDE STA 1219 AT S-18 HAS CORROSION ON FRAME. FRAME AT STA 1219 S-18 RT WAS FOUND TO BE OUT OF LIMITS, AND REPAIRED IAW SRM 53-00-07, FIG 201; ACFT WAS GROUNDED.SDR IPXA13578604Frame · dentedINSPECTION TYPE:C15, MAIN CABIN FRAME AT BS 540 IS DENTED AND CRACKED BETWEEN S5-6R. FABRICATED AND INSTALLED REPAIR IAW SRM 53-00-07-2R-1.SDR IPXA13578592Frame · dentedINSPECTION TYPE:C-16, AFT CARGO BAY INTERIOR SIDE BODY FRAME DENTED ON UPPER SURFACE, BS1220, STR 25R-STR 26R. FABRICATED AND INSTALLED REPAIR IAW SRM 53-60-07-2R-1 AND 53-00-07-2R-6, DETAIL V.SDR FDEA201305171014Frame · damagedCENTER FUSELAGE, THE UPPER FRAME 45 BASE-TO-ARCHES JUNCTION FOUND HOLE NR 22 WITH CRACK SIGNAL AND THE CRACK IS ELIMINATED WHEN THE HOLE DIMENSION IS 0.551" (RT SIDE). COMPLIED WITH EA6-5310-168229.SDR FDEA201305171013Fitting · damagedCENTER FUSELAGE UPPER FRAME 44 BASE-TO-ARCHES JUNCTION FOUND HOLE NR 5 WITH CRACK SIGNAL AND THE CRACK IS ELIMINATED WHEN THE HOLE DIMENSION IS 0.472". (LT SIDE) COMPLIED WITH EA6-5310-168229SDR IPXA3578544Frame · dentedINSPECTION TYPE:C-16, AFT CARGO BAY INTERIOR SIDE BODY FRAME DENTED ON UPPER SURFACE BS 1340 S25-26R. FABRICATED AND INSTALLED REPAIR IAW SRM 53-60-07-2R-1 AND 5 3-00-07-2R-5, DETAIL II.SDR IPXA3578496Frame · dentedINSPECTION TYPE:C-16, AFT CARGO BAY INTERIOR RT SIDE FRAME DENTED ON UPPER FRAME BS 1500 STR 26-27R. FABRICATED & INSTALLED FRAME REPAIR IAW SRM 53-00-07-2R-5.SDR IPXA3578485Frame · dentedINSPECTION TYPE:C-16, AFT CARGO BAY INTERIOR SIDE BODY FRAME DENTED ON UPPER SURFACE BS 1320, STR 26R. FABRICATED AND INSTALL REPAIR IAW SRM 53-60-07-2R-1 AND 53 -00-07-2R-5, DETAIL I.SDR DALA13023950857Frame · crackedAFT PRESSURE BULKHEAD FORMER AT LONGERON 14L CRACKED. INSTALLED DOUBLERS IAW SRM 53-01.SDR HNAA2013051700295Frame · crackedCRACK FOUND ON FRAME IN CABIN UNDERFLOOR AT BS 251, BETWEEN S33-32S. REPAIRED IAW RD8-53-4811. COMPLIED WITH HFEC INSPECTION. NO OTHER DEFECTS FOUND.SDR UALA2013051703422Frame · corrodedAFT CARGO EQUIPMENT BAY BILGE FRAME WEB IS CORRODED BS 1661, STR 27-28L. TRIMMED OUT DAMAGE AND REPAIRED WEB IAW ECRA 5360-01292 AND EA 130471. MAJOR REPAIR.SDR DALA13023180948Frame · corrodedAFT ACCESSORY COMPARTMENT FRAME AT BS 1380 LOWER RT SIDE SHOWS EVIDENCE OF CORROSION AROUND FASTENERS. REPLACED FRAME WITH FABRICATED IAW SRM 51-30-02, PARA 1, SRM 53-01, PARA 3, SRM 51-20-0, PARA. 4, DWG 9912246-109 & 9912246-121, SRM 51-10-4, PARA 2, SRM 51SDR CALA2013051700313Frame · crackedFRAME FOUND CRACKED BS 500A. REPAIRED FRAME IAW EA 5310-04716, REV E OP1 AND ECRA 5310-05728.SDR CALA2013051700312Frame · crackedFRAME FOUND CRACKED BS 400. REPAIRED CRACKED FRAME IAW EA 5310-04716, REV E OP1 AND ECRA 5310-05728.SDR CALA2013051700306Frame · crackedFRAME BETWEEN STRINGER 8 AND 9L BS 440 CRACKED. REPAIRED FRAME IAW EA 5310-04716, REV E.SDR CALA2013051700311Frame · crackedFRAME CRACKED BETWEEN STRINGER 8 & 9R BS 727D. REPAIRED FRAME IAW EA 5310-04716 REV E OP1 AND ECRA 5310-05728.SDR CALA2013051700310Frame · crackedFRAME FOUND CRACKED BS 480. REPAIRED FRAME IAW EA 5310-04716, REV E, OP1 AND ECRA 5310-05728.SDR CALA2013051700309Frame · crackedFRAME CRACKED BETWEEN STRINGER 8 & 9R BS 787. REPAIRED FRAME IAW EA 5310-04716, REV E OP1 AND ECRA 5310-05728.SDR AALA20130516014Frame · crackedFRAME CRACKED AT THE LOWER END BELOW VENTRAL STAIR ACTUATOR. ACCOMPLISHED SPLICE REPAIR IAW 53-10-00-33, FIG 2.SDR HNAA2013051600280Frame · corrodedSURFACE CORROSION AND CRACK FOUND ON FRAME AT BS 503.80, STR 31S. CLEANED CORROSION, REPAIRED FRAME MEMBER. HFEC INSPECTION WAS COMPLIED WITH. NO CRACK FOUND. FRAME REPAIR WAS IAW RD8-53-4811 AND EO8-53-13-0267.SDR QXEA2013051501009Frame · corrodedFRAME BS 664 CORRODED AT STRINGER 24P FWD AND AFT SIDE. AFTER CORROSION REMOVAL IAW SRM 51-21-00-00-02 FOUND TO BE CRACKED. REMOVED FRAME IAW SRM 51-42-05-02-01. MATCH DRILLED/APPLIED SURFACE PROTECTION IAW SRM 51-40-07-02-01, 51-21-10-02-01, 51-25-10-02-01 SDR QXEA2013051500996Frame · corrodedFRAME BS 547, FLANGE REINFORCING DOUBLER IS CORRODED BELOW STR 24S. REMOVED FRAME REINFORCING DOUBLER IAW SRM 51-42-05-02-01, REV 12. NOTE: .012 LOSS AFTER CORROSION BLENDED. FOUND TO BE OUT OF LIMITS IAW SRM 53-30-15-00-01, REV 12. MATCH DRILLED NEW DOUBLESDR CALA2013051700308Frame · crackedFRAME BETWEEN STRINGER 8 & 9R BS 400 CRACKED. REPAIRED FRAME IAW EA 5310-04716, REV E, FIG 3, PG 1-8.SDR GLBA2013051600248Frame · crackedDURING A SCHEDULED ROUTINE INSPECTION FOUND A CRACK AT FS 107 AT THE INTERSECTION OF LONGERON UNDER RT FINGER DOUBLER, .5" IN LENGTH. REPAIRED IAW EO 13-1900-53-040. MAJOR REPAIR.SDR AALA20130515106Frame · crackedTHE 1485 CANT FRAME CRACKED BELOW STAIR RETENTION ACTUATOR. ACCOMPLISHED REPAIR ON 1485 CANT FRAME PER AARD 53-10-00-33.SDR SCNA20130516104Frame · gougedLEFT FUSELAGE STA 500B FRAME HAS A GOUGED SPOT APPROX 12 IN ABOVE FLOOR. REPAIRED LT FUSELAGE FRAME STA 500B APPROX 12" ABOVE FLOOR.SDR FDEA201305150996Frame · corrodedBS 1640 FRAME INBD EDGE FOUND CORRODED BETWEEN S5 - 6L. REPAIRED IAW STA EA 757-5362-08-E2225, REV.SDR FDEA201305150995Frame · corrodedBS 1681 FRAME FOUND CORRODED AT S5L. REPAIRED IAW SRM 51-10-02, REV 108 AND STAE EA 757-5362-08-E2226, REV-.SDR CALA2013051500296Frame · crackedFRAME BETWEEN STRINGER 8 AND 9R BS 500F INBD FASTENER HAS A CRACK. REPAIRED FRAME IAW EA 5310-04716, REV. E.SDR CALA2013051500295Frame · crackedFRAME BETWEEN STRINGER 8 AND 9L BS 400 INBD FASTENER HAS A CRACK. REPAIRED FRAME IAW EA 5 310-04716 REV E,SDR SWAA2013061217119Frame · corrodedFRAME CORRODED AT BS 360, BETWEEN STR 27L TO STR 28L. REPAIRED FRAME IAW SRM.SDR CALA2013051500294Frame · crackedFRAME BETWEEN STRINGER 8 AND 9R BS 500C RT INBD FASTENER HAS A CRACK. REPAIRED REF EA 5310-04716, OP 1, REV E.SDR CALA2013051500293Frame · crackedFRAME BETWEEN STRINGER 8 AND 9R BS 440 RT INBD FASTENER HAS CRACK REPAIRED REF EA 5310-04716 OP1, REV E.SDR DALA1313000681Frame · dentedDENT ON UPPER FLANGE OF FRAME AT BS 640 ABOVE S24R FWD CARGO. ACCOMPLISHED ERA 514336-4, ORIG.SDR DALA1312990681Frame · dentedTWO DENTS ON UPPER FUSELAGE FLANGE OF FRAME AT BS 580 BETWEEN S23-24L & CTR OF PRODUCTION SPLICE. ACCOMPLISHED ERA 514337-1, REV ORIG.SDR DALA1312970681Frame · dentedSMALL DENT ON INNER FREE FLANGE OF FUSELAGE FRAME BS 1480 BETWEEN STR 25L & 26L. ACCOMPLISHED REPAIR IAW SMR 53-00-07, FOR 201, REPAIR 5.SDR UIEA2013051400279Frame · crackedCRACK INDICATION NOTED ON LT AFT INNER CHORD OF FRAME AT BS 2231 S19L LOWER AFT HOLE LT SIDE. REPAIRED FRAME IAW SRM 53-60-15-2R-2.SDR SWAA2013062017445Frame · crackedFRAME CRACKED AT BS 188, STRINGER 17R. R&R FRAME IAW SRM & DRAWING.SDR SWAA2013062017444Frame · crackedFRAME CRACKED AT BS 188, STRINGER 17L. REPAIRED FRAME IAW SRM.SDR SWAA2013061817277Frame · corrodedFRAME LOWER FLANGE OF FRAME CORRODED AT BS 787, BETWEEN STRINGER 26L AND STR 27L. R & R FRAME IAW SRM AND DWG.SDR DALA1315240682Frame · dentedAFT CARGO FRAME, BS 1340, S25-26R DENTED. REPAIRED IAW SRM 53-00-07, FIG 201, REPAIR 5 DETAIL I.
Back to JASC 5311