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 ASAA2013052395166Skin · dentedLEFT FUSELAGE BS 1000, SKIN IS DENTED JUST ABOVE S14L. ACFT GROUNDED. REMOVED DAMAGED SKIN FROM BS 992-1016, S10-14L, LOCATED FABRICATED BONDED DRILLED AND INSTALLED NEW SKIN IAW SRM 51-40-05, 51-40-02, MM 51-21-307-014, 51-21-99-307-001, DWG 65-52988.SDR ASAA2013052395161Skin · chafedRIGHT WING INBD BOOST PUMP CUTOUT HAS MINOR CHAFING. ACFT GROUNDED. REPAIRED CHAFING IAW SRM 57-20-01-2R-6.SDR ASAA2013052395142Transition Panel · gougedFWD CARGO BAY LT TRANSITION PANEL BETWEEN BS 500A AND 500B GOUGED AT FASTENER HOLE. REMOVED, FABRICATED NEW AND REPLACED TRANSITION PANEL IAW SRM 53-30-53-2R3, FIG 201.SDR ASAA2013052395139Floor Support · gougedFWD CARGO BAY JUST AFT BS 500B, ABOVE 28L, FLOOR SUPPORT GOUGED ON CORNER. REMOVED DAMAGE AND CHECKED LIMITS, FOUND TO BE OUT OF LIMITS IAW SRM 53-30-53-1A-1, FIG 101. REPAIRED CARGO FLOOR SUPPORT IAW SRM 53-00-53.SDR ASAA2013052395135Transition Panel · corrodedFWD CARGO COMP RT TRANSITION PANEL CORRODED IN SEVERAL AREAS FROM STA 500C TO 500G. REMOVED CORROSION AND CHECKED LIMITS FOUND TO BE OUT OF LIMITS IAW SRM 53-30-53-1A-1, FIG 101. R & R TRANSITION PANEL IAW SRM 51-40-02-0G-0.SDR ASAA2013052295461Skin · chafedLEFT INBD THRUST REVERSER FWD TORQUE BOX SKIN UPPER SECTION HAS A CHAFE AREA ON BACK SIDE. REPAIRED NR1 ENGINE. INBD FWD TORQUE BOX SKIN IAW ASA EA400-78EA-10560.SDR ASAA2013052295433Skin · chafedNR 1 ENGINE OTBD THRUST REVERSER FWD TORQUE BOX UPPER SKIN HAS AREAS CHAFED ON BACK SURFACE. ACFT GROUNDED. REPAIRED SKIN IAW EA 400-78EA-10569, REV NEW ISSUE DATE 6/25/13.SDR ASAA2013052295432Skin · chafedNR 2 ENGINE INBD THRUST REVERSER FORWARD TORQUE BOX UPPER SKIN SECTION HAS A CHAFED AREA ON THE BACK SIDE. ACFT GROUNDED. REPAIRED UPPER TORQUE BOX SKIN IAW EA 400-78EA-10563, REV NEW ISSUE DATE 6-25-13.SDR ASAA2013052295256Support Beam · chafedNR 1 ENG PYLON FAN COWL SUPPORT BEAM INBD CHORD CHAFED. ACFT GROUNDED. REPAIRED NR 1 ENG PYLON INBD FAN COWL SUPPORT BEAM IAW ASA EA NR 400 54EA 10557.SDR ASAA2013052295253Angle · corrodedLT WHEEL WELL MANIFOLD ASSY LOWER AFT CHORD TO LOWER CENTER CHORD SPLICE PLATE CORRODED. ACFT GROUNDED. REMOVED LT WHEEL WELL MANIFOLD LOWER AFT CHORD SPLICE PLATE ANGLE FABRICATED NEW ANGLE TREATED, PRIMED, TOPCOATED AND INSTALLED IAW SRM 51-30-01-0G 0, FIGSDR ASAA2013052295250Flange · corrodedLT WHEEL WELL MANIFOLD ASSY LWR FWD CHORD HAS FRETTING CORROSION ON LOWER FLANGE. ACFT GROUNDED. REMOVED LT WHEEL WELL MANIFOLD LWR FWD CHORD FABRICATED NEW CHORD TREATED, PRIMED AND TOP COATED AND INSTALLED IAW SRM 51-30-01-0G-0, FIG 7, 51-40-02 0G-0 AND AMSDR ASAA2013052295247Angle · corrodedLT WHEEL WELL MANIFOLD ASSY LOWER AFT ANGLE CORRODED ON VERTICAL AND HORIZ FLANGE. ACFT GROUNDED. REMOVED LT WHEEL WELL MANIFOLD LWR AFT CHORD FABRICATED NEW CHORD TREATED, PRIMED AND TOPCOATED AND INSTALLED IAW SRM 51-30-01-0G-0 FIG 7, 51-40-02-0G 0 AND AMM SDR ASAA2013052295231Support Beam · corrodedFWD ENTRY DOOR THESHOLD INNER SUPPORT CORRODED NEAR FWD AND AFT END. ACFT GROUNDED. REMOVED ENTRY DOOR THRESHOLD INNER SUPPORT AND REPLACED WITH NEW SUPPORT IAW SRM 51-40-02, FIG 8 AND 51-40-05, FIG 3, W .75, O .080, R .069, L 2.0, D .011.SDR ASAA2013052295224Fairing · chafedNR 6 FLAP FAIRING IF OT LANDING CHAFED. ACFT GROUNDED. REMOVED AND INSTALLED NEW STIFFENER AND DOUBLER IAW SRM 51-40-02-0G 0.SDR ASAA2013052295214Structure · chafedNR 4 SLAT INBD T/E EDGE IS CHAFED ON THE BOTTOM SIDE. ACFT GROUNDED. REPAIRED CHAFED ON NR 4 SLAT INDB T/E EDGE IAW SRM 51-70-10-2R 0. REPAIR 4, PARA 20, PG 48.SDR ASAA2013052295141Closeout Panel · chafedRIGHT T/E CLOSE OUT PANEL CHAFED ON OTBD NR 6 FAIRING. ACFT GROUNDED. REMOVED, FABRICATED AND INSTALLED NEW CLOSEOUT PANEL IAW SRM 51-40-02 AND DWG 65-69646 AND MM 20-50-11-912-002.SDR ASAA2013052195220Support Bracket · damagedNR 1 FLAP FAIRING SUPPORT BRACKET HAS BARE METAL AND PITTING. ACFT GROUNDED. REMOVED DAMAGED NR 1 FAIRING LOWER SUPPORT BRACKET, FABBED, INSTALLED NEW LWR SUPPORT BRACKET IAW SRM 51-40-02, 51-40-05.SDR ASAA2013052195288Skin · chafedLT OTBD AFT FLAP CHAFED NR 1 FLAP FAIRING LANDING. REPAIRED LT OTBD AFT FLAP CHAFED AT NR 1 FLAP FAIRING LANDING IAW SRM 51-70-10-2R-4, REPAIR 4. (PERMANENT REPAIR)SDR ASAA2013052195130Reveal · chafedAFT CARGO BAY FWD REVEAL HAS EDGE DAMAGE, FABRICATED NEW REVEAL IAW SRM 51-40-05 AND DWG 65-56655.SDR EE4Y2013060300063Keelbeam · corrodedLOWER FUSELAGE LT CONDITIONING BAY AT BS 653 LBL 40.875 TEE CHORD WITH CORROSION. THE BLENDOUTS WERE REPAIRED IAW MESSAGE COO-ILF-13-0009-02B.SDR EE4Y2013060300062Skin · corrodedLEFT WING T/E UPPER SKIN CORROSION AT WS 190 AND WS 220. THE BLENDOUTS WERE REPAIRED IAW MESSAGE COO-ILF-13-0010-02B DTD, MAY 23 2013, UNDER THE NON ROUTINE WO: A1B144, SUBJOB: 5 ITEM: 42.SDR EE4Y2013060300061Keelbeam · corrodedLOWER FUSELAGE, AT BS 727G+5 AT S27L KEEL BEAM CORRODED. THE BLENDOUT WAS REPAIRED IAW MESSAGE COO-ILF-13-0013-05B, DTD MAY 30 2013, UNDER THE NON ROUTINE WO: A1B144, SUBJOB: 1, ITEM: 192.SDR ASAA2013051995156Skin Panel · chafedSKIN PANEL 6308 IS CHAFED. ACFT GROUNDED. BLENDED SKIN PANEL AND CHECKED LIMITS FOUND TO BE OUT OF LIMITS IAW SRM 53-00-70-1A-1, FIG 101. NEW PANEL, LOCATED AND DRILLED IAW DWG 65-79917.SDR ASAA2013051895132Skin · delaminatedRT WING 5 SLAT OTBD T/E IS DELAMINATED. REPAIRED RT WING NR 5 SLAT OTBD T/E DELAMINATION IAW SRM 51-70-10-2R-4, REPAIR 4, PG 1.SDR ASAA2013051895020Floor Panel · gougedFWD CARGO BAY FLOOR PANEL NR 3 HAS DEEP GOUGE. ACFT GROUNDED. FABRICATED NEW FLOOR PANEL IAW SRM 51-40-05-0G-0.SDR ASAA2013051895019Floor Panel · damagedAFT CARGO BAY FLOOR PANEL NR 4 IS DAMAGED AT EDGE. ACFT GROUNDED. FABRICATED NEW FLOOR PANEL IAW SRM 51-40-05-0G-0.SDR ASAA2013051894981Floor Panel · gougedAFT CARGO BAY FLOOR PANEL NR2 HAS A DEEP GOUGE. ACFT GROUNDED. FABRICATED NEW AFT CARGO BAY FLOOR PANEL NR2 IAW SRM 51-40-08-0G-0 AND RESTORED FINISH IAW SRM
51-20-01-0G-0.SDR ASAA2013051894844Door · lack of lubeR2 DOOR DIFFICULT TO OPEN & CLOSE. ACFT GROUNDED. C/W GVI OF R2 DOOR , CLEANED AND LUBED DOOR ASSY. PERFORMED AMM TASK 52-41-00 PROC C. HANDLE TORQUE WITHIN LIMITS.SDR ASAA2013051894843Hinge · lack of lubeF/A REPORTS AFT ENTRY DOOR IS HARD TO OPEN. ACFT GROUNDED. LUBED ENTRY DOOR HINGES. OPS NORMAL.SDR EE4Y2013052900053Tee Fitting · corrodedLOWER FUSELAGE LT AIR CONDITION BAY AT BS 653.25, LBL 40.875 TEE CHORD WITH CORROSION. TEE WAS REPAIRED IAW MESSAGE COO-ILF-13-0009-02B DTD MAY 21, UNDER THE NON ROUTINE WO: A1B144, SUBJOB: 1, ITEM 245.SDR ASAA2013051294792Skin · crackedPOSSIBLE CRACK ON RT HORIZONTAL STAB T/E OF IN SPAR SKIN STAB 97. ACFT GROUNDED. CONFIRMED SKIN CRACK REF BNDT 51-00-00, FIG 23, PART 6 HFEC. PERFORMED HFEC OF ADJACENT BAYS IAW SRM 55-10-01-2R-13, STEP Q, NO INDICATIONS NOTED. INSP NR 3. ACCOMPLISHED CAT B SDR ASAA2013050994736Frame · crackedFRAME AT BS 500B, LT SIDE FRAME AT BS 500B, LT SIDE HAS A CRACK AT THE FASTENER DIRECTLY ABOVE AND INBD OF THE 1 DIA WIRE PENETRATION HOLE APPROX .1250" LONG EXTENDING INBD BELOW STRINGER 20L, REPAIRED FRAME AT STA 500B IAW ASA EA 400 53, EA 10317.SDR EE4Y2013052900052Skin · dentedLOWER FUSELAGE, AT BS 375 BETWEEN STR 17L AND STR 18L SKIN, WITH DENT.CORRECTIVE ACTION: THE DENT WAS REPAIRED IN ACCORDANCE WITH BOEING MESSAGE COO-ILF-13-0005-0B DTD 17 MAY 2013, UNDER THE NON ROUTINE WORK ORDER: A1B144, SUBJOB: 1, ITEM: 70SDR ASAA2013050794728Rib · chafedLEFT OTBD FIXED WING T/E RIB AT WS 415 IS CHAFED. ACFT GROUNDED. R & R OTBD LT FIXED WING T/E FITTING IAW SRM 51 40 02 0G 0 AND AMM 20 50 11 912 002, FIG 203.SDR ASAA2013050294727Frame · dentedAFT CARGO FRAME AT BS 727C DENTED ABOVE 23R. ACFT GROUNDED. REPAIRED FRAME IAW EA 400 53, EA 10243.SDR ASAA2013042994633Frame · dentedFWD CARGO BS 500E S24L FRAME DENTED. ACFT GROUNDED. REPAIRED FWD CARGO FRAME IAW EA 400-53EA-10241 REV NEW.SDR ASAA2013042794823Baffle · bentLEFT BAFFLE BETWEEN BS 400 AND 420 IS BENT. ACFT GROUNDED. R & R BAFFLE IAW SRM 51-40-02-0G-0.SDR ASAA2013042794822Baffle · crackedFWD CARGO BAY LEFT BAFFLE BETWEEN BS 460 - 480 IS CRACKED. ACFT GROUNDED. R & R BAFFLE IAW SRM 51-40-02-0G-0.SDR ASAA2013042794751Failsafe · corrodedFWD CARGO BS 500G FAILSAFE CORRODED AT S28R. ACFT GROUNDED. R & R FAILSAFE IAW SRM 51-40-02-0.SDR ASAA2013042194567Seat Track · gougedSEAT TRACK AT LBL 24.75 FROM BS 727B TO 927 HAS NUMEROUS NICKS AND GOUGES. R & R SEAT TRACK IAW SRM 51-40-02-0G-D AND EA 400-53EA-04953 REV.SDR ASAA2013042194565Seat Track · gougedSEAT TRACK AT LBL 45.5 FROM BS 727B - 927 HAS NUMEROUS NICKS AND GOUGES. R & R SEAT TRACK IAW SRM 51 40 02 0G 0.SDR ASAA2013042094698Skin · dentedPROTRUSION IN SKIN AT BETWEEN BS 727G AND 747, APPROX 2 ABOVE STR 25R. ACFT GROUNDED. REPAIRED DENT IAW EA 400 53EA 10272, REV NEW DATED 02MAY13.SDR ASAA2013042094595Baffle · corrodedON WORKING AFT CARGO RT TRANSITION PANEL, FOUND CORRODED ON BAFFLE BS 747 TO 767 AT S26R. FABRICATED NEW BAFFLE AND INSTALLED IAW SRM 51-40-02, STEP 4-B A-C, ACFT GROUNDED.SDR ASAA2013042094590Baffle · corrodedUPON WORKING AFT CARGO RT TRANSITION PANEL, FOUND CORRODED ON BAFFLE STA 747 - 767 AT S26R. FABRICATED NEW BAFFLE AND INSTALLED IAW SRM 51-40-02, STEP 4-B A-C.SDR ASAA2013042094551Door · out of adjustL1 DOOR IS HARD TO CLOSE AND SOMETIMES BINDS. PERFORMED VERTICAL ADJUSTMENT OF L-1 DOOR IAW AMM 52-11-00-705-007, 3, H. ADJUSTED HORIZONTAL CONTROL ROD ADJUSTMENT IAW AMM 52-11-00-705-007, 3, J, 4. PERFORMED GUIDE ARM ADJUSTMENT IAW AMM 52-11-705-00, 3, G. SDR ASAA2013041894580Floorboard · gougedAFT CARGO FLOORBOARD SEVERAL DEEP GOUGES. FABRICATED NEW FLOORBOARD IAW SRM 51-40-05.SDR ASAA2013041794576Shear Tie · corrodedAFT CARGO BS 807 FRAME AT SKIN CORRODED NEXT TO STRINGER 27L. REMOVED CORROSION BY BLENDING, FOUND TO BE OUT OF LIMITS DUE TO EXISTING REPAIR. REPAIRED SHEAR TIE IAW SRM 53 00 07, FIG 101 AND 53 05 07 REPAIR 3, CATEGORY B REPAIR, CONTACT ENGINEERING FOR METSDR ASAA2013041794569Skin · chafedRIGHT INBD FOREFLAP CHAFED ON CENTER UPPER SIDE. REPAIRED RT INBD FOREFLAP IAW SRM 51 70 10 2R 4.SDR ASAA2013041794519Shear Tie · corrodedAFT CARGO BAY SHEAR TIE CORRODED BS 807, STR 27. REMOVED CORRODSION, FOUND TO BE OUT OF LIMITS. REPAIRED SHEAR TIE IAW SRM 53-00-07, FIG 101 AND 53-00-07,SDR ASAA2013041794518Shear Tie · corrodedAFT CARGO BAY AT BS 767 O/B OF S25L ON FRAME AT SKIN CORROSION REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS. REPAIRED SHEAR TIE IAW SRM 53-00-07, FIG 101 AND 53-00-07.
Back to Boeing 737-4Q8