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 SWAA062555Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 20L. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR ASAA0640785Frame · crackedFOUND CRACK IN FRAME. REMOVED DAMAGE IN FRAME FABRICATED REPAIR PARTS AND INSTALLED PER SRM 53 00 07.SDR QXEA200601978Frame · tool damagePDX C3 FUSELAGE BELLY FRAME HAS DRILL START/MARK AT STATION X18.250 AND STRINGER 31P. REPAIRED IAW RD 8/4-53-1619 AND HORIZON AIR EA 6-53-778.SDR QXEA200601977Frame · dentedPDX C3 FRAME DENTED AT 18.250, STRINGER 31L, REPAIRED IAW HORIZON AIR EA 6-53-778, RD 8/4-53-1619.SDR SWAA062549Frame · corrodedDURING SCHEDULED 10Y CHECK, FOUND AFT STUB FRAME ZEE ANGLE CORRODED AT BS 947.5, STR 13L. REMOVED AND REPLACED STUB FRAME ZEE ANGLE PER SRM.SDR SWAA062548Frame · corrodedDURING SCHEDULED 10Y CHECK, FOUND AFT STUB FRAME ZEE ANGLE CORRODED AT BS 947.5, STR 13R. REMOVED AND REPLACED STUB FRAME ZEE ANGLE PER SRM.SDR SWAA062537Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 14L. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA062536Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 348, STR 15L. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR 2006UALA01424Frame · chafedSTA 1040 LBL 7 HOLE WORN THROUGH FRAME DUE TO CONTACT WITH APU PNEUMATIC DUCT CLAMP. MAJOR REPAIR: REMOVED DAMAGE. FABRICATED AND INSTALLED REPAIR.SDR 06FDEA2613Frame · crackedMAIN CABIN AT STA 1741 L13 RT SIDE ON FRAME FOUND CRACK 5 INCHES LONG. CUTTED FRAME SECTION BETWEEN LONG 10 AND 11 LT SIDE AND SPLICE INSTALLED NEW SECTION IAW SRM 53-30-00 FIG 5 VOL 1, FABRICATED PART IAW DETAIL PART TRAVELER F176558- 3 FWD CHANNEL F176556-5SDR 06FDEA2606Frame · crackedMAIN CABIN AT STA 1781 L13 LT SIDE ON FRAME FOUND CRACK 5 INCHES LONG. CUT FRAME SECTION BETWEEN LONGERONS 10 AND 11 LT SIDE AND SPLICE INSTALLED NEW SECTION IAW SRM 53-00-00 FIG 51 VOL 1. FABRICATED PART IAW DETAIL PARTS TRAVELER F176555-3 FWD CHANNEL F1765SDR 06FDEA2603Frame · damagedINTERNAL FUSELAGE AT STA 285 Z=30 APPROX LT SIDE FRAME REPAIR. REMOVED EXISTING CAP REPAIR, TRIMMED OUT AND INSTALLED NEW CAP, FABRICATED PART IAW DETAIL PART TRAVELER N02459 AND SRM 53-40-00 FIG 15 SHT 4 VOL 1.SDR SWAA062520Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 294.3, STR 4L. REPAIRED FRAME SECTION PER SRM.SDR CA060723004Frame · corroded(CAN) SKIN TO FRAME ATTACH ANGLE CORRODED NR BS 520, STR 27R TO 28R (TC NR20060723004)SDR CA060723003Frame · corroded(CAN) FWD CARGO PIT FRAME CORRODED AT BS 500C AND STR 28R TO 28L (TC NR 20060723003)SDR CA060723002Frame · corroded(CAN) FWD CARGO PIT FRAME TO SKIN AT BS500C CORRODED STR 27R TO 28R (TC NR 20060723002).SDR CA060723001Frame · corroded(CAN) FWD CARGO PIT FRAME TO SKIN AT BS 500B CORRODED BETWEEN STR 28R AND 28L (TC NR 20060723001).SDR HALA0600595Frame · corrodedCORROSION AFT CARGO BAY TOP FLANGE OF FRAME UNDER NUT PLATE BS 1219, RBL 42, WL 125. REMOVED CORROSION AT BS 1219, RBL 42, WL 125, FOUND TO BE OUT OF LIMITS IAW SRM 53-00-07-1A-1. REMOVED HANDLING SYSTEM ROLLER TRAY TO GAIN ACCESS IAW SRM 51-40-02, REMOVED FSDR HALA0600553Frame · corrodedCORROSION AFT CARGO BAY TOP FLANGE OF FRAME UNDER NUT PLATE BS 1197+110, LBL 42, WL 125. REMOVED AND REPLACED TOP FLANGE CHORD ON FRAME AT BS 1197+110 LBL 44 TO RBL 44 WL 125 IAW B767 SPM 51-40-02.SDR HALA0600552Frame · corrodedCORROSION, AFT CARGO BAY TOP FLANGE OF FRAME UNDER NUT PLATE BS 1197+132 LBL 42, WL 125. REMOVED UPPER CHORD BEAM/FLOOR SUPPORT ANGLE ON FRAME AT BS 1197+132 44 LBL 44 RBL. INSTALLED NEW UPPER CHORD ON FRAME AT WL 125 IAW B767 SRM 51-40-02.SDR 06FDEA2600Frame · dentedFOUND STA 380 STR 21 RT FRAME INBOARD FLANGE DENTED. REPAIRED DENT AT BS 380 STR 21R IAW SRM 51-40-3.SDR 06FDEA2597Frame · dentedDENT ON I/B FRAME FLANGE BS 970 LT AT STR 26L IN AFT CARGO BAY. *S/D* REPAIRED DENT ON I/B FRAME FLANGE BS 970 STR 26L IAW SRM 51-40-3.SDR 06FDEA2596Frame · dentedDENT ON I/B FRAME FLANGE BS 970 LT BETWEEN STR 23L AND STR 24L IN AFT CARGO BAY. *S/D* REPAIRED DENT ON I/B FRAME FLANGE BS 970 BETWEEN STR 23L AND 24L IAW SRM 51-40-3.SDR 06FDEA2595Frame · dentedDENT ON INBOARD FRAME AT BS 990 LEFT AT STR 26L IN AFT CARGO BAY. *S/D* REPAIRED DENT IN FRAME BS 990 STR 26L IAW SRM 51-40-3.SDR 06FDEA2594Frame · dentedDENT ON INBOARD FRAME AT BS 1010 LT AT STR 26L IN AFT CARGO BAY.SDR SWAA062494Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 9R. REPAIRED FRAME SECTION PER SRM.SDR SWAA062487Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND STUB FRAME CRACKED AT FWD SIDE UPPER CORNER BS 296, STR 7R. REMOVED AND REPLACED STUB FRAME SECTION PER SRM.SDR USAA060903Frame · crackedFOUND CRACK BS 747 STR 9R. INSTALLED REPAIR DOUBLERS IAW TR 53-10-20D, DEFECT SIZE: .250".SDR USAA060904Frame · crackedFOUND FRAME CRACKED BS 500C, BETWEEN S-8R AND S-9R. CUTOUT CRACKED AREA, AND DRILLED UP AND INSTALLED NEW REPAIR ANGLES IAW SRM 53-10-20D, DEFECT SIZE: .50".SDR SWAA062462Frame Splice · corrodedDURING SCHEDULED 20Y CHECK, FOUND AFT PRESSURE BULKHEAD CHORD SPLICE CORRODED AT BS 1016, STR 26R. REMOVED AND REPLACED BULKHEAD SPLICE PER SRM.SDR UPS06447681Frame · crackedINSPECTION TYPE:C FX BS340 FRAME FOUND 1 HOLE CRACK AT S6R LOCATION APPROX 0.030" LONG, CRACK LENGTH 0.030". FX BS 340 STR 6R AREA FRAME REPAIRED AS PER RS R53-15-35543 ITEM B AND UPS ENGINEERING FILE NR 747-53-20319.SDR 2006UALA01403Frame · crackedFRAME CRACKED ON RAIL SUPPORT AT STA 380 & 440 AT S8R. MAJOR REPAIR: REMOVED DAMAGE. FABRICATED AND INSTALLED REPAIR PARTS.SDR 06FDEA2566Frame · dentedDENT ON I/B FRAME FLANGE BS 950F LT BETWEEN STR 23L AND STR 24L IN AFT CARGO BAY. REPAIRED DENT IN FRAME IAW SRM 51-30-5SDR 06FDEA2565Frame · dentedDENT ON I/B FRAME FLANGE BS 950F LT BETWEEN STR 25L AND STR 26L IN AFT CARGO BAY. REPAIRED FRAME IAW SRM 51-30-5, 51-30-8, 51-10-2SDR USAA060887Frame · crackedFOUND CRACK BS 440 S-25R UNDER DOOR STOP FITTING. REMOVED DAMAGE, FABRICATED AND INSTALLED DOUBLER IAW EA 97882, DEFECT SIZE: .75.SDR UPS06447480Frame · crackedINSPECTION TYPE:C RT BLG W/W STA 1438 FRAME ATT HOLE FOUND CRACKED RBL 116 WL 156, CRACK LENGTH 3/8". RT BLG W/W BS 1438 RBL 116 WL 152 TO WL 165 FRAME REPAIRED AS PER SRM 51-40-03 FIG 2.SDR DL76S060585Frame · crackedTHE LT BS 903.5 FRAME HAS A CRACK IN THE LOWER END BETWEEN CHORD FLANGES. THE CRACKED AREA WAS REMOVED AND A REPAIR ANGLE WAS INSTALLED.SDR SWAA062446Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FWD CARGO DOOR CUTOUT UPPER FRAME CRACKED AT NR 5 DOOR STOP. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA062445Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FWD CARGO DOOR CUTOUT FWD FRAME CRACKED AT NR 5 DOOR STOP. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA062444Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND AFT CARGO DOOR CUTOUT FWD FRAME WEB CRACKED AT LOWER STOP FITTING. REMOVED AND REPLACED FRAME WEB SECTION PER SRM.SDR SWAA062442Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 807, STR 14L. REPAIRED FRAME SECTION PER SRM.SDR SWAA062441Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 767, STR 14L. REPAIRED FRAME SECTION PER SRM.SDR SWAA062440Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 348, STR 15L. REPAIRED FRAME SECTION PER SRM.SDR SWAA062430Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, LBL 6 TO RBL 6. REPAIRED FRAME SECTION PER SRM.SDR ASAA0640761Frame · dentedFOUND FWD CARGO COMPARTMENT UPPER FLANGE DENTED. REPAIRED FRAME PER SRM 51 70 11.SDR EIA2006114Frame · crackedFOUND CRACK, RT BS 600 FRAME WEB AT STRINGER 9. CRACKED FRAME WEB REPLACED IAW B747 SRM 53-10-04 FIG 4. DOUBLER USED 7075-T6 0.063".SDR UPS06847362Frame · crackedC2 D-PIT STA 1394 L34R FRAME IS CRACKED. REMOVED DAMAGED AREA. FABRICATED AND INSTALLED REPAIR ANGLES IAW 53-2-0 FIG 1F, 53-04-01-0 FIG 051, 51-01-21 AND 51-01-20D.SDR ABXA060202Frame · crackedWHILE ACCOMPLISHING A REPETITIVE EDDY CURRENT INSPECTION TO THE RIGHT OUTER CHORD AT BULKHEAD STA. 1809, SEVERAL CRACKS WERE CONFIRMED. REPAIRED RIGHT OUTER CHORD PER J.C.'S 53800002-001, 002, 003, AND W/O# 600251128.SDR SWAA062418Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 827, LBL4, WL 154. REPAIRED FRAME SECTION PER SRM.SDR SWAA062417Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME SECTION PER SRM.
Back to JASC 5311