Boeing 737-3Q8
Service difficulty reports · 4,188
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 = '7373Q8' 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 = '7373Q8' 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 CALA0100187Skin · gougedINSPECTION FOUND FUSELAGE SKIN GOUGED JUST AFT OF RIGHT LOWER HORIZONTAL LUG AT STA 1150. THE DAMAGED SKIN WAS REMOVED AND REPLACED IAW SRM 51-40-01.SDR CALA0100173Doubler · corrodedINSPECTION FOUND LOWER STRAP DOUBLER CORRODED AT LOWER DOOR JAMB, STA 787 - 796. THE STRAP DOUBLER WAS REMOVED AND REPLACED IAW SRM 51-10-02.SDR SWAA010569Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 294.5, BETWEEN STR 1R & 2R. REPAIRED FRAME PER SRM.SDR SWAA010568Splice · crackedDURING SCHEDULED D-CHECK, FOUND STR SPLICE CHANNEL CRACKED AT BS 360, STR 4L. REMOVED AND REPLACED STR SPLICE CHANNEL PER SRM.SDR SWAA010565Flap · brokenDURING SCHEDULED SERVICE CHECK, FOUND LT WING L/E NR 1 KRUEGER FLAP OUTBD END BROKEN AT SPRING LOADED FLAP DOOR. REMOVED AND REPLACED KRUEGER FLAP PER MM.SDR CALA0100164Fitting · separatedINSPECTION FOUND LT ELEVATOR HORN BEARING FITTING SEPARATED. THE LT ELEVATOR WAS REMOVED AND REPLACED IAW MM 27-31-11.SDR CALA0100158Floor Support · corrodedINSPECTION FOUND FLOOR SUPPORT CORRODED AT STA 500D BETWEEN S26L AND S26R. THE FLOOR SUPPORT WAS REMOVED AND REPLACED IAW SRM 51-10-02.SDR CALA0100156Bracket · crackedINSPECTION FOUND A 1 INCH CRACK IN PANEL SUPPORT BRACKET AT PRESSURE BULKHEAD STA 727, JUST ABOVE STRINGER 27R. A FORMED SECTION REPAIR WAS INSTALLED IAW SRM 51-70-11.SDR SWAA010533Fitting · corrodedDURING SCHEDULED D-CHECK, FOUND LT MLG STABILIZER BEAM FITTING CORRODED AT SUPPORT BEAM. REMOVED AND REPLACED FITTING PER MM.SDR SWAA010530Stringer · crackedDURING SCHEDULED D-CHECK, FOUND STR 6R CRACKED AT BS 520. REPAIRED STRINGER PER SRM.SDR SWAA010529Frame · crackedDURING SCHEDULED D-CHECK, FOUND FWD SVC DOOR CUTOUT FWD LOWER FRAME CRACKED AT INBD LOWER CORNER. REPAIRED FRAME PER SRM.SDR SWAA010528Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND STR CLIPS CRACKED AT STR 6R, BS 500D & BS 520. REMOVED AND REPLACED STR CLIPS PER SRM.SDR SWAA010526Bulkhead · crackedDURING SCHEDULED D-CHECK, FOUND BS 178 BULKHEAD WEB CRACKS AT RBL 17.1, WL 163 & LBL 17.1, WL 229. REPAIRED BULKHEAD WEB PER BFG ER.SDR SWAA010527Frame · corrodedDURING SCHEDULED D-CHECK, FOUND BS 727 CHORD CORRODED AT BL 0, WL 148. REPAIRED CHORD PER SRM.SDR SWAA010505Frame · crackedDURING SCHEDULED D-CHECK, FOUND FWD SVC DOOR CUTOUT FWD UPPER FRAME CRACKED AT UPPER INBD RADIUS, BS 296.5, WL 274. REPAIRED UPPER FRAME PER SRM.SDR SWAA010504Shear Tie · crackedDURING SCHEDULED D-CHECK, FOUND SHEAR TIE CRACKED AT BS 360, BETWEEN STR 13L & 14L.SDR SWAA010503Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME CRACKED AT BS 500D, 2 ABOVE STR 13R. REPAIRED FRAME PER SRM.SDR CALA0100142Intercostal · crackedINSPECTION FOUND A 1 INCH CRACK IN INTERCOSTAL AT STA 380 - 400, BL 0. A NEW INTERCOSTAL WAS INSTALLED IAW SRM 53-30-51 AND 51-10-02.SDR CALA0100140Intercostal · crackedINSPECTION FOUND A 1 INCH CRACK AT NUTPLATE HOLE IN INTERCOSTAL AT STA 927 - 947, BL 0. THE INTERCOSTAL WAS REPLACED IAW SRM 53-60-51, FIGURE 1, SHEET 7.SDR CALA0100134Floor Support · crackedINSPECTION FOUND FLOOR SUPPORTS CRACKED AT STA 540, LBL 1 AND RBL 1. THE CRACKS WERE 1 INCH LONG. THE FLOOR SUPPORTS WERE REMOVED AND REPLACED IAW SRM 51-10-02.SDR SWAA010488Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND 12 STRINGER CLIPS CRACKED, BS 559-BS 727A, STRINGERS 10L, 5R, 8L, 5L, 4L, 1, 2L, 6R, 7R, 3L & 6L. REMOVED AND REPLACED CLIPS PER SRM.SDR SWAA010487Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER CLIPS CRACKED, BS 500B, STR 9L, BS 500D, STR 5L, BS 520, STRS 5R, 6L & 8L, BS 1121, STR 21L. REMOVED AND REPLACED CLIPS PER SRM.SDR SWAA010486Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727E, STR 21R. REPAIRED FRAME PER SRM.SDR SWAA010476Bulkhead · crackedDURING SCHEDULED D-CHECK, FOUND BS 178 BULKHEAD CRACKED, LBL 4.7, WL 212-213. REPAIRED BULKHEAD PER SRM.SDR SWAA010453Bulkhead · crackedDURING SCHEDULED D-CHECK, FOUND BS 178 BULKHEAD WEB CRACKS AT LBL 12 TO LBL 13, WL 218 & RBL 6.7, WL 200 TO WL 201. REPAIRED BULKHEAD WEB PER SRM.SDR SWAA010464Shear Tie · crackedDURING SCHEDULED D-CHECK, FOUND SHEAR TIE CRACKED AT BS 520, BETWEEN STR 15L & 16L. REPAIRED SHEAR TIE PER SRM.SDR SWAA010463Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND STR CLIPS CRACKED AT BS 380, STR 8L, BS 520, STR 16L, BS 500D, STR 3L, 6L, 7L, 8L, 5R, & 8R, BS 500C, STR 7R, BS 360, STR 5L, BS 360, STR 2L, BS 344, STR 11R, BS 639, STR 8L, BS 597, STR 8R, & BS 663.75, STR 10R. REMOVED AND RESDR SWAA010462Shear Tie · crackedDURING SCHEDULED D-CHECK, FOUND SHEAR TIE CRACKED AT BS 1040, BETWEEN STR 2L & 3L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA010433Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND STR CLIPS CRACKED AT STR 8R, BS 578 & 637, STR 7R, BS 557, STR 8L, BS 616, STR 4R, BS 616, & STR 6L BS 597 & 616. REMOVED AND REPLACED STR CLIPS PER SRM.SDR SWAA010454Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND STR CLIPS CRACKED AT BS 616, STR 3R, BS 639, STR 4R & BS 706, STR 2L. REMOVED AND REPLACED STR CLIPS PER SRM.SDR SWAA010465Bracket · corrodedDURING SCHEDULED D-CHECK, FOUND BOTH FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT BAR FLOOR BRACKETS CORRODED. REMOVED AND REPLACED BRACKETS PER SRM.SDR SWAA010412Slide · out of adjDURING SCHEDULED C2 CHECK, FOUND FWD ENTRY DOOR EMEGRENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. RE-ADJUSTED EVAC SLIDE ASSY PER MM.SDR SWAA010411Cover · looseDURING SCHEDULED C2 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY RETAINER HOOKS LOOSE. REMOVED AND REPLACED EVAC SLIDE COVER ASSY PER MM.SDR SWAA010405Stiffener · crackedDURING SCHEDULED SPECIAL VISIT, FOUND BS 663 VERTICAL STIFFENERS CRACKED AT LBL 6.5 & RBL 6.5. REMOVED AND REPLACED VERTICAL STIFFENERS PER SRM.SDR CALA0100111Angle · corrodedINSPECTION FOUND AFT FLOOR ATTACH ANGLE IN FORWARD CARGO AREA CORRODED AT STA 500D ABOVE S26L-S26R. THE ANGLE WAS REMOVED AND A NEW ANGLE WAS INSTALLED IAW SRM 51-10-02.SDR CALA0100107Panel · corrodedINSPECTION FOUND AFT CARGO PIT RT TRANSITION PANEL CORRODED AT STA 727 - 767 AND LT TRANSITION PANEL CORRODED AT STA 727 - 847. THE RT TRANSITION PANEL WAS REMOVED AND REPLACED IAW SRM 51-10-02. THE CORRODED SECTION OF LT TRANSITION PANEL WAS REMOVED AND REPSDR CALA0100105Angle · crackedINSPECTION FOUND A .5 INCH CRACK IN ANGLE AT STA 380, L26L. THE ANGLE WAS REMOVED AND REPLACED IAW SRM 51-10-02.SDR SWAA010346Charger · inoperativeFWD SVC DOOR EMERGENCY EXIT LIGHT ILLUMINATED AFTER PUSHBACK. REMOVED AND REPLACED HOUSING CHARGER ASSY PER MM.SDR CALA0100103Angle · gougedINSPECTION FOUND RT SIDE VERTICAL STABILIZER TO FUSELAGE ANGLE GOUGED AT STA 1088 - 1156. THE LT ANGLE AT STA 1121 - 1138 WAS ALSO GOUGED. THE GOUGED SECTIONS WERE REMOVED AND REPLACED IAW ECRA 5380-01013.SDR SWAA010342Battery Pack · dischargedDURING SCHEDULED PM CHECK, FOUND FWD SVC DOOR OVERHEAD EMERGENCY LIGHT INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR CALA0100100Skin · dentedINSPECTION FOUND FUSELAGE SKIN DENTED AFT OF L-1 DOOR AT STA 380. THE DENTED AREA WAS CUT OUT AND A REPAIR DOUBLER WAS INSTALLED IAW SRM 53-00-01, FIGURE 208.SDR CALA0100087Floor Support · crackedINSPECTION FOUND A .5 INCH CRACK IN FLOOR SUPPORT AT STA 540, LBL 1. THE FLOOR SUPPORT WAS REMOVED AND REPLACED IAW SRM 51-10-02.SDR CALA0100086Floor Support · crackedINSPECTION FOUND A .5 INCH CRACK IN FLOOR SUPPORT AT STA 540, RBL 1. THE FLOOR SUPPORT WAS REMOVED AND REPLACED IAW SRM 51-10-02.SDR SWAA010290Stringer · corrodedDURING SCHEDULED D-CHECK, FOUND STR 27L CORRODED FROM BS 500B TO BS 500D. REPAIRED STR PER SRM & ER.SDR SWAA010289Keelbeam · corrodedDURING SCHEDULED D-CHECK, FOUND KEEL BEAM CORRODED AT BS 721, RBL 7 & BS 500D, LT SIDE. REPAIRED KEEL BEAM PER ER''S & SRM.SDR SWAA010265Lens · missingEMERGENCY EXIT LIGHT LENS COVER MISSING AT BULLNOSE, ROW 12 DEF. INSTALLED LENS PER MM.SDR SWAA010264Bulkhead · crackedDURING SCHEDULED D-CHECK, FOUND BS 178 BULKHEAD VERTICAL BEAM CRACKED AT RBL 17.1, WL 191. REPAIRED VERTICAL BEAM PER ER.SDR SWAA010255Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, BETWEEN STR 1L & 2L. REPAIRED FRAME PER SRM.SDR SWAA010254Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 767, BETWEEN STR 8R & 9R. REPAIRED FRAME PER ER.SDR SWAA010253Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, RBL 68, WL 268. REPAIRED FRAME PER ER & SRM.
Back to Boeing 737-3Q8