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 KNNA200700002Frame · damagedINSTALLED INTERIM REPAIR AT L2 DOOR CUTOUT AT THE FWD LOWER CORNER. REMOVED INTERIM REPAIR AND INSTALLED PERMANENT REPAIR.SDR DHL2006780122Frame · corrodedAFT CARGO COMPT, CORROSION ON FRAME BS 950F, STR 28L. CUT OUT DAMAGED AREA APPROX 2" BY 1.5", AND FABRICATED REPAIR ANGLE FROM 7075-T6, .040" BY 4.25" BY 3", PO NR 634724, PER B727 SRM 51-40-3 FIG 1 AND 53-10-2 FIG 5. TREATED, PRIMED, AND INSTALLED REPAIR ANSDR 06FDEA04140Frame · damagedAFT CABIN, AFT PRESSURE BULKHEAD LOWER T-CHORD AT STA 2007 FOUND EXISTING REPAIR DOUBLER AT RBL 27.5. SNRM N01258: REFER TO SNRM N00806 AND SRM 51-31-01 VOL II FOR WORK CARRIED OUT. AFT CABIN, AFT PRESSURE BULKHEAD LOWER T-CHORD AT STA 2007 REMOVED AS PER SRSDR SWAA064616Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 26R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA064615Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 20R. REPAIRED FRAME SECTION PER SRM.SDR TRAX200601064Frame · crackedSUSPECT CRACK ON FS 640 FRAME PER INSPECTION OF TASK CARD E0600-53-69-0002. FLT 4256 CX.SDR SWAA064579Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 9L. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA064578Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 9R AND STR 9L. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA064577Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 9R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA064576Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 9R AND STR 9L. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA064575Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 9R AND STR 9L. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA064574Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 9R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA064573Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 9R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA064572Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 9R AND STR 9L. REPAIRED FRAME SECTION PER SWA EA.SDR 06FDEA04130Frame · damagedWHILE WORKING LT FS 12A DUE TO TOOLING MALFUNCTION DAMAGE TO FRAME 12A APPROX STR 29 COMPLIED WITH EA6-5310-105011.SDR TRAX200601059Frame · crackedLEFT SIDE FS 640 FRAME CRACKED.SDR USAA061362Frame · crackedSTATION 520 BETWEEN S8L AND S9L CRACKED. INSTALLED FRAME DOUBLER IAW TR 53-10-20D, DEFECT SIZE: .375 INCH.SDR AWXA200602019Frame · crackedMCN - R-2 DOOR CUT OUT SURROUND STRUCTURE, UPPER FORWARD STUB FRAME CRACKED, B/S 954, RBL 60, WL 262. REPLACED R-2 DOOR CUT OUT SURROUND STRUCTURE, UPPER FORWARD STUB FRAME, B/S 954, RBL 60, WL 262 IAW B737-300 SRM 51-40-02.SDR DJFA2006346Frame · crackedDURING SCHEDULED MAINTENANCE A CRACK WAS LOCATED AT THE FRAME 10 RIB, UNDER THE CENTER ISLE FLOOR AT THE GALLEY. REPAIRED FRAME 10 IAW SRM 51.71.11.SDR USAA061350Frame · crackedPSU HANGAR BRACKET I/B ATTACH RIVET STATION 440 LEFT SIDE CRACKED. INSTALLED DOUBLERS IAW TR 53-10-20D, DEFECT SIZE: .375 INCH.SDR SWAA064538Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE BELTFRAME CRACKED AT BS 947, STR 18L. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR C2XA06TY074Frame · damagedTYS - DURING A CURRENT 2C INSPECTION THE DOOR STOP ATTACHMENT HOLE WAS MISDRILLED. MAINTENANCE REPAIRED THE HOLE BY REAMING THE HOLE TO .300 AND FABRICATING A BUSHION, DYE PEN THE AREA AND INSTALLED NEW BUSHION USING A PRESS FIT WITH FLANGE ON THE INTERNAL SUSDR QXEA200603376Frame · damagedC4 PDX - HOLE DAMAGE AT FRAME STATION X450.00 2 1/2" INBOARD OF STRINGER 23L. REPAIRED IAW RD 8-53-9367.SDR SWIA200617610Frame · crackedFS 280 LBL9 LOWER FRAME/EVIDENCE OF CRACKS ON FLOOR SUPPORT BEAM AND LBL9 I/B AND O/B 280 CLIPS ARE CRACKED, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED I/B AND O/B CLIPS AND FILLERS.SDR HNAA0600185Frame · corrodedFRAME LEG BETWEEN STR 31 AND 30 R/S AT X531 REPLACED DUE TO CORROSION.SDR HNAA0600173Frame · corrodedFRAME AT X510 BETWEEN STRINGER 31S AND 31P HAS BEEN REPLACED DUE TO CORROSION.SDR HNAA0600175Frame · corrodedFRAME LEG IS CORRODED BETWEEN STRINGERS 31 AND 32 AT X467 R/S. REPLACED LOWER FRAME SEGMENT.SDR HNAA0600176Frame · corrodedCORROSION TO FRAME LEGS AT X445 BETWEEN STRINGERS 26 THROUGH 31. REPLACED FRAME SECTION.SDR HNAA0600153Frame · corrodedFRAME LEGS BETWEEN STR 32 AND 26 ARE CORRODED AT 434. REPLACED FRAME SEGMENT.SDR HNAA0600152Frame · corrodedFRAME LEGS BETWEEN STRINGERS 24 THROUGH 31 ARE CORRODED. REPLACED FRAME SEGMENT.SDR HNAA0600140Frame · corrodedCENTER AISLE UNDER FLOOR FRAME LEG CORRODED BETWEEN STRINGERS 31 AND 32 AT FRAME 436. REMOVED AND REPLACED RIGHT HAND BOTTOM FRAME SEGMENT.SDR HNAA0600136Frame · corrodedCABIN UNDER FLOOR FORWARD SIDE OF FRAME LEG CORRODED AT X270 BETWEEN STRINGERS 27 28 R/S. REMOVED AFFECTED CHINE FRAME, INSTALLED CHINE FRAME, (NEW) IAW DRWG 5 85320210 85321385.SDR HNAA0600134Frame · corrodedCABIN UNDER FLOOR FRAME LEG IS CORRODED AT X436 BETWEEN STRINGERS 30 AND 31. REMOVED AND REPLACED RIGHT HAND BOTTOM FRAME SEGMENT AT STA X434 IAW DEHAVILLAND DRAWINGS 85330057 AND 85330012.SDR DLM88070438Frame · crackedSTA 1446 UPPER CANTED FRAME REPAIR - THREE CRACKS AT STA 1446 CANTED FRAME. PERMANENT REPAIR WAS PERFORMED IAW SRM 53-03 FIG 30 AS ORDERED BY EA 09-062073-12 REV C, OPN 0103.SDR 2006UALA02229Frame · crackedFWD CARGO PIT DOOR CUTOUT AFT FRAME CRACKED AT INBD RADIUS NEAR STRINGER S24R. MAJOR REPAIR: REMOVED AND REPLACED FORWARD CARGO PIT DOOR CUTOUT AFT FRAME. REFERENCE SRM 51-40-02 PG 1-30.SDR QXEA200603383Frame · corrodedPDX C4 - FRAME X649.897 AT FLOOR LEVEL Z111.5 AND Y28R (RT AFT CORNER OF UPPER CARGO AREA) HAS SMALL CHAFE MARK ON TOP FLANGE OF FRAME. REPAIRED IAW DHC-8-200 SRM 51-20-16, 51-20-36, 51-20-51 AND RD 8-53-9351.SDR SWAA064495Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT AFT CARGO DOOR CUTOUT, BS 794, STR 27R. REPAIRED FRAME SECTION PER SRM.SDR SWAA064470Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 297, RBL 55, WL 208. REPAIRED FRAME PER SRM.SDR 06FDEA04028Frame · damagedUPON REMOVAL OF WEB RT BETWEEN FS 12 AND FS 13 3 HOLES ARE ELONGATED DOUBLE DRILLED FLOOR LEVEL AT FS 13 REPAIRED FRAME AT FS 13 RT IAW A310SRM 53-12-13 FIG 201 SEE JPF FOR JOB TASK STEP.SDR 06FDEA04027Frame · damagedUPON REMOVAL OF WEB BETWEEN FS 12 - FS 13 FOUND 3 HOLES ELONGATED DOUBLE DRILLED FLOOR LEVEL LT SIDE AT FS 13 REPAIRED FRAME AT FS-13, IAW A310 SRM 53-12-31 FIG 201 SEE JPF FOR JOB TASK STEPS.SDR USAA200701003Frame · crackedCRACK AT LBL 380, FRAME 1 INCH BELOW S14L. REMOVED DAMAGE, INSTALLED FILLER & 11 INCH DOUBLER PER EA 98280.SDR 2006UALA02211Frame · crackedRH WHEEL WELL BS 695 FRAME INNER CHORD ANGLE CRACKED JUST ABOVE AND AFT OF MLG UPLOCK MECHANISM. MAJOR REPAIR: INSTALLED REPLACEMENT FRAME ANGLE. REFERENCE SRM 51-40-02 AND MM 53-10-98 PG 1-3.SDR TRAX200601038Frame · crackedRIGHT FS 640 FRAME IS CRACKED. REPAIRED DAMAGE TO RT FS 640 FRAME IAW SB 601R-53-061.SDR TRAX200601037Frame · crackedLEFT FS 640 FRAME IS CRACKED. REPAIRED DAMAGE TO LT FS640 FRAME IAW SB601R-53-061SDR SWAA064465Failsafe · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME FAIL-SAFE CHORD CRACKED AT BS 440, STR 27R. REPAIRED CHORD PER SRM.SDR SWAA064451Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 303.9, STR 16L. REPAIRED FRAME SECTION PER EA.SDR DJFA2006342Frame · crackedDURING A SCHEDULED MAINTENANCE VISIT, A 1 INCH CRACK WAS FOUND ON LT SIDE OF THE LIGHTNING HOLE AT FRAME 10 UNDER THE CENTER ISLE FLOOR AT THE GALLEY. REPAIRED FRAME 10 IAW SRM 51.71.11SDR KCSA061537Frame · crackedFUSELAGE FRAME WEB CUTOUT AREA IS CRACKED AT STA 960, STR 8L.SDR KCSA061536Frame · crackedFUSELAGE FRAME WEB CUTOUT AREA IS CRACKED AT STA 960, STR 7R.SDR BAQA20060007Frame · crackedCRACK FOUND IN OVER HEAD FRAME. DETERMINED TO BE MINOR REPAIR. REPAIRED BY INSTALLING DOUBLERS IAW AC 43.13-1B MM.
Back to JASC 5311