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 ASAA0944654Seat Track · gougedGOUGES IN SEAT TRACK UPPER FLANGE BS 500E+15 TO 500E+18. REMOVED AND REPLACED SEAT TRACK.SDR ASAA0944646Stringer Clip · crackedSTRINGER CLIP CRACKED BS 500G STR 26R. REMOVED AND REPLACED STRINGER CLIP.SDR ASAA0944645Stringer Splice · crackedCRACKED STRINGER SPLICE STA 907 STR 4R. REMOVED AND REPLACED STRINGER SPLICE.SDR ASAA0944643Stringer Clip · crackedSTRINGER CLIP CRACKED BS 500G STR 26R. REMOVED AND REPLACED STR CLIP.SDR ASAA0944631Sill · corrodedANGLE O/B OF R1 DOOR MOP SILL CORRODED. REMOVED CORRODED ANGLE, LOCATED DRILLED AND INSTALLED NEW ANGLE IAW B737 400 SRM 51 40 02.SDR ASAA0944910Skin · damagedDRILL MARKS ON INNER FUSELAGE SKIN STA 747 BETWEEN STRINGERS 8 9. BLENDED DRILL MARKS, FABRICATED AND INSTALLED REPAIR DOUBLER AND TEAR STRAP DOUBLER.SDR ASAA0944628Floor Support · corrodedCORROSION AT STA 787-807 RBL 20 FLOOR SUPPORT. CORROSION OUT OF LIMITS. REMOVED AND REPLACED SUPPORT STRAP PER SRM 53-60-15 AND 51-40-05.SDR ASAA0944627Frame · damagedFWD CARGO COMPARTMENT DRILL START ON FRAME. REPAIRED PER ER 09-1870 & EA 400-53EA-00989.SDR ASAA0944626Shear Tie · corrodedFWD CARGO COMPARTMENT CORROSION ON SHEAR TIE. REMOVED DAMAGED SHEAR TIE, FABRICATED REPAIR PARTS AND INSTALLED PER SRM 53-00-07 REPAIR 3.SDR ASAA0944625Web · wornOUTBOARD WALL OF RT RAM AIR INLET HAS 2 AREAS OF WEAR CAUSED BY BULB SEALS. REPAIRED O/B WALL OF RT RAM AIR INLET.SDR ASAA0944624Stop Fitting · scratchedFWD CARGO DOOR STOP PIN FITTING AT AFT BOTTOM CORNER IS SCRATCHED. REPAIRED PER ATS ER 09 1826 AND ASA 800 52EA 00790 BY BLENDING AREA AND RE-APPLYING PROTECTIVE FINISH.SDR ASAA0944623Frame · corrodedCORROSION ON AFT CARGO BAY LOWER AFT FLANGE OF FRAME ANGLE. REMOVED AND REPLACED FRAME ANGLE.SDR ASAA0944622Attach Bracket · crackedFWD CARGO COMP INTERCOSTAL ATTACH BRACKET CRACKED. REMOVED BRACKET, FABRICATED NEW BRACKET AND INSTALLED.SDR ASAA0944751Wedge · damagedLEFT INBOARD FLAP TRAILING EDGE WEDGE O/B END BENT / CRACKED. REMOVED DAMAGED AREA, FABRICATED FILLER AND DOUBLER BONDED REPAIR IAW B737 400 SRM 51 70 10.SDR ASAA0944613Seat Track · gougedGOUGES IN SEAT TRACK UPPER FLANGE BS 608 TO BS 612 RBL 25 WL 208. REMOVED AND REPLACED SEAT TRACK WITH NEW SEAT TRACK.SDR ASAA0944612Seat Track · gougedGOUGES IN SEAT TRACK UPPER FLANGE BS 541 RBL 45 WL 208. REMOVED AND REPLACED SEAT TRACK.SDR ASAA0944611Seat Track · gougedGOUGES IN SEAT TRACK UPPER FLANGE BS 570 TO BS 575 RBL 45 WL 208. REMOVED AND REPLACED SEAT TRACK.SDR ASAA0944608Seat Track · damagedMECHANICAL DAMAGE ON SEAT TRACK. REPLACED TRACK.SDR ASAA0944607Seat Track · damagedMECHANICAL DAMAGE ON SEAT TRACK. REPLACED SEAT TRACK.SDR ASAA0944606Seat Track · damagedMECHANICAL DAMAGE ON SEAT TRACK. REMOVED AND REPLACED SEAT TRACK.SDR ASAA0944605Seat Track · damagedMECHANICAL DAMAGE ON SEAT TRACK. REMOVED AND REPLACED SEAT TRACK.SDR ASAA0944610Skin · gougedGOUGE IN FUSELAGE EXTERNAL SKIN. REPAIRED SKIN PER SRM 53-00-01 REPAIR 31.SDR ASAA0944609Frame · crackedFRAME CRACKED AT I/B FASTENER HOLE FOR A/C BRACKET. REPAIRED CRACKED FRAME.SDR ASAA0944604Beam · crackedLONGITUDINAL BEAM CORNER CRACKED. REPAIRED CRACKED LONGITUDINAL BEAM PER EA 400-53EA-00978.SDR ASAA0944603Shear Web · corrodedSHEAR WEB BS 1016+4 RBL 25 WL 208. REMOVED AND REPLACED SHEAR WEB PER SRM 51-40-02.SDR ASAA0944739Skin · delaminatedFOUND DELAMINATION UNDER I/B ARROW ON UPPER SURFACE NR 4 GROUND SPOILER. REMOVED PREVIOUS REPAIR AND DAMAGED AREA FABRICATED FILLER AND DOUBLER AND INSTALLED REPAIR DOUBLERS IAW B737 400 SRM 51 70 10.SDR ASAA0944724Support · corrodedCORROSION ON FLOOR TO SIDEWALL SUPPORT AFT CARGO BAY. REPAIRED ON MIG 5.SDR ASAA0944614Support · corrodedCORROSION ON SUPPORT ZEE (FLOOR TO SIDEWALL SUPPORT) BS 727C +10 TO BS 767. REPLACED FLOOR TO SIDEWALL SUPPORT BS 727C +10 TO BS 767 PER SRM.SDR ASAA0944589Bracket · gougedAFT CARGO BAY BRACKET AT I/B OF CARGO GOUGED. REMOVED AND REPLACED BRACKET WITH FABRICATED BRACKET.SDR ASAA0944790Frame · corrodedFRAME STA 727D DENTED AND CORRODED ABOVE STR 25R. REMOVED DAMAGED AREA, FABRICATED, TREATED AND INSTALLED REPAIR ANGLE AND FILLER IAW B737 400 SRM 51 70 11.SDR ASAA0944725Support Angle · damagedLOWER RT SPLICE ANGLE AT BODY STATION 727+3 MISDRILLED HOLE. REMOVED AND REPLACED SUPPORT ANGLE.SDR ASAA0944662Intercostal · crackedLEFT O/B MID FLAP INTERCOSTAL CRACKED AT I/B FORE FLAP TRACK ROLLER. REMOVED CRACKED INTERCOSTAL, LOCATED DRILLED AND INSTALLED NEW INTERCOSTAL IAW B737 400 SRM 51 40 05.SDR ASAA0944660Skin · dentedLEFT INBOARD MID FLAP BULLNOSE DENTED 24 INCHES FROM I/B END. REMOVED DAMAGED SECTION, FABRICATED AND INSTALLED REPAIR DOUBLER IAW B737 400 SRM 57 53 01 FIG 201.SDR ASAA0944617Seat Track · gougedGOUGE IN SEAT TRACK UPPER FLANGE. REMOVED AND REPLACED SEAT TRACK.SDR ASAA0944616Seat Track · gougedGOUGE IN SEAT TRACK UPPER FLANGE. REPLACED SEAT TRACK BS 480-520 LBL 45 WL 208.SDR ASAA0944615Seat Track · gougedGOUGE IN SEAT TRACK UPPER FLANGE. REMOVED AND REPLACED SEAT TRACK.SDR ASAA0944593Frame · damagedFWD CARGO COMPARTMENT DRILL START IN FRAME. REPAIRED PER SRM 51-70-11.SDR ASAA0944592Bear Strap · crackedL1 DOOR LOWER HINGE CRACK INDICATION AT OPEN HOLE IN BEAR STRAP. REPAIRED L1 DOOR LOWER HINGE.SDR ASAA0944591Structure · corrodedUPPER CHORD CORRODED BS 1116 RBL 24 WL 238 APU COMPARTMENT. REMOVED AND REPLACED UPPER CHORD.SDR ASAA0944590Structure · corrodedBS 1126 RBL 24 WL 230 APU COMPARTMENT TEE CHORD IS CORRODED. REMOVED AND REPLACED TEE CHORD.SDR ASAA0944586Support · corrodedAFT CARGO SUPPORT CORROSION OUT OF LIMITS BS 832 LBL 22 WL 156. REMOVED AND REPLACED ZEE FROM BS 817-947.SDR ASAA0944585Web · corrodedAFT CARGO WEB CORROSION OUT OF LIMITS BS 867 RBL 22 WL 156. REPLACED WEB.SDR ASAA0944584Floor Support · damagedAFT CARGO FLOOR RT SUPPORT ZEE ELONGATED HOLES OUT OF LIMITS BS 847-947 RBL 22 WL 156. FLOOR TO SIDEWALL SUPPORT PLATE REMOVED AND REPLACED BS 867-947.SDR ASAA0944582Floor Support · corrodedAFT CARGO FLOOR SUPPORT CORROSION OUT OF LIMITS BS 823 RBL 3 WL 156. REPAIRED BY REPLACING SUPPORT ANGLES PER SRM 53-00-53.SDR ASAA0944581Support Bracket · crackedNOSE GEAR VIEWER SUPPORT BRACKET IS CRACKED AT BS 260 RBL 4. REMOVED AND REPLACED NOSE GEAR VIEWER SUPPORT BRACKET.SDR ASAA0944580Floorbeam · corrodedCORROSION ON FLOORBEAM AT BS 270 RBL 10 LBL 10 WL 207. REMOVED UPPER ZEE CHORD, FABRICATED & INSTALLED NEW ZEE CHORD PER SRM 51-40-02.SDR ASAA0944579Structure · corrodedBS 1116 RBL 24 LOWER CHORD IS CORRODED. REMOVED AND REPLACED LOWER CHORD.SDR ASAA0944578Floor Support · corrodedAFT CARGO RT SUPPORT ZEE CORROSION OUT OF LIMITS BS 867-947 RBL 22 WL 156. REMOVED AND REPLACED FLOOR SUPPORT.SDR ASAA0944577Floor Support · corrodedAFT CARGO FLOOR SUPPORT CORROSION OUT OF LIMITS BS 812 LBL 3 WL 156. REPAIRED BY REPLACING SUPPORT ANGLES PER SRM 53-00-53.SDR ASAA0944576Support · corrodedFWD CARGO BULKHEAD SUPPORT BS 500G WL 160 STR LBL 34 CORROSION OUT OF LIMITS. REMOVED AND REPLACED SUPPORT PER SRM 53-30-53 AND 51-40-02.
Back to Boeing 737-4Q8