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 ASAA0946624Oven · malfunctionedFLT ATTENDANTTS REPORTED AFT GALLEY OVEN 4 13 (BIG OVEN) BEGAN SMOKING APPROX 2 MINS AFTER APPLYING POWER. TURNED OVEN OFF. OVEN DOOR CONTINUED TO GET HOTTER. SMELL OF ELECTRICAL WIRES. SMOKE COMING OUT OF VENTS ABOVE OVEN. COULD NOT PULL CB'S IN AFT GALLSDR ASAA0946593Support · damagedELONGATED HOLE IN AFT FAIRING SUPPORT LEFT SIDE. REPLACED ATTACHED SUPPORT.SDR ASAA0946528Support Angle · damagedLEFT WING TO BODY STRUCTURE HAS ELONGATED HOLE COMMON TO LOWER SUPPORT ANGLE HOLE. REPAIRED PER EA.SDR ASAA0946530Support · chafedLEFT WING AFT NR 1 PYLON LWR DRAIN INNER SUPPORT FOR DRAIN HAS FASTENERS CHAFED THROUGH INNER STRUCTURE. REPAIRED PER EA.SDR ASAA0946529Cargo Track · corrodedCORROSION ON CARGO TRACK BS 940 LBL 17 WL 156. REMOVED CARGO TRACK FABRICATED NEW TRACK AND INSTALLEDSDR ASAA0946555Hydraulic Line · damagedAT FL 370 ENG 2 SYSTEM B LOW PRESSURE LIGHT ILLUMINATED. HYD B SYSTEM SHOWED 40 PERCENT THEN DROPPED TO 1 PERCENT. ELEC B LIGHT ILLUMINATED ALONG WITH FEEL DIFFERENTIAL PRESSURE LOSS OF SYS B. REPLACED HYDRAULIC LINE AND HOSE. OP AND LEAK CHECK GOOD.SDR ASAA0946509Support Angle · crackedSUPPORT ANGLE IS CRACKED T/E LEFT WING WBL 204. REPLACED SUPPORT ANGLE.SDR ASAA0946502Skin · chafedRIGHT WING O/B FORE FLAP L/E SKIN I/B EDGE TO 1.25 INCHES AND 7.5 INCHES FROM LWR AFT EDGE OF BULLNOSE THERE IS A CHAFED AREA. REPAIRED RIGHT WING OB FORE FLAP LE SKIN I/B EDGE TO 1.25 INCHES AND 7.5 INCHES FROM LWR AFT EDGE OF BULLNOSE.SDR ASAA0946501Skin · chafedLEFT WING O/B FORE FLAP L/E SKIN I/B EDGE TO 15 INCHES AND 7.5 INCHES FROM LWR AFT EDGE OF BULLNOSE THERE IS A CHAFED AREA. REPAIRED LT WING O/B FORE FLAP L/E SKIN O/B EDGE TO 15 INCHES AND 7.5 INCHES FROM LWR AFT EDGE OF BULLNOSE.SDR ASAA0946500Skin · chafedLEFT WING O/B FORE FLAP L/E SKIN O/B EDGE TO 1.75 AND 3 INCHES FROM LWR AFT EDGE OF BULLNOSE THERE IS A CHAFED AREA. REPAIRED LT WING O/B FORE FLAP L/E SKIN O/B EDGE TO 1.75 AND 3 INCHES FROM LWR AFT EDGE OF BULLNOSE.SDR ASAA0946499Panel · dentedRIGHT WING I/B MAIN FLAP T/E PANEL HAS 2 DENTS THAT ARE OUT OF LIMITS ON THE LOWER SURFACE. REPAIRED DENTS.SDR ASAA0946479Bear Strap · crackedBEAR STRAP CRACKED AT FWD ENTRY DOOR LOWER HINGE CUTOUT. TRIMMED OUT CRACK, REPAIRED AREA PER ER 09-4345 & EA 400-53EA-02133.SDR ASAA0946478Skin · dentedDENT IN FUSELAGE SKIN AT A PREVIOUS REPAIR. REMOVED PREVIOUS REPAIRS AND REPAIRED.SDR ASAA0946466Skin · delaminatedLEFT I/B FORE FLAP T/E WEDGE LOWER SKIN IS DENTED AND DELAMINATED 28 INCHES FROM O/B END, 9 INCHES FROM T/E. REPAIRED SKIN.SDR ASAA0946465Skin Panel · chafedLEFT O/B MID FLAP LOWER AFT PANEL UPPER SURFACE ADJACENT TO THE O/B AFT FLAP TRACK IS CHAFED. REPAIRED PER SRM.SDR ASAA0946464Wedge · delaminatedNR 5 T/E WEDGE IS DELAMINATED 2 INCHES FROM I/B END UPPER SURFACE ON PREVIOUS REPAIR. REPAIRED NR 5 SLAT T/E WEDGE PER SRM 57-43-02.SDR ASAA0946463Skin · chafedLEFT O/B FORE FLAP UPPER SKIN 9 INCHES, 2 INCHES FROM I/B. 4.5 INCHES FROM T/E IS CHAFED AT PREVIOUS REPAIR. REPAIRED FLAP SKIN.SDR ASAA0946462Skin · delaminatedLEFT O/B FORE FLAP LOWER SKIN 1.5 INCHES, 2 INCHES FROM TRAILING EDGE, 2 3 INCHES FROM I/B EDGE IS A DELAMINATED AREA. REPAIRED FLAP SKIN.SDR ASAA0946461Skin · dentedLEFT O/B FORE FLAP LOWER SKIN 20 INCHES FROM I/B EDGE 2 INCHES FROM AFT EDGE IS DENTED. REPAIRED IAW SRM.SDR ASAA0946409Flap Track · corrodedNR 8 FLAP TRACK AFT ATTACH POINT RUSTY AT SHIMS. REMOVED AND REPLACED THE NR 8 FLAP TRACK.SDR ASAA0946410Flap Track · corrodedNR 6 FLAP TRACK IS CORRODED ON BEARING WEAR SURFACES. REMOVED AND REPLACED NR 6 FLAP TRACK.SDR ASAA0946408Flap Track · corrodedNR 1 FLAP TRACK AT AFT O/B MOUNT BOLT HAS EVIDENCE OF CORROSION. REMOVED AND REPLACED NR 1 FLAP TRACK.SDR ASAA0946407Flap Track · corrodedNR 2 FLAP TRACK HAS EVIDENCE OF CORROSION ON ALL ROLLER SURFACES. REMOVED AND REPLACED NR 2 FLAP TRACK.SDR ASAA0946411Skin · gougedNR 1 PYLON PANEL 5727L CUTOUT SKIN FWD EDGE IS GOUGED FROM PANEL. BLENDED AREA, FOUND OUT OF LIMITS. ACCOMPLISHED REPAIR TO THE NR 1 ENG PYLON PANEL CUTOUT.SDR ASAA0946369Skin · delaminatedRIGHT O/B FORE FLAP TRAILING EDGE UPPER SURFACE IS DELAMINATED. REPLACED O/B FORE FLAP.SDR ASAA0946368Support Bracket · crackedFWD ENTRY DOOR LWR FWD LINER SUPPORT BRACKET IS CRACKED AT STOP PIN FITTING. REMOVED AND REPLACED FWD ENTRY DOOR FWD LINER SUPPORT BRACKET.SDR ASAA0946367Support Bracket · crackedFWD ENTRY DOOR LWR AFT LINER SUPPORT BRACKET IS CRACKED AT STOP PIN FITTING. REMOVED AND REPLACED FWD ENTRY DOOR AFT LINER SUPPORT BRACKET.SDR ASAA0946359Skin · gougedLEFT WING LOWER SURFACE TRAILING EDGE PANEL JUST OUTBOARD OF THE NR 3 FLAP TRACK FAIRING IS GOUGED ON INNER SURFACE OVER CONE AREA. REPAIRED GOUGE ON INNER SURFACE OVER CONE AREA ON LEFT WING LOWER SURFACE TRAILING EDGE JUST OUTBOARD OF THE NR 3 FLAP TRACK FASDR ASAA0946351Housing · crackedHORIZONTAL STAB FWD MECHANISM CRACKED LOWER FLANGED. REMOVED AND REPLACED HOUSING.SDR ASAA0946349Support Angle · chafedAPU COMPARTMENT DOOR LATCH FWD HOLE CHAFED. REPAIRED APU COMPARTMENT DOOR LATCH FWD STRUCTURE SUPPORT ANGLE FOUND OUT OF LIMITS.SDR ASAA0946346Skin · chafedRIGHT O/B FORE FLAP I/B LEADING EDGE IS CHAFED. REPAIRED IAW SRM.SDR ASAA0946345Controller · malfunctionedCABIN ALTITUDE WARNING HORN SOUNDS AT CRUISE (FL330) CABIN ALT WAS 11 500FT. STANDBY MODE ARRESTED CLIMB AND REDUCED CABIN ALT TO JUST BELOW 10 000FT. PERFORMED DECAY CK REF AMM TASK 21 00 05 782 001, OPS CHECK GOOD. REMOVED A/C POWER REF AMM 24 22 00 862 0SDR ASAA0946336Flap Track · corrodedNR 3 FLAP TRACK HAS EVIDENCE OF CORROSION ON ALL ROLLER SURFACES. REMOVED AND REPLACED NR 3 FLAP TRACK.SDR ASAA0946335Flap Track · corrodedNR 7 FLAP TRACK AFT ATTACH POINT RUSTY AT SHIMS. BOLT HOLES WERE FOUND TO BE CORRODED TRACK WAS REMOVED AND REPLACED.SDR ASAA0946315Skin · chafedCHAFING OF FUSELAGE SKIN COMMON TO DORSAL FIN BETWEEN 2L 2R BS 861 887. REPAIRED SKIN.SDR ASAA0946307Wedge · chafedRIGHT I/B MID FLAP TRAILING EDGE WEDGE I/B CONTROL ROD CUTOUT IS CHAFED. REPAIRED IAW EA.SDR ASAA0946306Wedge · chafedRIGHT I/B MID FLAP TRAILING EDGE WEDGE O/B CONTROL ROD CUTOUT IS CHAFED. REPAIRED IAW SRM.SDR ASAA0946283Frame · crackedCRACK IN FRAME I/B INNER CHORD AT FASTENER. REPAIRED FRAME IB INNER CHORD.SDR ASAA0946309Support Angle · corrodedFCB AFT BULKHEAD FLOOR TO BULKHEAD SUPPORT ANGLE ASSY IS CORRODED. REMOVED AND REPLACED AFT BULKHEAD FLOOR TO BULKHEAD SUPPORT ANGLE.SDR ASAA0946308Gate · dentedAFT ENTRY DOOR LOWER GATE DENTED ON AFT SIDE. REPLACED AED LOWER GATE.SDR ASAA0946305Channel · crackedZEE CHANNEL SHIELD IS PUNCTURED AND CRACKED. REMOVED AND REPLACED CHANNEL.SDR ASAA0946304Fitting · crackedFOUND CRACK ON AFT ENTRY DOOR SURROUND FITTING. REMOVED AND REPLACED AFT ENTRY DOOR SURROUND SEAL FITTING.SDR ASAA0946268Skin · chafedRIGHT OB AFT FLAP LEADING EDGE SKIN IS CHAFED JUST IB OF NR 1 RT OB AFT FLAP REPLACED WITH SERVICEABLE UNIT.SDR ASAA0946269Beam · damagedFWD ENTRY DOOR BEAM LOWER GATE STOP DRILL FOR CRACK LEFT NO EDGE MARGIN TO FASTENER HOLE COMMON TO STOP FITTING. REMOVED DAMAGE FROM LOWER BEAM, INSTALLED REPAIR ANGLES.SDR ASAA0946267Intercostal · crackedUPPER ANGLE OF INTERCOSTAL IS CRACKED AT FASTENER HOLES. REMOVED AND REPLACED UPPER ANGLESDR ASAA0946256Seat Track · corrodedSEAT TRACK CORRODED. REPAIRED SEAT TRACK.SDR ASAA0946255Skin · wornNR 2 SLAT T/E WEDGE WORN THROUGH LOWER SKIN I/B END. REPAIRED NR 2 SLAT T/E WEDGE ON I/B END LOWER SURFACE.SDR ASAA0946249Doubler · chafedNR 3 SLAT T/E WEDGE PREVIOUS REPAIR AT I/B END IS CHAFED. REPAIRED NR 3 SLAT T/E WEDGE AT I/B END.SDR ASAA0946229Seat Track · corrodedSEAT TRACK CORRODED BS 346 AND 351 LBL 24 WL 208. REPLACED SEAT TRACK.SDR ASAA0946228Sill · corrodedMOPSILL CORRODED BS 315-340 LBL 54 WL 208. REMOVED AND REPLACED MOPSILL.
Back to Boeing 737-4Q8