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 ASAA0640553Floorbeam · corrodedFOUND CORROSION ON FLOORBEAM. REPAIRED FLOORBEAM PER SRM 53 00 51.SDR ASAA0640552Angle · crackedL ANGLE CRACKED 9 INCHES FWD OF GALLEY DOOR 2 INCHES FROM TOP STOP. REMOVED AND REPLACED PER SRM 51 40 2.SDR ASAA0640545Web · corrodedFOUND SUB THRESHOLD WEB AT FED CORRODED. REPLACED PER SRM 53 10 15 AND 51 40 02.SDR ASAA0640547Stringer Clip · crackedFOUND CRACKED STRINGER CLIP. REMOVED AND REPLACED CRACKED STRINGER CLIPS PER SRM 51 40 02 AND 53 00 03.SDR ASAA0640546Clip · corrodedFOUND CORRODED KEEL BEAM SUPPORT CLIPS. REMOVED AND REPLACED PER SRM 51 40 02.SDR ASAA0640543Frame · corrodedCORROSION FOUND ON FRAME. REPLACED FRAME PER SRM 51 40 2 AND 53 00 07.SDR ASAA0640544Shear Tie · corrodedFOUND CORROSION ON FRAME SHEAR TIE. REMOVED AND REPLACED FRAME PER SRM 53 00 07 AND 51 40 02.SDR ASAA0640542Shear Tie · corrodedFOUND CORROSION ON SHEAR TIE. REMOVED CORROSION AND INSTALLED REPAIR PER SRM 53 00 07.SDR ASAA0640541Shear Tie · corrodedFOUND CORROSION ON SHEAR TIE. REPAIRED PER SRM 53 00 07 REPAIR 10.SDR ASAA0640540Shear Tie · corrodedFOUND CORROSION ON SHEAR TIE. REPAIRED PER SRM 53 00 07.SDR ASAA0640539Shear Tie · corrodedFOUND SHEAR TIE CORRODED. CUTOUT DAMAGE AND INSTALLED REPAIR PER SRM 53 00 07.SDR ASAA0640538Stiffener · corrodedFOUND CORROSION ON APU COMPARTMENT RT TORQUE BOX VERTICAL STIFFENER AFT OF APU AIR INLET CUTOUT. REMOVED AND REPLACED STIFFENER PER SRM 53 80 13 AND 51 40 02.SDR ASAA0640537Stringer · corrodedFOUND CORROSION ON APU COMPARTMENT RT TORQUE BOX STRINGER ABOVE APU AIR INLET CUTOUT. REMOVED AND REPLACED STRINGER PER SRM 53 80 13 AND 51 40 02.SDR ASAA0640536Stringer · corrodedFOUND CORROSION ON APU COMPARTMENT RT TORQUE BOX STRINGER BELOW APU AIR INLET CUTOUT. REMOVED AND REPLACED STRINGER PER SRM 53 80 13.SDR ASAA0640534Floorbeam · corrodedAFT CARGO PIT HAS CORROSION ON ALL FLOORBEAMS FROM LT TRANSITION PANEL TO RT TRANSITION PANEL. FLOORBEAMS REPAIRED IAW ASA EA 5310 02617.SDR ASAA0640532Skin · chafedLT WING OB MID FLAP LE SKIN IS CHAFED AT IB CORNER. BLENDED CHAFED AREA CHECKED OUT OF LIMITS. REPAIRED IAW SRM 57 53 01 FIG 201 REPAIR 8.SDR ASAA0640531Skin · dentedFOUND FUSELAGE EXTERNAL SKIN DENTED. DENT WITHIN 3" OF LAP. DENT APPEARS TO CROSS THE LAP AT STR 14R. REPAIRED EXTERNAL SKIN IAW ASA EA 5330 02081.SDR ASAA0640530Sill · corrodedFOUND CORROSION ON FWD CARGO COMPARTMENT DOOR OPENING SILL WEB. REMOVED AND INSTALLED NEW SILL WEB IAW SRM 51 40 02 PG 3 PARA 5B.SDR ASAA0640522Frame · corrodedAFT CARGO DOOR CUTOUT FWD FRAME HAS CORROSION ON FRAME AND WEB. REPLACED FRAME PER SRM 51 40 02.SDR ASAA0640528Skin · chafedRT OB FORE FLAP CHAFED ON IB LE. REMOVED DAMAGED AREA FABRICATED AND INSTALLED REPAIR DOUBLERS IAW SRM 57 53 01 FIG 201 REPAIR 1.SDR ASAA0640526Skin · damagedFOUND FUSELAGE SKIN DAMAGED, REPAIRED PER EA 5330 02079.SDR ASAA0640524Frame · corrodedFOUND CORROSION ON LWR EDGE FRAME UNDER PRESSURE SEAL ON RT FWD OVER WING EXIT. REPAIRED PER EA 5220 01012.SDR ASAA0640527Skin · chafedLT WING NR 3 SLAT IB LWR T/E IS CHAFED. REPAIRED SLAT IAW SRM 51 70 10 PARA 1 REPAIR 4 PG 201.SDR ASAA0640523Shear Tie · corrodedFOUND CORROSION ON SHEAR TIE. REMOVED CORROSION FOUND OUT OF LIMITS. REPLACED SHEAR TIE PER SRM 53 00 07 FIG 201 REPAIR 3.SDR ASAA0640529Housing · corrodedFOUND CORROSION AROUND HANDLE SHAFT BEARING HOUSING OF R1 DOOR. REMOVED AND REPLACED R1 DOOR HANDLE SHAFT HOUSING (TORQUE BOX) IAW BOHM 52 46 06.SDR ASAA0640525Door Frame · corrodedFOUND CORROSION ON LT AFT EMERGENCY EXIT HATCH ON LWR EDGE FRAME UNDER PRESSURE SEAL. REPAIRED LT AFT EMERGENCY EXIT HATCH LOWER EDGE FRAME UNDER PRESSURE SEAL IAW EA 5220 01013.SDR ASAA0640516Access Panel · damagedACCESS PANEL 7420 RT WING 45 INCHES FM IB END PNL HAS A DENT. REPAIRED THE DAMAGED AREA OF RT WING FLAP PNL 7420 IAW SRM 51 70 10 PG 211 PARA 7 PG 213 PARA 8 PG 238 APRA 15 AND PG 249 PARA 20.SDR ASAA0640515Skin · dentedUPPER LT WING PNL NR 7220L IS DENTED ON THE LWR SURFACE AS MARKED. REPAIRED THE DAMAGED AREA OF THE LT WING PANEL NR 7220L IAW SRM 51 70 10 PG 211 PARA 7 PG 213 PARA 8 PG 238 PARA 15 AND PG 249 PARA 20.SDR ASAA0640517Stringer Clip · corrodedAFT PIT CORROSION ON STRINGER CLIP. REMOVED AND DISCARDED CORRODED STRINGER CLIP FABRICATED DRILLED UP AND INSTALLED NEW STRINGER CLIP PER SRM 51 40 02 PG 2 3 6 AND 7.SDR ASAA0640518Frame · crackedNR 2 ENGINE PYLON CRACK IN FRAME. REPAIRED PER EA 5440 01050 AND ER 06 1834.SDR ASAA0640514Skin · delaminatedRT WING NR 9 SPOILER UPPER SURFACE IS DELAMINATED WITH A DENT. REPAIRED PER SRM 51 70 10 REPAIR 4.SDR ASAA0640513Skin · dentedFOUND RT IB FORE FLAP HAS SHARP DENT ON LWR SURFACE 28" FM IB END. REPAIRED PER SRM 51 70 10 REPAIR 4.SDR ASAA0640512Door Frame · chafedAFT CARGO DOOR FWD LWR FRAME IS CHAFED. REMOVED AND REPALCED FWD LWR CARGO DOOR FRAME ON AFT CARGO DOOR PER SRM 51 40 02.SDR ASAA0640507Frame · corrodedFOUND CORROSION ON SHEAR TIE. REMOVED CORROSION FOUND TO BE OUT OF LIMITS. REMOVED DAMAGED SHEAR TIE, FABRICATED REPAIR PARTS AND INSTALLED.SDR ASAA0640505Shear Tie · corrodedFOUND CORROSION ON SHEAR TIE. REMOVED DAMAGED SECTION OF SHEAR TIE FABRICATED REPAIR PARTS AND INSTALLED PER SRM 53 00 07.SDR ASAA0640509Shear Tie · corrodedFOUND CORROSION ON SHEAR TIE. REMOVED CORROSION FOUND OUT OF LIMITS REPAIRED SHEAR TIE PER SRM 53 00 07 FIG 201 REPAIR 3.SDR ASAA0640508Shear Tie · corrodedFOUND CORROSION ON SHEAR TIE. REMOVED DAMAGED SHEAR TIE FABRICATED AND INSTALLED REPAIR PARTS PER SRM 53 00 07.SDR ASAA0640506Shear Tie · corrodedFOUND CORROSION ON SHEAR TIE, CUT OFF SHEAR TIE AND INSTALLED REPAIR PER SRM 53 00 07.SDR ASAA0640511Stringer · corrodedFOUND CORROSION ON STRINGER AROUND FASTENERS. REMOVED CORROSION FABRICATED AND INSTALLED REPAIR PER SRM 53 00 03.SDR ASAA0640510Shear Tie · corrodedFOUND SHEAR TIE CORRODED. REMOVED CORROSION FOUND OUT OF LIMITS. REPAIRED SHEAR TIE PER SRM 53 00 07 FIG 201 REPAIR 3.SDR ASAA0640504Failsafe · corrodedFOUND CORROSION ON FAILSAFE. REMOVED AND REPLACED FAILSAFE PER SRM 51-40-02.SDR ASAA0640502Frame · corrodedFOUND CORROSION ON FRAME. REPAIRED DAMAGED PER SRM 51 70 11.SDR ASAA0640501Floorbeam · corrodedFOUND CORRODED FLOORBEAM. CUTOUT DAMAGED AREA AND INSTALLED REPAIR PER SRM 53 10 51.SDR ASAA0640503Shear Tie · corrodedFOUND CORROSION ON AFT SIDE OF SHEAR TIE REPAIR DOUBLER. REMOVED AND REPAIRED PER SRM 53 00 07.SDR ASAA0640499Doubler · corrodedFOUND CORROSION IN APU COMPARTMENT RT TORQUE BOX EDGE DOUBLER AFT OF APU CUTOUT. FABRICATED AND INSTALLED DOUBLER PER SRM 51 40 02.SDR ASAA0640498Doubler · corrodedFOUND CORROSION IN APU COMPARTMENT RT TORQUE BOX EDGE DOUBLER FORWARD OF APU AIR INLET CUTOUT. FABRICATED AND INSTALLED DOUBLER PER SRM 51 40 02.SDR ASAA0640520Slide · malfunctionedDURING PILOT EVACUATION TRAINING R2 DOOR SLIDE FAILED TO INFLATE AUTOMATICALLY SLIDE DID INFLATE EVENTUALLY IN THE TIME OF 2.5 SECONDS PER CMM 25 66 07 PG 104. REMOVED AND REPLACED SLIDE PER AMM 25 61 31.SDR ASAA0640497Door Frame · corrodedFOUND CORROSION ON AFT CARGO DOOR CUTOUT LOWER CHORD. REMOVED AND REPLACED PER EA 5310 02613.SDR ASAA0640496Angle · corrodedFOUND CORROSION ON AFT CARGO DOOR OPENING SUB THRESHOLD ANGLE. REMOVED CORROSION FABRICATED REPAIR PARTS INSTALLED REPAIR PER SRM 51 40 02.SDR ASAA0640495Shear Tie · corrodedFOUND SHEAR TIE CORRODED. REMOVED CORROSION FOUND OUT OF LIMITS. REPAIRED SHEAR TIE PER SRM 53 00 07 FIG 201 REPAIR 3.
Back to Boeing 737-4Q8