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 ASAA0844088Cargo Track · corrodedCORROSION ON AFT CARGO TRACK BS 945 RT RBL 13. REPLACED AFT CARGO BAY FLOOR TIE DOWN TRACK FROM BS 847 945 RBL 13.SDR ASAA0844087Frame · corrodedCORROSION ON FRAME AT BS 727B LBL 15 WL 155. REPAIRED FRAME PER SRM 53-00-07 REPAIR 4SDR ASAA0844078Strap · crackedE BAY FLOORBEAM TENSION STRAP IS CRACKED BS 344 BL 0 STOPPED DRILLED CRACK AND ACCOMPLISHED REPAIR 4 PER SRM 53 10 51.SDR ASAA0944161Skin · puncturedRT IB MID FLAP TRAILING EDGE WEDGE HAS A PUNCTURE IB OF 2ND TRACK. REMOVED EXISTING DOUBLER FABBED REPAIR PARTS AND BONDED REPAIR IAW B737 400 SRM 51 70 10.SDR ASAA0944162Skin · dentedRT EXTERNAL FUSELAGE DENTED AT STA 236 BELOW AND AFT OF EXTERNAL POWER DOOR. REMOVED DAMAGED AREA FABBED REPAIR PARTS INSTALLED THE REPAIR IAW AAR EA 13108 AND ASA EA 400 53 EA 00454.SDR ASAA0944146Skin · dentedLT INBD MID FLAP T/E WEDGE LOWER SURFACE HAS MULTIPLE SHARP DENTS AT INBD CORNER AT PREVIOUS REPAIR. REMOVED PREVIOUS REPAIR FABBED REPAIR PARTS AND BONDED IAW SRM51 70 10.SDR ASAA0844096Pressure Switch · defectiveF/A REPORTED LOUD BANG AT 35000' CABIN ALTITUDE THEN SHOWED A 1000'/MIN CLIMB CABIN WENT FROM 8500' TO 11000' DURING OUR RAPID DESCENT GOT CONTROL AT APPROX 20000' IN MANUAL AC. AFTER LANDING CABIN WAS 500' BELOW SEA LEVEL. INSPECTED THE APU DUCT SEALS [KEEL SDR ASAA0844070Frame · elongatedAFT CARGO FRAME HAS 1 EA ELONGATED HOLE BS 727F LBL 22 MARKED. REPLACED BS 727F FRAME PER SRM 51-70-11, 51-30-01, 51-20-01 & 51-40-02.SDR ASAA0844071Frame · damagedAFT CARGO FRAME HAS 1 EA ELONGATED HOLE BS 787F LBL 22 MARKED. REPLACED BS 787F FRAME PER SRM 51-70-11, 51-30-01, 51-20-01, 51-40-02.SDR ASAA0844072Frame · damagedAFT CARGO FRAME HAS 1 EA ELONGATED HOLE BS 767F LBL 28 MARKED. REPLACED BS 767F FRAME PER SRM 51-70-11, 51-30-01, 51-20-01, 51-40-02.SDR ASAA0944151Skin · damagedLT DOOR UPPER AFT CORNER CURLED BACK. REMOVED DAMAGED AREA FABRICATED FILLER AND DOUBLER INSTALLED IAW SRM 52-00-01.SDR ASAA0844053Shear Web · corrodedWHILE WORKING CARD 5140578 FOUND SHEAR WEB CORRODED. STA. 787-794 WL 156 RBL 25 REPLACEDSDR ASAA0844095Skin · dentedFUSELAGE SKIN DENT AT STA 1057 ABOVE STR 24R. REMOVED DAMAGED AREA FABBED FILLER AND DOUBLER AND INSTALLED REPAIR IAW EA 13083.SDR ASAA0844062Flap System · malfunctionedDURING ARRIVAL INTO OTZ FLAPS EXTENDED TO JUST SHORT OF 10 WITH A GREEN LIGHT ON THE LEADING EDGE. FLAPS COULD NOT BE EXTENDED PAST 10 WITH NORMAL OR ALTERNATE FLAP EXTENSION. RAN APPROPRIATE CHECK LIST AND LANDED IN OTZ. RELEASED PER CDL 57 53 1 PLACARD INSSDR ASAA0844055Floorbeam · corrodedCORROSION ON AFT CARGO FLOOR BEAM. BS 795 RBL 15 RBL 19 LOWER SURFACE AT NUTPLATE HOLE. R&R SUPPORT CLIP PER SRM.SDR ASAA0844052Intercostal · corrodedCORROSION ON INTERCOSTAL WEB BETWEEN FRAMES AT BS 787-795 RBL 24. R&R INTERCOSTAL.SDR ASAA0944160Skin · puncturedRUDDER PUNCTURED RT SIDE APPROX. 16" FROM 88" FROM LOWER EDGE. PREPPED PUNCTURED AREA AND REPAIRED AREA IAW B737 400 SRM 51 70 03 REP 2.SDR ASAA0944140Skin · delaminatedLT IB MID FLAP T/E WEDGE IS DELAMINATED UPPER SURFACE CENTER. REMOVED DAMAGED AREA FABRICATED REPAIR PARTS BONDED REPAIR IAW SRM 51 70 10 REP 4.SDR ASAA0944154Skin · crackedFUSELAGE SKIN CRACKED AFT OF STA 303 BELOW LT DOOR UPPER HINGE REMOVED DAMAGED SKIN. FABRICATED INSTALLED REPLACEMENT GAP COVER IAW SRM 51 40 02.SDR ASAA0944149Doubler · puncturedLT INBD MID FLAP LOWER SURFACE PREVIOUS REPAIR DOUBLER PUNCTURED. REMOVED DAMAGED AREA FABRICATED FILLER AND DOUBLER INSTALLED IAW SRM 51 70 10.SDR ASAA0944148Skin · dentedLT NR 3 SPOILER UPPER SKIN DENTED .45 INCH DIAMETER AND .004 DEEP A/Y=112. REMOVED DAMAGED AREA FABRICATED AND INSTALLED DOUBLER IAW SRM 51 70 10.SDR ASAA0944147Skin · dentedNR 3 SPOILER UPPER SKIN HAS A CLUSTER OF DENTS 1.8 IN FWD OF T/E. REMOVED DAMAGED AREA FABRICATED FILLER AND DOUBLER BONDED REPAIR IAW SRM 51 70 10.SDR ASAA0944145Skin · dentedLT IB FORE FLAP UPPER SURFACE DENTED. REMOVED DAMAGED AREA FABRICATED FILLER AND DOUBLER BONDED REPAIR IAW SRM 51 70 10.SDR ASAA0944143Skin · dentedNR 2 SPOILER UPPER SKIN IS DENTED. PREPPED DAMAGED AREA FABRICATED DOUBLER AND BONDED REPAIR IAW SRM 51 70 10 REPAIR 2.SDR ASAA0944142Skin · chafedRT OTBD MID FLAP CHAFED ABOVE NR 7 FLAP TRACK FAIRING. REMOVED DAMAGED AREA FABRICATED REPAIR PARTS AND BONDED REPAIR IAW SRM 51 70 10.SDR ASAA0944141Skin · chafedLT OB FORE FLAP IB LEADING EDGE IS CHAFED. REMOVED DAMAGED AREA FABRICATED HEAT TREATED AND INSTALLED REPLACEMENT SKIN IAW SOPM 20 50 01.SDR ASAA0944139Skin · dentedLT IB FORE FLAP LOWER SURFACE HAS A CLUSTER OF 20 DENTS BEHIND NR 2 TIRE. REMOVED DAMAGED AREA FABRICATED FILLER AND DOUBLER BONDED REPAIR IAW SRM 51 70 10.SDR ASAA0944153Skin · dentedRT HORIZ STAB AT STA101 HAS A DENTS ON THE LEADING EDGE. REMOVED PREVIOUS REPAIR FABRICATED FILLER AND DOUBLER INSTALLED IAW SRM 55 10 01.SDR ASAA0944152Skin · dentedRT HORIZ STAB AT STA 92.7 HAS 2 DENTS ON THE LEADING EDGE. REMOVED PREVIOUS REPAIR FABRICATED FILLER AND DOUBLER INSTALLED IAW SRM 55 10 01.SDR ASAA0944179Cargo Track · corrodedCORROSION ON AFT CARGO TRACK BS 945 LBL 13. R&R CARGO TRACK.SDR ASAA0844121Nut · looseL1 DOOR WILL NOT CLOSE FOUND GUIDE ARM ROD END JAMB NUT LOOSE. SECURED LOOSE JAMB NUT. L1 DOOR OPS CHECK GOOD.SDR ASAA0944126Shear Tie · corrodedCORROSION ON SHEAR TIE AT BS 927-947 RBL 17. REMOVED AND REPLACED INTERCOSTAL.SDR ASAA0844068Support · corrodedCORROSION ON FLOOR TO SIDEWALL SUPPORT. BS 867 947 RBL 25. R&R FLOOR TO SIDEWALL SUPPORT.SDR ASAA0844023Support · corrodedCORROSION ON FLOOR TO SIDEWALL SUPPORT BS 867 947 RBL 25SDR ASAA0844015Support · corrodedCORROSION ON FLOOR TO SIDEWALL SUPPORT PLATE. REPLACE FLOOR TO SIDEWALL SUPPORT PER SRM 53-60-53 FIG 201.SDR ASAA0944228Intercostal · corrodedCORROSION ON INTERCOSTAL UPPER FLANGE BETWEEN FRAME AT BS 767 TO 787 RBL 24. R&R INTERCOSTAL BS 767 787 RBL 24.SDR ASAA0844016Support · corrodedCORROSION ON FLOOR TO SIDEWALL SUPPORT PLATE. REPLACE SUPPORT PLATE PER SRM 53-60-53.SDR ASAA0844079Cargo Track · damagedMECHANICAL DAMAGE DOUBLE HOLES ON CARGO TIE DOWN STRAP.SDR ASAA0844054Intercostal · corrodedCORROSION ON INTERCOSTAL BETWEEN FRAMES BS 747 TO BS 767 RBL 24. REPLACED INTERCOSTAL.SDR ASAA0844017Support · corrodedCORROSION ON FLOOR TO SIDEWALL SUPPORT PLATE. REPLACED SUPPORT PLATE PERRM 53-60-53 FIG 201.SDR ASAA0844036Skin · dentedRT STABILIZER LEADING EDGE SKIN HAS DENT ON STA 243 TO STA 254. REMOVED DAMAGE SECTION OF SKIN AND INSTALLED EXTERNAL DOUBLER WITH BLIND FASTENERS PER SRM 55 10 01 REPAIR 3.SDR ASAA0844110Strap · corrodedFOUND CORROSION ON LOWER STRAP BS 830-846 RBL 25. R&R STRAP.SDR ASAA0844069Strap · corrodedCORROSION ON LOWER SUPPORT STRAP BS 782 800 RBL 25 WL 155. LOWER SUPPORT STRAP WILL BE REPLACED ON CARD 5140637.SDR ASAA0844003Repair · damagedL1 DOOR AT PREVIOUS REPAIR TOP AFT CORNER OF REPAIR IS CURLED UP. REMOVED PREVIOUS REPAIR, FABRICATED AND INSTALLED NEW FILLER AND DOUBLER IAW B737 400 SRM 52 00 01.SDR ASAA0844077Support · corrodedCORROSION ON RT FLOOR TO SIDEWALL SUPPORT IN AFT CARGO BAY RBL 25 BS 727+4 BS 767 OUT OF LIMITS. REPLACED RT FLOOR TO SIDEWALL SUPPORT PER SRM 53 60 53 REPAIR 5.SDR ASAA0843999Support · corrodedCORROSION ON RT FLOOR TO SIDEWALL SUPPORT IN AFT CARGO BAY RBL 25 BS 727+4-767. REPLACED RT FLOOR TO SIDEWALL SUPPORT PER SRM 53-60-53.SDR ASAA0843998Support · corrodedCORROSION ON AFT CARGO LOWER BULKHEAD SUPPORT RBL 12 (OUT OF LIMITS). FABRICATED AND INSTALLED NEW BULKHEAD SUPPORT.SDR ASAA0944185Cargo Track · corrodedAFT CARGO COMPARTMENT CORROSION FOUND ON STRUCTURE BENEATH FLOOR PANEL AT CARGO DOOR LOWER THRESHOLD SILL AREA. R&R CARGO TIEDOWN TRACK BS 777 877 RBL 13 SRM 53 00 53.SDR ASAA0843954Skin · puncturedNR 9 SPOILER HAS A PUNCTURE ON LOWER SIDE 9 INCHES FROM INBD END. REPAIRED NR 9 SPOILER LOWER SKIN PUNCTURE IAW SRM 51-70-10 REPAIR 4.SDR ASAA0843959Guide Arm · stiffL1 DOOR HARD TO CLOSE FROM INSIDE FOUND WHILE REPOSITIONING JETWAY AFTER ARRIVAL. ADJUSTED L1 DOOR GUIDE ARM REF M/M 52-11-00-705-007-B00. OPERATED NORMALLY OK FOR SERVICE.
Back to Boeing 737-4Q8