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 ASAA11410180Web · crackedWEB CRACKED AT BS 648.5 847 S27R WL 140. REMOVED CRACKED WEB INTERCOSTAL FABRICATED WEB AND ATTACHING STIFFENERS STRAPS. INSTALLED PARTS PER SRM 53 60 15 REPAIR 1 AND SRM 51 40 02.SDR ASAA11410135Web · crackedWEB CRACKED AT BS 845.5 847 S27R WL 140.SDR ASAA11410136Skin · crackedFUSELAGE SKIN HAS A SUBSURFACE CRACK AT BS 727D+3 JUST BELOW STR 23R. ACCOMPLISHED FUSELAGE SKIN REPAIR PER ASA ER 11 03655 ASA EA 400 533A 06137.SDR ASAA11410053Keelbeam · corrodedCORROSION LT W/W LT KEEL BEAM HAS CORROSION AT SURROUNDING AREAS OF NUT PLATES FROM BS 674 BS 727 WL 148 (LOWER SURFACE OF LOWER CHORD). REMOVED NUT PLATES BLENDED CORROSION. DAMAGE ALL WITHIN LIMITS. REFINISHED SURFACES AND REPLACED NUT PLATES PER B737 400SDR ASAA11410048Floorbeam · crackedLONGITUDINAL FLOORBEAM UPPER CHORD IS CRACKED AT BS 665 BL 0 WL 208. REPAIRD LONGITUDINAL FLOORBEAM UPPER CHORD PER ASA EA 400 57EA 06079.SDR ASAA11410013Floor Support · crackedFLOOR SUPPORT IS CRACKED AT BS 359 BL 0 WL 208. REMOVED AND REPLACED INTERCOSTAL PER B737 400 SRM 51 40 02.SDR KNN2011F00000Proximity Switch · out of toleranceAFTER T/O THE LANDING GEAR WOULD NOT GO UP. GEAR HANDLE WOULD NOT PASS THROUGH THE "OFF" POSITION. ACFT AIR RETURNED AND MX T/S FOUND GAP ON MLG SAFETY SENSOR (PROX SWITCH) TO TARGET EXCEEDING TOLERANCE.SDR ASAA1149962Stringer Clip · crackedSTRINGER CLIP CRACKED STA 500F STR 5R. REMOVED AND REPLACED CLIP IAW ASA DWG A53100265816.SDR ASAA11410082Shear Tie · corrodedE&E BAY STA 360 SHEAR TIE CORRODED FROM STR 28L TO 29L FWD SIDE. REMOVED FABRICATED NEW AND INSTALLED SHEAR TIE IAW B737 400 SRM 51 40 02.SDR ASAA11410076Shear Tie · corrodedE AND E BAY FRAME STA 360 SHEAR TIE CORRODED FROM STR 28R TO 29R. REMOVED, FABRICATED, TREATED, PRIMED, TOPCOATED AND INSTALLED SHEAR TIE IAW B737 400 SRM 51 40 02.SDR ASAA1149963Doubler · crackedLT WING I/B FOREFLAP HAS CRACKED REPAIR DOULBER ON UPPER SURFACE JUST O/B OF MIDSPAN. REPAIRED DAMAGE TO UPPER SURFACE AND CORE OF LT WING I/B FOREFLAP IAW B737 400 SRM 57 53 02 AND SRM 51 70 10.SDR ASAA1149986Frame · corrodedE&E BAY FRAME STA 380 SHEAR TIE CORRODED FROM STRINGER 28L TO 28R. REMOVED AND REPLACED FRAME AT STA 380 FROM STR 25L TO 25R LOWER SECTION IAW B737 400 SRM 51 40 02.SDR ASAA1149961Stringer Clip · crackedSTRING CLIP CRACKED AT STA 887 STRINGER 4L. REMOVED AND REPLACED CLIP IAW ASA DWG A53100265816.SDR ASAA1149960Stringer Clip · crackedSTRINGER CLIP CRACKED AT STA 807 STR 4L. REMOVED AND REPLACED CLIP IAW ASA DWG A53100265816.SDR ASAA1149959Stringer Clip · crackedSTRINGER CLIP CRACKED AT STA 827 STR 4L. REMOVED AND REPLACED CLIP IAW ASA DWG A53100265816.SDR ASAA11410143Doubler · corrodedCORROSION IN AFT PIT STA 967 ON INTERNAL DOUBLER. REPAIRED INTERNAL DOUBLER IAW ASA EA 400 53EA 05911.SDR ASAA11410142Frame · corrodedAFT PIT STA 1006 FRAME CORRODED BETWEEN STR 23L AND 21L. REPAIRED FRAME IAW ASA EA 400 53EA 05908.SDR ASAA11410078Stiffener · corrodedAPU COMPT AIR INLET TORQUE BOX INLET LOWER AFT FLANGE (OUTBOARD SIDE) VIEWED FROM INSIDE TORQUE BOX ABOVE BLEED AIR DUCT CORRODED AFT OF STA 1121. REMOVED CORRODED STIFFENER AND REPLACED WITH FABRICATED STIFFENER IAW B737 400 SRM 53 80 15.SDR ASAA11410093Failsafe · corrodedFRAME 827 CORRODED AT STR 22L AFT SIDE. REMOVED CORROSION AND REPAIRED FAIL SAFE CHORD IAW ASA EA 40053EA 05872.SDR ASAA11410134Stringer · corrodedAPU COMPTAIR INLET TORQUE BOX INLET LOWER AFT FLANGE FOUND CORRODED AFT OF STA 1121. REPLACED STRINGER IAW B737 400 SRM 53 80 15 FIG 101 51 40 02 FIG 8 AND 51 40 12 PAGES 2 AND 3.SDR ASAA11410086Trans Panel · corrodedTRANSITION PANEL FOUND CORRODED AFT OF FRAME STA 787 AND LBL 21.8. REPLACED TRANSITION PANEL IAW B737 400 SRM 53 60 53 FIG 201.SDR ASAA11410088Frame · corrodedFRAME STA 867 CORRODED AT STRINGER 22L TO 23L. REMOVED DAMAGED SECTION FABRICATED REPAIR PARTS AND INSTALLED IAW ASA EA 40053EA05865.SDR ASAA11410075Frame · corrodedFRAME 787 CORRODED AT FRONT SIDE AT STR 25L TO 27L. PERFORMED SHEAR TIE REPAIR AT FS 787 BETWEEN STRINGER 25L AND 27L IAW B737 400 SRM 53 00 07 FIG 201.SDR ASAA11410067Frame · corrodedFRAME FS 767 CORRODED ON AFT SIDE BETWEEN STRINGER 25R 26L. REMOVED FABRICATED AND INSTALLED FAIL SAFE ANGLE ON FRAME 767 IAW B737 400 SRM 53 60 07 FIG 1 AND 51 40 02 PAGES 2 AND 3.SDR ASAA11410023Frame · corrodedFRAME 747 CORRODED AT STR 25R 27R. REPAIRED FRAME IAW B737 400 SRM 53 00 07 FIG 201. THIS IS A CATEGORY B REPAIR REQUIRING REPEAT INSP AT 66 000 TOTAL FLIGHT CYCLES.SDR ASAA11410021Frame · corrodedFRAME 827 CORRODED AT STR 26L 27R. REPAIRED FRAME 827 IAW B737 400 SRM 53 00 07 FIG 201. THIS IS A CATEGORY B REPAIR AND REQUIRES REPEAT INSP AT 66 000 TOTAL FLIGHT CYCLES.SDR ASAA11410010Frame · corrodedAFT CARGO COMPARTMENT FRAME STA 747 CORRODED AT 25L. REPAIRED SHEAR TIE AT STA 747 STR 25L IAW B737 400 SRM 53 00 07 FIG 201.SDR ASAA11410009Frame · corrodedAFT CARGO COMPARTMENT FRAME STA 767 CORRODED AT STR 25L TO 26L. REPAIRED SHEAR TIE AT STA 767 BETWEEN STR 25L TO 26L IAW B737 400 SRM 53 00 07 FIG 201 REPAIR 1.SDR ASAA11410008Cargo Track · corrodedCARGO COMPARTMENT TRACK CORRODED AT FS 946 RBL 18. INSTALLED CARGO TRACK REPAIR IAW SRM B737 400 SRM 53 60 53.SDR ASAA11410006Shear Tie · corrodedSHEAR TIE CORRODED AT FS 927 STR 27R TO 27L. FABRICATED, DRILLED, TREATED AND INSTALLED SHEAR TIE REPAIR IAW B737 400 SRM 53 00 07 FIG 201.SDR ASAA11410003Shear Tie · corrodedSHEAR TIE CORRODED AT STR 27L TO 27R FS 887. FABRICATED, DRILLED, TREATED AND INSTALLED SHEAR TIE REPAIR IAW B737 400 SRM 53 00 07 FIG 201.SDR ASAA11410000Shear Tie · corrodedSHEAR TIE CORRODED AT FS 807 STR 27R 27L. FABRICATED, DRILLED, TREATED AND INSTALLED SHEAR TIE IAW B737 400 SRM 53 00 07 FIG 201.SDR ASAA1149999Stringer Clip · corrodedSTRINGER TIE BS 787 STR 26R CORRODED. REMOVED AND REPLACED WITH NEW STRINGER TIE PER B737 400 SRM 53 00 03.SDR ASAA1149998Stringer Clip · corrodedCORRODED STRINGER TIE BS 767 STR 26R. REMOVED AND REPLACED WITH NEW STRINGER TIE PER B737 400 SRM 53 00 03.SDR ASAA1149997Frame · corrodedFRAME STA 807 CORRODED AT STR 24L TO 26L (AFT CARGO COMPARTMENT). REPAIRED SHEAR TIE AT STA 807 BETWEEN STR 24L TO 26L IAW B737 400 SRM 53 00 07 FIG 201.SDR ASAA1149978Stringer · corrodedIN AFT PIT STA 1013 STR 22L FOUND CORRODED. REPAIRED STRINGER IAW B737 400 SRM 53 00 01 FIG 201.SDR ASAA1149977Attach Fitting · corrodedIN AFT PIT STA 1016 STRINGER ATTACH FITTING FOUND CORRODED. REMOVED AND REPLACED FITTING IAW B737 400 SRM 51 40 02 FIG 2.SDR ASAA1149958Stringer Clip · corrodedAFT CARGO STRINGER AT 25L FOUND CORRODED AT STA 747. REMOVED AND REPLACED STRINGER CLIP IAW B737 400 SRM 51 40 02 STEP 4.SDR ASAA1149957Support Angle · crackedAFT PIT AFT BULKHEAD LOWER SUPPORT ANGLE CORRODED. REMOVED CORROEDED ANGLE. FABRICATED AND INSTALLED NEW ANGLE IAW B737 400 SRM 51 40 02 FIG.2.SDR ASAA1149956Support Angle · corrodedAFT PIT AFT BULKEAD LOWER SUPPORT ANGLE CORRODED. REMOVED CORRODED ANGLE, FABRICATED AND INSTALLED NEW ANGLE IAW B737 400 SRM 51 40 02 FIGURE 2.SDR ASAA1149955Stringer Clip · crackedSTRINGER CLIP CRACKED AT STA 727E STRINGER 7R. REMOVED AND REPLACED CLIP IAW ASA DWG A53100265816.SDR ASAA1149954Stringer Clip · crackedSTRINGER TIE CRACKED AT STA 727A AND STRINGER 5L. REMOVED AND REPLACED CLIP IAW ASA DWG A53100265816.SDR ASAA1149953Stringer Clip · crackedSTRINGER TIE CRACKED STA 727D STRINGER 5R. REMOVED AND REPLACED CLIP IAW ASA DWG A53100265816.SDR ASAA1149952Stringer Clip · crackedSTRINGER TIE CRACKED AT 727B STRINGER 4R. REMOVED AND REPLACED CLIP IAW ASA DWG A53100265816.SDR ASAA1149951Stringer Clip · crackedSTRINGER CLIP STA 727C STRINGER 6L CRACKED. REMOVED AND REPLACED CLIP IAW ASA DWG A53100265816.SDR ASAA1149950Stringer Clip · crackedSTRINGER TIE CRACKED AT STA 272A STRINGER 6L. REMOVED AND REPLACED CLIP IAW ASA DWG A53100265816.SDR ASAA1149949Stringer Clip · crackedSTRINGER CLIP CRACKED AT STA 727A STRINGER 7R. REMOVED AND REPLACED CLIP IAW ASA DWG A53100265816.SDR ASAA1149948Stringer Clip · crackedSTRINGER CLIP CRACKED AT STA 727F STRINGER 4R. REMOVED AND REPLACED CLIP IAW ASA DWG A53100265816.SDR ASAA1149947Stringer Clip · crackedSTRINGER CLIP CRACKED AT STA 727C STRINGER 7R. REMOVED AND REPLACED CLIP IAW ASA DWG A53100265816.SDR ASAA1149946Stringer Clip · crackedSTRINGER CLIP CRACKED AT STA 727B STRINGER 7R. REMOVED AND REPLACED CLIP IAW ASA DWG A53100265816.
Back to Boeing 737-4Q8