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 SWAA085970Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 887, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA085969Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 847, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA085968Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA085967Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 807, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA085966Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA085965Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA085964Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA085946Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA085945Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA085939Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8R. REPAIRED FRAME PER PAE EA.SDR SWAA085938Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME PER PAE EA.SDR SWAA085937Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER PAE EA.SDR SWAA085936Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 8L. REPAIRED FRAME PER PAE EA.SDR SWAA085935Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8L. REPAIRED FRAME PER PAE EA.SDR SWAA085934Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA085933Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA085932Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA085931Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 732, STR 4R. REPAIRED FRAME PER SWA ACO.SDR SWAA085926Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA085925Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA085924Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA085923Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA085922Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA085921Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR 08FDEA04642Frame · gougedMAIN CARGO DECK HAS GOUGE ON FRAME SPLICE AT FR 29 3.5 INCH BELOW STR 12. REMOVED AND REPLACED FRAME SPLICE IAW SRM 51-40-21, LOCATED AND DRILLED IAW SRM 51-40-44. TREATED AND PRIMED IAW SRM 51-21-10. SPLICE FABRICATED ON TRAVELER T8/765592.SDR 08FDEA04639Frame · corrodedAFT CARGO COMPT, BS 1320, S-26L, IS CORRODED. REPAIRED FRAME, BS 1320, S-26R, IAW SRM 53-00-07, REPAIR NR 5. INSTALLED REPAIR IAW SRM 51-40-02. THIS REPAIR IS CLASSIFIED AS A CATEGORY "B" MAJOR REPAIR WITH THE FOLLOWING FOLLOW UP TRACKING REQUIREMENTS: INITSDR 08FDEA04638Frame · dentedFWD CARGO COMPT, BS 760, S-24L, FRAME UPPER J-ANGLE IS DENTED. REPAIRED FRAME, BS 760, S-24L, FWD CARGO COMPT, IAW SRM 53-00-07, REPAIR NR 5. INSTALLED REPAIR PARTS IAW SRM 51-40-02. THIS REPAIR I CLASSIFIED AS A CATEGORY 'B" MAJOR REPAIR WITH THE FOLLOWISDR 08FDEA04629Frame · gougedMAIN CARGO DECK HAS GOUGE ON FRAME SPLICE ON FRAME 30 2.5 INCH BELOW STR 12. REMOVED AND REPLACED FRAME SPLICE IAW SRM 51-40-21. NEW SPLICE FABRICATED ON TRAVELER T8/ 765593. LOCATED AND DRILLED IAW SRM 51-40-44. TREATED AND PRIMED IAW SRM 51-21-10.SDR 08FDEA04628Frame · gougedMAIN CARGO DECK HAS GOUGE ON FRAME SPLICE ON FRAME 29 2.5 INCH BELOW STR 12 L. REMOVED AND REPLACED SPLICE IAW SRM 51-40-21. NEW SPLICE FABRICATED ON TRAVELER T8/765594 MAT.2024-0 .063C BATCH NR 3976. LOCATED AND DRILLED IAW SRM 51-40-45. TREATED AND PRIMESDR 08FDEA04620Frame · dentedFWD CARGO PIT STA 760 STR -24L FRAME UPPER J ANGLE DENTED. REPAIRED FRAME STA 760 STR -24L IAW SRM 53-00-07,51-40-02. SUBSEQUENT INSPECTIONS ARE REQUIRED PER SRM 53-00-07, PAGE 208, REPAIR 5, DETAIL III AND PAGE 210, TABLE II. THIS IS A CLASS "B" REPAIR WITSDR ASOA200801416Frame · corrodedCORROSION ON 280 FRAME AT RBL 9. CORROSION OUT OF LIMITS. REMOVED AND REPLACED FRAME.SDR ASOA200801415Frame · corrodedCORROSION ON 280 FRAME AT LBL 9. REMOVED AND REPLACED FRAME. REMOVED MINOR CORROSION ON FRAME. BEGAN REMOVAL OF 280 BEAM LT PER SB670BA-53-026.SDR C8GA20080083Frame · corrodedWHILE IN HEAVY PERFORMING INSPECTIONS IT WAS NOTED THAT THE FRAME WAS DENTED AT BS 1110 JUST ABOVE STR 26R CUT OUT DAMAGED FRAME AND FABRICATED NEW FRAME FROM 7075-O .063 INCH 23 INCH BY 4.5 INCH. HEAT TREATED FRAME TO T6. INSTALLED REPAIR IAW SRM 53-10-2 ANSDR ASAA0843926Frame · crackedFRAME CRACKED STA 867 STR 8 9L. CUTOUT DAMAGE FABRICATED AND INSTALLED REPAIR ANGLES AND FILLER IAW ASA EA 400 53EA 00267.SDR ASAA0843925Frame · crackedFRAME CRACKED STA 787 STR 8 9L. CUTOUT DAMAGE FABRICATED AND INSTALLED REPAIR ANGLES AND FILLER IAW ASA EA 400 53EA 00267.SDR ASAA0843911Frame · crackedFRAME CRACKED. REMOVED DAMAGED SECTION. INSTALLED REPAIR ANGLES AND FILLER PER ASA EA 400-53EA-00267.SDR ASAA0843909Frame · crackedFRAME CRACKED. REMOVED DAMAGED SECTION. INSTALLED REPAIR ANGLES AND FILLER PER ASA EA 400-53EA-00267.SDR ASAA0843908Frame · crackedFRAME CRACKED. REMOVED DAMAGED SECTION. INSTALLED REPAIR ANGLES AND FILLER PER ASA EA 400-53EA-00267.SDR ASAA0843907Frame · crackedFRAMED CRACKED. REMOVED DAMAGED SECTION. INSTALLED REPAIR ANGLES AND FILLER PER ASA EA 400-53EA-00267.SDR ASAA0843905Frame · crackedFRAME CRACKED. REMOVED DAMAGED SECTION. INSTALLED REPAIR ANGLES AND FILLER PER ASA EA 400 53EA 00267.SDR ASAA0843895Frame · crackedFRAME CRACKED. REMOVED DAMAGED SECTION. INSTALLED REPAIR ANGLES AND FILLER PER ASA EA 400 53EA 00267.SDR ASAA0843894Frame · crackedFRAME CRACKED. REMOVED DAMAGED SECTION. INSTALLED REPAIR ANGLES AND FILLER PER EA 400 53EA 00267.SDR ASAA0843893Frame · crackedFRAME CRACKED. REMOVED DAMAGED SECTION. INSTALLED REPAIR ANGLES AND FILLER PER ASA EA 400 53EA 00267.SDR ASAA0843892Frame · crackedFRAME CRACKED. REMOVED DAMAGED SECTION. INSTALLED REPAIR ANGLES AND FILLER PER ASA EA 400-53EA-164.SDR ASAA0843891Frame · crackedFRAME CRACKED. REMOVED DAMAGED SECTION. INSTALLED REPAIR ANGLES AND FILLER PER EA 400 53EA 00267.SDR ASAA0843902Frame · crackedFRAME CRACKED. REMOVED DAMAGED SECTION. INSTALLED REPAIR ANGLES AND FILLER PER EA 400 53EA 00267.SDR ASAA0843901Frame · crackedFRAME CRACKED. REMOVED DAMAGED SECTION. INSTALLED REPAIR ANGLES AND FILLER PER EA 400-53EA-00267.SDR ASAA0843900Frame · crackedFRAME CRACKED. REMOVED DAMAGED SECTION. INSTALLED REPAIR ANGLES AND FILLER PER ASA EA 400 53EA 00267.SDR ASAA0843898Frame · crackedFRAME CRACKED. REMOVED DAMAGED SECTION. INSTALLED REPAIR ANGLES AND FILLER PER ASA EA 400 53EA 00267.SDR ASAA0843897Frame · crackedFRAME CRACKED. REMOVED DAMAGED SECTION. INSTALLED REPAIR ANGLES AND FILLER PER EA 400 53EA 00267.
Back to JASC 5311