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 SWAA095292Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 291.5, STR 13R. REPAIRED FRAME PER EO.SDR SWAA095291Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 380, BETWEEN STR 15R TO STR 16R. REPAIRED FRAME PER EO.SDR SWAA095279Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 188, STR 17R. REPAIRED FRAME PER SRM.SDR CALA2009082400470Frame · crackedFUSELAGE FRAME CRACKED STA 400 LT BETWEEN STR 8 AND 9 LT. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR ANGLES, PER EC/RA 5310-04996.SDR USAA2009082192195Frame · crackedCLT - Q3 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME AT BS 727B, BETWEEN S8R & S9R. REPAIRED FUSELAGE FRAME AT BS 727B, BETWEEN S8R & S9R IAW TYPICAL REPAIR 53-10-20E.SDR SWAA095272Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 908, BETWEEN STR 22R TO STR 23R. REPAIRED FRAME PER SRM.SDR FDEA200908163023Frame · damagedREWORK REQUIRED ON EXISTING FRAME REPAIR AT BS 535 LONGERON 25 LT FRAME. CARRIED OUT REPAIR IAW EA 1-5310-132181, REPAIR CLASSIFIED MAJOR IAW GMM 6-2-100 REV 107.SDR FDEA200908163022Frame · damagedREWORK REQUIRED ON EXISTING FRAME REPAIR AT BS 535 LONGERON 21 LEFT FRAME. CARRIED OUT REPAIR IAW EA 1-5310-132181, REPAIR CLASSIFIED MAJOR IAW GMM 6-2-100 REV 107.SDR ASAA0946553Stiffener · corrodedAFT PIT STIFFENER ANGLE ON 797 STUB FRAME CORRODED 25R 27R. REMOVED ANGLE, FABBED REPLACEMENT PART AND INSTALLED PARTS.SDR ASAA0946490Stiffener · corrodedAFT PIT STIFFENER ANGLE ON 797 STUB FRAME CORRODED STR 25R 27R. REMOVED ANGLE, FABBED REPLACEMENT PART AND INSTALLED.SDR CALA2009082400467Frame · crackedFUSELAGE FRAME CRACKED AT STA 480 LT BETWEEN STR 8LT AND 9LT. REMOVED DAMAGE FROM FRAME, FABRICATED, TREATED, PRIMED AND INSTALLED REPAIR ANGLES. RE-INSTALLED PSU RAIL BRACKET, INSTALLED NEW SUPPORT FITTING ASSY PER ECRA 5310-04996.SDR CALA2009082400468Frame · crackedFUSELAGE FRAME CRACKED STA 480 BETWEEN STR 8RT AND 9RT. REMOVED DAMAGED FRAME WEB SECTION AND INSTALLED REPAIR ANGLES A AND B REF ECRA 5310-04996.SDR ASAA0946576Frame · crackedFRAME CRACKED AT STA 747 BETWEEN STR 8R AND 9R. REMOVED DAMAGED AREA, FABRICATED REPAIR PARTS, INSTALLED PER EA.SDR ASAA0946575Frame · crackedFRAME CRACKED AT STA 727F BETWEEN STR 8L AND 9L. REMOVED DAMAGED AREA, FABRICATED REPAIR PARTS, INSTALLED PER EA.SDR ASAA0946573Frame · crackedFRAME CRACKED AT STA 440 BETWEEN STR 8L AND 9L. REMOVED DAMAGED AREA, FABRICATED REPAIR PARTS, INSTALLED PER EA.SDR ASAA0946572Frame · crackedFRAME CRACKED AT STA 480 BETWEEN STR 8R AND 9R. REMOVED DAMAGED AREA, FABRICATED REPAIR PARTS, INSTALLED PER EA.SDR ASAA0946571Frame · crackedFRAME CRACKED AT STA 747 BETWEEN STR 8L AND 9L. REMOVED DAMAGED AREA, FABRICATED REPAIR PARTS, INSTALLED PER EA.SDR ASAA0946570Frame · crackedFRAME CRACKED AT STA 727D BETWEEN STR 8R AND 9R. REMOVED DAMAGED AREA, FABRICATED REPAIR PARTS, INSTALLED PER EA.SDR ASAA0946564Frame · crackedCABIN FRAME CRACKED AT STA 400 BETWEEN STR 8L AND 9L IS CRACKED. REMOVED DAMAGED AREA, FABRICATED REPAIR PARTS, INSTALLED PER EA.SDR ASAA0946559Frame · crackedCABIN FRAME CRACKED AT STA 827 BETWEEN STR 8L AND 9L. REMOVED DAMAGED AREA, FABRICATED REPAIR PARTS, INSTALLED PER EA.SDR ASAA0946557Frame · crackedFRAME AT STA 400 BETWEEN STR 8R AND STR 9R IS CRACKED. REMOVED DAMAGED AREA, FABRICATED REPAIR PARTS, INSTALLED PER EA.SDR USAA2009082192201Frame · crackedCLT - Q4 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME AT BS 480 BETWEEN S8L & S9L. FUSELAGE FRAME AT BS 480 BETWEEN S8L & S9L IAW TYPICAL REPAIR 53-10-20E.SDR USAA2009082192200Frame · crackedCLT - Q4 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME AT BS 440 BETWEEN S8L & S9L. FUSELAGE FRAME AT BS 440 BETWEEN S8L & S9L IAW TYPICAL REPAIR 53-10-20E.SDR USAA2009082192199Frame · crackedCLT - Q4 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME AT BS 727D BETWEEN S8R & S9R. REPAIRED FUSELAGE FRAME AT BS 727D BETWEEN S8R & S9R IAW TYPICAL REPAIR 53-10-20E.SDR USAA2009082192198Frame · crackedCLT - Q4 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME AT BS 500A BETWEEN S8R & S9R. REPAIRED FUSELAGE FRAME AT BS 500A BETWEEN S8R & S9R IAW TYPICAL REPAIR 53-10-20E.SDR USAA2009082192197Frame · crackedCLT - Q4 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME AT BS 400 BETWEEN S8R & S9R. REPAIRED FUSELAGE FRAME AT BS 400 BETWEEN S8R & S9R IAW TYPICAL REPAIR 53-10-20E.SDR ASOA200900894Frame · corrodedCORROSION DAMAGE ON FS 364.00 FRAME FROM STR 26 LT TO STR 25 RT.
REMOVED RIVETS & T FITTING CLEANED UP MINOR CORROSION ALODINED & PRIMED SHOT IN RIVETS & INSTALLED T FITTING PER SRM 51-21-06, 51-42-06, AND 51-25-02. REMOVED RIVETS ON FS 364.00 FRAME CAUSE OSDR USAA2009081892169Frame · crackedCLT - Q3 - MAJOR REPAIR - CRACK IN FUSELAGE FRAME AT BS 500B BETWEEN S20L & S21L. REPAIRED FUSELAGE FRAME AT BS 500B BETWEEN S20L & S21L IAW B737 SRM 53-00-07 REPAIR 13.SDR AALA20090814TUL04Frame · corrodedCORROSION ON AFT SIDE OF FRAME STATION 1309 LONGERON 29L LONGERON 29R. REPAIRED UNDER AARD 53-10-00-17 AND EA MD 80-53-007091.SDR AALA20090814TUL03Frame · crackedFRAME STATION 1446 OUTBOARD OF LONGERON 2L IS CRACKED. REPAIRED FRAME UNDER EA MD80-53-007119 AND SRM 53-03-00.SDR ASOA200900879Frame · crackedIN REFERENCE TO TASK CARD AWL2 53-41-201, FRAME CAP ANGLE IS CRACKED AT LBL 18.0 ON OUTBOARD SIDE AT FS 559.00. REPAIRED IAW REO 601R-53-41-1044.SDR FDEA200908133006Frame · corrodedUPON REMOVAL OF LAV SERVICE BOX FOUND CORROSION ON SKIN ON INTERNAL SIDE AT TOP SIDE OF CUT OUT. REMOVED LEVEL 1 CORROSION. REMOVED AND REPLACED INTERNAL LAV SERVICE PANEL CUTOUT DOUBLER AND INSTALLED FRAME SPICE REPAIR AT FR 12 BETWEEN STR 38 AND STR 44 LT ISDR DL76G091961Frame · crackedSTA 1809.5 BULKHEAD FWD CHORD, CRACKED APPROX 1" IN RADIUS AT STR 5R. REPAIRED DAMAGE IAW SRM 53-80-08, REPAIR 9.SDR USAA2009081492129Frame · crackedCLT - Q3 - MAJOR REPAIR - CRACK ON STUB FRAME AT BS 601, RBL 65, WL 201. REPAIRED STUB FRAME AT BS 601, RBL 65, WL 201 IAW EA 101323.SDR USAA2009081392112Frame · crackedCLT - Q3 - MAJOR REPAIR - CRACK ON FRAME AT BS 616, WL 201, RBL 65. REPAIRED FRAME AT BS 616, WL 201, RBL 65 IAW TYPICAL REPAIR 53-62-01.SDR USAA2009081392111Frame · crackedCLT - Q3 - MAJOR REPAIR - CRACK ON FRAME AT BS 616, WL 201, LBL 65. REPAIRED FRAME AT BS 616, WL 201, LBL 65 IAW TYPICAL REPAIR 53-62-01.SDR SWAA095191Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND STUB FRAME CHORD CRACKED AT BS 190, WL 207 LT SIDE. REPAIRED CHORD PER SRM.SDR SWAA095189Angle · corrodedDURING SCHEDULED SPV CHECK, FOUND FRAME ANGLE CORRODED AT BS 500B, BETWEEN STR 28L TO STR 28R. REPAIRED ANGLE PER SRM.SDR SWAA095188Angle · corrodedDURING SCHEDULED SPV CHECK, FOUND FRAME ANGLE CORRODED AT BS 500, BETWEEN STR 26L TO STR 27L. REPAIRED ANGLE PER SRM.SDR UALA2009081302470Frame · corrodedFOUND CORROSION ON FRAME AT STA 1680 BETWEEN STR 29 RT AND STR 30. MAJOR REPAIR ACCOMPLISHED: PERFORMED A GVI OF FUSELAGE STRUCTURE BETWEEN BS 1664-1700 AND STR 26L-26R. FOUND CORROSION ON FRAME, BS 1681 AND SHEAR TIE BETWEEN ST R-27L-28L. REMOVED FRAME ANSDR PIDA09024Frame · crackedDURING C CHECK, FOUND BS 787 LEFT FRAME CRACKED AT PSU RAIL. REPAIRED FRAME IAW SRM 53-00-07.SDR AALA20090814TUL08Frame · crackedCANT FRAME 1485 LEFT SIDE IS CRACKED. INSTALLED DOUBLER UNDER AARD 53-10-00-32.SDR SWAA095185Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 639, BETWEEN LBL 65 TO LBL 68. REPAIRED FRAME PER SWA EA.SDR SWAA095182Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 727E, BETWEEN STR 13L TO STR 14L. REPAIRED FRAME PER SWA EA.SDR SWAA095180Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 500A, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME PER EA.SDR SWAA095175Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME OUTER CHORD CRACKED AT BS 639, BETWEEN RBL 65 TO RBL 68. REPAIRED CHORD PER AAR EA.SDR SWAA095174Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND LT STUB BEAM CRACKED AT BS 639, LBL 63. REPAIRED BEAM PER AAR EA.SDR SWAA095170Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME WEB CRACKED AT BS 639, BETWEEN RBL 65 TO RBL 68. REPAIRED WEB PER EA.SDR SWAA095164Frame · crackedDURING SCHEDULED 8Y CHECK, FOUND FRAME CRACKED AT BS 294, STR 17R. REPAIRED FRAME PER SRM.SDR SWAA095162Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 767, STR 13L TO STR 14L. REPAIRED FRAME PER AAR EA.
Back to JASC 5311