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 ASAA0945356Support Bracket · damagedLT RAM AIR INLET DUCT UPPER AFT O/B SUPPORT BRACKET HAS ELONGATED HOLES. REMOVED AND REPLACED SUPPORT BRACKET.SDR ASAA0945355Strap · damagedFWD CARGO BAY DRILL STARTS ON STRAP. REPLACED 121 STRAP WITH FABRICATED STRAP.SDR ASAA0945354Stringer Clip · crackedSTRINGER CLIP CRACKED BS 706 STR 11R. REMOVED AND REPLACED STRINGER CLIP.SDR ASAA0945353Stringer Clip · crackedSTRINGER CLIP CRACKED BS 706 STR 11L. REMOVED AND REPLACED STRINGER CLIP.SDR ASAA0945352Torque Box · corrodedAPU RT TORQUE BOX HAS CORROSION AROUND THE INLET DUCT MOUNTING AREA I/B AND O/B SIDES. REMOVED AND REPLACED VERTICAL STIFFNER ON THE APU RT TORQUE BOX IAW SRM 51-40-02.SDR ASAA0945351Frame · damagedDRILL START ON FRAME DOUBLER. REMOVED DRILL START ON BS 500A DOUBLER FWD FACE.SDR ASAA0945350Frame · damagedDAMAGED EDGE OF FRAME FLANGE. REMOVED DAMAGED.SDR ASAA0945349Angle · corrodedCORROSION FCB AFT BULKHEAD LWR ANGLE IS CORRODED BS 500G LBL 24-RBL 24 WL 156. REMOVED AND REPLACED ANGLE.SDR ASAA0945348Strap · corrodedAFT CARGO DOOR CUTOUT STRAP CORRODED ON UPPER SURFACE. REMOVED, FABRICATED AND REPLACED TO CD CUTOUT STRAP PER SRM.SDR ASAA0945347Frame · damagedFORWARD CARGO BAY BS 440 FRAME UPPER SURFACE HAS DAMAGE IN RADIUS. REMOVED AND REPLACED FRAME PER DWG 65-20727.SDR ASAA0945346Attach Angle · crackedCRACK AT AFT FASTENER HOLE FOR RAM AIR ATTACH ANGLE. REMOVED DAMAGED SECTION OF ANGLE, FABRICATED REPAIR PARTS AND INSTALLED.SDR ASAA0945397Floor Support · corrodedAFT CARGO COMPARTMENT FLOOR SUPPORT CORRODED.SDR ASAA0945345Skin · gougedFCB FUSE SKIN GOUGED BS 500+8 BETWEEN STR 24-25R. REMOVED DAMAGED SKIN FABRICATED REPAIR PARTS AND INSTALLED.SDR ASAA0945344Support · corrodedAFT CARGO COMPARTMENT BS 727G+6 TO 827+6 LBL 20 WL 154 FLOOR TO SIDEWALL SUPPORT CORRODED. REMOVED AND REPLACED SUPPORT ZEE.SDR ASAA0945343Support Channel · corrodedAFT CARGO COMPARTMENT BS 727D+11 LBL 1 TO RBL 1 WL 148 CORROSION ON ANTENNA SUPPORT CHANNEL. REMOVED AND REPLACED.SDR ASAA0945342Floor Support · corrodedAFT CARGO COMPARTMENT FLOOR SUPPORT CORRODED.SDR ASAA0945341Floor Support · damaged5 DRILL STARTS ON EDGE OF FLOOR SUPPORT. REMOVED FLOOR SUPPORT FABRICATED NEW SUPPORT AND INSTALLED.SDR ASAA0945340Stringer Clip · crackedSTRINGER CLIP CRACKED IN AFT CARGO COMPARTMENT. REMOVED AND REPLACED STRINGER CLIP.SDR ASAA0945339Cargo Track · corrodedAFT CARGO COMP BS 794 STR 24L CARGO TIE DOWN IS CORRODED. REPLACED TIE DOWN PLATES PER SRM.SDR ASAA0945338Floor Support · damagedAFT CARGO COMP BS 799-804 RBL 8 WL 154 3 DRILLED HOLES IN FLOOR SUPPORT. REPAIRED IN ACCORDANCE WITH SRM.SDR ASAA0945304Stringer · dentedFWD CARGO BAY STR 22R BENT BS 394 ON UPPER I/B FLANGE. REMOVED DAMAGED STRINGER, FABRICATED REPAIR PARTS.SDR ASAA0945303Frame · dentedAFT CARGO COMPARTMENT BS 827 FRAME DENTED 2 INCHES ABOVE STR 24L.SDR ASAA0945302Frame · dentedAFT CARGO COMPARTMENT BS 747 FRAME DENTED 2 INCHES ABOVE STR 25L. REMOVED DAMAGED SECTION OF FRAME FABRICATED REPAIR PARTS AND INSTALLED.SDR ASAA0945301Frame · dentedAFT CARGO COMP BS 767 FRAME DENTED 1 INCH ABOVE STR 24R. REMOVED DAMAGED SECTION OF FRAME FABRICATED REPAIR PARTS AND INSTALLED.SDR ASAA0945298Support Angle · chafedLEFT PYLON I/B MID FLAP SPRING DOOR CUTOUT LOWER EDGE SUPPORT ANGLE AT AFT END HAS CHAFING DAMAGE. REMOVED DAMAGED STIFFENER AND INSTALLED NEW STIFFENER.SDR ASAA0945297Support · corrodedCORROSION FCB FLOOR TO SIDEWALL SUPPORT BS 500B+5-500D+10 WL 156 LBL 23-25. REMOVED AND REPLACED FLOOR TO SIDEWALL SUPPORT.SDR ASAA0945296Support · corrodedCORROSION FCB FLOOR TO SIDEWALL SUPPORT AT NUT PLATE HOLES BS 380-420 WL 156 LBL 23-25. REMOVED AND REPLACED SUPPORT ZEE.SDR ASAA0945295Support · corrodedCORROSION FCB FLOOR TO SIDEWALL SUPPORT BS 500G-500D+10 WL 156 LBL 23-25. REMOVED AND REPLACED SIDEWALL SUPPORT.SDR ASAA0945291Support · corrodedCORROSION FCB FLOOR TO SIDEWALL SUPPORT CORRODED AT NUT PLATE HOLES BS 380-500B+5 LBL 24 WL 156. REMOVED AND REPLACED SIDEWALL SUPPORT.SDR ASAA0945285Crease Beam · corrodedCREASE BEAM WEB CORRODED. REPLACED WEB WITH FABRICATED CREASE BEAM WEB.SDR ASAA0945275Intercostal · crackedINTERCOSTAL IS CRACKED AT 278 STR 14R. REMOVED AND REPLACED DAMAGED FRAME SECTION PER REPAIR.SDR ASAA0945366Switch · failedREPORTED EMERGENCY LIGHTS WILL NOT SHUTOFF WITH SWITCH IN OFF POSITION FROM "ARM" IN FLT DECK. SUSPECT BAD OVERHEAD SWITCH. COULD DUPLICATE. REMOVED AND REPLACED OVERHEAD EMERGENCY LIGHTS SWITCH S7 REF WDM 33 51 11. OPS NORMAL REF MM 33 51 02.SDR ASAA0945272Stringer Clip · crackedSTRINGER CLIP CRACKED. REMOVED AND REPLACED STRINGER CLIP.SDR ASAA0945274Stringer Clip · crackedSTRINGER CLIP CRACKED. REMOVED AND REPLACED STRINGER CLIP.SDR ASAA0945273Stringer Clip · crackedSTRINGER CLIP CRACKED. REMOVED AND REPLACED STRINGER CLIP.SDR UALA2009042701213Skin Panel · chafedRIGHT O/B MID FLAP LOWER AFT I/B SKIN PANEL IS CHAFED ON LOWER SURFACE 48 INCHES FROM I/B END OF PANEL ON PREVIOUS REPAIR DOUBLER. RIGHT I/B MID FLAP LOWER AFT SKIN WAS REPAIRED PER SRM 51-70-10.SDR ASAA0945277Bracket · crackedNR 6 FLAP TRANSMISSION O/B TORQUE TUBE DOGHOUSE LOWER I/B BRACKET. REPLACED CRACKED BRACKET.SDR ASAA0945270Skin Panel · chafedRIGHT O/B MID FLAP LOWER AFT I/B SKIN PANEL IS CHAFED ON LOWER SURFACE 48 INCHES FROM I/B END OF PANEL ON PREVIOUS REPAIR DOUBLER. RIGHT I/B MID FLAP LOWER AFT SKIN WAS REPAIRED PER SRM 51-70-10.SDR ASAA0945269Skin Panel · chafedRIGHT O/B MID FLAP LOWER AFT I/B SKIN PANEL IS CHAFED ON LOWER SURFACE 33 INCHES FROM I/B END OF PANEL ON PREVIOUS REPAIR DOUBLER. RIGHT O/B MID FLAP LWR AFT SKIN WAS REPAIRED PER SRM 51-70-10.SDR ASAA0945278Floor Panel · puncturedAFT CARGO BAY FLOOR PANEL IS PUNCTURED. REMOVED AND REPLACED FLOOR PANEL.SDR ASAA0945300Reinforcement · gougedDRILL MARKS ON FRAME REINFORCEMENT CHORD. FAB NEW FRAME MATERIAL TREATED DRILLED AND LOCATED ALODINE AND PRIME.SDR ASAA0945299Web · damagedFWD CARGO BAY DOOR CUTOUT WEB DAMAGED. REMOVED AND REPLACED WEB.SDR ASAA0945281Support · corrodedAFT CARGO COMP BS 727O+10 727G+6 LBL20 WL 154 FLOOR TO SIDEWALL SUPPORT HAS AREAS OF CORROSION. REMOVED AND REPLACED SUPPORT ZEE.SDR ASAA0945280Support · corrodedAFT CARGO COMP BS 727E STR 23R 25R SIDEWALL SUPPORT HAS AREAS OF CORROSION AT FASTENER HOLES. REMOVED DAMAGED SUPPORT FABRICATED NEW PART AND INSTALLED.SDR ASAA0945279Support · corrodedAFT CARGO COMP BS 727 727D+10 LBL 20 WL 154 FLOOR TO SIDEWALL SUPPORT HAS AREAS OF CORROSION. REMOVED AND REPLACED SUPPORT ZEE.SDR ASAA0945276Floor Support · corrodedAFT CARGO COMP BS 727E+10 767 RBL 20 WL 154 FLOOR TO SIDEWALL SUPPORT HAS AREAS OF CORROSION. REMOVED AND REPLACED SIDEWALL SUPPORT.SDR ASAA0945271Stringer Clip · crackedSTRINGER CLIP CRACKED STA 907 STR 8R. REMOVED AND REPLACED STR CLIP.SDR ASAA0945282Stringer Clip · crackedCRACKED STRINGER CLIP STA 727B STR 4L. REMOVED AND REPLACED STRINGER CLIP.SDR ASAA0945306Skin · crackedLT HORZ STAB LWR SKIN CRACKED (NDI VERIFIED 2 INCH CRACK) STAB STA 125 REAR SPAR AREA. REPAIRED IAW EA 400-55EA-01247.SDR ASAA0945305Stringer · dentedSTRINGER DENTED. REMOVED DAMAGE, FABRICATED REPAIR PARTS AND INSTALLED.
Back to Boeing 737-4Q8