Boeing 737-8Q8
Service difficulty reports · 1,686
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 = '7378Q8' 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 = '7378Q8' 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 ASMF201310003Control Cable · out of adjustAIRCRAFT RETURNED TO PLATFORM, DURING FLIGHT AILERONS CONTROLS TEST, THE RT SPOILER DID NOT RETURN TO NEUTRAL POSITION. MAINTENANCE PERFORMED FLIGHT CONTROL TEST, CONFIRMING THAT THE RIGHT SPOILER DID NOT RETURN TO NEUTRAL POSITION IAW AMM 27-61-00. THE RUDDSDR SCNA20131011178Strap · corrodedAFT CARGO LT NR 3 FLOOR STRAP CORRODED PANEL RACK. FABRICATED NEW AFT CARGO LT NR 3 FLOOR STRAP.SDR SCNA20131004155Frame · chafedFRAME AT BS 500E FREE FLANGE CHAFED AND ONE SOLID FASTENER CHAFED BETWEEN STRINGERS 15 & 17L. BLENDED CHAFE, AND FOUND TO BE OUT OF LIMITS. REPAIRED FRAME.SDR SCNA20131004151Floor Panel · puncturedAFT CARGO BAY FLOOR PANEL HAS A PUNCTURE APPROX 5 INCHES FWD OF BS 727E. R & R FLOOR PANEL.SDR SCNA20131001135Attach Fitting · corrodedL-1 DOOR SLIDE GIRT BAR FWD FLOOR ATTACH FITTING CORRODED. R & R FITTING.SDR SCNA20131001134Seat Track · gougedCABIN LBL 45.5 SEAT TRACK STA 897 HAS GOUGED SPOT AROUND SCREW HOLE LOWER SIDE. REPAIRED DAMAGE.SDR SCNA20131005167Web · corrodedCABIN FLOOR LT MOP SILL WEB HAS A CORROSION SPOT ON TOP SIDE AT BS 986-967. REMOVED, FABRICATED & REPLACED WEB.SDR SCNA20131005168Skin · damagedAPU BAY DAMAGE ON SKIN. REPAIRED DAMAGE ON SKIN LT IAW EO 15345.SDR SCNA20131005166Mount · damagedTOOL DAMAGE IN APU COMPARTMENT LT AFT MOUNT. REPAIRED DAMAGE ON LT AFT APU MOUNT IAW EO 15345.SDR SCNA20131004153Sill · corrodedCABIN FLOOR RT MOP SILL SECTION BETWEEN BS 294.5 TO 344 CORRODED IN SEVERAL AREAS, R & R.SDR SCNA20131007170Floorbeam · corrodedAFT WET AREA BS 967 FLOORBEAM HAS SEVERAL CORROSION & BARE METAL AREAS. REPAIRED FLOORBEAM IAW EA 15322.SDR SCNA20131005164Floorbeam · corrodedAFT WET AREA BS 986.5 FLOORBEAM HAS SEVERAL CORROSION AREAS ON TOP AND LOWER SIDES. REPAIRED FLOORBEAM AT FS 986.5 IAW EA 15341.SDR SCNA20131004161Support Frame · corrodedAFT WET AREA LBL 31 SUPPORT FRAME HAS CORROSION AT BS 992. FABRICATED, LOCATED & DRILLED NEW SUPPORT FRAME.SDR SCNA20131004160Floor Support · crackedCABIN FLOOR SUPPORT BS 312 - 328, RBL 31 IS CRACKED. FABRICATED FLOOR SUPPORT.SDR SCNA20131002149Frame · chafedFUSELAGE LT FRAME BS 727A HAS A CHAFED SPOT, APPROXIMATELY 2 INCHES ABOVE FLOOR. BLENDED FRAME AND FOUND TO BE OUT OF LIMITS. REPAIRED IAW EA 15339.SDR SCNA20131001140Floor Support · corrodedCABIN FLOOR SUPPORT BS 312-328, LBL 12 CORRODED. REPLACED FLOOR SUPPORT.SDR SCNA20131007172Sill · corrodedAFT WET AREA MOP SILL SECTION BETWEEN BS 947 TO 986 HAS SEVERAL CORROSION AREAS, EXTENDED TO UNDER R2 DOOR CUTOUT SCUP PLATE. R & R SILL.SDR SCNA20131007171Sill · corrodedAFT WET AREA LT MOP SILL SECTION FROM BS 947.5 TO 992 HAS SEVERAL CORROSION AREAS. R & R AFT WET AREA MOP SILL.SDR SCNA20131004162Web · corrodedAFT WET AREA LT SEAL WEB HAS CORROSION SPOT AT BS 986 & LBL 31. R & R WEB.SDR SCNA20131004154Transition Panel · corrodedAFT CARGO BAY TRANSITION PANEL LOWER SURFACE CORRODED BS 767-787 FWD OF CARGO DOOR. REMOVED & INSTALLED TRANSITION PANEL FROM STA 767-787.SDR SCNA20131005165Floorbeam · corrodedCABIN FLOORBEAM, BS 328 HAS CORROSION AREA AT RBL 23. REPAIRED DAMAGE SECTION OF FLOORBEAM.SDR SCNA20131004152Door Frame · corrodedR1 DOOR FRAME UNDER SCUP PLATE CORRODED, R & R.SDR SCNA20131002146Floorbeam · corrodedFLOORBEAM BS 344 HAS CORROSION AT RBL 3. FABRICATED REPAIR STRAP FOR CABIN FLOORBEAM.SDR SCNA20131001143Angle · corrodedFWD CARGO BAY RIGHT TRANSITION ANGLE CORRODED BS 492.4 TO 500A. REMOVED, FABRICATED & REPLACED.SDR SCNA20131005163Angle · corrodedFWD CARGO LT TRANSITION ANGLE CORRODED FS 460 TO FS 500I. R & R LT TRANSITION ANGLE.SDR SCNA20131004150Angle · corrodedFWD CARGO BAY RT TRANSITION ANGLE CORRODED, FS 500A - 500I. REMOVED, FABRICATED REPLACEMENT TRANSITION ANGLE & INSTALLED.SDR ASMF201308010Blade · damagedDURING TRANSIT CHECK, MX PERSONNEL DETECTED FOD DAMAGED ON 2 FAN BLADES OF THE RT ENGINE. MX PERSONNEL PERFORMED A FOREIGN OBJECT DAMAGE INSPECTION IAW MM TASK 71-00-00-800-802-F00, DETECTING 2 FAN BLADES DAMAGED, 1 OUTLET GUIDE VANE CRACKED AND INNER BARREL SDR SCNA20130516104Frame · gougedLEFT FUSELAGE STA 500B FRAME HAS A GOUGED SPOT APPROX 12 IN ABOVE FLOOR. REPAIRED LT FUSELAGE FRAME STA 500B APPROX 12" ABOVE FLOOR.SDR SCNA20130516103Sill · corrodedAFT WET AREA AFT FLOOR SILL WEB UPPER SURFACE HAS SEVERAL CORROSION SPOTS. REPAIRED AFT SILL WEB.SDR SCNA20130514099Floor Support · corrodedAFT CARGO BAY RIGHT FLOORBEAM AT FRAME 794.3 TO 847 CORRODED. REMOVED AND REPLACED FRAME FROM 777 TO 859.SDR SCNA20130514101Floor Support · corrodedAFT WET AREA RBL32 FLOOR SUPPORT FRAME STA 992.8 - 1016 HAS SEVERAL CORROSION SPOTS AROUND SCREW HOLE TOP UPPER AND LOWER SURFACES. REMOVED AND REPLACED FLOOR SUPPORT STA 992.8 - 1016 LBL32 AFT WET AREA.SDR SCNA20130514100Baffle · corrodedFORWARD PIT BAFFLE CORRODED ON O/B SIDE AT S-27L AND STA 500H. REMOVED AND REPLACED BAFFLE AT STR-27L STA 500H.SDR SCNA20130513098Intercostal · crackedFOUND INTERCOSTAL BETWEEN BS 500F - 500G CRACKED AT STRINGER. REMOVED AND REPLACED INTERCOSTAL.SDR SCNA20130513096Floor Support · corrodedWET AREA FLOOR SUPPORT FRAME STA 992.8 - 1016, LBL 32 HAS CORROSION SPOT ON UPPER SURFACE AND AROUND SEVERAL SCREW HOLES. REMOVED AND REPLACED FLOOR SUPPORT FRAME 992.8 - 1016 LBL 32.SDR SCNA20130513095Floorbeam · corrodedAFT CARGO BAY RIGHT FLOORBEAM AT FRAME 794.3 TO 847 CORRODED. REMOVED AND REPLACED FLOORBEAM.SDR SCNA20130513091Floorbeam · corrodedAFT WET AREA FLOORBEAM STA 986 SEVERAL CORROSION SPOTS AROUND SCREW HOLE TOP AND BOTTOM SIDES. T-CAP REPAIR. REPAIRED FLOORBEAM.SDR SCNA20130513090Bulkhead · crackedAFT BULKHEAD CRACKED BS 1016. REPAIRED AFT PRESSURE BULKHEAD.SDR SCNA20130513094Stringer Clip · crackedFORWARD PIT S-26L STRINGER CLIP CRACKED AT STA 500I. REMOVED AND REPLACED STRINGER CLIP AT STA 500I S-26L.SDR SCNA20130513093Stringer Clip · crackedFORWARD PIT S26R STRINGER CLIP CRACKED AT STA 500I. REMOVED AND REPLACED STRINGER CLIP AT STA 500I.SDR SCNA20130513089Support Bracket · crackedFWD CARGO BAY LEFT INTERCOSTAL FWD SUPPORT BRACKET CRACKED AFT OF STA 500G AT LBL21. REMOVED CRACKED SUPPORT BRACKET. INSTALLED NEW SUPPORT BRACKET.SDR SCNA20130513088Support Bracket · crackedFORWARD CARGO BAY LEFT INTERCOSTAL AFT SUPPORT BRACKET CRACKED FORWARD SIDE OF STA 500H AT LBL21. REMOVED CRACKED SUPPORT BRACKET. INSTALLED NEW BRACKET.SDR SCNA20130513092Floor Support · corrodedAFT WET AREA RBL 24 FLOOR SUPPORT BEAM STA 947.5 - 967 HAS CORROSION ON TOP SURFACE. REMOVED AND REPLACED FLOOR SUPPORT BEAM 947.5 - 967.SDR SCNA20130510084Bracket · crackedFORWARD PIT BAFFLE BRACKET CORRODED AT STA 500H AND S-27L. REMOVED AND REPLACED BAFFLE BRACKET AT 500H AND S-27L.SDR SCNA20130510087Support Frame · corrodedAFT WET AREA RBL 49 SUPPORT FRAME STA 947.5-967 HAS CORROSION AREA. REMOVED SUPPORT AND INSTALLED NEW SUPPORT.SDR SCNA20130510086Stringer Clip · corrodedFWD PIT STR CLIP CORRODED AROUND FASTENERS AT STR 27R AND STA 500F. REMOVED AND REPLACED STRINGER CLIP AT STR 27R AND STA 500F.SDR SCNA20130510085Stringer Clip · corrodedIN FWD CARGO BAY, FOUND EXFOLIATION CORROSION ON STRINGER CLIP AT STA 500H STRINGER 27R. REMOVED AND REPLACED STRINGER CLIP AT STA 500H STRINGER 27R.SDR SCNA20130510083Support Bracket · crackedFORWARD CARGO BAY RIGHT INTERCOSTAL AFT SUPPORT BRACKET CRACKED FWD SIDE OF 500H RBL 21. REMOVED CRACKED AFT SUPPORT BRACKET AT STA 500H RBL 21. INSTALLED NEW SUPPORT BRACKET.SDR SCNA20130510082Bracket · crackedFORWARD PIT BAFFLE FWD BRACKET CRACKED AT S-26R AND 500H. REMOVED CRACKED BAFFLE AT S-26R AND 500H. INSTALLED NEW SUPPORT BRACKET.SDR SCNA20130510080Intercostal · crackedWHILE REMOVING TRANSITION ZEE ANGLE FOR REPAIR, FOUND INTERCOSTAL AT STRINGER 25L BETWEEN STATION 500H-500I TO BE CRACKED IN THE RADIUS. FABRICATED NEW INTERCOSTAL.SDR SCNA20130510079Support Angle · corrodedFORWARD CARGO COMPARTMENT LEFT FWD STA 500I S-25L, TRANSITION SUPPORT ANGLE FOR SIDEWALL/FLOOR PANELS IS CORRODED OVER A LARGE AREA. REPAIRED FWD PIT LEFT TRANSITION SUPPORT STA 500I S-25L.
Back to Boeing 737-8Q8