Boeing 737-4Q8
Service difficulty reports · 6,250
Newest first. General aviation reporting is voluntary.
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 aircraft_model_key = '7374Q8' 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 aircraft_model_key = '7374Q8' 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 ASAA2013052795125Cusp Web · corrodedCORRODED IN CUSP AREA, RT SIDE FROM 727E TO 727F CUSP WEB AT RT STA 727E TO 727F FOUND TO BE OUT OF LIMITS IAW SRM 53-60-13-1A 1-FIG 101. REMOVED, FABRICATED AND INSTALLED NEW WEB IAW SRM 51-40-02 AND 51-30-01-0G-0.SDR ASAA2013052795068Stringer Clip · bentAFT CARGO STRINGER CLIP BENT AT S 25L AND STA 727B. R & R STRINGER CLIP (TIE) IAW SRM 51-40-02-0G-0, PAR 7D.SDR ASAA2013052695412Floor Panel · gougedAFT CARGO BAY NR 3 FLOOR PANEL HAS DEEP GOUGES FULL LENGTH OF PANEL. ACFT GROUNDED. FABRICATED NEW PANEL IAW SRM 51-40-05-06-0.SDR ASAA2013052695330Floor Support · corrodedCABIN BS 360 - 390, RBL 57, FLOOR SUPPORT HAS CORRODED SPOT ON TOP SIDE. REMOVED, FABRICATED AND INSTALLED NEW FLOOR SUPPORT IAW SRM 51-40-02-0G-0 AND SRM 51-40-05.SDR ASAA2013052695278Skin · chafedRIGHT WING NR 4 SLAT LOWER SURFACE CHAFED ABOVE ACTUATOR. ACFT GROUNDED. REPAIRED CHAFE ON RT WING NR 4 SLAT IAW SRM 51-70-10 -2R0, REPAIR 4, PARA 20, PG 48.SDR ASAA2013052695277Floor Support · corrodedAFT GALLEY FLOOR SUPPORT WEB ANGLE RT, STA 986 IS CORRODED IN SERVERAL AREAS. REMOVED CORRODED FOUND TO BE OUT OF LIMITS IAW SRM 53-60-51-1A1, FIG 101. R & R FLOOR SUPPORTS IAW SRM 51-40-02.SDR ASAA2013052695262Web · corrodedAFT GALLEY FLOOR SUPPORT WEB BETWEEN BS 986-1006 IS CORRODED NUMEROUS AREAS. ACFT GROUNDED. REMOVED AND REPLACED WEB IAW SRM 51-40-02 AND SRM 51-40-05.SDR ASAA2013052695218Support Angle · crackedAFT CARGO BAY BS 847, S25R SUPPORT CLIP FOR FORMED INTERCOSTAL HAS DAMAGES AND EVIDENCE OF A CRACK IN RADIUS. ACFT GROUNDED. R & R WITH A NEW SUPPORT CLIP FOR FORMED INTERCOSTAL AT STA 847, STR 25R IAW SRM 51-40-02-0G 0.SDR ASAA2013052695211Floor Support · corrodedAFT GALLEY BS 986, LT FWD FLOOR FITTING FOR THE GALLEY IS CORRODED 30. ACFT GROUNDED. R & R FITTING IAW SRM 51-40-02.SDR ASAA2013052695208Intercostal · chafedAFT CARGO BAY BS 847, S-25R TWO ATTACHMENTS ARE CHAFING INTO FORMED INTERCOSTAL CAUSING EXTENSIVE DAMAGES. ACFT GROUNDED. R & R WITH A NEW INTERCOSTAL AT BS 847 ABOVE S25R IAW SRM 51-40-02-0G 0.SDR ASAA2013052695175Stiffener · corrodedAPU BAY STIFFENER FOR AIR INTAKE AT APROX BS 1121 IS CORRODED. ACFT GROUNDED. REMOVED CORRODED AND CHECKED LIMITS, FOUND STIFFENER OUT OF LIMITS IAW SRM 53-80-13-1A-2. R & R STIFFENER IAW SRM 51-40-02-0G-0.SDR ASAA2013052695126Support Angle · corrodedAFT ENTRY DOOR L2 LOWER MOP SILL SURROUND STA 928, S17L INBD SUPPORT ANGLE FOR SILL IS CORRODED. REMOVED OLD MOP SILL IAW SRM 51-40-02 DRILLED, COUNTERSANK NEW MOPS SILL IAW SRM 51-40-05 INSTALLED NEW MOP SEAL IAW SRM 51-40-02.SDR ASAA2013052695069Floorbeam · gougedGOUGE IN FLOOR SUPPORT APPROX BS 540 RT SIDE INSTALLED NEW COVER PLATE ON CHANNEL IAW SRM 51-40-02.SDR ASAA2013052515391Channel · corrodedCABIN FLOOR RT MOP SILL BS 294.5-344 HAS SEVERAL CORROSION SPOTS ON TOP SIDE. ACFT GROUNDED. R & R INNER CHORD IAW SRM 51-40-02, W 1", O .080", R .056", L 1", D .024".SDR ASAA2013052595464Floorbeam · corrodedFLOORBEAM, BS 344 CORROSION SPOT ON UPPER SIDE AT LBL 13. REMOVED CORROSION, FOUND OUT OF LIMITS IAW SRM 52-10-51-1A-1. REPAIRED FLOORBEAM TEE CAP IAW EA NR 400-53 EA-10605.SDR ASAA2013052595439Floorbeam · corrodedFLOORBEAM BS 344 CORROSION SPOT ON UPPER SIDE AT LBL 13. ACFT GROUNDED. REMOVED CORROSSION, FOUND OUT OF LIMITS IAW SRM 52-10-51-1A-1. REPAIRED FLOORBEAM TEE CAP IAW EA NR 400-53EA-10605SDR ASAA2013052595429Floorbeam · corrodedBS 986 FLOORBEAM HAS AREAS OF CORROSION MAINLY AROUND CLIP NUT HOLES. ACFT GROUNDED. R & R FLOORBEAM UPPER TEE IAW EA 400-53EA-10598.SDR ASAA2013052595408Skin · dentedLEFT FUSELAGE AT BS 228, SKIN HAS A PROTRUSION BELOW 24L. ACFT GROUNDED. C/W EA 400-53EA-10505, REV NEW DATE ISSUED 6-13-13.SDR ASAA2013052595387Floor Support · corrodedCABIN FLOOR SUPPORT STRUCTURE, BS 1006, RT ANGLE SUPPORT IS CORRODED. ACFT GROUNDED. REMOVED CORROSION, FOUND TO BE OUT OF LIMITS IAW SRM 53-60-51, FIG 101. R & R FLOOR SUPPORT ANGLE STRAP IAW SRM 51-40-02.SDR ASAA2013052595361Floor Panel · damagedCABIN FLOOR PANEL UNDER FWD LAV HAS DAMAGED AREA. ACFT GROUNDED. BONDED FLOOR PANEL IAW IAW SRM 53-00-50, PAR 30, PGS 1 & 2.SDR ASAA2013052595313Web · corrodedAFT GALLEY FLOOR SUPPORT WEB RT BETWEEN BS 986 - 1006 CORRODED. REMOVED CORROSION, FOUND TO BE OUT OF LIMITS IAW SRM 53-60-51, FIG 101. R & R RT SUPPORT WEB IAW SRM 51-40-02.SDR ASAA2013052595311Fitting · corrodedRIGHT AFT R2 SERVICE DOOR, AT MOP SILL DOOR CUTOUT, HAS CORROSION. R & R FITTING IAW SRM 51-40-02.SDR ASAA2013052595298Shim · corrodedFWD CABIN STA 329-344 261-10 FLOOR SUPPORT HAS CORROSION. ACFT GROUNDED. REMOVED CORROSION FROM FLOOR SUPPORT SHIM, NO ALLOWABLE LIMITS APPLICABLE. R & R SHIM IAW SRM 51-40-02-0G0 AND 51-30-01-0G0.SDR ASAA2013052595290Floorbeam · corrodedCABIN FLOORBEAM BS 947 CORRODED. R & R FLOORBEAM IAW EA NR 400-53EA-10551.SDR ASAA2013052595284Channel · corrodedCABIN FLOOR RT MOP SILL, STA 294.5 - 344 HAS SEVERAL CORROSION SPOTS ON TOP SIDE. ACFT GROUNDED. R & R INNER CHORD IAW SRM 51-40-02.SDR ASAA2013052595249Floorbeam · corrodedCABIN FLOORBEAM, BS 312 HAS SEVERAL CORRODED AREAS ON TOP SIDE. ACFT GROUNDED. REMOVED CORROSION, FOUND TO BE OUT OF ALLOWABLE LIMITS IAW SRM 51-10-02-0G 0 AND 53-10 51-1A-1. REPAIRED FLOORBEAM TEE IAW SRM 53-10-51-2.SDR ASAA2013052595222Floor Support · corrodedFWD CABIN BS 312-328, LBL10, FLOOR SUPPORT FRAME HAS CORRODED SPOT. ACFT GROUNDED. REMOVED CORROSION, FOUND TO BE OUT OF ALLOWABLE LIMITS IAW SRM 51-10-02-0G 0 AND 53-10 51-1A-1, FIG 101. R & R SUPPORT IAW SRM 51-40-02 -0G 0 AND DWG 65C33971.SDR ASAA2013052595216Drain Pan · corrodedFWD CABIN LT MOP SILL FROM BS 294.5 - 360 HAS SEVERAL CORROSION SPOTS. ACFT GROUNDED. REMOVED CORRODED FOUND TO BE OUT OF ALLOWABLE LIMITS IAW SRM 53-10-15-1A 1. R & R MOPSILL IAW SRM 51-40-02-0G 0 AND DWG 65-17688.SDR ASAA2013052595149Angle · corrodedRT MLG WHEEL WELL MANIFOLD ASSY LOWER AFT ANGLE IS CORRODED WITH BARE METAL, OUT OF LIMITS. REMOVED ANGLE FORMED NEW ANGLE HEAT TREATED, LOCATED, DRILLED, ALODINED, PRIMED, TOPCOATED AND INSTALLED IAW SRM 51 40-02-0G-0, DETAIL I, 51-30-01-0G-0, 51-40-05-0G-0SDR ASAA2013052595138Sill · corrodedAFT ENTRY DOOR L2 LOWER MOP SILL SURROUND AT CUTOUT BS 928 S17L FWD FITTING FOR DOOR IS CORRODED. R & R FITTING IAW SRM 51-40-02.SDR ASAA2013052595127Web · corrodedAFT GALLEY FLOOR WEB, LT BETWEEN STA 986-1006 IS CORRODED NUMEROUS AREAS. R & R WEB IAW SRM 51-40-02 AND SRM 51-40-05.SDR ASAA2013052595122Skin · dentedRIGHT FUSELAGE AT BS 505 SKIN IS DENTED STRINGER 23R. REPAIRED SKIN IAW SRM 53-00-01-2R-31.SDR ASAA2013052595061Crease Beam · corrodedCABIN FLOOR RT CREASE BEAM HAS CORROSION SPOT AT BS 380. ACFT GROUNDED. INSTALLED REPAIR ANGLES IAW SRM 51-70-12-0G-0, FIG 1.SDR ASAA2013052495437Skin · dentedNR 2 ENGINE INLET COWL INNER SKIN DENTED AT 6:30 O`CLOCK POSITION 5 FROM AFT EDGE. ACFT GROUNDED. REPAIRED NR 2 ENGINE INLET COWL INNER SKIN IAW EA 400-71EA-10607, REV NEW ISSUED 6/28/13.SDR ASAA2013052495204Sill · corrodedRT AFT GALLEY SERVICE DOOR R2 MOP SILL SUPPORT ANGLE HAS CORRODED ON AFT INBD, OTBD END. ACFT GROUNDED. REMOVED CORRODED FOUND TO BE OUT OF LIMITS IAW SRM 53-60-15, FIG 101. R & R RT R2 MOPSILL IAW SRM 51-40-02, W 4, O .071, R .027, L 7FT, D .044.SDR ASAA2013052315392Transition Panel · corrodedFWD CARGO COMP RT TRANSITION PANEL CORRODED IN SEVERAL AREAS FROM BS 500C TO 500G. ACFT GROUNDED. REMOVED CORROSION AND CHECKED LIMITS FOUND TO BE OUT OF LIMITS IAW SRM 53-30-53-1A-1, FIG 101. R & R TRANSITION PANEL IAW SRM 51-40-02-0G-0, W 2. O .040, R .033SDR ASAA2013052395306Shear Tie · corrodedFWD CARGO BS 500D S26-27L FWD SIDE OF SHEAR TIE CORRODED. REPAIRED SHEAR TIE IAW SRM 53-00-07-2R-3. THIS IS A CAT B REPAIR.SDR ASAA2013052395413Skin · dentedRIGHT FUSELAGE BS 418, SKIN HAS A PROTRUSION 2 INCHES ABOVE S27R. ACFT GROUNDED. REPAIRED DENT IAW EA 400-53EA-10552, REV NEW DATE ISSUED 6-21-13.SDR ASAA2013052395409Skin · dentedRT FUSELAGE, BS 202, SKIN IS DENTED 9 INCHES FROM FWD ACCY BAY CUTOUT. ACFT GROUNDED. C/W EA 400-53EA-10508, REV NEW DATE ISSUED 6-13-13.SDR ASAA2013052395336Web · corrodedRT MLG WHEEL WELL WEB HAS CORRODED ON AFT OTBD SURFACE. R & R WEB IAW EA 400-53EA-10547.SDR ASAA2013052395326Transition Panel · corrodedFWD CARGO LT TRANSITION PANEL CORRODED IN SEVERAL AREAS FROM BS 500E TO 500G. REMOVED CORRODED FROM THE TRANSITION PANEL AND FOUND TO BE OUT OF LIMITS IAW SRM 53-30-53-1A-1, FIG 101. REMOVED FABRICATED NEW AND REPLACED THE TRANSITION PANEL IAW SRM 53-30-53-SDR ASAA2013052395287Support Beam · chafedNR 2 PYLON INBD FAN COWL SUPPORT BEAM CHORD CHAFED. REPAIRED NR 2 PYLON INBD FAN COWL SUPPORT BEAM CHORD IAW EA 400-54EA-10558.SDR ASAA2013052395285Support Beam · chafedNR 2 PYLON OTBD FAN COWL SUPPORT BEAM CHORD CHAFED. ACFT GROUNDED. REPAIRED NR 2 PYLON OTBD FAN COWL SUPPORT BEAM CHORD IAW EA 400-54EA-10558.SDR ASAA2013052395254Skin · dentedRT FUSELAGE, BS 413 SKIN IS DENTED 2 INCHES ABOVE 27R. REPAIRED DENT IAW EA 400-53EA-10552, REV NEW.SDR ASAA2013052395252Structure · corrodedLT WHEEL WELL MANIFOLD ASSY UPPER CHORD HAS BARE METAL AND CORROSION. ACFT GROUNDED. REMOVED LT WHEEL WELL MANIFOLD UPPER CHORD FABRICATED NEW CHORD TREATED, PRIMED TOPCOATED AND INSTALLED IAW SRM 51-30-01-0G-0, 51-40-02-0G-0 AND AMM 51-21 21-307-014 AND 51SDR ASAA2013052395248Skin · dentedRT FUSELAGE, BS 247 SKIN IS DENTED 2 INCHES ABOVE LAP SEAM. ACFT GROUNDED. REPAIRED SKIN IAW EA 400 53EA 10529 REV NEW.SDR ASAA2013052395229Skin · dentedRT FUSELAGE SKIN IS DENTED 3 INCHES BELOW EXTERNAL POWER DOOR CUTOUT. ACFT GROUNDED. REPAIRED SKIN IAW EA 400-53EA-10536.SDR ASAA2013052395226Skin · dentedRT FUSELAGE BS 193 SKIN IS DENTED LESS THAN 3 IN ABOVE 24R. ACFT GROUNDED. C/W EA-400-53EA, 10537 REV NEW.SDR ASAA2013052395217Skin · chafedRT WING OTBD BOOST PUMP CUTOUT LAND HAS CHAFING. ACFT GROUNDED. REPAIRED CHAFING IAW SRM 57-20-01-2R 6.SDR ASAA2013052395167Sill · corrodedAFT ENTRY DOOR L2 LOWER MOP SILL SURROUND AT CUTOUT STA 928 2A7L AFT FITTING FOR DOOR IS CORRODED. ACFT GROUNDED. R & R FITTING IAW SRM 51-40-02, W .5, O .300, R .190, L .5, D .112.
Back to Boeing 737-4Q8