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 SCNA20190627104Support Fitting · corrodedMAIN CABIN FWD WET AREA STA 344 LBL64 SUPPORT FITTING CORRODED. REMOVED CORRODED MOUNT AND INSTALLED NEW MOUNT.SDR SCNA20190627103Mount · corrodedMAIN CABIN FWD WET AREA STA 312 LBL 64 SUPPORT MOUNT IS CORRODED. REMOVED CORRODED MOUNT AND INSTALLED NEW MOUNT.SDR SCNA20190627102Intercostal · crackedMAIN CABIN FWD WET AREA STA 270 TO 277 BL0 INTERCOSTAL CRACKED. REMOVED AND INSTALLED NEW WET AND MAIN CABIN FWD AREA STA 270 TO STA 277 BLO.SDR SCNA20190627101Intercostal · crackedMAIN CABIN FWD WET AREA STA 277 TO 294.5 BL0 INTERCOSTAL CRACKED. REMOVED AND INSTALLED NEW WET AND MAIN CABIN FWD AREA STA 277 TO 294.5 BLO.SDR SCNA20190627100Floorbeam · corrodedMAIN CABINFWD WET AREA STA 328 RBL 47 FLOORBEAM UPPER FLANGE SHOWS CORROSION. REMOVED AND REPLACED FLOORBEAM UPPER FLANGE AT STA 328 RBL 47.SDR SCNA20190627099Floorbeam · corrodedMAIN CABIN FWD WET AREA STA 328 RBL24 FLOORBEAM UPPER FLANGE CORRODED. REMOVED AND REPLACED FLOORBEAM UPPER FLANGE ONBS 328 RBL0 TO .63.SDR SCNA20190627098Intercostal · crackedMAIN CABIN FWD WET AREA STA 312 TO 328 RBL 33 INTERCOSTAL IS CRACKED. REMOVED AND INSTALLED NEW WER IN MAIN CABIN FWD AREA STA 312-320 RBL 33.SDR SCNA20190627097Floor Panel · damagedDAMAGED FLOOR PANEL 231CF AT CORNER. REPAIRED DAMAGED FLOOR PANEL 231CF AT CORNER.SDR SCNA20190627096Floor Panel · damagedDAMAGED FLOOR PANEL 231BF AT CORNER. REPAIRED DAMAGED FLOOR PANEL 231 BF AT CORNER.SDR SCNA20190627095Scuff Plate · crackedAFT DOOR CARGO DOOR SCUFF-PLATE CRACKED. LOCATED AND DRILLED AFT DOOR CARGO DOOR SCUFF PLATE. INSTALLED NEW SCUFF PLATE.SDR SCNA20190627094Shear Web · corrodedSTATION 986.5 RT SIDE CLOSE OUT WEB HAS CORROSION ON TOP AND BOTTOM SIDE. REMOVED + REPLACED LT + RT SHEAR WEB FROM STATION 986-1016.SDR SCNA20190627093Strap · corrodedAT STATION 1016 SHEAR WEB STRAP ON RT SIDE HAS CORROSION. REMOVED + REPLACED SHEAR WEB STRAP @ STA 1016 RT O/B.SDR SCNA20190627092Strap · corrodedAT STATION 1016 SHEAR WEB STRAP AT RBL 25 HAS CORROSION. REMOVE + REPLACED STRAP @ STP 1016 RBL 25.SDR SCNA20190627091Strap · corrodedAT STATION 1016 SHEAR WEB STRAP AT RBL 0 HAS CORROSION. REMOVED + REPLACED SHEAR WEB STRAP @ STA 1016 RB10.SDR SCNA20190627090Strap · corrodedAT STATION 1016 SHEAR WEB STRAP HAS CORROSION AT LBL 0. REMOVED + REPLACED STRAP @ STATION 1016 SHEAR WEB @ LBL 0.SDR SCNA20190627089Floorbeam · corrodedFLOORBEAM AT STATION 947.5 LT SIDE HAS CORROSION. CORROSION ALSO IS RUNNING UNDER L-2 DOOR INNER CHORD. REPAIRED FLOORBEAM UPPER T-CAP @ STA 947.5 THE ENTIRE CAP.SDR SCNA20190627088Door Sill · corrodedL-2 DOOR INNER CHORD DOOR SILL HAS CORROSION. REMOVED AND REPLACED L-2 INNER CHORD DOOR SILL.SDR SCNA20190627087Floorbeam · corrodedAFT FLOORBEAM, BS 986.5 RBL 13 TO DOOR SILL HAS CORROSION. REPLACED UPPER T-CAP @ STP 986.5.SDR SCNA20190627086Floorbeam · corrodedAFT FLOORBEAM, BS 986.5 RBL 0 TO RBL 13 HAS CORROSION. ALL WORK ACCOMPLISHED.SDR SCNA20190627085Floorbeam · corrodedAFT FLOORBEAM BS 986.5, LBL 0, TO LBL 13. HAS CORROSION. ALL WORK ACCOMPLISHED.SDR SCNA20190627084Bracket · corrodedAFT FLOORBEAM, BS 992.8 LBL24 GALLEY MOUNT HAS CORROSION. FABRICATED NEW BRACKET AFT FLOORBEAM BS 992.8 LBL 24.SDR SCNA20190627083Floorbeam · corrodedAFT FLOORBEAM, BS 986.5, LBL13N TO DOOR SILL HAS CORROSION. ALL WORK ACCOMPLISHED.SDR SCNA20190627082Intercostal · crackedMAIN CABIN FWD WET AREA STA 312 TO 328 LT INTERCOSTAL CRACKED. REMOVED AND REPLACED ON MAIN CABIN FWD WET AREA STA 312 TO 328 LT INTERCOSTAL.SDR SCNA20190627081Attach Angle · corrodedL1 MAIN CABIN DOOR MOP SILL ATTACH ANGLE HAS CORROSION. REMOVED AND REPLACED ANGLE AT L1 MAIN CABIN DOOR MOP SILL.SDR SCNA20190627080Door Sill · corrodedL1 MAIN CABIN DOOR MOP SILL HAS CORROSION. REMOVED AND REPLACED L1 MAIN CABIN CARGO DOOR MOP SILL.SDR SCNA20190627079Attach Angle · corrodedRI MAIN CABIN DOOR MOP SILL ATTACH ANGLE HAS CORROSION. REMOVED AND REPLACED ANGLE AT R1 MAIN CABIN DOOR-MOP SILL.SDR SCNA20190627078Door Sill · corrodedR1 CABIN DOOR MOP SILL HAS CORROSION. REMOVED AND REPLACED R1 CABIN DOOR MOP SILL.SDR SCNA20190627077Seal · brokenPANEL 671CB HAS ATTACHING PANEL WITH SEAL THAT IS BROKEN. REPAIRED PANEL 671CB. RESTORED FINISH.SDR SCNA20190627076Support Rod · wornRT LOWER TRAILING EDGE PNL SUPPORT ROD ATTACH POINTS WORN, ROD IS LOOSE. (AT WS 317, MARKED WITH STREAMER). REMOVED RT TE PNL SUPPORT ROD. REPLACED BUSHINGS AND INSTALLED ROD.SDR SCNA20190627075Panel · damagedPANEL 621LB ENLARGED HOLE. REPAIRED PNL 621LB.SDR SCNA20190627074Panel · damagedDAMAGED FASTENER HOLES IN PANEL 521JB (2 EACH). REPAIRED DAMAGED FASTENER HOLES ON PANEL 521JB (2 EACH) AND PRIMED PANEL 521JB AND PAINTED PANEL 521JB.SDR SWAA2019062834246Bracket · out of adjustL1 DOOR GIRT BAR HANGER OUT OF ADJUST. ADJUSTED THE GIRT BAR BRACKET PER SIP.SDR SWAA2019062834253Battery · inoperativeL2 DOOR HEADER PANEL EMERGENCY EXIT LIGHT INOP. R&R BATTERY M1672 IAW AMM.SDR SWAA2019062834252Battery Pack · inoperativeAFT ENTRY LOWERED CEILING PANEL EMERGENCY EXIT LIGHT INOPERATIVE. R&R M1672 BATTERY PACK IAW AMM.SDR SWAA2019062654112Lens · detachedR/H EMERGENCY EXIT SIGN COVER ROW POPPED OFF. REATTACHED COVER PER SIP.SDR SWAA2022031015844Panel · elongatedWING TO BODY FAIRING PANEL 193B HAS ENLARGED FASTENER HOLES AT LOCATIONS 1-8;10; 13-20; 24-38 MOD / REMOVED/REPLACED 193B PANEL REF B737 AMM 53-51-21 & SRM 51-20-07.SDR SWAA2022031022408Bracket · crackedRIGHT WING INBOARD FIXED TRAILING EDGE UPPER ADJUSTABLE PANEL SEAL SUPPORT BRACKET IS CRACKED AT THE FASTENER / REMOVED AND REPLACED RIGHT WING INBOARD FIXED TRAILING EDGE UPPER ADJUSTABLE PANEL SEAL SUPPORT BRACKET PER MM 20-50-11SDR SWAA2019061933914Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1673. R&R BATTERY PER AMM.SDR SWAA2022031017273Baffle · brokenFWD CARGO COMPARTMENT RBL 25 BS 500C WL156 FWD SIDE OF FRAME; BAFFLE CLIP BROKEN / REMOVED AND REPLACED BAFFLE CHIP AT BS 500C RBL 25 WL 156 FWD SIDE OF FRAME PER SRM 51-40-02-0G-0 AND BOEING DWG #143A7505 92385U 06/17/19 PART #143A7502U158SDR SWAA2019061433760Battery · no testR/H AFT EMERGENCY BATTERY FAILED CAPACITY CHECK. / R&R BATTERY PER AMM.SDR SWAA2019061433759Battery Pack · no testR/H FORWARD EMERGENCY BATTERY FAILED CAPACITY CHECK. / R&R BATTERY PACK PER AMM.SDR SWAA2019061433758Battery Pack · no testL/H FORWARD EMERGENCY BATTERY FAILED CAPACITY CHECK. / R&R BATTERY PACK PER AMM.SDR SWAA2019061433757Slide · looseL1 DOOR SLIDE CAME LOOSE FROM THE COMPONENT. / REINSTALLED SLIDE IAW MT.SDR SWAA2022031017267Doubler · crackedR/H 663 VAPOR BARRIER HORSESHOE DOUBLER CRACKED WL 145 RBL 27 / LOCATED AND DRILLED R/H 663 VAPOR BARRIER HORSESHOE DOUBLER IAW SRM 51-40-05 AND DWG 111A1515. REFERENCE CUSTOMER NRC N205045 FOR REMOVAL AND INSTALLATIONSDR SWAA2022031017265Structure · corrodedL/H HORIZONTAL STABILIZER L/E HAS PITTING ALONG THE LEADING EDGE FROM STATION 69.93 TO STATION 281.81 / ORDERED & RECEIVED SERVICABLE L/H HORIZONTAL LEADING EDGE. REFER TO CUST CARD 755-070-01-01Y FOR INSTALLATION (POS:L/H; TAG NO.:513863; P/N OFF:186A1001-15;SDR SWAA2019062834251Attach Angle · crackedL/H MAIN WHEEL WELL LOWER ATTACH ANGLE CRACKED AT BS. 663, LBL 35. REPAIRED ANGLE PER ER AND EA.SDR SWAA2019061433774Baffle · crackedAFT CARGO BAY BAFFLE CRACKED BETWEEN BS. 747 TO BS. 767, RBL 17. R&R BAFFLE IAW SRM AND DWG.SDR SWAA2019061433773Baffle · crackedAFT CARGO BAFFLE CRACKED BETWEEN BS. 727A TO BS. 727B, RBL 25. R&R BAFFLE IAW SRM AND DWG.SDR SWAA2019061433772Floor Support · crackedINTERCOSTAL CRACKED BETWEEN BS. 426 TO BS. 440, RBL 24. R&R INTERCOSTAL IAW SRM AND DWG.SDR SWAA2019061433771Attach Angle · corrodedAFT CARGO FORWARD SHIELD ATTACH ANGLE COMMON TO THE SHIELD CORRODED BETWEEN BS. 767 TO BS. 787, RBL 22. R&R ANGLE PER SRM & DWG.
Back to Boeing 737-7Q8