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 DHL2006752504Frame · puncturedFOUND PUNCTURE HOLE ON UPPER SEGMENT OF FRAME AT BS 480 STR 26R (FWD PIT, UNDER FLOOR SUPPORT STAP). REMOVED TRANSMISSION PANEL IN FWD BAG RT FROM 480 TO 560 FOR ACCESS IAW SRM 51-30-2 CUT OUT DAMAGED AREA SIZE 1 INCH X .5 INCH IAW SRM 51-10-1 FABBED ANGLE RSDR SWAA060013Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT FWD CARGO DOOR CUTOUT, AFT FRAME NR 5 STOP FITTING. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA060012Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT AFT CARGO DOOR CUTOUT, FWD FRAME NR 5 STOP FITTING. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA060011Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT FWD CARGO DOOR CUTOUT, FWD FRAME NR 5 STOP FITTING. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR UPS06145999Frame · damagedINSPECTION TYPE:2C MAIN CARGO COMPARTMENT FLOOR FRAME 52 BTWN FLOOR PNL 242EK AND 242ZJ FRAME DAMAGED PN 99589. REMOVED AND REPLACED FRAME IAW SRM 51-40-00.SDR 2006UALA00009Frame · crackedCABIN OVERWING FRAME BS 616L INNER CHORD CRACKED AT LOWER END JUST BELOW CREASE BEAM. REMOVED CRACK ACCOMPLISHED FILLER AND ANGLE REPAIR PER MM 53-11-89.SDR 2006UALA00012Frame · crackedCABIN FRAME CRACKED STA 616 RT IS CRACKED BELOW FLOOR. REMOVED THE CRACK, FABRICATED FILLER ANGLE REPAIR REF MM 53-11-89 AND INSTALLED.SDR 2006UALA00011Frame · crackedCABIN FRAME STA 616 LT SIDE IS CRACKED BELOW FLOOR. REMOVED DAMAGE, FABRICATED FILLER AND ANGLE REF MM 53-11-89 AND INSTALLED.SDR SWAA060021Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT R1 DOOR CUTOUT, FWD FRAME NR 4 STOP FITTING. REPAIRED FRAME PER SRM.SDR SWAA060019Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT R1 DOOR CUTOUT, FWD FRAME NR 3 STOP FITTING. REPAIRED FRAME PER SRM.SDR ASAA0540767Frame · crackedPAE- BSTA 380 FRAME MEMBER CRACKED AT BIN RAIL ATTACH. REPAIRED FLOOR BEAM IAW SRM. (K)SDR ASAA0540768Frame · dentedDENT IN FRAME AT BS 727F BETWEEN STR 22R-24R. REPAIRED FRAME IAW SRM 51-70-11. (K)SDR ASAA05400762Frame · crackedPAE- FRAME CRACKED AT BIN RAIL ATTACH POINT. REPAIRED CRACKED FRAME IAW SRM. (K)SDR IXXA05SMN288SFrame · crackedDURING ROUTINE C-CHECK INSP, FWD ACCY COMPT INTERNAL PART BETWEEN L-25L AND L-24L, AT STA 255.000 HAS FRAME CRACKED (1.5 INCH). PERFORMED MAJOR REPAIR IAW SRM 53-2-1 FIG.74 (SHEET 1,3). REMOVED FASTENERS IAW SRM 51-1-21. REMOVED DAMAGED SECTION. FABRICATED EXSDR AWXA200600113Frame · corrodedMCN - DURING C19 CHECK DISCOVERED CORROSION ON FRAME ATTACH FLANGE AT BS 827, WL 148, AND FROM BL 3L TO BL 6L. CORROSION WAS FOUND TO BE OUT OF LIMITS IAW BOEING 737-300 SRM 53-00-07-1A1 FIG 101. MAINTENANCE CUT OUT DAMAGED AREA OF FRAME ATTACH FLANGE IAW BSDR 2006UALA00020Frame · crackedCABIN STA 663.75 FRAME IS CRACKED AT 2 RIGHT STR CUTOUT. REMOVED DAMADE FABRICATED AND INSTALLED REPAIR ANGLE, STRINGER SPLICE, AND FILLER REF SRM 53-00-07 REPAIR 9 AND SRM 51-40-02 AND 51-40-03.SDR 2006UALA00019Frame · crackedCABIN STA 663.75 FRAME CRACKED AT NR 3 LT STR CUTOUT. REMOVED DAMAGE AND FABRICATED AND INSTALLED REPAIR ANGLE, SPLICE AND FILLER REF SRM 53-00-07 REPAIR 9, AND 51-40-02 AND 51-40-03.SDR 2006UALA00018Frame · crackedRIGHT FWD CABIN STA 360 BETWEEN STRINGER 8 AND 9 CLIP AND FRAME CRACKED. REMOVED DAMAGE AND FABRICATED AND INSTALLED ANGLE AND FILLER AND STRINGER CLIP PER MM 53-10-84.SDR 2006UALA00017Frame · crackedCABIN STA 787 FRAME IS CRACKED BETWEEN STR 8R AND 9R AT PSU SUPPORT RAIL IS CRACKED. REMOVED THE DAMAGE AND FABRICATED FILER AND ANGLE PER SRM 53-10-84 AND INSTALLED.SDR 2006UALA00016Frame · crackedFWD LT CABIN STA 380 FRAME BETWEEN STRINGER 8 AND 9 CRACKED AT RIVET. REMOVED DAMAGE AND FABRICATED AND INSTALLED FILLER AND DOUBLER PER MM 53-10-84.SDR SWAA054163Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT AFT CARGO DOOR CUTOUT, FWD FRAME NR 5 STOP FITTING. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SIMA200600902Frame · damagedFUSELAGE FRAME AT STA 236 WAS FOUND TO BE CRACKED AT THE END OF A PREVIOUS REPAIR. REMOVED THE PREVIOUS REPAIR, EXTENDED THE CUT OUT TO REMOVE THE CRACK. FABRICATED A FILLER AND DOUBLER. REPAIR DONE IAW SRM. (K)SDR SIMA200600305Longeron · puncturedPUNCTURE ON THE LT NACELLE OB LWR LONGERON. PERFORMED A CUTOUT TO REMOVE THE DAMAGE. FABRICATED AN ANGLE DOUBLER FOR REPAIR. REPAIR DONE IAW SRM. (K)SDR SWAA054148Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT FWD CARGO DOOR CUTOUT, FWD FRAME LOWER STOP FITTING. REPAIRED FRAME PER SWA EA.SDR SWAA054151Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT FWD CARGO DOOR CUTOUT, FWD FRAME NR 5 STOP FITTING. REPAIRED FRAME PER BFG ER.SDR SWAA054150Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT FWD CARGO DOOR CUTOUT, AFT FRAME NR 5 STOP FITTING. REPAIRED FRAME PER BFG ER.SDR SWAA054149Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT AFT CARGO DOOR CUTOUT, AFT FRAME NR 4 STOP FITTING. REPAIRED FRAME PER BFG ER.SDR ASAA0540751Frame · gougedPAE- FRAME CRACKED AT BIN RAIL ATTACH POINT. INSTALLED FRAME REPAIR DOUBLER ON BSTA 480 FRAME RT AT BIN RAIL LOCATION. (K)SDR ASAA0540752Frame · crackedPAE-FRAME CRACKED AT BIN RAIL. REPAIRED FRAME AT BSTA 907RH BIN RAIL ATTACH POINT. (K)SDR SWAA054130Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 639, STR 17L. REPAIRED FRAME PER SRM.SDR SWAA054119Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME PER SRM.SDR SWAA054118Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME PER SRM.SDR AWXA200600144Frame · crackedMCN - MAJOR REPAIR - DURING C19 CHECK DISCOVERED AFT GALLEY DOORWAY FRAME CRACKED, .5 INCHES AT BS 957, WL 257 AND BL 58R. MAINTENANCE REMOVED AND INSTALLED NEW REPLACEMENT DOORWAY FRAME AT BS 957, WL 257 AND BL 58R IAW BOEING 737-300 SRM 52-13-31-404-010-800SDR 2005UALA01531Frame · dentedAFT PIT STA 1580 FRAME HAS A DENT BETWEEN STR 25L AND 26L ON UPPER FLANGE. TRIMMED DAMAGE, INSURANCE CUT, INSTALLED ANGLE DOUBLER PER REO G-10195 AND EVA-50003.SDR 2005UALA01530Frame · dentedAFT PIT FRAME STA 1500, STR 25L AND 26L HAS DENT UPPER FLANGE. CUTOUT DAMAGE AND REPAIRED PER REO G10197 AND EVA-50005.SDR 2005UALA01529Frame · damagedAFT PIT STA 1520 FRAME HAS A DENT BETWEEN STR 25L AND 26L ON UPPER FLANGE. TRIMMED OUT DAMAGE TO FRAME, INSURANCE CUT, INSTALLED ANGLE REPAIR PER REO G10198 AND EVA 50006.SDR 2005UALA01528Frame · damagedAFT PIT STA 1600 FRAME HAS A DENT BETWEEN STR 25L AND 26L ON UPPER FLANGE. CUT OUT DAMAGE, INSURANCE CUT, INSTALLED DOUBLER REPAIR PER RE0-G10199, AND EVA-50007.SDR SWIA200516432Frame · crackedFOUND FS 605.00 BETWEEN STR 18L AND 19L, LOWER FRAME FLANGE CRACKED, ITEM FOUND AT C CHECK INSPECTION. REPAIRED REF REO 601R-53-11-171 REV C.SDR SWIA200516429Frame · crackedFUSELAGE, UPPER AND LOWER FRAME FLANGES ARE CRACKED, FS 605.00 STR 9L, ITEM FOUND AT C CHECK INSPECTION. REPAIR CARRIED OUT IAW REO 601R-53-61-1717.SDR AWXA200600140Frame · crackedMCN - MAJOR REPAIR - DURING C19 CHECK DISCOVERED BS 188 FRAME CRACKED, .25 INCHES, AT WL 207 AND BL 30L. MAINTENANCE CUT OUT AND REMOVED DAMAGED PORTION OF FLANGE AND CHORD FLANGE FROM BS 188 FRAME IAW BOEING 737-300 SRM 53-00-07-2R11 FIG 201. FABRICATED REPSDR USAA051641Frame · crackedSTA 706 FRAME WEB S9L AT I/B RIVET SECURING A/C PSU SUPPORT CRACKED. REMOVED DAMAGE AND INSTALLED, FABRICATED REPAIR PARTS IAW TR 53-10-22, DEFECT SIZE: .187 INCH.SDR USAA051642Frame · crackedSTA 663.75, S3L CRACKED. CUT OUT DAMAGE, INSTALLED FILLER, REPAIR ANGLE AND STRAPS IAW SRM 53-00-07-2R9, DEFECT SIZE: .25 INCH.SDR USAA051644Frame · crackedFRAME 727D LBL 4 TO RBL 4 CRACKED. REMOVED DAMAGED AREAS, FABRICATED AND INSTALLED REPAIR DOUBLERS IAW EA 97220, DEFECT SIZE: .125.SDR SWAA054107Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME PER SRM.SDR SWAA054106Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME PER SRM.SDR SWAA054105Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME PER SRM.SDR SWAA054104Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME PER SRM.SDR SWAA054102Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8R. REPAIRED FRAME PER SRM.SDR SWAA054101Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME PER SRM.SDR SWAA054099Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER SRM.
Back to JASC 5311