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 SWAA112634Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CHORD CRACKED AT BS 616, WL 208. REMOVED AND REPLACED CHORD PER EA.SDR DALA1131401701Frame · crackedM/D STA 903 FRAME BTN STR 20R AND 21R INNER CHORD CRACKED AND REPAIRED AS PER ERA 489733-14AD REV ORIG.SDR IPXA11566229Frame · damagedINSPECTION TYPE:SP, REPLACED UPPER SKIN ON MCD. FOUND DOUBLE HOLE COMMON TO BS 520, FRAME STR 10L. REPAIRED IAW ATS ER NR 11-02359.SDR DALA1125419871Frame · corrodedAFT CARGO STATION 1136 FRAME HAS CORROSION BETWEEN L29L AND L26R. REMOVED CORROSION 1"X 5"AREA X 2 PLACES IAW DC9-50 SRM 51-10-3. OUT OF LIMITS IAW DC9-50 53-01 FIG 1. CUT OUT & REMOVED 39 INCH SECTION OF FRAME, CONFIRMED DAMAGE CONTAINED IN CUT OUT. REPASDR CALA2011041100279Frame · chafedAPU BLEED AIR DUCT RUBBING FRAME STA 1040 (TAIL COMP). REPAIRED FRAME AT STA 1040 PER AVO HOU032311-01 REV A AND ECRA 5311-01523 WEIGHT CHANGE IS LESS THAN FIVE POUNDS.SDR ASAA1149565Frame · corrodedBS 1006 FRAME CORRODED UNDER R2 DOOR MOP SILL. REMOVED DAMAGED SECTION FABRICATED REPAIR PARTS AND INSTALLED IAW B737 400 SRM 53 00 07.SDR IPXA1M66277Frame · corrodedINSPECTION TYPE:4C, MAIN CABIN TRANSVERSE FRAME INTERCOSTAL AND UNDER "U" BLOCK SUPPORT STRUCTURE HAS CORROSION AT STA 1256 BETWEEN L1L AND L1R. REPAIRED CORRODED FRAME REF EO MD11-5310-42469-A AND STA SA EA 011-5310-01-A3048 REV IR AT STA 1256 BETWEEN L1L ANSDR IPXA1566301Frame · damagedINSPECTION TYPE:SP, BS 580 FRAME HAS DOUBLE DRILLED HOLE AT APPROX 2 INCH DOWN FROM TOP OF DOOR. REPAIRED IAW ER 11-02357, DATED 30-APR-2011 AND EO B757-5230-42377-A, DATED 02-MAY-2011.SDR IPXA1566300Frame · damagedINSPECTION TYPE:SP, BS 540 FRAME HAS DOUBLE DRILLED HOLE AT APPROX 2 INCH DOWN FROM TOP OF DOOR. REPAIRED IAW ER 11-02357, DATED 30-APR-2011, AND EO B757-5230-42377-A, DATED 02-MAY-2011.SDR IPXA1566299Frame · damagedINSPECTION TYPE:SP, BS 590 FRAME HAS DOUBLE DRILLED HOLE AT APPROX 2 INCH DOWN FROM TOP OF DOOR. REPAIRED IAW ER 11-02357, DATED 30-APR-2011 AND EO B757-5230-42377-A, DATED 02-MAY-2011.SDR IPXA1566298Frame · damagedINSPECTION TYPE:SP, BS 520 FRAME HAS DOUBLE DRILLED HOLE AT APPROX 2 INCH DOWN FROM TOP OF DOOR. REPAIRED IAW ER 11-02357, DATED 30-APR-2011 AND EO B757-5230-42377-A, DATED 02-MAY-2011.SDR IPXA1566297Frame · damagedINSPECTION TYPE:SP, BS 560 FRAME HAS DOUBLE DRILLED HOLE AT APPROX 2 IN DOWN FROM TOP OF DOOR. REPAIRED IAW ATS ER 11-02357, DATED 30-APR-2011 AND EO B757-5230-42377-A, DATED 02-MAY-2011.SDR SWIA201126092Frame · corrodedFS 319 FRAME CORRODED FROM STRINGER 26L TO 26R. (C-CHECK) REPAIRED PER REO.SDR IPXA11566235Frame · damagedINSPECTION TYPE:SP, MCD, BS 600 OUTER FRAME CHORD 22" DOWN FROM UPPER EDGE OFFSET PILOT HOLES IN 4 EA FASTENERS HOLES MARKED. REPAIR IAW ATS ER 11-02350.SDR ASAA1149602Frame · corrodedFRAME STA 1006 CORRODED UNDER L2 MOP SILL. REMOVED DAMAGED SECTION. FABRICATED HEAT TREATED LOCATED TREATED PRIMED TOPCOATED AND INSTALLED FRAME REPAIR IAW B737 400 SRM 53 00 07 FIG 201.SDR SIMA201110105Frame · corrodedDURING MAINTENANCE BASE VISIT FOUND BOTH HALVES OF FRAME 280 CORRODED. THE AIRCRAFT WAS REMOVED FROM SERVICE. REPAIRED IAW EO-CR-53MR-219. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR ASOA201100716Frame · corrodedFRAME AT FS 295 CORRODED ON AFT SIDE ON VERTICAL. REMOVED CORROSION IAW SRM 51-42-06-001-001-A01.SDR ASOA201100715Frame · corrodedFRAME AT FS 333.00 AT STR 26RT IS CORRODED. REPAIRED IAW SRM 51-42-06-011-011-A01.SDR ASOA201100714Frame · corrodedFRAME AT 333 BETWEEN STRINGERS 27 AND 26L CORRODED ON BOTH SIDES, VERTICAL LEG AND ON HORIZONTAL LEG. REPAIRED IAW SRM 51-42-06-001-001-A01.SDR SWAA112599Angle · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME ANGLE CORRODED AT BS 328, STR 20L. REMOVED AND REPLACED ANGLE PER SRM AND BAC DWG.SDR SWAA112583Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 616, WL 208. REPAIRED FRAME PER EA.SDR CALA2011040700270Frame · crackedSUPPORT TASK - FUSELAGE FRAME WEB HAS A 1 IN CRACK AT STR 16L STA 303.9. REPAIRED CRACKED FRAME REF EA 5310-04659 REV A OP 2.SDR SWAA2013022213000Frame · crackedCRACK INDICATION FOUND ON THE FRAME STUB BEAM LOCATED AT BS 616 BETWEEN S-17R AND S-18R. PERFORMED REPAIR ON THE STUB BEAM IAW EA 1-353-15638 AND EO AEM-HC53-714/11 R0.SDR K11A2011052672401Frame · corrodedFRAME CORROSION, 3 INCHES AT STA 620 RBL 24.SDR DALA1125559856Frame · crackedAFT ACCESSORY COMPARMENT, L4L, CANTED FRAME CRACKED BS 1245. R & R CANTED FRAME 1245 PN 09-5300-3-0606IAW SRM 51-30-5 & 51-30-2. REQUIRED INSP COMPLETED.SDR CALA2011040700269Frame · crackedFRAME CRACKED AT STA 1120 LEFT SIDE OF FUSELAGE BETWEEN S8LT AND S9LT IN CABIN. TREATED, PRIMED AND INSTALLED FABRICATED FRAME REPAIR DOUBLERS. ND COLD WORKED HOLES AT END OF REPAIR DOUBLERS AND INSTALLED FASTENERS, SEALED EDGES AT STA 1120, LEFT SIDE OF FUSSDR FDEA201104061366Frame · gougedFRAME AT BS 1140, S2L, IS GOUGED. REMOVED DAMAGED SECTION OF FRAME IAW SRM 51-40-02. LOCATED, TRIMMED AND DRILLED FRAME AND SPLICES SRM 53-00-07, P.201/202, FIG 201. TREATED AND PRIMED FRAME AND SPLICES IAW SRM 51-20-01. INSTALLED FRAME REPLACEMENT AND 4 ESDR CALA2011040600268Frame · crackedFRAME CRACKED AT STA 1120 RIGHT SIDE OF FUSELAGE BETWEEN S8RT AND S9RT IN CABIN. REPAIRED CRACKED FRAME AT STA 1120 RIGHT SIDE OF FUSELAGE BETWEEN S8RT AND S9RT IN CABIN REF SRM 53-00-07 ISSUED DIP FOR REP DVI INSP ZONE 1 REF SRM 53-00-07 REPAIR 1 PAGE 207. SDR FOTR21053Frame · buckledFRAME AT BS 970 IN AFT PIT IS BUCKLED BETWEEN STRR AND STR28R. REMOVED DAMAGED FRAME SECTION FROM BS 970 BETWEEN STR 25L TO 27R. FABRICATED NEW FRAME SECTION FROM 7075-0 .063" PO 2105316 DIM 71" X 11". HEAT TREATED PART FROM 7075-0 TO 7075T6 IAW FASI ENG RESDR ASAA1149517Frame · crackedPASSENGER CABIN FRAME CRACKED AT BS 747 BETWEEN STR 8R AND 9R. CUT OUT DAMAGED AREA AND INSTALLED REPAIR PARTS IAW ASA EA AD20062609 400 53 118 REV NEW DATED 12 APR 2011.SDR ASAA1149516Frame · crackedPASSENGER CABIN FRAME CRACKED AT BS 867 BETWEEN STR 8R AND 9R. CUT OUT DAMAGED AREA AND INSTALLED REPAIR PARTS IAW ASA EA AD20062609 400 53 118 REV NEW DATED 12 APR 2011.SDR ASAA1149515Frame · crackedPASSENGER CABIN FRAME AT BS 727F CRACKED BETWEEN STR 8R AND 9R. CUT OUT DAMAGED AREA AND INSTALLED REPAIR PARTS IAW ASA EA AD20062609 400 53 118 REV NEW DATED 12 APR 2011.SDR GLBA20110405GFrame · crackedMAJOR REPAIR - DURING A SCHEDULED ROUNTINE INSPECTION MAINTENANCE FOUND THE CARGO DOOR FWD FUSELAGE FRAME AT F.S. 456 CRACKED AT THE GAS STRUT MOUNT UPPER IB NUTPLATE AREA, 1" IN LENGTH. MAINTENANCE REPAIRED THE AFFECTED AREA AND PERFORMED ALL REQUIRED RII INSSDR C2XA11TY041Frame · crackedRT FRAME 10 IS CRACKED AT DV WINDOW. REMOVED AND REPLACED FRAME 10 IAW EMB 145 SRM 51-40-02.SDR SWAA112496Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 727B, BETWEEN STR 14L TO STR 15L. REPAIRED FRAME PER SRM.SDR SWAA112494Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FORWARD CARGO COMPARTMENT FRAME CRACKED AT BS 520, BETWEEN STR 21L TO STR 22L. REPAIRED FRAME PER SRM.SDR SWAA112480Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FWD CARGO COMPARTMENT FRAME CRACKED AT BS 500D, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM AND EA.SDR SWAA112479Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FWD CARGO COMPARTMENT FRAME CRACKED AT BS 500C, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR CALA2011040500263Frame · crackedCABIN INTERIOR LEFT FRAME CRACKED STA 760 AT PSU RAIL ATTACH POINT (MARKED). INSTALLED REPAIR DOUBLER AT STA 760 LT FRAME PER SRM 53-00-07, INSTALLED REPAIR DOUBLER AT STA 760 FRAME AT PSU RAIL ATTACH REPAIR 1. POINT BETWEEN STR 8L & 9L PER SRM 53-00-07 REPAISDR ASAA1149634Stiffener · corrodedBS 767 FRAME STIFFENER CORRODED FROM STR 26R TO 27R. REPLACED FRAME STIFFENER IAW B737 400 SRM 51 40 02 AND 53 00 01.SDR ASAA1149595Frame · dentedAFT PIT LT FRAME STA 767 DENTED ON UPPER SURFACE ABOVE STR 25L. CUT OUT DAMAGED AREA FORMED HEAT TREATED LOCATED TREATED PRIMED TOPCOATED AND INSTALLED FRAME REPAIR IAW ASA EA 400 53EA 05363.SDR ASAA1149591Frame · corrodedSTA 947 FRAME IS CORRODED BETWEEN STR 25L & 26L. REMOVED DAMAGED AREA, FABBED REPAIR PARTS AND INSTALLED IAW ASA EA 400 53EA 05359.SDR ASAA1149586Frame · corrodedPASSENGER CABIN LT FRAME STA 992 CORRODED BETWEEN 16L 17L. REMOVED DAMAGED SECTION. RECEIVED HEAT TREATED LOCATED PRIMED TOPCOATED AND INSTALLED FRAME REPAIR IAW EA 400 53EA 05333.SDR ASAA1149584Frame · dentedFRAME AT STA 727G HAS 2 EA DENTS ON UPPER SURFACE BETWEEN STR 20L & 22L. REMOVED DAMAGED AREAS FABRICATED REPAIR PARTS AND INSTALLED REPAIR IAW ASA EA 400 43EA 05352 AND AAR EA 14369.SDR ASAA1149583Frame · dentedFRAME AT STA 767 HAS A DENT BETWEEN STR 24R & 25R. REMOVED DAMAGED AREA, FABRICATED REPAIR PARTS & INSTALLED REPAIR PARTS IAW ASA EA 400 53EA 05350 & AAR EA 14360.SDR ASAA1149581Frame · dentedFRAME STA 827.0 HAS 2 DENTS UPPER SURFACE BETWEEN STR 24L 25L. CUT OUT DAMAGED SECTION. FABRICATED HEAT TREATED LOCATED TREATED PRIMED TOPCOATED AND INSTALLED FRAME REPAIR IAW EA 400 53EA 05338.SDR GLBA20110404FFrame · crackedMAJOR REPAIR - DURING A SCHEDULED ROUNTINE INSPECTION MAINTENANCE FOUND THE FUSELAGE FRAME AT F.S. 456 AND STRINGER 10R CUTOUT IS CRACKED AT THE IB LWR CORNER OF THE COUTOUT, CRACK IS .5" IN LENGTH. MAINTENANCE REPAIRED THE AFFECTED AREA AND PERFORMED ALL REQUSDR IPXA11566113Frame · dentedINSPECTION TYPE:CK, FWD CARGO COMP STA 800 BETWEEN STR 23 AND 24L FRAME IS DENTED. REMOVED DAMAGE AND REPAIRED IAW SRM 53-00-07-2R5.SDR IPXA11566099Frame · dentedINSPECTION TYPE:C4, FWD CARGO COMPARTMENT STA 780 BETWEEN STR 24R AND 23R FRAME IS DENTED. REMOVED DAMAGE, CUTOUT AREA, HFEC FASTENER HOLES, FABRICATED REP AIR "J" SECTION FROM 7075-0, HEAT TREATED PART TO T6 CONDITION, MADE INSURANCE CUT AT CUT OUT AREA. TRSDR FDEA201104041314Frame · dentedCABIN RIGHT HAND STATION 1701 L-11 FRAME FOUND DENT. CABIN RIGHT HAND STATION 1701 L-11 DENTED FRAME REPAIRED AS PER SRM 53-00-07 FIG 201 REPAIR 2 REVISION 46. REPETITIVE INSPECTION REQUIRED - INITIAL INSPECTION AT 14,500 CYCLES AND REPETITIVE INSPECTION A
Back to JASC 5311