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 ASAA0944277Skin · dentedDENT ON LT IB FLAP. REPAIRED DENTS ON LT IB AFT FLAP LOWER SURFACE IAW B737 400 SRM 51 70 10.SDR ASAA0944252Guide Arm · looseL1 DOOR HARD TO OPEN & CLOSE. FOUND L 1 DOOR GUIDE ARM LOOSE & OUT OF ADJUSTMENT. R&R GUIDE ARM & ADJUSTED REF. AMM 52 11 21 004 404 007 015 B00. L 1 DOOR STILL HARD TO CLOSE REMOVED DOOR LINER & ADJUSTED HORZ ROD & ALL DOOR STOP PINS REF. AMM 52 11 21 004SDR ASAA0944468Skin · dentedRT WING I/B GROUND SPOILER NR 5 UPPER SURFACE HAS DENT AT O/B CORNER. PREPPED DAMAGED AREA, FABRICATED FILLER AND DOUBLER AND INSTALLED REPAIR PARTS IAW B737 400 SRM 51 70 10 REPAIR 4.SDR ASAA0944373Frame · gougedAFT PIT BS 727 JUST BELOW STRINGER 25L FRAME GOUGED AT FWD TOP. CUT OUT DAMAGED AREA. FABRICATED REPAIR PARTS AND INSTALLED REPAIR IAW B737 400 SRM 51 70 11.SDR ASAA0944372Frame · crackedAFT PIT BS 767 FRAME FWD FACE IS CRACKED BETWEEN S27R AND S 28R. REMOVED DAMAGED FRAME SHEAR TIE. FABRICATED REPAIR PARTS AND INSTALLED REPAIR PARTS IAW B737 400 SRM 53 00 07.SDR ASAA0944312Doubler · delaminatedLT WING OB AFT FLAP TRAILING EDGE REPAIR DOUBLER IS DELAMINATED AT IB CORNER. REPAIR LT OB AFT FLAP IB DAMAGE IAW B737 400 SRM 51 70 10 REPAIR 4.SDR ASAA0944319Frame · corrodedAFT PIT AT BS 867 STRINGER 27L STRINGER 28R FRAME CORRODED. REPAIRED FRAME AT BS 867 IAW B737 400 SRM 53 00 07 FIG 1.SDR ASAA0944253Shear Tie · crackedSHEAR CLIP CRACKED STR 4L STA 807. REMOVED CRACKED SHEAR CLIP AND INSTALLED NEW IAW SRM 51-40-02 PG 30 AND 51-40-02 PG2.SDR ASAA0944450Shear Tie · corrodedCORROSION IN FWD CARGO COMPARTMENT ON SHEAR CLIP FS 500A BETWEEN STR 26L & 27L. CUT OUT DAMAGED AREA, FABRICATED REPAIR DOUBLER FILLER AND INSTALLED REPAIR PARTS IAW B737 400 SRM 53 00 07 AND 51 40 02.SDR ASAA0944446Angle · corrodedLT AT DOOR LOWER CUTOUT AREA Z-ANGLE (MOP SILL) IS CORRODED MULTIPLE PLACES FS 967 TO FS 986. REMOVED CORRODED Z-ANGLE AND INSTALLED NEW MOPSILL IAW B737 400 SRM 51 40 02.SDR ASAA0944413Angle · corrodedL2 DOOR LOWER CUTOUT AREA Z ANGLE IS CORRODED IN MULTIPLE PLACES FS 967 TO 986. MOVED CORRODED ZEE ANGLE AND INSTALLED NEW ZEE ANGLE IAW B737 400 SRM 51 40 02.SDR ASAA0944379Shear Tie · corrodedCORROSION IN FWD CARGO COMPARTMENT. ON SHEAR TIE CLIP FS 500A BETWEEN STRINGER 28R AND 28L. FABRICATED SHEAR CLIP AND REPAIR PARTS AND INSTALLED IAW SRM 53-30-07 AFTER CUTTING OUT DAMAGED AREA IAW SRM 53-00-07.SDR ASAA0944374Fitting · corrodedCORROSION IN FWD CARGO COMPARTMENT ON SHEAR CLIP STA 500C BETWEEN STRINGER 28R AND 28L. REMOVED PREVIOUS REPAIR. FABRICATED NEW REPAIR PART AND INSTALLED REPAIR PART IAW B737 400 SRM 53 00 07.SDR ASAA0944332Skin · dentedLT WING OB FORE FLAP HAS A DENT UPPER SURFACE 95" FROM OB END. REPAIRED DENT DAMAGE IAW B737 400 SRM 51 70 10 REPAIR 2.SDR ASAA0944335Shear Tie · corrodedCORROSION IN FWD CARGO COMPARTMENT ON SHEAR TIE CLIP STA 500A BETWEEN STRINGER 28R AND STRINGER 27R. REMOVED CORROSION AND FABRICATED REPAIR DOUBLER. INSTALLED IAW B737 400 SRM 53 00 07.SDR ASAA0944333Floorbeam · corrodedAFT GALLEY AREA FLOORBEAM UPPER SURFACE CORRODED AT FS 967 RBL 16. REMOVED CORROSION REPAIRED FLOORBEAM IAW EA EA 400-53, EA 00544.SDR ASAA0944313Skin · dentedLT WING NR 1 SPOILER DENTED ON UPPER SURFACE 3 INCHES FROM LE AND 20 INCHES FROM OB EDGE A= .400 Y=.027 A/Y=14.81. REPAIRED DENT DAMAGE ON UPPER SURFACE OF NR 1 SPOILER IAW B737 400 SRM 51 70 10 REPAIR 2.SDR ASAA0944316Shear Tie · corrodedFWD CARGO COMPT. PREVIOUS BLEND OUT SHEAR CLIP STA 500B BETWEEN S 28R 27R SUSPECTED OUT OF LIMITS. REMOVED CORROSION FOUND TO BE OUT OF LIMITS IAW B737 400 SRM 53 00 07 FIG 101. FABRICATED AND INSTALLED REPAIR DOUBLER IAW B737 400 SRM 53 00 07.SDR ASAA0944315Shear Tie · corrodedCORROSION IN FWD CARGO COMPARTMENT ON SHEAR CLIP STA 500B BETWEEN STR 28R AND STR 28L. FOUND CORROSION ON PREVIOUS REPAIR ANGLE REMOVED AND FABBED REPAIR ANGLE AND INSTALLED IAW SRM 53-00-07.SDR ASAA0944314Shear Tie · corrodedCORROSION IN FWD CARGO COMPARTMENT ON SHEAR CLIP STA 500E BETWEEN STR 28L AND STR 27L. REMOVED CORROSION FOUND TO BE OUT OF LIMITS REPAIRED IAW B737 400 SRM 53 00 07.SDR ASAA0944227Skin · damagedMISS DRILLED HOLE SKIN STA 260. REPAIRED PER ASA EA 400 53EA 00474.SDR ASAA0944226Repair · damagedPREVIOUS FLUSH REPAIR AT BS 259 SPLICE AND STR 17L. REPAIRED PER ASA EA 400 53EA 00474.SDR ASAA0944461Stringer Splice · corrodedFWD CARGO COMPARTMENT BETWEEN FS 500G AND FS 520 STR 28R HAS CORROSION. CUT OUT DAMAGED AREA, FABRICATED REPAIR ANGLE AND FILLER INSTALLED REPAIR PARTS IAW B737 400 SRM 53 30 12.SDR ASAA0944383Skin · dentedLT WING OB MID FLAP HAS A DENT AT UPPER SURFACE 119 INCHES FROM OB END. REMOVED DAMAGED SKINS AT 117" AND 119" FROM OB END. FABRICATED DOUBLERS INSTALLED REPAIR DOUBLERS IAW B737 400 SRM 51 70 10.SDR ASAA0944382Skin · dentedLT WING OB MID FLAP HAS A DENT AT UPPER SURFACE 81 INCHES FROM OB END. REMOVED DAMAGE AT 75" AND 81" FROM OB END. FABRICATED DOUBLERS AND BONDED REPAIR DOUBLERS IAW B737 400 SRM 51 70 10.SDR ASAA0944381Stringer Clip · crackedSTRINGER TIE AT FS 1006 ON STRINGER 12L CRACKED. R&R CRACKED STRINGER CLIP IAW SRM 51-40-02.SDR ASAA0944380Shear Tie · crackedINSIDE FUSELAGE BETWEEN STRINGER 12R AND 13R JUST FWD OF FS 291.5 FRAME ATTACH ANGLE IS CRACKED. R&R CRACKED ANGLE IAW SRM 51-40-02.SDR ASAA0944371Stringer Clip · crackedSTRINGER TIE AT FS 1006 ON STR 13L IS CRACKED. R&R STRINGER CLIP IAW B737 400 SRM 51 40 02.SDR ASAA0944370Stringer Clip · crackedCABIN FS 706 STR 11R FRAME CLIP IS CRACKED. REMOVED DAMAGED AREA. FABRICATED AND INSTALLED STRINGER CLIP IAW B737 400SRM 51 40 02.SDR ASAA0944369Stringer Clip · crackedSTRINGER TIE AT FS 1006 ON STRINGER 10L CRACKED. R&R STRINGER CLIP IAW B737 400SRM 51 40 02.SDR ASAA0944368Stringer Clip · crackedSTRINGER TIE AT FS 1006 ON STRINGER 11L CRACKED. R&R STRINGER CLIP IAW B737 400SRM 51 40 02.SDR ASAA0944467Skin · dentedRT WING IB FOREFLAP LOWER SURFACE HAS AREAS OF MULTIPLE SMALL DENTS IN LINE WITH NR 3 AND NR 4 TIRES. REMOVED PREVIOUS REPAIRS FABRICATED REPAIR DOUBLER AND BONDED REPAIR DOUBLER IAW B737 400 SRM 51 70 10 REP 4.SDR ASAA0944464Skin · chafedLT NR 3 SLAT INBD AFT LOWER CORNER CHAFED. REMOVED DAMAGED AREA FABRICATED REPAIR DOUBLER BONDED REPAIR DOUBLER IAW B737 400 SRM 51 70 10 .SDR ASAA0944317Skin · dentedRT WING NR 5 SPOILER DENTED ON LOWER SURFACE 12 " FROM TE AND 36" FROM IB EDGE. REPAIRED DENT DAMAGE ON LOWER SURFACE OF NR 5 SPOILER IAW B737 400 SRM 51 70 10 REPAIR 2.SDR ASAA0944284Shear Tie · corrodedSHEAR TIE CORRODED AT STA 727C BETWEEN STR 25 AND 26 LT. ACCOMPLISHED SHEAR TIE REPAIR FOR FRAME 727C STR 25 AND 26 LT IAW B737 400 SRM 53 00 07 REPAIR 5.SDR ASAA0944281Shear Tie · corrodedFOUND SHEAR TIE CORRODED STA 727B BETWEEN STR 25 26 LT. REPAIRED SHEER TIE AT STA 727B BETWEEN STR 25 26 LT IAW B737 400 SRM 53 00 07 FIG 201.SDR ASAA0944225Skin · dentedFUSELAGE SKIN DENT 4" AFT OF LT FUSELAGE SENSOR. REPAIRED PER ATS ER 08 4027 ASAS EA 400 53EA 00474.SDR ASAA0944211Plate · corrodedCORROSION FWD ENTRY DOOR UPPER HINGE LOWER GUIDE PLATE. REPLACED GUIDE PLATE.SDR ASAA0944198Bushing · migratedRT PYLON DIAGONAL BRACE AFT OB FUSE PIN BUSHING MIGRATED. R&R DIAGONAL BRACE.SDR ASAA0944318Skin · dentedLT WING NR 2 SPOILER LOWER OB SURFACE HAS A CLUSTER OF DENTS. REPAIRED NR 2 SPOILER IAW B737 400 SRM 51 70 10 REPAIR 2.SDR ASAA0944200Intercostal · corrodedCORROSION ON UPPER FLANGE OF INTERCOSTAL BETWEEN FRAMES AT BS 767 787 RBL 24. BLENDED CORROSION 1X2 .050" REMAINING THICKNESS. .000 REMAINING. OUT OF LIMITS R&R PER 51 40 02.SDR ASAA0944199Torque Tube · gougedFWD ENTRY DOOR FUSELAGE TORQUE TUBE IS GOUGED. R&R FWD ENTRY DOOR FUSELAGE TORQUE TUBE.SDR ASAA0944307Skin · delaminatedRT IB FLAP OUTER SKIN PANEL HAS 2 AREAS OF DELAMINATION. REPAIRED RT IB OUTER SKIN DAMAGE ON FLAP IAW B737 400 SRM 51 70 10 REPAIR 3 PG 201.SDR ASAA0944278Skin · dentedLT AFT IB TE FLAP UPPER SURFACE DENTED APPROX 3" IB OF OB EDGE 9" FWD OF AFT EDGE. REPAIRED LT AFT IB TE FLAP UPPER SURFACE IAW SRM 51-70-10.SDR ASAA0944191Skin · dentedLT OB FORE FLAP HAS A DENT FROM CHAFING OB OF NR 1 FORE FLAP TRACK. R&R EXISTING REPAIR DOUBLER REQUIRES REPAIR FASTENER INSPECTIONS AT EVERY C CHECK.SDR ASAA0944183Threshold · damagedFOUND MISDRILLED HOLE IN THRESHOLD WEB AND LOWER STRAP IN AFT CARGO BAY BS 845 RBL 23. R&R THRESHOLD WEB AND LOWER STRAP.SDR ASAA0944182Threshold · damagedFOUND MISDRILLED HOLE IN THRESHOLD WEB AND LOWER STRAP IN AFT CARGO BAY BS 845 RBL 23. R&R THRESHOLD WEB AND LOWER STRAP IN AFT CARGO.SDR ASAA0944276Frame · dentedFOUND STA 807 FRAME BENT AT RADIUS JUST ABOVE STR 24L. REMOVED DAMAGED AREA OUT LIMITS FABRICATED NEW PART TREATED PRIMED TOP COATED AND INSTALLED REPAIR IAW B737 400 SRM 51 40 02.SDR ASAA0944213Skin · crackedNR 1 SLAT LWR SKIN CRACKED AT MIDDLE AUX TRACK 4 FASTENER HOLES. REPAIRED USING DOUBLER SPLICE PLATE AND FILLER.SDR ASAA0944274Skin · chafedNR 4 SLAT IB TE LOWER SURFACE CHAFFED ALL THE WAY THROUGH. REPAIRED NR 4 SLAT IB TE LOWER SURFACE IAW B737 400 SRM 51 70 10.
Back to Boeing 737-4Q8