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 ASAA0140185Stringer Clip · dentedPAE - DURING SI CHECK, FOUND STRINGER CLIP DENTED AT STATION 727R AND STRINGER 24L. REPAIRED IAW SRM. (M)SDR ASAA0140173Frame · gougedPAE - DURING SI C-CHECK, FOUND AFT BAY FORWARD DOOR FRAME IS GOUGED AT BS 794, RBL 27 WL 156 AND RBL 31 AND WL 158. REPAIRED PER EA. (M)SDR ASAA0140169Floorbeam · corrodedPAE - DURING SI CHECK, FOUND FLOORBEAM AT BS 1016, LBL 29 AND WL 208 IS CORRODED. REPAIRED PER EA. (M)SDR ASAA0140170Skin · crackedPAE - DURING SI CHECK, FOUND CRACK ON FORWARD APU DOOR HINGE CUTOUT. REPAIRED PER EA. (M)SDR ASAA0140171Floorbeam · corrodedPAE - DURING SI CHECK, FOUND CORROSION ON FLOORBEAM AT STATION 344, LBL 60 AND WL 206. REPAIRED IAW EA. (M)SDR ASAA0140172Floorbeam · corrodedPAE - DURING SI C-CHECK, FOUND CORROSION ON TOP OF FLOORBEAM AT BS 344, LBL 17 TO 43. REPAIRED PER EA. (M)SDR ASAA0140167Wire · disconnectedSEA - DURING LINE CHECK, FOUND FLOOR TRACK LIGHTS NEAR ROW 1 INOPERATIVE. REATTACHED WIRES ON INOPERATIVE SECTIONS. OPERATIONAL CHECKED GOOD. (M)SDR ASAA0140166Wire · disconnectedANC - DURING LINE CHECK, FOUND FLOOR TRACK LIGHTS INOPERATIVE IN AFT CABIN. CONNECTED WIRES, OPS NORMAL. (M)SDR ASAA0140165Wire · disconnectedSEA - DURING LINE CHECK, FOUND FLOOR TRACK LIGHTS NEAR ROW 1 INOPERATIVE. REATTACHED WIRES ON INOPERATIVE SECTIONS. OPERATIONAL CHECKED GOOD. (M)SDR ASAA0140162Attach Fitting · corrodedPAE - DURING SI CHECK, FOUND CORROSION ON GIRT BAR ATTACHMENT AT BS 312, LBL 53, WL 209. REPLACED PER SRM. (M)SDR ASAA0140163Sill · corrodedPAE - DURING SI CHECK, FOUND CORROSION ON MOP SILL AT BS 307-344, LBL 55 AND WL 208. REPLACED MOP SILL PER SRM. (M)SDR ASAA0140164Seat Track · gougedPAE - DURING SI CHECK, FOUND SEAT TRACK GOUGED AT BS 538, LBL 45.5 AND WL 208. REPLACED PER SRM. (M)SDR ASAA0140161Fitting · corrodedPAE - DURING SI CHECK, FOUND CORROSION ON GRIT BAR ATTACHMENT AT BS 344, LBL 53 AND WL 209. REPLACED PER SRM. (M)SDR ASAA0140160Floor Support · damagedPAE - DURING SI CHECK, FOUND FLOOR SUPPORT AT BS 951, LBL 16-25 AND WL 208 HAS MECHANICAL DAMAGE. REPLACED FLOOR SUPPORT PER SRM. (M)SDR ASAA01400159Floorbeam · damagedPAE - DURING SI CHECK, FOUND FLOORBEAM AT BS 967 RBL 16 AND WL 208 HAS MECHANICAL DAMAGE. REPAIRED PER SRM. (M)SDR ASAA0140158Stringer · gougedPAE - DURING SI CHECK, FOUND GOUGE ON STRINGER 16 RT ON UPPER SIDE JUST FORWARD OF 500F FRAME. REPAIRED PER SRM. (M)SDR ASAA0140155Stiffener · corrodedPAE - DURING SI CHECK, FOUND CORROSION ON STIFFENER AT BS 335, LBL 10 AND WL 208. REPLACED IAW SRM. (M)SDR ASAA0140157Angle · corrodedPAE - DURING SI CHECK, FOUND GALLEY SUPPORT ANGLE CORRODED AT BS 993, LBL 32-44, WL 208. REPLACED PER SRM. (M)SDR ASAA0140154Light · inoperativeSEA - DURING LINE CHECK, FOUND RED FLOOR TRACK LIGHTS NEAR ROW 1 INOPERATIVE. REMOVED AND REPLACE TRACK LIGHT ASSEMBLY. OPS CHECKED NORMAL. (M)SDR ASAA0140156Angle · corrodedPAE - DURING SI CHECK, FOUND GALLEY SUPPORT ANGLE CORRODED AT BS 986-1016, RBL 32, WL 208. REPLACED IAW SRM. (M)SDR AUS20011282Valve · fod(AUS) FUEL SYSTEM NON-RETURN VALVE JAMMED OPEN BY FOD CAUSING A FUELIMBALANCE BETWEEN NO1 AND NO2 TANKS. INVESTIGATION FOUND APLASTIC BLANK WAS JAMMING THE VALVE OPEN. SUSPECT FOD WAS A BLANKING CAP FROM BOOST PUMP PRESSURE LINE. BOOST PUMP HAD BEEN REPLACED PSDR ASAA0140152Stringer · gougedPAE - DURING SI CHECK, FOUND STRINGER 16 RIGHT HAS GOUGE ON UPPER SIDE JUST FORWARD OF BS 500 FRAME. REPAIRED PER SRM. (M)SDR ASAA0140151Attach Fitting · corrodedPAE - DURING SI CHECK, FOUND CORROSION ON GALLEY ATTACH FITTINGS AT BS 333, RBL 9 AND WL 209. REPLACED PER SRM. (M)SDR ASAA0140153Wire · damagedPDX - DURING LINE CHECK, FOUND FLOOR TRACK LIGHTING AT ROW 16 INOPERATIVE. RESTORED WIRING TO ORIGINAL CONDITION, OPS CHECKED GOOD. (M)SDR ASAA0140150Frame · crackedPAE - DURING SI CHECK, FOUND CRACK IN FRAME AT BS 1006 WL 208 AND LBL 41. REPAIRED IAW SRM. (M)SDR ASAA0140148Sill · corrodedPAE - DURING SI CHECK, FOUND R-2 MOPSILL AT BS 951-992, RBL 55 AND WL 208 CORRODED. REPLACED PER SRM. (M)SDR ASAA0140149Sill · corrodedPAE - DURING SI CHECK, FOUND L2 MOPSILL AT BS 951-992, LBL 55 AND WL 208 CORRODED. REPLACED PER SRM. (M)SDR NUZ2001F00000Tube · out of positionON INSPECTION OF AREA AROUND NR 6 FLAP TRANSMISSION, A FIRE EXTINGUISHING TUBE WAS FOUND CHAFED THROUGH IN SEVERAL PLACES, CAUSED BY INBOARD FORE FLAP OUTBOARD CARRIAGE. IT APPEARS THAT TUBE IS WRONGLY POSITIONED.SDR ASAA0140147Angle · damagedPAE - DURING SI CHECK, FOUND GALLEY SUPPORT Z-ANGLE AT BS 993, RBL 32-44, AND WL 208 HAS MECHANICAL DAMAGE. REPLACED PER SRM. (M)SDR ASAA0140145Angle · corrodedPAE - DURING SI CHECK, FOUND GALLEY SUPPORT ANGLE QT BS 986 TO 1016 AND WL 208 IS CORRODED. REMOVED AND REPLACED ANGLE IAW SRM. (M)SDR ASAA0140146Floorbeam · corrodedPAE - DURING SI CHECK, FOUND CORROSION ON FLOORBEAM AT STATION 360 WL 208 AND RBL 19 AND 26. REPAIRED IAW SRM. (M)SDR ASAA0140142Frame · crackedPAE - DURING SI CHECK, FOUND CRACK AT BS 747 BETWEEN STRINGER 8 AND 9 LEFT. REPAIRED CRACKED FRAME PER SRM. (M)SDR ASAA0140143Strap · damagedPAE - DURING SI CHECK, FOUND FLOOR WEB STRAP AT BS 1020 RBL 18 AND WL 208 HAS MECHANICAL DAMAGE. REPLACES STRAP PER SRM. (M)SDR ASAA0140144Strap · damagedPAE - DURING SI CHECK, FOUND FLOOR WEB STRAP AT BS 1020 RBL 4 AND LBL 4 AND WL 208 HAS MECHANICAL DAMAGE. REPLACED STRAP PER SRM. (M)SDR ASAA0140139Angle · corrodedPAE - DURING SI CHECK, FOUND CORROSION ON BULKHEAD SUPPORT ANGLE AT STATION 500G LBL 24 TO RBL 24 AND WL 156. FABRICATED AND INSTALLED ANGLE IAW SRM. (M)SDR ASAA0140141Floorbeam · corrodedPAE - DURING SI CHECK, FOUND CORROSION TOP OF FLOORBEAM AT BS 312 LBL 1, 6, 15 AND WL 208. REPAIRED IAW SRM. (M)SDR ASAA0140140Sill · corrodedPAE - DURING SI CHECK, FOUND CORROSION ON MOPSILL RBL 55 AT BS 274, 283, 294 AND 346 AND WL 208. REMOVED AND REPLACED MOPSILL IAW SRM. (M)SDR ASAA0140137Wire · disconnectedSEA - DURING LINE CHECK, FOUND EMERGENCY EXIT LIGHT INOPERATIVE AT ROW 6-12. WIRE DISCONNECTED. RECONNECTED WIRE, OPS CHECK GOOD. (M)SDR ASAA0140138Frame · crackedPAE - DURING SI CHECK, FOUND STUB FRAME AT BS 294.5, WL 208, RBL 60 IS CRACKED. REPAIRED IAW SRM. (M)SDR ASAA0140135Wire · damagedSEA - DURING RON CHECK, FOUND EMERGENCY LIGHT INOPERATIVE AT ROW 1-3. REPAIRED WIRE, OPS NORMAL. (M)SDR ASAA0140128Light · inoperativeSEA - DURING LIGHT CHECK, FOUND L2 DOOR EMERGENCY EXIT LIGHT INOPERATIVE. REMOVED AND REPLACED LIGHT, OPS NORMAL. (M)SDR ASAA0140134Door Frame · corrodedPAE - DURING C-CHECK, FOUND AFT CARGO BAY BS 792, RBL 24-28 WL 160 DOOR FRAME PLATE IS CORRODED. REMOVED AND REPLACED PLATE IAW SRM. (M)SDR ASAA0140130Cargo Track · corrodedPAE - DURING C-CHECK, FOUND AFT CARGO BAY RIGHT FLOOR TRACK BS 747 TO 947 RBL 14 WL 150 CORRODED. REMOVED AND REPLACED PER SRM. (M)SDR ASAA0140129Support · corrodedPAE - DURING C-CHECK, FOUND AFT CARGO BAY RIGHT FLOOR TO SIDEWALL SUPPORT PLATE FROM BS 727-762, RBL 20 WL 150 IS CORRODED. REMOVED AND REPLACED SIDE WALL PLATE IAW SRM. (M)SDR ASAA0140133Web · gougedPAE - DURING C-CHECK, FOUND FORWARD ENTRY DOOR WEB GOUGED OUTBOARD OF AFT STOP FITTING. REPAIRED PER EA. (M)SDR ASAA0140132Skin · dentedPAE - DURING C-CHECK, FOUND AFT CARGO DOOR SKIN DENTED. REPLACES SKIN IAW SRM. (M)SDR ASAA0140131Support · corrodedPAE - DURING C-CHECK, FOUND AFT CARGO BAY LEFT FLOOR SIDEWALL SUPPORT PLATE FROM BS 727-947 AND LBL 20, WL 150 CORRODED. REPLACED IAW SRM. (M)SDR ASAA0140127Light · disconnectedSEA - DURING LINE CHECK, FOUND EMERGENCY FLOOR TRACK LIGHTS INOPERATIVE AT ROW 9-10. RECONNECTED FLOOR TRACK LIGHTS, OPS NORMAL. (M)SDR ASAA0140126Web · corrodedPAE - DURING C-CHECK, FOUND SUB THRESHOLD WEB CORRODED OUT OF LIMITS AT BS 794-847, RBL 21, WL 150. REMOVED AND REPLACED PER SRM. (M)SDR ASAA0140125Strap · corrodedPAE - DURING C-CHECK, FOUND SUB THRESHOLD TIE STRAP CORRODED OUT OF LIMITS AT BS 775-847, WL 150. REMOVED AND REPLACED PER SRM. (M)
Back to Boeing 737-4Q8