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 SWAA2019091036718Floor Panel · damagedFORWARD FLOOR PANEL 222AF AFT EDGE AND AFT OUTBOARD CORNER DAMAGED, BETWEEN BS 270 TO BS 420. REPAIRED FLOOR PANEL 222AF IAW SRM.SDR SWAA2022031518684Cover · crackedR/H AILERON TAB #5 I/B HINGE COVER CRACKED / RECEIVED NEW R/H AILERON TAB #5 I/B HINGE COVER. INSTALLATION OF HINGE COVER WILL BE ACCOMPLISHED ON CUSTOMER CARD # T978752 IAW AMM 27-11-21-400-801 STEP 3.E.(4)(D) 56790U 13SEP19SDR SWAA2022031518685Cover · crackedL/H AILERON TAB #5 I/B AND O/B HINGE COVERS CRACKED / RECIEVED NEW L/H AILERON TAB #5 I/B AND O/B HINGE COVERS. INSTALLATION OF HINGE COVERS WILL BE ACCOMPLISHED ON CUSTOMER CARD # T978751 IAW AMM 27-11-21-400-801 STEP 3.E.(4)(D) 56790U 13SEP19SDR SWAA2022031518686Cover · crackedL/H AILERON TAB # 1 I/B HINGE COVER CRACKED / RECIEVED L/H AILERON TAB REPLACEMENT #1 I/B HINGE COVER INSTALLATION OF HINGE COVER WILL BE ACCOMPLISHED ON CUSTOMER CARD # T978751 IAW AMM 27-11-21-400-801 STEP 3E(4)(D) 56790U 13SEP19SDR SWAA2019090336460Eec · faultyAIR TURNBACK/DECLARED EMERGENCY, PASSING 10,000' WITH CLIMB THRUST AT 95% N1,THE #1 ENGINE STARTED SURGING BETWEEN -5 TO-10% N1.SHORTLY THEREAFTER #1 N1 ROLLED BACK TO NEAR IDLE THRUST. ENGINE INDICATIONS APPEARED NORMAL. ENGINE BLEED AIR WAS ON AND AC PACKS SDR SWAA2019090336459Transmitter · faultyDECLARED EMERGENCY, SELECTED FLAPS 15 FLAPS WERE SPLIT AT 2 & 1 1/2. FLAPS INDICATED. FLAPS MATCHED AT 2 RAN QRH FLAP TRAILING EDGE DISAGREE CHECKLIST AND PERFORMED ALTERNATE FLAP EXTENSION. R&R LEFT FLAP POSITION TRANSMITTER PER MM.SDR SWAA2022031818675Rib · crackedRIGHT HORIZONTAL REMOVABLE L/E PANEL 341B RIB #5 IS CRACKED / REMOVED #5 RIB ON RIGHT HORIZ REMOVABLE L/E PANEL 341B IAW SRM 51-40-02-0G-0 PARA 4 & FIG 8. 55920R 18SEP19 INSTALLED SERVICEABLE RIB IAW SRM 51-40-02-0G-0 PARA 4. & DWG #186A1001SDR SWAA2022031818676Rib · crackedRIGHT HORIZONTAL REMOVABLE L/E PANEL 341B RIB #9 IS CRACKED / REMOVED #9 RIB ON RIGHT HORIZ REMOVABLE L/E PANEL 341B IAW SRM 51-40-02-0G-0 PARA 4. FIG 8. 55920R 18SEP19 INSTALLED SERVICABLE RIB IAW SRM 51-40-02-0G-0 PARA 4 & DWG #186A1001SDR SWAA2022031818660Beam · corroded***CORROSION*** IN MULTIPLE AREAS OF AFT CABIN FLOOR BEAM STA 987 RBL 28-45 WL 208 / REPAIRED THE FLOOR BEAM AT STA 987 RBL 28-45 WL 208. (986.5) IAW EA 1-A53-8241 R3 (T978916)SDR SWAA2019092437075Intercostal · crackedFORWARD PASSENGER CABIN INTERCOSTAL CRACKED AT BS 344+10, BL 0. R&R INTERCOSTAL IAW SRM AND DWG.SDR SWAA2019091336877Intercostal · crackedFORWARD PASSENGER CABIN INTERCOSTAL CRACKED BETWEEN BS 312 TO BS 328, RBL 31. REPAIRED INTERCOSTAL IAW SRM AND DWG.SDR SWAA2019091336876Intercostal · crackedFORWARD PASSENGER CABIN INTERCOSTAL CRACKED BETWEEN BS 294 TO BS 312, RBL 16. R&R INTERCOSTAL IAW SRM & DWG.SDR SWAA2019091336872Intercostal · crackedFORWARD PASSENGER CABIN INTERCOSTAL CRACKED AT BS 312+10, LBL 44. R&R INTERCOSTAL IAW SRM AND DWG.SDR SWAA2019091036717Web · damagedCLOSEOUT WEB DAMAGED BETWEEN BS 986 TO BS 1016, BETWEEN RBL 36 TO RBL 42. R&R WEB IAW SRM AND DWG.SDR SWAA2019091036716Intercostal · damagedTOP SURFACE OF INTERCOSTAL DAMAGED BETWEEN BS 986 TO BS 1016, RBL 7. REPAIRED INTERCOSTAL PER SRM AND DWG.SDR SWAA2019091036715Intercostal · crackedFORWARD PASSENGER CABIN INTERCOSTAL CRACKED AT BS 277+7, BL 0. REPAIRED INTERCOSTAL IAW SRM AND DWG.SDR SWAA2019091036714Intercostal · crackedFORWARD PASSENGER CABIN INTERCOSTAL CRACKED BETWEEN BS 328 TO BS 344, LBL 44. REPAIRED INTERCOSTAL PER SRM & DWG.SDR SWAA2019091036713Pressure Deck · crackedHORIZONTAL PRESSURE DECK CRACKED AT BS 665, RBL 41. REPAIRED HORIZONTAL PRESSURE DECK PER SRM.SDR SWAA2022031618626Tie Down · corroded***CORROSION*** ON TRACK TIE DOWN AT AFT CARGO BAY BS787 RBL14 WL157. / AFT CARGO BAY; CARGO TRACK RBL14 WILL BE REPLACED ON DEFECT NUMBER T978836. NO FURTHER ACTION REQUIREDSDR SWAA2022031618627Tie Down · corroded***CORROSION*** ON TRACK TIE DOWN AT AFT CARGO BAY BS727D RBL14 WL155. / CARGO TRACK RBL14 (AFT CARGO) WILL BE REPLACED ON DEFECT NUMBER T978836. NO FURTHER ACTION REQUIREDSDR SWAA2022031618625Strap · corroded***CORROSION*** ON TENSION STRAP AT AFT CARGO BAY BS767 - BS827 RBL18 WL160. / REMOVED AND REPLACED TENSION STRAP FROM AFT CARGO BAY BS767-BS827 RBL18 WL160 IAW SRM 51-40-02-0G-0 AND SRM 51-40-05 AND DWG 146A8120; ID: 0027. 59826U 09/16/19.SDR SWAA2022031618623Frame · corroded***CORROSION*** ON FRAME AT AFT CARGO BAY BS947 RBL11 WL177. MARKED / REMOVED CORROSION ON FRAME AT AFT CARGO BAY BS947 RBL11 WL177 AND REPAIRED PER ATS ER #19-04764 REV IR AND SWA EA #1-753-35714 REV IRSDR SWAA2022031618624Frame · corroded***CORROSION*** ON FRAME AT AFT CARGO BAY BS947 RBL 11 WL177. MARKED / FRAME WILL BE REPLACED ON DEFECT # T928824 56693U 05SEP19SDR SWAA2019100837655Gusset · crackedFORWARD CARGO BAY AFT BULKHEAD SUPPORT GUSSET CRACKED AT BS. 500D, STR. 19L. / R&R GUSSET IAW DWG.SDR SWAA2019100737582Angle · crackedLOWER COMPOSITE BULKHEAD UPPER ATTACH ANGLE CRACKED AT BS. 663, RBL 10. REPAIRED ANGLE IAW SRM.SDR SWAA2019100137409Gusset · crackedFORWARD CARGO BAY AFT BULKHEAD SUPPORT GUSSET CRACKED AT BS. 500D, STR. 19R. / R&R SUPPORT GUSSET IAW SRM AND DWG.SDR SWAA2019100137408Shield · corrodedFORWARD CARGO BAY AFT SHIELD CORRODED AT BS 510, RBL 23. R&R SHIELD IAW SRM AND DWG.SDR SWAA2019100137407Support · corrodedFORWARD CARGO BAY FLOOR TO SIDEWALL SUPPORT CORRODED BETWEEN BS. 500A TO BS. 500, LBL 23. R&R SUPPORT IAW SRM & DWG.SDR SWAA2019100137361Support · crackedAFT CARGO BAY FORWARD BULKHEAD PANEL SUPPORT CRACKED AROUND THE FASTENER AT BS. 727, RBL 3. / R&R SUPPORT IAW SRM & DWG.SDR SWAA2019100137360Support · corrodedAFT CARGO BAY FLOOR TO SIDEWALL SUPPORT CORRODED BETWEEN BS. 727 TO BS. 767, RBL 21. / R&R SUPPORT IAW SRM AND DWG.SDR SWAA2019100137359Support · corrodedAFT CARGO BAY FLOOR TO SIDEWALL SUPPORT CORRODED BETWEEN BS. 847 TO BS. 727B, LBL 21. R&R SUPPORT IAW SRM AND DWG.SDR SWAA2019100137358Splice · corrodedAFT CARGO BAY FLOOR SUPPORT SPLICE CORRODED AT BS. 887, BETWEEN LBL 8 TO RBL 8. R&R FLOOR SUPPORT SPLICE IAW SRM AND DWG.SDR SWAA2019092437108Shield · corrodedFORWARD SHIELD AT AFT CARGO BAY CORRODED BETWEEN BS 797 TO BS 767, RBL 22. R&R SHIELD IAW SRM AND DWG.SDR SWAA2019092437107Tie Down · corrodedAFT CARGO BAY TRACK TIE DOWN CORRODED BETWEEN BS 727 TO BS 867, LBL 17. R&R TIE DOWN IAW SRM AND DWG.SDR SWAA2019092437105Shield · corrodedAFT CARGO BAY AFT SHIELD CORRODED BETWEEN BS 847 TO BS 867, RBL 21. R&R SHIELD PER SRM AND DWG.SDR SWAA2019100337544Rivet · shearedR1 DOOR ESCAPE SLIDE AFT GIRT BAR HANGER HAD A SHEARED RIVET. R & R THE RIVETS PER SRM.SDR SWAA2019100337543Skin · crackedRIGHT WING NR 6 SLAT NOSE SKIN CRACKED AT ONE FASTENER AT ACTUATOR ATTACH RIB. R & R THE NR 6 SLAT ASSEMBLY IAW AMM.SDR SWAA2019081435910Lamp · inoperativeFORWARD SERVICE DOOR EXTERNAL EMERGENCY LIGHT INOP. RELAMPED LIGHT IAW AMM.SDR SWAA2019080765690Screw · missingL1 DOOR ESCAPE SLIDE LOOSE MISSING BOLT. INSTALLED SCREW IAW AMM.SDR SWAA2019072935397Fuse · blownRT OVERWING EXIT IDENTIFICATION SIGN DID NOT ILLUMINATE WHEN TESTED. R&R FUSE PER AMM.SDR SWAA2019072935391Cover · missingRT OVERWING EXIT IDENTIFICATION SIGN COVER MISSING. R&R LIGHT COVER PER AMM.SDR SWAA2019072535273Battery Pack · dischargedAFT LT EXTERIOR EMERGENCY LIGHT INOP. R&R BATTERY PACK PER AMM.SDR SWAA2019072435247Battery Pack · failedEMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY TEST AT M01670. R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2022031420467Floor Panel · crackedRAMP REPORTED TO CAPTAIN; LARGE TEAR IN AFT CARGO FLOOR PANEL 140CF / R & R AFT CARGO FLOOR PANEL IAW M/M 25-52-10 (140CF)SDR SWAA2019071834968Glowstrip · looseLT AISLE PHOTO ILLUMINATION STRIP AFT OF ROW 24 LOOSE AND CRACKED. R&R STRIP IAW SIP.SDR SWAA2019071634880Slide · out of positionR1 DOOR SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MT.SDR SWAA2019070534565Battery Pack · failedEMERGENCY LIGHTS OPERATIONAL TEST FAILED. R&R BATTERY PACK PER AMM.SDR SCNA20190627107Closeout Panel · crackedCLOSE OUT PNL ON AFT SIDE OF LT WHEEL WELL CRACKED. REPAIRED CLOSE OUT PNL ON AFT SIDE OF LT WHEEL WELL.SDR SCNA20190627106Floor Panel · damagedFLOOR PANEL 222DF HAS 2 CORNERS DAMAGED. REPAIRED DAMAGED FLOOR PANEL 222DF (2 CORNERS).SDR SCNA20190627105Floor Panel · damagedFLOOR PANEL 232AF 4 CORNERS DAMAGED. REPAIRED DAMAGED FLOOR PANEL 232AF (4 CORNERS).
Back to Boeing 737-7Q8