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 ASAA0540457Tab · puncturedOKC - FOUND RIGHT ELEVATOR TAB IS PUNCTURED. PREPPED DAMAED AREA, APPLIED HOT BOND REPAIR IAW 737-400 SRM 51-70-04 REPAIR 1. (M)SDR ASAA0540453Floorbeam · corrodedOKC - FOUND CORROSION ON FLOORBEAM AT BS 360. REMOVED CORROSION, FABRICATED AND INSTALLED REPAIR PARTS IAW B737-400 SRM 53-00-51 FIG 201. (M)SDR ASAA0540450Shear Tie · corrodedOKC - FOUND BS 847 SHEAR TIE BETWEEN STRINGERS 26 LEFT AND 27 LEFT CORRODED. REMOVED DAMAGED SECTION OF SHEAR TIE, FABRICATED AND INSTALLED REPAIR PIECES IAW B737-400 SRM 53-00-07. (M)SDR ASAA0540449Shear Tie · corrodedOKC - FOUND BS 827 SHEAR TIE BETWEEN 26 LEFT AND 27 LEFT CORRODED OUT OF LIMITS ON ATTACH FLANGE. CORRODED SHEAR TIE REMOVED AND REPLACEMENT SHEAR TIE SPLICED INTO FRAME. (M)SDR ASAA0540448Floorbeam · corrodedOKC - FOUND UPPER CHORD OF FLOORBEAM AT BS 294.5 IS CORRODED. REMOVED CORRODED SECTION OF CHORD. FABRICATED REPLACEMENT CHORD AND INSTALLED IAW B737-200 SRM 53-10-51 FIG 201. (M)SDR ASAA050447Floorbeam · corrodedOKC - FOUND HAT CHANNEL ON FLOORBEAM AT BS 294.5 IS CORRODED. REMOVED CHANNEL, FABRICATED AND INSTALLED REPLACEMENT CHANNEL IAW B737-200 SRM 51-40-02 AND AMM 51-21-21. (M)SDR ASAA0540452Angle · crackedOKC - FOUND ANGLE CRACKED AT BS 289 STRINGER 10 RIGHT. REMOVED CRACKED ANGLE, REPLACED WITH NEW PART IAW 737-400 SRM 51-40-2. (M)SDR ASAA0540451Floor Panel · damagedOKC - FOUND FLOOR WEB AT RBL 45 BS 983 HAS ELONGATED HOLES. REMOVED DAMAGED PART, FABRCIATED AND INSTALLED REPAIR PIECES IAW 737-400 SRM 51-30-01 AND 51-40-2. (M)SDR ASAA0540446Skin · gougedOKC - FOUND RIGHT AILERON GOUGED AT CUTOUT FOR INBOARD MOUNT. PREPPED DAMAGED AREA, APPLIED LAY-UP REPAIR IAW B737-400 SRM 51-70-03 REPAIR 10. (M)SDR ASAA0540445Rib · crackedOKC - FOUND LEFT HORIZONTAL L/E HAS CRACKED RIB AT BS 244.72. REMOVED AND REPLACED RIB ON L/E AT BS 244.72 IAW B737-400 SRM 51-40-02. (M)SDR ASAA0540444Shear Web · corrodedOKC - FOUND SHEAR WEB CORRODED AT BS 989 LBL 35. REMOVED SHEAR WEB, FABRICATED AND INSTALLED REPLACEMENT PARTS IAW B737-400 SRM 53-60-1 AND 51-40-05. (M)SDR ASAA0540443Angle · crackedOKC - FOUND ANGLE CRACKED AT BS 289 STRINGER 12 RT. REMOVED CRACKED ANGLE, REPLACED WITH NEW PART IAW B737-400 SRM 51-40-2. (M)SDR ASAA0540442Wedge · gougedOKC - FOUND RIGHT INBOARD FLAP TRAILING EDGE WEDGE GOUGED IN TWO PLACES. REPLACED RIGHT INBOARD FLAP TRAILING EDGE IAW B737-400 SRM 51-40-5, AND 08. (M)SDR ASAA0540441Plate · crackedOKC - FOUND SPLICE PLATE RIGHT SIDE CRACKED AT BS 601, STRINGER 15 RT. REMOVED CRACKED SPLICE PLATE, FABRICATED AND INSTALLED REPLACEMENT SPLICE PLATED IAW B737-400 SRM 51-30-1 AND 2. (M)SDR ASAA0540438Shear Tie · damagedOKC - SHEAR TIE AT BS 986, RBL 49 HAS ELONGATED FASTENER HOLES. REMOVED DAMAGED SHEAR TIE, FABRICATED AND INSTALLED REPLACEMENT SHEAR TIE IAW B737-400 SRM 51-30-1, AND 51-30-3.SDR ASAA0540439Angle · crackedOKC - FOUND ANGLE CRACKED AT BS 289, STRINGER 11R. REMOVED AND REPLACED CRACKED ANGLE WITH NEW PART IAW B737-400 SRM 51-40-2. (M)SDR ASAA0540433Frame · dentedFWD CARGO BAY, BSTA 440, RBL 22, WL 156, FRAME IS DENTED AT FASTENER. TRIMMED OUT DAMAGE AND INSTALLED REPAIR IAW EA. (K)SDR ASAA0540437Stringer Clip · corrodedOKC - FOUND STRINGER TIE CLIP BS 807 STRINGER RT IS CORRODED. REMOVED CLIP, FABRICATED AND INSTALLED NEW CLIP IAW B737-400 SRM 51-30-1, AND 51-40-2. (M)SDR ASAA0540434Bulkhead · corrodedCORROSION ON AFT PRESSURE BULKHEAD C-CHANNEL. REMOVED DAMAGED SECTION OF AFT PRESSURE BULKHEAD AND VERTICAL STIFFENER, FABRICATED REPAIR PARTS AND INSTALLED IAW EA. (K)SDR ASAA0540436Guide Arm · out of rigCREW PREFLIGHT - L1 DOOR DIFFICULT TO CLOSE. RIGGED L-1 DOOR GUIDE ARM, CONTROL PUSHROD AND STOP PINS. (K)SDR ASAA0540432Seal Depressor · crackedFWD GALLEY DOOR CUTOUT FWD UPPER SEAL DEPRESSOR CRACKED. REMOVED AND REPLACED IAW EA. (K)SDR ASAA0540431Skin · damagedRUDDER SKIN DAMAGED AT 3 LOCATIONS. LWR LT SIDE AT BOTTOM CORNER EDGE 1 INCH, 2 INCH, AND 7 INCH AFT OF L/E. REPAIRED DAMAGE IAW EA. (K)SDR ASAA0540430Floor Support · damagedWHILE WORKING FOUND FLOOR SUPPORT IN AFT CARGO BAY TO BE DAMAGED AT BSTA 727E+14 INCH, LBL 13. TRIMMED OUT DAMAGED AREA IN FLOOR SUPPORT IN AFT CARGO BAY AT BSTA 727E + 14 INCH LBL 13 AREA, REMOVED .5 INCH X 6 INCH SECTION, THEN FABRICATED AND INSTALLED REPAISDR ASAA0540429Floorbeam · corrodedCORROSION ON FLOORBEAM. REMOVED TOP SECTION OF FLOORBEAM, FABRICATED AND INSTALLED REPAIR PARTS AND INSTALLED. (K)SDR ASAA0540428Skin · puncturedRT IB FORE FLAP LWR SKIN PUNCTURED. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR FILLERS AND DOUBLERS IAW SRM. (K)SDR ASAA0540427Wedge · dentedRT IB MID FLAP T/E WEDGE 7420R HAS SEVERAL DINGS. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR FILLERS AND DOUBLERS IAW SRM. (K)SDR ASAA0540426Skin · dentedLT IB FORE FLAP DENTED, DELAMINATED ON LOWER SKIN AT CENTER TRACK. REMOVED DAMAGE, FABRICATED AND INSTALLED SKIN SECTION AND DOUBLER IAW SRM. (K)SDR ASAA0540425Floorbeam · corrodedCORROSION ON FLOORBEAM BSTA 947.5, LBL 16, RBL 16, WL 208. REPAIRED FLOORBEAM IAW SRM AND EA. (K)SDR ASAA0540424Sill · corrodedCORROSION ON AFT GALLEY MOP SILL BSTA947-1000, RBL 49, WL 206. REMOVED AND REPLACED AFT GALLEY MOP SILL. (K)SDR ASAA0540423Web · misdrilledCENTER FUEL CELL, AFT CELL, DRILL START DAMAGE ON UPPER CHORD AND SPANWISE BEAM WEB. REPAIRED DRILL START ON UPPER CHORD AND SPANWISE BEAM. (K)SDR ASAA0540422Sill · corrodedCORROSION ON AFT ENTRY MOPSILL, BS 937 TO 1000. REMOVED AND REPLACED AFT ENTRY MOPSILL. (K)SDR ASAA0540421Frame · crackedFRAME AT BSTA 500, RBL 1, WL 154 CRACKED. REPAIRED FRAME IAW SRM. (K)SDR ASAA0540420Stringer · corrodedSTRINGER 28L IS CORRODED AT BSTA 500G. REMOVED DAMAGED SECTION OF STR 28L, FABRICATED AND INSTALLED REPAIR PIECES IAW SRM. (K)SDR ASAA0540419Web · corrodedAFT PIT DOOR-SILL WEB CORRODED. REMOVED CORRODED WEB, LOCATED AND INSTALLED NEW WEB IAW SRM. (K)SDR ASAA0540418Shear Tie · corrodedSHEAR TIE AND FRAME AT 747 BL0, RBL 5, IS CORRODED. REMOVED DAMAGED SECTION OF SHEAR TIE AND FRAME, FABRICATED AND INSTALLED REPAIR PIECES IAW SRM. (K)SDR ASAA0540417Shear Tie · corrodedSHEAR TIE AT FRAME 747C, RBL 12 IS CORRODED. REMOVED DAMAGED SECTION OF SHEAR TIE, FABRICATED AND INSTALLED REPAIR PIECES IAW SRM. (K)SDR ASAA0540416Shear Tie · corrodedSHEAR TIE AT FRAME 727C BL 0 IS CORRODED. REMOVED DAMAGED SECTION OF SHEAR TIE, FABRICATED AND INSTALLED REPAIR PIECES IAW SRM. (K)SDR ASAA0540395Frame · crackedCRACKED FRAME AT BIN RAIL STA 400. REPAIRED CRACKED FRAME AT BIN RAIL BSTA 400, STR 8L- 9L IAW SRM. (K)SDR ASAA0540394Frame · crackedCRACKED FRAME AT BIN RAIL STA 440. REPAIRED CRACKED FRAME AT BIN RAIL BSTA 440, STR 8L-9L IAW SRM. (K)SDR ASAA0540399Seat Track · corrodedPAE - FOUND SEAT TRACK CORRODED AT BS 907 RBL 25 WL 208. REMOVED REPLACED SEAT TRACK. (M)SDR ASAA0540398Frame · crackedPAE - FOUND CRACKED FRAME AT BIN RAIL STATION 400 BETWEEN STRINGER 8R-9R. REPAIRED CRACKED FRAME AT BIN RAIL STATION 400 BETWEEN STRINGER 8R-9R IAW 737-400 SRM 53-00-07. (M)SDR ASAA0540397Frame · crackedPAE - FOUND CRACKED FRAME. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR IAW 737-400 SRM 53-00-07. (M)SDR ASAA0540396Frame · crackedPAE - FOUND CRACKED FRAME. REPAIRED CRACKED FRAME IAW 737-400 SRM 53-00-07. (M)SDR ASAA0540415Intercostal · misdrilledFWD CARGO BAY, BSTA 509, RBL 22, WL 154, INTERCOSTAL HAS A DRILL START. REMOVED, FABRICATED AND INSTALLED REPAIR PARTS IAW SRM. (K)SDR ASAA0540414Frame · corrodedCORROSION ON FRAME WEB BSTA 796, STR 24R. REMOVED CORROSION, OUT OF LIMITS AND REPAIRED IAW SRM. (K)SDR ASAA0540413Seat Track · corrodedCORROSION ON SEAT TRACK FLANGE, BSTA 344, LBL 45, WL 208. REMOVED AND REPLACED SEAT TRACK IAW SRM. (K)SDR ASAA0540412Web · corrodedCORROSION ON WEB UNDER FWD ENTRY DOOR MOPSILL AT BSTA 333-342, LBL 58, WL 208. REPLACED WEB UNDER FWD ENTRY DOOR MOPSILL. (K)SDR ASAA0540411Floorbeam · corrodedCORROSION ON FLOORBEAM BSTA 1076, RBL 25-30, WL 208. BLENDED CORROSION, DETERMINED TO BE OUT OF LIMITS, REPAIRED FLOORBEAM IAW SRM. (K)SDR ASAA0540410Sill · corrodedCORROSION ON FWD ENTRY DOOR MOPSILL BSTA 300-344, LBL 58, WL 208. REMOVED AND REPLACED IAW SRM. (K)SDR ASAA0540409Channel · corrodedCORROSION ON U-CHANNEL, BSTA 312 - 344, LBL 59, WL 208. REMOVED AND REPLACED IAW SRM. (K)
Back to Boeing 737-4Q8