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 SWAA062886Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME SECTION PER SRM.SDR SWAA062885Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME SECTION PER SRM.SDR SWAA062884Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 8R. REPAIRED FRAME SECTION PER SRM.SDR SWAA062883Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8R. REPAIRED FRAME SECTION PER SRM.SDR SWAA062882Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME SECTION PER SRM.SDR SWAA062881Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L AND 8R. REPAIRED FRAME SECTION PER SRM.SDR SWAA062880Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME SECTION PER SRM.SDR SWAA062879Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME SECTION PER SRM.SDR SWAA062875Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 8L. REPAIRED FRAME SECTION PER SRM.SDR SWAA062873Frame · corrodedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 993, RBL 47, WL 212. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR ASAA0640835Frame · crackedFRAME CRACKED AT STOP PAD FITTING. REPAIRED FRAME PER EA 5310 02653 AND ER 06 2544.SDR QXEA200602074Frame · corrodedPDX C4 AFT CARGO BAY FRAME WEB AND SUPPORT ANGLE AT FUSELAGE STATION X600, Y27LT AND 299.00 HAVE CORROSION ON SURFACE. REPAIRED IAW DHC-8-200 SRM 51-20-36, 51-70-11, 51-40-00 AND SRM 51-40-11.SDR SWAA062850Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 500, STR 27R AND STR 27L. REPAIRED FRAME SECTION PER SRM.SDR 06FDEA2842Frame · corrodedAIR CONDITIONING COMPT LT FOUND CORROSION WITH EXF ON FRAME AT STA 501 X= 30. REPAIRED FRAME IAW SRM 53-30-00 VOL 1 FIG 5 (REF SRM 53-00-01 VOL 1 FIG 8 ). FABRICATED PARTS IAW DETAIL PARTS TRAVELER I016366/N01366 & IAW SRM 53-30-00 VOL 1 FIG 5.SDR 06FDEA2841Frame · corrodedAIR CONDITIONING COMPT LT FOUND CORROSION WITH EXF ON FRAME AT STA 547 X= 30. REPAIRED FRAME IAW SRM 53-30-00 VOL 1 FIG 5 (REF SRM 53-00-01 VOL 1 FIG 8). FABRICATE PARTS IAW DETAIL PARTS TRAVELER I016354/N01354 & IAW SRM 53-30-00 VOL 1 FIG 5.SDR SWIA200617033Frame · crackedFUSELAGE FRAME AND CLEAT CRACKED ON CAPTAINS SIDE JUST BELOW DV WINDOW SUPPORT FRAME, DISCOVERED DURING C-CHECK INSPECTION. NEW FRAME INSTALLED IAW SRM 120 51-10-02 PG 3 SEC 3A.SDR HNAA0600097Beltframe · corrodedCORROSION FOUND ON BELL FRAME AT X167 UNDER FLIGHT COMPARTMENT. REPLACED FRAME.SDR PIDA06080Frame · crackedFRAME AT STA 867 CRACKED AT ATTACH BRACKET. REPAIRED FRAME PER SRM 53-00-07.SDR 06FDEA2832Frame · dentedFUSELAGE UPPER LOBE, FRAME IS DENTED, BS 520, 5 INCHES ABOVE STR 17R. REPAIRED FUSELAGE UPPER LOBE FRAME AT BS 520 5 INCHES ABOVE STR 17R IAW SRM 51-40-3.SDR 06FDEA2831Frame · dentedFUSELAGE UPPER LOBE, FRAME IS DENTED, BS 500, 5 INCHES ABOVE STR 17R. REPAIRED UPPER LOBE FRAME AT SB 500 5 INCHES ABOVE STR 17R IAW SRM 51-40-3.SDR SWAA062842Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 9L. REPAIRED FRAME SECTION PER SRM.SDR SWAA062835Frame · corrodedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 1006, RBL 46, WL 209. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA062827Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 639, STR 17R AND STR 17L. REPAIRED FRAME SECTION PER EA.SDR SWAA062826Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 21L. REPAIRED FRAME PER SRM.SDR 06FDEA2826Frame · corrodedFUSELAGE UPPER LOBE, CORROSION ON FRAME INNER AND OUTER FLANGE, AT BS 720A BETWEEN STR 1 TO STR 4 RT. REPAIRED FRAME PER SRM 53-10-4.SDR UPS06547781Frame · dentedINSPECTION TYPE:C DENT IN AFT CARGO FUSELAGE FRAME STA 1460 BET S26R TO S27R. REPAIR AT FRAME STA: 1460, BET S26R AND S27R HAS BEEN ACCOMPLISHED PER FINAL EA NR 757-5362-27-A1508 WITH NO DEVIATIONS AND UPS EO NR B757-53 10-24958-A, NOTE: ALL WORK STEPS ACCOMPSDR 2006UALA01508Frame · crackedFWD PIT FRAME AT BS 490 FWD SIDE CRACKED LOWER DOOR STOP FTG UPPER I/B ATTACH FASTENER MARKED WITH BLACK DOT AFT DOOR FRAME. MAJOR REPAIR: REMOVED DAMAGE, FABRICATED AND INSTALLED FILLER AND REPAIR PARTS.SDR PIDA06082Frame · crackedFRAME CRACKED AT STA 747 STR 9R. REPAIRED FRAME PER SRM 53-00-07.SDR PIDA06081Frame · crackedFRAME CRACKED AT STA 827 STR 9R. REPAIRED PER SRM 53-00-07.SDR SWAA062820Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 14R. REPAIRED FRAME SECTION PER SRM.SDR SWAA062812Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 9L. REPAIRED FRAME SECTION PER SRM.SDR SWAA062811Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 9L. REPAIRED FRAME SECTION PER SRM.SDR SWAA062802Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 188, STR 17L. REPAIRED FRAME SECTION PER SRM.SDR SWAA062797Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 639, STR 17L. REPAIRED FRAME SECTION PER MM.SDR ASAA0640830Frame · crackedFOUND CRACKED FRAME WEB. REMOVED AND REPLACED FRAME PER SRM 51 40 02.SDR UPS06847739Fitting · corrodedINSPECTION TYPE:C2 FRAME FITTING AT STA 1420 UPPER CUSP RT SIDE IS CORRODED OUT OF LIMITS. REMOVED FRAME FITTING AT STA 1420 RT CUSP IAW SRM 51-3-0. FABRICATED AND INSTALLED FITTING AT STA 1420 RT CUSP IAW SRM 51-3-2-0 AND SRM 51-03-00-0.SDR UPS06847738Frame · crackedINSPECTION TYPE:C2 CRACK ON AFT FRAME OF TYPE 1 DOOR AT CUSP STA 418 RT. REMOVED DAMAGED SECTION OF FRAME AT STA 418 RT CUSP IAW SRM 51-03-00-0. FABRICATED AND INSTALLED REPAIR ANGLES AT STA 418 RT CUSP IAW SRM 51-1-20D, DWG 46417934.SDR WRLA2006045Frame · corrodedITEM: DURING "C" CHECK IN GSO FOUND LEFT WHEEL WELL STA 1510 FRAME CORRODED ON LOWER LEG. FORMED NEW FRAME IAW DAC DWG AEA7165 REV K. INSTALLED NEW FRAME SECTION IAW SRM 53-00-01 VOL I.SDR 2006UALA01499Frame · crackedFWD CARGO DOOR CUTOUT AFT SIDE HAS A CRACK INDICATION ON FRAME AT UPPER I/B CORNER OF LOWER DOOR STOP. *S/D* MAJOR REPAIR: REMOVED DAMAGE WEB AND FITTING. INSTALLED REPAIR ANGLES.SDR PIDA06078Frame · crackedFRAME CRACKED STA 747 AT ATTACH BRKT STR 9L. REPAIRED FRAME PER SRM 53-00-07.SDR 06FDEA2769Frame · dentedMAIN DECK CARGO - MAIN FRAME AT STA 1721 LONGERON 12L FOUND WITH DENT AFA0019-3. CARRIED OUT REPAIR PER SRM 53-70-00 FIGURE 1. REPAIR IS CLASSIFIED AS MAJOR PER GMM 6-2-100.SDR SWAA062785Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 13L. REPAIRED FRAME SECTION PER SRM.SDR SWAA062783Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 616, RBL 65 AND LBL 65. REPAIRED FRAME PER BOEING SB.SDR SWAA062778Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 9L. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA062777Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 9R. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA062776Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 9R. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA062775Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 9R. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA062774Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 9R AND STR 9L. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA062773Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 9R. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA062772Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 9R AND STR 9L. REMOVED AND REPLACED FRAME SECTION PER SRM.
Back to JASC 5311