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 SWAA2017110817649Frame · crackedFRAME CRACKED AT BS 400, STRINGER 8R. REPAIRED THE FRAME IAW EA.SDR SWAA2017110817648Frame · crackedFRAME CRACKED AT BS 827, STRINGER 8L. REPAIRED THE FRAME IAW EA.SDR SWAA2017110117534Frame · crackedFRAME CRACKED AT BS 727A, STR 8L. REPAIRED FRAME PER EA.SDR SWAA2017110117533Frame · crackedFRAME CRACKED AT BS 500C, STR 8L. REPAIRED FRAME PER EA.SDR SWAA2017110117532Support · corrodedAFT CARGO BAY FLOOR TO SIDEWALL SUPPORT CORRODED BETWEEN BS 727+4 TO BS 767, RBL 21. R&R SUPPORT PER SRM & DWG.SDR SWAA2017110117531Support · corrodedAFT CARGO BAY FLOOR TO SIDEWALL SUPPORT CORRODED BETWEEN BS 727+4 TO BS 847, LBL 21. R&R SUPPORT IAW SRM.SDR SWAA2017103017460Frame · crackedFRAME CRACKED AT BS 500C, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2017103017459Frame · crackedFRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2017101117030Battery · dischargedFORWARD FLASHLIGHT INOP. R&R BATTERY IAW AMM.SDR SWAA2022020221107Drain Mast · corroded***CORROSION*** BS 989 BETWEEN STR23L-24L FWD BOLT SIDE DRAIN MAST SKIN PAN HAS CORROSION / REMOVED DAMAGE ON FWD BOLT SIDE OF DRAIN MAST SKIN PAN BS 989 BETWEEN STR'S 23 AND 24 L/H. REPAIRED PER ATS ER 17-04587 REV IR AND SWA EA 1-753-31868 REV IRSDR SWAA2022020221103Intercostal · corroded***CORROSION***BS 1016 BULKHEAD BL0-RBL10 INTERCOSTAL HAS CORROSION. . / REMOVED CORROSION ON BS 1016 BULKHEAD INTERCOSTAL BL0-RBL10 .8' X .7' X .017' FOUND TO BE OUT OF LIMITS PER SRM 53-80-08-1A-1 REMOVED AND REPLACED PER ATS ER 17-04661 REV IR AND SWA EA 1-SDR SWAA2017121918531Intercostal · corrodedBULKHEAD INTERCOSTAL CORRODED AT BS 1016, BETWEEN BL 0 TO LBL 10. R & R THE INTERCOSTAL IAW ER AND EA.SDR SWAA2017121118360Crease Beam · corrodedCREASE BEAM WEB CORRODED BETWEEN BS 1006 TO BS 1016, LBL 50. R&R WEB PER SRM AND DWG.SDR SWAA2017121118359Crease Beam · corrodedCREASE BEAM WEB CORRODED BETWEEN BS 1006 TO BS 1016, RBL 50. R&R WEB PER SRM AND DWG.SDR SWAA2017110817661Intercostal · corrodedINTERCOSTAL WEB CORRODED BETWEEN BS 986 TO BS 992, STR 20L. R&R INTERCOSTAL IAW SRM & DWG.SDR SWAA2017110817660Intercostal · corrodedBULKHEAD INTERCOSTAL CORRODED AT BS 1016, BETWEEN RBL 10 TO RBL 25. R & R THE INTERCOSTAL IAW SRM & DWG.SDR SWAA2017110817659Intercostal · corrodedBULKHEAD INTERCOSTAL CORRODED AT BS 1016, BETWEEN LBL 35 TO LBL 40. R & R THE INTERCOSTAL IAW SRM & DWG.SDR SWAA2017110817658Intercostal · corrodedBULKHEAD INTERCOSTAL CORRODED AT BS 1016, BETWEEN LBL 25 TO LBL 35. R & R THE INTERCOSTAL IAWSRM AND DWG.SDR SWAA2017110817657Intercostal · corrodedBULKHEAD INTERCOSTAL CORRODED AT BS 1016, BETWEEN LBL 10 TO LBL 25. R & R THE INTERCOSTAL IAW SRM & DWG.SDR SWAA2017101117031Battery · failedAFT RT BATTERY FAILED TIME TEST. R&R BATTERY PER AMM.SDR SWAA2017101017006Light · inoperativeRT EMERGENCY ESCAPE HATCH FORWARD LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2022020221097Intercostal · crackedBS 312-328 WL 208 RBL32 INTERCOSTAL IS CRACK. / REMOVED & INSTALLED INTERCOSTAL AT B.S. 312-328 WL208 RBL32 IAW SRM 51-40-05; SRM 51-40-02; DWG 141A5400 SHT 39SDR SWAA2022020221098Intercostal · crackedBS 277 -294 WL208 BL0 INTERCOSTAL IS CRACK. / REMOVED & INSTALLED A NEW INTERCOSTAL AT B.S 277-294 WL 208; BL0 IAW SRM 51-40-05; SRM 51-40-02; DWG 141A5400 SHT 20SDR SWAA2022020221099Intercostal · crackedBS 344-360 WL208 LBL15 INTERCOSTAL IS CRACK. / REMOVED AND REPLACED CRACKED INTERCOSTAL PER SRM 57-40-02-000 SRM 51-40-05-00-0 AND DWG 141A5400 SHEET 12 92771U 10/23/17SDR SWAA2017121118358Intercostal · crackedINTERCOSTAL CRACKED BETWEEN BS 344 TO BS 360, BL0. R&R INTERCOSTAL IAW SRM AND DWG.SDR SWAA2017120418242Floor Support · crackedINTERCOSTAL CRACKED BETWEEN BS. 328 TO BS. 340, LBL 45. / R&R INTERCOSTAL IAW SRM AND DWG.SDR SWAA2017120418205Door Sill · corrodedL1 DOOR MOPSILL CORRODED BETWEEN BS 312 TO BS 340, WL 208. R&R MOPSILL IAW SRM AND DWG.SDR SWAA2017112117934Strap · corrodedCREASE BEAM STRAP CORRODED AT BS 280, RBL 55. R & R THE STRAP IAW SRM AND DWG.SDR SWAA2017111617859Floorbeam · corrodedTOP FLOORBEAM CORRODED AT BS 328, RBL 15. REPAIRED T-CHORD PER SRM.SDR SWAA2022020221093Retainer · crackedLEFT WING T/E PANEL 551 GB AFT SEAL RETAINER IS CRACKED / REMOVED AND REPLACED LEFT WING T/E PANEL 551GB AFT SEAL RETAINER IAW SOPM 20-50-01. 57283U 13OCT17.SDR SWAA2022020221092Service Door · crackedFORWARD SERVICE DOOR HANDLE CASTING ATTACH FITTING IS CRACKED AT FORWARD UPPER ATTACH HOLE INSIDE CENTER LIGHTENING HOLE ON DOOR. / REMOVED & REPLACED FWD SERVICE DOOR PER AMM 52-41-00-000-801; AMM 52-41-00-400-801; AMM 52-41-00-820-801; AMM 52-41-00-700-801; SDR SWAA2017101017012Strip · delaminatedRT ESCAPE PATH STRIP DELAMINATED AT ROW 1. R&R STRIP PER DWG.SDR SWAA2017101017011Light · inoperativeL1 DOOR OVERHEAD EMERGENCY EXIT LIGHT BULB INOP. RELAMPED LIGHT PER AMM.SDR SWAA2022020220718Seal · crackedRT HORIZONTAL STAB FWD UPPER SLIDING SEAL IS CRACKED / REMOVED & REPLACED RH HORIZONTAL STAB FWD UPPER SLIDING SEAL IAW AMM 53-31-31-400-801 & IPC 53-31-31-03SDR SWAA2017121218403Skin · crackedLT WING FAIRING 542BB INNER SKIN CRACKED JUST FORWARD OF OUTBOARD AFT DRAIN HOLE. REPAIRED SKIN IAW ER & EA.SDR SWAA2017121118357Skin · crackedRT WING FAIRING 642BB INNER SKIN CRACKED JUST FORWARD OF OUTBOARD AFT DRAIN HOLE. REPAIRED SKIN PER EA.SDR SWAA2017112117933Skin · crackedLEFT WING FAIRING 544BB INNER SKIN CRACKED JUST FORWARD OF THE AFT FRAME. REPAIRED THE SKIN IAW ER & EA.SDR SWAA2017111517814Skin · crackedFUSELAGE SKIN CRACKED AT BS 540, STRINGER 22R. REPAIRED THE SKIN IAW EA.SDR SWAA2022020121059None · corrodedCORROSION ON AED MOPSILL / BLENDED DAMAGED AREA ON AED MOPSILL 2.5' X 1.5' AREA ORIGINAL THICKNESS 0.080; REMOVED 0.024' MAT. FOUND TO BE OUT OF LIMITS PER SRM 53-70-15-1A-1; REMOVED & REPLACED AED MOPSILL IAW BOEING DRAWING 14A8501 & SRM 51-40-02.SDR SWAA2022020121060Scuff Plate · crackedAFT CARGO BAY FWD SCUFF PLATE IS CRACKED / REPAIRED AFT CARGO BAY FWD SCUFF PLATE IAW SWA EA 1-A53-2073 REV 11SDR SWAA2017112017909Window Frame · crackedLT NR 1 WINDOW FRAME CRACKED AT THE UPPER OUTBOARD CORNER. REPAIR LT NR 1 WINDOW FRAME IAW ACO.SDR SWAA2017110617592Window Frame · crackedR1 WINDOW FRAME CRACKED. REPAIRED THE WINDOW FRAME IAW ACO.SDR SWAA2017110617591Window Frame · crackedR3 WINDOW FRAME CRACKED. REPAIRED THE WINDOW FRAME IAW ACO.SDR SWAA2017110117520Frame · crackedBULKHEAD FRAME WEB CRACKED AT BS 727. REPAIRED WEB PER EA.SDR SWAA2017100316876Battery Pack · dischargedRT EMERGENCY EXIT LIGHT INOP. R&R BATTERY PACK PER AMM.SDR SWAA2017100316875Battery Pack · dischargedLT OVERWING EMERGENCY LIGHT INOP. R&R BATTERY PACK PER AMM.SDR SWAA2017100316874Light · brokenLT OVERWING EMERGENCY EXIT ASSEMBLY ACTUATOR NUTS BROKEN. R&R LIGHT HOUSING ASSEMBLY PER SRM.SDR SWAA2022020121040Floor Panel · pulledFWD FLOOR PANEL 221AF UPPER SKIN HAS MULTIPLE AREAS OF PULLED STRANDS. / DAMAGED FLOOR PANEL 221AF WAS REPLACED WITH A SERVICABLE PART IAW SRM 51-10-0G-0 PAR 9SDR SWAA2022020121045Floor Panel · pulledFWD FLOOR PANEL 221GF UPPER SKIN HAS AREAS OF PULLED STRANDS AND DAMAGE TO AFT CORNERS AND FWD O/B CORNER TANG. / DAMAGED FLOOR PANEL 221GF WAS REPLACED WITH A SERVICABLE PART IAW SRM 51-10-02-0G-0SDR SWAA2022020121042Floor Panel · pulledFWD FLOOR PANEL 221CF UPPER SKIN HAS SMALL AREA OF PULLED STRANDS WITH DAMAGED INSERTS. / REPAIRED AREA OF PULLED STRANDS ON UPPER SKIN AND REPLACED DAMAGED INSERTS ON FWD FLOOR PANEL 221CF IAW SRM 53-00-50-2R-1. 56749U 01NOV17
Back to Boeing 737-7Q8