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 ASAA0640054Cargo Track · corrodedPAE - AFT CARGO COMPARTMENT, CORROSION ON CARGO TIE DOWN TRACKS. FOUND OUT OF LIMITS, CARGO TIE DOWN TRACK REPLACED ON MIG-5 CARD NR 4989820 PER B737-400 SRM 53-60-53. (M)SDR ASAA0640053Floorbeam · corrodedPAE - FOUND CORROSION ON FLOORBEAM AT BS 967, LBL 15-19, WL 208. REPAIRED PER B737-400 SRM 53-00-51 REPAIR 3. (M)SDR ASAA0640052Floorbeam · corrodedPAE - FOUND CORROSION ON FLOORBEAM AT BS 312, WL 208, LBL 11. REMOVED AND REPLACED SECTION IAW B737-400 SRM 53-10-51 AND ASA EA 5310-02552. (M)SDR ASAA0640051Frame · corrodedPAE - FOUND CORROSION ON FRAME AT BS 270, WL 208, RBL 8. REMOVED AND FABRICATED NEW FRAME IAW B737-400 SRM 51-40-05 AND 51-40-02. (M)SDR ASAA0640050Threshold · corrodedPAE - FOUND CORROSION ON AFT CARGO BAY DOOR CUT OUT SUB THRESHOLD WEB. REMOVED AND REPLACED AFT CARGO BAY SUB THRESHOLD WEB IAW B737-400 SRM 51-40-02. (M)SDR ASAA0640043Sill · corrodedPAE - FOUND CORROSION ON LT MOPSILL AT BS 950, WL 208. REMOVED AND REPLACED MOPSILL IAW B737-400 SRM 5360-15, 51-40-02, 51-40-08, AND AMM 51-21-41. (M)SDR ASAA0640042Frame · corrodedPAE - FOUND CORROSION ON BS 847 FRAME. REMOVED AND REPLACED FRAME IAW B737-400 SRM 51-40-05, 51-40-02, AND DWG 65-47960. (M)SDR ASAA0640041Strap · corrodedPAE - FOUND CORROSION ON AFT CARGO BAY DOORWAY FLOOR STRAP. REMOVED AND REPLACED STRAP IAW B737-400 SRM 53-60-15 AND 51-40-02. (M)SDR ASAA0640040Frame · corrodedPAE - FOUND CORROSION ON BS 794, FRAME BETWEEN STRINGER 23R-26R. REMOVED AND REPLACED FRAME AT BS 794, BETWEEN STRINGERS 16 TO 26 RT, IAW B737-400 SRM 51-40-02. (M)SDR ASAA0640039Sill · corrodedPAE - FOUND CORROSION ON LT MOPSILL AT BS 950, WL 208. REMOVED AND REPLACED MOPSILL IAW B737-400 SRM 53-60-15, 51-40-02, 51-40-08 AND AMM 51-21-41. (M)SDR ASAA0640038Stringer Clip · crackedPAE - FOUND STRINGER CLIP CRACKED AT BS 500B, STRINGER 11 RT. REMOVED AND REPLACED STRINGER CLIP AT BS 500B, STRINGER 11 RT IAW B737-400 SRM 51-40-02. (M)SDR ASAA0640037Stringer Clip · crackedPAE - FOUND STRINGER CLIP CRACKED AT BS 500D, STRINGER 11 RT. REMOVED AND REPLACED STRINGER CLIP AT BS 500D, STRINGER 11 RT IAW B737-400 SRM 51-40-02. (M)SDR ASAA0640036Stringer Clip · crackedPAE - FOUND STRINGER CLIP CRACKED AT BS 500A, STRINGER 11 RT. REMOVED AND REPLACED STRINGER CLIP AT BS 500A, STRINGER 11 RT IAW B737-400 SRM 51-40-02. (M)SDR ASAA0640035Failsafe · corrodedPAE - FOUND FAILSAFE AT BS 794, RBL 19, CORRODED. REMOVED AND REPLACED FAILSAFE AT BS 794, RBL 19, IAW B737-400 SRM 51-40-02. (M)SDR ASAA0640034Sill · corrodedPAE - FOUND RIGHT MOPSILL AT BS 950 TO 990 WL 208 CORRODED. REMOVED AND REPLACED RT MOPSILL AT BS 950-990 IAW B737-400 SRM 53-60-15.SDR ASAA0640028Battery Pack · inoperativeJNU - AFT LEFT SVC DOOR OVER DOOR EMERGENCY AND AFT RIGHT SVC DOOR EXIT LOCATOR SIGN LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK FOR AFT LEFT SVC DOOR EXIT LOCATOR SIGN LIGHTS. OPS CHECKS NORMAL.SDR ASAA0640027Sill · corrodedOKC - FOUND CORROSION ON R2 DOOR THRESHOLD MOPSILL, INNER CHORD. REMOVED AND REPLACED R2 DOOR THRESHOLD MOPSILL IAW B737-400 SRM 53-60-15 FIG 101 DETAIL 5, AND SRM 51-40-02, 51-40-05 AND 51-40-08. (M)SDR ASAA0640026Crease Beam · corrodedPAE - FOUND CORROSION ON CREASE BEAM AT BS 601, LBL 64, WL 208. REMOVED AND REPLACED CREASE BEAM AT BS 540 TO 663, LBL 64, WL 208, PER B737-400 SRM 53-60-13 PAGE 106, DETAIL 5, SRM 53-60-13, PAGE 2, DETAIL 1. (M)SDR ASAA0640025Crease Beam · corrodedPAE - FOUND CORROSION ON CREASE BEAM AT BS 639, RBL 64, WL 208. REMOVED AND REPLACED CREASE BEAM AT BS 540 TO 663, RBL 64, WL 208, PER B737-400 SRM 51-40-02 PAGE 1-2, STEP 4, SRM 51-10-02 SRM 53-60-13. (M)SDR ASAA0640023Structure · corrodedCORROSION ON STRUCTURE AT BS 270, WL 208, RBL 8. REMOVED, REPLACED, AND FABRICATED NEW STRUCTURE IAW SRM. (K)SDR ASAA0640022Floorbeam · corrodedCORROSION ON FLOORBEAM UPPER STRUCTUREAT BS 312, WL 208, LBL 11. REMOVED AND REPLACED STRUCTURE IAW SRM AND EA. (K)SDR ASAA0640021Angle · corrodedSUB THRESHOLD ANGLE CORRODED AT BSTA 795, RBL 19-23. REMOVED AND REPLACED SUB THRESHOLD ANGLE AT BSTA 795, RBL 19-23 IAW SRM. (K)SDR ASAA0640020Fitting · corrodedFWD LAV AFT WALL IB TIE DOWN FITTING CORRODED. REMOVED AND REPLACED FWD LAV AFT WALL IB TIE DOWN FITTING IAW SRM. (K)SDR ASAA0640019Frame · corrodedCORROSION ON FWD CARGO BAY AT BSTA 500C BETWEEN STR 28L AND 28R AND STR 28R SHEAR TIE HAS CORROSION AT LWR FASTENER TO SKIN. REPAIRED FRAME AT BSTA 500C BETWEEN STRINGERS 28L AND 28R IAW SRM. (K)SDR ASAA0640018Shear Tie · corrodedCORROSION ON FWD CARGO BAY AT BSTA 500B BETWEEN STR 28L AND 28R SHEAR TIE CORROSION AT LWR FWD SURFACE. REPAIRED FRAME AT BSTA 500B BETWEEN STRINGERS 28L AND 28R IAW SRM. (K)SDR ASAA0640017Floorbeam · corrodedCORROSION ON FLOORBEAM UPPER CHORD. REPAIRED FLOORBEAM IAW SRM. (K)SDR ASAA0640016Frame · corrodedFWD CARGO BAY STA 500D BETWEEN STRINGERS 28L AND 28R SHEAR TIE CORRODED. REPAIRED FWD CARGO BAY STA 500D FRAME BETWEEN STR 28L AND 28R SHEAR TIE. (K)SDR ASAA0640058Cargo Track · corrodedSEA - FOUND AFT CARGO PIT TIE DOWN TRACK CORRODED AT THRESHOLD AREA. REMOVED AND REPLACED AFT CARGO PIT RT TIE DOWN TRACK IAW B737-400 SRM 53-00-53, FIG 201. (M)SDR ASAA0640024Door Frame · tornFWD CARGO DOOR OPENING DAMAGED ON FWD SIDE BY GROUND EQUIPMENT. INSTALLED REPAIR IAW SRM. (K)SDR ASAA0640008Skin · dentedPAE - AFT CARGO DOOR EXTERNAL SKIN DENTED AND GOUGED. REPLACED SKIN PER B737-400 SRM 52-30-01. (M)SDR AASAA0640008Skin · dentedAFT CARGO DOOR EXTERNAL SKIN DENTED AND GOUGED. REPLACED SKIN IAW SRM. (K)SDR ASAA0640007Skin · dentedAFT CARGO DOOR EXTERNAL SKIN DENTED AND GOUGED. REPLACED SKIN IAW SRM. (K)SDR ASAA0640009Frame · crackedFRAME CRACKED AT BIN RAIL. REPAIRED FRAME IAW SRM. (K)SDR ASAA0640006Doubler · corrodedCORROSION ON DOUBLER, BLENDED OUT OF LIMITS, FABRICATED NEW DOUBLER AND INSTALLED IAW ENGINEERING DWG. (K)SDR ASAA0640005Frame · crackedFRAME CRACKED AT BIN RAIL. REPAIRED FRAME AT BIN RAIL LOCATION IAW SRM. (K)SDR ASAA0640004Frame · crackedFRAME CRACKED AT BIN RAIL SUPPORT. REPAIRED FRAME AT BIN RAIL LOCATION IAW SRM. (K)SDR ASAA0640003Frame · crackedFRAME CRACKED AT BIN RAIL ATTACH POINT. INSTALLED FRAME REPAIR DOUBLER ON BSTA 480 FRAME RT AT BIN RAIL LOCATION IAW SRM. (K)SDR ASAA0640002Frame · crackedFRAME CRACKED AT BIN RAIL ATTACH POINT. REMOVED DAMAGE, FABRICATED AND REPAIRED FRAME IAW SRM. (K)SDR ASAA0540762Attach Fitting · crackedPAE - FOUND FRAME CRACKED AT BIN RAIL ATTACH POINT. REPAIRED CRACKED FRAME IAW B737-400 SRM 53-00-07. (M)SDR ASAA0540765Door Frame · crackedPAE- FWD CARGO DOOR FWD FRAME CRACKED AT NR5 DOORSTOP FITTING. REMOVED AND REPLACED BSTA 440 FWD CARGO DOOR FRAME IAW SRM. (K)SDR ASAA0540766Floorbeam · corrodedPAE- CORROSION ON TOP CHORD OF FLOOR BEAM. REPAIRED FLOOR BEAM IAW SRM. (K)SDR ASAA0540767Frame · crackedPAE- BSTA 380 FRAME MEMBER CRACKED AT BIN RAIL ATTACH. REPAIRED FLOOR BEAM IAW SRM. (K)SDR ASAA0540768Frame · dentedDENT IN FRAME AT BS 727F BETWEEN STR 22R-24R. REPAIRED FRAME IAW SRM 51-70-11. (K)SDR ASAA05400762Frame · crackedPAE- FRAME CRACKED AT BIN RAIL ATTACH POINT. REPAIRED CRACKED FRAME IAW SRM. (K)SDR ASAA0540763Floor Support · corrodedPAE-FWD CARGO BAY FLOOR SUPPORT CORRODED. CUT OUT DAMAGED FLOOR SUPPORT, FABRICATED AND INSTALLED REPAIR IAW SRM. (K)SDR ASAA0540764Shear Tie · corrodedPAE- CORROSION ON FWD CARGO FRAME SHEAR TIE AT BSTA 500B BL 0, STR 28 LT. FOUND CORROSION TO BE OUT OF LIMITS, FABRICATED AND INSTALLED REPAIR TO FRAME SHEAR TIE IAW SRM. (K)SDR ASAA0540756Stringer · corrodedPAE: CORROSION ON STRINGER END FITTING. REMOVED AND REPLACED FITTING IAW SRM. (K)SDR ASAA0540757Stiffener · corrodedPAE: CORROSION ON TORQUE BOX STIFFENER. REMOVED AND REPLACED STIFFENER IAW SRM. (K)SDR ASAA0540758Stiffener · corrodedPAE: CORROSION ON TORQUE BOX STIFFENER. REMOVED AND REPLACED STIFFENER IAW SRM. (K)SDR ASAA0540759Stiffener · corrodedPAE: CORROSION ON TORQUE BOX STIFFENER. REMOVED AND REPLACED STIFFENER IAW SRM. (K)
Back to Boeing 737-4Q8