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 DALA1133159866Frame · crackedMAIN CABIN STA 560 RIGHT LONG 17 FRAME CRACKED. AT FRAME 560L 17R CUT OUT DAMAGE SECTION 1 1/4 BY 3 3/4 IAW DC9 SRM 53-03 FIG 32. NDT VERIFIED DAMAGE REMOVED. FABRICATED 1-33 ANGLE FROM 7075-0 .071. HEAT TREATED ON PEMCO TRAVELER NR 2547 NR 1585 TO 7075-TSDR DALA1133139866Frame · crackedMAIN CABIN STA 503 FRAME CRACKED AT L17R 2 FASTENERS. AT FRAME 503 L17R CUT OUT DAMAGED SECTION 3 3/4 IAW DC-9 SRM 53-03 FIG 32 NDT VERIFIED DAMAGE REMOVED. FABRICATED 1EA -33 ANGLE FROM 7075-0 0.071. HEAT TREATED ON PEMCO TRAVELER NR 2547NO1585TO 7075-T6. SDR DALA1133129866Frame · crackedMAIN CABIN STA 522 RIGHT LONG 17 FRAME CRACKED. CUT OUT DAMAGE IAW DC9 SRM NR 53-03 F32 NDT VERIFY NO CRACK REMAINS. FAB FILLER IAW 53-03 FIG 2 MAT .063 7075T6.FAB DRILL UP ANGLE -5 .O71 70750. HEAT TREATED ON TRAVELER 216DA956. RECEIVED REPAIR ANGLE SR0953SDR DALA1133109866Frame · crackedMAIN CABIN STA 541 FRAME AT L17R CRACKED AT FASTENER. CUT OUT DAMAGE AREA 1 1/4 BY 3 3/4 IAW 53-03 FIG 32. NDT VERIFY DAMAGE REMOVED. FAB -33 FILLER IAW 53-03 F.32. MATERIAL .071 7075-0 AND DRILL UP. HEAT TREATED ON TRAVELER 216DA956. RECEIVED ANGLE PN SDR DALA1133099866Frame · crackedMAIN CABIN STA 465 FRAME AT L17R CRACKED AT FASTENER. CUT OUT DAMAGE IAW DC-9 SRM 53-03 FIG 32 1 1/4 BY 3 3/4. NDT VERIFY NO DAMAGE. FABRICATED FILLER IAW 53-03 FIG 32.063 7075T6 IAW 53003 FIG 32. FABRICATED -33 ANGLE .071 7075T0 HEAT TREATED ON TRAVELER 21SDR HEEA131085Frame · chafedDURING SCHEDULED MAIN BASE VISIT, PART WAS FOUND TO BE CHAFED.SDR IPXA1566680Frame · dentedINSPECTION TYPE:C, FWD CARGO COMPARTMENT FRAME DENTED AT STA 680 BETWEEN STR 23L-24L. REPAIRED IAW 757-200PF, SRM 53-00-07-2R-5, DETAIL VI.SDR IPXA1566667Frame · dentedINSPECTION TYPE:C, AFT CARGO BAY LT FRAME IS DENTED BS 1540 ABOVE STR 23L. REPAIRED IAW SRM 53-00-07-2R 5 DETAIL I.SDR DALA1132309866Frame · crackedAFT ACC COMPT STA 1275 L7L CANTED FR CRACKED. REMOVED CRACKED ANGLE. OBTAIN NEW ANGLE PN NR SR09530086-31. DRILLED AND DEBURRED, ALODINED AND PRIMED AND INSTALLED ANGLE IAW DC9 SRM 51-10-5, P-226 07 MAY 11 Q-919 483541 07 MAY 11.SDR FOTR2106708543Frame · corrodedCORROSION AT STA 747 AND STR 28R. REPAIRED ON FASI W/O 21067.SDR FOTR2106708995Frame · crackedRT FUSELAGE FRAME AT BS 601 IS CRACKED AT LOWER FASTENER HOLE BELOW STR 17R. REPAIRED ON FASI W/O 21067, NR 08995.SDR ASAA1149799Frame · corrodedIN AFT PIT BS 727B STR 27R TO 26R FRAME IS CORRODED. REMOVED CORROSION FOUND OUT OF LIMITS. CUT OUT DAMAGED AREA, FABRICATED AND INSTALLED REPAIR PARTS IAW B737 400 SRM 53 00 07.SDR FDEA201105081795Frame · damagedBS 620 FRAME DOUBLER HAS FASTENER HOLES WITH NO ED. REMOVED AND REPLACED BS620 FRAME DOUBLER IAW EA 7-5310-123595.SDR FDEA201105081794Frame · damagedAFTER REMOVAL OF FRAME AND CLEANUP FOUND DOUBLE DRILL HOLES STA. 620 BETWEEN STR 3L - 4L. REPAIRED BS 620 STRINGER 3-4L SKIN AND FRAME IAW EA 7-5310-123595.SDR DALA1135811403Frame · crackedM/D STA 903 RBL 92 FRAME INNER CHORD FOUND CRACK. THE FRAME INNER CHORD REPAIRED AS PER ER/A 489746-14AD.SDR DALA1135801403Frame · crackedM/D STA 903 LBL 92 FRAME INNER CHORD FOUND CRACK AND THAT FRAME INNER CHORD REPAIRED PER ER/A 489750-14AD.SDR DALA1133860688Frame · dentedDURING HMV A DENT WAS FOUND AT AFT CARGO COMP FRAME STA 1480 BTW STRINGER S25L-S26L. FRAME WAS REPAIRED IAW SRM 53-00-07 REPAIR 5.SDR USAA2011051291839Frame · crackedPIT - FORWARD PRESSURE BULKHEAD - CRACK IN FUSELAGE FRAME AT BS 616, LBL 62. REPAIRED FUSELAGE FRAME AT BS 616, LBL62 IAW TYPICAL REPAIR TR737-5362-10-0023 & JOB CARD 99S00020003.SDR AALA20110508TUL01Frame · corrodedCORROSION ON LOWER FLANGE OF FRAME STATIONS 1250 AT LONGERON 30. INSTALLED REPAIR STRAP PER EA MD80-53-016796.SDR CALA2011050900353Frame · cracked757-53-3-0370 FWD CARGO COMPT, STA 660 FRAME IS DENTED ON FLANGE AT AREA BETWEEN S23R - S24R. REMOVED DAMAGED AREA AND INSTALLED REPAIR DOUBLER REF SRM 53-30-07 REPAIR 5.SDR ASAA1149779Frame · crackedAFT PASSENGER CABIN BS 827 LT FRAME CRACKED AT PSU ATTACH BRACKET STR 8L. REPAIRED FRAME IAW ASA EA AD20062609 400 53 120.SDR ASAA1149778Frame · crackedAFT CABIN LT FUSELAGE FRAME BS 907 CRACKED AT PSU MOUNT ATTACH BRACKET STR 8L. REPAIRED FRAME IAW ASA EA AD20062609 400 53 120.SDR ASAA1149777Frame · crackedPASSENGER CABIN FRAME CRACKED BS480 STR 8R. REPAIRED FRAME IAW ASA EA AD20062609 400 53 120.SDR ASAA1149776Frame · crackedPASSENGER CABIN FRAME CRACKED BS 400 STR 8R. REPAIRED FRAME IAW ASA EA AD20062609 400 53 120.SDR ASAA1149775Frame · crackedRIGHT FRAME BS 787 CRACKED AT PSU MOUNT BRACKET STR 8R. REPAIRED FRAME IAW ASA EA AD20062609 400 53 120.SDR ASAA1149774Frame · crackedAFT CABIN LT FUSELAGE FRAME BS 787 CRACKED AT PSU MOUNT BRACKET STR 8L. REPAIRED FRAME IAW ASA EA AD20062609 400 53 120.SDR ASAA1149773Frame · crackedAFT PASSENGER CABIN BS 727F LT FRAME CRACKED AT PSU MOUNT ATTACH BRACKET STR 8L. REPAIRED FRAME IAW ASA EA AD20062609 400 53 120.SDR ASAA1149772Frame · crackedAFT PASSENGER CABIN BS 747 LT FRAME CRACKED AT PSU MOUNT ATTACH BRACKET STR 8L. REPAIRED FRAME IAW ASA EA AD20062609 400 53 120.SDR ASAA1149770Frame · crackedPASSENGER CABIN FRAME CRACKED AT BS 380 STR 8R. REPAIRED FRAME IAW ASA EA AD20062609 400 53 120.SDR DALA1137019880Frame · corrodedFWD CARGO AREA STA 600 BETWEEN L27L AND L27R, EVIDENCE OF CORROSION ON METAL FRAME FWD OF AUX FUEL TANK. OUT OF LIMITS AT IAW SRM 51-01, FIG 1. REMOVED DAMAGED FLOOR SUPPORT ANGLE SECTION IAW SRM 51-70-5. FABRICATED REPLACEMENT FLOOR SUPPORT ANGLE IAW DWG 5SDR USAA2011051791868Frame · crackedCLT - Q2 - 4 CRACKS IN FUSELAGE FRAME AT BS 380, S20L. REPAIRED FUSELAGE FRAME AT BS 380, S20L IAW EA 102958.SDR DALA1131731608Frame · crackedFS 903 RT FRAME INNER CHORD WAS CRACKED BETWEEN STR 20R AND 21R AND WAS REPAIRED PER ERA 488821-14AD REV ORG.SDR USAA2011060300014Attach Fitting · corrodedPIT - S5 CHECK - LEVEL 2 EXFOLIATION CORROSION ON CARGO BIN FRAME ATTACH FITTING AT FR 31, BETWEEN STR 40R TO STR 41R. REPLACED CARGO BIN FRAME ATTACH FITTING AT FR 31, BETWEEN STR 40R TO STR 41R IAW A320 SRM 51-42-11.SDR DALA1133880688Frame · dentedDURING HMV A DENT WAS FOUND BULK CARGO COMP FRAME STA 1600 BTW S25L-S26L. FRAME WAS REPAIRED IAW SRM 53-00-07 REPAIR 5 FIG 201 SHEETS (1-15).SDR DALA1133870688Frame · dentedDURING HMV A DENT WAS FOUND BULK CARGO COMP AT FRAME STA 1500 ABOVE S25L. FRAME WAS REPAIRED IAW SRM 53-00-07 FIG 201 SHEET (1-15) REPAIR 5.SDR IPXA1566628Frame Splice · gougedINSPECTION TYPE:C, SCREW STRIKE ON THE BS 620 FRAME SPLICE DOUBLER, INBD FLANGE, BETWEEN STR 8-9L. R & R FRAME SPLICE DOUBLER IAW SRM 51-40-02-0G.SDR QXEA2011050900324Frame · corrodedINTERNAL FUSELAGE UNDERFLOOR, AT STA X94.800 BETWEEN STRINGERS 33 TO 31 LT, FRAME ANGLE HAS SURFACE CORROSION. REMOVED CORROSION IAW Q400 SRM 51-21-00-00-02. FOUND TO BE WITHIN LIMITS OF RD8/4-53-2344. TREATED, PRIMED AND PAINTED WORKED AREA IAW RD 8/4-53-2SDR COMA2011050670014Frame · corrodedLOWER END OF FS 549.00 FRAME CORRODED JUST BELOW THE FLOOR LINE AT STRINGER 18 LT. REMOVED AND REPLACED LT 549 FRAME SECTION IAW CRJ SRM 51-42-06.SDR SWAA2012083007232Frame · crackedFRAME CRACKED AT BS 727, WL 201. REPAIRED FRAME IAW EA AND AAR EA.SDR DALA1133840688Frame · dentedDURING HMV A DENT WAS FOUND FWD CARGO COMPARTMENT FRAME STA 580 BETWEEN STRINGERS S23L-S24L. FRAME WAS REPAIRED IAW SRM 53-00-07 REPAIR NR 5 FIG 201 SHEETS (1-15).SDR ASOA201100888Frame Splice · crackedFRAME SPLICE AT FS 718, STR 20R IS CRACKED. LOCATED AND INSTALLED SERVICEABLE FRAME SPLICE AT FS 718, STR 20R IAW SRM 51-42-06. THIS REPAIR REQUIRES MAJOR/MINOR CLASSIFICATION IAW ASA SOP 5702. THIS REPAIR IS CLASSIFIED AS A MINOR REPAIR IAW ASA SOP 5702.SDR K11A2011050572201Frame · crackedDURING AD INSPECTION FOUND FRAME 1148 CRACKED IN 2 AREAS BETWEEN STRINGERS 30L AND 28L.SDR QXEA2011050600319Frame · corrodedINTERNAL FUSELAGE UNDERFLOOR AT STA X196.000 FRAME ANGLE BETWEEN STR 32 TO 31 RT HAS SURFACE CORROSION. BLENDED OUT CORROSION ON FLANGE IAW RD 8/4-53-2344, FOUND TO BE WITHIN LIMITATIONS IAW RD 8/4-53-2344. COMPLETED REPAIR IAW RD 8/4-53-2344.SDR DALA1131411701Frame · crackedFS 903 FRAME BETWEEN STR 20L AND 21L INNER CHORD CRACKED AND REPAIRED PER ERA 489732-14AD REV ORG.SDR JR2R2011050500183Frame · corrodedFRAME 364 HAS CORROSION IN SPOTS BETWEEN STR 27R AND 25R IN FWD EE BAY. REPAIRED FRAME 364 IAW RO CRJ7-53-0412.SDR HNAA2011062300183Frame · corrodedFRAME AT X202.75, STR 31S IS CORRODED AND THE CORROSION GOES BETWEEN THE TENSION FITTING AND FLOORBEAM SUPPORT STRUT. CORROSION GOES FROM 30S TO 32S. REMOVED FRAME X202.75 BETWEEN STR 28S AND STR 28P. REPLACED WITH NEW FRAME, REMOVED RT FORWARD TENSION FITTSDR IPXA11566746Frame · dentedINSPECTION TYPE:C3, FRAME IS DENTED, INBD FLANGE, STA 580, WL 213, BETWEEN STR 16-17R. REPLACED BS 580, RT FRAME SECTION IAW DWG 143N1008, 143N1024, ER 11-02814 DATED 05-17-11, SRM 51-40-02-0G, AND SRM 51-40-05-0G.SDR IPXA11566514Frame · damagedINSPECTION TYPE:C3, SCREW STRIKE ON INNER FLANGE OF FRAME, STA 440, STR 13R. REPAIRED BS 440 FRAME BETWEEN STR 10R AND 11R TO STR 14R IAW SRM 53-30-07-0I 1, SRM 53-00-07-1A 1, SRM 53-00-07-2R 1, SRM 51-20-01-0G, SRM 51-40-09-0G, SRM 51-40-02-0G, SRM 51-40-SDR DALA1131570917Frame · crackedCRACK ON FRAME STA 1322 AND LONG 17 RT. REPAIRED PER ERA 491696-14 REV ORG.SDR DALA1131560917Frame · crackedCRACK ON FRAME STA Y=1322 BTWN LONG 17LT. REPAIRED PER ERA 491696-14 REV ORG.
Back to JASC 5311