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 SWAA2013050715707Lens · brokenL1 DOOR EMERGENCY EXIT LIGHT COVER BROKEN. REMOVED AND REPLACED LENS IAW AMM.SDR SWAA2013010411138Lens · missingEXIT LIGHT LENS MISSING FROM AFT GALLEY DOOR. REMOVED AND REPLACED AFT GALLEY SERVICE DOOR "EMERGENCY EXIT" LENS/LIGHT ASSY OPS CHECK GOOD PER MM.SDR SCNA20121212090Fire Loop · shortedDURING FINAL DESCENT FOR LANDING, RIGHT WING BODY OVERHEAT ILLUMINATED. MAINTENANCE FOUND THE LEADING EDGE OUTBOARD FIRE DETECTION, FWD RT STRUT FIRE DETECTION, & FWD RT PACK BAY LOOPS SHORTED. REMOVED & REPLACED. OPS CHECKS OK.SDR SWAA2012112609845Lens · missingLOWER EMERGENCY EXIT LIGHT COVER MISSING ON F/O'S SIDE. REPLACE LENS ASSY IAW MM.SDR SWAA2012110509048Window Frame · crackedFIRST OFFICERS NR 1 WINDOW POST FRAME CRACKED AT UPPER O/B CORNER. REPAIRED POST FRAME PER ER AND EA.SDR SWAA2012110509047Window Frame · crackedCAPT'S NR 1 WINDOW POST FRAME CRACKED AT UPPER O/B CORNER. REPAIRED POST FRAME PER ER AND EA.SDR SWAA2012101108445Spoiler · inoperativeRIGHT WING SPOILER INOP. REMOVED AND REPLACED SPOILER PER MM.SDR SWAA2012101108441Charger · inoperativeRIGHT WING SPOILER RATIO CHARGER INOP. REMOVED AND REPLACED SPOILER RATIO CHARGER PER MM.SDR SWAA2012062605295Sign · brokenOVERWING EMERGENCY EXIT SIGN BROKEN. REMOVED AND REPLACED LIGHT PER M/M.SDR Z6WR201206130010Blade · crackedREF CMM 78-31-37 REV 23 01MAR2012 FIG 25 ITEM 290. THE 315A2233-14 OUTER V-BLADE HAS A VISUAL CRACK MEASURING 7.25 LONG.SDR SWAA2012040902921Retainer · looseL1 DOOR EMERGENCY EVAC SLIDE COVER AFT GIRT BAR RETAINER HOOK LOOSE. REMOVED AND REPLACED RETAINER ASSY IAW SRM & DWG.SDR SWAA2012031402190Sign · brokenL2 DOOR EMERGENCY EXIT SIGN BROKEN. REMOVED AND REPLACED SIGN ASSY AS PER MM.SDR SCNA20120423003Window Frame · crackedDURING MAINTENANCE INSPECTION, FOUND R3 WINDOW FRAME CRACKED AT FWD LWR FASTENER HOLE. REMOVED CRACKED R3 WINDOW FRAME. INSTALLED NEW R3 WINDOW FRAME.SDR SCNA20120423002Window Frame · crackedDURING MAINTENANCE INSPECTION, FOUND L3 WINDOW FRAME CRACKED AT FWD LWR FASTENER HOLE. REMOVED L3 WINDOW FRAME. INSTALLED NEW L3 WINDOW FRAME.SDR SWAA120265Battery · failedDURING SCHEDULED HC1 CHECK, FWD EMERGENCY EXIT LIGHT FAILED CAPACITY CHECK. REMOVED & REPLACED BATTERY PER MM.SDR SWAA120254Battery · failedDURING SCHEDULED HC1 CHECK, OVERWING EMERGENCY EXIT LIGHT FAILED CAPACITY CHECK. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA120244Battery · failedDURING SCHEDULED HC1 CHECK, AFT EMERGENCY EXIT LIGHT FAILED CAPACITY CHECK. REMOVED AND REPLACED BATTERY PER MM.SDR SCNA12001Window Frame · crackedHIGH PITCH, LOW VOLUME SQUEAL NEAR L2 WINDOW WITH DIFFERENTIAL PRESSURE ABOVE 3.0. FOUND L3 WINDOW LEAKING AT UPPER FWD CORNER. FOUND WINDOW SEAL DETERIORATED. FOUND CRACK AT SECOND HOLE ON FWD WINDOW FRAME. CRACK RUNS THROUGH FASTENER HOLE & THROUGH RADIUSSDR SCNA11023Module · faultyEMERGENCY EXIT LIGHTS ILLUMINATED AFTER TAKEOFF WITH LIGHT SWITCH IN THE ARMED POSITION. MX REMOVED & REPLACED AFT F/A STATION CONTROL PANEL SWITCH MODULE. OPS CHECKS NORMAL.SDR SWAA116695Lens · looseDURING SCHEDULED CV CHECK, FOUND RT EMERGENCY EXIT BULLNOSE LIGHT LENS LOOSE AT ROW 13. SECURED LENS PER MM.SDR SWAA113822Flap · delaminatedDURING SCHEDULED HC2 CHECK FOUND, RT WING O/B AFT FLAP DELAMINATED. REPAIRED AFT FLAP PER SRM.SDR SWAA112954Slide · low pressureL1 DOOR EMERGENCY EVAC SLIDE PRESSURE INDICATOR LOW. REMOVED AND REPLACED SLIDE PER MT.SDR SWAA111576Sign · looseFWD ENTRY DOOR LOWER EMERGENCY EXIT SIGN LOOSE. REMOVED AND REPLACED EXIT SIGN PER MM.SDR SWAA111294Wedge · delaminatedDURING SCHEDULED MV3 CHECK, FOUND LT WING NR 3 SLAT L/E WEDGE DELAMINATED. REMOVED AND REPLACED NR 3 SLAT PER MM.SDR SCNA10007Light · inoperativeDURING ROUTINE MAINTENANCE, FOUND RT OVERWING EMERGENCY DOOR WINDOW LIGHT INOPERATIVE. PLACED RT OVERWING EMERGENCY DOOR LIGHT ON MEL.SDR SWAA101554Bracket · looseDURING SCHEDULED 12Y CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE GIRT BAR FWD BRACKET LOOSE. REMOVED AND REPLACED BRACKET PER MM.SDR SWAA101546Light · inoperativeDURING SCHEDULED 12Y CHECK, FOUND L1 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOP. RELAMPED PER MM.SDR SWAA101545Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 907, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME PER SRM.SDR SWAA101390Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 360, STR 8R. REPAIRED FRAME PER EA.SDR SWAA101389Attach Bracket · corrodedDURING SCHEDULED 12Y CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE FWD SLIDE ATTACH BRACKET CORRODED. REMOVED AND REPLACED BRACKET PER SRM.SDR SWAA101387Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER EA.SDR SWAA101360Light · damagedDURING SCHEDULED 12Y CHECK, FOUND AFT LAVATORY FWD WALL EMERGENCY EXIT LIGHT DAMAGED. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA101293Skin · crackedDURING SCHEDULED 12Y CHECK, FOUND SKIN CRACKED BETWEEN BS 500 TO BS 500A, BETWEEN STR 27L TO STR 27R. REPAIRED SKIN PER SRM.SDR SWAA101292Skin · crackedDURING SCHEDULED 12Y CHECK, FOUND SKIN CRACKED BETWEEN BS 500A TO BS 500B, BETWEEN STR 27L TO STR 27R. REPAIRED SKIN PER SRM.SDR SWAA101186Stringer Clip · crackedDURING SCHEDULED 12Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 8L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA101185Fitting · crackedDURING SCHEDULED 12Y CHECK, FOUND CENTER WING BOX SHEAR FITTING CRACKED AT BS 540, STR 4R. REMOVED AND REPLACED FITTING PER SRM.SDR SWAA101184Fitting · crackedDURING SCHEDULED 12Y CHECK, FOUND CENTER WING BOX SHEAR FITTING CRACKED AT BS 540, STR 3R. REMOVED AND REPLACED FITTING PER SRM.SDR SWAA101183Fitting · crackedDURING SCHEDULED 12Y CHECK, FOUND CENTER WING BOX SHEAR FITTING CRACKED AT BS 540, STR 2R. REMOVED AND REPLACED FITTING PER SRM.SDR SWAA101182Fitting · crackedDURING SCHEDULED 12Y CHECK, FOUND CENTER WING BOX SHEAR FITTING CRACKED AT BS 540, STR 1R. REMOVED AND REPLACED FITTING PER SRM.SDR SWAA101181Fitting · crackedDURING SCHEDULED 12Y CHECK, FOUND CENTER WING BOX SHEAR FITTING CRACKED AT BS 540, STR 3L. REMOVED AND REPLACED FITTING PER SRM.SDR SWAA101180Fitting · crackedDURING SCHEDULED 12Y CHECK, FOUND CENTER WING BOX SHEAR FITTING CRACKED AT BS 540, STR 2L. REMOVED AND REPLACED FITTING PER SRM.SDR SWAA101179Fitting · crackedDURING SCHEDULED 12Y CHECK, FOUND CENTER WING BOX SHEAR FITTING CRACKED AT BS 540, STR 1L. REMOVED AND REPLACED FITTING PER SRM.SDR SWAA101178Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER EA.SDR SWAA101177Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME PER EA.SDR SWAA101176Floorbeam · corrodedDURING SCHEDULED 12Y CHECK, FOUND FLOORBEAM CORRODED AT BS 986.5, BETWEEN RBL 35 TO RBL 42. REPAIRED BEAM PER SRM.SDR SWAA101175Crease Beam · corrodedDURING SCHEDULED 12Y CHECK, FOUND LT CREASE BEAM Z-ANGLE CORRODED BETWEEN BS 947 TO BS 986.5, STR 17L. REMOVED AND REPLACED BEAM PER SRM.SDR 2010F00001Slide · misinstalledAIRCRAFT 30674 WAS PERFORMING "P39" CHECK. THE ESCAPE SLIDE AT THE FWD PASSENGER ENTRY DOOR CANNOT PROPERLY RELEASED. SHOP VISIT OF THE ESCAPE SLIDE SHOWS SERVICEABLE PART TAG WAS STILL ATTACHED ON THE SAFETY PIN HOLE OF THE BOTTLE OF THE ESCAPE SLIDE BY A PSDR SWAA101062Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER EA.SDR SWAA101061Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER EA.SDR SWAA100421Battery Pack · failedDURING SCHEDULED HC2 CHECK, LT EMERGENCY EXIT LIGHT BATTERY PACK FAILED CAPACITY TEST AT ROW 16. REMOVED AND REPLACED BATTERY PACK PER MM.
Back to Boeing 737-7Q8