Boeing 737-4Q8
Service difficulty reports · 6,250
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 = '7374Q8' 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 = '7374Q8' 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 ASAA0440102Socket · disconnectedJNU - FOUND FLOOR TRACK LIGHTS INOPERATIVE AT SECTION FIRST CLASS ROWS 2-6. RECONNECTED LAMP SOCKET AT ROW 2. OPS CHECK NORMAL. (M)SDR ASAA0440100Frame · crackedGYR - FOUND STATION 360 AT 8L FRAME IS CRACKED AT SIDEWALL ATTACHMENT BRACKET. REPAIRED FRAME AT STATION 360 AT 8L. (M)SDR ASAA0440117Frame · crackedFOUND FS 360 AT STRINGER 8L FRAME IS CRACKED AT SIDEWALL LIGHT ATTACHMENT BRACKET. REPAIRED FRAME AT STATION 360 AT STRINGER 8L. (M)SDR ASAA0440099Wire · disconnectedJNU - FOUND SIX ADJACENT TRACK LIGHTS INOPERATIVE SEAT ROWS 2-6. RECONNECTED LIGHT ASSEMBLY AT ROW 2. (M)SDR ASAA0440113Stringer · corrodedGYR - FOUND AFT PIT STRINGER 25R IS EXFOLIATED AT STATION 940. CUTOUT DAMAGED SECTION OF STRINGER, FABRICATED REPAIR PART AND INSTALLED REPAIR IAW SRM 53-00-03 FIG 201. (M)SDR ASAA0440119Bulkhead · damagedFOUND BULKHEAD STATION 178 HAS WEB DAMAGED WL 219, LBL 18.1, PART NR 65-16300-511. REPAIR DAMAGED WEB IAW ASA EA 5310-02343 PAGE 3 STEP 3. (M)SDR ASAA0440094Skin · dentedGYR - FOUND DENT IN FUSELAGE SKIN, AF6 OF L-1 DOOR 8 FEET ABOVE VERTICAL. REPAIRED DENT IN FUSELAGE STATION 360 TO 380, STRINGER 17L AND 18L REF SRM 53-00-01 FIG 201. (M)SDR ASAA0440095Attach Fitting · corrodedGYR - FOUND ATTACH FITTING CORRODED. REPLACED ATTACH FITTING. (M)SDR ASAA0440097Floorbeam · corrodedGYR - FOUND MAIN DECK FLOORBEAM UPPER T-CAP STATION 360 HAS NUMEROUS AREAS OF CORROSION ON UPPER SURFACE. REPAIRED FLOORBEAM. (M)SDR ASAA0440090Shear Tie · corrodedGYR - FOUND FORWARD CARGO COMPARTMENT, STATION 520 RBL 3, LOWER FRAME SHEAR TIE 100 PERCENT EXFOLIATED. FABRICATED AND INSTALLED 65-46534-9 SHEAR TIE. (M)SDR ASAA0440096Floorbeam · corrodedGYR - FOUND MAIN DECK FLOORBEAM STATION 294.5 HAS CORROSION FROM LBL 12 TO RBL 50. REPAIRED FLOORBEAM T-CAP CHORD. (M)SDR ASAA0440092Crease Beam · corrodedGYR - FOUND R1 DOOR THRESHOLD CREASEBEAM AT STATION 294.5 APPROX RBL 55, CORRODED IN NUMEROUS AREAS OF UPPER SURFACE. REMOVED AND REPLACED R-1 DOOR THRESHOLD CHORD STATION 262 TO 380 RBL 55 PER SRM 51-40-02. (M)SDR ASAA0440093Floorbeam · corrodedGYR - FOUND MAIN DECK FLOORBEAM AT FS 294.5 APPROX LBL 12 TO RBL 50, UPPER T-CAP HAS SEVERAL AREAS OF CORROSION ON UPPER SURFACE. BLENDED CORROSION CK OUT OF LIMITS. REMOVED 'T' AND FABRICATED NEW 'T' AND INSTALLED 'T' AND REPAIR ANGLE PER SRM 53-10-51. (M)SDR ASAA0440089Light · disconnectedANC - FOUND FORWARD GALLEY ENTRANCE RED FLOOR TRACK LIGHT UNPLUGGED. REINSTALLED FORWARD GALLEY RED FLOOR TRACK LIGHT, OPS CHECK GOOD. (M)SDR ASAA0440086Floorbeam · corrodedGYR - MAIN DECK FLOORBEAM AT STATION 294.5 APPROX LBL 12 TO RBL 50, UPPER T-CAP HAS SEVERAL AREAS OF CORROSION ON UPPER SURFACE. BLENDED CORROSION CK OUT OF LIMITS. REMOVED 'T' AND REPAIR ANGLE EPR SRM 53-10-51. (M)SDR ASAA0440087Crease Beam · corrodedGYR - FOUND R1 DOOR THRESHOLD CREASEBEAM AT STATION 294.5 APPROX RBL 55, CORRODED IN NUMEROUS AREAS OF UPPER SURFACE. REMOVED AND REPLACED R1 DOOR THRESHOLD CHORD STATION 262 TO 380 RBL 55 PER SRM 51-40-02. (M)SDR ASAA0440082Floor Support · corrodedOAK - FOUND CORROSION BETWEEN RIGHT STATION 787-793 FLOOR SUPPORT BEAM. REMOVED AND REPLACED FLOOR SUPPORT BEAM. (M)SDR ASAA0440083Intercostal · crackedOAK - FOUND LOWER FUSELAGE AREA BELOW AFT CARGO COMPARTMENT. BILGE RIGHT SIDE BETWEEN STATION 747-767 INTERCOSTAL CRACKED. REMOVED AND REPLACED WITH NEW INTERCOSTAL AY RT SIDE AT AFT PIT STATION 747-767. (M)SDR ASAA0440085Floor Support · corrodedOAK -FOUND AFT CARGO COMPARTMENT BILGE AREA LBL 3 LONGITUDINAL FLOOR SUPPORT CHANNEL IS CORRODED AT FLOOR PANEL SPLICE STRAP ATTACH HOLES BETWEEN STATOIN 767 AND 787. REPLACED LONGITUDINAL FLOOR SUPPORT CHANNEL FROM STATION 727G AND STATION 787 USING EXISTINGSDR ASAA0440081Intercostal · crackedOAK - FOUND AFT CARGO COMPARTMENT BILGE HAD CRACKED INTERCOSTAL. REPLACED INTERCOSTAL. (M)SDR ASAA0440079Shear Tie · corrodedGYR - FOUND FORWARD CARGO COMPARTMENT, STATION 520 RBL 3, LOWER FRAME SHEAR TIE 100 PERCENT EXFOLIATED. FABRICATED AND INSTALLED 65-46534-9 SHEAR TIE. (M)SDR ASAA0440077Wire · brokenPDX - FOUND AFT TWO RED EMERGENCY LIGHTS ARE NOT WORKING. REPLACED ONE SECTION BROKEN WIRE. (M)SDR ASAA0440069Floorbeam · corrodedGYR - FOUND CORROSION ON FLOORBEAM. REPAIRED FLOORBEAM PER SRM. (M)SDR ASAA0440055Floor Support · corrodedGYR - AFT GALLEY AREA FORE TO AFT FLOOR SUPPORT BEAM HAS CORROSION STATION 947 TO 967 RBL 50. REMOVED AND REPLACED FLOOR SUPPORT BEAM STATION 947 TO 967 RBL 50. (M)SDR ASAA0440059Intercostal · corrodedGYR - AFT PIT INTERCOSTAL AT STATION 787-790 STRINGER 25R CORRODED UPPER SURFACES. REMOVED AND REPLACED INTERCOSTAL STATION 767 TO 790 STRINGER 25R. (M)SDR ASAA0440054Seat Track · corrodedGYR - FOUND MAIN DECK SEAT TRACK AT STATION 344 LBL 26.5 UPPER SURFACES OF INBOARD AND OUTBOARD FLANGES CORRODED. REPAIRED SEAT TRACK AT STATION 344 LBL 26.5. (M)SDR ASAA0440053Fitting · corrodedGYR - FOUND L1 DOOR GIRT BAR FITTINGS AT STATION 312 AND 344 ARE CORRODED. REMOVED AND REPLACED ATTACH FITTINGS. (M)SDR ASAA0440056Angle · corrodedGYR - AFT BAG PIT BS 767 FRAME FAIL/SAFE CHORD ANGLE IS CORRODED FROM 26R TO BL 0. REPAIRED BS 767 FRAME FAIL/SAFE CHORD ANGLE. (M)SDR ASAA0440057Floor Support · corrodedGYR - AFT GALLEY AREA FORE TO AFT FLOOR SUPPORT CHORD HAS CORROSION STATION 947 TO 967 LBL 50. REMOVED AND REPLACED SUPPORT STATION 947-967 LBL 50. (M)SDR ASAA0440058Crease Beam · corrodedGYR - FLOOR CREASE BEAM AT R2 JAMB CORRODED STATION 947 TO STATION 990. REMOVED AND REPLACED CREASE BEAM STATION 947 TO 1006 RBL 50. (M)SDR ASAA0440060Crease Beam · corrodedGYR - FLOOR CREASE BEAM AT L2 JAMB CORRODED STATION 947 TO 1006. REMOVED AND REPLACED CREASE BEAM CHORD STATION 947-1006 LBL 50. (M)SDR ASAA0440063Channel · corrodedGYR - AFT CARGO PIT CENTER BELLY BETWEEN STATION 727D AND 727E, VHF ANTENNA SUPPORT STRUCTURE CORRODED. REMOVED AND REPLACED VHF ANTENNA SUPPORT STRUCTURE. (M)SDR ASAA0440064Bushing · wornGYR - NR 1 ENGINE PYLON, DIAGONAL BRACE, LOWER SPAR ATTACH FITTING, INBOARD BUSHING MIGRATING. REMOVED AND REPLACED BUSHING. (M)SDR ASAA0440065Bushing · wornGYR - NR 2 PYLON LOWER SPAR FITTING INBOARD BUSHING MIGRATED. REMOVED AND REPLACED LOWER SPAR FITTING BUSHINGS. (M)SDR ASAA0440067Bearing · defectiveGYR - FOUND NR 1 ENGINE PYLON, UPPER LINK ATTACH POINT ROTATING IN UPPER SPAR FITTING. REMOVED AND REPLACED CROWN BEAM BEARING. (M)SDR ASAA0440068Keelbeam · corrodedGYR - RIGHT KEEL BEAM CHORD AT STATION 502 HAS CORROSION. REPAIRED KEEL BEAM AT STATION 502. (M)SDR ASAA0440061Seat Track · corrodedGYR - MAIN DECK SEAT TRACK AT STATION 344 LBL 45.6 UPPER SURFACE OF INBOARD AND OUTBOARD FLANGES FOUND CORRODED. REPAIRED SEAT TRACK AT STATION 344 LBL 45.6 IAW SRM 737 53-00-52. (M)SDR ASAA0440062Crease Beam · corrodedGYR - R-1 DOOR LOWER THRESHOLD CREASEBEAM UPPER SURFACE HAS SEVERAL AREAS OF CORROSION BETWEEN STATION 294.5 AND 344 RBL 50. REMOVED AND REPLACED CREASEBEAM (CHORD) AT R1 DOOR 294.5 TO 344 RBL 50. (M)SDR ASAA0440066Bearing · looseGYR - NR 2 PYLON, UPPER SPAR ATTACH FITTING BEARING IS LOOSE IN LUG. REMOVED AND REPLACED CROWN BEAM BEARING. (M)SDR ASAA0440046Floor Support · corrodedGYR - FOUND AFT BAG PIT BS 947 FLOOR SUPPORT ANGLE IS CORRODED AT SEVERAL PLACES LBL 25 TO RBL 25. REMOVED AND REPLACED FLOOR SUPPORT ANGLES. (M)SDR ASAA0440052Web · corrodedGYR - FOUND AFT PIT DOOR JAMB INBOARD BEAM AT FS 846 ABOVE STATION 25L CORRODED. REMOVED AND REPLACED WEB AT STATION 740-847 AT STRINGER 25R. (M)SDR ASAA0440051Crease Beam · corrodedGYR - FOUND L1 DOOR LOWER THRESHOLD CREASE BEAM UPPER HAS CORROSION FROM STATION 294.5 TO 344, LBL 50. REMOVED AND REPLACED CREASE BEAM. (M)SDR ASAA0440047Channel · corrodedGYR - AFT BAG PIT RIGHT TRANSITION Z-CHANNEL IS CORRODED IN NUMEROUS PLACES FROM BS 867 TO 947. REMOVED AND REPLACED Z-CHANNEL STATION 867 TO 947, 25R. (M)SDR ASAA0440048Channel · corrodedGYR - FOUND AFT BAG PIT RIGHT TRANSITION Z-CHANNEL IS CORRODED FROM STATION 847 TO 867. REMOVED AND REPLACED TRANSITION AT STATION 847 TO 867, 25 RT TO 25 RT. (M)SDR ASAA0440049Channel · corrodedCYR - AFT BAG PIT LEFT TRANSITION Z-CHANNEL IS CORRODED IN NUMEROUS PLACES FROM STATION 797 TO 947. AFT CARGO PIT LEFT SIDE Z-CHANNEL REMOVED AND REPLACED 797 TO 947, 25L TO 25L. (M)SDR ASAA0440050Floorbeam · corrodedCYR - AFT CARGO PIT FLOORBEAM HAS CORROSION TOPSIDE WHERE FLOORPANEL SPLICE STRAP CROSSES, AFT OF 727F, LBL 16 TO RBL 16. REPAIRED AFT PIT FLOORBEAM AT STATION 727F, RBL 16. (M)SDR ASAA0440045Sign · missingPDX - FOUND FLOOR EXIT SIGN MISSING NEAR L2 DOOR. REPLACED SIGN, OPS NORMAL. (M)SDR ASAA0440044Floorbeam · corrodedGYR - FOUND MAIN DECK FLOORBEAM AT FS 294.5 UPPER T-CAP UPPER SURFACE HAS SEVERAL AREAS OF CORROSION FROM LBL 24 TO RBL 50. REPAIRED UPPER CHORD AT STATION 294.5 FROM LBL 24 TO RBL 50. (M)SDR ASAA0440041Wire · looseDEN - FOUND EMERGENCY FLOOR LIGHTING INOPERATIVE AT SEAT POSITION 22C. RECONNECTED LOOSE WIRE AND SECURED. OPS CHECK GOOD. (M)SDR ASAA0440042Skin · scratchedGYR - FOUND FUSELAGE EXTERNAL SKIN HAS SCRATCHES STATION 247, 10 INCHES ABOVE 24R. CUTOUT DAMAGE AND INSTALLED REPAIR DOUBLER IAW 737-400 SRM 53-10-01. (M)
Back to Boeing 737-4Q8