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 ASAA0640065Frame · crackedPAE: FRAME CRACKED AT BIN RAIL. REPAIRED FRAME AT BSTA 907 RT BIN RAIL ATTACH POINT IAW SRM. (K)SDR ASAA0640064Frame · crackedPAE: FRAME CRACKED AT BIN RAIL ATTACH POINT. REPAIRED FRAME AT BSTA 500A LT BIN RAIL ATTACH POINT SRM. FABRICATED REPAIR PARTS. (K)SDR SWAA060322Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 847, STR 9R. REPAIRED FRAME PER SRM.SDR SWAA060321Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 9R. REPAIRED FRAME PER SRM.SDR SWAA060320Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 887, STR 9L. REPAIRED FRAME PER SRM.SDR ASAA0640063Frame · corrodedPAE: CORROSION ON BSTA 794, FRAME BETWEEN STR 23R-26R. REMOVED AND REPLACED FRAME AT BSTA 794 BETWEEN STRINGERS 16 RT TO 26 RT IAW SRM. (K)SDR DHL2006763503Cap · corrodedS/O 284007 N/R 031817 - FWD CARGO AFT DOOR OPENING FRAME CAP BS 620 S-26R HAS EXFOLIATION CORROSION. CUT OUT CORRODED SECTION OF FRAME CAP. FABRICATED AND INSTLLED FRAME CAP REPAIRS 14" X 1" AND 22" X 1" FROM 60-9101 7075-T6 IAW B727 SRM 51-40-4 FIG. 1 AND 5SDR USAA060145Frame · dentedSTA 1466 STR 26L, ACTION: TRIM OUT DAMAGE AND INSTALLED REPAIR PARTS IAW EA 95421A DEFECT SIZE: 2 INCH.SDR 06FDEA0373Frame · dentedFRAME DENTED B/S 660 STR 23-25 RT. REPAIRED FRAME BS 660 STR 23-25 RT IAW SRM 51-40-3.SDR SIMA200603703Frame · dentedTHE CARGO FRAME AT FS 677 WAS FOUND DENTED. PERFORMED 2 CUT OUTS ON FRAME, REMOVED THE DAMAGE. PREPARED A REPAIR DOUBLER FOR NEW FRAME. REPAIR DONE IAW REPAIR STATEMENT. (K)SDR SIMA200603702Frame · dentedTHE CARGO FRAME AT FS 640 WAS FOUND DENTED. PERFORMED A CUT OUT OF FRAME 640 TO REMOVE THE DAMAGE. PREPARED REPAIR DOUBLER FOR REPAIR. REPAIR DONE IAW REPAIR STATEMENT. (K)SDR UPS06846159Frame · corrodedINSPECTION TYPE:C1 EXFOLIATION CORROSION UNDER FRAME 1000 ABOVE L36 AT SITE OF REMOVED NUTPLATE. REPAIRED FRAME AT STA 1000 L36 IAW EO DC-8 5310-11728-B.SDR 06FDEA0347Frame · dentedSNRM N00737: CABIN COMPARTMENT LEFT HAND FRAME AT STATION 1681 FOUND WITH DENT BETWEEN STRINGER 10-11. CORRECTIVE ACTION: SNRM N00737: CABIN COMP'T LH FRAME STA 1661 STR 10-11 CARRIED OUT REPAIR AS PER SRM 53-30 -00 FIG. 1 VOL. I. REPAIR CLASSIFIED ASSDR UPS06M46093Frame · corrodedINSPECTION TYPE:C2 BILGE STA 1801, LONGERON 52 (BL 0), UPPER CHORD OF FRAME HAS CORROSION AROUND FASTENER. REMOVED CORROSION IAW MD-11 SRM 51-21-01. NDT VERIFIED MATERIAL AFTER CORROSION WAS REMOVED TO BE .070" TO .066" PER NDT SPM 04-00-06. MATERIAL IS WITHISDR 2006UALA00127Frame · puncturedFWD CARGO PIT STA 700 LBL 40 LOWER LOBE FRAME WEB PUNCTURED. WEB PERMANENTLY REPAIRED PER FAA 8100-9 WEB REPAIR INSTRUCTIONS.SDR 06FDEA0363Frame · dentedAFT CARGO FRAME DENTED AT BS 950B BETWEEN STR 25 & 26 L. REPAIRED AFT CARGO BAY FRAME AT BS 950B BETWEEN STR 25L - 26L PER SRM 51-40-3.SDR SWAA060295Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME PER SRM.SDR SWAA060294Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, BETWEEN STR 8L TO STR 9L & STR 8R TO STR 9R. REPAIRED FRAME PER SRM.SDR SWAA060292Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME PER SRM.SDR SWAA060291Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, BETWEEN STR 8R TO STR 9R & STR 8L TO STR 9L. REPAIRED FRAME PER SRM.SDR SWAA060290Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME PER SRM.SDR SWAA060289Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME PER SRM.SDR SWAA060281Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE STUB FRAME CRACKED AT BS 188, RT SIDE, WL 207. REMOVED AND REPLACED STUB FRAME PER SRM.SDR 06FDEA0368Frame · dentedFRAME DENTED TWO PLACES STA 540 STR 23 AND 24 LT. FOUND DENTED FRAME TO BE OUT OF LIMITS REMOVED DAMAGED AREA FABRICATED REPAIR PARTS ALODINED & PRIMED & INSTALLED ALL WORK DONE IAW SRM 51-40-03, 51-30-2, M/M 51- 20-021-7, 51-20-151-7.SDR 06FDEA0367Frame · dentedFRAME DENTED THREE PLACES STA 600 STR 24 LT. REMOVED DAMAGE ON FRAME BS 600 STR 24L AND REPAIRED IAW SRM 51-40-03 AND SRM 51- 30-02.SDR 06FDEA0366Frame · dentedFRAME DENTED THREE PLACES STA 560 STR 23-24 LT. REMOVED DAMAGE ON FRAME STA 560 STR 23L TO 24L AND REPAIRED IAW SRM 51-40-3 AND SRM 51-30-02SDR 06FDEA0364Frame · dentedAFT CARGO FRAME DENTED AT BS 950C BETWEEN STR 25 AND 26L. REPAIRED PER SRM 53-10-1, 53-10-2, 51-40-3.SDR 06FDEA0346Frame · dentedFRAME DENTED AT BS 680 BELOW STR 23R IN THE FORWARD CARGO COMPARTMENT. REPAIRED FRAME AT BS 680 BELOW STR 23R IAW SRM 51-40-3.SDR USAA060127Frame · crackedSTATION 480 FRAME WEB LEFT SIDE IS CRACKED AT THE INBOARD RIVET FOR PSU. INSTALLED DOUBLER IAW TR 53-10-20C, DEFECT SIZE: .375.SDR 2006UALA00100Frame · crackedTHE FOLLOWING CABIN FRAMES ARE CRACKED BETWEEN STR 8L AND 9L, STA 400, STA 440, STA 482, STA 747, STA 787, STA 827 STA 867 AND STA 907. *S/D* REMOVED CRACKS, AND ACCOMPLISHED ANGLE AND FILLER REPAIR PER MM 53-10-84.SDR 2006UALA00099Frame · damagedCABIN STA 360 AT STR 8R IS CRACKED AT FASTENER HOLE UNDER STR CLIP. REMOVED STRINGER CLIP, CUT OUT DAMAGE ON FRAME, INSTALLED REPAIR. REF MM 53-10-84-801.SDR SWAA060269Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 300, STR 10L. REPAIRED FRAME PER SRM.SDR 2006UALA00111Frame · corrodedCORROSION DAMAGE WAS FOUND IN THE BS 847 FRAME ON THE AFT SIDE OF LOWER CARGO NEAR STRINGER 25. ACCOMPLISHED ANGLE DOUBLER REPAIR PER SB 737-53A1228.SDR 2006UALA00098Frame · crackedFWD CABIN STA 440 FRAME IS CRACKED BETWEEN STR 8R AND 9R. REPAIRED FRAME AT STA 440 BETWEEN STR 8R AND 9R PER AMM 53-10-84-601.SDR USAA060121Frame · crackedSTA 400 BETWEEN S-8R AND S-9R CRACKED. INSTALLED DOUBLERS IAW TR 53-10-20C, DEFECT SIZE: .437 INCH.SDR USAA060119Frame · crackedBS 400 AT PSU RAIL BETWEEN STRINGER 8 AND 9 RT. CUT OUT DAMAGED AREA. INSTALLED REPAIR DOUBLERS IAW TR 53-10-20C AND EA 97304, DEFECT SIZE: .250 INCH.SDR DU4R2006256Frame · puncturedCIRCUMFERENTIAL FRAME AT BS 1460 JUST ABOVE STRINGER 26L HAS A PUNCTURE. FABRICATED AND INSTALLED REPAIR ANGLE IAW B757 SRM 53-00-07 FIG 201.SDR ASAA0640051Frame · corrodedPAE - FOUND CORROSION ON FRAME AT BS 270, WL 208, RBL 8. REMOVED AND FABRICATED NEW FRAME IAW B737-400 SRM 51-40-05 AND 51-40-02. (M)SDR DHL2006763518Frame · crackedS/O 284007 N/R 032154 - CRACK ABOUT 10 INCHES LONG ON FRAME WEB AT BS 1352 RT LOWER SIDE FROM 4 O'CLOCK POSITION TO 5 O'CLOCK AFT SIDE OF WEB. CUT OUT CRACKED AREA OF FRAME. FABRICATED AND INSTALLED REPAIR DOUBLER 27-7/8" X 3-3/8" AND FILLER FROM 7075-T6 .071SDR 06FDEA0285Frame · dentedFRAME DENTED BS 680 STR 25 RIGHT. REPAIRED FRAME AT BS 680 STR 25RT IAW SRM 51-40-3.SDR ASAA0640042Frame · corrodedPAE - FOUND CORROSION ON BS 847 FRAME. REMOVED AND REPLACED FRAME IAW B737-400 SRM 51-40-05, 51-40-02, AND DWG 65-47960. (M)SDR SWAA060213Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482, STR 20L. REPAIRED FRAME PER SWA EA.SDR SWAA060212Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482B, STR 20R. REPAIRED FRAME PER SWA EA.SDR 06FDEA0254Frame · corrodedCORROSION AT STA BS 1997 FRAME, FORWARD SIDE/LOWER LEG/BOTTOM SIDE AT LONGERON L43-R AND EXTENDING 2 FASTENERS EITHER SIDE OF LONGERON. REMOVED FRAME AND SPLICES IAW DC 10 SRM 51-35-01 VOL II. REMOVED CORROSION IAW DC10 SRM 51-21-01 VOL II. FOUND OUT OF LIMSDR USAA060098Frame · crackedFOUND CRACK AFT CARGO STA 1380 BETWEEN STR 26L AND 27L. CUT OUT DAMAGED AREA, REPAIRED PER EA 97224, DEFECT SIZE: 1.60.SDR USAA060081Frame · damagedFRAME RIVETS MISSING, BS 480 2" ABOVE FLOOR LEVEL. INSTALLED TWO FASTENERS IAW SRM 51-10-02, DEFECT SIZE: 2".SDR SWIA200616518Frame · crackedAFT EQUIP BAY FS 654.5 BETWEEN STR 13R-14R, FRAME WORN ON AFT I/B EDGE FROM APU EXHAUST DUCT. ITEM FOUND AT C-CHECK INSPECTION. REPAIRED AS PER REO 610R-53-61-1731 REV NC.SDR AWXA200600260Frame · crackedMCN - DURING C19 CHECK DISCOVERED 188 FRAME CRACKED, 2.1 INCHES, IN RADIUS AT WL 208 AND BL 31L. MAINTENANCE CUT OUT AND REMOVED DAMAGED PORTION OF CHORD WEB AT BS 188 FRAME IAW BOEING 737-300 SRM 53-00-07-2R11. PERFORMED HFEC INSPECTION, NO CRACKS NOTED. FSDR SWAA060219Frame · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE FRAME FAILSAFE CHORD CRACKED AT BS 360, STR 20R. REPAIRED FRAME PER SRM.SDR SWAA060218Frame · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 20R. REMOVED AND REPLACED FRAME SECTION PER SRM.
Back to JASC 5311