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 2007UALA01063Frame · corrodedFRAME 32 HAS 5 EA FRAME CLEATS WITH CORROSION BETWEEN STR 42L AND STR 40R. MAJOR REPAIR ACCOMPLISHED: REPLACED CLEATS.SDR UIEA200700178Doubler · crackedRT BS 900 TENSION TIE AREA HOLE NR 5 FOUND CRACKED AT FRAME DOUBLER, INSULATION BLANKET HOLE FOUND CRACKED AT FRAME DOUBLER BETWEEN S-8R TO S-9R AND S-10R TO S-10AR. FRAME DOUBLER REPAIRED AS PER BOEING MSG 1-306586780-2.SDR UIEA200700152Frame · crackedUPPER DECK STATION 740 STRINGER 6R FRAME CUTOUT CRACKED. REPAIRED STRINGER CUTOUT PER SRM 53-10-04 FIG 54.SDR UIEA200700191Frame · crackedBS 360 LT S24A STRINGER CUT-OUT CRACKED. CRACKED FRAME WEB REPAIRED AS PER BOEING MSG 1-307193755-1-2.SDR UIEA200700196Frame · crackedRT BS 900 TENSION TIE AREA NR 5 HOLE FOUND CRACK AT FRAME WEB THRU THICKNESS RUNNING I/B AND NR 10 HOLE FOUND CRACK AT FRAME WEB APPROX 0.060" IN LENGTH RUNNING DOWNWARD. CRACKED FRAME WEB REPAIRED AS PER BOEING MSG 1-306586780-2.SDR UIEA200700189Frame · crackedM/D STA 360 S-23R FRAME STRINGER CUT-OUT CRACK. CRACKED FRAME REPAIRED AS PER BOEING MSG 1-307825515-2-1.SDR 2007UALA01060Frame · corrodedFRAME 30 HAS 7 EA FRAME CLEATS WITH CORROSION BETWEEN STR 40R AND STR 41L. MAJOR REPAIR ACCOMPLISHED: REMOVED & REPLACED CLEATS.SDR SWAA071741Frame · corrodedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 360, STR 28L. REPAIRED FRAME PER ER.SDR UIEA200700154Frame · deformedMAIN DECK STATION 2000 STRINGER 13R FRAME INNER FLANGE FOUND DEFORMED. REPAIRED FLANGE PER SRM 51-40-03 FIG 1.SDR UIEA200700153Frame · deformedMAIN DECK STATION 1960 STRINGER 13R FRAME INNER FLANGE FOUND DEFORMED. REPAIRED PER SRM 51-40-03 FIG 1.SDR UIEA200700192Frame · crackedM/D STA270 S-R13A AREA FRAME CRACK. CRACKED FRAME WEB REPAIRED AS PER BOEING MSG 1-307196918-1-2.SDR EIA20070073Frame · damagedNOSE GEAR WELL STA 340, LEFT WL 150 FOUND BASE AND HOLES DAMAGED 1/2" BY 1/2" BEYOND SRM 53-10-01 PAGE 3 FIG 1 LIMIT. CHORD FABRICATED BY WORKSHOP INSTALLED PER BOEING 747 SRM 51-30-02.SDR DHL2007806603Frame · damagedMAIN CARGO COMPT FRAME HAS A MISDRILLED HOLE STA 1680.000 L-21L (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW FAA FORM 8110-3 DATED 03-30-07. REPAIR ORDER NR 2-50561-801 DATED 03-29-07 (ED-4504). PERFORMED NDT INSPECTION IAW DC8 NDT SPM PART 06-10-01-001. NOSDR DHL2007806544Frame · damagedMAIN CARGO COMPT FRAME HAS A MISDRILLED HOLE STA 980.000 L-12L (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW FAA FORM 8110-3 DATED 03-30-07, REPAIR ORDER NR 2-50561-801 DATED 03-29-07 (ED4502). PERFORMED NDT INSPECTION IAW DC8 NDT SPM PART 06-10-01-001. NO CRASDR DHL2007806545Frame · damagedMAIN CARGO COMPT FRAME HAS A MISDRILLED HOLE STA 960.000 L-20L TO L-21L (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW FAA FORM 8110-3 DATED 03-30-07, REPAIR ORDER NR 2-50561-801 DATED 03-29-07 (ED-4500). PERFORMED NDT INSPECTION IAW DC8 NDT SPM PART 06-10-01-00SDR ABXA070109Frame · crackedWHILE COMPLYING WITH EA 53300036-003, COCKPIT WINDOW ENCLOSURE MOD PER AD 2002-21-09, DOUBLER P/N: 991505-5 WAS FOUND CRACKED .75. REPLACED IAW EA 53300036-003 THROUGH 017 AND WO 600265187, S/B DC9 53-290 AND DWG SR09530268.SDR ABXA070108Frame · crackedWHILE COMPLYING WITH EA 53300036-003, COCKPIT WINDOW ENCLOSURE MOD PER AD 2002-21-09, DOUBLER P/N: 991505-7 WAS FOUND CRACKED, 1.0" AND .875. REPLACED IAW EA 53300036-003 THROUGH 017 AND WO 600265187, S/B DC9 53-290 AND DWG SR09530268.SDR 2007UALA01043Frame · crackedFWD ENTRY DOOR FWD SURROUND, WEB CRACKED FRAME BS 294 STR 11. MAJOR REPAIR: REMOVED AND REPLACED SHEAR TIE WEB AT 11L STA 294.5. REFERENCE AAR EAI070215 REV IR AND UA-EVA-70168.SDR UIEA200700179Frame · crackedLT BS 200 FRAME IS FOUND CRACKED AT 11EA FASTENER HOLES BETWEEN S13L AND S14L. CRACKED FRAME WEB REPAIRED AS PER SRM 51-40-03 FIG 1.SDR UIEA200700198Frame · crackedM/D LT BS 200 FRAME INNER CHORD IS FOUND CRACKED AT 1 FASTENER HOLE BETWEEN S13L AND S14L. CRACKED INNER CHORD REPAIRED AS PER SRM 51-40-03 FIG 1.SDR NWAA071556744Frame · crackedDURING "M" CHECK, FOUND CRACK IN FRAME AT BS 2120 S25R AND S26R. REPAIRED PER EA 67-208996.SDR 07FDEA01333Frame · crackedFWD AVIONIC COMPT CRACK 6" LONG ON FRAME. REPAIRED FRAME IAW SRM 53-30-00 FIGURE 5 SHT 1-2 VOL 1.SDR AWXA200700466Frame · crackedMCN - FORWARD CARGO COMPARTMENT DOOR CUT OUT, AFT FRAME CRACKED, BS 492.50, S24R AT LOWER STOP FITTING. REPAIRED FORWARD CARGO COMPARTMENT DOOR CUT OUT, AFT FRAME, BS 492.50, S24R AT LOWER STOP FITTING IAW AWA ER 03-5300-07093-SS2.SDR 07FDEA01311Frame · crackedDEVIATION TO EO 6-5310-7-5020-SB A310-53-2124- AD 2006-020-06, CRACKS IN FRAME FEET C43, C46 RT REPAIR PERFORMED BY REMOVING THE CRACKS THRU OVERSIZING IAW EA 6-5315-106424 AND RAS 049395/047/2007 ISS. ASDR 07FDEA01310Frame · crackedDEVIATION TO EO 6-5310-7-5020, SB A310-53-2124, AD 2006-02-06, CRACKS IN FRAME FEET , C45, C46 LT REPAIR PERFORMED BY CRACK REMOVING THRU OVERSIZING IAW EA 6-5315-106424 AND RAS 049395/047/2007 ISS A.SDR USAA070267Frame · crackedSTA 639 BELOW STR 16L HAS CRACK. REMOVED DAMAGE & INSTALLED REPAIR PARTS PER EA 98542, DEFECT SIZE: 2 INCHES.SDR USAA070268Frame · crackedFWD CARGO DOOR AFT FRAME LOWER DOORSTOP FITTING AREA, BS 492, S24R HAS CRACK. REMOVED & INSTALLED NEW FRAME PER BOEING DWG 65-20723 & SRM 51-40-02, DEFECT SIZE: 2 INCHES.SDR UPS07549764Frame · dentedINSPECTION TYPE:C DENT IN AFT CARGO FUSELAGE FRAME STA 1500, S26R. ACCOMPLISHED ON EA 757-5362-27-A1648 AND UPS B757-5310-26691-A.SDR UPS07549757Frame · dentedINSPECTION TYPE:C DENT IN AFT CARGO FUSELAGE FRAME STA 1340, BETWEEN S25L AND S26L. TRIMMED OUT DAMAGE AREA 1.56"W X 0.96"L IAW EA 757-5362-27-A1650. PRELIMINARY 1 STEP 1. HFEC AREA PER NTM 51-00-00 PT6. NO CRACK INDICATIONS NOTED. TRIMMED OUT .040" AROUNSDR UPS07549756Frame · dentedINSPECTION TYPE:C DENTS IN FORWARD CARGO FUSELAGE FRAME STA 820, BETWEEN S22R AND S24R (2EA). REMOVED DAMAGE 2 PLACES UPPER L=1.0" W=1.160" LOWER 1.400 W=1.160 IAW EA757-5362-27-A1651. NDT ON REWORK AREA IAW NTM 51-00-00 PT.6 NO CRACKS NOTED. ENLARGED THE TSDR UPS07549755Frame · dentedINSPECTION TYPE:C DENT IN AFT CARGO FUSELAGE FRAME STA 1560, S26L. ACCOMPLISHED ON FINAL EA 757-5362-27-A1647 AND UPS 757-5310-26668-A.SDR UPS07549754Frame · dentedINSPECTION TYPE:C DENTS IN AFT CARGO FUSELAGE FRAME STA 1480, BETWEEN S25L AND 26L (2EA). ACCOMPLISHED ON FINAL EA 757-5362-27-A1644 AND UPS ENG B757-5310-26669-A.SDR UPS07549753Frame · dentedINSPECTION TYPE:C DENT IN FORWARD CARGO FUSELAGE FRAME STA 720, S24L. REMOVED DAMAGED AREA L 1.200X W 1.160 PER EA 757-5362-27-A1652. NDT ON REWORK AREA IAW NTM 51-00-00 PTG NO CRACKS NOTED. PERFORM. 040" INSURANCE CUT L 1.32" X 1.200 PER EA 757-5362-27-A16SDR UPS07549752Frame · dentedINSPECTION TYPE:C DENTS IN AFT CARGO FUSELAGE FRAME 1540, BETWEEN S25R-S26R (2EA). ACCOMPLISHED ON FINAL EA 757-5362-27-A1645 AND UPS B757-5310-26662.SDR UPS07549746Frame · dentedINSPECTION TYPE:C DENT IN AFT CARGO FUSELAGE FRAME STA 1320, BETWEEN S25L AND S26L. TRIMMED OUT DAMAGED AREA 1.55"W X 1.10"L IAW EA 757-5362-27-A1643 STEP 1. HFEC INSPECTED AREA PER NTM 51-00-00 PT6. NO CRACK INDICATION NOTED. TRIMMED OUT .040" AROUND CUT SDR UPS07549719Frame · dentedINSPECTION TYPE:C DENT IN AFT CARGO FUSELAGE FRAME STA 1460, BET S26R AND S27R. ACCOMPLISHED ON FINAL EA NR 757-5363-27-A644 AND UPS NR B757-5310-2663-A.SDR UPS07549712Frame · dentedINSPECTION TYPE:C DENT IN AFT CARGO FUSELAGE FRAME STA 1500, 526R. ACCOMPLISHED ON EA 757-5362-27-A1648 AND UPS NR B757-5310-26691-A.SDR UPS07549711Frame · dentedINSPECTION TYPE:C DENT IN AFT CARGO FUSELAGE FRAME STA 1520. ACCOMPLISHED ON FINAL EA NR 757-5362-27-A1646 AND UPS NR B757-5310-26672-A.SDR 2007UALA01015Frame · corrodedFR27 HAS 1 EACH FRAME CLEAT WITH CORROSION BETWEEN STR 43R AND STR 44.SDR SIMA200709911Frame · damagedADDITIONAL HOLE DRILLED DURING ACCOMPLISHMENT OF EMB SB 145-53-0068 AT FRAME 47 BETWEEN STRINGER 10L AND STRINGER 11L. FABRICATED AND INSTALLED REINFORCEMENT ON FRAME 47 BETWEEN STRINGER 10L AND 11L IAW EMB IC2007-145-02316. AIRCRAFT RETURNED TO SERVICE.SDR 07FDEA01282Frame · crackedRT AIR COND COMPT FOUND CRACK 5" LONG ON FRAME STA 535. REPAIRED FRAME IAW SRM 53-30-00 FIG 5 AND SRM 53-00-01 FIG 8 VOL 1.SDR 07FDEA01277Frame · crackedCENTRAL CARGO COMPT 2 CRACKS 5" AND 7" LONG STA 1671. REPLACE LONG AFA3040-1 AND REPAIRED FRAME IAW SRM 53-30-00 FIG 5 AND 10 VOL 1.SDR SWAA071720Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 807, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA071719Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8R. REPAIRED FRAME PER SWA EA.SDR 07FDEA01301Frame · corrodedLOWER AFT PIT BILGE, FRAME HAS APPROX 3 SQ INCHES OF CORROSION ON AFT LOWER FACE AT STA. 950A, LBL 8". REMOVED CORROSION REF 51-10-2 AND 53-10-1. NDT'D FOR MATERIAL LOSS, FOUND AREA OUT OF LIMITS REF SRM 53-10-1 FIG 1. REMOVED SUPPORT BRKT, VERT SUPPORT BRKSDR 07FDEA01250Frame · chafedFOUND CRACKED FRAME-SEGMENT AT C74, P26 LT. REPLACEMENT OF THE AFFECTED FRAME-SEGMENT.SDR NWAA071546744Frame · crackedDURING "M" CHECK, FOUND CRACKS IN FRAME FASTENER HOLES AT TENSION TIE AREA BS 820 LT AND RT. REPAIRED PER EA 67-208989.SDR NWAA071536744Frame · crackedDURING "M" CHECK FOUND CRACKS IN FASTENER HOLE FRAME WEB TENSION TIE AREA AT BS 840 LT AND RT. REPAIRED PER EA 67-208992.SDR SWAA071675Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA071674Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SWA EA.
Back to JASC 5311