Boeing 737-7Q8
Service difficulty reports · 3,964
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 = '7377Q8' 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 = '7377Q8' 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 SCNA20141223220Frame · crackedBS 500A FRAME CRACKED AT STR 9L. REPAIRED THE FRAME.SDR SCNA20141223216Bracket · crackedRIGHT WING T/E, UPPER SHELF PANEL BRACKET CRACKED INBD OF FLAP DETECTION CONTROL ROLLER BRACKET FWD SIDE OF BULB SEAL BRACKET. R & R SHELF PANEL.SDR SCNA20141223215Bracket · crackedRT WING T/E UPPER SHELF PANEL BULB SEAL BRACKET CRACKED INBD OF FLAP DEFLECTION CONTROL ROLLER BRACKET. R & R SHELF PANEL BRACKET.SDR SCNA20141223235Strap · corrodedAFT CARGO FLOOR SPLICE STRAPS CORRODED. REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS. FABRICATED NEW STRAPS.SDR SCNA20141211212Power Supply · inoperativeLEFT OVERWING EMERGENCY LIGHTS INOPERATIVE. REPLACED POWER SUPPLY, CHARGER AND BATTERY PACK.SDR SCNA20141029154Rib · crackedLEFT HORIZONTAL STABILIZER RIB NR 1 IS CRACKED ON FWD OTBD END. R & R LT STAB RIB NR 1.SDR SCNA20141028153Support Angle · corrodedAFT CARGO BAY LEFT TRANSITION ZEE ANGLE IS CORRODED FROM BS 747 - 767. REMOVED CORROSION & FOUND TO BE OUT OF LIMITS, REPAIRED.SDR SCNA20141028148Floor Support · crackedFLOOR SUPPORT CRACKED AT FORWARD WET AREA BETWEEN BS 312 & 328, LBL 46. R & R FLOOR SUPPORT.SDR SCNA20141028149Floorbeam · corrodedFWD WET AREA FLOORBEAM UPPER TEE CORRODED BS 328, RBL 12. REMOVED CORROSION & FOUND TO BE OUT OF LIMITS, REPAIRED THE TEE.SDR SCNA20141028151Angle · corrodedAFT CARGO BAY LT TRANSITION ZEE ANGLE IS CORRODED FROM BS 727E - 747. BLENDED CORROSION FOUND TO BE OUT OF LIMITS, REPAIRED.SDR SCNA20141028152Support Angle · corrodedAFT CARGO BAY LT TRANSITION ZEE ANGLE IS CORRODED FROM BS 767 - 787. BLENDED CORROSION FOUND TO BE OUT OF LIMITS AND REPAIRED.SDR SCNA20141028150Support Angle · corrodedAFT CARGO BAY LEFT TRANSITION ZEE ANGLE HAS CORROSION FROM BS 727D - 727E. BLENDED CORROSION FOUND TO BE OUT OF LIMITS, REPAIRED.SDR SCNA20141007137Lamp · inoperativeR2 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE, REPLACED THE LAMP.SDR SCNA20140926135Light · damagedSELF ILLUMINATING FLOOR PATH LIGHT STRIP DAMAGED AT ROW 9 DEF. REPLACED DAMAGED SECTION.SDR SCNA20140915112Power Supply · inoperativeNUMEROUS EMERGENCY LIGHTS FAILED TO TEST. R & R LIGHT POWER SUPPLY & BATTERY PACK NEAR FWD ENTRY DOOR LT SIDE & NEAR AFT ENTRY DOOR RT SIDE.SDR SCNA20140818109Sensor · no indicationT/E FLAP ASSYMETRY. R & R NR 5 SKEW SENSOR.SDR SCNA20140527081Floor Support · corrodedFWD CARGO DOOR SURROUND AFT BOTTOM TRANSITION STRIP FLOOR SUPPORT CORRODED. INSTALLED NEW FWD CARGO DOOR SURROUND AFT BOTTOM TRANSITION STRIP FLOOR SUPPORT.SDR SCNA20140527103Intercostal · crackedBS 344, BL 0 FOUND INTERCOSTAL CRACKED. LOCATED, DRILLED AND REPLACED THE INTERCOSTAL.SDR SCNA20140527104Intercostal · crackedFOUND CRACKED INTERCOSTAL BETWEEN BS 328-344 INSIDE L1 DOOR. REMOVED DAMAGE. FABRICATED, LOCATE, DRILLED AND INSTALLED REPAIR.SDR SCNA20140527084Beam · corrodedBEAM JUST INBD OF R2 MOP SEAL HAS CORROSION BETWEEN BS 951-967. BLENDED CORROSION, FOUND TO BE OUT OF LIMITS. R & R BEAM.SDR SCNA20140527102Web · corrodedAFT CARGO WEB ASSY BS 767-787 RBL 18 UPPER SURFACE CORRODED JUST FWD OF DOOR OPENING. BLENDED CORROSION FOUND TO BE OUT OF LIMITS. R & R WEB.SDR SCNA20140527101Web · corrodedAFT CARGO WEB ASSY BS 767-787 RBL 18 UPPER SURFACE CORRODED. BLENDED CORROSION FOUND TO BE OUT OF LIMITS. REMOVED, FABRICATED NEW AND INSTALLED WEB ASSY.SDR SCNA20140527100Web · corrodedWEB ASSY BS 787-795 RBL 18 CORRODED ON UPPER SURFACE. REMOVED CORROSION FOUND TO BE OUT OF LIMITS. REMOVED, FABRICATED NEW AND INSTALLED WEB ASSY.SDR SCNA20140527080Cargo Track · crackedAFT CARGO BAY RT BS 794, RBL 13.84 TIE DOWN TRACK HAS A CRACK ON LOWER WEB. CARGO TRACK REPLACED FROM BS 727-887.SDR SCNA20140527099Channel · corrodedFOUND MOP SILL CORRODED AT L2 DOOR OPENING. FOUND OUT OF LIMITS. REMOVED AND INSTALLED SERVICEABLE L2 MOP SILL.SDR SCNA20140527098Window · crackedRT FLIGHT COMPARTMENT WINDOW NR 3, FOUND TWO CRACKS. REPAIRED CRACKS.SDR SCNA20140527095Floor Support · corrodedFLOOR SUPPORT AT ABOUT RBL 32 HAS CORROSION BETWEEN BS 986.5 - 1016. R & R FLOOR SUPPORT.SDR SCNA20140527091Floor Support · corrodedFLOOR SUPPORT CAP AT LBL 16 HAS CORROSION ON THE TOP AND BOTTOM SIDE BETWEEN BS 967 - 986.5. BLENDED CORROSION FOUND TO BE OUT OF LIMITS. R & R THE FLOOR SUPPORT.SDR SCNA20140527082Floor Support · corrodedFWD CARGO DOOR SURROUND FWD BOTTOM TRANSITION STRIP FLOOR SUPPORT NUT PLATE HOLES CORRODED. R & R FWD CARGO DOOR SURROUND FWD BOTTOM TRANSITION STRIP FLOOR SUPPORT.SDR SCNA20140527074Floorbeam · corrodedAFT CARGO BAY FLOORBEAM ANGLE AT BS 947.5 CORRODED ON UPPER AND LOWER SURFACE FROM RBL 3 - LBL 8.1. REMOVED ANGLE AND INSTALLED NEW.SDR SCNA20140527097Floor Support · corrodedFLOOR SUPPORT AT ABOUT LBL 32 HAS CORROSION ON THE TOP AND BOTTOM SIDE BETWEEN BS 986.5 - 1016. BLENDED CORROSION FOUND TO BE OUT OF LIMITS. R & R FLOOR SUPPORT.SDR SCNA20140527096Floor Support · corrodedFLOOR SUPPORT AT BL 0 HAS CORROSION BETWEEN FS 1006 AND FS 1016. REMOVED CORROSION FOUND TO BE OUT OF LIMITS. FABRICATED NEW FLOOR SUPPORT.SDR SCNA20140527092Floorbeam · corrodedFLOORBEAM CAP AT BS 951 HAS CORROSION BETWEEN LBL 24 AND LT L2 DOOR MOP SEAL. R & R FLOORBEAM CAP.SDR SCNA20140527090Floor Support · corrodedFLOOR SUPPORT AT LBL 16 HAS CORROSION ON THE TOP AND BOTTOM SIDE BETWEEN BS 951 - 967. BLENDED CORROSION FOUND TO BE OUT OF LIMITS. R & R FLOOR SUPPORT.SDR SCNA20140527089Floorbeam · corrodedFLOORBEAM HAS CORROSION ON THE TOP AND BOTTOM SIDE AT BS 947.5 BETWEEN LBL 16 AND RBL 16. REPAIRED FLOORBEAM.SDR SCNA20140527088Floorbeam · corrodedRT FLOORBEAM ANGLE AT BS 992.8 HAS CORROSION. R & R RT FLOORBEAM ANGLE AT BS 992.8.SDR SCNA20140527086Beam · corrodedBEAM CAP AT RBL 16 HAS CORROSION ON THE TOP AND BOTTOM SIDE BETWEEN BS 967 AND 985.5. REMOVED BEAM CAP AT RBL 16 BETWEEN FS 967-985.5 CORRODED BEYOND LIMITS. REPLACED.SDR SCNA20140527079Floor Support · corrodedCABIN FLOOR SUPPORT CORRODED ABOUT BS 344. REPAIRED FLOOR SUPPORT.SDR SCNA20140527093Floorbeam · corrodedFLOORBEAM AT BS 967 HAS CORROSION JUST INBD OF L2 DOOR MOP SEAL. REPAIRED FLOORBEAM.SDR SCNA20140527087Floorbeam · corrodedFLOORBEAM HAS CORROSION ON THE TOP AND BOTTOM SIDE END TO END AT BS 986.5. REMOVED CORROSION FOUND TO BE OUT OF LIMITS. REPAIRED FLOORBEAM.SDR SCNA20140527085Floorbeam · corrodedFLOORBEAM HAS CORROSION AT FS 967 BETWEEN RBL 16 AND RBL 24.SDR SCNA20140527078Cargo Track · unknownAFT CARGO TIE DOWN TRACK FROM BS 727-BS 887, RBL 13.8.SDR SCNA20140527077Door Sill · corrodedAFT CARGO DOOR SURROUND LOWER SILL UPPER STRAP CORRODED. REMOVED CORROSION FOUND TO BE OUT OF LIMITS. INSTALLED NEW.SDR SCNA20140527094Floorbeam · corrodedLEFT FLOORBEAM ANGLE AT BS 992.8, HAS CORROSION. BLENDED CORROSION ON ANGLE MATERIAL LOSS OUT OF LIMITS. R & R NEW FLOORBEAM ANGLE.SDR SCNA20140527083Channel · corrodedR2 DOOR MOP SILL HAS CORROSION AT SEVERAL SPOTS ON THE TOP AND BOTTOM SIDE, BETWEEN BS 951-992.8. R & R MOP SILL.SDR SWAA2014030325699Cover · damagedR2 DOOR EMERGENCY EXIT LIGHT COVER INOPERATIVE. R & R COVER IAW AMM.SDR SWAA2014022425499Light · brokenRT EMERGENCY EXIT EEPLS BROKEN BETWEEN BS 630.94 TO BS 630.95. R & R EEPLS IAW AMM.SDR SWAA2014022425498Pressure Panel · crackedMAIN WW PRESS WEB CRACKED AT BS 663, LBL 35. REPAIRED WEB IAW EA.SDR SWAA2014022425497Pressure Panel · crackedMAIN WW PRESS WEB CRACKED AT BS 663, LBL 35. REPAIRED WEB IAW EA.SDR SWAA2014022125420Skin · crackedRT WING NR 6 SLAT SKIN RIB CRACKED AT STATION 202.45. REPAIRED SKIN IAW SRM.
Back to Boeing 737-7Q8