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 ASAA0944224Floor Panel · corrodedFLOOR PANEL BS 775 857 AFT CARGO BAY HAS CORROSION. BLENDED CORROSION ON FLOOR PANEL BEYOND ACCEPTABLE LIMITS. R&R FLOOR PANEL.SDR ASAA0944180Hinge Fitting · crackedFORWARD ENTRY DOOR UPPER HINGE FITTING CRACKED. R&R HINGE FITTING.SDR ASAA0944169Hinge Fitting · crackedFWD ENTRY DOOR UPPER HINGE FITTING CRACKED. R&R HINGE FITTING.SDR ASAA0944174Floor Panel · corrodedAFT CARGO BAY FLOOR PANEL BS 727+4 TO 727D IS CORRODED. REPLACED FLOOR PANEL.SDR ASAA0944173Floor Panel · corrodedAFT CARGO BAY FLOOR PANEL BS 772 TO 859 IS CORRODED. FABRICATED PANEL ALADINED AND PRIMED.SDR ASAA0944172Floor Panel · corrodedAFT CARGO BAY FLOOR PANEL BS 727E TO 727G IS CORRODED. FABRICATED FLOOR BOARD AT BS 727E TO 727G.SDR ASAA0944279Skin Panel · dentedLT IB TE FLAP WEDGE PANEL HAS CLUSTERS OF DENTS ON LOWER SURFACE. REPAIRED LT IB TE FLAP WEDGE PANEL IAW B737 400 SRM 51 70 10.SDR ASAA0944258Intercostal · corrodedCORROSION ON TOP SIDE OF GALLEY MOUNT ATTACH BRACKET BETWEEN STA 360 380 RBL 12. R&R INTERCOSTAL AT RBL 10.4 STA 360 380 IAW 737 400 SRM 51 40 02.SDR ASAA0944257Shear Web · corrodedRT SHEAR WEB CORRODED STA 827 847 RBL 68 WL 208 UPPER SURFACE. REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS IAW 737 400 SRM 53 60 13 FIG 1 REPAIRED SHEAR WEB IAW 737 400 SRM 51 70 13 FIG 1.SDR ASAA0944340Frame · corrodedAFT CARGO BAY CORROSION FWD OF STA 727D BETWEEN STR 26R STR 27L. REPAIRED FRAME STA 727D BETWEEN STR 26R STR 27L IAW SRM 53-00-07 REPAIR 7/10.SDR ASAA0944336Support · corrodedAFT CARGO BAY CORRODED AFT OF STA 727D AT LBL 0. R&R NR 3 VHF ANTENNA SUPPORT IAW B737 400 SRM 51 40 02.SDR ASAA0944322Floorbeam · corrodedFLOOR BEAM AT STA 986.5 IS CORRODED ALONG TOP CHORD. REMOVED UPPER CHORD FABRICATED AND INSTALLED REPAIR UPPER CHORD SPLICE ANGLES FILLERS IAW EA 400 53EA 00557.SDR ASAA0944302Frame · crackedAFT CARGO BAY FRAME AT STA 767 CRACKED AT STR 26R. CUTOUT DAMAGED AREA AND FABRICATED AND INSTALLED REPAIR IAW B737 400 SRM 51 70 11 FIG 1.SDR ASAA0944300Sill · corrodedR2 DOOR THRESHOLD SUPPORT CORRODED JUST IB OF THRESHOLD UNDER FLOORBOARD. REMOVED CORROSION FOUND TO BE OUT OF LIMITS. R&R MOP SEAL IAW B737 400 SRM 51 40 2 SRM 51 40 5.SDR ASAA0944282Shear Tie · corrodedAFT CARGO COMPARTMENT STA 727 SHEAR TIE CORRODED BETWEEN STR 27L 27R. R&R CORRODED SHEAR TIE IN AFT CARGO COMPARTMENT STA 727G BETWEEN STR 27L 27R IAW B737 400 SRM53 00 07.SDR ASAA0944256Frame · corrodedAFT CARGO BAY CORROSION ON FRAME STA 727F AT STR 27R. REMOVED EXISTING REPAIR INSTALLED NEW FRAME REPAIR IAW 737 400 SRM 53 00 07 PG 201.SDR ASAA0944255Repair · corrodedAFT CARGO BAY CORROSION ON PREVIOUS REPAIR AT STA 747 AT STR 26R 27R.. DUE TO NO DAMAGE ON PREVIOUS REPAIR DOUBLER STA 747 AT STR 26R 27R REMOVED OLD REPAIR FABRICATED TREATED PRIMED AND INSTALLED NEW REPAIR IAW 737 400 SRM 51 40 02 53 00 07 FIG 201 REPAIR 3.SDR ASAA0944254Frame · corrodedAFT CARGO BAY CORROSION ON FRAME STA 727F AT STR 25L. REPAIRED FRAME STA 727F AT STR 25L IAW SRM 51 70 11. REMOVED CORROSION BEYOND LIMITS CUTOUT DAMAGE FABRICATED AND INSTALLED REPAIR.SDR ASAA0944186Strap · corrodedCORROSION ON STRAP BS 794 RBL 25 WL 25. STRAP REPLACED PER SRM 51 40 02.SDR ASAA0944337Frame · corrodedAFT CARGO BAY STA 787 SHEAR TIE CORRODED BETWEEN STR 27L AND 27R. R&R SHEAR TIE BETWEEN STR 27L AND 27R PER SRM 51-40-02 PG 4 AND SRM 53-00-07 FIG 201.SDR ASAA0944330Shear Tie · corrodedAFT CARGO COMPARTMENT STA 807 SHEAR TIE CORRODED BETWEEN 26L TO 27R. REPAIRED IAW B737 400 SRM 53 00 07 FIG 201.SDR ASAA0944323Shear Tie · corrodedSTA 887 FRAME SHEAR TIE IS CORRODED. REMOVED DAMAGED SECTION OF SHEAR TIE FRAME BOTTOM FABRICATED AND INSTALLED REPAIR SHEAR TIE IAW B737 400 SRM 53 00 07 REPAIR 10.SDR ASAA0944311Support Fitting · crackedINTERIOR FUSELAGE STA 663 STR 11L SUPPORT FITTING CRACKED AT RIVET. R&R WITH NEW SUPPORT FITTING AT STA 706 STR 12L IAW B737 400 SRM 51 40 05 51 40 02.SDR ASAA0944310Support Fitting · crackedINTERIOR FUSELAGE STA 706 STR 12L SUPPORT FITTING CRACKED AT RIVET. SUPPORT AT STA 706 STR 12L. R&R IAW SRM 51-40-05 & 51-40-02.SDR ASAA0944287Floor Support · corrodedAFT CARGO COMPARTMENT STA 775 FLOOR PANEL RAIL JUST IB OF LT CARGO TRACK CORRODED BETWEEN STR 27L. REMOVED CORRODED ANGLE, FABRICATED AND INSTALLED NEW ANGLE IAW EA 13139 AND EA 400 53EA 00518.SDR ASAA0944286Floor Support · corrodedAFT CARGO COMPARTMENT STA 775 FLOOR PANEL RAIL 2ND IB OF LT CARGO TRACK CORRODED BETWEEN STR 27L AND 26L. REMOVED CORRODED REPAIR ANGLE FABRICATED AND INSTALLED NEW ONE IAW EA 13139 AND EA #400.SDR ASAA0944280Frame · corrodedAFT CARGO COMPARTMENT LT FRAME UPPER FLANGE AT FUSELAGE STA 927 BETWEEN STR 21 22 LT CORRODED. REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS IAW B737 400 SRM 53 00 07.SDR ASAA0944260Frame · corrodedAFT CARGO COMPARTMENT FUSELAGE STA 867 FRAME SHEAR TIE CORRODED BETWEEN STR 27L 27R. REPAIRED FRAME IAW 737 400 SRM 53 00 07 FIG 201.SDR ASAA0944155Guide Arm · out of adjustL2 DOOR STICKS OPENING AND CLOSING ADJUSTED L2 DOOR GUIDE ARM REF MM 52-13-31 404 004 STEP C (6). OPS CK GOOD. LUBRICATED L2 DOOR HINGES AND GUIDE ARM ONLY. REF 12-25-11. DOOR OPERATES SMOOTH THRU OPEN AND CLOSE CYCLE.SDR ASAA0944320Skin · dentedRAMP REPORTED DENT ON RT HORIZ STAB LE STA 181. REMOVED DAMAGED AREA OF SKIN FABRICATED AND INSTALLED REPAIR SKIN SPLICE PLATE B737 400 SRM 55 10 01 REPAIR 12 FIG 204.SDR ASAA0944275Skin · chafedNR 4 SLAT UPPER TE LOWER SURFACE CHAFFED. REPAIRED NR 4 SLAT UPPER TE LOWER SURFACE DAMAGE IAW B737 400 SRM 51 70 10.SDR ASAA0944285Skin · dentedR2 SERVICE DOOR SKIN IS DENTED AFT LOWER EDGE ABOVE LOWER GATE. INSTALLED EXTERNAL DOUBLER REPAIR IAW B737 400 SRM 52 00 01 ON LOWER CORNER AFT EDGE OF R2 SERVICE DOOR.SDR ASAA0944212Intercostal · crackedFOUND INTERCOSTAL BS 227.8 235.8 STR 19L WL 201 CRACKED AT FWD HOLE. R&R INTERCOSTAL.SDR ASAA0944127Intercostal · crackedFOUND INTERCOSTAL BS 227.8 - 235.8 AT STR 19L, WL 201 CRACKED AT FWD HOLE.SDR ASAA0944329Skin · chafedNR 3 SLAT UPPER IB CORNER CHAFED. REMOVED DAMAGED AREA. PREPPED AREA FABRICATED AND INSTALLED REPAIR FILLER AND DOUBLER IAW B737 400 SRM 51 70 10 REPAIR 4.SDR ASAA0944321Flap Track · corrodedLT NR 1 FLAP TRACK RUSTED. R&R NR 1 FLAP TRACK B737 400 AMM 27 51 49.SDR ASAA0944308Failsafe · corrodedFAIL SAFE ANGLE HAS CORROSION AT STR 28R. REMOVED CORRODED FAIL SAFE ANGLE IAW SRM 51-40-02 FIG 8. INSTALLED NEW FAIL SAFE ANGLE IAW B737 400 SRM 51 40 02.SDR ASAA0944259Fitting · corrodedR2 DOOR CORROSION ON DOOR SURROUND FWD LIP FROM UPPER LATCH FITTING TOO UPPER HINGE. R2 PRESSURE SEAL LANDING AT DOOR CUTOUT. R&R R2 DOOR FWD LIP UPPER LATCH FITTING IAW 737 400 SRM 51 40 02. ACCOMPLISHED DOORSILL LAND AREA BUILD UP RESEAL ON UPPER LATCH FISDR ASAA0944283Skin · damagedFUSELAGE SKIN CREASED RT FROM STA 360 400 ABOVE STR 20. REPAIRED SKIN FROM STA 360 400 ABOVE STR 20 IAW ASA EA 400 53EA 00503.SDR ASAA0944150Skin · puncturedLT INBD FORE FLAP LOWER SURFACE PUNCTURED. REMOVED DAMAGED AREA FABRICATED FILLER AND DOUBLER INSTALLED IAW SRM 51 70 10.SDR ASAA0844109Attach Bracket · corrodedINTERCOSTAL ATTACH BRACKET BS 794 RBL 6 WL 153 HAS CORROSION. R&R BRACKET.SDR ASAA0944223Skin · damagedLT WING FIXED LE HAS FIBER DAMAGE AT NR 1 SLAT IB AUX TRACK CUTOUT. REPAIRED LT WING FIXED LEADING FIBER DAMAGE AT NR 1 SLAT IB AUX TRACK CUTOUT.SDR ASAA0944181Strap · corrodedCORROSION ON FAILSAFE STRAP. REPLACED FAILSAFE STRAP.SDR ASAA0944178Doubler · corrodedCORROSION ON INTERNAL DOUBLER ON FRAME STA 794 RBL 30 WL 160. R&R INTERNAL DOUBLER PER SRM 51 40 02.SDR ASAA0944170Frame · corrodedCORROSION ON FRAME BS 794. REPLACED BS 794 IN AFT CARGO BAY.SDR ASAA0844098Skin · damagedLT WING FIXED LE HAS FIBER DAMAGE AT NR 1 SLAT I/B AUX TRACK CUTOUT.SDR ASAA0844100Doubler · corrodedCORROSION ON INTERNAL DOUBLER ON FRAME BS 794 RBL 30 WL 160.SDR ASAA0844099Frame · corrodedCORROSION ON FRAME BS 794.SDR ASAA0844097Failsafe · corrodedCORROSION ON FAILSAFE STRAP.SDR ASAA0844089Skin · crackedNR 1 SLAT LWR SKIN CRACKED I/B AUX TRACK AND 4 EA FASTENER HOLES. REPAIRED USING DOUBLER SPLICE PLATE AND FILLER PER SRM 57-43-01 FIG 201
Back to Boeing 737-4Q8