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 SWAA117421Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 947.5, STR 20R. REPAIRED FRAME IAW EO.SDR SWAA117420Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 380, STR 16R. REPAIRED FRAME IAW EO.SDR SWAA117419Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 947.5, STR 19R. REPAIRED FRAME IAW EO.SDR SWAA117418Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 616, BETWEEN LBL 45.5 TO LBL 70. REPAIRED FRAME IAW EA.SDR SWAA117417Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 616, BETWEEN STR 14L TO STR 18L. REPAIRED FRAME IAW EA.SDR SWAA117351Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME O/B CHORD CRACKED AT BS 639, STR 16R. REPAIRED FRAME IAW ER AND EA.SDR SWAA117322Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME IAW EA.SDR C2XA11SH160Frame · corrodedSHV - DURING C-CHECK CORROSION PRESENT IN AREA WHERE THE SHUNT CONNECTION BAR COMES IN CONTACT WITH STRUCTURE. MAINTENANCE PERFORMED REPAIR AT APU SHUNT FRAME 80 IAW EC5310-01544 REV C, BONDING CHECK GOOD. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR FDEA201110254649Frame · misrepairedFRAME MISREPAIRED REPAIR AT BS 1440, S24-26L. R & R FRAME IAW SRM 51-40-02, AND DWG 146N1028. MAJOR REPAIR.SDR FDEA201110254648Frame · misrepairedFRAME AT BS 1540, STR 24L-26L MISREPAIRED. REMOVED & REPLACED FRAME IAW SRM 51-40-02 AND DWG 146N1030.SDR HYIA20111024001Frame · corrodedDURING HEAVY CHECK INSPECTION, CORROSION WAS FOUND ON MLG FAIRING RT WEB SEGMENT AT FRAME 29. CORROSION WAS OUT OF LIMITS PER THE SRM 51-21-58. CORRODED FRAME WAS CUT OUT AND NEW PORTION SPLICED IN.SDR UHLA2011102400364Frame · damagedMAJOR REPAIR - PERMANENT REPAIR TO BE ACCOMPLISHED FRAME 16 STRINGER 22L. REMOVED FR16 SHEAR TIE BETWEEN STGR 22L AND 23L, REMOVED DAMAGE AREA. PERFORMED HFEC INSEPCTION, NO CRACK LIKE INDICATIONS FOUND. INSTALLED FILLER, DOUBLER, AND SEAM SEALED IAW EMB 17SDR GLBA20111024HFrame · crackedMAJOR REPAIR - DURING A SCHEDULED ROUTINE INSP FOUND FUSELAGE FRAME AT FS 509 BETWEEN STRINGER 4L & 5L CRACKED AT CARGO DOOR GAS STRUT MOUNT AREA, (UPPER INBD NUTPLATE), 3 CRACKS ABOUT .5" EACH. MX REPAIRED THE AFFECTED AREA AND PERFORMED ALL REQUIRED RII INSDR GLBA20111024GFrame · crackedMAJOR REPAIR - DURING A SCHEDULED ROUTINE INSP FOUND 3 CRACKS AT FUSELAGE FRAME AT FS 456 BETWEEN STRINGER 3L & 4L AT THE UPPER INBD NUTPLATE ON THE CARGO DOOR GAS STRUT MOUNT AREA, ABOUT .5" LENGTH. MX REPAIRED THE AFFECTED AREA AND PERFORMED ALL REQUIRED RISDR IPXA11570170Frame · dentedINSPECTION TYPE:C-CK, AFT CARGO LT SIDE FRAME STA 1480, STR 25L DENTED. REPAIRED AFT CARGO LT SIDE FRAME STA 1480 S-25L IAW SRM 53-00-07-2R REPAIR 5, DETAIL 3 AND EO B757-5310-44696-A.SDR IPXA11570138Frame · dentedINSPECTION TYPE:C-CK, AFT CARGO LEFT SIDE FRAME AT BS 1460 S26L DENTED. REPAIRED IAW SRM 53-00-07-2R REPAIR 5, DETAIL 1.SDR IPXA11570130Frame · dentedINSPECTION TYPE:C-CK, FORWARD CARGO COMPARTMENT BS 820 S23-24L FRAME INNER CHORD DENTED. REPAIRED FRAME IAW SRM 53-00-07-2R, REPAIR 5, DETAIL 1.SDR SWAA117334Frame · corrodedDURING SCHEDULED SPV CHECK, FOUND FRAME CORRODED AT BS 500D, STR 26R. REPAIRED FRAME IAW ER AND EA.SDR SWAA117333Frame · corrodedDURING SCHEDULED SPV CHECK, FOUND FRAME CORRODED AT BS 500, BETWEEN STR 26R TO STR 27R. REPAIRED FRAME IAW ER AND EA.SDR SWAA117308Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA117307Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA117306Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA117293Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 294.5+1, STR 7R. REPAIRED FRAME EO AND EA.SDR SWAA117437Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 616, BETWEEN STR 14L TO STR 18L. REPAIRED FRAME IAW EA.SDR SWAA117435Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 616, STR 14L. REPAIRED FRAME IAW EA.SDR SWAA117434Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 616, WBL 208. REMOVED AND REPLACED FRAME IAW EO AND EA.SDR SWAA117375Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER EA.SDR SWAA117287Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND AFT CARGO COMPARTMENT CORRODED AT BS 867, BETWEEN STR 27L TO STR 27R. REPAIRED FRAME IAW SRM.SDR SWAA117276Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 747, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME IAW EO.SDR SWAA117253Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME WEB CRACKED AT BS 727B, STR 17L. REMOVED AND REPLACED FRAME IAW EO AND SRM.SDR SWAA117247Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME WEB CRACKED AT BS 639, STR 16L. REPAIRED FRAME PER EA AND ER.SDR FDEA201110234626Frame · damagedUPON REMOVAL OF CEILING PANEL IN AFT CARGO AT FRAME 61 R/H FOUND MOST OTBD NUTPLATE TO HAVE MULTIPLE SURROUNDING HOLES ON FRAME. COMPLIED WITH EA 6-5310-156034, FUSELAGE C-61 RT FRAME FITTING LOWER FLANGE.SDR ASAA11410611Frame · crackedREF AD 20090206 400 53 1 STEP 10 STA 500E LT FRAME HAS A CRACK. REMOVED DAMAGE AREA ON FRAME BOOT AT STR 21L. REPAIRED FRAME REF SRM 53 00 08 REPAIR 13.SDR ASAA11410610Frame · crackedREF AD 20090206 400 53 1 STEP 17 STA 500E RT FRAME HAS A CRACK. REMOVED DAMAGED AREA ON FRAME 500E AT 21R STR. COMPLETED STA 500E FRAME AT STR 21R REF SRM 53 00 07 REPAIR 13 AND EA 400 53EA 06597.SDR DALA1509233248Frame · buckledFRAME 75, BUCKLED, BETWEEN S 27-28L, S28-29R, REPAIRED IAW SRM 53-00-12.SDR DALA1159593248Frame · buckledFUSELAGE FRAME FR 75 AT STA 35719 IS BUCKLED BETWEEN STR 27 AND 28 LT AND AT STR 28 AND 29 RT REF NRC 178/179. REMOVED DAMAGED SECTION. DRILLED NEW SECTION, DRILLED REPAIR SLPICES PER A320 SRM 53-00-12 FIG 204. ACCOMPLISHED REPAIR IAW A320 SRM 53-00-12.SDR QXEA2011102401093Frame · corrodedINTERIOR FUSELAGE BELLY FRAME X1.00 FLANGES HAVE CORROSION BETWEEN STR 30S AND 33. BLENDED CORROSION IAW RD 8/4-53-2344. MIN REMAINING THICKNESS .048" CONFIRMED CRACK FREE REF NTM 51-00-02-250-801 AND 51-00-01-250-801. FOUND TO BE WITHIN LIMITS IAW RD 8/4-5SDR QML201110201111Frame · crackedDURING INSP OF THE TAILBOOM AND ATTACH POINT, CRACKING WAS NOTED IN THE UPPER STARBOARD ATTACH BOLT HOLE OF THE TAILBOOM ATTACH FRAME. PN:206-032-308-121, LOCATED AT STA 231.472. AXIAL STRESS EXERTED AT THIS LOCATION BY TAILBOOM FLEX, OVERTIME, CAUSES WEAKENSDR USAA2011110200003Frame · crackedFPBH - CRACK ON FUSELAGE FRAME AT BS 639, S16L, WL 208. REPAIRED FUSELAGE FRAME AT BS 639, S16L, WL208 IAW TYPICAL REPAIR 737-5362-10-0098A.SDR JR2R2011102000502Frame · corrodedFRAME 364 HAS CORROSION IN 2 SPOTS, BETWEEN STGR 27 AND 25R IN THE FWD E&E BAY. REPAIRED FRAME FS 364 24L TO 24R IAW CRJ900 RO CRJ9-53-0817.SDR DALA1159020187Strap · crackedFS 955 LT WING REAR SPAR BLKHD FAIL SAFE STRAP AND T-FITTING ARE CRACKED AT FASTENER HOLES. T-FITTING REPLACEMENT AND FAIL SAFE REPAIR WERE C/W BY ERA 496344-14AD REV ORIG.SDR DALA1159000187Strap · crackedFS 955 RT WING REAR BLKHD FAIL SAFE STRAP AND T-FITTING HAVE CRACKS AT FASTENER HOLES. T-FITTING REPLACED AND STRAP REPAIRED PER ERA 496343-14AD REV ORIG.SDR JR2R2011102000489Frame · corrodedFRAME 319 HAS CORROSION BETWEEN STGR 26L AND 27 IN THE FWD E&E BAY. REPAIRED FRAME 319 BETWEEN STGR 26L AND 26R IAW CRJ900 RO CRJ9-53-0818.SDR JR2R2011102000472Frame · damagedUPON FOM REMOVAL OF RT STUB FRAME AT 379 FRAME HAS HOLE IN RADIUS. LOCATED AND DRILLED NEW RT STUB FRAME AT FS 379 IAW CRJ 900 SRM 51-40-11.SDR DALA1304106902Frame · damagedDURING HMV CHECK, FOUND DAMAGE FROM EXCESSIVE DRILL STARTS ON FRAME. REPAIRED IAW ERA 486833-14.SDR ASAA11410667Frame · crackedFRAME 520 RIGHT SIDE CRACKED AT WIRE PENETRATION HOLE. REPAIRED STA 520 RT FRAME IAW B737 400 SRM 53 00 07 REPAIR 13.SDR ASAA11410612Frame · crackedFRAME 500B RIGHT SIDE CRACKED AT WIRE PENETRATION HOLE. C/W ASA EA 400 53EA 06699 REV NEW ISSUED 03 NOV 2011.SDR SWAA117255Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 663, BETWEEN STR 2L TO STR 2R. REPAIRED FRAME PER SRM AND ER.SDR SWAA117223Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO BAY FRAME CRACKED AT BS 520, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME IAW SRM.SDR NSVA2011266Frame · buckledFRAME AT BS 710 BUCKLED. COMPLETED REPAIR IAW 340SDS023358 AND TD 340-53-11-65.
Back to JASC 5311