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 SWAA2016021649070Support Angle · corrodedAFT CARGO BAY ON SIDEWALL SUPPORT ANGLE CORRODED AT BS 787, STRINGER 24L - 25L. R & R ANGLE ASSEMBLY IAW SRM.SDR SWAA2016021649059Crease Beam · corrodedCREASE BEAM INBD CHORD CORRODED, BETWEEN BS 290 - 360, RBL 56. R & R CHORD IAW DWG & SRM.SDR SWAA2016021249023Support Angle · corrodedAFT CARGO BAY ON SIDEWALL SUPPORT ANGLE CORRODED AT BS 727D, STRINGER 25R. R & R ANGLE IAW DWG & SRM.SDR SWAA2016021249022Seat Track · corrodedAFT CARGO BAY ON FLOOR TRACK CORRODED BETWEEN BS 927 - 947, RBL 13.5. R & R FLOOR TRACK IAW SRM.SDR SWAA2016021249021Floor Support · corrodedAFT CARGO BAY ON FLOOR SUPPORT CORRODED AT BS 944, RBL 7.5. R & R FLOOR SUPPORT IAW SRM & DWG.SDR SWAA2016021148994Support Channel · corrodedGIRT BAR SUPPORT CHANNEL CORRODED AT BS 344, LBL 59. R & R FITTING IAW SOPM.SDR SWAA2016021148993Support Angle · corrodedGIRT BAR SUPPORT Z ANGLE CORRODED AT BS 312, LBL 55. R & R FITTING IAW SOPM.SDR SWAA2016021148992Door Sill · corrodedCREASE BEAM INBD CHORD MOP SILL CORRODED, BETWEEN BS 312 - 360, LBL 58. R & R MOP SILL IAW SRM.SDR SWAA2016021148991Shield · corrodedAFT CARGO BAY ON FLOOR TO SIDEWALL SUPPORT PLATE SHIELD CORRODED, BETWEEN BS 847 - 867, RBL 21. R & R SHIELD IAW SRM & DWG.SDR SWAA2016021148989Support · corrodedAFT CARGO BAY ON FLOOR TO SIDEWALL SUPPORT PLATE SHIELD CORRODED, BETWEEN BS 727+4 - BS 767, RBL 21. R & R SUPPORT IAW SRM & DWG.SDR SWAA2016020948832Floorbeam · corrodedFLOORBEAM UPPER FLANGE CORRODED, AT BS 312, LBL 1. REPAIRED FLOORBEAM IAW SRM.SDR SWAA2016020948831Door Sill · corrodedR2 DOOR MOP SILL INNER CHORD CORRODED, BETWEEN BS 967 - 986, WL 208. R & R CHORD IAW SRM & DWG.SDR SWAA2016020948830Floor Support · corrodedAFT CARGO BAY FLOOR SUPPORT CORRODED AT BS 944, RBL 2.5. R & R SUPPORT IAW SRM & DWG.SDR SWAA2016020948829Floor Support · corrodedAFT CARGO BAY ON FLOOR SUPPORT CORRODED AT BS 727A+5, RBL 2.5. R & R SUPPORT IAW SRM.SDR SWAA2016020948828Floor Support · corrodedAFT CARGO BAY ON FLOOR SUPPORT, CORRODED AT BS 727B+3, LBL 2.5. R & R SUPPORT IAW SRM.SDR SWAA2016020948827Floor Support · corrodedAFT CARGO BAY FLOOR SUPPORT, CORRODED AT BS 727D+5.5, LBL 2.5. R & R SUPPORT IAW SRM.SDR SWAA2016020948826Intercostal · corrodedAFT CARGO BAY FLOOR TRACK, INTERCOSTAL WEB CORRODED, BETWEEN BS 727A - 727B, LBL 17. R & R INTERCOSTAL IAW SRM.SDR SWAA2016020948848Support Channel · crackedAFT CARGO BAY BULKHEAD LINER SUPPORT CHANNEL, CRACKED AT BS 727, RBL 4. R & R CHANNEL IAW SRM.SDR SWAA2016020148562Web · corrodedFORWARD CARGO BAY THRESHOLD SUB WEB CORRODED. R & R WEB IAW SRM & DWG.SDR SWAA2016021949242Pressure Deck · crackedPRESSURE DECK WEB CRACKED AT BS 665, RBL 40. REPAIRED WEB IAW ER & EA.SDR SWAA2016020948825Skin · crackedRIGHT WING NR 5 SLAT, LOWER SURFACE NOSE SKIN, CRACKED AT STATION 85.19. REPAIRED SKIN IAW SRM.SDR SWAA2016020948847Support Channel · crackedRIGHT WING UPPER TE PANEL SUPPORT CHANNEL CRACKED, ABOVE NR 2 ENG STRUT. R & R CHANNEL IAW SRM.SDR SWAA2016020948846Support Angle · crackedLEFT WING UPPER TE PANEL SUPPORT ANGLE CRACKED, AT TRANSVERSE WEB ATTACH POINT, ABOVE NR 1 PYLON AFT TIP. R & R ANGLE IAW SRM.SDR SWAA2016020448664Frame · crackedLT LOWER FRAME WEB CRACKED AT BS 727, WL 200. REPAIRED WEB PER EA.SDR SWAA2016020948818Pressure Panel · crackedMAIN WW VERTICAL PRESS WEB CRACKED AT BS 663, RBL 35. REPAIRED WEB IAW SRM.SDR SWAA2015122847452Lens · looseR2 DOOR EXIT LIGHT LENS LOOSE. REPLACED LENS IAW MM.SDR SWAA2015121547165Light · inoperativeRIGHT OVERHEAD BIN EMER LIGHT INOPERATIVE AT ROW 19. RELAMPED LIGHT IAW SIP.SDR SCNA20151209176Window Frame · crackedNR 1 WINDOW POST CRACK. PERFORMED PERMANENT REPAIR TO NR 1 WINDOW POST.SDR SWAA2015113046491Girt Bar · looseL2 DOOR GIRT BAR BRACKET LOOSE. SECURED GIRT BAR IAW SIP.SDR SWAA2015112346239Battery · failedRIGHT EMER LIGHT BATTERY PACK FAILED CAPACITY TEST. R & R BATTERY IAW AMM.SDR SWAA2015112346252Battery · failedLEFT EMER LIGHT BATTERY PACK FAILED CAPACITY TEST. R & R BATTERY IAW AMM.SDR SWAA2015090443508Bulkhead · crackedAFT PRESS BULKHEAD CRACKED AT STATION 1016, STRINGER 23R. REPAIRED BULKHEAD IAW EA.SDR SWAA2015082443071Lens · unsecureAFT GALLEY OVERHEAD EXIT SIGN LIGHT LENS FELL OFF. INSTALLED LENS ASSEMBLY IAW MM.SDR SWAA2015080342483Sensor · faultyON DESCENT BURNING SMELL IN COCKPIT AT 121,000', DISSIPATED BY 17,000'. MORE OF A PLASTIC BURNING SMELL. NO HOTSPOTS NOTED BY HAND IN COCKPIT. NO OVERHEATED WINDOWS. CAPTAIN MAP LIGHT WAS LEFT ON & WAS HOT BUT DID NOT SMELL. DISSIPATED SMELL NEVER RETURNESDR SWAA2015062240976Sign · displacedLEFT EMER EXIT CEILING PANEL SIGN DISPLACED AT ROW 18. REPLACED SIGN IAW EA.SDR SWAA2015061940927Latch · brokenEMERGENCY LIGHT CONNECTOR LATCH BROKEN AT BS 727E+18, LBL 19. REPLACED LATCH IAW WDM.SDR SWAA2015061940926Wire · damagedLEFT AFT BULLNOSE EMER LIGHT INOPERATIVE. REPAIRED WIRE IAW ER & EA.SDR SWAA2015061640740Support · crackedWING TO BODY FAIRING SUPPORT CRACKED AT BS 670, RBL 10. R & R SUPPORT IAW SRM & DWG.SDR SWAA2015060340352Intercostal · corrodedINTERCOSTAL CORRODED AT STATION 847 - 857, RBL 26, WL 155. REPAIRED INTERCOSTAL IAW SRM.SDR SWAA2015052640049Strap · corrodedLEFT EMER EXIT HATCH ESCAPE STRAP HOOK END CORRODED. R & R STRAP IAW AMM.SDR SWAA2015052640048Strap · corrodedRIGHT EMER EXIT HATCH ESCAPE STRAP HOOK END CORRODED. R & R STRAP IAW AMM.SDR SWAA2015052139915Tee Fitting · corrodedFORWARD APU BULKHEAD, RT VERTICAL STIFFENER TO FUSELAGE SKIN CLIP TEE FITTING CORRODED AT BS 1088, RBL 10. R & R TEE FITTING IAW SRM & DWG.SDR SWAA2015061140608Skin · crackedFOUND THE FUSELAGE SKIN CRACKED AT BS 540, STRINGER 22R. REPAIRED THE SKIN IAW EA.SDR SWAA2015050739424Stiffener · crackedRIGHT HORIZONTAL STABILIZER 101.90 RIB, 2ND FROM THE FRONT VERTICAL STIFFENER CRACKED. REPAIRED STIFFENER IAW SRM.SDR SWAA2015050539312Support Angle · crackedLEFT WING FIXED TE UPPER PANEL ABOVE PYLON AFT FAIRING, VERTICAL PANEL SUPPORT ANGLE CRACKED, AT OTBD RIVET HOLES. R & R ANGLE IAW SRM.SDR SWAA2015060540389Skin · corrodedFUSELAGE SKIN CORRODED AT WATER SERVICE PANEL CUT OUT FWD HINGE, APPROX STATION 967 - 986, STRINGER 24R. REPAIRED SKIN IAW EA.SDR SWAA2015060340349Frame · crackedFUSELAGE FRAME CRACKED AT STATION 827, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2015060340348Frame · crackedFUSELAGE FRAME CRACKED AT STATION 867, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2015051839786Frame · crackedFRAME CRACKED AT BS 747, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2015051839785Frame · crackedFRAME CRACKED AT BS 747, STRINGER 8L. REPAIRED FRAME IAW EA.
Back to Boeing 737-7Q8