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 ASAAA0540666Sill · crackedPAE - FOUND CORROSION AT AFT ENTRY DOOR MOPSILL BS 947-996, LBL 52, WL 208 AND CRACKED AT BS 994. REMOVED AND REPLACED AFT ENTRY MOPSILL PER B737-400 SRM 51-40-02. (M)SDR ASAA0540669Stringer · corrodedYXX - APU COMPARTMENT RIGHT TORQUE BOX STRINGER AT BS 1126 IS CORRODED. REPLACED STRINGER IAW B737-400 SRM 51-40-02. (M)SDR ASAA0540668Web · crackedYXX - FOUND CRACKED WEB AT BS 303.9, STRINGER 16 LEFT. REPAIRED IAW ERO NR 5039 AND ASA EA 5310-02523. (M)SDR ASAA0540667Floorbeam · corrodedPAE - FOUND FLOORBEAM CORRODED. REMOVED DAMAGED SECTION OF FLOORBEAM UPPER CHORD, FABRICATED REPAIR PARTS AND INSTALLED PER EA 5310-02515. (M)SDR ASAA0540666Sill · corrodedPAE - FOUND CORROSION AT AFT ENTRY DOOR MOPSILL BS 947-996, LBL 52, WL 208 AND CRACKED AT BS 994. REMOVED AND REPLACED AFT ENTRY MOPSILL PER B737-400 SRM 51-40-02. (M)SDR ASAA0540665Shear Tie · corrodedPAE - FOUND CORROSION AT AFT CARGO BAY ON SHEAR TIE. REMOVED DAMAGED SECTION OF SHEAR TIE, FABRICATED REPAIR PARTS AND INSTALLED PER B737-400 SRM 53-00-07. (M)SDR ASAA0540662Frame · corrodedPAE - AFT CARGO BAY ODOR FRAME DOUBLER, BS 849, RBL 28, CORRODED. REPLACED FRAME ASSY PER B737-400 SRM 51-40-02. (M)SDR ASAA0540661Frame · corrodedPAE - FOUND CORROSION ON FRAME UPPER CHORD. REPAIRED PER B737-400 SRM 51-70-11. (M)SDR ASAA0540660Frame · corrodedPAE - FOUND FRAME CORRODED AT BS 727E, LBL 20. REPAIRED PER B737-400 SRM 53-00-07. (M)SDR ASAA0540659Frame · dentedPAE - FOUND DENT IN FRAME AT BS 500E, STRINGER 24R. REPAIRED DENT PER B737-400 SRM 51-70-11 AND 53-30-53. (M)SDR ASAA0540664Sill · corrodedRT DOOR R1, MOPSILL CORRODED. REPLACED MOPSILL IAW SRM. (K)SDR ASAA0540663Crease Beam · corrodedRT CREASE BEAM CORRODED. REPLACED IAW SRM. (K)SDR ASAA0540656Seal Depressor · corrodedPAE-CORROSION ON FWD SERVICE DOOR CUTOUT SEAL DEPRESSOR. REMOVED AND REPLACED DUE TO FINDING CRACKS WHILE REMOVING CORROSION. (K)SDR ASAA0540655Frame · corrodedPAE- CORROSION AFT CARGO BAY FRAME CHROD SHEAR TIE. REPAIRED IAW SRM. (K)SDR ASAA0540654Skin · crackedPAE - NR 3 SLAT LWR T/E SKIN AT IB END CRACKED AT FASTENER HOLE. REPAIRED IAW SRM. (K)SDR ASAA0540653Skin · crackedPAE- NR 3 SLAT LWR T/E SKIN AT OB END CRACKED THROUGH FASTENER HOLE. REPAIRED IAW SRM 57-43-01. (M)SDR ASAA0540652Beam · crackedPAE- NR3 SLAT LWR T/E SKIN AT OB AUX TRACK, 5 EA CRACKS THROUGH FASTENER HOLES. REPAIRED IAW SRM. (K)SDR ASAA0540651Beam · crackedPAE- FWD ENTRY DOOR LWR GATE BEAM CRACKED. REMOVED AND REPLACED IAW SRM. (K)SDR ASAA0540650Web · corrodedPAE-CORROSION ON SHEAR WEB. REMOVED AND REPLACED SHEAR WEB IAW SRM. (K)SDR ASAA0540649Frame · corrodedPAE-CORROSION ON LOWER FRAME CHORD. REMOVED AND REPLACED LOWER FRAME CHORD IAW SRM. (K)SDR ASAA0540657Frame · corrodedPAE - FOUND CORROSION AFT CARGO BAY, FRAME LOWER CHORD. CORROSION OUT OF LIMITS, FABRICATED AND INSTALLED NEW SHEAR TIE FRAME PER B737-400 SRM 53-00-07. (M)SDR ASAA0540658Floorbeam · corrodedPAE - FOUND CORROSION AROUND FASTENER HOLES IN FLOORBEAM UPPER CHORD AT BS 986, RLB 24 TO LBL 44, WL 208. REPAIRED PER B737-400 SRM 53-60-51 AND EA 5310-0251. (M)SDR ASAA0540642Skin · corrodedPAE - FOUND CORROSION ON SKIN UNDER NR 2 DME ANTENNA. REMOVED AND REPLACED SKIN PER SRM 51-40-02. (M)SDR ASAA0540643Shear Tie · corrodedPAE-CORROSION AT BSTA 500B, RBL 16, WL 149, UPPER SURFACE OF SHEAR TIE AT FASTENER. REPAIRED SHEAR TIE IAW SRM. (K)SDR ASAA0650642Skin · corrodedPAE - CORROSION ON SKIN UNDER NR 2 DME ANTENNA. REMOVED AND REPLACED SKIN IAW SRM. (K)SDR ASAA0540641Skin · dentedPAE - DENT IN FUSELAGE SKIN. REPAIRED SKIN IAW EA. (K)SDR ASAA0540640Floorbeam · crackedPAE - PREVIOUS REPAIR CRACKED AT FRAME. REMOVED AND REPLACED REPAIR ANGLES IAW EA. (K)SDR ASAA0540639Frame · tool damagePAE- DRILL START ON FRAME AT BSTA 767, RBL 12, WL 154. REPAIRED FRAME IAW SRM. (K)SDR ASAA0540638Door · scratchedPAE - FWD CARGO DOOR LWR AFT SIDE FRAME IS SCRATCHED. REMOVED AND REPLACED FRAME IAW SRM. (K)SDR ASAA0540637Frame · tool damagePAE - AFT CARGO BAY DRILL START ON FRAME UPPER FLANGE. REPAIRED FRAME IAW SRM. (K)SDR ASAA0540636Frame · gougedPAE-MECHANICAL DAMAGE TO FLOOR BEAM AT BSTA 312, LBL 11-54, WL 208. REMOVED AND REPLACED FLOOR BEAM UPPER CHORD AT BSTA 312, WL 208 IAW SRM. (K)SDR ASAA0540647Web · crackedYXX-SB, WEB MOD AT BSTA 360, STR 16 LT, TO BE COMPLIED WITH. SB ACCOMPLISHED IAW EO. (K)SDR ASAA0540646Bracket · crackedYXX - R-1 DOOR INTERIOR, AT AFT BOTTOM CORNER, PLATE CRACKED THROUGH AT FASTENER HOLES. REPAIRED BY INSTALLING REPAIR PARTS IAW SRM. (K)SDR ASAA0540645Floorbeam · corrodedYXX - FLOORBEAM AT BSTA 344, BL 0, TO LBL 65 CORRODED AT ANCHOR NUT HOLES. REPAIRED IAW SRM. (K)SDR ASAA0540644Floorbeam · corrodedYXX - CORROSION ON TOP SURFACE OF FLOORBEAM AT BSTA 294.5, LBL 12 TO RBL 12. FLOOR BEAM UPPER CHORD REPAIRED BY SPLICE IAW SRM. (K)SDR ASAA0540603Frame · crackedPAE - FOUND BS 380 FRAME MEMBER CRACK AT BIN RAIL ATTACHMENT. REPAIRED PER B737-400 SRM 53-00-07. (M)SDR ASAA0540621Fitting · corrodedPAE - FOUND CORROSION ON L-1 DOOR GIRT BAR FITTING. REMOVED AND REPLACED IAW B737-400 SRM 51-40-02 AND 53-00-07. (M)SDR ASAA0540626Shear Web · corrodedPAE - FOUND CORROSION ON SHEAR WEB. REMOVED AND REPLACED IAW B737-400 SRM 51-40-02 AND DWG 65-45875.SDR ASAA0540630Intercostal · crackedPAE - FOUND INTERCOSTAL ANGLE CORRODED AT BS 925-987, FOUND TO BE CRACKED ALSO AT THE FASTENER HOLE. REPLACED INTERCOSTAL IAW B737-400 SRM 53-60-51 AND 51-40-06. (M)SDR ASAA0540632Skin · bird strikeOKC - FOUND FUSELAGE SKIN L/E NEAR RADOME SEAM RIGHT SIDE DAMAGED FROM BIRD STRIKE. TEMPORARY REPAIR INSTALLED, REF EM 5330-02004. REMOVED EXISTING TEMPORARY REPAIR. FABRICATED AND INSTALLED A REPAIR FILLER AND DOUBLER IAW ASA EA 5310-02519. (M)SDR ASAA0540635Frame · crackedPAE - FOUND FRAME CRACKED AT FORWARD ENTRY DOOR LOWER STOP PAD FITTING. REMOVED DAMAGED SECTION OF FRAME. FABRICATED AND INSTALLED NEW FRAME, FITTINGS, REPAIR PARTS, AND INSTALLED IAW ASA EA 5310-02518. (M)SDR ASAA0540634Skin · dentedOKC - FUSELAGE SKIN DENTED IN FIVE LOCATIONS BETWEEN BS 360-368, AT STRINGER 16-18 LEFT. CUT OUT DAMAGED AREA OF SKIN, FABRICATED AND INSTALLED A REPAIR DOUBLER, TRIPLER AND FILLER IAW ASA EA 5330-02022. (M)SDR ASAA0540633Skin · dentedFOUND FUSELAGE SKIN DENT OUT OF LIMITS AT BS 246, 5 INCHES BELOW AND 5 INCHES AFT OF THE EXTERNAL POWER RECEPTACLE. CUT OUT DAMAGED AREA OF SKIN, FABRICATED AND INSTALLED A REPAIR DOUBLER, TRIPLER AND FILLER IAW B737-400 SRM 53-00-01 FIGURE 201 REPAIR 31 AND SDR ASAA0540631Floorbeam · corrodedPAE - FOUND FLOORBEAM CORRODED. REMOVED, FABRICATED AND INSTALLED FLOORBEAM IAW B737-400 SRM 53-10-51 REPAIR 5. (M)SDR ASAA0540624Shear Tie · corrodedPAE - FOUND CORROSION ON SHEAR TIE. REPAIRED SHEAR TIE IAW B737-400 SRM 53-00-07. (M)SDR ASAA0540629Intercostal · corrodedFOUND INTERCOSTAL ANGLE CORRODED AT BS 925-987, FOUND TO BE CRACKED ALSO AT THE FASTENER HOLE. REPLACED INTERCOSTAL IAW B737-400 SRM 53-60-51 AND 51-40-06. (M)SDR ASAA0540628Frame · crackedPAE - FOUND CRACKED FRAME AT BIN RAIL SUPPORT AT BS 360 BETWEEN STRINGER 7-8 LEFT. REPAIRED CRACKED FRAME IAW B737-400 SRM 53-00-07. (M)SDR ASAA0540627Fitting · corrodedPAE - FOUND CORROSION ON L1 AFT GIRT BAR FITTING. REPAIRED IAW B737-400 SRM 51-40-02 AND 53-00-07. (M)SDR ASAA0540625Seat Track · corrodedPAE - FOUND CORROSION AT BS 500F-500G, LBL 18.5, WL 156 ON FLOOR TRACK. REMOVED DAMAGED FLOOR TRACK AND REPLACE IAW B737-400 SRM 53-00-53. (M)SDR ASAA0540623Sill · corrodedPAE - FOUND AFT SERVICE DOOR CUTOUT MOPSILL IS CORRODED. REMOVED AND REPLACED INTERCOSTAL IAW B737-400 SRM 51-40-02 AND DWG 65-45885. (M)
Back to Boeing 737-4Q8