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 ASAA1149802Cargo Track · corrodedAFT CARGO COMPARTMENT CENTER FLOOR SUPPORT AT RBL 14 HAS LIGHT CORROSION AROUND FASTENER HOLES BS 807 TO BS 947. REMOVED CORROSION AND FOUND OUT OF LIMITS IAW B737 400 SRM 53 60 53. REMOVED TRACK SECTION AND REPAIRED IAW ASA EA 400 53EA 05515.SDR ASAA1149796Panel · corrodedAFT CARGO DOOR FORWARD CUTOUT LOWER CLOSE OUT PANEL IS CORRODED. REMOVED CORROSION OUT OF LIMITS, FABRICATED AND INSTALLED REPAIR PARTS IAW B737 400 SRM 51 70 13 FIG 1.SDR ASAA1149784Trans Panel · corrodedAFT CARGO COMPARTMENT LEFT TRANSITION PANEL HAS CORROSION MULTIPE PLACES BS 807 TO BS 947. REMOVED TRANSITION PANEL, FABRICATED AND INSTALLED REPLACEMENT PART IAW B737 400 SRM 51 40 05 AND 51 40 02.SDR ASAA1149782Angle · corrodedAFT PIT TRANSITION "Z" ANGLE HAS CORROSION AT FASTENER HOLES BS 727 TO BS 767. BLENDED AREA FOUND OUT OF LIMITS, FABRICATED REPAIR PARTS IAW B737 400 SRM 51 40 05 AND 51 40 02.SDR ASAA1149799Frame · corrodedIN AFT PIT BS 727B STR 27R TO 26R FRAME IS CORRODED. REMOVED CORROSION FOUND OUT OF LIMITS. CUT OUT DAMAGED AREA, FABRICATED AND INSTALLED REPAIR PARTS IAW B737 400 SRM 53 00 07.SDR ASAA1149798Fitting · crackedAT BS 360 STR 11L STRINGER TO FRAME CLIP IS CRACKED IN RADIUS. REPLACED CLIP IAW ASA EA 400 53EA 0543.SDR ASAA1149797Attach Fitting · bentAFT CARGO COMPARTMENT BS 727A FRAME TO STRINGER 23R ATTACH CLIP IS BENT. REMOVED AND REPLACED CLIP IAW B737 400 SRM 51 40 02.SDR ASAA1149795Splice · corrodedAFT CARGO COMPARTMENT BS 727G REPAIR SPLICE IS CORRODED ABOVE STR 25L. REMOVED AND REPLACED REPAIR SPLICE IAW B737 400 SRM 53 60 07 FIG 1 AND 51 70 11 FIG 1.SDR ASAA1149794Support · corrodedAFT CARGO COMPARTMENT BS 727G LT SIDEDWALL SUPPORT IS CORRODED AROUND FASTENER HOLES BETWEEN STR 19L AND 25L. REMOVED CORROSION OUT OF LIMITS, FABRICATED AND INSTALLED REPLACEMENT PART IAW B737 400 SRM 51 40 02.SDR ASAA1149793Shear Tie · corrodedAFT CARGO COMPARTMENT BS 727C FRAME SHEAR TIE IS CORRODED BETWEEN STR 25L AND STR 26L. REMOVED CORROSION FOUND OUT OF LIMITS, FABRICATED AND INSTALLED REPLACEMENT PART IAW B737 400 SRM 51 70 11.SDR ASAA1149792Trans Panel · corrodedAFT PIT LT TRANSITION PANEL CORRODED BS 727F TO BS 807. REMOVED CORRODED PANEL, FABRICATED AND INSTALLED REPLACEMENT PART IAW B737 400 SRM 51 40 05.SDR ASAA1149791Shear Tie · corrodedSHEAR TIE CORRODED BS727A +15 RBL 2. REMOVED CORRODED SHEAR TIE, FABRICATED AND INSTALLED REPLACEMENT PART IAW B737 400 SRM 51 20 01 AND 51 40 02.SDR ASAA1149790Trans Panel · corrodedAFT PIT TRANSITION PANEL CORRODED SEVERAL AREAS BS 727 TO BS 727F. REMOVED CORRODED PANEL AND INSTALLED REPLACEMENT PART IAW B737 400 SRM 51 40 05.SDR ASAA1149783Shear Tie · corrodedSHEAR TIE AT BS 520 BETWEEN STR 28L AND 28R IS CORRODED. REMOVED DAMAGED PART FABRICATED REPLACEMENT AND INSTALLED IAW B737 400 SRM 51 40 02.SDR ASAA1149781Floor Support · corrodedAFT CARGO COMPARTMENT FLOORBOARD SUPPORT HAS CORROSION ON LOWER SIDE AT NUT PLATE BS 727F +7 RBL 2.5. TRIMMED OUT DAMAGE, FABRICATED REPAIR PARTS AND INSTALLED IAW ASA EA 400 53EA 05500.SDR ASAA1149780Floorbeam · corrodedTOP OF FLOORBEAM AT BS 360 CORRODED AT FASTENER HOLE LBL 10. REPAIRED FLOORBEAM IAW ASA EA 400 53EA 05459.SDR ASAA1149779Frame · crackedAFT PASSENGER CABIN BS 827 LT FRAME CRACKED AT PSU ATTACH BRACKET STR 8L. REPAIRED FRAME IAW ASA EA AD20062609 400 53 120.SDR ASAA1149778Frame · crackedAFT CABIN LT FUSELAGE FRAME BS 907 CRACKED AT PSU MOUNT ATTACH BRACKET STR 8L. REPAIRED FRAME IAW ASA EA AD20062609 400 53 120.SDR ASAA1149777Frame · crackedPASSENGER CABIN FRAME CRACKED BS480 STR 8R. REPAIRED FRAME IAW ASA EA AD20062609 400 53 120.SDR ASAA1149776Frame · crackedPASSENGER CABIN FRAME CRACKED BS 400 STR 8R. REPAIRED FRAME IAW ASA EA AD20062609 400 53 120.SDR ASAA1149775Frame · crackedRIGHT FRAME BS 787 CRACKED AT PSU MOUNT BRACKET STR 8R. REPAIRED FRAME IAW ASA EA AD20062609 400 53 120.SDR ASAA1149774Frame · crackedAFT CABIN LT FUSELAGE FRAME BS 787 CRACKED AT PSU MOUNT BRACKET STR 8L. REPAIRED FRAME IAW ASA EA AD20062609 400 53 120.SDR ASAA1149773Frame · crackedAFT PASSENGER CABIN BS 727F LT FRAME CRACKED AT PSU MOUNT ATTACH BRACKET STR 8L. REPAIRED FRAME IAW ASA EA AD20062609 400 53 120.SDR ASAA1149772Frame · crackedAFT PASSENGER CABIN BS 747 LT FRAME CRACKED AT PSU MOUNT ATTACH BRACKET STR 8L. REPAIRED FRAME IAW ASA EA AD20062609 400 53 120.SDR ASAA1149770Frame · crackedPASSENGER CABIN FRAME CRACKED AT BS 380 STR 8R. REPAIRED FRAME IAW ASA EA AD20062609 400 53 120.SDR ASAA1149704Floorbeam · corrodedFLOORBEAM STA 312 CORRODED BETWEEN LBL 12 TO RBL 12. REMOVED CORRODED UPPER CHORD, FABRICATED TREATED PRIMED TOP COATED AND INSTALLED NEW UPPER CHORD REPAIR IAW B737 400 SRM 53 10 51 FIG 201 REPAIR 5.SDR ASAA1149716Floor Support · corrodedFLOOR SUPPORT BETWEEN BEAMS AT BS 360 TO BS 380 CORRODED ON UPPER SURFACE AT RBL 12. REMOVED AND REPLACED FLOOR SUPPORT IAW B737 400 SRM 51 40 02.SDR ASAA1149705Floorbeam · corrodedFLOOR BEAM CORRODED STA 294 BETWEEN BL 0 AND RBL 12. REMOVED UPPER CHORD. FABRICATED TREATED PRIMED TOP COATED AND INSTALLED NEW UPPER CHORD IAW B737 400 SRM 53 10 51 FIG 201 REPAIR 5.SDR ASAA1149769Sill · corrodedAFT PIT LOWER SILL WEB CORRODED. REMOVED CORRODED WEB AND INSTALLED REPLACEMENT IAW B737 400 SRM 51 40 02.SDR ASAA1149768Skin · dentedRIGHT WING SPOILER NR 6 UPPER SURFACE HAS TWO EACH PROTRUSIONS ON OUTBOARD HALF APPROX 8 IN FROM TRAILING EDGE. REPAIRED SPOILER IAW B737 400 SRM 51 70 10.SDR ASAA1149608Intercostal · crackedCRACK FOUND IN E BAY INTERCOSTAL BS 344 TO BS 360 BL 0 WL 200. REMOVED AND REPLACED CRACKED INTERCOSTAL IAW B737 400 SRM 51 40 02, 51 40 05, 51 20 01.SDR ASAA1149607Strap · crackedFOUND STABILIZING STRAP IN E BAY BROKEN BS 312 BL 0 WL 200. REMOVED AND REPLACED STABILIZING STRAP IAW B737 400 SRM 51 40 02, 51 40 05, 51 20 01.SDR ASAA1149800Wedge · chafedRT WING LEADING EDGE SLAT LOWER TRAILING EDGE CHAFED. REPAIRED DAMAGED AREA OF SLAT TRAILING EDGE WEDGE IAW B737 400 SRM 51 70 10 REPAIR 4.SDR ASAA1149767Slat · delaminatedRIGHT WING LEADING EDGE SLAT NR 6 INBOARD AFT CORNER DELAMINATED. REPAIRED DAMAGED SLAT IAW B737 400 SRM 51 70 02 REPAIR 4.SDR ASAA1149766Slat · chafedRIGHT WING LEADING EDGE SLAT NR 5 INBOARD LOWER TRAILING EDGE CORNER CHAFED. REPAIRED DAMAGED SLAT IAW B737 400 SRM 51 70 02 REPAIR 4.SDR ASAA1149759Skin · delaminatedLEFT WING LEADING EDGE NR 3 SLAT INBOARD LOWER TRAILING EDGE CHAFED WITH DELAMINATION. BONDED REPAIR IAW SRM 51-70-10 REPAIR 4.SDR ASAA1149757Skin · delaminatedLEFT WING LEADING EDGE NR 3 SLAT OUTBOARD AFT CORNER DELAMINATED. BONDED REPAIR IAW SRM 51-70-10 REPAIR 4.SDR ASAA1149756Skin · delaminatedLEFT WING LEADING EDGE SLAT NR 2 INBOARD AFT CORNER DELAMINATED IN TWO PLACES. BONDED REPAIR IAW SRM 51-70-10 REPAIR 4.SDR ASAA1149755Skin · delaminatedLEFT WING LEADING EDGE SLAT NR 2 OUTBOARD AFT CORNER DELAMINATED. BONDED REPAIR IAW SRM 51-70-10 REPAIR 4.SDR ASAA1149572Battery · dischargedRT INTERIOR OVERWING EXIT EMERGENCY EXIT LIGHT INOP. REPLACED BATTERY IN CHARGER M1468 CHECKS GOOD REF MM 33 51 02.SDR ASAA1149753Strap · crackedE&E BAY CABIN FLOOR SUPPORT STRAP CRACKED AT BS 328 LBL 46. STOP DRILLED CRACK AND INSTALLED REPAIR PLATE IAW SRM 53-10-51.SDR ASAA1149573Guide Arm · wornL2 DOOR DOES NOT CLOSE PROPERLY. REMOVED AND REPLACED L2 DOOR SNUBBER PER AMM 52 13 17. DOOR STILL CHECKS BAD. L2 DOOR UPPER GUIDE ARM WORN REPLACED GUIDE ARM REF AMM 52 13 13.SDR ASAA1149560Guide Arm · out of adjustFORWARD ENTRY DOOR L1 WILL NOT CLOSE. THE FLAP ON THE TOP IS NOT GOING INTO PLACE PROPERLY. FOUND AFT LATCH ROLLERS NOT ENGAGING LATCH FITTINGS DUE TO AFT DOOR EDGE LAGGING FORWARD EDGE. ADJUSTED GUIDE ARM IAW B737 400 AMM 52 11 00.SDR ASAA1149556Snubber · malfunctionedL1 DOOR SNUBBER DOES NOT SEEM TO ENGAGE DURING DOOR OPENING OR CLOSING. REMOVED AND REPLACED SNUBBER IAW B737 400 AMM 52 11 71. OPS NORMAL.SDR BJNA110401Battery · inoperativeAFT F/A FLASHLIGHT INOPERATIVE. R & R AFT F/A FLASHLIGHT BATTERY IAW AMM 25-64-6.SDR ASAA1149723Bushing · galledLEFT FORWARD VERTICAL STABILIZER BOLT FORWARD ATTACH LUG BUSHING IS GALLED. REPAIRED BUSHING PER ASA EA 400 55EA 05422.SDR ASAA1149553Housing · corrodedR2 DOOR HANDLE MECHANISM HOUSING ASSEMBLY CAM SHAFT BEARING HOUSING CORRODED. REMOVED CORRODED HOUSING AND INSTALLED REPLACEMENT PART IAW BOEING CMM 52 46 05.SDR ASAA1149369Slide · out of adjustL2 (AFT ENTRY DOOR) SLIDE POSITION NEEDS ADJUSTMENT. GIRT BAR DRAGS AND BINDS. REPOSITIONED L2 SLIDE PER B737 400 AMM 25 61 35.SDR ASAA1149554Stringer · damagedMAIN CABIN BS 368 STR 14L HAS EXISTING PILOT HOLE THRU STRINGER ONLY. REMOVED DAMAGED STRINGER AND INSTALLED REPLACEMENT PART IAW B737 400 SRM 53 30 03 FIG 201.SDR ASAA1149353Plate · looseR1 (FORWARD GALLEY SERVICE DOOR) HARD TO CLOSE FOUND UPPER HINGE LOWER CAM PLATE ATTACH BOLTS LOOSE. TIGHTEN BOLTS. DOOR OPS CHECKS OK PER B737 400 AMM 52 41 00 705 001 1.
Back to Boeing 737-4Q8