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 SWAA2016100308396Stringer Clip · corrodedSTRINGER CLIP 15L CORRODED AT BS 716. R & R THE STRINGER CLIP SRM.SDR SWAA2016082355064Engine · failedRIGHT ENGINE TURBINE FAILURE AFTER TAKEOFF AT 1500' AGL SHUTDOWN ENGINE. DECLARED AN EMERGENCY, AND RETURNED TO DEPARTURE. R & R THE NR 2 ENGINE IAW MT.SDR SWAA2016102409053Intercostal · crackedINTERCOSTAL CRACKED BETWEEN BS 277 TO BS 294, RBL 1. R&R INTERCOSTAL PER SRM.SDR SWAA2016101808889Frame · crackedSTUB FRAME CRACKED AT BS 294, WL 208. R&R STUB FRAME PER SRM.SDR SWAA2016100308395Floor Support · crackedFLOOR SUPPORT CRACKED BETWEEN BS 344 TO 360, LBL 12. R & R THE FLOOR SUPPORT IAW SRM.SDR SWAA2016091907964Intercostal · crackedINTERCOSTAL CRACKED BETWEEN BS 344 TO 360, LBL 1. R & R THE INTERCOSTAL IAW SRM.SDR SWAA2016091607879Floor Support · crackedFLOOR SUPPORT CRACKED BETWEEN BS 294 TO 312, RBL 16. R & R THE FLOOR SUPPORT IAW DWG & SRM.SDR SWAA2016091607878Floor Support · crackedFLOOR SUPPORT CRACKED BETWEEN BS 312 &. 328, RBL 34. R & R FLOOR SUPPORT IAW SRM & DWG.SDR SWAA2016082255050Girt Bar · looseL1 DOOR EMERGENCY SLIDE GIRT BAR LOOSE. SECURED THE GIRT BAR IAW MT.SDR SWAA2016102409052Skin · crackedRT WING LEADING EDGE NR 8 SLAT NOSE SKIN CRACKED AT STA 451.97. REPAIRED SKIN PER SRM.SDR SWAA2016080854599Actuator · inoperativeFUEL CROSSFEED VALVE INOPERATIVE. R & R FUEL CROSSFEED VALVE ACTUATOR IAW MM.SDR SCNA20160721100Window Frame · crackedWHILE INSPECTING R1 WINDOW FRAME, FOUND THE UPPER OUTBOARD FRAME CRACKED. ACCOMPLISHED REPAIR.SDR SCNA20160721099Window Frame · crackedR1 UPPER OUTBOARD WINDOW FRAME IS CRACKED. ACCOMPLISHED REPAIR.SDR SWAA2016072054090Charger · no testRIGHT OVERWING EMERGENCY EXIT BATTERY PACKS FAILED CAPACITY TEST. R & R THE BATTERY CHARGER PER AMM.SDR SWAA2016071954062Light · inoperativeLEFT OVERWING EXTERIOR LOWER EMERGENCY LIGHT INOPERATIVE. R & R THE LIGHT PER AMM.SDR SWAA2016071954050Light · inoperativeR2 DOOR EXTERIOR LOWER EMERGENCY LIGHT INOPERATIVE. R & R LIGHT IAW AMM.SDR SWAA2016072054089Battery Pack · inoperativeLEFT OVERWING EXIT LIGHT INOPERATIVE. R & R THE BATTERY PACK IAW AMM.SDR SWAA2016072054081Battery Pack · inoperativeCENTER OVERWING EXIT LIGHT INOPERATIVE. R & R THE BATTERY PACK IAW AMM.SDR SWAA2016071853905Wire · disconnectedLT STOW BIN EMERGENCY LIGHT INOPERATIVE AT ROW 1. CONNECTED WIRE IAW WDM.SDR SWAA2016071353767Control Valve · no testRIGHT ELEVATOR TAB CONTROL VALVE FAILED TEST. R & R THE CONTROL VALVE IAW AMM.SDR SWAA2016070753584Girt Bar · crackedL2 DOOR EMERGENCY SLIDE GIRT BAR STOP CRACKED. R & R THE GIRT BAR ASSEMBLY IAW AMM.SDR SWAA2016062953346Light · inoperativeLT AFT FUSELAGE EMERGENCY LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA2016062753305Lens · looseL2 DOOR EXTERIOR EMERGENCY EXIT LIGHT LENS LOOSE. R & R LENS IAW SIP.SDR SWAA2016062453186Slide · low pressureR1 DOOR EMERGENCY EVAC SLIDE PRESSURE LOW. R & R SLIDE IAW MAINTENANCE.SDR SWAA2016062353178Power Supply · inoperativeLEFT OVERHEAD BIN BULLNOSE EMERGENCY LIGHTS INOPERATIVE. R & R POWER SUPPLY IAW AMM.SDR SWAA2016062753304Spacer · brokenR2 DOOR EMERGENCY EVAC SLIDE GIRT BAR FORWARD NYLON SPACER BROKEN. R & R GIRT BAR ASSY IAW AMM.SDR SWAA2016061552905Light · inoperativeRIGHT LOWER FORWARD OVERWING EMERGENCY EXIT LIGHT PARTIALLY INOPERATIVE. RELAMPED LIGHT IAW AMM.SDR SWAA2016061552904Light · inoperativeLEFT FORWARD LOWER OVERWING EMERGENCY EXIT LIGHT PARTIALLY INOPERATIVE. RELAMPED LIGHT IAW AMM.SDR SWAA2016061552903Light · inoperativeR2 DOOR INTERIOR EMERGENCY EXIT AREA LIGHT BELOW EXIT SIGN PARTIALLY INOPERATIVE.
RELAMPED LIGHT IAW AMM.SDR SWAA2016061452857Light · disconnectedCOCKPIT EMERGENCY EXIT SWITCH DOME LIGHT INOPERATIVE. RECONNECTED LAMP IAW AMM.SDR SWAA2016061552909Lens · dirtyLEFT EXTERIOR EMERGENCY EXIT LIGHT LENSES DIRTY. CLEANED LIGHT IAW AMM.SDR SWAA2016061552897Lens · dirtyRIGHT EXTERIOR EMERGENCY EXIT LIGHT LENSES DIRTY. CLEANED LIGHT IAW AMM.SDR SWAA2016061552908Light · inoperativeR1 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOPERATIVE. RELAMPED LIGHT IAW AMM.SDR SWAA2016061552907Battery Pack · dischargedLEFT BIN EMERGENCY LIGHT INOPERATIVE BETWEEN ROW 7 TO ROW 23. R & R BATTERY PACK IAW AMM.SDR SWAA2016061552906Battery Pack · dischargedAFT LOWER EMERGENCY LIGHT INOPERATIVE. R & R BATTERY PACK IAW AMM.SDR SWAA2016061552896Light · inoperativeRIGHT OVERWING EXTERIOR EMERGENCY EXIT LIGHT INOPERATIVE. RELAMPED LIGHT IAW AMM.SDR SWAA2016061552895Light · inoperativeL2 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOPERATIVE. RELAMPED LIGHT IAW AMM.SDR SWAA2016061552894Light · inoperativeR2 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOPERATIVE. RELAMPED LIGHT IAW AMM.SDR SWAA2016061552893Battery Pack · dischargedRIGHT BIN EMERGENCY LIGHT INOPERATIVE AT ROW 8. R & R BATTERY PACK IAW AMM.SDR SWAA2016061552902Light · inoperativeLEFT EMERGENCY EXIT AREA LIGHT INOPERATIVE AT ROW 14. R & R LIGHT IAW AMM.SDR SWAA2016061452858Cap · missingL2 DOOR ESCAPE SLIDE CONTAINER FORWARD END CAP MISSING. INSTALLED END CAP IAW SRM.SDR SWAA2016061452853Lens · dirtyEXTERIOR EMERGENCY EXIT LIGHT LENS DIRTY. CLEANED LENS IAW AMM.SDR SWAA2016061452854Light · inoperativeLEFT BULLNOSE BIN EMERGENCY EXIT LIGHT INOPERATIVE AT ROW 11. R & R LIGHT IAW AMM.SDR SWAA2016062853318Intercostal · corrodedAFT CARGO BAY INTERCOSTAL CORRODED BETWEEN BS 747 TO BS 767, RBL 21. R & R INTERCOSTAL IAW DWG & SRM.SDR SWAA2016062453188Rib · crackedLEFT HORIZONTAL STABILIZER RIB STA 92.70, CRACKED VERTICAL STIFFENER 3RD FROM FRONT SPAR, AT LOWER END. REPAIRED RIB IAW SRM.SDR SWAA2016071853904Structure · crackedFUSELAGE SKIN LOWER BULKHEAD CHORD CRACKED AT BS 540, STR 22R. REPAIRED CHORD IAW ER AND EA.SDR SWAA2016071353766Skin · crackedFUSELAGE SKIN CRACKED AT BS 540, STRINGER 22L. REPAIRED THE SKIN IAW ER AND EA.SDR SWAA2016070553466Plate · crackedRIGHT WING LOWER TRAILING EDGE WAFFLE PLATE CRACKED JUST INBOARD OF THE NR 2 PYLON AFT TIP. R & R WIGGLE PLATE IAW SRM.SDR SWAA2016070553465Gusset · crackedLEFT WING UPPER TRAILING EDGE PANEL SUPPORT GUSSET CRACKED ABOVE THE NR 1 PYLON AFT TIP AT TRANSVERSE WEB ATTACH POINT. R & R THE GUSSET IAW SRM.SDR SWAA2016062853317Intercostal · corrodedAFT CARGO BAY INTERCOSTAL CORRODED BETWEEN BS 727A TO BS 727B, STR 27R. R & R INTERCOSTAL IAW SRM.
Back to Boeing 737-7Q8