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 SWAA2022020322115Floor Support · corrodedSUPPLEMENTAL INFORMATION: ***CORROSION*** AFT CARGO BAY FLOOR FLOOR SUPPORT SUPPORT TEE CORRODED AT BS 772; LBL 19 TO RBL 19. / NO ALLOWABLE DAMAGE LIMITS ARE GIVEN IN SRM FOR THIS PART. REMOVED DAMAGE FLOOR SUPPORT 'TEE' SPLICE STRAP AND REPLACED WITH NEW PARSDR SWAA2022020322113Floor Support · corrodedSUPPLEMENTAL INFORMATION: ***CORROSION*** AFT CARGO BAY FLOOR SUPPORT TEE STRAP AT BS 727D+7 CORRODED LBL 19 TO RBL 19. / ACB FLOOR SUPPORT TEE STRAP AT BS 727D+7 IS REMOVED 2ND REPLACED IAW SRM 51-40-02- AND DWG 146A7500 (NO ALLOWABLE DAMAGE FOR THIS PART)SDR SWAA2018010918900Skin · crackedSKIN CRACKED AT BS 540, STRINGER 22L. REPAIRED THE SKIN IAW ER & EA.SDR SWAA2018010318798Support Bracket · crackedAFT CARGO BAY STANCHION SUPPORT BRACKET ASSEMBLY CRACKED AT BS 867, LBL 11. R&R SUPPORT ASSEMBLY IAW SRM AND DWG.SDR SWAA2018010318797Floor Support · corrodedAFT CARGO BAY FLOOR SUPPORT CORRODED AT BS 907, LBL 4. R&R TRACK PER SRM AND DWG.SDR SWAA2018010318796Shield · corrodedAFT CARGO BAY AFT SHIELD CORRODED BETWEEN BS 847 TO BS 867, BETWEEN RBL 20 TO RBL 22. R&R SHIELD IAW DWG & SRM.SDR SWAA2018010318795Support Bracket · corrodedAFT CARGO BAY FORWARD RT BULKHEAD SUPPORT L-BRACKET CORRODED AT BS 727, STR 25R. R&R L-BRACKET PER SRM AND DWG.SDR SWAA2017121818463Shield · corrodedAFT CARGO BAY FORWARD SHIELD CORRODED BETWEEN BS 767 TO 793, BETWEEN RBL 20 TO 22. R & R THE SHIELD IAW SRM.SDR SWAA2017121818456Sidewall Support · corrodedAFT CARGO BAY RT FLOOR TO SIDEWALL SUPPORT CORRODED BETWEEN BS 727 TO 767. REPAIRED THE SIDEWALL SUPPORT IAW SRM.SDR SWAA2017121818455Sidewall Support · corrodedAFT CARGO BAY LT FLOOR SIDEWALL SUPPORT CORRODED BETWEEN BS 727 TO 847. REPAIRED THE SIDEWALL SUPPORT IAW SRM.SDR SWAA2017112818064Plate · crackedRT WING LOWER TRAILING EDGE WIGGLE PLATE CRACKED AT REAR SPAR STA 259. R&R WIGGLE PLATE IAW SRM.SDR SWAA2022020322107None · crackedSUPPLEMENTAL INFORMATION: ***CORROSION*** ON AFT SERVICE DOOR MOP SILL FROM B.S. 867-986. / CORROSION EVALUATION WAS FOUND TO BE OUT OF LIMITS; LOCATED AND DRILLED NEW MOPSILL AT AFT SERVICE DOOR AREA. MOP SILL TO BE INSTALLED ON CARD #T707244. 86750U 15NOV17SDR SWAA2018010318794Door Sill · corrodedAFT ENTRY DOOR MOP SILL CORRODED BETWEEN BS 947 TO BS 986. R&R MOPSILL PER SRM & DWG.SDR SWAA2017121918518Frame · crackedLEFT INBOARD FASTENER HOLE ON THE FRAME FOUND CRACKED AT BS 727, WL 200. REPAIRED THE FRAME IAW EA.SDR SWAA2017121918517Frame · crackedRIGHT FRAME INBOARD FASTENER HOLE CRACKED AT BS 727, WL 200. REPAIRED THE FRAME IAW EA.SDR SWAA2022020322105Angle · crackedSUPPLEMENTAL INFORMATION: FAIRING FORMING SPLICE ANGLE CRACKED AT BS 500D WS 70.5. / REMOVED DAMAGED SPLICE ANGLE AND INSTALLED NEW SPLICE ANGLE AT BS 500D; R/H WS 70.5 PER DWG # 116A3110; SH.3. AND SRM 51-40-02-0G-0; PARG.4.B. AND 7.D. 88964U 30NOV17SDR SWAA2022020322095None · crackedSUPPLEMENTAL INFORMATION: (RIGHT WING) UPPER T/E PANEL SUPPORT CRACKED AT TRANSVERSE WEB LOWER ATTACH POINT ABOVE #2 PYLON AFT TIP / REMOVED AND REPLACED THE UPPER T/E SUPPORT AT THE TRANVERSE WEB IAW SRM 51-40-02-0G-0SDR SWAA2022020322094Web · crackedSUPPLEMENTAL INFORMATION: (RIGHT WING) TRANSVERSE WEB UPPER O/B END CRACKED AT ATTACH FASTENER JUST I/B OF PROGRAM ROLLER SUPPORT ARM / REMOVED AND REPLACED THE RIGHT WING TRANSVERSE WEB IAW SRM 51-40-02-0G-0. REF. DRAWING 115A2512 FOR FASTENER CALL OUT.SDR SWAA2018010318739Attach Bracket · crackedFRAME ATTACH BRACKET CRACKED AT BS 867, STR 8R. REPAIRED BRACKET IAW EA.SDR SWAA2018010318738Attach Bracket · crackedFRAME ATTACH BRACKET CRACKED AT BS 827, STR 8R. REPAIRED BRACKET IAW EA.SDR SWAA2018010318737Attach Bracket · crackedFRAME ATTACH BRACKET CRACKED AT BS 727B, STR 8R. REPAIRED BRACKET IAW EA.SDR SWAA2018010318736Attach Bracket · crackedFRAME ATTACH BRACKET CRACKED AT BS 360, STR 8R. REPAIRED BRACKET IAW EA.SDR SWAA2018010318735Attach Bracket · crackedFRAME ATTACH BRACKET CRACKED AT BS 867, STR 8L. REPAIRED BRACKET IAW EA.SDR SWAA2018010318734Attach Bracket · crackedFRAME ATTACH BRACKET CRACKED AT BS 827, STR 8L. REPAIRED BRACKET IAW EA.SDR SWAA2018010318733Attach Bracket · crackedFRAME ATTACH BRACKET CRACKED AT BS 727B, STR 8L. REPAIRED BRACKET IAW EA.SDR SWAA2018010318732Attach Bracket · crackedFRAME ATTACH BRACKET CRACKED AT BS 360, STR 8L. REPAIRED BRACKET IAW EA.SDR SWAA2018010318731Stiffener · crackedLT HORIZONTAL STABILIZER INSPAR RIB CRACKED STA 92.70 AT 3RD VERTICAL STIFFENER IN LOWER AREA. REPAIRED STIFFENER IAW SRM.SDR SWAA2017121318426Window Frame · crackedRT NR 3 WINDOW FRAME E-F POST THE 2ND AND 3RD LOWER HOLES CRACKED. REPAIRED FRAME IAW ER AND EA.SDR SWAA2017110717667Glowstrip · inoperativeAFT GALLEY PROXIMITY LIGHT PHOTOLUMINESCENT STRIP INOP. R&R STRIP PER AMM.SDR SWAA2018010318670Rib · crackedRIGHT HORIZONTAL STABILIZER IN SPAR RIB CRACKED AT HSS 157.10. REPAIRED THE RIB IAW SRM.SDR SWAA2022020322036Intercostal · crackedNTERCOSTAL BETWEEN BS 312 AND BS 328 RBL 30 WL 208 IS CRACKED / REMOVED AND REPLACED INTERCOSTAL BETWEEN B.S 312 AND B.S 312 AND B.S 328 RBL 30 WL 208 PER SRM 51-40-05 AND SRM 51-40-02-06-0 AND DWG 147A5400 SH 4 AND 5SDR SWAA2022020322037Intercostal · cracked***CORROSION*** CORROSION ON AFT FLOORBOARD FASTENER HOLE ON INTERCOSTAL BETWEEN BS 344 AND BS 360 LBL 12 WL 208. / FOUND INTERCOSTAL TO BE CRACKED OUT OF LIMITS IAW B737 SRM CH 53-10-51-1A-1 REFER TO NON ROUTINE CARD T707255 FOR REPLACMENT OF INTERCOSTALSDR SWAA2017121918556Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 380, STR 14L. R&R CLIP PER SRM AND DWG.SDR SWAA2017121918555Stringer Clip · corrodedSTRINGER CLIP CORRODED AT BS 277, STR 4L. REPAIRED STRINGER CLIP IAW ER AND EA.SDR SWAA2017121918554Stringer Clip · corrodedSTRINGER CLIP CORRODED AT BS 277, STR 5L. REPAIRED CLIP PER ER AND EA.SDR SWAA2017121918553Intercostal · corrodedINTERCOSTAL CORRODED AT BS 294.5+6, STR 5R. R&R INTERCOSTAL PER SRM.SDR SWAA2017121918552Intercostal · crackedINTERCOSTAL CRACKED BETWEEN BS 294.5 TO BS 312, RBL 16. R&R INTERCOSTAL PER SRM AND DWG.SDR SWAA2017121918516Strap · corrodedR1 DOOR MOPSILL VERTICAL FLANGE STRAP CORRODED AT BS 294, WL 209. R & R THE STRAP IAW SRM AND DWG.SDR SWAA2017121918514Floor Support · crackedFORWARD FLOOR SUPPORT FASTENER HOLE CRACKED BETWEEN BS 344 TO 360, BL 0. R & R THE FLOOR SUPPORT IAW SRM.SDR SWAA2017121918513Floor Support · crackedFORWARD FLOOR SUPPORT FASTENER HOLE CRACKED BETWEEN BS 344 TO 360, LBL 12. R & R THE FLOOR SUPPORT IAW SRM.SDR SWAA2017121918512Floor Support · crackedFLOOR SUPPORT CRACKED BETWEEN BS 277 TO 294.5, BL 0. R & R FLOOR SUPPORT IAW SRM AND DWG.SDR SWAA2017121918511Floor Support · crackedFLOOR SUPPORT CRACKED BETWEEN BS 312 TO 328, LBL 45 R & R THE FLOOR SUPPORT IAW SRM AND DWG.SDR SWAA2017121818454Frame · crackedABOVE FORWARD ENTRY DOOR MAIN SILL FRAME CRACKED AT BS. 312. REPAIRED FRAME IAW ER AND EA.SDR SWAA2022020221227Panel · corrodedR/W SLAT COVE PANEL 623CB IS CORRODED / FABRICATED AND DRILLED REPLACEMENT R/W #6 SLAT COVE PANEL 623CB IAW DWG.141A8131SDR SWAA2017121918510Support Beam · crackedRT WING LOWER PANEL SUPPORT BEAM CRACKED AT ORSS. 287. R & R THE SUPPORT BEAM IAW SRM AND DWG.SDR SWAA2022020322033Fairing · delaminatedFAIRING 643AB OUTER SKIN HAS DISBONDED DENT 8' FROM LEADING EDGE. (MARKED) / FAIRING 643AB WITH OUTER SKIN DISBONDED DENT 8' FRAM LEADING EDGE AS MARKED WAS REPLACED WITH A SERVICEABLE FAIRING AND WILL BE INSTALLED ON SA-M 565E CARD #JPANEL-640-CLOSE. *** (POSSDR SWAA2017121918509Skin · crackedRT WING FAIRING 642BB INNER SKIN CRACKED JUST FORWARD OF OUTBOARD AFT DRAIN HOLE. REPAIRED THE SKIN IAW ER & EA.SDR SWAA2017121918508Skin · crackedLEFT WING FAIRING 544BB INNER SKIN CRACKED JUST FORWARD OF AFT FITTING. REPAIRED THE SKIN IAW ER & EA.SDR SWAA2017120418212Floorbeam · crackedFLOOR BEAM CRACKED AT BS. 294, RBL 52. / REPAIRED FLOOR BEAM PER EA.SDR SWAA2022020321737Fairing · out of tolerance#3 AFT FLAP TRACK FAIRING #1 HOLE DIAMETER OUT OF LIMITS / #3 AFT FLAP TRACK FAIRING #1 HOLE DIAMETER OUT OF LIMITS OF SWA ACO #7996-57 WAS REPAIRED PER SWA EA #1-757-14582 REV IR DATED 27-NOV-2017 AND ATS ER #17-04952 REV IR DATED 24-NOV-2017
Back to Boeing 737-7Q8