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 SWAA2017050413573Collar · damagedL1 DOOR SLIDE FORWARD GIRT BAR COLLAR ROLL PIN DAMAGED. R&R COLLAR PER MT AND AMM.SDR SWAA2017051813830Pressure Panel · crackedWING CENTER SECTION REAR SPAR VERTICAL PRESSURE WEB CRACKED AT BS 663, RBL 35. REPAIRED WEB PER SRM & EA.SDR SWAA2017041813194Lamp · inoperativeRIGHT EXTERNAL EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM.SDR SWAA2017051713779Intercostal · crackedFORWARD CARGO EQUIPMENT BAY INTERCOSTAL CRACKED BETWEEN BS 500D TO BS 520, RBL 7. R&R INTERCOSTAL IAW SRM AND DWG.SDR SWAA2017051713778Intercostal · crackedFORWARD CARGO EQUIPMENT BAY INTERCOSTAL CRACKED BETWEEN BS 500D TO BS 520, RBL 30. R&R INTERCOSTAL IAW SRM AND DWG.SDR SWAA2017041813158Cover · missingRIGHT OVERWING EMERGENCY EXIT SMALL SIGN COVER MISSING. REINSTALLED THE COVER IAW AMM.SDR SWAA2017041113075Light · inoperativeL2 DOOR EXTERNAL EMERGENCY EXIT LIGHT INOP. RELAMPED PER MM.SDR SWAA2017040713025Slide · dislodgedL2 DOOR SLIDE INADVERTENTLY FELL OUT OF IT`S CONTAINER, DID NOT DEPLOY, STILL OPERATIONAL. REINSTALLED THE SLIDE IAW MT.SDR SWAA2017040512937Lamp · inoperativeLEFT EMERGENCY LIGHT INOPERATIVE AT ROW 9. REPLACED THE LAMPS IAW WDM & AMM.SDR SWAA2017040512931Sign · wrong partR1 DOOR EMERGENCY EXIT SIGN MISSING RED ARROW. R & R THE SIGN IAW AMM.SDR SWAA2017040512930Sign · wrong partL1 DOOR EMERGENCY EXIT SIGN MISSING RED ARROW. R & R THE SIGN IAW AMM.SDR SWAA2017040512920Lens · dirtyLEFT EMERGENCY LIGHT LENS DIRTY. R & R THE LENS IAW AMM.SDR SWAA2017040412919Cover · discoloredRIGHT EMERGENCY LIGHT COVER DISCOLORED. R & R THE COVER IAW AMM.SDR SWAA2017040412918Sign · wrong partR2 DOOR LOWER EXIT SIGN MISSING DIRECTIONAL ARROWS. R & R THE SIGN IAW AMM.SDR SWAA2017040412947Sign · wrong partL2 DOOR LOWER EXIT SIGN MISSING DIRECTIONAL ARROWS. R & R THE SIGN IAW AMM.SDR SWAA2017040512955Battery Pack · no testEMERGENCY LIGHT AT M1669 FAILED CAPACITY CHECK. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017040512928Battery Pack · no testEMERGENCY LIGHT AT M1675 FAILED CAPACITY CHECK. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017040512927Lens · dirtyAFT SLIDE LIGHT LENS DIRTY AT BS 1000, LBL 60. R & R THE LENS IAW AMM.SDR SWAA2017040512926Lens · dirtyAFT SLIDE LIGHT LENS DIRTY AT BS 1000, RBL 60. CLEANED THE LENS IAW AMM.SDR SWAA2017040512925Lens · dirtyOVERWING SLIDE LIGHT LENS DIRTY AT BS 757, RBL 51. CLEANED THE LENS IAW AMM.SDR SWAA2017040512924Lens · dirtyOVERWING SLIDE LIGHT LENS DIRTY AT BS 757, LBL 51. CLEANED THE LENS IAW AMM.SDR SWAA2017040512923Lens · dirtyR1 DOOR SLIDE LIGHT LENS DIRTY AT BS 365, LBL 72. CLEANED THE LENS IAW AMM.SDR SWAA2017040512922Lens · dirtyR1 DOOR SLIDE LIGHT LENS DIRTY AT BS 348, RBL 68. CLEANED THE LENS IAW AMM.SDR SWAA2017051813834Frame · crackedFRAME CRACKED AT BS 907, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2017040612993Frame · crackedFRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2017040612981Frame · crackedFRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2017040612980Frame · crackedFRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2017040612979Frame · crackedFRAME CRACKED AT BS 360, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2017040612978Frame · crackedFRAME CRACKED AT BS 520, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2017040612977Frame · crackedFRAME CRACKED AT BS 500C, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2017040612976Frame · crackedFRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2017032912842Fan · failedSMOKE & FUMES REPORTED MID CABIN. DISPATCHED WITH GASPER FAN OFF. R & R THE RECIRCULATION FAN IAW AMM.SDR SWAA2017051813833Skin · dentedSKIN DENTED AT BS 200, 3" STR 17L. REPAIRED SKIN IAW ER AND EA.SDR SWAA2017032212727Bracket · gougedL2 DOOR EMERGENCY EVAC SLIDE GIRT BAR BRACKET ASSEMBLY AFT FITTINGS GOUGED. R&R BRACKET ASSEMBLY IAW AMM.SDR SWAA2017032212725Bracket · gougedL2 DOOR EMERGENCY EVAC SLIDE GIRT BAR BRACKET ASSEMBLY FORWARD FITTINGS GOUGED. R&R BRACKET ASSEMBLY IAW AMM.SDR SWAA2017030612350Slide · looseR2 DOOR EMERGENCY EVAC SLIDE BUSTLE LOOSE. SECURED SLIDE PER MT.SDR SWAA2017030712379Guard · brokenEMERGENCY EXIT LIGHT SWITCH GUARD BROKEN. R & R THE GUARD IAW SOPM.SDR SWAA2017032112633Intercostal · crackedFORWARD CARGO BAY INTERCOSTAL CRACKED BETWEEN BS 500 TO 500A, LBL 25 R & R THE INTERCOSTAL IAW SRM & DWG.SDR SWAA2017032112604Rib · crackedLEFT HORIZONTAL STABILIZER RIB CRACKED AT STA. 120.30, 3RD VERTICAL STIFFENER FROM THE FRONT. REPAIRED THE RIB IAW SRM.SDR SWAA2017030112225Sign · looseRIGHT OVERWING EXIT SIGN LOOSE. R & R THE SIGN IAW MM.SDR SWAA2017022812155Bushing · looseR1 DOOR SLIDE GIRT BAR BUSHING LOOSE. SECURED THE BUSHING IAW SIP.SDR SWAA2017030612334Baffle · crackedBAFFLE CRACKED BETWEEN BS 440 TO BS 460, LBL 25. R&R BAFFLE IAW DWG & SRM.SDR SWAA2017030612333Baffle · crackedBAFFLE CRACKED BETWEEN BS 400 TO BS 420, LBL 25. R&R BAFFLE IAW DWG & SRM.SDR SWAA2017032112683Attach Fitting · crackedLT WING INBOARD UPPER TRAILING EDGE SUPPORT BEAM FORWARD ATTACH CLIP CRACKED AT RSS 80. R&R CLIP IAW SRM.SDR SWAA2017030612332Cap · missingR2 DOOR EMERGENCY EVAC SLIDE TRIM END CAP MISSING. INSTALLED END CAP IAW SRM.SDR SWAA2017030612345Floor Support · crackedLONGITUDINAL FLOORBEAM FLANGE CRACKED AT BS 727B, RBL 45.5. REPAIRED FLANGE PER SRM.SDR SWAA2017030612344Floor Support · crackedLONGITUDINAL FLOORBEAM FLANGE CRACKED AT BS 727B, RBL 24.75. REPAIRED FLANGE PER SRM.SDR SWAA2017030812409Shield · corrodedFLOOR TO SIDEWALL SHIELD CORRODED BETWEEN BS 420 TO 440, RBL 25. R & R THE SHIELD IAW SRM & DWG.SDR SWAA2017032112603Support Angle · corrodedAFT CARGO BAY BULKHEAD SUPPORT ANGLE CORRODED AT BS 947, BETWEEN LBL 15 RBL 25. R&R ANGLE IAW SRM.SDR SWAA2017032112601Support · corrodedAFT CARGO BAY FLOOR TO SIDEWALL SUPPORT CORRODED BETWEEN BS 867 TO 887, RBL 25. R&R SUPPORT IAW SRM.
Back to Boeing 737-7Q8