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 AALA20120327006Frame · crackedFRAME CRACKED AT BIN SUPPORT BRACKET STATION 440L. INSTALLED REPAIR DOUBLER PER ECO J1159AD.SDR AALA20120327003Frame · crackedFRAME CRACKED AT SUPPORT BRACKET STATION 400L. INSTALLED REPAIR DOUBLER PER ECO J1159D.SDR AALA20120327005Frame · crackedFRAME CRACKED AT SUPPORT ANGLE. INSTALLED REPAIR DOUBLER PER ECO J1159AD.SDR AALA20120327004Frame · crackedFRAME CRACKED AT SUPPORT BRACKET AT BODY STATION 380 LEFT. INSTALLED REPAIR DOUBLER PER ECO J1159AD.SDR SWAA2012041603149Frame · corrodedFRAME CORRODED AT BS 727E, BETWEEN STR 26R TO STR 27R. REPAIRED FRAME IAW SRM AND DWG.SDR QXEA2012032600261Frame · corrodedBS 489.5 FRAME FLANGE CORRODED AT STRINGER 31-32P. REMOVED CORROSION IAW RD 8/4-53-234. REMOVED MATERIAL OUT OF LIMITS. FABRICATED AND INSTALLED NEW FLANGE IAW RD 8/4-53-017. CONFIRMED CRACK FREE, ALODINED PRIMED AND PAINTED.SDR EIAA20120326020Strap · damagedRIGHT BS 800 FRAME STRAP AND STR 17R STRAP HAS 2 EACH HOLES WITH TOOL MARKS. REMOVED DAMAGE, FABBED AND INSTALLED REPAIR PER ERCA 489-53-021-2.SDR FDEA201203261111Frame · chafedFOUND CHAFE MARKS ON FRAME FLANGE AT BS 1280 BETWEEN S11-12L. REPAIRED IAW SRM 53-00-07 REPAIR 3, FIG 201, REV 105. REPAIR IS CLASSIFIED AS MAJOR.SDR FDEA201203261109Frame · chafedFOUND CHAFING MARK ON FRAME AT BS 1280 STR 10L. REPAIR CARRIED OUT IAW SRM 53-00-07 REPAIR 3, FIG 201, REV 105. REPAIR IS CLASSIFIED AS MAJOR.SDR FDEA201203261108Frame · chafedFOUND CHAFING ON FRAME BS 1280, STR 13L. REPAIRED IAW SRM 53-00-07 REPAIR 3 FIG 201 REV 105. REPAIR IS CLASSIFIED AS MAJOR.SDR FDEA201203261107Frame · chafedFOUND CHAFING ON FRAME AT BS 1280, STR 14L. REPAIRED IAW SRM 53-00-07 REPAIR 3, FIG 201, REV 105. REPAIR IS CLASSIFIED AS MAJOR.SDR FDEA201203261106Frame · chafedFOUND CHAFING MARK ON FRAME FLANGE AT BS 1280 AND STR 14R. REPAIRED IAW SRM 53-00-07 REPAIR 3, FIG 201 REV.105. REPAIR IS CLASSIFIED AS MAJOR.SDR FDEA201203261105Frame · chafedFOUND CHAFING ON FRAME AT BS 1280, STR 13R. REPAIRED IAW SRM 53-00-07 REPAIR 3 FIG 201, REV 105. REPAIR IS CLASSIFIED AS MAJOR.SDR FDEA201203261104Frame · chafedFOUND CHAFING ON FRAME AT STA 1280, STR 11R. REPAIRED IAW SRM 53-00-07, REPAIR 3, FIG 201, REV 105. REPAIR IS CLASSIFIED AS MAJOR.SDR C77A201305010002Frame · crackedR CRACK OCCURRED WHILE COLD WORKING DENT DESCRIBED BELOW. ON APPROACH, CREW REPORTED A BIRD STRIKE ON THE UPPER FUSELAGE SKIN JUST AFT OF THE RADOME. AFTER INSPECTION, MX FOUND EVIDENCE OF A BIRD STRIKE THAT CAUSED THE FOLLOWING DAMAGE: ON FR 1 AFTER OPENINGSDR SWAA2012042003285Frame · crackedCRACK ON FRAME LOCATED AT BS 312 BETWEEN STR 5L AND 6L. REPAIRED FRAME PER EA & EO.SDR SWAA2012041803203Frame · corrodedCORROSION ON FRAME AT BS 787, BETWEEN STR 26L AND STR 27L IN AFT CARGO COMPARTMENT. REPAIRED FRAME PER SRM & BAC DRAWING.SDR DALA1225490698Frame · dentedAFT CARGO FRAME DENTED ON UPPER FLANGE STA 1500 I/B STR 25R. TRIMMED OUT DAMAGE, REMOVED FRAME SPLICE, FABRICATED SPLICE/ANGLE REPAIR, STRINGER CLIP AND INSTALLED IAW B757 SRM 53-00-07 DURING HMV.SDR SWAA2012042503201Frame · corrodedCORROSION ON FRAME AT BS 747, BETWEEN STR 26R AND STR 27R IN AFT CARGO COMPARTMENT. REPAIRED FRAME PER SRM & BAC DRAWING.SDR SWAA2012041803202Frame · corrodedCORROSION ON FRAME AT BS 747, BETWEEN STR 27L AND STR 27R IN AFT CARGO COMPARTMENT. REPAIRED FRAME PER SRM & BAC DRAWING.SDR SWAA2012041803200Frame · corrodedCORROSION ON FRAME AT BS 500C BETWEEN STR 28R AND STR 28L FWD CARGO COMPARTMENT. REPAIRED FRAME PER SRM & BAC DRAWING.SDR SWAA2012041703176Frame · corrodedAFT CARGO COMPARTMENT FRAME CORRODED AT BS 727E, BETWEEN STR 26L AND STR 27L. REPAIRED FRAME IAW SRM AND DRAWING.SDR SWAA2012041203075Frame · corrodedFRAME CORRODED AT BS 787, BETWEEN STR 27L TO STR 27R. REPAIRED FRAME IAW SRM.SDR FDEA201203241092Frame · dentedDENT ON AFT CARGO FRAME STA 1480 ABOVE STR 26L. FOUND DENT TO BE OUT OF LIMITS IAW SRM-53-00-07, FIG 101, R & R AFT CARGO FRAME IAW SRM-51-40-02. "CAT A" MAJOR REPAIR.SDR USAA2012032800003Frame · crackedSHEAR SKIN / CDFI VISIT - CRACK ON INNER CHORD FROM BOTTOM FASTENER DOWN TO END OF CHORD AT BS 639, RBBL 63.5. REPAIRED FRAME AT BS 639, RBBL 63.5 IAW TYPICAL REPAIR TR 737-5362-10-002373.SDR QXEA2012032400250Frame · corrodedFRAME BS 547, FLANGES ARE CORRODED AT STRINGER 33-31S. REMOVED RIVETS TO CLEAN UP CORROSION. REMOVED CORROSION IAW RD 8/4-53-2344. REMAINING MATERIAL WITHIN LIMITS AND CONFIRMED CRACK FREE. INSTALLED RIVETS. .SDR FDEA201203241093Frame · dentedDENT ON FRAME BS 1500 ABOVE STR 26L IN CARGO BAY. DENT NOT ALLOWED IN FRAME FLANGE IAW SRM 53-00-07. ALLOWABLE DAMAGE 2 PG 101, FIG 101. R & R FRAME IAW SRM 51-40-02. MAJOR REPAIR.SDR FDEA201203231069Frame · gougedFR47 FRAME FITTING FOUND GOUGE DAMAGE AT THE MACHINE MILL EDGE B/W STR 24L-STR 25L. COMPLIED WITH EO.SDR SWAA2012040202782Frame · corrodedFRAME CORRODED AT BS 311, STR 23L. REPAIRED FRAME IAW SRM.SDR QXEA2012032300245Frame · corrodedFRAME 489.5, FLANGE IS CORRODED AT STRINGER 33-32S. REMOVED CORROSION IAW RD 8/4-53-2344. REMOVED MATERIAL WITHIN LIMITS AND CRACK FREE. ALODINED PRIMED AND PAINTED AREA.SDR QXEA2012032300244Frame · corrodedFRAME 321, FLANGE IS CORRODED AT STRINGER 33-32S. REMOVED CORROSION IAW RD 8/4/53-2344. REMOVED MATERIAL WITHIN LIMITS AND CONFIRMED CRACK FREE. ALODINED PRIMED AND PAINTED AREA.SDR QXEA2012032300243Frame · corrodedFRAME 301, FLANGE IS CORRODED AT STRINGER 33-32S. REMOVED CORROSION IAW RD 8/4-53-2344. MATERIAL REMOVED WITHIN LIMITS AND CRACK FREE. ALODINED PRIMED AND PAINTED AREA.SDR QXEA2012032300242Frame · corrodedFRAME 529.5 FLANGES ARE CORRODED AT STRINGER 33-31S. REMOVED RIVETS FOR ACCESS. REMOVED CORROSION IAW RD 8/4-53-2344. MATERIAL REMOVED WITHIN LIMITS. CRACK FREE. REINSTALLED RIVETS. ALODINED PRIMED AND PAINTED AREA.SDR QXEA2012032300241Frame · corrodedFRAME 604.5, FLANGE IS CORRODED AT STRINGER 31P-32P. REMOVED RIVETS FOR ACCESS TO AREAS. REMOVED CORROSION IAW RD 8/4-53-2344. MATERIAL REMOVED WITHIN LIMITS AND CRACK FREE. RE-INSTALLED RIVETS.SDR QXEA2012032300246Frame · corrodedFRAME 94.8, FLANGE IS CORRODED AT STRINGER 31P-32P. BLENDED AND REMOVED CORROSION IAW RD 8/4-53-2344. AREA CRACK FREE AND MATERIAL REMOVED WITHIN LIMITS. ALODINED AREA, PRIMED AND PAINTED.SDR AALA20120322025Strap · gougedSTRAP FOR STATION 1147 FRAME HAS SCREW GAUGE. INSTALLED NEW STRAP PER AARD 51-10-00-5.SDR AALA20120322024Frame · crackedAFT ACCY 1474 CANT FRAME CRACKED AFT OF LONGERON 18 RIGHT. ACCOMPLISHED DOUBLER REPAIR PER AARD 53-10-00-15.SDR FDEA201203221058Frame · damagedFRAME WEB AT BS 418 BETWEEN STR 11R AND STR 12R CHAFED UNDERNEATH STANDOFF AFTER REMOVAL OF STANDOFF. REPAIRED IAW EA F-5310-158163, PART 1. REPAIR IS CLASSIFIED AS MAJOR.SDR DALA1233939255Frame · crackedAFT ACCESSORY COMPARTMENT CANTED FRAME 1520.225 FWD FACE AT STRINGER 1R FUSELAGE STRAP ATTACHED TO THE CANTED FRAME HAS A CRACK. REPAIRED DAMAGED AT CANTED FRAME STA 1520.225 FWD FACE L2R PER ERA 502687-14 REV O.SDR SWAA2012042703511Frame · corrodedFRAME CORRODED AT BS 827, BETWEEN STR 26R TO STR 27R. REPAIRED FRAME IAW SRM.SDR SWAA2012042603463Frame · crackedSTUB FRAME CRACKED AT BS 296.5, STR 7R. REPAIRED FRAME IAW EO AND EA.SDR SWAA2012042603431Frame · crackedFRAME WEB CRACKED AT BS 277, STR 16L. REPAIRED WEB IAW EA AND EO.SDR FDEA201203211140Frame · corrodedCARGO BAY BS 1480, STR 25- 27R, FRAME CORRODED. BLENDED CORROSION AND CHECKED LIMITS IAW SRM 53-00-07, FIG. 101, SHEET 3; ORIGINAL MATERIAL- .063", AFTER BLENDOUT- .050". BLENDOUT IS OUT OF LIMITS. R & R FRAME IAW SRM 51-40-02 AND DWG 146N1030. MAJOR REPSDR ASOA201200988Frame · corrodedFRAME FS 349.00 CORRODED BETWEEN STR 26L AND 26R. REPAIRED IAW REO 601R-53-21-2276.SDR AALA20120321031Frame · crackedTHE 1497 CANT FRAME CRACKED BELOW RIGHT LOUVER BOX. INSTALLED 1497 FRAME DOUBLER PER SRM 51-01-00 FIGURE 2 AND AARD 53-10-00-15 REPAIR 15.SDR IPXA12572508Frame · dentedINSPECTION TYPE: C, MAIN CARGO BAY BS 1460 STR 16-17L FRAME FLANGE IS DENTED. REPAIRED IAW EA 120282.SDR DALA1217409259Frame · crackedDURING HMV/MOD, FOUND RT FUSELAGE FRAME TAB CRACKED THROUGH RADIUS AT STA 902 UNDER CUSP WEB. REMOVED AND REPLACED FRAME IAW DWG SG09530019.SDR SWAA2012041603151Frame · crackedSTUB FRAME CRACKED AT BS 959.9, STR 17L. REPAIRED FRAME IAW EO AND EA.SDR DALA1217306304Frame · crackedSTA 1160, S-9R FOUND FRAME CRACK AFTER REMOVE FRAME DOUBLER FOR NRC 240-050. ENTERED AND DEFERRED FOR SDR REPORTING. STA 1160 S-9R FRAME CRACKED AREA REPAIRED AS PER B747-400 SRM 53-40-07 REPAIR 3 FIG 201.SDR ASOA201200968Frame · corrodedFRAME 319.70 CORRODED BETWEEN STR 26L AND 36R. REPAIRED IAW REO 601R-53-21-2276.
Back to JASC 5311