Boeing 737-3Q8
Service difficulty reports · 4,188
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 = '7373Q8' 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 = '7373Q8' 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 SWAA050468Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CHORD AT BS 270, FROM LBL 11 TO RBL 11, CORRODED. REMOVED AND REPLACED CHORD PER SRM.SDR SWAA050467Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM UPPER CHORD AT BS 986.5, FROM LBL 50 TO RBL 50, CORRODED. REPAIRED FLOORBEAM CHORD PER ER.SDR SWAA050466Frame · crackedDURING SCHEDULED D-CHECK, FOUND 2 EACH FRAMES CRACKED AT BS 480, STRINGER 8R AND STRINGER 8L. REPAIRED FRAME SECTIONS PER SRM.SDR SWAA050464Fitting · corrodedDURING SCHEDULED D-CHECK, FOUND GIRT BAR FITTING AT BS 344, LBL 59, CORRODED. REMOVED AND REPLACED GIRT BAR FITTING PER SRM.SDR SWAA050463Beam · crackedDURING SCHEDULED D-CHECK, FOUND 3 EACH CRACKS ON LONGITUDINAL BEAMS FROM BS 540 TO BS 727B, FROM RBL 45 TO LBL 24. REPAIRED BEAMS PER ER.SDR SWAA050462Beam · corrodedDURING SCHEDULED D-CHECK, FOUND 2 EACH LONGITUDINAL BEAMS FROM BS 540 TO BS 727, BETWEEN BS RBL 24 TO RBL 45, CORRODED. REPAIRED LONGITUDINAL BEAMS PER ER.SDR SWAA050461Spar · corrodedDURING SCHEDULED D-CHECK, FOUND LT HORIZONTAL STABILIZER REAR SPAR UPPER CHORD, CORRODED. REPAIRED CHORD PER SRM.SDR SWAA050460Fitting · corrodedDURING SCHEDULED D-CHECK, FOUND LT HORIZONTAL STABILIZER LOWER THRUST BRACE LOWER ATTACH FITTING CORRODED. REPAIRED THRUST FITTING PER SRM.SDR SWAA050459Skin · crackedDURING SCHEDULED D-CHECK, FOUND RT HORIZONTAL STABILIZER LOWER SKIN AT STATION 127, CRACKED. REPAIRED SKIN PER ER.SDR SWAA050446Frame · crackedDURING SCHEDULED D CHECK, FOUND FRAME FROM BS 827 TO BS 907, STRINGER 8L, CRACKED. REPAIRED FRAME SECTION PER SRM.SDR SWAA050444Stringer Clip · crackedDURING SPV, FOUND STRINGER CLIP AT BS 360, STRINGER 4L, CRACKED. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA050451Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME AT BS 380, STRINGER 13L, CRACKED. REPAIRED FRAME SECTION PER SRM.SDR SWAA050450Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM WEB FROM BS 927 TO BS 947, LBL 55, CORRODED. REMOVED AND REPLACED CREASE BEAM WEB PER SRM.SDR SWAA050449Skin · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE SKIN AT FWD SERVICE DOOR LOWER HINGE CUTOUT, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA050448Web · crackedDURING SCHEDULED D-CHECK, FOUND FLOOR WEB FROM BS 188 TO BS 196, LBL 32 TO RBL 32, CRACKED. REMOVED AND REPLACED FLOOR WEB PER SRM.SDR SWAA050447Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME AT BS 188, RBL 33, CRACKED. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA050445Skin · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE SKIN AT BS 727C + 5, STRINGER 2R, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA050437Skin · crackedDURING SCHEDULED A1 CHECK, FOUND 3 EACH FUSELAGE SKIN CRACKS AT BS 727E, STRINGER 23L AND STRINGER 19R, BS 867, STRINGER 24R. REPAIRED SKIN PER EA.SDR SWAA050436Fitting · corrodedDURING SCHEDULED D-CHECK, FOUND LT MLG AFT SPAR SUPPORT BEAM STABILIZER FITTING LUG FACES, CORRODED. REMOVED AND REPLACED SUPPORT FITTING PER BAC DRAWING AND SRM.SDR SWAA050435Skin · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE SKIN AT BS 360, STRINGER 14L, CRACKED. REPAIRED SKIN PER ER.SDR SWAA050434Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER CLIP AT BS 500C, STRINGER 15R, CRACKED. REPAIRED STRINGER CLIP PER SRM.SDR SWAA050422Splice · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER SPLICE AT BS 400, STRINGER 14L AND STRINGER 4L, CRACKED. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA050423Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER CLIP AT BS 500D, STRINGER 8L, CRACKED. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA050421Splice · crackedDURING SCHEDULED D-CHECK, FOUND 2 EACH STRINGER SPLICES FROM BS 400 TO BS 420, STRINGER 4R, CRACKED. REMOVED AND REPLACED STRINGER SPLICES PER SRM.SDR SWAA050420Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME AT BS 380, STRINGER 9R, CRACKED. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR AWXA200500193Light · brokenPHX - EEL - DURING 4-DAY CHECK FOUND THE EMERGENCY ESCAPE PATH LIGHT AT SEAT ROW 7 LT INOPERATIVE. MAINTENANCE FOUND WIRES PULLED FROM CONNECTOR OF EMERGENCY ESCAPE PATH LIGHT ASSEMBLY AT SEAT ROW 7 LT, REMOVED AND REPLACED LIGHT ASSEMBLY, OPERATIONAL CHECK WSDR SWAA050409Shear Tie · corrodedDURING SCHEDULED D-CHECK, FOUND SHEAR TIE CORRODED BETWEEN BS 500 AND BS 500D, FROM STRINGER 26L TO STRINGER 27L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA050408Frame · corrodedDURING SCHEDULED D-CHECK, FOUND FRAME AT BS 1128, RBL 26, CORRODED. REMOVED AND REPLACED FRAME SECTION PER BAC DRAWING, SRM.SDR SWAA050407Shear Tie · crackedDURING SCHEDULED D-CHECK, FOUND SHEAR TIE AT BS 380, BETWEEN STRINGERS 13L AND 14L, CRACKED. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA050396Fitting · corrodedDURING SCHEDULED D-CHECK, FOUND LT MLG STABILIZER BEAM FWD LUG, CORRODED. REMOVED AND REPLACED LT MLG FITTING PER MM.SDR SWAA050377Splice · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER SPLICE CRACKED AT BS 908, STRINGER 4R & STRINGER 4L. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA050379Fitting · corrodedDURING SCHEDULED D-CHECK, FOUND LT WING GEAR SPAR FITTING CORRODED. REMOVED AND REPLACED SPAR FITTING PER BAC DRAWING.SDR SWAA050378Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM WEB AT BS 840, LBL 65, CORRODED. REMOVED AND REPLACED CREASE BEAM WEB PER SRM.SDR SWAA050380Shear Tie · crackedDURING SCHEDULED D-CHECK, FOUND SHEAR TIE AT BS 360, STRINGER 14R, CRACKED. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA050361Shear Tie · corrodedDURING SCHEDULED D-CHECK, FOUND SHEAR TIE CORRODED BETWEEN BS 727E AND BS 747, FROM LBL 6 TO RBL 6. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA050360Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, BETWEEN STRINGERS 23L AND 25L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA050365Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM WEB FROM BS 360 TO BS 380, LBL 64, CORRODED. REMOVED AND REPLACED CREASE BEAM WEB PER SRM.SDR SWAA050364Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CHORD AT BS 328, FROM LBL 49 TO RBL 55, CORRODED. REMOVED AND REPLACED CHORD SECTION PER SRM.SDR SWAA050363Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CHORD AT BS 360, BL 0, CORRODED. REMOVED AND REPLACED CHORD SECTION PER SRM.SDR SWAA050362Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CHORD AT BS 294, LBL 11, CORRODED. REMOVED AND REPLACED FLOORBEAM CHORD PER SRM.SDR SWAA050346Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME AT BS 887, STRINGER 8R, CRACKED. REPAIRED FRAME SECTION PER SRM.SDR SWAA050345Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM AT BS 967, FROM LBL 27 TO RBL 27, CORRODED. REMOVED AND REPLACED FLOORBEAM SECTION PER SRM.SDR SWAA050344Web · corrodedDURING SCHEDULED D-CHECK, FOUND FLOOR SHEAR WEB AT BS 1014, LBL 37, CORRODED. REMOVED AND REPLACED WEB SECTION PER SRM.SDR SWAA050343Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER CLIP AT BS 787, STRINGER 20R, CRACKED. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA050342Stringer Clip · corrodedDURING SCHEDULED D-CHECK, FOUND STRINGER CLIP AT BS 807, STRINGER 25L, CORRODED. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA050341Bulkhead · crackedDURING SCHEDULED D-CHECK, FOUND BULKHEAD PRESSURE DOME WEB AT BS 1016, 1 O`CLOCK POSITION, CRACKED. REPAIRED WEB PER ER.SDR SWAA050333Spar · corrodedDURING SCHEDULED D-CHECK, FOUND RT AND LT HORIZONTAL STABILIZER FWD AND AFT SPARS, UPPER ATTACH LUGS AND CLEVIS, CORRODED. REPAIRED HORIZONTAL STAB PER SRM.SDR SWAA050271Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND R1 DOOR EVAC SLIDE OUT OF ADJUST. REMOVED AND REPLACED R1 DOOR EVAC SLIDE PER MM.SDR SWAA050270Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN AT BS 524, STRINGER 10L, CRACKED. REPAIRED SKIN PER EA.SDR SWAA050259Skin · crackedFUSELAGE SKIN AT BS 500B, STRINGER 17L, CRACKED. REPAIRED SKIN PER EA.
Back to Boeing 737-3Q8