Boeing 737-4Q8
Service difficulty reports · 6,250
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 = '7374Q8' 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 = '7374Q8' 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 ASAA0340076Strap · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON TOP OF FLOOR SUPPORT STRAP AT BS 772 LBL 21 AND RBL 21. REPAIRED IAW SRM. (M)SDR ASAA0340075Frame · gougedDURING C-CHECK, FOUND GOUGE ON FRAME AT BS 727D RBL 14 AND W165. REPAIRED IAW SRM. (M)SDR ASAA0340074Floor Support · corrodedDURING C-CHECK, FOUND CORROSION ON FLOOR SUPPORT. REPAIRED IAW SRM. (M)SDR ASAA0340073Anchor · crackedPAE - DURING C-CHECK, FOUND AFT PIT FORWARD NET LEFT LOWER ANCHOR CRACKED. REPAIRED IAW SRM. (M)SDR ASAA0340072Shear Tie · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON SHEAR TIE AT BS 727G BETWEEN STRINGER 25R AND 26R. REPAIRED IAW SRM. (M)SDR ASAA0340071Intercostal · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON INTERCOSTAL AT BS 727A 727B LBL 2 WL 159. REPAIRED IAW SRM. (M)SDR ASAA0340069Shear Tie · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON SHEAR TIE AT BS 727F BETWEEN STRINGER 25R AND 26R. REPAIRED IAW SRM. (M)SDR ASAA0340068Frame · dentedPAE - DURING C-CHECK, FOUND DENTS ON RADIUS OF FRAME AT BS 847 RBL 21-22 WL 156. REPAIRED IAW SRM. (M)SDR ASAA0240022Angle · crackedPAE DURING C-CHECK, FOUND LEFT AFT RAM AIR INLET PLENUM OUTBOARD ATTACH SKATE ANGLE IS CRACKED. REPAIRED IAW SRM. (M)SDR ASAA0240023Bracket · crackedPAE - DURING C-CHECK, FOUND CRACKED BRACKET RIGHT AILERON INBOARD BALANCE BAY OUTBOARD RIB FITTING AND WEB. REPAIRED IAW SRM. (M)SDR ASAA0340004Wire · brokenSEA - DURING LINE CHECK, FOUND THE EMERGENCY TRACK LIGHTS INOPERATIVE AT ROW 19. REPAIRED BROKEN WIRE. TRACK LIGHTS THEN OPERATED NORMALLY. (M)SDR ASAA0340003Snubber · brokenSIT - DURING PREFLIGHT CHECK, THE L1 DOOR SNUBBER WAS FOUND BROKEN. SNUBBER WAS REPLACED. DOOR THEN OPERATED NORMALLY. (M)SDR ASAA0140001ALight · malfunctionedPDX - DURING LINE CHECK, FOUND EMERGENCY TRACK LIGHTS INOPERATIVE AT ROWS 13-17, DISCONNECTED WIRES. RECONNECTED WIRES, OPS CHECKED NORMAL. (M)SDR ASAA0340002Wire · disconnectedPDX - DURING LINE CHECK, FOUND EMERGENCY TRACK LIGHTS INOPERATIVE AT ROWS 17, 18, 19, DISCONNECTED WIRES. RECONNECTED WIRES, OPS CHECKED NORMAL. (M)SDR ASAA0240249Wire · brokenDURING LINE CHECK, FOUND EMERGENCY FLOOR TRACK LIGHTING INOPERATIVE FROM FORWARD GALLEY TO ROW 2. REPAIRED BROKEN WIRES, REPLACED LIGHT SECTION, OPS CHECKED NORMAL RELEASED FOR SERVICE (M)SDR ASAA0240243Skin · dentedDURING C-CHECK, FOUND AFT CARGO DOOR SKIN REQUIRES REPLACEMENT. REPAIRED IAW SRM. (M)SDR ASAA0240247Skin · crackedDURING C-CHECK, FOUND RIGHT WING LE CRACKED AT SLAT ACTUATOR CUT OUT. REPAIRED IAW SRM. (M)SDR ASAA0240248Door Frame · damagedDURING C-CHECK, FOUND FORWARD CARGO BAY FORWARD DOOR FRAME CLOSURE WEB DAMAGED. REPAIRED IAW SRM. (M)SDR ASAA0240246Shroud · chafedDURING C-CHECK, FOUND APU SHROUD SKIN CHAFED. REPAIRED IAW EA. (M)SDR ASAA0240245Angle · crackedDURING C-CHECK, NR 1 PYLON CRACKED L ANGLE AT INBOARD END OF FAIRING STIFFENER. REPAIRED IAW SRM. (M)SDR ASAA0240239Cotter Pin · out of positionDURING C-CHECK, FOUND FORWARD ENTRY DOOR SNUBBER COTTER PINS CHAFING FUSELAGE STRUCTURE INBOARD LOWER CAM PLATE. REPAIR IAW SRM. (M)SDR ASAA0240238Retainer · chafedDURING C-CHECK, FOUND APU ACCESS DOOR SEAL RETAINER ANGLE IS CHAFED ON LEFT SIDE. REPAIR IAW SRM. (M)SDR ASAA0240237Skin · dentedDURING C-CHECK, FOUND APU ACCESS DOOR SKIN DENTED AND CHAFED OUT OF LIMITS. REPAIR IAW SRM. (M)SDR ASAA0240236Skin · dentedPAE - DURING C-CHECK, FOUND SKIN IS DENTED AT BS 807 STRINGER 27R TO 27L. REPAIRED IAW SRM. (M)SDR ASAA0240242Angle · crackedPAE - DURING C-CHECK, FOUND RIGHT WING TRAILING EDGE HAS A CRACKED ANGLE AT RSS 545. REPAIRED IAW SRM. (M)SDR ASAA0240241Channel · crackedPAE - DURING C-CHECK, FOUND PYLON PANEL NR 5836 SUPPORT CHANNEL IS CRACKED. REPAIRED IAW SRM. (M)SDR ASAA0240240Stiffener · wornPAE - DURING C-CHECK, FOUND RIGHT MID FLAP PYLON CUTOUT STIFFENER ARE WORN. REPAIRED IAW SRM. (M)SDR ASAA0240235Skin · lightning strikePAE - DURING C-CHECK, FOUND LIGHTNING STRIKES ON FUSELAGE SKIN AT BS 273.5, 360, 447 AND STRINGERS 2L AND 3L AND 76. REPAIRED IAW SRM. (M)SDR ASAA0240234Mount · crackedPAE - DURING C-CHECK, FOUND MOUNT CRACKED AT BS 204, LBL 5 AND WL 175. REPAIRED IAW SRM. (M)SDR ASAA0240233Channel · damagedPAE - DURING C-CHECK, FOUND OVERSIZED HOLES ON CHANNEL AT BS 178 RBL 6-18 AND WL 218. REPAIRED IAW SRM. (M)SDR ASAA0240231Doubler · corrodedDURING C-CHECK, FOUND CORROSION ON FRAME DOUBLER AT BS 794 RBL 22-28 AND WL 154. REPAIRED IAW SRM. (M)SDR ASAA0240230Stringer Clip · crackedDURING SI CHECK, FOUND FORWARD CARGO COMPARTMENT STRINGER CLIP CRACKED AT BS 480 AND STRINGER 22L. REPAIRED IAW SRM. (M)SDR ASAA0240229Frame · damagedDURING C-CHECK, FOUND FRAME AT BS 178 RBL 17 AND WL 182-239 HAS OVERSIZED HOLES. REPAIRED IAW SRM. (M)SDR ASAA0240228Bracket · damagedDURING C-CHECK, FOUND BRACKET AT BS 178 RBL 25 AND WL 195 HAS OVERSIZED HOLES. REPAIRED IAW SRM. (M)SDR ASAA0240227Clip · crackedDURING C-CHECK, FOUND FRAME CLIP AT BS 807, RIGHT BL 20 IS CRACKED IN AFT CARGO BAY. REPAIRED IAW SRM. (M)SDR ASAA0240226Bracket · damagedDURING C-CHECK, FOUND BRACKETS AT BS 178 RIGHT BL 17-23 AND LEFT BL 25 AND WL 25 HAVE OVERSIZED HOLES. REPAIRED IAW SRM. (M)SDR ASAA0240225Stiffener · damagedDURING C-CHECK, FOUND HORIZONTAL STIFFENER AT BS 178 LEFT/RIGHT BL 17-28 AND WL 195 HAS OVERSIZED HOLES. REPAIRED IAW SRM. (M)SDR ASAA0240224Frame · crackedDURING SI CHECKED, FOUND FRAME CRACKED AT BS 400 BETWEEN STRINGER 7R AND 8R AT FORWARD FASTENER HOLES. REPAIRED IAW SRM. (M)SDR ASAA0240223Angle · crackedDURING SI CHECK, FOUND ANGLE CRACKED ON LEFT WING TRAILING EDGE. REPAIRED IAW EA. (M)SDR ASAA0240213Support · corrodedPAE - DURING C-CHECK, FOUND SIDEWALL TO BULKHEAD SUPPORT CORRODED AT BS 727 RBL 24 AND WL 156. REPAIRED IAW SRM. (M)SDR ASAA0240212Strap · corrodedDURING C-CHECK, FOUND CORROSION ON STRAP IN AFT CARGO BAY AT BS 771 WL 156 BL 24. REPAIRED IAW SRM. (M)SDR ASAA0240211Cargo Track · corrodedDURING C-CHECK, FOUND CORROSION ON CARGO FLOOR TRACK IN AFT CARGO BAY FROM BS 787-847 AND RBL 14. REPAIRED IAW SRM. (M)SDR ASAA0240210Bulkhead · damagedDURING C-CHECK, FOUND VERTICAL CHORD AT BS 178 BL 17.1 AND WL 182-239 HAS DAMAGED HOLES. REPAIRED IAW SRM. (M)SDR ASAA0240209Channel · damagedDURING C-CHECK, FOUND HORIZONTAL CHANNELS AT BS 178 REQUIRE REPLACEMENT DUE TO OVERSIZED HOLES. REPAIRED IAW SRM. (M)SDR ASAA0240208Support · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON AFT CARGO BAY FLOOR TO SIDEWALL SUPPORTS. REPAIRED IAW SRM. (M)SDR ASAA0240207Floor Support · corrodedPAE - DURING C-CHECK, FOUND AFT CARGO BAY FLOOR SUPPORT CORRODED AT BS 727A, RBL 3 AND WL 156. REPAIRED IAW SRM. (M)SDR ASAA0240206Support Angle · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON SIDEWALL SUPPORT ANGLE AT STATION 727D AND STRINGER 25R. REPAIRED IAW SRM. (M)SDR ASAA0240205Support · corrodedPAE - DURING C-CHECK, FOUND FLOOR TO SIDEWALL SUPPORTS CORRODED AT BS 727B PLUS 12 THROUGH 947 AND WL 156 TO 160 AND LEFT AND RIGHT BL 24. REPAIRED IAW SRM. (M)SDR ASAA0240204Skin · lightning strikePAE - DURING C-CHECK, FOUND UPPER FUSELAGE EXTERNAL SKIN HAS LIGHTNING STRIKES AT BS 369.5 THROUGH BS 500F PLUS 1.25 AND WL 304 THROUGH WL 147 AND LBL 0.0 THROUGH LBL 26. REPAIRED IAW SRM. (M)SDR ASAA0240189Frame · crackedDURING SI CHECK, FOUND CRACKED FRAME AT BS 400 AT STRINGER 7R AND 8R. REPAIRED IAW SRM. (M)
Back to Boeing 737-4Q8