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 ASAA0944782Wedge · chafedRT WING I/B FLAP TRAILING EDGE WEDGE HAS TWO CHAFED AREAS IN PREVIOUS REPAIRS. REMOVED DAMAGED DOUBLERS, PREPPED AREAS, FABRICATED FILLER AND DOUBLER, BONDED REPAIR IAW B737 400 SRM 51 70 10.SDR ASAA0944752Skin · wornRIGHT I/B EXHAUST GATE UPPER SKIN IS WORN BEYOND REPAIRABLE LIMITS. REPLACED RIGHT I/B EXHAUST GATE PER AMM 27 51 05.SDR ASAA0944744Seal · crackedRIGHT I/B MID FLAP SEAL PLATE ADAPTER PLATE ATTACH FASTENERS ARE LOOSE. REMOVED RIGHT I/B MID FLAP SEAL PLATE ADAPTER FOUND TO BE CRACKED, REPLACED WITH NEW PER SRM 51 40 02.SDR ASAA0944745Panel · gougedRIGHT WING O/B OF PYLON FAIRING T/E DOGHOUSE HAS DEEP GOUGE AND CHAFING. FABRICATED A REPLACEMENT PANEL AND INSTALLED PER SRM 51 10 02.SDR ASAA0944742Seat Track · damagedNUMEROUS AREAS OF CORROSION AND OR MECHANICAL DAMAGE TO SEAT TRACK SEGMENT BS 727B-907 RBL 24. REMOVED AND REPLACED SEAT TRACK.SDR ASAA0944723Floor Panel · dentedNR 4 FLOOR PANEL IS DENTED FWD CARGO BAY. REMOVED AND REPLACED FLOOR PANEL.SDR ASAA0944733Stringer Clip · corrodedCORROSION ON STRINGER CLIP BS 867 S26L. REMOVED AND REPLACED STRINGER CLIP PER SRM 51-40-02.SDR ASAA0944731Strap · corrodedCORROSION ON STRAP. REMOVED AND REPLACED STRAP PER SRM 53-60-51.SDR ASAA0944721Support Angle · corrodedCORROSION ON ZEE ANGLE BS 727 727C RBL 20. REPLACED FLOOR TO SIDEWALL SUPPORT ZEE ANGLE BS 727-727C RBL 20.SDR ASAA0944720Support Angle · corrodedCORROSION ON SUPPORT ZEE BS 807-847 LBL 20. REPAIRED FROM BS 798 TO BS 876.SDR ASAA0944719Support Angle · corrodedCORROSION ON SUPPORT ZEE BS 727B+8 TO BS 807. REPAIRED FROM BS 727 TO BS 798.SDR ASAA0944718Support Angle · damagedMISDRILLED HOLE IN SUPPORT ZEE. REPAIRED FROM BS 727 TO BS 727G.SDR ASAA0944831Retainer · gougedGOUGES ON RIGHT I/B LEADING EDGE NR 4 KRUEGER FLAP AFT SIDE AROUND THE THIRD FASTENER NUT FOR BLADE SEAL IS OUT OF LIMITS. REMOVED AND REPLACED SEAL RETAINER.SDR ASAA0944732Bracket · crackedNR 6 SLAT ACTUATOR LOWER ATTACH PANEL FWD BRACKET IS CRACKED. REMOVED AND REPLACED BRACKET.SDR ASAA0944710Attach Angle · crackedSEAL RIB ATTACH ANGLE O/B OF NR 3 FLAP TRACK FAIRING COMMON TO LOWER T/E COVE PANEL IS CRACKED. REMOVED AND REPLACED ANGLE.SDR ASAA0944701Stiffener · crackedSTIFFENER CRACKED AT RT WING IFOT I/B SIDE. REMOVED AND REPLACED STIFFENER.SDR ASAA0944700Stiffener · crackedLT WING AFT INBOARD NO STEP PANEL LWR SURFACE OUTBOARD STIFFENER CRACKED. REMOVED AND REPLACED STIFFENER PER SRM 51 40 02.SDR ASAA0944708Frame · damagedBS 747 RT FRAME RBL 18 23 HAS OBLONG HOLES. REMOVED DAMAGE ON FRAME BS 747 RBL 18 23 AND INSTALLED REPAIR DOUBLER.SDR ASAA0944702Support Angle · corrodedCORROSION ON ZEE SUPPORT (FLOOR TO SIDEWALL SUPPORT) AFT CARGO BAY BS 727F 747 LT. REMOVED AND REPLACED SUPPORT ZEE PER SRM 53 60 53.SDR ASAA0944709Doubler · crackedGROUND CONDITIONING AIR PANEL INTERNAL DOUBLER IS CRACKED. REMOVED AND REPLACED WITH NEW.SDR ASAA0944884Aileron · delaminatedLT AILERON LOWER I/B FORWARD CORNER DELAMINATED. REMOVED DAMAGED AREA, REPAIRED PAINTED AND BALANCED IAW B737 400 SRM 57 60 02.SDR ASAA0944840Aileron · delaminatedLT AILERON LOWER I/B FORWARD CORNER DELAMINATED. REMOVED DAMAGED AREA, REPAIRED PAINTED AND BALANCED AILERON IAW B737 400 SRM 57 60 02.SDR ASAA0944706Skin · gougedRIGHT O/B MID FLAP O/B LOWER AFT SKIN PANEL INNER SURFACE AT NR 3 AND NR 4 FLAP TRACKS. RIGHT O/B MID FLAP O/B LOWER AFT SKIN OUT OF LIMITS AT NR 3 AND NR 4 TRACK PER SRM. DAMAGE WAS REMOVED AT NR 3 TRACK 1 INCH DIAMETER .032 DEEP AT NR 4 TRACK 1 INCH DIA .0SDR ASAA0944704Skin · chafedLEFT O/B MID FLAP O/B LOWER AFT PANEL CHAFED ON INNER SURFACE AT NR 3 AND NR 4 FLAP TRACK. LEFT O/B MID FLAP O/B LWR PANEL AT NR 3 AND 4 TRACK DAMAGE OUT OF LIMIT. REMOVED DAMAGE AT NR 3 TRACK 1" X 2", .032 DEEP AT NR 4 TRACK 1 INCH DIAMETER.SDR ASAA0944705Skin · chafedLEFT O/B MID FLAP O/B LOWER AFT PANEL CHAFED ON PREVIOUS REPAIR 14 INCHES I/B OF NR 1 FLAP TRACK. LEFT O/B MID FLAP O/B LOWER AFT PANEL 14.5 INCHES O/B OF NR 1 TRACK CHAFE MEASURES .018 ORIGINAL THICKNESS .064 OUT OF LIMITS. AREA WAS REPAIRED AND REFINISHED.SDR ASAA0944692Skin · chafedRIGHT O/B MID FLAP LWR AFT SKIN UPPER SURFACE IS CHAFED AT NR 3 AFT FLAP TRACK. OUT OF LIMITS. DAMAGE WAS REMOVED 1" X 2" X .032 REPAIRED.SDR ASAA0944691Skin · chafedRIGHT O/B MID FLAP LWR AFT SKIN LWR SURFACE IS CHAFED AT NR 4 AFT FLAP TRACK. OUT OF LIMITS. DAMAGE WAS REMOVED 1" X 1.5" X .032 REPAIRED PER SRM.SDR ASAA0944690Skin · chafedRIGHT O/B MID FLAP LWR AFT SKIN LWR SURFACE IS CHAFED 13 INCHES O/B OF NR 1 AFT TRACK ON DOUBLER. REPAIRED CHAFED AREA.SDR ASAA0944693Angle · tornANGLE AT RSS 272 WBL 201 IS TORN LT WING. REPLACED ANGLE.SDR ASAA0944707Fitting · corrodedFWD ENTRY DOORWAY AFT GIRT BAR FITTING ASSY IS CORRODED. REMOVED AND REPLACED CORRODED FWD ENTRY DOORWAY AFT GIRT BAR FITTING ASSY PER SRM 51 40 02.SDR ASAA0944698Fitting · corrodedFWD ENTRY DOORWAY GIRT BAR FITTING BRACKET ASSY IS CORRODED. REPLACED FWD ENTRY DOORWAY GIRT BAR FITTING BRACKET ASSY.SDR ASAA0944673Cargo Track · corrodedAFT PIT FWD LT ANCHOR FITTING LOCKING LUGS DAMAGED ADDITION DAMAGE NOTED/CORROSION.SDR ASAA0944674Skin · damagedFUSELAGE SKIN PREVIOUSLY BLENDED AREAS OUT OF LIMITS. REMOVED DAMAGED SKIN AND INSTALLED REPAIR.SDR ASAA0944672Bear Strap · crackedHOLE CRACKED IN BEAR STRAP AT FWD ENTRY DOOR CUTOUT UPPER HINGE CUTOUT. REPAIRED BEAR STRAP.SDR ASAA0944671Bear Strap · crackedHOLE CRACKED IN BEAR STRAP AT FWD ENTRY DOOR CUTOUT LOWER HINGE CUTOUT. REPAIRED PER EA 400-53EA-0093.SDR ASAA0944703Flap Track · corrodedNR 7 FLAP TRACK CORRODED. NR 7 FLAP TRACK REMOVED AND REPLACED WITH SERVICEABLE UNIT.SDR ASAA0944647Flap Track · corrodedNR 7 FLAP TRACK CORRODED. REMOVED AND REPLACED WITH SERVICEABLE UNIT ON DEFECT.SDR ASAA0944641Web · corrodedCORROSION AFT CARGO BAY WEB IS CORRODED BETWEEN BS 767 787 RBL 22.5. REMOVED AND REPLACED AFT CARGO BAY WEB.SDR ASAA0944680Skin · dentedLT HORIZONTAL STABILIZER L/E HAS DENT WITH POSSIBLE BENT STRUCTURE AT APPROX 110 INCHES FROM O/B EDGE OF O/B LEADING EDGE. REMOVED RIB & REWORKED DENT. HFEC INSPECTION IS OK. REPAIRED L/E DENT BY INSTALLING EXTERNAL DOUBLER IAW SRM 55 10 01 REPAIR 3 EA 400 SDR ASAA0944644Spar · crackedLEFT I/B MID FLAP REAR SPAR UPPER CHORD IS CRACKED AT FOUR LOCATIONS NEAR I/B AND O/B NUT PLATE. REMOVED AND REPLACED LEFT I/B MID FLAP REAR SPAR UPPER CHORD PER DWG 65 47841 AND SRM 51 40 02.SDR ASAA0944642Seat Track · wornBS 480 RBL 62 LATERAL TRACK HAS EXTREME WEAR. REPLACED LATERAL TRACK PER SRM 51-40-02.SDR ASAA0944653Floor Support · corrodedCORROSION AT STA 747+5 RBL 3 ON FLOOR SUPPORT. CORROSION OUT OF LIMITS. REMOVED FLOOR SUPPORT BS 740 793.5 PER SRM 53-60-53. NEW FLOOR SUPPORT TO BE INSTALLED ON CUST CARD.SDR ASAA0944652Frame · corrodedBS 794 FRAME CORRODED VERT WEB DOOR SURROUND. REMOVED AND REPLACED WEB PER SRM 51-40-02 & 51-40-05 AND DWG 65-47957.SDR ASAA0944651Frame · corrodedBS 794 FRAME VERTICAL WEB CORRODED. CORROSION OUT OF LIMITS. REMOVED AND REPLACED WEB PER SRM 51-40-02 AND 53-60-15.SDR ASAA0944650Reveal · corrodedAFT CARGO BAY DOOR CUTOUT FWD REVEAL (COVER PLATE) CORRODED. REMOVED AND REPLACED FRAME UPPER COVER PLATE PER SRM 51-20-01 & 51-40-02 AND DWG 65-56655.SDR ASAA0944649Strap · corrodedSTRAP CORRODED AT AFT CARGO DOOR CUTOUT THRESHOLD. CORROSION OUT OF LIMITS. REMOVED AND REPLACED STRAP WITH FABRICATED PER SRM 51-40-02.SDR ASAA0944648Floor Support · corrodedSTA 859 RBL 3 FLOOR SUPPORT IS CORRODED AROUND NUT PLATE HOLES. REPLACED DAMAGED SECTION OF RBL 3 FLOOR SUPPORT BS 740-873.SDR ASAA0944679Snubber · wornL1 DOOR VERY HEAVY AND HARD TO OPERATE. REMOVED AND REPLACED L1 DOOR SNUBBER, OPS CHECK NORMAL.SDR ASAA0944656Splice · corrodedFLOOR PANEL NR 3 TO NR 4 SPLICE STRIP STA 787 STR 25 25 CORRODED. REMOVED AND REPLACED SPLICE STRAP.SDR ASAA0944655Floor Support · corrodedCORROSION AT STA 927G+17 RBL 3 FLOOR SUPPORT. REPLACED RBL 3 FLOOR SUPPORT BS 873 TO 947.
Back to Boeing 737-4Q8