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 ASAA0540622Intercostal · corrodedPAE - FOUND INTERCOSTAL ANGLE CORRODED AT BS 925-947, FOUND TO BE CRACKED ALSO AT FASTENER HOLES. REMOVED AND REPLACED INTERCOSTAL IAW B737-400 SRM 51-40-06 AND 53-60-51. (M)SDR ASAA0540620Support · corrodedPAE - FOUND CORROSION ON L1 DOOR GIRT BAR FITTING SUPPORT. REMOVED AND REPLACED IAW B737-400 SRM 51-40-02. (M)SDR ASAA0540619Sill · corrodedPAE - FOUND AFT ENTRY DOOR CUTOUT MOPSILL CORRODED. REMOVED AND REPLACED MOPSILL IAW B737-400 SRM 51-40-02, AND DWG 65-52878. (M)SDR ASAA0540610Stop Fitting · corrodedPAE - FOUND AFT ENTRY DOORSILL AREA DOOR STOP PAD FITTINGS CORRODED. REMOVED AND REPLACED PER B737-400 SRM 51-40-02, AND DWG 65-52878. (M)SDR ASA05400603Frame · crackedPAE - FOUND BS 380 FRAME MEMBER CRACK AT BIN RAIL ATTACHMENT. REPAIRED PER B737-400 SRM 53-00-07. (M)SDR ASAA0540602Structure · corrodedPAE - FOUND CORROSION AROUND FASTENER AT BS 631, RBL 1, BETWEEN STRINGER 28 RT AND 28 LEFT. PERFORMED BUTT SPLICE STRAP REPAIR PER ASA EA 5310-02516. (M)SDR ASAA0540598Repair · crackedPAE - PREVIOUS REPAIR CRACKED AT FRAME. REMOVED AND REPLACED REPAIR ANGLES PER ASA EA 5310-02517. (M)SDR ASAA0540597Keelbeam · corrodedKEEL BEAM HAS CORROSION AT LT OB LWR EDGE. BLENDED CORROSION, MAX MATERIAL REMOVED .051, ORIGINAL THICKNESS .140. FOUND TO BE OUT OF LIMITS. FABRICATED AND INSTALLED REPAIR PARTS IAW EA. (K)SDR ASAA0540605Frame · corrodedPAE - FOUND CORROSION AT APU COMPARTMENT LOWER CHORD FOR AIR INLET IS CORRODED AT BS 1118 TO 1125, RBL 20. REMOVED AND REPLACED PER B737-400 SRM 51-40-02 AND DWG 65-46579. (M)SDR ASAA0540614Skin · dentedOKC - DENT IN FUSELAGE SKIN BETWEEN STRINGER 20R-21R, BS 294-296. TEMPORARY REPAIR INSTALLED. REMOVED EXISTING REPAIR, CUTOUT DAMAGED AREA OF SKIN, FABRICATED AND INSTALLED A REPAIR DOUBLER, TRIPLER, FILLERS AND TWO TEAR STRAP INTERNAL DOUBLERS IAW B737-400 SDR ASAA0540604Frame · corrodedPAE - FOUND CORROSION AT APU COMPARTMENT UPPER CHORD FOR AIR INLET IS CORRODED AT BS 1122, RBL 11, WL 214. REMOVED AND REPLACED PER B737-400 SRM 51-40-02 AND DWG 656-46579. (M)SDR ASAA0540613Skin · dentedOKC - FOUND FUSELAGE SKIN DENTED OUT OF LIMITS ON EITHER SIDE OF STRINGER 27 LEFT AT BS 853-855. DAMAGE IS ADJACENT TO AN EXISTING REPAIR AT BS 837-850 STRINGER 226 RT-27 RT. REMOVED DAMAGED AREA OF SKIN, REMOVED EXISTING REPAIR DOUBLER. FABRICATED AND INSTSDR ASAA0540612Skin · damagedOKC - FUSELAGE SKIN EXTERIOR DAMAGE REMOVAL OUT OF LIMITS AT BS 868, 1 INCH BELOW STRINGER 21 RT. CUT OUT DAMAGED AREA OF SKIN, FABRICATED AND INSTALLED A REPAIR DOUBLER, TRIPLER, AND FILLERS PER B737-400 SRM 53-00-01, FIG 201, AND REPAIR 31. (M)SDR ASAA0540611Floorbeam · corrodedYXX - FOUND CORROSION ON FLOORBEAM AT BS 312, LBL 12-50. DAMAGED SECTION OF FLOORBEAM REPLACED PER B737-400 SRM 53-10-51 FIG 201. (M)SDR ASAA0540609Web · damagedPAE - WEB HAS ELONGATED HOLES AT BS 344 TO 360, WL 208, RBL 65. REMOVED DAMAGED SECTION OF WEB, REPAIRED AND INSTALLED NEW SECTION PER B737-400 SRM 51-20-13 FIGURE 1. (M)SDR ASAA0540608Web · damagedPAE - FOUND WEB HAS ELONGATED HOLES AT BS 332, WL 208, RBL 65. REMOVED DAMAGED SECTION, REPAIRED PER B737-400 SRM 51-70-13. (M)SDR ASAA0540607Doubler · corrodedPAE - FOUND CORROSION ON SKIN DOUBLER FOR BODY DRAIN AT BS 500-500A PLUS 5 INCHES. REMOVED AND REPLACED DOUBLER PER B737-400 SRM 51-40-02. (M)SDR ASAA0540606Doubler · corrodedPAE - FOUND CORROSION ON SKIN DOUBLER FOR BODY DRAIN AT BS 500C- 500C PLUS 5 INCHES. REMOVED AND REPLACED DOUBLER PER B737-400 SRM 51-40-02. (M)SDR ASAA0540601Frame · scratchedPAE - FOUND SCRATCH IN FORWARD CARGO DOOR SIDE FRAME. REPLACED FRAME PER B737-400 SRM 51-40-02. (M)SDR ASAA0540600Skin · dentedPAE - FOUND DENT IN FUSELAGE SKIN. REPLACED SKIN PER ASA EA 5330-02014. (M)SDR ASAA0540599Skin · dentedPAE - FOUND DENT IN FUSELAGE SKIN. REPAIRED SKIN PER ASA EA 5330-02014. (M)SDR ASAA0540595Frame · chafedPAE - FOUND AFT CARGO DOOR LOWER FORWARD SIDE FRAME HAS MULTIPLE NICKS AND CHAFING FROM LOWER STOP CUTOUT TO LOWER EDGE OF DOOR. REMOVED AND REPLACED FRAME SECTION PER B737-400 SRM 51-40-02. (M)SDR ASAA0540593Floorbeam · corrodedPAE - FOUND CORROSION ON FLOORBEAM. REPAIRED FLOORBEAM PER B737-400 SRM 53-60-51. (M)SDR ASAA0540594Sill · corrodedPAE - FOUND L-1 DOOR CUTOUT MOPSILL CORRODED. REPLACED L-1 DOOR MOPSILL PER B737-400 SRM 51-40-02. (M)SDR ASAA0540587Reveal · crackedPAE - FOUND FORWARD SERVICE DOOR CUTOUT AFT LOWER SEAL DEPRESSOR IS CRACKED. REMOVED AND REPLACED PER B737-400 SRM 51-40-02. (M)SDR ASAA0540586Seat Track · corrodedPAE - FOUND CORROSION ON SEAT TRACK. REMOVED AND REPLACED CORRODED SEAT TRACK PER B737-400 SRM 53-00-52. (M)SDR ASAA0540585Angle · corrodedPAE - FOUND CORROSION ON Z-ANGLE. REMOVED CORRODED Z-ANGLE, FABRICATED NEW Z-ANGLE AND INSTALLED PER B737-400 SRM 51-40-02. (M)SDR ASAA0540584Intercostal · corrodedPAE - FOUND CORROSION ON INTERCOSTAL. REMOVED DAMAGED INTERCOSTAL, FABRICATED NEW AND INSTALLED PER B737-400 SRM 51-40-02. (M)SDR ASAA0540583Web · corrodedPAE - FOUND CORROSION ON SUBTHRESHOLD WEB COMMON TO MOPSILL. REMOVED DAMAGED WEB, FABRICATED NEW WEB AND INSTALLED PER B737-400 SRM 51-40-02. (M)SDR ASAA0540582Fitting · corrodedPAE - FOUND CORROSION ON FITTING. REMOVED AND REPLACED FITTING PER B737-400 SRM 51-40-02. (M)SDR ASAA0540581Fitting · corrodedPAE - FOUND CORROSION ON FITTING. REMOVED AND REPLACED FITTING PER B737-400 SRM 51-40-02. (M)SDR ASAA0540580Skin · corrodedPAE - FOUND CORROSION ON MOUNTING AREA AROUND MARKER BEACON. REMOVED AND REPLACED SKIN PANEL AT MARKER BEACON PER B737-400 SRM 51-40-02. (M)SDR ASAA0540579Frame · corrodedPAE - FOUND CORROSION ON FRAME. REMOVED DAMAGED SECTION OF FRAME, FABRICATED AND INSTALLED REPAIR PARTS PER B737-400 SRM 53-00-07. (M)SDR ASAA0540578Sill · corrodedPAE - FOUND CORROSION ON MOPSILL. REMOVED AND REPLACED MOPSILL PER B737-400 SRM 51-40-52. (M)SDR ASAA0540577Seat Track · corrodedPAE - FOUND CORROSION ON SEAT TRACK. REMOVED AND REPLACED SEAT TRACK PER B737-400 SRM 51-40-52. (M)SDR ASAA0540576Fitting · corrodedPAE - FOUND FITTING CORRODED. REPLACED CORRODED FITTING PER B737-400 SRM 51-40-02. (M)SDR ASAA0540575Fitting · corrodedPAE - FOUND FITTING CORRODED. REPLACED CORRODED FITTING PER B737-400 SRM 51-40-02. (M)SDR ASAA0540574Angle · corrodedPAE - FOUND Z-ANGLE CORRODED. REPLACED CORRODED Z-ANGLE PER B737-400 SRM 51-40-02. (M)SDR ASAA0540573Sill · corrodedPAE - FOUND MOPSILL CORRODED. REPLACED MOPSILL PER B737-400 SRM 51-40-02. (M)SDR ASAA0540590Floorbeam · corrodedPAE - FOUND CORROSION ON TOP CHORD OF FLOORBEAM. REPAIRED FLOORBEAM AT BS 312 LBL 7 - RBL 8 WL 208 PER B737-400 SRM 53-00-51. (M)SDR ASAA0540589Stringer · crackedPAE - FOUND CRACK IN STRINGER 14L AT STRINGER SPLICE. REMOVED DAMAGED SECTION, FABRICATED REPAIR PARTS AND INSTALLED PER B737-400 SRM 51-40-02. (M)SDR ASAA0540588Skin · crackedPAE - BS 492.4 RBL 28 FORWARD CARGO DOOR CUTOUT FORWARD SIDE OF CLOSEOUT WEB IS CRACKED .250 INCH. REMOVED DAMAGED SECTION, FABRICATED REPAIR PARTS AND INSTALLED PER B737-400 SRM 51-70-13 FIG 1. (M)SDR ASAA0540567Angle · corrodedPAE - FOUND CORROSION ON Z-ANGLE. REPLACED Z-ANGLE PER B737-400 SRM 51-40-02. (M)SDR ASAA0540570Floor Support · corrodedPAE - FOUND CORROSION ON FLOOR SUPPORT. REPLACED FLOOR SUPPORT PER B737-400 SRM 51-40-02. (M)SDR ASAA0540569Support Angle · crackedPAE - FOUND CRACKED SUPPORT ANGLE. REPLACED SUPPORT ANGLE PER B737-400 SRM 51-40-02. (M)SDR ASAA0540565Sill · corrodedPAE - FOUND MOPSILL CORRODED. REPLACED MOPSILL PER B737-400 SRM 51-40-02. (M)SDR ASAA0540566Frame · chafedPAE - FOUND FRAME CHAFED. REPAIRED FRAME PER B737-400 SRM 51-40-02. (M)SDR ASAA0540564Stringer Clip · crackedPAE - FOUND BS 500E STRINGER 12AR AND 12BR STRINGER CLIPS CRACKED. REMOVED AND REPLACED STRINGER 12BR. STRINGER 12AR WAS NDI`D AND FOUND NOT TO BE CRACKED. (M)SDR ASAA0540563Floorbeam · gougedPAE - FOUND CORRODED FLOORBEAM. REMOVED DAMAGED SECTION OF FLOORBEAM, FABRICATED T-CHORD, REPAIR PARTS AND INSTALLED. (M)SDR ASAA0540558Floorbeam · corrodedPAE - FOUND CORROSION ON FLOORBEAM. REMOVED DAMAGED UPPER CHORD, FABRICATED NEW UPPER CHORD, REPAIR PARTS AND INSTALLED IAW 737-400 SRM 53-00-51. (M)
Back to Boeing 737-4Q8