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 SWAA2017082815926Battery Pack · faultyEMERGENCY LIGHT BATTERY PACK M1675 FAULTY. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017082815925Battery Pack · faultyEMERGENCY LIGHT BATTERY PACK M1670 FAULTY. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017081615730Lens · missingR2 DOOR EMERGENCY EXIT LIGHT COVER LENS MISSING. INSTALLED LENS IAW AMM.SDR SWAA2017081615732Housing · brokenAFT ENTRY CENTER CEILING EMERGENCY EXIT LIGHT HOUSING ASSEMBLY BROKEN. R&R LIGHT ASSEMBLY IAW AMM.SDR SWAA2017081615731Grip · damagedL2 EMERGENCY EXIT DOOR GRIP ASSEMBLY DAMAGED. R&R DOOR GRIP ASSEMBLY IAW AMM.SDR SWAA2022013118565Scuff Plate · crackedAFT CARGO BAY AFT CORNER SCUFF PATE IS CRACKED / AFT CARGO BAY; AFT CORNER SCUFF PLATE REMOVED IAW AMM 53-11-020-801. REPAIRED IAW EA 1-A53-2076; REV 11. INSTALLED IAW AMM 53-11-420-801. 88783U. 07AUG2017.SDR SWAA2017080315497Battery · no testEMERGENCY LIGHT BATTERY M1672 FAILED CAPACITY TEST. R & R THE BATTERY IAW MM.SDR SWAA2017080315496Battery · no testEMERGENCY LIGHT BATTERY M1675 FAILED CAPACITY TEST. R & R THE BATTERY IAW MM.SDR SWAA2017080315329Battery · no testEMERGENCY LIGHT BATTERY M1669 FAILED CAPACITY TEST. R & R THE BATTERY IAW MM.SDR SWAA2022013118563Angle · crackedAPU AIR INLET INNER WALL PANEL UPPER FWD ANGLE IS CRACKED / REMOVED AND REPLACED APU AIR INLET INNER WALL PANEL; UPPER FWD ANGLE PER BOEING DRAWING #353A2010; REV. B. SHT. 0008 & 0012 AND SRM 51-40-02-0G-0; PARAGRAPH 4. 26373U 26JUL17SDR SWAA2017072515265Light · unsecureR1 DOOR LOWER EXIT SIGN LIGHT ASSEMBLY FELL OFF. R&R LIGHT ASSEMBLY IAW AMM.SDR SWAA2017072515269Hook · looseL1 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR STOWAGE HOOK LOOSE. R&R HOOK IAW SRM & MT.SDR SWAA2022013118561Plate · corroded***CORROSION*** LOWER TCAS ADAPTER PLATE HAS CORROSION COMMON TO TCAS ANTENNA MOUNTING SURFACE / REPAIRED LOWER TCAS ADAPTER PLATE PER EA 1-753-31596 REV IR AND ER 17-03407 IRSDR SWAA2022012818558Flap · delaminatedR/W I/B AFT FLAP LOWER SURFACE 32' FROM I/B END AND 3' FROM AFT EDGE HAS AREA OF DELAMINATION NOTED / DELAMINATED AREA ON LWER SURFACE OF R/W I/B AFT FLAP; 32' FROM I/B END & 3' FROM AFT EDGE WAS REPAIRED IAW SRM 57-53-01; SRM 51-70-06-2R-1; SRM 51-70-10-2R-2;SDR SWAA2022012718550Retainer Seal · crackedFAIRING 542BB FWD O/B SEAL RETAINER IS CRACKED / REMOVED AND REPLACED FAIRING 542BB FWD O/B SEAL RETAINER IAW SOPM 20-50-01 STEP 8. 7479U 07/15/17SDR SWAA2022012718551Retainer Seal · brokenFAIRING 542BB O/B CENTER SEAL RETAINER IS BROKEN / REMOVED FAIRING 542 O/B CENTER SEAL RETAINER PER SRM 51-40-02-0G-0 3426C 07-14-17 INSTALLED FAIRING 542BB O/B CENTER SEAL RETAINER IAW SRM 51-40-02-0G-0 STEP 11C (1)(A)(C)(2) 7041U 19JUL17SDR SWAA2017080715401Stiffener · crackedLEFT HORIZONTAL STABILIZER IN SPAR RIB VERTICAL STIFFENER CRACKED AT HSS 111.10, THIRD CENTER AFT LOWER. REPAIRED THE STIFFENER IAW ER AND EA.SDR SWAA2017080715400Floor Support · corrodedAFT CARGO BAY FLOOR SUPPORT CORRODED BETWEEN BS 747 TO 767, RBL 24. R & R THE FLOOR SUPPORT IAW SRM & DWG.SDR SWAA2017072515198Stiffener · crackedLEFT HORIZONTAL STABILIZER IN SPAR RIB VERTICAL STIFFENER CRACKED AT HSS 111.1, NR 4 AFT LOWER. REPAIRED THE STIFFENER IAW SRM.SDR SWAA2017082415897Skin · crackedRIGHT HORIZONTAL STABILIZER LOWER SKIN CRACKED BETWEEN HSS 92.70 TO 101.90. REPAIRED THE SKIN IAW SRM AND EA.SDR SWAA2017082415896Doubler · crackedLEFT WINDOW FRAME POST E-F CRACKED ON 3 OF SECOND FASTENER HOLE OF LOWER CORNER. REPAIRED THE DOUBLER IAW EA.SDR SWAA2017072515213Floor Support · crackedFORWARD CARGO BAY FLOOR SUPPORT ANGLE CRACKED AT BS 500C, RBL 24. R & R THE FLOOR SUPPORT ANGLE IAW SRM AND DWG.SDR SWAA2017082315890Intercostal · corrodedRT FLOOR SEAL ATTACH INTERCOSTAL CORRODED AT BS 1016. R&R INTERCOSTAL IAW SRM & DWG.SDR SWAA2017082315887Intercostal · corrodedLT FLOOR SEAL ATTACH INTERCOSTAL CORRODED AT BS 1016. R&R INTERCOSTAL IAW SRM & DWG.SDR SWAA2017081415636Stiffener · corrodedBULKHEAD STIFFENER CORRODED AT BS 1016, WL 208, NR 11 CLOCKWISE. REPAIRED THE STIFFENER IAW EA.SDR SWAA2017082315883Frame · crackedFRAME CRACKED AT BS 907, STR 8R. REPAIRED FRAME PER ER AND EA.SDR SWAA2017082115816Skin · crackedRT WINGLET LEADING EDGE UPPER INBOARD SURFACE CRACKED, 3RD FASTER BACK. REPAIRED SKIN PER ER & EA.SDR SWAA2017072515197Rib · crackedRIGHT HORIZONTAL STABILIZER RIB CRACKED AT HSS 92.7, THIRD VERTICAL STIFFENER BACK FROM LEADING EDGE AT LOWER END. REPAIRED THE RIB ASSEMBLY IAW SRM.SDR SWAA2017080715399Gusset · crackedFORWARD CARGO BAY SUPPORT GUSSET CRACKED AT BS 500D, STRINGER 19R. R & R THE GUSSET IAW SRM & DWG.SDR SWAA2017080715398Support · corrodedFORWARD CARGO BAY SUPPORT CORRODED BETWEEN BS 500C TO 500D, RBL 24. R & R THE SUPPORT IAW SRM & DWG.SDR SWAA2017072515196Sidewall Support · corrodedFORWARD CARGO BAY SIDEWALL SUPPORT CORRODED BETWEEN BS 420 TO 500D, LBL 24. R & R THE SIDEWALL SUPPORT IAW SRM.SDR SWAA2017071815145Window Frame · crackedRT NR 3 FLIGHT DECK WINDOW FRAME SECOND HOLE FROM BOTTOM CRACKED RUNNING FORWARD AND AFT. REPAIRED WINDOW POST IAW ACO.SDR SWAA2022012618474Angle · crackedAFT ENTRY DOOR LOWER GATE COVER PANEL FWD AND AFT ATTACH ANGLES ARE CRACKED / REMOVED AND REPLACED CRACKED FWD AND AFT ATTACH ANGLES ON AFT ENTRY DOOR LOWER GATE COVER PANEL IAW SRM 51-40-02-0G-0 STEP 1.A. AND STEP 4.B. AND 4.E. AND FIGURE 8 SHEET 1 43920U 11JSDR SWAA2022012618476Fairing · elongatedNUMBER 3 FLAP TRACK TAIL CONE ATTACH FASTENER HOLES #1; #9; #13 THRU #23 HAVE CONDITIO N 2HOLES AND REQUIRE REPAIR. / NUMBER 3 FLAP TRACK TAIL CONE ATTACH FASTENER HOLES #1; #9; #13 THRU #23 WERE REPAIRED IAW ACO #7996-57 AND SRM 51-70-04 REPAIR 9. 56144U. 07/SDR SWAA2022012618477Fairing · elongatedNUMBER 6 FLAP TRACK FAIRING TAIL CONE FASTENER HOLES #2; #3; #4; #5; #8; #14; #17; #21 HAVE CONDITION 2 HOLES AND REQUIRE REPAIR . / NUMBER 6 FLAP TRACK FAIRING TAIL CONE FASTENER HOLES #2; #3; #4; #5; #8; #14; #17 AND #21 WERE REPAIRED PER SWA ACO #7996-57; SSDR SWAA2022012618478Window Frame · cracked#1 CO PILOT WINDOW FRAME UPPER RH CORNER IS CRACKED / ACCOMPLISHED ACO 8464-53 RH #1 FLIGHT DECK FRAME - PERMANENT REPAIRSDR SWAA2017082815924Skin · crackedFUSELAGE SKIN CRACKED AT BS 540, STRINGER 22R. REPAIRED THE SKIN IAW EA.SDR SWAA2017082415902Skin · crackedFUSELAGE SKIN CRACKED AT BS 540, STRINGER 22L. REPAIRED THE SKIN IAW ER AND EA.SDR SWAA2022012618465Angle · corrodedFORWARD CARGO BAY BS 500D BULKHEAD SUPPORT ANGLE IS CORRODED AT RBL 8-25; WL 156 / REMOVED DAMAGED BULKHEAD SUPPORT ANGLE FROM F.C.B. @ BS 500D; RBL 22 TO LBL 22; WL 156 AND REPLACED WITH NEW SUPPORT ASSY IAW SRM 51-40-02-0G-0 STEP 4. 92115U 22JUL17SDR SWAA2017081615729Angle · corrodedFORWARD CARGO BAY BULKHEAD SUPPORT ANGLE CORRODED AT BS 500D, LBL 26. R&R ANGLE IAW SRM.SDR SWAA2017080715395Gusset · crackedFORWARD CARGO BAY SUPPORT GUSSET CRACKED AT BS. 500D, STRINGER 19L. R & R THE GUSSET IAW SRM AND DWG.SDR SWAA2017080715394Sidewall Support · crackedFORWARD CARGO BAY FLOOR TO SIDEWALL SUPPORT CRACKED BETWEEN BS 420 TO 440, RBL 27. R & R THE SIDWALL SUPPORT IAW SRM.SDR SWAA2017072515195Threshold · corrodedFORWARD CARGO DOOR CUTOUT SUB THRESHOLD WEB CORRODED BETWEEN BS 440 TO 492, BETWEEN RBL 24 TO RBL 29. R & R THE CUTOUT IAW SRM AND DWG.SDR SWAA2022012618450Angle · corroded***CORROSION*** AFT CARGO BAY BULKHEAD SUPPORT ANGLE BS947 LBL 10-RBL 10. / THERE ARE NO SRM ALLOWABLE DAMAGE ON ACB BULKHEAD SUPPORT ANGLE AT B/S 947 LBL 10-RBL 10 PART TO BE REPLACED BY SRM 51-10-02-0G-0 PARG. #9 REMOVED & REPLACED SUPPORT ANGLE P/N 7530182 SDR SWAA2022012618451Threshold · corroded***CORROSION*** AFT CARGO BAY SUB THRESHOLD BS792-847 RBL 15. / REMOVED CORROSION ON ACB SUB THRESHOLD PER SRM 51-10-02-0G-0; EVALUATED DAMAGE ORIGINAL MATERIAL THICKNESS IS .050' PER SRM 53-60-15-0I-1 TABLE 4(2); REMAINING MAT. THICKNESS IS .025' MAT. LOSS .0SDR SWAA2022012618452Stringer Clip · corroded***CORROSION*** ACB BS 867 STR26L CLIP BACK SIDE HAS CORROSION. / NO ALLOWABLE DAMAGE LIMITS LISTED IN SRM FOR CORROSION REMOVAL; REMOVED AND REPLACED STR CLIP AT BS 867 STR 26L. PER SRM 51-40-02-0G-0 AND DWG 146A1282 SHEET 124 AND 125.SDR SWAA2022012618453None · crackedACB BS 867 LBL9 WL156 ANGLE ATTACHMENT CLIP IS CRACK. / REMOVED AND REPLACED CLIP P/N 149A8109U114 IAW SRM 51-40-02-0G-0 57049U 11JUL17SDR SWAA2017080815392Support · corrodedAFT CARGO BAY FLOOR TO SIDEWALL SUPPORT CORRODED BETWEEN BS 727 TO BS 767, RBL 10. R&R SUPPORT PER SRM.SDR SWAA2017080715393Sidewall Support · corrodedAFT CARGO BAY FLOOR TO SIDEWALL SUPPORT CORRODED BETWEEN BS 847 TO 867, RBL 10. R &R THE SIDEWALL SUPPORT IAW SRM & DWG.SDR SWAA2017072515193Sidewall Support · corrodedAFT CARGO BAY FLOOR TO SIDEWALL SUPPORT CORRODED BETWEEN BS 727 TO 847, LBL 24. R & R THE SIDEWALL SUPPORT IAW SRM.
Back to Boeing 737-7Q8