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 USAA2009010590023Frame · crackedCLT Q5 MAJOR REPAIR NR 03C20853011/001 CRACK ON FUSELAGE FRAME AT BS500B BELOW S20L. REPAIRED FUSELAGE FRAME AT BS500B BELOW S20L IAW B737 SRM 53-00-07 & US AIRWAYS EA NR 100790.SDR SWAA087400Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 291, BETWEEN STR 5R TO STR 19R. REPAIRED FRAME PER SRM.SDR SWAA087380Frame Splice · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME SPLICE CRACKED AT BS 500, BETWEEN STR 13L TO 14L. REPAIRED FRAME PER ER.SDR SWAA087373Frame · corrodedDURING SCHEDULED 12Y CHECK, FOUND FRAME CORRODED AT BS 500, BETWEEN LBL 3 TO RBL 3. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA087389Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 727D, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA087385Frame Splice · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME SPLICE CRACKED AT BS 500C, STR 13L. REPAIRED FRAME PER ER.SDR SWAA087384Frame Splice · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME SPLICE CRACKED AT BS 727C, BETWEEN STR 13L TO STR 14L. REPAIRED FRAME PER ER.SDR USAA2009012190113Frame · crackedSAL - C19 - MAJOR REPAIR - CRACK ON FRAME AT BS 380 BETWEEN S8R & S9R. REPAIRED FRAME AT BS 380 BETWEEN S8R & S9R IAW US AIRWAYS TASK CARD M1C53002.SDR DL757081795Failsafe · corrodedFAIL/SAFE STRAP CORRODED AT STA 900 SKIN BUTT JOINT BELOW WINDOW BELT RT SIDE OF FUSELAGE. COMPLIED WITH AT SAA SAT ON NON ROUTINE 81716550001.SDR USAA2009011690083Frame · crackedSAL - C19 - MAJOR REPAIR - CRACK ON FRAME AT BS 500C, BETWEEN S8L TO S9L. REPAIRED FRAME AT BS 500C, BETWEEN S8L TO S9L IAW AMERICA WEST AIRLINES TASK CARD M1C53002.SDR USAA2009011590078Frame · crackedSAL - C19 - MAJOR REPAIR - NR 6192125 - FRAME CRACKED AT BS480, BETWEEN S-8L & S9L. REPAIRED FRAME AT BS480, BETWEEN S-8L & S9L IAW AMERICA WEST AIRLINES TASK CARD M1C53002.SDR FDEA200812275311Frame · dentedMAIN DECK CARGO RT FRAME STATION 1741 AT LONGERON 11 FOUND DENTED. REPAIR CARRIED OUT AS PER SRM 53-30-00 FIGURE 1 VOLUME I. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100. DAMAGE TOLERANCE INSPECTION REQUIRED AT INITIAL FLIGHT CYCLE 14,500 AS PER SRM 53-30-0SDR FDEA200812275310Frame · dentedMAIN DECK CARGO - LT FRAME STATION 1741 AT LONGERON 11 FOUND DENT. REPAIR CARRIED OUT AS PER SRM 53-30-00 FIGURE 1 VOLUME I. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100. DAMAGE TOLERANCE INSPECTION REQUIRED AT INITIAL FLIGHT CYCLE 14,500 AS PER SRM 53-30-00SDR FDEA200812265304Frame · dentedFRAME BS 760 S23 AND 24L DENTED. REPAIRED FRAME IAW SRM 53-00-07 FIG 201 REPAIR 5. THIS IS A MAJOR AND CATEGORY "B" REPAIR.SDR FDEA200812245286Frame · dentedFWD PIT, FUSELAGE FRAME BS 780, INNER CHORD, (SLOPING), BETWEEN S24R AND S25R, HAS A DENT. REMOVED DAMAGED SECTION OF BS 780 FRAME, BETWEEN S24R AND S25R, PER SRM 53-00- 07, REPAIR NR 5. RECEIVED FABRICATED FRAME REPAIR PARTS ON MAE TRAVELER NR T8/772747. SDR FDEA200812245280Frame · gougedGOUGED FRAME ON STA 580, STR 3L REMOVED FASTENERS IAW SRM 51-30-2, BLENDED OUT DAMAGE AREA IAW SRM 51-10-1. UT AREA IAW NDTM 51-00-00 FIG 2 PT 4. HFEC AREA IAW NDTM 51-00-00 FIG 23 PT 6. NO DEFECTS NOTED. FOUND TO BE OUT OF LIMITS IAW FDX SRM 53-10-1 FIG 1ASDR ASAA0944181Strap · corrodedCORROSION ON FAILSAFE STRAP. REPLACED FAILSAFE STRAP.SDR ASAA0944178Doubler · corrodedCORROSION ON INTERNAL DOUBLER ON FRAME STA 794 RBL 30 WL 160. R&R INTERNAL DOUBLER PER SRM 51 40 02.SDR ASAA0944170Frame · corrodedCORROSION ON FRAME BS 794. REPLACED BS 794 IN AFT CARGO BAY.SDR ASAA0844100Doubler · corrodedCORROSION ON INTERNAL DOUBLER ON FRAME BS 794 RBL 30 WL 160.SDR ASAA0844099Frame · corrodedCORROSION ON FRAME BS 794.SDR ASAA0844097Failsafe · corrodedCORROSION ON FAILSAFE STRAP.SDR UALA2008122406995Frame · corrodedCORROSION ON TOP OF FRAME 59, AFT PIT FLOOR JUST AFT OF PIT DOOR. MAJOR REPAIR. INSTALL STRAP REPAIR PER TIMCO REO-L01119. OBTAINED APPROVAL FROM AIRBUS VIA RAS-DAHAM-4900705-2008. ON NR K0145C BY 310884 AND INSPECTED BY LC67. THIS IS A PERMANENT REPAIR.SDR SWAA087341Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 500B, BETWEEN STR 28L TO STR 28R. REPAIRED FRAME PER SRM.SDR CALA2008122301165Frame · crackedFRAME CRACKED AT STATION 867 BETWEEN STRINGER 8 AND 9 LEFT. REPAIRED CRACKED FRAME PER EA 5310-04498, OP 2.SDR CALA2008122301164Frame · crackedFRAME CRACKED AT STATION 400 BETWEEN STRINGER 8 AND 9 RIGHT. REPAIRED FRAME AT STATION 400, STRINGER 8R - 9R, PER EA 5310-04498.SDR DHLA2009743548Frame · dentedBS 1030 FRAME DENTED AT STR 26L. ACCOMPLISHED FRAME REPAIR AS REQUIRED PER B727 SRM 51-40-3 FIG 1.SDR SWAA087319Frame · corrodedDURING SCHEDULED 24Y CHECK, FWD CARGO COMPT FRAME CORRODED AT BS 500, BETWEEN STR 27L TO STR 28L. REPAIRED FRAME PER SRM.SDR SWAA087317Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FWD CARGO COMPARTMENT FRAME CORRODED AT BS 500, BETWEEN STR 28L TO STR 28R. REPAIRED FRAME PER SRM.SDR SWAA087312Angle · crackedDURING SCHEDULED 18Y CHECK, FOUND FRAME SUPPORT ANGLE CRACKED AT BS 639, LBL 48. REMOVED AND REPLACED ANGLE PER SRM.SDR 2008FA0000898Frame · corrodedWHILE INSPECTING THE LT AFT FUEL TANK STRUCTURE, DUE TO LIGHTENING DAMAGE EVENT, FOUND THE FOAM INSULATION WATER SOAKED, AND CAUSING SERIOUS CORROSION IN OUTER FLANGE OF AFT PRESSURE BULKHEAD AND SURROUNDING STRUCTURE. THE HOLE IN THE LT OUTER PRESSURE BULKSDR SWAA094509Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 597, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA094508Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA094507Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 907, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA094506Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 727D, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA094505Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 727B, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA094504Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA094503Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR UALA2008122206950Frame · dentedAFT PIT FRAME DENTED BS 1440, STR 26L. MAJOR REPAIR ACCOMPLISHED. REPAIRED FRAME DENT AT STA 1440 WITH FABRICATED J-ANGLE REPAIR.SDR USAA2008122292290Frame · crackedPIT - FPBH - MAJOR REPAIR - CRACK IN FORWARD CARGO DOOR OPENING IN FORWARD FRAME AT LOWER DOOR STOP FITTING ON LOWER EDGE AT BS 440, S24L. REPAIRED DOOR FRAME IAW US AIRWAYS EA 112037.SDR SWAA087296Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 380, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA087291Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 520, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA087290Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA087286Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 348, STR 16L. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA087264Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 727D, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA087263Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND LT CHORD CRACKED AT BS 178, RBL 28, WL 207. REPAIRED CHORD PER ACO.SDR SWAA087262Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND RT CHORD CRACKED AT BS 178, RBL 28, WL 207. REPAIRED CHORD PER ACO.SDR ASAA0844087Frame · corrodedCORROSION ON FRAME AT BS 727B LBL 15 WL 155. REPAIRED FRAME PER SRM 53-00-07 REPAIR 4SDR CALA2008122201161Frame · crackedFRAME CRACKED AT STATION 380 BETWEEN STR 8 AND 9 RIGHT. CUT OUT DAMAGED AREA FROM FRAME AT STATION 380 BETWEEN STRINGERS 8 AND 9 RIGHT. INSTALLED REPAIR ANGLES PER EA5310-04498 OP2.SDR CALA2008122201160Frame · crackedFRAME CRACKED AT STATION 727B BETWEEN STRINGER 8 AND 9 LEFT. CUT OUT DAMAGED AREA FROM FRAME STA 727B BETWEEN STR 8 AND 9 LT INSTALLED REPAIR ANGLES PER EA5310-04498 OP2.
Back to JASC 5311