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 SWAA062771Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 9R. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA062770Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 9L. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA062769Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 9L. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA062762Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 867, LBL 6 TO RBL 6. REPAIRED FRAME SECTION PER SRM.SDR SWAA062761Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 847, LBL 6 TO RBL 6. REPAIRED FRAME SECTION PER SRM.SDR SWAA062747Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500D, STR 20R. REPAIRED FRAME SECTION PER SRM.SDR CALA0600279Frame · corrodedINSPECTION FOUND AFT PIT FORWARD FLOOR FRAME UNDER CAMPLATE CORRODED THROUGH FRAME AT STA 787-807, S2R TO S17R. THE CORRODED SECTION OF FRAME WAS REMOVED AND REPLACED IAW SRM 51-40-02.SDR EIA2006148Frame · crackedMAIN DECK FRAME AT BS 1760 FOUND CRACK BETWEEN S-12 AND S-13R 0.5" LONG. REPAIRED IAW B747 SRM 53-10-04 FIG 87, DOUBLER USED 7075-T6 0.063.SDR EIA2006146Frame · crackedUPPER DECK TENSION TIE LT SIDE STA 840 FOUND 1 OF THE FASTENER HOLES WITH CRACKS ON FRAME, DOUBLER AND AFT CHANNEL. FRAME AND DOUBLER REPAIRED IAW B747 SRM 53-10-04, FIG 52. CRACKED AFT CHANNEL REPAIRED IAW B747 SRM 51-40-03 FIG 3 DOUBLER USED 7075-T6 0.063,SDR EIA2006145Frame · crackedFRAME LOWER LEG AT AFT CARGO STA 1560 BETWEEN STR 41L TO 42L FOUND CRACK AND CORROSION. REPAIRED IAW B747 SRM 53-10-04 FIG 4, REPAIR ANGLE USED 7075-T6 0.063.SDR EIA2006144Frame · crackedFOUND FUSELAGE LOWER LEG AT STA 1580 STRINGER 41L TO 42 L CRACK. CRACKED FRAME REPAIRED IAW B747 SRM 53-10-04 FIG 04 REPAIR ANGLE USED 7075-T6 0.063.SDR EIA2006143Frame · crackedFUSELAGE FRAME LOWER LEG AT STA 1540 STRINGER 41 L TO 42 L FOUND CRACKED. REPAIRED IAW B747 SRM 53-10-04 FIG 4 REPAIR ANGLE USED 7075-T6 0.063.SDR EIA2006142Frame · crackedFUSELAGE FRAME WEB AT AFT CARGO STA 1600 STRINGER 44L FOUND PUNCTURED AND CRACKED. REPAIR IAW B747 SRM 53-10-04 FIG 71, DOUBLER USED 7075-T5 0.040.SDR EIA2006141Frame · crackedAFT CARGO STA 1500 LEFT, FOUND FRAME CRACK AT STRINGER 36 LEFT CUT OUT. CRACKED FRAME REPAIRED IAW B747 SRM 53-10-04 FIG 4, REPAIR ANGLE USED 7075-T60.063.SDR IXXA06SMN258SFrame · crackedDURING ROUTINE C-CHECK INSPECTION FOUND FRAME CRACKED AT STATION 55.000, LONGERON 24 RIGHT. REMOVED EXISTING REPAIR DOUBLER IAW SRM 51-1-21 (XFS 591.250). REMOVED CORROSION (XFS 566.250 – XFS 578.750) IAW SRM 51-1-8 PAGES 17-18. FOUND OUT OF LIMITS IAW SRMSDR EIA2006134Frame · crackedFOUND BULK CARGO, FUSELAGE FRAME AT STA 2040 STR 3 LEFT FOUND CRACKED. REPAIRED IAW B747 SRM 53-10-04 FIG 90 DOUBLER USED 7075-T6 0.071STRAP 7075-T6 0.063.SDR EIA2006133Frame · crackedMAIN-DECK FRAME AT BS 1940 STR 12-R CRACKED. REPAIRED IAW B747 SRM 53-10-04 FIG 87, DOUBLER USED 7075-T6 0.063, STR USED 7075-T6 0.100.SDR QXEA200601995Frame · corrodedPDX C4 THE FORWARD FACE OF THE FRAME AT STATION X182 HAS A 1/2" SPOT OF CORROSION ABOUT 2" OUTBOARD OF STRINGER 31P AND 1" ABOVE THE SKIN. REPAIRED IAW DHC-8-200 SRM 51-20-16 AND SRM 51-20-26.SDR USAA060978Strap · corrodedFOUND FRAME SPLICE STRAP CORRODED, STA 1460, S22L TO S24L. INSTALLED SPLICE STRAP, TRIPLER AND DOUBLER PER EA 97879, SRM 51-40--02; CORROSION TASK C53-153-02; LEVEL 1, DEFECT SIZE: 18" BY 3.5" BY 0.012".SDR HNAA0600101Frame · corrodedFRAME LEG CORRODED BETWEEN STRINGERS 31 AND 32 AT X434. REPLACED RIGHT HAND BOTTOM FRAME SEGMENT.SDR HNAA0600100Frame · corrodedFRAME LEG IS CORRODED AT X436 BETWEEN STRINGERS 30 AND 31S. REPLACED FRAME SEGMENT.SDR 06FDEA2711Frame · dentedFUSELAGE UPPER LOBE FRAME IS DENTED AT BS 600 5" ABOVE STR 17. REMOVED DAMAGED FRAME, REPAIRED FRAME IAW SRM 53-10-2, 51-20-1, 51-30-5, 51-10-2, 51-40-3, 53-10-4, AND 51-30-2.SDR SWAA062694Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FWD CARGO DOOR CUTOUT, FWD FRAME WEB CRACKED AT BS 440, STR 24R. REMOVED AND REPLACED FRAME WEB PER SRM.SDR SWAA062693Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FWD ENTRY DOOR CUTOUT, FWD FRAME CORRODED AT BS 303, LBL 60, WL 210. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA062687Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 807, STR 8R. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA062682Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 20L. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA062681Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, STR 20R. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR ASAA0640822Frame · damagedELONGATED HOLES IN FRAME FLANGE. CUT OUT AND REMOVED 1.1 X .90 DAMAGED AREA ON FRAME UPPER FLANGE. FABRICATED AND INSTALLED REPAIR IAW SRM 51 70 11.SDR PIDA06079Frame · crackedFRAME CRACKED AT STA277 STR 16R. REPAIRED PER SRM 53-00-07.SDR AWXA200601369Frame · crackedFOUND FWD PIT DOORWAY FWD FRAME CRACKED AT LWR DOOR STOP BS 440 AT STR 24RT. REPAIRED FWD PIT DOOR WAY FWD FRAME AT LWR DOOR STOP BS 440 AT STR 24RT IAW AWA ER NR 03 - 5332 - 06206 - HF2.SDR CALA0600272Beltframe · corrodedINSPECTION FOUND BELTFRAME CORRODED AT STA 500C, S26L-27L, LBL 17 - LBL 22. A SHEAR TIE REPAIR ANGLE AND FILLER WERE INSTALLED IAW SRM 53-00-07, REPAIR 1, FIGURE 201.SDR SWAA062674Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 807, STR 14L. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA062673Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 14L. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA062672Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 767, STR 14L. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA062670Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 348, STR 15L. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA062669Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO DOOR FRAME CUTOUT, FWD FRAME CRACKED AT BS 440, NR 1 AND NR 5 DOOR STOP FITTINGS. REMOVED AND REPLACED FRAME SECTION PER BOEING DRAWING AND SRM.SDR SWAA062668Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 291.5, STR 16R. REPAIRED FRAME SECTION PER ER.SDR 06FDEA2689Frame · dentedN01255 FUSELAGE UPPER LOBE, FRAME IS DENTED, BS 540, 5 INCHES ABOVE STR 17R. REMOVED DAMAGE AND REPAIRED IAW SRM 53-10-2, 51-20-1, 51-30-5, 51-10-2, 51-40-3, 53-10-4 AND 51-30-2.SDR 06FDEA2688Frame · dentedFUSELAGE UPPER LOBE, FRAME IS DENTED, BS 580, 5 INCHES ABOVE STR 17R. REMOVED DAMAGE AND REPAIRED FRAME IAW SRM 53-10-2, 51-20-1, 51-40-3, 53-10-4, 51-30-5 AND 51-30-2.SDR ASAA0640819Frame · dentedFOUND AFT CARGO FRAME DENTED. REPAIRED WITH FABRICATED REPAIR PART PER SRM 51 70 11.SDR ASAA0640817Frame · corrodedFOUND CORROSION ON FRAME REPAIRED FRAME PER SRM 53 00 07.SDR ASAA0640815Frame · corrodedFOUND SKIN TO FRAME ATTACH ANGLE CORRODED AT BS 520 BETWEEN STR 27R AND 28R. ATTACH ANGLE REPLACED IAW SRM 51 30 01 53 00 07 AND 51 40 02.SDR ASAA0640814Frame · corrodedFOUND SKIN TO FRAME ATTACH ANGLE CORRODED AT BSTA 520 BETWEEN STR 27R AND 28R. ATTACH ANGLE REPLACED IAW SRM 51 30 01 5300 07 AND 51 40 02.SDR ASAA0640813Frame · corrodedFOUND FWD CARGO PIT FRAME TO SKIN AT BSTA 500C CORRODED. FRAME TO SKIN ATTACHMENT REPAIRED PER SRM 53 00 07.SDR ASAA0640812Frame · corrodedFOUND FWD CARGO FRAME TO SKIN AT BSTA 500C CORRODED. REPAIRED PER SRM 53 00 07.SDR ASAA0640811Frame · corrodedFOUND FWD CARGO PIT FRAME TO SKIN AT BSTA 500B CORRODED. REPAIRED PER SRM 53 00 07.SDR ASAA0640810Frame · dentedFOUND AFT CARGO FRAME DENTED. REPAIRED WITH FABRICATED PART IAW SRM 51 70 11.SDR SWAA062655Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME SECTION IAW SWA EA.SDR SWAA062640Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8R. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA062639Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 887, STR 8R. REMOVED AND REPLACED FRAME SECTION PER SRM.
Back to JASC 5311