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 07FDEA00985Frame · dentedMAIN DECK CARGO, FRAME FOUND DENT AT STA 1721 L12 LT. REPAIR CARRIED OUT AT MAIN DECK CARGO FRAME AT STA 1721 L12 LT AS PER SRM 53-30-00 FIGURE 1 VOLUME I. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100.SDR DU4R2007074Frame · corrodedFOUND CORROSION IN AFT PIT MAIN FRAME UPPER CAP AT BS 1300 S-26 27R. REPAIRED BY FABRICATING AND INSTALLING REPAIR 12 BY 2 FROM 7075-T6 .071 IAW B757 SRM 53-00-07 FIG 201.SDR ABXA070103Frame · crackedAFT RIGHT MAIN FRAME HAD CRACK AT FORWARD AND AFT FLANGES, MUST BE REPLACED PER NEA 53400102-002-30. REMOVED AND REPLACED RIGHT MAIN FRAME IAW DC9 EA 53400326-001-2. CRACK LENGTHS WERE 1" AND 1 1/4".SDR 2007UALA00800Frame · crackedAFT BULK CARGO COMPT 2ND FRAME FWD OF AFT PRESSURE BULKHEAD [F68] APPROX 12 INCHES INBOARD LEFT FUSE FLOORBEAM ATTACH CRACKED. [SUP 06-14-07] MAJOR REPAIR ACCOMPLISHED. CUTOUT DAMAGED FLANGE. HFEC TRIMMED SURFACE. FABRICATED AND HEAT TREATED REPAIR ANGLESSDR TRAX200700371Frame · crackedLEFT SIDE 640 FRAME CRACKED FWD SIDE BETWEEN STR 9 AND ENGINE SUPPORT BEAM WEB AFT OF ENGINE SUPPORT BEAM UPPER OUTBOARD ATTACH ANGLE.SDR SWAA071416Frame · corrodedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 847, STR 25L. REPAIRED FRAME PER SRM.SDR SWAA071415Frame · corrodedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 827, STR 25L. REPAIRED FRAME PER SRM.SDR SWAA071417Frame · corrodedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 807, STR 25L. REPAIRED FRAME PER SRM.SDR SWAA071414Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 26R. REPAIRED FRAME PER SRM.SDR SWAA071404Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 16R. REPAIRED FRAME PER SRM.SDR SWAA071401Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 13R. REPAIRED FRAME PER SWA EA.SDR 07FDEA00969Frame · corrodedCORROSION IN THE AIR CONDITIONING COMP, C43-44, P47 RT. REPAIR WAS PERFORMED BY REWORK OF CORRODED AREA IAW EA 6-5315-103434 AND RAS/048419/005/2006 ISSUE "A".SDR 07FDEA00968Frame · corrodedCORROSION IN THE AIR CONDITIONING COMPARTMENT AT C42, P50-51 LT. REPAIR WAS PERFORMED BY CUT OUT AND INSTALLING A REPAIR ANGLE AND A NEW PICK UP ANGLE IAW EA 6-5315-103434 AND RAS/048419/005/2006 ISSUE "A".SDR 07FDEA00966Frame · corrodedFUSELAGE TAIL SECTION, CORROSION AT C102, BETWEEN P13 LT AND P13 RT. REPAIR WAS PERFORMED BY TRIM THE FRAME OUTER FLANGE TO ALLOW FASTENER INSTALLATION.SDR 07FDEA00963Frame · corrodedFOUND CORROSION IN THE AIR CONDITIONING COMP, C42, P50-51 RT. REPAIR WAS PERFORMED BY CUT OUT AND INTALLING A REPAIR ANGLE AND A NEW PICK UP ANGLE IAW EA 6-5315-103434 AND RAS/048419/005/2006 ISSUE "A".SDR AWXA200700461Frame · crackedMCN - CRACKED FRAME, BS 380, S27L. REPAIRED FRAME, BS 380, S27L IAW B737-300 SRM 53-00-07-2R4, FIGURE 201.SDR ABXA070078Frame · crackedFS 1209 CANTED FRAME CRACKED BETWEEN LONGERON 14 AND 15 LEFT SIDE. REPAIRED IAW DC9 SRM 53-01.SDR TRAX200700361Frame · corrodedFRAME CORRODED AT FS 349 STRINGER 27.SDR TRAX200700360Frame · corrodedFRAME CORRODED AT FS 333 STRINGER 27. REMOVED FASTNERS AND BLENDED CORRISION IAW CRJ 700 SRM 51-42-06. PERFORMED THICKNESS MEASUREMENT OF BLEND AREA AT FS 333, STR 27 IAW CRJ 700 NDTM 51-20-004. MINIMUM THICKNESS IS .047". SUBMITTED AND RECIEVED REO 670-53SDR TRAX200700359Frame · corrodedFRAME CORRODED AT FS 319 STRINGER 27.SDR TRAX200700358Frame · corrodedFRAME CORRODED AT FS 295 STRINGER 27.SDR 07FDEA00907Crossbeam · corrodedFOUND CORROSION AT CROSSBEAM C67 RT. PART REPLACED IAW SRM 51-72-10.SDR 07FDEA00903Frame · corrodedFOUND CORROSION AT FRAME SECTION C102. PART REPLACED IAW SRM 51-72-10.SDR 07FDEA00881Frame · corrodedFOUND CORROSION EXIST AT AVIONIC COMPARTMENT AT STA 1315/ FRAME 16 AND 17 BETWEEN S47 AND 48 BELOW ACCESS PNL 121 PF ZONE 120 COMPLIED WITH EA 6- 5330-107691.SDR USAA070218Frame · crackedBS 727B BETWEEN STRINGERS 8R & 9R AT RAIL ATTACH POINT CRACKED. REMOVED DAMAGE & INSTALLED FAB'D REPAIR PARTS PER T/R 53-10-20E, DEFECT SIZE: .250 INCH.SDR USAA070198Frame · crackedBS 520 S-9R, FRAME CRACKED. REPAIRED PER TYPICAL REPAIR 53-10-20D, DEFECT SIZE: .250 INCH.SDR ABXA070096Frame · corrodedLOWER POCKETS IN MAIN FRAME IN LEFT WHEEL WELL HAD CORROSION AROUND LOWER VERTICAL ATTACH BOLTS. CLEANED, TREATED CORROSION AROUND LOWER VERTICAL ATTACH BOLT ON LEFT MAIN FRAME 718 AIW DC9 SRM.SDR AWXA200700486Frame · crackedMCN - CRACKED FRAME, BS 294.5, S10L - S11L. REPAIRED FRAME, BS 294.5, S10L - S11L IAW AWA ER 03-5312-07093-SS5.SDR SWAA071386Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 369, STR 9L. REPAIRED FRAME PER EA.SDR NWAA071416306Frame · crackedDURING "M" CHECK, FOUND CRACK IN FORWARD FASTENER HOLE AT FRAME TO STRINGER CONNECTION BS 500 S10R. REPAIRED PER EA 63-209223.SDR NWAA071386306Frame · crackedDURING "M" CHECK, FOUND CRACK IN FRAME FASTENER HOLE AT BS 500 S10L. REPAIRED PER EA 63-209228.SDR NWAA071376306Frame · crackedDURING "M" CHECK, FOUND CRACK IN FRAME TO STRINGER CONNECTION FASTENER HOLE AT BS 480 S10L. REPAIRED PER EA 63-209229.SDR NWAA071476306Frame · crackedDURING "M" CHECK, FOUND CRACK ON FRAME WEB AND FRAME DOUBLER TENSION TIE AT BS 1140 RBL 70. REPAIRED PER EA 63-209214.SDR TRAX200700369Frame · crackedSUSPECT CRACK ON LEFT DOUBLER AT FRAME 640. PERFORMED EDDY CURRENT INSPECTION OF SUSPECT AREA PER MTC REQUEST IAW CRJ 200 NDTM PART 1, 51-20-06. LEFT FS 640 IS CRACKED. REMOVED DAMAGE ON LT DOUBLER FRAME 640. AND PERFORMED EO 600-53-059 PART B ESB MOD. ALLSDR SWAA071361Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA071359Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, BETWEEN STR 13R & STR 14R. REPAIRED FRAME PER SRM.SDR SWAA071369Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND STR FUSELAGE FRAME CRACKED AT BS 380, STR 15R. REPAIRED FRAME PER SWA EA.SDR SWAA071350Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA071353Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907 STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA071351Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787 STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA071354Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747 STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA071352Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 706 STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA071349Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440 STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA071348Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER SWA EA.SDR USAA070178Frame · crackedBS 492 S-24R CRACKED. FAB'D & INSTALLED REPAIR ANGLES PER EA 98533, DEFECT SIZE: .5 INCH CRACK.SDR USAA070191Frame · crackedSTA 500A, S9L CRACKED. FAB'D & INSTALLED DOUBLER REPAIR PARTS PER TR 53-10-20D, DEFECT SIZE: .50 INCH.SDR TRAX200700342Frame · crackedSUSPECT CRACK ON LEFT DOUBLER AT FRAME 640. PERFORMED EDDY CURRENT INSPECTION OF SUSPECT AREA PER MTC REQUEST. LEFT FS 640 DOUBLER IS CRACKED.SDR ASAA0771525Frame · maint errorAFT CARGO PIT FRAME AT BS 787 DOUBLE DRILLED. REPAIRED IAW SRM 51-70-11.SDR SWAA071325Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA071333Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8L. REPAIRED FRAME PER SWA EA.
Back to JASC 5311