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 72300183Frame · corrodedSEVERAL AREAS OF CORROSION ON FRAME.SDR AWXA200500398Frame · corrodedMCN - MAJOR REPAIR - DURING C-16 CHECK EXFOLIATION CORROSION WAS FOUND ON AFT SIDE OF FRAME BETWEEN STR 25 RT AND STR 26 RT. MAINTENANCE BLENDED OUT CORROSION ON AFT SIDE OF FRAME AT BS 794, BETWEEN STR 25 RT AND STR 26 RT; FABRICATED 2 EACH REPAIR ANGLES; INSDR AWXA200500373Frame · corrodedMCN - MAJOR REPAIR - DURING C-16 CHECK GALVANIC CORROSION WAS FOUND ON FORWARD AND AFT SIDE OF FRAME AT BS 847 BETWEEN STR 25 RT AND STR 26 RT. MAINTENANCE BLENDED OUT CORROSION ON FRAME AND PERFORMED HFEC INSPECTION OF EXISTING HOLES COMMON TO REPAIR. REMOVSDR MALA050244Frame · corrodedDURING C2 CHECK IN YYC FOUND INBOARD FWD AT FRAME 15 CORROSION FOUND ON ATTACHMENT OF FWD STOWING AIRSTAIRS RAILING.SDR SWAA050639Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 9R. REPAIRED FUSELAGE FRAME PER SRM.SDR SWAA050637Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 9L. REPAIRED FUSELAGE FRAME PER SRM.SDR ASAA0580150Frame · chafedC-CHECK, UPPER LT ACCY COMPARTMENT FWD EDGE OF FRAME WEB IS CHAFED. REMOVED DAMAGED SECTION. INSTALLED REPAIR DOUBLERS AND FILLER. (K)SDR AWXA200500399Frame · corrodedMCN - MAJOR REPAIR - DURING C-16 CHECK EXFOLIATION CORROSION WAS FOUND ON FORWARD AND AFT FACE OF FRAME AT BS 794.3, STR 26 RT IN AFT CARGO COMPARTMENT. MAINTENANCE BLENDED OUT CORROSION ON FRAME AT BS 794.3, STR 26 RT; FABRICATED 2 EACH REPAIR ANGLES; INSTALSDR SWAA050619Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 188, STR 17L & 17R. REPAIRED FUSELAGE FRAME PER SRM.SDR SWAA050616Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME WEB CRACKED AT BS 303.9, STR 4L. REPAIRED FRAME WEB PER SRM.SDR SWAA050615Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME WEB CRACKED AT BS 277, STR 14R. REPAIRED FRAME WEB PER SRM.SDR SWAA050614Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACK AT BS 380, STR 9R. REPAIRED FUSELAGE FRAME PER SRM.SDR SWAA050613Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 9R. REPAIRED FUSELAGE FRAME PER SRM.SDR 0500246730Frame · crackedDURING LINE CHECK FOUND CRACK IN FRAME AT BS 440 STRINGER 10L. REPAIRED PER EA 67-203062.SDR SWAA050599Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 9R. REPAIRED FUSELAGE FRAME PER SRM.SDR SWAA050598Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727E, STR 9L. REPAIRED FUSELAGE FRAME PER SRM.SDR 2005UALA00188Frame · dentedAFT PIT STA 1360 FRAME DENTED STR 26L. FRAME WAS TRIMMED AND ANGLE DOUBLERS WERE INSTALLED.SDR SWAA050601Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 9R. REPAIRED FUSELAGE FRAME PER SRM.SDR ASAA0540144Frame · corrodedPAE - FOUND CORROSION AFT CARGO BAY ON FRAME BS 767 STRINGER 25R AND 27R FORWARD SIDE OF FRAME. REMOVED AND REPLACED FRAME. (M)SDR SWAA050571Frame · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED FRAME AT BS 807, STR 9L. REPAIRED FRAME PER SRM.SDR 2005UALA00182Frame · dentedAFT PIT STA 1480 FRAME DENTED ON INBD FLANGE AT STR 26L. TYPICAL PIT FRAME UPPER INNER FRAME CAP DAMAGE. FRAME REPAIRED USING NESTED J-ANGLE REPAIR.SDR 2005UALA00181Frame · dentedAFT PIT STA 1460 LT FRAME DENTED AT STR 25L ON INBD FLANGE.TYPICAL PIT FRAME UPPER INNER FRAME CAP DAMAGE. FRAME REPAIRED USING NESTED J-ANGLE REPAIR.SDR 2005UALA00180Frame · dentedFWD PIT FRAME DENTED ON INBD FLANGE AT BS 660 AND STR 24L. TYPICAL PIT FRAME UPPER INNER FRAME CAP DAMAGE. FRAME REPAIRED USING NESTED J-ANGLE REPAIR.SDR 2005UALA00179Frame · dentedFWD PIT STA 640 FRAME DENTED ON INBD FLANGE AT STR 25R. TYPICAL PIT FRAME UPPER INNER FRAME CAP DAMAGE. FRAME REPAIRED USING NESTED J-ANGLE REPAIR.SDR 2005UALA00178Frame · dentedFWD PIT STA 600 FRAME DENTED AT STR 24L ON INBD FLANGE. TYPICAL PIT FRAME UPPER INNER FRAME CAP DAMAGE. FRAME REPAIRED USING NESTED J-ANGLE REPAIR.SDR 050546238Frame · crackedRIGHT FS 718 FRAME CRACKED AT 1 INCH IN LENGTH. CRACK IS BELOW EXISTING REPAIR.SDR 050546237Frame · crackedLEFT FS 718 FRAME CRACKED AT 1 INCH IN LENGTH. CRACK IS BELOW EXISTING REPAIR.SDR EIA2005026Frame · crackedFUSELAGE STA 1000 CHORD IS CRACKED BETWEEN STR 37L-38L NEAR BATHTUB FITTING AT EXTERIOR SIDE UNDER RAM AIR DUCT. REMOVED DAMAGED CHORD FROM STA 1000 BETWEEN STR 37-38 LT AND REPLACED PER B747 SERVICE BULLETIN 747-53A2471 FIG 13 AND EO 53-747-1072-90 REV A PARSDR EIA2005020Frame · crackedCRACK AT LOWER FRAME STR 25R, R5 DOOR STA 2231. INSTALLED NEW LOWER FRAME STA 2231 AT STR 25R PER B747 SRM 51-30-02 PG 8-9.SDR EIA2005018Frame · crackedCRACK INDICATION NOTED IN LWR FASTENER HOLES IN LTC-3 FRAME UPPER CLOSURE FITTING DURING OPEN HOLE HFEC INSPECTION. REAMED HOLE INSTALLED FREEZE PLUG IN LOWER HOLE AND INSTALLED FASTENER PER B747 SRM 51-10-08 PGS 1-11, 51-30-09 PGS 1-16, 20, 29, 30 AND BOEINGSDR EIA2005015Frame · crackedCRACK INDICATION NOTED IN 4 EA FASTENER HOLES AT STA 800, STR 16L, FWD INNER FRAME CHORD. REMOVED EXISTING REPAIR PARTS, FABRICATED NEW STRAPS AND INSTALLED REQUIRED EXISTING AND FABRICATED STRAPS PER ECRA 471-53-230-2.SDR EIA2005014Frame · crackedMAIN CABIN INTERIOR, RT MAIN FRAME CRACK AT BS 360, BETWEEN STR 14 & 15. REMOVED AND REPLACED MAIN FRAME AT STA 360 RT MAIN CABIN PER ECRA 471-53-240-2 BETWEEN STR 13A TO 23 B747 SRM 51-30-02 PAGES 2, 3, 8 & 9.SDR EIA2005037Frame · crackedBS 1840 STR 11R FRAME CRACKED. DAMAGE REMOVED, FABBED AND INSTALLED REPAIR PER ECRA 478-51-173-1.SDR EIA2005034Frame · crackedBS 1780 STR 13R FRAME CRACKED. DAMAGE REMOVED, REPAIR PARTS FABBED AND INSTALLED PER SRM 53-10-04.SDR EIA2005033Frame · crackedBS 880 LT STR 8L - 9L TENSION TIE FRAME CRACKED. DAMAGED AREA REMOVED, REPAIR FABBED AND INSTALLED PER ECRA 478-51-173-1.SDR C2XA05SH016Frame · tool damageSHV - DURING C-CHECK TOOLING MARK ON FRM 60 STR 5 L. MAINTENANCE REMOVE THE DAMAGE AREA AND PERFORMED REPAIRED IAW EMB145 SRM 53-00-04 SECTION 14 FIGURE 206. THE AIRCRAFT WAS APROVED FOR RETURN TO SERVICE.SDR MALA050229Frame · chafedRIGHT FRAME SECTION AT FS 686.888 IS CHAFED AND HAS BEEN REPAIRED IAW MESABA EO S53285.SDR SWAA050532Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME CRACKED AT BS 907, STR 9R. REPAIRED FRAME PER SRM.SDR SWAA050531Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME CRACKED AT BS 887, STR 9R. REPAIRED FRAME PER SRM.SDR SWAA050530Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME CRACKED AT BS 827, STR 9R. REPAIRED FRAME PER SRM.SDR SWAA050529Frame · crackedDURING SCHEDULED D-CHECK, FOUND BS 440 FRAME CRACKED AT STR 9L. REPAIRED FRAME PER SRM.SDR SWAA050523Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND CRACKED FRAME AT LT FWD LOWER CORNER EMERGENCY EXIT AT BS 616. REPAIRED FRAME PER TYPICAL REPAIR MANUAL.SDR EIA2005012Strap · crackedCRACK IN FRAME INNER STRAP AT STA 2231 LT FROM STR 25 TO STR 26 AT L-5 DOOR FWD FRAME. REMOVED STRUCTURE AS REQUIRED. FABRICATED REQUIRED PARTS AND INSTALLED FABRICATED STRAPS ALL PER ECRA 471-53-236-2P AND B747 SRM 53-10-04 PG 689-694.SDR EIA2005008Frame · crackedCRACK INDICATION IN LWR TWO FASTENER HOLES IN RT C-3 FRAME UPPER CLOSURE FITTING. REPAIRED RT C-3 FRAME UPPER CLOSURE FITTING PER ECRA 471-53-243-2.SDR SWAA050515Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FRAME AT BS 287,STR 16L CRACKED. REPAIRED FRAME SECTION PER EA.SDR SWAA050509Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME AT BS 787, STR 9R CRACKED. REPAIRED FRAME SECTION PER SRM.SDR USAA050332Frame · crackedPIT - FOUND FRAME CRACKED .25 INCH, STATION 616 FRAME JUST BELOW FLOOR. DOUBLER INSTALLED PER TYPICAL REPAIR 53-62-01. (M)SDR USAA050326Frame · crackedPIT - FOUND FRAME CRACKED .25 INCH, JUST BELOW FLOOR ON FRAME 616L. INSTALLED DOUBLER PER TYPICAL REPAIR 53-62-01. (M)SDR 2005UALA00172Frame · damaged178 BULKHEAD UPPER FRAME ANGLE LT SIDE AT SPLICE HAS 2 EACH HOLES WITH NO EDGE DISTANCE. TRIMMED THE DISCREPANT FRAME, FABRICATED AND INSTALLED REPAIR FRAME SPLICE ANGLE.SDR CALA0500047Frame · corrodedINSPECTION FOUND STA 500 FRAME CORRODED AT SKIN ATTACH POINT BETWEEN S27R AND S28R, RBL 11-RBL 16. A FRAME REPAIR WAS INSTALLED IAW SRM 53-00-07, FIGURE 203.
Back to JASC 5311