Boeing 737-7Q8
Service difficulty reports · 3,964
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 = '7377Q8' 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 = '7377Q8' 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 SWAA2017122018583Plate · crackedLT WING LOWER TRAILING EDGE WAFFLE PLATE CRACKED ABOVE NR 3 FLAP TRACK. R&R WAFFLE PLATE IAW SRM.SDR SWAA2017112818062Support Beam · crackedLT WING LOWER TRAILING EDGE PANEL SUPPORT BEAM CRACKED. R&R BEAM IAW SRM.SDR SWAA2017112818061Support Angle · crackedLT WING UPPER TRAILING EDGE PANEL SUPPORT ANGLE CRACKED. R&R ANGLE ASSEMBLY IAW SRM.SDR SWAA2017112818060Attach Angle · crackedLT WING TRANSVERSE WEB OUTBOARD ATTACH ANGLE CLIP CRACKED. R&R ANGLE CLIP IAW SRM.SDR SWAA2017101817180Slide · out of positionR2 DOOR SLIDE OUT OF POSITON. REPOSITION THE SLIDE IAW MT.SDR SWAA2022020221608Skin · corroded***CORROSION*** NOTED ON AFT CARGO DOOR EXTERNAL SKIN - LOCAL TO PRE-EXISTING BLEND AREAS. / ACD EXTERIOR SKIN WAS REPLACE ON WO 501248SDR SWAA2017120418207Skin · corrodedFUSELAGE SKIN CORRODED AT BS 862, STR 25L. REPAIRED SKIN PER EA.SDR SWAA2017101817179Slide · out of positionR1 DOOR SLIDE OUT OF POSITION. REPOSITIONED THE SLIDE IAW MT AND AMM.SDR SWAA2022020221185Panel · cracked(LEFT WING) #2 SLAT COVE PANEL 524GB CRACKED / REMOVED #2 SLAT CORE PANEL 524GB PER SOPM 56556C 12OCT17 FABRICATED #2 SLAT CORE PANEL 524GB IAW SRM 51-40-05-0G-0 & DWG #114A8121. INSTALLED NEW PANEL IAW SOPM 20-50-01.55920U 04NOV17SDR SWAA2022020221186Panel · cracked(LEFT WING) #2 SLAT COVE PANEL 524DB CRACKED / REMOVED; FABRICATED NE # 2 SLAT COVE PANEL 524DB; AND INSTALLED PANEL IAW SOPM 20-30-0; DWG.114A8121SDR SWAA2022020221595Angle · corroded***CORROSION*** NOTED ON WATER SERVICE DOOR (146AR) FWD ANGLE / GUARD ASSY. / REMOVED CORROSION ON WATER SERVICE DOOR (146AR) FWD ANGLE/GUARD ASSY AREA OF .05 X .05 X .008 FOUND TO BE OUT OF LIMITS DUE TO NO ALLOWABLE DAMAGE PER SRM REPAIRABLE BY REPLACEMENT RSDR SWAA2017120518244Skin · crackedL/H WING #2 SLAT BULLNOSE LOWER SURFACE SKIN CRACKED. / REPAIRED #2 SLAT SKIN IAW SRM.SDR SWAA2017112217969Floor Support · crackedFLOOR SUPPORT CRACKED BETWEEN BS 500D TO BS 520, BL 0. R&R SUPPORT IAW SRM AND DWG.SDR SWAA2017112017902Former · crackedLT WING TO BODY FAIRING FORMER CRACKED AT 500D, WING STA 70.5. REPAIRED FORMER IAW SRM & DWG.SDR SWAA2017121818462Frame · crackedR1 DOOR SURROUND STRUCTURE, FORWARD STUB FRAME CRACKED AT BS 296, STRINGER 17R. REPAIRED THE STUB FRAME IAW EA.SDR SWAA2017110217485Pressure Panel · debondedVAPOR BARRIER BULKHEAD DISBONDED AT BS 663, RBL 30. REPAIRED BARRIER PER SRM.SDR SWAA2022020221151Floor Panel · corroded***CORROSION*** AFT CARGO BAY FLOOR PANEL SPLICE PLATE AT BS 772 HAS AREAS OF CORROSION BETWEEN LBL 21 AND RBL 21. / REMOVED AND REPLACED AFT CARGO BAY FLOOR PANEL SPLICE AT BS 772 AND DRAWING 146A9401 AND SRM 51-40-02-0G-0 89327U 19NOV17SDR SWAA2022020221152Splice Plate · corroded***CORROSION*** AFT CARGO BAY FLOOR PANEL SPLICE PLATE AT BS 887 HAS AREAS OF CORROSION BETWEEN LBL 9 AND RBL 21. / LOCATED AND DRILLED NEW SPLICE PLATE ON ACT AT B.S 887 PER SRM 51-40-02-0G-0 AND SRM 51-40-05-0G-0 AND DWG 146A9401 P/N 7530863 OK TO INSTALL 56SDR SWAA2022020221160Angle · crackedSTANCHION ATTACH ANGLE IS CRACKED AT BS 866 LBL 11 WL 165. / REMOVED AND REPLACED STANCHION ATTACH ANGLE I.A.W. SRM 51-40-02-0G-0 AND DWG; 149A8102SDR SWAA2022020221154Nut Plate · corroded***CORROSION*** VERTICAL WEB ASSY NUTPLATE STRIP HAS CORROSION BETWEEN BS 787 AND BS 794 RBL 20 WL 156. / REMOVED AND REPLACED VERTICAL WEB ASSY NUTPLATE STRIP AT BS 787 TO 794 RBL 20 WL 156 IAW SRM 51-40-02-0G-0 AND DRAWING 146A5120 59327U 5NOV17SDR SWAA2022020221155Nut Plate · corroded***CORROSION*** VERTICAL WEB ASSY NUTPLATE STRIP HAS CORROSION AT BS 800 RBL 20 WL 156. / REMOVED AND REPLACED VERTICAL WEB ASSY NUTPLATE STRIP AT BS800 RBL 20 WL156 IAW SRM 51-40-02-0G-0 AND DRAWING 146A8120 89327U 5NOV17SDR SWAA2022020221156Support Angle · corroded***CORROSION*** AFT CARGO BAY AFT BULKHEAD CENTER LOWER SUPPORT ANGLE HAS AREAS OF CORROSION BETWEEN LBL 9 AND RBL 21. / REMOVED DAMAGE ON AFT CARGO BAY AFT BULKHEAD CENTER LWR SUPPORT BS 947 BETWEEN LBL 9-RBL 21. REPAIRED PER ATS ER-17-04588 REV IR AND SWA EASDR SWAA2022020221157Window Frame · corrodedFIRST OFFICER'S #1 WINDOW FRAME; OUTBOARD VERTICAL POST HAS PITTING 9' FROM TOP OF FRAME / REPAIRED FIRST OFFICERS #1 WINDOW FRAME OUTBOARD VERTICAL POST 9' FROM TOP OF FRAME PER ATS ER 17-04515 REV IR AND SWA EA 1-753-32012 REV IR.SDR SWAA2022020221158Window Frame · corrodedFIRST OFFICER'S #1 WINDOW FRAME; OUTBOARD VERTICAL POST HAS PITTING 2' FROM TOP OF FRAME / REPAIRED FIRST OFFICER'S #1 WINDOW FRAME VERTICAL POST PITTING PER ATS ER 17-04515 REV IR AND SWA EA 1-753-32012 REV IR.SDR SWAA2022020221159Intercostal · corroded***CORROSION*** ON INTERCOSTAL AT BS 772.5 RBL 20 WL 156. / REMOVED CORROSION ON INTERCOSTAL WEB DIMENTION DAMAGE L=2.600' W=.600' DEPTH .009 MAX ALLOWABLE DAMAGE 10% FOUND TO BE OUT OF LIMITS IAW SRM 53-60-15-1A-1 STEP B (2) FIG 103 DETAIL D REMOVED INTERCOSTSDR SWAA2017121918532Sidewall Support · corrodedAFT CARGO BAY FLOOR TO SIDEWALL SUPPORT CORRODED BETWEEN BS 867 TO 947, RBL 21. R & R THE SIDEWALL SUPPORT IAW SRM & DWG.SDR SWAA2017121118362Slide · frayedR2 DOOR EMERGENCY ESCAPE SLIDE GIRT FRAYED. R&R SLIDE IAW MT.SDR SWAA2017120518243Frame · crackedFRAME CRACKED AT BS. 867, STR. 8R. / REPAIRED FRAME PER EA.SDR SWAA2017112117962Frame · crackedFRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2017112117961Frame · crackedFRAME CRACKED AT BS 360, STR 8R. REPAIRED FRAME PER EA.SDR SWAA2017112117960Frame · crackedFRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER EA.SDR SWAA2017112117959Frame · crackedFRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME PER EA.SDR SWAA2017112117958Frame · crackedFRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER EA AND ER.SDR SWAA2017112117957Support Angle · corrodedCLOSE-OUT WEB SUPPORT ANGLE CORRODED BETWEEN BS 789 TO BS 793, RBL 24. R&R ANGLE IAW SRM & DWG.SDR SWAA2017112117956Strap · corrodedAFT CARGO BAY THRESHOLD STRAP CORRODED BETWEEN BS 774 TO BS 861.5, RBL 20. R&R STRAP IAW DWG AND SRM.SDR SWAA2017112117955Track · corrodedAFT CARGO BAY FLOOR TRACK CORRODED AT BS 908, LBL 3. R&R FLOOR TRACK IAW SRM AND DWG.SDR SWAA2017112117954Support · corrodedAFT CARGO BAY FLOOR TO SIDEWALL SUPPORT CORRODED BETWEEN BS 847 TO BS 867, RBL 21. R&R SUPPORT IAW SRM AND DWG.SDR SWAA2017112117953Floorbeam · corrodedAFT CARGO BAY FLOORBEAM CORRODED AT BS 772, RBL 3. REPAIRED FLOOR BEAM IAW EA AND SRM.SDR SWAA2017112117952Floorbeam · corrodedAFT CARGO BAY FLOORBEAM CORRODED AT BS 772, RBL 8. REPAIRED FLOORBEAM IAW EA AND SRM.SDR SWAA2017112117951Track · corrodedAFT CARGO BAY FLOOR TRACK CORRODED AT BS 772, LBL 17. REPAIRED FLOOR TRACK IAW EA AND SRM.SDR SWAA2017112117950Bracket · corrodedFORWARD CARGO BAY AFT LT BULKHEAD SIDEWALL BRACKET CORRODED AT BS 500D, LBL 24. R&R BRACKET PER SRM AND DWG.SDR SWAA2017112117949Shield · corrodedFORWARD CARGO BAY DOOR LOWER MAIN SILL AFT SHIELD CORRODED BETWEEN BS 492 TO BS 500A. R&R SHIELD IAW SRM AND DWG.SDR SWAA2017112117948Shield · corrodedFORWARD CARGO BAY DOOR LOWER MAIN SILL FORWARD SHIELD CORRODED BETWEEN BS 420 TO BS 440. R&R SHIELD IAW SRM AND DWG.SDR SWAA2017112117935Web · corrodedFORWARD CARGO BAY BILGE LOWER EDGE OF INTERCOSTAL CORRODED BETWEEN BS 500 TO 500A, STRINGER 28R. R & R THE INTERCOSTAL WEB IAW SRM & DWG.SDR SWAA2017111717882Sidewall Support · corrodedAFT CARGO BAY FLOOR TO SIDEWALL SUPPORT NUTPLATE ASSEMBLY CORRODED BETWEEN BS 767 TO 794, RBL 21. R & R THE SIDEWALL SUPPORT IAW SRM AND DWG.SDR SWAA2017111617847Frame · crackedFRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER ER AND EA.SDR SWAA2017111617846Frame · crackedFRAME CRACKED AT BS 727B, STR 8L. REPAIRED FRAME PER EA.SDR SWAA2017111617845Bracket · corrodedFORWARD CARGO BAY AFT CENTER BULKHEAD FLOOR BRACKET CORRODED AT BS 500D, BETWEEN LBL 24 TO RBL 24. R&R BRACKET IAW SRM AND DWG.SDR SWAA2017110817662Frame · crackedFRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2017110817650Frame · crackedFRAME CRACKED AT BS 500A, STRINGER 8R. REPAIRED THE FRAME IAW EA.
Back to Boeing 737-7Q8