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 SWAA2018010918947Slide · out of positionR2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER AMM AND MT.SDR SWAA2018010918946Connector · disconnectedRT EMERGENCY EXIT LIGHT INOP AT ROW 19. RECONNECTED CONNECTOR IAW WDM AND AMM.SDR SWAA2022020722555Fairing · delaminatedPANEL 193AR HAS PUNCTURES & DELAMINATION ON INNER SURFACE CORE AREA / PANEL 193 AR PUNCTURES AND DELAMINATION ON INNER SURFACE CORE AREA REPAIRED IAW SRM 51-70-05-2R-2 20549U_10529C 1/13/18SDR SWAA2022020722548Stiffener · crackedLEFT HORIZONTAL STABILIZER VERTICAL STIFFENER LOWER END IS CRACKED AT STAB STA 92.70 3RD AFT OF FORWARD SPAR / TRIMMED CRACK OUT; 1.75' X 0.167'; NDL NO DEFECTS NOTED; REPAIRED IAW SRM 55-10-09-2R-4; LH HORIZONTAL STAB RIB STA 92.70 3RD STIFFENER AFT OF FWD SPSDR SWAA2018021919844Stiffener · crackedLEFT HORIZONTAL STABILIZER VERTICAL STIFFENER, LOWER END CRACKED AT HSS 92.70. R & R THE STIFFENER IAW SRM.SDR SWAA2018021919843Window Frame · crackedNR 1 LT FLIGHT DECK WINDOW FRAME CRACKED IN THE CORNER. REPAIRED THE WINDOW FRAME IAW ACO.SDR SWAA2018021919776Skin · crackedRIGHT WING NR 8 SLAT LOWER LEADING EDGE, CRACKED AT FASTENER. REPAIRED TH ESLAT SKIN IAW SRM.SDR SWAA2018021419675Stiffener · crackedLEFT HORIZONTAL STABILIZER VERTICAL STIFFENER, LOWER END CRACKED AT HSS 92.70, AFT OF FORWARD SPAR. REPAIRED THE STIFFENER IAW SRM.SDR SWAA2018013119467Rib · crackedLT HORIZONTAL STABILIZER LEADING EDGE PANEL RIB CRACKED AT LEADING EDGE STA 95.96. R&R RIB IAW SRM & DWG.SDR SWAA2022020722537Retainer · crackedLT WING TRAILING EDGE BULB SEAL RETAINER; ABOVE #1 AFT FAIRING TIP; CRACKED (MARKED) / REMOVED LEFT WING TRAILING EDGE BULB SEAL RETAINER ABOVE #1 AFT FAIRING TIP WITH CRACK DAMAGE AND INSTALLED NEW PART SAME LOCATIONABOVE IAW SRM 51-40-02-0G-0 AND AIPC 57-50-SDR SWAA2022020722527Retainer · cracked(RIGHT WING) T/E COVE SEAL RETAINER IS CRACKED ABOVE #2 PYLON AFT TIP / REMOVED RIGHT WING T/E COVE SEAL RETAINER WITH CRACK DAMAGE ABOVE #2 PYLON AFT TIP AND INSTALLED NEW PART SAME LOCATION ABOVE IAW AIPC 57-50-00-25 AND SRM 51-40-02.SDR SWAA2022020722536Support Bracket · crackedUPPER T.E. PANEL LOWER SUPPORT BRACKET CRACKED AT TRANSVERSE WEB LOWER ATTACH POINT; ABOVE #1 AFT FAIRING TIP (MARKED) / REMOVED UPPER TRAINING EDGE PANEL LOWER SUPPORT BRACKET CRACKED AT TRANSVERSE WEB LOWER ATTACH POINT ABOVE #1 AFT FAIRING TIP AND INSTALLEDSDR SWAA2018021919812Support Angle · crackedRIGHT WING UPPER TRAILING EDGE PANEL LOWER SURFACE, THE SUPPORT ANGLE WAS FOUND CRACKED. R & R THE SUPPORT ANGLE IAW SRM.SDR SWAA2018021919775Web · crackedRIGHT WING TRANSVERSE WEB CRACKED AT THE OTBD UPPER ATTACH FASTENER JUST INBOARD OF PROGRAM ROLLER SUPPORT ARM ATTACH POINT. R & R THE WEB IAW SRM.SDR SWAA2018021919767Attach Angle · crackedRIGHT WING RSS. 80 UPPER TRAILING EDGE SUPPORT BEAM TO REAR SPAR, ATTACH ANGLE CRACKED. R & R THE ATTACH ANGLE IAW SRM.SDR SWAA2018021519674Frame · crackedFRAME CRACKED AT BS 480, STRINGER 8R. REPAIRED THE FRAME IAW ER AND EA.SDR SWAA2018021519673Shear Tie · corrodedAFT CARGO BAY BILGE SHEAR TIE CORRODED AT BS 727B, LBL 19. R & R THE SHEAR TIE IAW SRM AND DWG.SDR SWAA2018020819592Post · crackedLT NR 3 WINDOW FRAME E-F POST CRACKED AT THE 2ND AND 3RD LOWER HOLES. REPAIRED POST IAW EA.SDR SWAA2018020819503Stringer Clip · corrodedAFT CARGO BAY BILGE, STRINGER CLIP CORRODED AT BS 807, RBL 14.5. R&R CLIP IAW SRM AND DWG.SDR SWAA2018020819502Door Sill · corrodedAFT CARGO BAY DOOR CUTOUT AFT LOWER MAIN SILL LOWER SURFACE CORRODED BETWEEN BS 847+9 TO BS 867, RBL 22. R&R SHIELD WEB IAW SRM AND DWG.SDR SWAA2018020819501Intercostal · corrodedAFT CARGO BAY DOOR CUTOUT FORWARD LOWER MAIN SILL INTERCOSTAL CORRODED BETWEEN BS 787 TO BS 787+7, RBL 23.5. R&R INTERCOSTAL IAW SRM AND DWG.SDR SWAA2018020819500Intercostal · corrodedAFT CARGO BAY BILGE INTERCOSTAL UPPER CHORD LOWER SURFACE CORRODED BETWEEN BS 747 TO BS 767, RBL 22. R&R INTERCOSTAL IAW SRM.SDR SWAA2018020819499Support · corrodedAFT CARGO BAY RT FLOOR TO SIDEWALL SUPPORT CORRODED BETWEEN BS 727 TO BS 767. R&R SUPPORT PER SRM & DWG.SDR SWAA2018020819498Support · corrodedAFT CARGO BAY LT FLOOR TO SIDEWALL SUPPORT CORRODED BETWEEN BS 727 TO BS 727D+12. R&R SUPPORT IAW DWG & SRM.SDR SWAA2022020722513Frame · crackedTHE STR 8R AIR CONDITIONING ATTACH BRACKET FRAME IS CRACKED AT BS 827 AROUND THE I/B FASTENER / REPAIRED STR 8R AIR CONDITIONING ATTACH BRACKET FRAME AT BS 827 I.A.W. E.A. 1-A53-12114 REV 4 88302U 06JAN18SDR SWAA2022020722511Frame · crackedTHE STR 8L AIR CONDITIONING ATTACH BRACKET FRAME IS CRACKED AT BS 867 AROUND THE I/B FASTENER. / ACCOMPLISHED STR 8L AIR CONDITIONING ATTACH BRACKET FRAME REPAIR AT BS 867 PER EA 1-A53-12114 REV 4 DATE 11/12/2009SDR SWAA2018021919833Frame · crackedFRAME CRACKED AT BS 747, STRINGER 8L. R & R THE FRAME IAW ER AND EA.SDR SWAA2018021919766Frame · crackedFRAME CRACKED AT BS 907, STRINGER 8R. REPAIRED THE FRAME IAW ER AND EA.SDR SWAA2018021919765Frame · crackedFRAME CRACKED AT BS 867, STRINGER 8R. REPAIRED THE FRAME IAW EA.SDR SWAA2018021519680Frame · crackedFRAME CRACKED AT BS 727D, STRINGER 8R. R & R THE FRAME IAW ER & EA.SDR SWAA2018021419672Frame · crackedFRAME CRACKED AT BS 727A, STRINGER 8R. REPAIRED THE FRAME IAW EA.SDR SWAA2018021419660Frame · crackedFRAME CRACKED AT BS 440, STRINGER 8R. REPAIRED THE FRAME IAW EA.SDR SWAA2018021419652Frame · crackedFRAME CRACKED AT BS 827, STRINGER 8L. REPAIRED THE FRAME IAW EA.SDR SWAA2018021419651Frame · crackedFRAME CRACKED AT BS 480, STRINGER 8L. REPAIRED THE FRAME IAW EA.SDR SWAA2018021419650Skin · crackedR1 DOOR CUTOUT LOWER FORWARD CORNER CRACKED AT BS 294.3, RBL 53. REPAIRED IAW EA.SDR SWAA2018020819496Splice · corrodedSPLICE CORRODED AT BS, 663.75, BETWEEN STR 9L TO STR 10L. R&R SPLICE IAW SRM AND DWG.SDR SWAA2018013119466Frame · crackedFRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2018013119465Frame · crackedFRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2018010518871Lens · missingLT OVERWING EMERGENCY EXIT LIGHT LENS MISSING. INSTALLED LENS PER MM.SDR SWAA2018021919764Plate · crackedFORWARD CARGO, RT GUSSET PLATE CRACKED AT BS 500D, STRINGER 19R. R & R THE GUSSET PLATE IAW SRM.SDR SWAA2018021419659Gusset · crackedFORWARD CARGO LT GUSSET PLATE CRACKED AT BS 500D, STRINGER 19L. R & R THE GUSSET IAW SRM.SDR SWAA2018020819495Angle · corrodedFORWARD CARGO AFT BULKHEAD TO SIDEWALL SUPPORT ANGLE CORRODED AT BS 500D, RBL 24. R&R ANGLE IAW SRM AND DWG.SDR SWAA2018020819494Angle · corrodedFORWARD CARGO AFT BULKHEAD TO SIDEWALL SUPPORT ANGLE CORRODED AT BS 500D, LBL 24. R&R ANGLE IAW SRM AND DWG.SDR SWAA2018020819493Angle · corrodedFORWARD CARGO AFT BULKHEAD TO FLOOR SUPPORT ANGLE, CORRODED AT BS. 500D, BETWEEN LBL 22 TO RBL 22. R&R ANGLE IAW SRM & DWG.SDR SWAA2018020819492Threshold · corrodedFORWARD CARGO DOORWAY LOWER THRESHOLD WEB CORRODED BETWEEN BS 440 TO BS 495. R&R WEB IAW DWG & SRM.SDR SWAA2018021919763Floor Support · crackedFLOOR SUPPORT CRACKED BETWEEN BS 294.5 TO 312, RBL 1. R & R THE FLOOR SUPPORT IAW SRM AND DWG.SDR SWAA2018020819491Door Sill · corrodedL2 DOOR MOP SILL CORRODED AT LBL 50. R&R MOP SILL PER SRM AND DWG.SDR SWAA2018020819490Door Sill · corrodedR2 DOOR MOP SILL CORRODED, RBL 50. R&R MOP SILL PER SRM & DWG.SDR SWAA2018020819489Intercostal · crackedFLOOR STRUCTURE INTERCOSTAL CRACKED BETWEEN BS 344 TO BS 360, LBL 5. R&R INTERCOSTAL IAW SRM AND DWG.SDR SWAA2018020819488Intercostal · crackedFLOOR STRUCTURE INTERCOSTAL CRACKED BETWEEN BS 312 TO BS 328, LBL 47. R&R INTERCOSTAL IAW SRM AND DWG.
Back to Boeing 737-7Q8