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 DHL2007741510Frame · dentedFWD PIT HAS 1 EA DENT IN RADIUS OF FRAME AT BS 700 BETWEEN STR 23L AND 24L. CUT OUT DAMAGED AREA 1.5" BY 1.25", FABRICATED REPAIR DOUBLER FROM 7075-T0, .071" BY 9.75" BY 3.75", PO NR 9004690, PER B727 SRM 51-40-3 FIG 1. HEAT TREATED REPAIR PART TO 7075-T6 PESDR UPS07850388Frame · crackedINSPECTION TYPE:C2 STA 70 FRAME CRACKED AND CORRODED BETWEEN L31R AND L32R IN A/C COMPT. REPAIRED CRACKED AND CORRODED FRAME AT STA 70 BETWEEN L31R AND L32R IN A/C BAY IAW SRM 53-02-05 FIG 08C2.SDR DHL2007741515Frame · dentedFWD PIT, 1 DENT IN RADIUS OF FRAME AT BS 680, STR 23L TO 24L. CUT OUT DAMAGED AREA 1.5" BY 1", FABRICATED REPAIR DOUBLER FROM 7075-T0, .071" BY 12" BY 4" BY 1", PO NR 9004690, PER B727 SRM 53-10-2 FIG 3, AND 51-40-3 FIG 1. HEAT TREATED REPAIR PART TO 7075-T6SDR DHL2007741513Frame · dentedFWD PIT, BS 720A, DENT IN RADIUS OF FRAME BETWEEN STR 24L AND 25L. CUT OUT DMG, 1" BY 1", FABRICATED REPAIR ANGLE FROM 7075-T0, .071" BY 10" BY 4" BY 1", PO NR 9004690, PER B727 SRM 53-10-2 FIG 3 AND 51-40-3 FIG 1. HEAT TREATED REPAIR ANGLE TO 7075-T6 PER FASDR NWAA072596729Frame · crackedDURING "L" CHECK, FOUND CRACKS IN FRAME FASTENER HOLES AND SHORT EDGE MARGIN IN TENSION TIE AREA AT BS 840. REPAIRED PER EA 67-209728.SDR SWAA073599Frame · crackedDURING SCHEDULED RON, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073598Frame · crackedDURING SCHEDULED RON, FOUND FUSELAGE FRAME CRACKED AT BS 706, STR 8R. REPAIRED FRAME PER SWA EA.SDR 07FDEA02549Frame · bentREWORK: BUCKLE IN BODY FRAME SHEAR TIE WAS STRAIGHTENED USING SRM 51-40-1 (FUSELAGE SKIN) REMOVED SHEAR TIE, FAB NEW SHEAR TIE AND 2 FILLERS, AND INSTALLED AT STA 720B, STRINGER 28 TO STRINGER 28 WL 148 IAW BOEING 727 SRM 53-10-4, PGS 46, 47, 48, 49.SDR 07FDEA02543Frame · corrodedFWD LWR. CARGO PIT BILGE, FRAME HAS CORROSION ON FWD SIDE ON SKIN ATTACH FLANGE AND UP VERTICAL SIDE 2", STA 720E BETWEEN STR 27R AND 28R. REMOVED DAMAGED SECTION BS 720E BETWEEN STR 27R - 28R. FABRICATED REPAIR PART, SHEAR TIE PER SRM 53-10-4 PG 43-45.SDR K11A2008121172005Frame · dentedFRAME DENTED ON TOP SIDE.SDR K11A2008121172004Frame · dentedFRAME DENTED ON TOP SIDE.SDR K11A2008121072003Frame · dentedFRAME DENTED ON UPPER SURFACE IN 2 AREAS.SDR NWAA072679925Frame · crackedDURING "H" CHECK, FOUND CRACKS IN APU FORWARD FRAME AT BS 1004 BETWEEN L28L-L29L AND L28R-L29R. REPAIRED PER EA 99-210163.SDR NWAA072606729Frame · crackedDURING "L" CHECK, FOUND CRACKS IN FRAME AT TENSION TIE AREA AND LT AFT AND LT FORWARD CHANNEL AT BS 800. REPAIRED PER EA 67-209731.SDR NWAA072586729Frame · crackedDURING "L CHECK FOUND FRAME DOUBLER FASTENER HOLE WITH PLUG INSTALLED AND FRAME WEB WITH FASTENER HOLE CRACKED AT BS 940. REPAIRED PER EA 67-209730.SDR NWAA072626729Frame · crackedDURING "L" CHECK, FOUND CRACK IN FRAME AND FORWARD CHANNEL FASTENER HOLE IN TENSION TIE AREA AT BS 900 LT. REPAIRED PER EA 67-209733.SDR TRAX200701028Frame · corrodedCORROSION DAMAGE FS 310.00 FRAME BETWEEN STR 27 AND 26 RT IN MAIN AVIONICS BAY (MARKED). FOUND BLENDED AREA WITHIN LIMITS IAW CRJ 700 SRM 53-21-00 ONLY .002 MATERIAL REMOVED ALLOWED UP TO .005. ALODINES PRIMED AND PAINTED BLENDED AREA. INSTALLED FOUR REMOVESDR SWAA073574Frame · crackedDURING SCHEDULED SPV CHECK, FOUND STUB FRAME CRACKED AT BS 296, STR 16R. REPAIRED FRAME PER SRM.SDR SWAA073576Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 303, STR 16L. REPAIRED FRAME PER SRM.SDR KCSA071242Frame · crackedR3 DOOR CUT CRACKED IN UPPER AFT CORNER STA 1315 WL 275, 2 INCHES.SDR USAA070561Frame · crackedSTA 727D, RBL 2 AND LBL 2 HAS CRACK. INSTALLED REPAIR DOUBLER PER SRM 51-70-11, DEFECT SIZE: .25 INCH CRACK.SDR USAA070560Frame · crackedNR 4, 5, 6 & 7 STOP IN ACCESS HOLES AT EDGE OF INTERIOR SKIN 0.5 INCH, AFT FRAME HAS CRACK. FAB'D DOUBLERS & INSTALLED; INNER SKIN DOUBLER, DOOR STOP DOUBLER (4 EA) ON AFT FRAME PER EA 98739, DEFECT SIZE: 0.5 INCH.SDR USAA070559Frame · crackedRIGHT STA 1138 AT RIGHT STAB HINGE FUSELAGE LOWER CUTOUT HAS CRACK. STOP DRILLED CRACKS & INSTALLED DOUBLER REPAIR PER SRM 53-00-01 FIG 201, SRM 51-10-02, DEFECT SIZE: 1.8 INCH.SDR USAA070558Frame · crackedIN FRAME STRAP, LEFT STA 1138 LT STAB HINGE FUSELAGE LOWER CUTOUT CRACKED. STOP DRILLED CRACK & INSTALLED DOUBLER PER SRM 53-00-01 FIG 201, DEFECT SIZE: 2.25 INCH.SDR 07FDEA02525Frame · corrodedCLG WHEEL WELL CAVITY CORROSION ON CIRCUMFERENTIAL ANGLE AT FWD OF STA 15121, BETWEEN LONGERON 51L AND 52. REMOVED, REPLACED AND INSTALLED 2 EACH ANGLES AT 51L TO 52 AT FS 1521 IAW MD/DC10 SRM 51-33-01 VOL II PAGE 1.SDR 07FDEA02524Frame · corrodedCLG WHEEL WELL CAVITY, CORROSION ON BULKHEAD LOWER CIRCUMFERENTIAL ANGLE AT STA 152 LONGERON 50R TO 49R. REMOVED, FABRICATED AND INSTALLED 4 EACH ANGLES 49R TO 50R IAW MD/DC10 SRM 51-33-01 VOLII AND 51-35-01 VOLII PAGE 1.SDR HAEA200700201Frame · corrodedDURING MCI INSPECTION FRAME 7 ON THE LT SIDE, DIRECTLY BEHIND AFT EDGE OF PILOTS SIDE WINDOW WAS FOUND TO BE CORRODED IN THE UPPER TUB. ENGINEERING EVALUATED THE CORROSION AND DETERMINED THAT REPAIR WAS NEEDED AND ISSUED AN ENGINEERING INSTRUCTION FOR THE REPASDR K11A2008121072004Frame · corrodedFORWARD BILGE FUSELAGE FRAME HAS CORROSION.SDR 2007FA0000695Spar · damagedWHILE INVESTIGATING A NOISE IN THE LANDING GEAR ACTUATOR GEARBOX, IT WAS DISCOVERED THA THE AN3-6A BOLTS ATTACHING THE ACTUATOR MOUNTING BRACKET, PN 50110133, TO THE FRONT CENTER SPAR WERE LOOSE. AN ATTEMPT TO TIGHTEN THE BOLTS REVEALED THAT THE NUTPLATES INSSDR NWAA072576729Frame · crackedDURING "L" CHECK, FOUND CRACKS IN FRAME WEB AND TENSION TIE FORWARD CHANNEL FASTENER HOLES AT BS 820. REPAIRED PER EA 67-209727.SDR SWAA073551Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 986, STR 20R. REPAIRED FRAME PER SRM.SDR SWAA073545Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA073546Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 597, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073553Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073535Frame · crackedDURING SCHEDULED A1 CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 15R. REPAIRED FRAME PER SWA EA.SDR SWAA073552Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8R. REPAIRED FRAME PER SWA EA.SDR 07FDEA02511Frame · crackedGALLEY DOOR (R-1) CUTOUT UPPER FWD SIDE STATION 380 FRAME CRACKED ON FORWARD SIDE BETWEEN STR 7R AND 8R. REMOVED FASTENERS IN DAMAGED AREA, CUTOUT DAMAGE, NDT VERIFIED NO DEFECTS. FABRICATED STRAP AND FILLER, TREATED, PRIMED REPAIR PARTS. INSTALLED REPAIR PSDR UPS07550453Frame · dentedINSPECTION TYPE:C DENT IN AFT FUSELAGE FRAME STA 1220 APPROX S26R. REPAIR ACCOMPLISHED PER FINAL EA 757-5362-A1712 AND UPS EO B757- 7-5310-27419-A.SDR UPS07550452Frame · dentedINSPECTION TYPE:C DENT IN AFT CARGO FUSELAGE FRAME STA 1580, APPROX. S26L. ACCOMPLISHED REPAIR PER FINAL EA 757-5362-A1711 AND OPS EO B757- 5310-27394-A.SDR UPS07550433Frame · dentedINSPECTION TYPE:C DENT IN AFT CARGO FUSELAGE FRAME STA 1460, APPROX S25L. ACCOMPLISHED REPAIR PER EA 757-5362-27-A1710 AND UPS EO B757-5310-27393-A.SDR 2007UALA02707Frame · dentedDENTED FRAME STA 1500, STR 25L IN AFT PIT. [08-17-07] MAJOR REPAIR ACCOMPLISHED. REPAIRED PER UA ENGINEERING SPECIFICATIONS.SDR 2007UALA02706Frame · dentedDENTED FRAME STA 1580 BETWEEN STR 25-26L IN AFT PIT. [08-17-07] MAJOR REPAIR ACCOMPLISHED. REPAIRED PER UA ENGINEERING SPECIFICATIONS.SDR USAA070541Frame · crackedBS 440 S-9R, ATTACH BRACKET FRAME HAS CRACK. INSTALLED DOUBLER PER TR 53-10-20E, DEFECT SIZE: .5 INCH.SDR CALA0700363Frame · crackedINSPECTION FOUND A .25 INCH CRACK IN MAIN FRAME AT STA 616, LBL 55. A REPAIR WAS INSTALLED IAW ECRA 5311-01158.SDR SWAA073511Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073512Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500D, STR 14R. REPAIRED FRAME PER SWA EA.SDR SWAA073514Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 706, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA073513Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8L. REPAIRED FRAME PER SWA EA.SDR DL76S070925Frame · crackedDURING HMV3, THE LT BS 903.5 INBOARD CHORD WAS FOUND CRACKED AT WL 190.SDR 07FDEA02485Frame · corrodedAFT PIT STA 970 SHEAR TIE CORRODED BETWEEN STRINGER 25R-26R RBL 17-22 REMOVED CORRRODED SHEAR TIE. FAB`D REPAIR SHEAR TIE AND INSTALLED PER SRM 53-10- 4 FIG 11 PAGE 43 THR 45.
Back to JASC 5311