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 SCNA20141020144Lamp · inoperativeFOUND R1 EXTERIOR EMERGENCY LIGHT INOPERATIVE, REPLACED THE LAMP.SDR SCNA20140501046Engine · failedDURING CLIMBOUT, A LOUD BANG AND FLASH, NR 2 ENGINE FAILURE. RETURNED TO DEPARTURE.SDR SCNA20140326045Switch · stuckLANDING GEAR WOULD NOT RETRACT AFTER TAKEOFF. ACCOMPLISHED FIM TASK & FOUND SWITCH S1060 STUCK IN DOOR OPEN POSITION WITH MANUAL EXT DOOR CLOSED. REPLACED S1060 & PERFORMED GEAR SWING. CHECKS GOOD.SDR SCNA20140320044Battery Pack · inoperativeFOUND LT AND RT BATTERY PACKS AT STATION 727, FORWARD OF LT AND RT FORWARD ESCAPE HATCHES AND BATTERY PACKS THAT CONTROL THE LIGHT AROUND THE FORWARD ENTRY & SERVICE DOORS FAILED THE TEST.SDR SCNA20140107001Life Raft · damagedDURING CABIN INSPECTION, FOUND LACING ON LIFE RAFT POPPED. R & R LIFE RAFT.SDR SCNA20131219234Cover · missingEMERGENCY LIGHT COVER MISSING. R & R COVER.SDR ASMF201311223001Bleed Valve · leakingDURING TRANSIT CHECK, IT WAS DETECTED A FUEL LEAK IN THE RT ENG WITH 50 DROPS PER MINUTE. MX PERSONNEL DETECTED TRANSIENT BLEED VLV WITH LEAK WITHIN OPERATION LIMITS IAW MM 71-71-00 PAGE 6, DISPATCHING THE ACFT IN SUCH CONDITION. AT GDL, MX PERSONNEL REPLACSDR SCNA20141020143Battery Pack · inoperativePOSITION NR 3 EMERGENCY BATTERY PACK INOPERATIVE. R & R NR 3 POSITION BATTERY PACK.SDR SCNA20141020142Battery Pack · inoperativePOSITION NR 1 BATTERY PACK FOR EMERGENCY LIGHTS INOPERATIVE. R & R NR 1 EMERGENCY BATTERY PACK.SDR SCNA20131022180Battery Pack · inoperativeEMERGENCY LIGHT INOPERATIVE. R & R THE EMERGENCY LIGHT POWER SUPPLY BATTERY PACK M1694 IAW AMM 33-51-06 BATTERY PACK TEST SATISFACTORY. R & R THE LT FORWARD OVERWING EXTERIOR EMERGENCY LIGHT LAMP.SDR SCNA20131004158Intercostal · crackedFWD CARGO BAY LT INTERCOSTAL CRACKED BETWEEN BS 500-500A. R & R INTERCOSTAL.SDR ASMF201311080001Door · out of adjustDURING CLIMB ACFT DID NOT PRESURIZE. AIRCRAFT RETURNED TO DEPARTURE. MAINTENANCE PERFORMED ADJUSTMENT OF THE PASSENGERS DOOR IAW AMM 52-11-00-820-801 AND TESTED IAW AMM 52-11-00-700-804, ALL CORRECT.SDR SCNA20131004157Intercostal · damagedFS 500A, STR 25R, INTERCOSTAL BENT & CRACKED. R & R INTERCOSTAL & ANGLE.SDR SCNA20131004159Floor Panel · corrodedAFT CARGO BAY FLOOR PANEL BS 727 TO 794 HAS SEVERAL AREAS CORRODED ON TOP AND BOTTOM SIDES. R & R AFT CARGO FLOOR PANELS.SDR SCNA20131005169Angle · brokenAFT WET AREA FLOOR WEB HAS NUTPLATE BROKEN AT LBL 37, BS 992. R & R BROKEN NUTPLATE & FABRICATED, LOCATED & DRILLED NEW ANGLE.SDR SCNA20131002148Floorbeam · corrodedAFT CARGO BAY FLOORBEAM CORRODED AT BS 887 FROM RBL 20 TO LBL 8. FABRICATED, REMOVED & INSTALLED NEW FLOORBEAM.SDR SCNA20131002147Transition Panel · corrodedAFT CARGO BAY FLOOR LT TRANSITION PANEL HAS SEVERAL CORROSION AREAS ON UPPER AND LOWER SIDE FROM BS 727 TO 847. R & R LT TRANSITION PANEL STA 727 TO STA 847.SDR SCNA20131011179Support Bracket · damagedAFT CARGO RT SIDEWALL SUPPORT BRACKET HAS MISDRILLED HOLES AT BS 727I S25R. R & R SUPPORT BRACKET.SDR SCNA20131001145Structure · corrodedAFT CARGO BS 727D LT SIDE BETWEEN S22-25L HAS CORROSION AROUND NUTPLATES, REPLACED.SDR SCNA20131001141Angle · corrodedAFT WET AREA INNER ANGLE CORRODED BS 992 TO 1016, RBL 55. FABRICATED NEW ANGLE. PART REMOVED & INSTALLED.SDR SCNA20130930133Transition Panel · corrodedAFT PIT TRANSITION PANEL CORRODED AT NUTPLATES & FASTENER HOLES STA 847-864, RBL-20 AFT OF DOOR OPENING. FABRICATED NEW TRANSITION PANEL & INSTALLED.SDR SCNA20130930132Angle · crackedFWD CARGO BAY BS 500D RT FRAME ANGLE CRACKED UNDER TRANSITION PANEL. R & R FRAME ANGLE.SDR SCNA20130930131Support Frame · crackedAFT CARGO BAY FWD BULKHEAD, BS 727 HAS LOWER SUPPORT FRAME CRACKED AT ATTACH POINT. R & R SUPPORT FRAME.SDR SCNA20130930130Attach Angle · crackedINTERCOSTAL ATTACH ANGLE AT FS 500H & STR 25L CRACKED (AFT SIDE). R & R ATTACH ANGLE.SDR SCNA20130930129Shear Tie · crackedSHEAR TIE AT FS 500I & STR 25L CRACKED. R & R SHEAR TIE.SDR SCNA20130930128Shear Tie · crackedSHEAR TIE AT FS 500I & STR 25R CRACKED. R & R SHEAR TIE.SDR SCNA20130930127Attach Angle · crackedINTERCOSTAL ATTACH ANGLE AT FS 500H & STR 25R CRACKED, AFT SIDE. R & R ATTACH ANGLE.SDR SCNA20130930126Shear Tie · crackedSHEAR TIE AT FS 500H & STR 25L CRACKED. R & R SHEAR TIE.SDR SCNA20130930125Attach Angle · crackedINTERCOSTAL ATTACH ANGLE AT FS 500H & S25L CRACKED (FWD SIDE). R & R ATTACH ANGLE.SDR SCNA20130930124Attach Angle · crackedINTERCOSTAL ATTACH ANGLE AT FS 500G & STR 25R CRACKED (AFT SIDE). R & R ATTACH ANGLE AT FS 500G & STR 25R.SDR SCNA20130930123Attach Angle · crackedINTERCOSTAL ATTACH ANGLE AT FS 500H & STR 25R CRACKED. R & R ATTACH ANGLE.SDR SCNA20130930122Shear Tie · crackedSHEAR TIE AT FS 500H & S25R CRACKED. R & R SHEAR TIE.SDR SCNA20130930121Attach Angle · crackedINTERCOSTAL ATTACH ANGLE AT 500G & STR 25R CRACKED (FWD SIDE). R & R ATTACH ANGLE.SDR SCNA20130930120Attach Angle · crackedINTERCOSTAL ATTACH ANGLE AT FS 500G S25L CRACKED. R & R ATTACH ANGLE.SDR SCNA20130930119Attach Angle · crackedINTERCOSTAL ATTACH ANGLE AT FS 500F & S25R CRACKED. R & R ATTACH ANGLE.SDR SCNA20130930118Attach Angle · crackedINTERCOSTAL ATTACH ANGLE AT FS 500F & S25L CRACKED. R & R ATTACH ANGLE.SDR SCNA20130930117Attach Angle · crackedINTERCOSTAL ATTACH ANGLE AT FS 500E & STR 25R CRACKED. R & R ATTACH ANGLE.SDR SCNA20130930116Structure · corrodedFWD CARGO FLOOR TRIM STRIP IS CORRODED. FABRICATED CARGO FLOOR TRIM STRIP.SDR SCNA20130930115Attach Angle · crackedINTERCOSTAL ANGLE AT FS 500E & STR 25L CRACKED. R & R INTERCOSTAL ANGLE AT FS 500E & STR 25L.SDR SCNA20131010177Skin · damagedNR 2 OTBD FAN COWL RUB STRIP & SKIN DAMAGED. R & R RUB STRIP AND REPAIRED SKIN DAMAGE ON NR 2 OTBD FAN COWL.SDR SCNA20131010176Skin · chafedNR 1 INBD FAN COWL RUB STRIP AND SKIN CHAFED. R & R RUB STRIPS AND REPAIRED SKIN DAMAGE ON NR 1 INBD FAN COWL.SDR SCNA20131010175Rub Strip · chafedNR 1 OTBD FAN COWL RUB STRIP AND SKIN CHAFED. R & R RUB STRIP AND REPAIRED SKIN.SDR SCNA20131010174Rub Strip · crackedNR 2 INBD UPPER RUB STRIP CRACKED. R & R UPPER RUB STRIP.SDR SCNA20131010173Skin · damagedFAN COWL SKIN TO BE DAMAGED. R & R RUBSTRIP & REPAIRED SKIN DAMAGE ON NR 2 INBC FAN COWL.SDR SCNA20131004156Door Frame · crackedR1 DOOR FWD CUTOUT LOWER STUB FRAME AT BS 296 CRACKED ACROSS LOWER FASTENER HOLES. R & R LOWER STUB FRAME.SDR SCNA20131001139Floor Support · damagedCABIN BS 540, FLOOR SUPPORT ANGLE BETWEEN LT SEAT TRACK DAMAGED. R & R CABIN STA 540 FLOOR SUPPORT ANGLE BETWEEN LT SEAT TRACK.SDR SCNA20131001138Floor Support · damagedCABIN BS 540 FLOOR SUPPORT ANGLE BETWEEN RT SEAT TRACK DAMAGED AND RIVET PULLED THROUGH. R & R CABIN STA 540 FLOOR SUPPORT ANGLE BETWEEN RT SEAT TRACK.SDR SCNA20131001137Floor Support · crackedCABIN FLOOR SUPPORT, RT ANGLE, BS 540 CRACKED AT BL 0 ATTACHMENT POINT. R & R BREAK ASSY.SDR SCNA20131001136Floor Support · brokenFLOOR SUPPORT STRUCTURE TRANSVERSE FLOOR PANEL LANDING BROKEN AT THE ATTACHMENT TO FLOORBEAM AT BL0.0 AND STA 540. R & R BREAK ASSY.SDR SCNA20131001144Support Angle · damagedAFT CARGO BAY BS 727D LT SUPPORT ANGLE SECTION BETWEEN S22-25L HAS CORROSION & DAMAGE AROUND FASTENER HOLES. R & R DAMAGED SECTION OF SUPPORT.
Back to Boeing 737-8Q8