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 ASAA0640801Shear Tie · corrodedFOUND CORROSION ON SHEAR TIE. REPAIRED PER SRM 53 00 07.SDR ASAA0641034Skin · puncturedLEFT OUTBOARD FORE FLAP REPAIR DOUBLER I/B END DAMAGED FROM TORQUE BOX SCREW. REMOVED PREVIOUS REPAIR DOUBLER, FABRICATED NEW REPAIR DOUBLER AND INSTALLED PER SRM 57-53-01 REPAIR 1 PG 201, 202.SDR ASAA0640797Failsafe · corrodedFOUND CORROSION ON FAIL/SAFE ANGLE. REPLACED PART PER SRM 51 40 02 AND DWG 65 47959.SDR ASAA0640796Frame · crackedCRACK IN FRAME FASTENER. REPAIRED FRAME PER SRM 53 00 07.SDR ASAA0640795Sill · corrodedFOUND CORROSION ON LT CREASE BEAM MOP SILL. REMOVED AND REPLACED MOPSILL PER SRM 51 40 02.SDR ASAA0640793Frame · corrodedFOUND CORROSION ON FRAME. REPAIRED PER SRM 53 00 07.SDR ASAA0640792Failsafe · corrodedFOUND CORROSION ON FAIL/SAFE. REPAIRED PER SRM 51 70 11.SDR ASAA0640791Frame · puncturedFOUND UPPER FRAME FLANGE PUNCTURED. CUT OUT DAMAGE AND INSTALLED REPAIR PER SRM 51 70 11.SDR ASAA0640786Shear Tie · corrodedFOUND CORROSION ON SHEAR TIE. CUT OUT DAMAGE AND INSTALLED REPAIR PER SRM 53 00 07.SDR ASAA0640785Frame · crackedFOUND CRACK IN FRAME. REMOVED DAMAGE IN FRAME FABRICATED REPAIR PARTS AND INSTALLED PER SRM 53 00 07.SDR ASAA0640784Shear Tie · corrodedFOUND CORROSION ON AFT SIDE OF SHEAR TIE. REPLACED SHEAR TIE PER SRM 51 40 02.SDR ASAA0640783Shear Tie · corrodedFOUND CORROSION ON SHEAR TIE. CUT OUT AND INSTALLED REPAIR PER SRM 53 60 07.SDR ASAA0640782Sill · corrodedCORROSION ON RT CREASE BEAM MOPSILL. REMOVED AND REPLACED CREASE BEAM MOPSILL PER SRM 51-40-02.SDR ASAA0640781Angle · tool damageFWD CARGO DOOR HAS TOOLING MARKS ON FWD INBD L ANGLE LOCATED AT DOOR DAMPNER MOUNT FITTING. BLENDED DAMAGE FOUND OUT OF LIMITS FABRICATED AND INSTALLED NEW L ANGLE PER SRM 51 30 01.SDR ASAA0640780Stringer Clip · corrodedSTRINGER CLIP CORRODED. REMOVED CORROSION FOUND OUT OF LIMITS REPLACED STRINGER CLIP PER SRM 53 00 07 AND 51 40 02.SDR ASAA0640779Shear Tie · corrodedSHEAR TIE CORRODED. REMOVED DAMAGED SHEAR TIE FABRICATED REPAIR PARTS AND INSTALLED PER SRM 53 00 07.SDR ASAA0640778Shear Tie · corrodedCORROSION ON SHEAR TIE. BLENDED FOUND OUT OF LIMITS REMOVED DAMAGE FABRICATED NEW SHEAR TIE AND INSTALLED PER SRM 53 00 07.SDR ASAA0640776Shear Tie · corrodedCORROSION ON SHEAR TIE. REPAIRED PER SRM 53 00 07 REPAIR 3.SDR ASAA0640775Shear Tie · corrodedCORROSION ON SHEAR TIE. FABRICATED AND INSTALLED SHEAR TIE PER SRM 53 00 07.SDR ASAA0640770Shear Tie · corrodedCORROSION ON SHEAR TIE. REPAIRED PER SRM 53 00 07.SDR ASAA0640774Floorbeam · corrodedWHILE WORKING FOUND BSTA 360 FLOORBEAM CORRODED AROUND NUT PLATES. REPAIRED FLOORBEAM IAW SRM 53-00-51.SDR ASAA0640773Sill · corrodedCORROSION ON MOPSILL. REMOVED AND REPLACED PER SRM 51 40 02.SDR ASAA0640772Strap · corrodedCORROSION ON REINFORCEMENT STRAP. REMOVED AND REPLACED STRAP PER SRM 51 40 02.SDR ASAA0640771Shear Tie · corrodedCORROSION ON SHEAR TIE. FABRICATED AND INSTALLED SHEAR TIE PER SRM 53 00 07.SDR ASAA0640769Shear Tie · corrodedCORROSION ON SHEAR TIE. FABRICATED AND INSTALLED SHEAR TIE PER SRM 53-00-07.SDR ASAA0640766Doubler · corrodedWHILE WORKING FOUND CORROSION ON INTERNAL DOUBLER AT BSTA 794. REMOVED AND REPLACED INTERNAL DOUBLER PER SRM 53 00 04.SDR ASAA0640764Shear Tie · corrodedFOUND CORROSION ON FWD SIDE OF FRAME. REMOVED AND REPLACED SHEAR TIE PER SRM 53 00 07.SDR ASAA0640763Sill · corrodedFOUND CORROSION ON L 1 MOPSILL CORRODED UPPER AND LOWER SURFACES. REMOVED AND REPLACED MOPSILL L 1.SDR ASAA0640762Channel · corrodedFOUND CORROSION ON FWD ENTRY DOOR SUB THRESHOLD "U" AND "Z" CHANNELS UPPER AND LOWER SURFACES. REMOVED AND REPLACED "U" AND "Z" CHANNELS PER SRM 51 40 02.SDR ASAA0640761Frame · dentedFOUND FWD CARGO COMPARTMENT UPPER FLANGE DENTED. REPAIRED FRAME PER SRM 51 70 11.SDR ASAA0640760Shear Tie · corrodedFOUND CORROSION ON FWD SIDE OF SHEAR TIE. REMOVED AND REPLACED SHEAR TIE PER SRM 53 00 07.SDR ASAA0640758Tee Fitting · corrodedWHILE WORKING FOUND RT UPPER APU TORQUE BOX STRINGER CORRODED. REMOVED AND REPLACED RT UPPER APU TORQUE BOX STRINGER PER SRM 51 40 02.SDR ASAA0640757Tee Fitting · corrodedAPU COMPARTMENT CORROSION ON TEE FITTING AT FWD APU AIR INLET CUTOUT. REMOVED AND REPLACED T CHORD AT FWD APU AIR INLET CUTOUT PER SRM 51 40 02.SDR ASAA0640756Stringer · corrodedWHILE WORKING FOUND RT LOWER APU TORQUE BOX STRINGER CORRODED. REMOVED AND REPLACED RT LOWER APU TORQUE BOX STRINGER PER SRM 51 40 02.SDR ASAA0640755Tee Fitting · corrodedAPU COMPT CORROSION ON TEE FITTING AT AFT APU AIR INLET CUTOUT. REPLACED T CHORD AT AFT APU AIR INLET PER SRM 51 40 02.SDR ASAA0640754Frame · dentedFOUND FWD CARGO COMP FRAME UPPER FLANGE IS DENTED. CUT OUT DAMAGED SECTION OF FRAME 2" BY 6.2" FROM ORIGINAL THICKNESS OF .050". INSTALLED REPAIR PARTS AND REFINISHED PER SRM 53 00 07.SDR ASAA0640681Doubler · gougedGOUGE IN EXISTING DOUBLER JUST AFT OF THE FWD CARGO DOOR OPENING IN FUSELAGE. REMOVED EXISTING DOUBLER AND INSTALLED NEW REPAIR PER ASA EA 5330 02104.SDR ASAA0640660Shear Tie · corrodedFOUND CORRODED KEEL BEAM SUPPORT CLIP. REMOVED AND REPLACED PER SRM 51 40 02.SDR ASAA0640659Shear Tie · corrodedFOUND CORROSION ON SHEAR TIE. CUT OUT DAMAGE AND FABRICATED AND INSTALLED REPAIR PER SRM 53 00 09.SDR ASAA0640658Shear Tie · corrodedFOUND CORROSION ON SHEAR TIE. REPLACED FRAME PER SRM 51 40 02.SDR ASAA0640657Shear Tie · corrodedFOUND CORROSION ON SHEAR TIE. REMOVED AND REPLACED SHEAR TIE FRAME PER SRM 53 00 07.SDR ASAA0640656Shear Tie · corrodedFOUND CORROSION ON SHEAR TIE. REPAIRED DAMAGED SHEAR TIE PER SRM 53 00 07 REPAIR 3.SDR ASAA0640655Sill · corrodedFOUND CORRODED MOPSILL AT AFT ENTRY DOOR. BLENDED CORROSION ON MOPSILL OUT OF LIMITS. REMOVED AND REPLACED MOPSILL PER SRM 51 40 02.SDR ASAA0640654Web · misdrilledFOUND MISDRILLED HOLE IN CASTING WEB. REMOVED DAMAGED CASTING WEB AND REPLACED PER EA 5310 02633.SDR ASAA0640653Skin · lightning strikeFOUND LIGHTNING STRIKE IN CROWN. CUTOUT DAMAGED AREA AND INSTALLED REPAIR DOUBLER AND TRIPLER PER EA 5310 02636.SDR ASAA0640652Doubler · crackedFOUND CRACK ON CIRCUMFERENTIAL DOUBLERS. REPLACED DOUBLER PER EA 5310 02638.SDR ASAA0640651Stringer · misdrilledMISDRILLED STRINGER. CUT OUT DAMAGED AREA AND INSTALLED REPAIR IAW SRM 53 00 03 AND EA 5310 02635.SDR ASAA0640650Floorbeam · corrodedFOUND FLOORBEAM CORRODED. REMOVED DAMAGED UPPER CHORD AND INSTALLED DOUBLER PER EA 53 20 01755.SDR ASAA0640649Floorbeam · corrodedFOUND CORRODED FLOORBEAM UPPER FLANGE. REPAIRED FLOORBEAM IAW EA 53 10 02634 AND ER 06 1946 AND SRM 53 80 08.SDR ASAA0640644Sill · corrodedFOUND CORROSION ON MOPSILL. REPLACED PER SRM 51 40 02.
Back to Boeing 737-4Q8