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 SWAA2022021115083Retainer · crackedLEFT WING INBOARD FLAP OUTBOARD LEADING EDGE SEAL RETAINER IS CRACKED. / REMOVED AND REPLACED LEFT WING INBOARD FLAP OUTBOARD LEADING EDGE SEAL RETAINER IAW SRM 51-40-02SDR SWAA2022021115085Vapor Barrier · crackedRH W/W LOWER WEB IS CRACKED VERTICALLY APPROX. 10' LONG AT STA 663.75 AT RBL 10.845 / PERFORMED PERMANAANT REPAIR ON CRACK PORTION LOCATED IN VAPOR BARRIER BAY 2R SRM 51-70-04. REPAIR 10 SEE NRC# D294008 FOR REMAINDER OF CRACK LOCATED IN BAY 1R.SDR SWAA2018031220356Battery Pack · no testM1672 BATTERY PACK FAILED A CAPACITY CHECK. R & R THE BATTERY PACK IAW AMM.SDR SWAA0121030120347Beam · crackedR1 DOOR BEAM FORWARD INBOARD FASTENER CRACKED AT THE RADIUS. R & R THE DOOR IAW AMM.SDR SCNA20180226066Skin · wornFOUND WEAR DAMAGE ON THE RIGHT WING OUTBOARD TRAILING EDGE AFT FLAP SKIN JUST OUTBOARD OF THE NR 7 FLAP TRACK FAIRING DURING RIGHT WING INSPECTION. THE THICKNESS OF THE SURFACE SKIN IS COMPLETELY WORN THROUGH DOWN TO THE COMPOSITE CORE TOWARDS THE AFT PORTION SDR SWAA2018022220011Fuse · blownLT OVERWING AFT EMERGENCY LIGHT INOP. R&R FUSE PER AMM.SDR SWAA2018022220009Fuse · blownLT BULLNOSE EMERGENCY LIGHT INOP AT ROW 9. R&R FUSE PER AMM.SDR SWAA2018022019920Light · missingCEILING PANEL EMERGENCY LIGHT ASSEMBLY MISSING AT BS 898, BL 0. INSTALLED LIGHT ASSEMBLY PER SOPM.SDR SWAA2018022019875Slide · out of positionL2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MT.SDR SWAA2018021419670Lamp · inoperativeLEFT OVERHEAD EMERGENCY LIGHT INOPERATIVE AT ROW 9. REPLACED THE LAMPS IAW AMM.SDR SWAA2018021319684Floor Support · crackedFLOOR SUPPORT CRACKED BETWEEN BS 312 TO 328, LBL 45. R & R THE FLOOR SUPPORT IAW SRM AND DWG.SDR SWAA2018021919846Battery · inoperativeEMERGENCY LIGHT BATTERY AT M1674 INOPERATIVE. R & R THE BATTERY IAW AMM.SDR SWAA2018022119980Bracket · crackedFORWARD CARGO BAY INTERCOSTAL BRACKET CRACKED AT BS. 500C, STRINGER 26L. R & R THE BRACKET IAW ER & EA.SDR SWAA2018021319683Bracket · crackedFORWARD CARGO BAY DRAIN LINE BRACKET CRACKED AT BS 500C, BETWEEN STRINGERS 24 TO 25L. R & R THE BRACKET IAW SRM & DWG.SDR SWAA2018020819614Glowstrip · inoperativeAFT FLOOR PHOTO ILLUMINESCENT STRIP INOP. R&R STRIP PER AMM.SDR SWAA2018020719521Pressure Panel · crackedRT WHEEL WELL VERTICAL WEB CRACKED AT BS 663, RBL 43. REPAIRED WEB PER EA.SDR SWAA2018013019437Light · inoperativeRT EMERGENCY LIGHT INOP AT ROW 11. RELAMPED LIGHT IAW AMM.SDR SWAA2018013019436Light · inoperativeR2 DOOR EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT IAW AMM.SDR SWAA2022020822602Scuff Plate · crackedACB AFT SCUFF PLATE IS CRACKED / ACB AFT SCUFF PLATE WAS REPAIRED PER EA 1-A53-2096 REV 11SDR SWAA2018020819613Scuff Plate · crackedFORWARD CARGO BAY FORWARD AND AFT SCUFF PLATE CORNERS CRACKED. R&R SCUFF PLATE IAW SRM AND DWG.SDR SWAA2018020819612Intercostal · crackedFORWARD CARGO BAY INTERCOSTAL CRACKED BETWEEN BS 500D TO BS 520, STR 28L. R&R INTERCOSTAL IAW DWG AND SRM.SDR SWAA2022020822601None · brokenLT WING LOWER T/E ATTACH CLIP FOR PANEL 551EB INBD ATTACH POINT IS BROKEN / REMOVED AND REPLACED LT WING LOWER T/E ATTACH CLIP FOR PANEL 551EB INBD ATTACH POINT IAW SRM 51-40-02-0G-0 AND AIPC 57-50-00-23.SDR SWAA2018020819533Rib · crackedRIGHT HORIZONTAL STABILIZER LEADING EDGE RIB CRACKED AT HSS 151.75. R & R THE RIB IAW SRM AND DWG.SDR SWAA2018012919358Slide · out of positionR1 DOOR EMERGENCY EVAC SLIDE GIRT BAR OUT OF POSITION. REPOSITIONED SLIDE PER MT.SDR SWAA2022020722589Retainer · crackedLT WING I/B FLAP O/B AFT UPPER SEAL RETAINER IS CRACKED / REMOVED AND REPLACED LT WING I/B FLAP O/B AFT UPPER SEAL RETAINER IAW SRM 51-40-02-0G-0.SDR SWAA2018022620066Support Fitting · corrodedRT MAIN GEAR FORWARD TRUNNION SUPPORT FITTING CORRODED. REPAIRED FITTING PER EA.SDR SWAA2018022620061Support Fitting · corrodedLT MAIN GEAR FORWARD TRUNNION LUG FACE SUPPORT FITTING CORRODED. REPAIRED FITTING PER EA.SDR SWAA2018022220008Support Fitting · corrodedLT MAIN GEAR FORWARD TRUNNION LUG FACE SUPPORT FITTING CORRODED. REPAIRED FITTING PER EA.SDR SWAA2018022119979Frame · corrodedFRAME CORRODED AT BS 927, BETWEEN STRINGERS 18L TO 19L. REPAIRED THE FRAME IAW EA.SDR SWAA2018021919842Shear Tie · corrodedSHEAR TIE CORRODED AT BS 867, BETWEEN STRINGERS 23L TO 25L. R & R THE SHEAR TIE IAW SRM AND DWG.SDR SWAA2018021919780Floorbeam · corrodedCOCKPIT FLOORBEAM UPPER TEE CORRODED AT BS 270, BETWEEN BL 0 TO RBL 8. REPAIRED THE FLOORBEAM TEE IAW EA.SDR SWAA2018022119978Bear Strap · corrodedAFT CARGO DOOR BEAR STRAP CUTOUT LOWER AFT CORNER CORRODED AT BS 845, BETWEEN STRINGERS 23R TO 24R. REPAIRED IAW ER & EA.SDR SWAA2018021919841Support · corrodedAFT GREY WATER DRAIN MAST INTERNAL SUPPORT STRUCTURE CORRODED BETWEEN BS 987 TO 1000, STRINGERS 24L TO 25L. R & R THE SUPPORT IAW SRM AND DWG.SDR SWAA2018021919840Frame · corrodedFRAME CORRODED AT BS 987, BETWEEN STRINGER 27L TO 27R. REPAIRED THE FRAME IAW ER AND EA.SDR SWAA2018021319682Frame · corrodedAFT CARGO BAY UPPER FLANGE OF FRAME CORRODED AT BS 947, BL 0. R & R FRAME IAW SRM & DWG.SDR SWAA2018020819527Rib · crackedRIGHT HORIZONTAL STABILIZER LEADING EDGE RIB FOUND CRACKED AT HSS 105.26. R & R THE RIB IAW SRM & DWG.SDR SWAA2018020819525Fitting · corrodedRIGHT MAIN LANDING GEAR FORWARD TRUNNION LUG FACE FITTING CORRODED. REPAIRED THE FITTING IAW EA.SDR SWAA2018021919839Skin · delaminatedLEFT WING NR 3 SLAT DELAMINATED, ON THE UPPER TRAILING EDGE WEDGE. R & R THE NR 3 SLAT IAW MM.SDR SWAA2018020819594Fitting · corrodedAFT CARGO BAY TIE DOWN FITTING UPPER SURFACE CORRODED AT BS 791, STR 24L. R&R FITTING IAW DWG & SRM.SDR SWAA2018022119977Deck Plate · crackedHORIZONTAL PRESSURE DECK CRACKED AT BS 664, LBL 33. REPAIRED THE DECK IAW ER & EA.SDR SWAA2018021319681Rib · crackedRIGHT HORIZONTAL STABILIZER RIB CRACKED AT HSS 129.5 THIRD VERTICAL STIFFENER. REPAIRED THE RIB IAW SRM.SDR SWAA2018022220007Skin · corrodedFORWARD SKIN OF CORRODED AT BS 887, BETWEEN STR 23R TO STR 26R. REPAIRED SKIN PER ER AND EA.SDR SWAA2018022220006Skin · corrodedAFT SKIN CORRODED AT BS 887, BETWEEN STR 24L TO STR 26L. REPAIRED SKIN PER ER AND EA.SDR SWAA2018022220005Skin · corrodedFUSELAGE FORWARD SKIN CORRODED AT BS 887, BETWEEN STR 23L TO STR 26L. REPAIRED SKIN PER ER & EA.SDR SWAA2018022119976Skin · corrodedFORWARD AND AFT EDGE OF LAVATORY SERVICE PANEL SKIN CORRODED. REPAIRED THE SKIN IAW ER AND EA.SDR SWAA2018022119975Skin · corrodedSKIN CORRODED AT BS 967, BETWEEN STRINGERS 26L TO 27L. REPAIRED THE SKIN IAW ER & EA.SDR SWAA2018011719139Lens · noneRIGHT LOWER EXTERNAL EMERGENCY EXIT LIGHT LENS DIRTY. CLEANED LENS IAW SOPM.SDR SWAA2018011719083Hook · looseR2 DOOR SLIDE GIRT BAR STOW HOOK LOOSE. SECURED THE HOOKS IAW SIP.SDR SWAA2018021919845Rib · crackedRIGHT HORIZONTAL STABILIZER RIB CRACKED AT HSS 92.7. REPAIRED THE RIB IAW EA.SDR SWAA2018021419687Rib · crackedLEFT HORIZONTAL STABILIZER RIB CRACKED AT HSS 92.70, AFT LOWER ATTACH HOLE FLANGE ON INBOARD SIDE. REPAIRED THE RIB IAW ER AND EA.
Back to Boeing 737-7Q8