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 ASAA1047938Shear Tie · corrodedFWD CARGO COMPARTMENT SHEAR TIE IS CORRODED O/B OF STR 26R. CUT OUT DAMAGED AREA, FABRICATED REPAIR ANGLE AND INSTALLED.SDR ASAA1047936Skin · chafedRIGHT O/B FOREFLAP LOWER LEADING SKIN IS CHAFED 6 IN FROM I/B END. REMOVED EXISTING REPAIR DOUBLER, FABRICATED NEW DOUBLER AND INSTALLED.SDR ASAA1047935Skin · damagedSCRIBE LINE AT STR 20L. FABRICATED REPAIR PARTS AND INSTALLED REPAIR.SDR ASAA1047994Frame · crackedFS 727B FRAME IS CRACKED. CUT OUT DAMAGED SECTION AND INSTALLED REPAIR.SDR ASAA1047993Frame · crackedFS 727D FRAME IS CRACKED. CUT OUT DAMAGED SECTION AND INSTALLED REPAIR.SDR ASAA1047992Frame · crackedFS 727F FRAME IS CRACKED. CUT OUT DAMAGED SECTION AND INSTALLED REPAIR.SDR ASAA1047990Frame · crackedFS 747 FRAME IS CRACKED. CUT OUT DAMAGED SECTION AND INSTALLED REPAIR.SDR ASAA1047989Frame · crackedFS 787 FRAME IS CRACKED. CUT OUT DAMAGED SECTION AND INSTALLED REPAIR.SDR ASAA1047988Frame · crackedFS 827 FRAME IS CRACKED. CUT OUT DAMAGED SECTION AND INSTALLED REPAIR.SDR ASAA1047986Frame · crackedFS 867 FRAME IS CRACKED. CUT OUT DAMAGED SECTION AND INSTALLED REPAIR.SDR ASAA1047984Frame · crackedFS 907 FRAME IS CRACKED. CUT OUT DAMAGED SECTION AND INSTALLED REPAIR.SDR ASAA1047982Failsafe · corrodedAFT CARGO COMPT FAIL SAFE ON FRAME FS 747 CORRODED. INSTALLED REPAIR ANGLE.SDR ASAA1047981Frame · crackedSTA 727D FRAME IS CRACKED. CUT OUT DAMAGE AND INSTALLED REPAIR.SDR ASAA1047980Frame · crackedSTA 727F FRAME IS CRACKED. CUT OUT DAMAGE AND INSTALLED REPAIR.SDR ASAA1047979Frame · crackedSTA 747 FRAME IS CRACKED. CUT OUT DAMAGE AND INSTALLED REPAIR.SDR ASAA1047977Frame · crackedSTA 787 FRAME IS CRACKED. CUT OUT DAMAGE AND INSTALLED REPAIR.SDR ASAA1047976Frame · crackedSTA 827 FRAME IS CRACKED. CUT OUT DAMAGE AND INSTALLED REPAIR.SDR ASAA1047974Stringer · gougedFWD CARGO COMPARTMENT STRINGER 22L IS GOUGED. REPAIRED STRINGER.SDR ASAA1047952Floorbeam · corrodedAFT CABIN FLOORBEAMS HAS CORROSION IN SEVERAL PLACES. REMOVED DAMAGED AREA INSTALLED REPAIR.SDR ASAA1047951Frame · crackedFRAME AT STA 867 IS CRACKED. REMOVED DAMAGED AREA, INSTALLED REPAIR.SDR ASAA1047950Frame · crackedFRAME AT STA 907 IS CRACKED. REMOVED DAMAGED AREA, INSTALLED REPAIR.SDR ASAA1047949Frame · crackedFRAME AT STA 727B IS CRACKED. REMOVED DAMAGED AREA, INSTALLED REPAIR.SDR ASAA1047940Cusp Web · corrodedAFT CABIN RT CUSP WEB IS CORRODED. REMOVED AND REPLACED CUSP WEB.SDR ASAA1047971Skin · dentedLEFT HORIZ STAB L/E DENTED OUT OF LIMITS. REMOVED DAMAGED AREA, INSTALLED NEW SECTION.SDR ASAA1047941Skin · chafedLEFT O/B MIDFLAP RUB STRIP WORN THROUGH JUST O/B OF I/B CARRIAGE FITTING. REMOVED DAMAGED SKIN AND INSTALLED REPAIR.SDR ASAA1047972Skin · dentedLEFT I/B AFT FORE FLAP LOWER SURFACE REPAIR DOUBLER DENTED. REMOVED DAMAGED DOUBLER, INSTALLED NEW.SDR ASAA1047968Skin Panel · damagedRT WING NR 7 SPOILER PANEL LOWER SURFACE HAS CREASE AT I/B CORNER. REMOVED DAMAGED AREA, INSTALLED REPAIR PARTS.SDR ASAA1047934Wedge · damagedNR 4 SLAT T/E WEDGE I/B END IS DAMAGED. REMOVED DAMAGED AREA, FABBED REPAIR PARTS FILLER AND DOUBLER AND BONDED.SDR ASAA1047722Skin · crackedCRACK ON FUSELAGE SKIN 2 INCHES AFT OF BS 727D BELOW STR 23L. REPAIRED CRACK 2 INCHES AFT OF BS 727D BELOW STR 23L.SDR ASAA1047710Guide Arm · lack of lubeL2 DOOR DIFFICULT TO OPEN/CLOSE CATCHES. LUBRICATED GUIDE ARM ATTACH POINTS AND OPERATED DOOR. OBSERVED NORMAL OP'S DOOR FIT AND LIGHTS AGREED WITH HANDLE POSITION. OK FOR SERVICE. REF M/M 52 13 00 705 003.SDR ASAA1047676Skin · crackedLEFT WING L/E SKIN CRACKED AT I/B CORNER OF NR 1 K-FLAP O/B SPRING DOOR CUTOUT. REPAIRED L/E SKIN AT I/B CORNER OF NR 1 K-FLAP O/B SPRING DOOR CUTOUT.SDR ASAA1047693Skin · crackedAC GROUND PACK RECEPTACLE DOOR POSSIBLE CRACK ON FUSELAGE SKIN ALONG DOOR CUTOUT.SDR ASAA1047612Skin · crackedFUSELAGE SKIN HAS A CRACK IN SKIN BS 727D STR 10L.SDR ASAA1047683Attach Fitting · crackedSTRINGER 11L INTERCOSTAL WEB AFT ATTACH CLIP IS CRACKED AT RADIUS AT BS 360. REMOVED CRACKED CLIP INSTALLED NEW CLIP.SDR ASAA1047682Attach Fitting · crackedSTRINGER 8L INTERCOSTAL WEB AFT ATTACH CLIP IS CRACKED AT RIVET HOLE AT BS 360. REMOVED CRACKED CLIP INSTALLED NEW CLIP.SDR ASAA1047601Attach Fitting · crackedSTRINGER 8L INTERCOSTAL WEB AFT ATTACH CLIP IS CRACKED AT RIVET HOLE AT BS 360.SDR ASAA1047600Intercostal · crackedSTRINGER 11L INTERCOSTAL WEB AFT ATTACH CLIP IS CRACKED AT RADIUS AT BS 360.SDR ASAA1047599Pan · crackedAFT ENTRY DOOR LINER LOWER ATTACH PAN IS CRACKED. REMOVED AND REPLACED DOOR LINER LOWER ATTACH PAN PER AMM 52-13-61.SDR ASAA1047598Door Frame · crackedFWD CARGO DOORWAY FWD FRAME IS CRACKED AT 25R LOWER DOOR STOP. REMOVED CRACKED FRAME AND INSTALLED NEW FRAME.SDR BJNA100302Wire · brokenOVERWING EMERGENCY EXIT SIGN INOPERATIVE. FOUND WIRE PULLED OUT OF TERMINAL END R & R TERMINAL. OPS CHECK GOOD.SDR BJNA100301Flashlight · inoperativeFWD EMERGENCY FLASHLIGHT INOPERATIVE. REMOVED AND REPLACED FWD EMERGENCY FLASHLIGHT. OPS CHECK GOOD.SDR ASAA1149854Support Fitting · gougedAFT PRESSURE BULKHEAD SUPPORT FITTING BOLT HOLE IS GOUGED AT BOLT 81L. REMOVED AND REPLACED AFT PRESSURE BULKHEAD FITTING IAW B737 400 SRM 51 40 02 AND 51 40 05.SDR ASAA1047267Clamp · out of positionDURING PREFLIGHT/BOARDING ALT COOLING FAN LIGHT ON. NORMAL SUPPLY FAN C/B OUT NO HISTORY ATTEMPTED RESET PER GPM 05 00 91. SMOKE / WIRING FIRE IN COCKPIT OVERHEAD BEHIND OVERSER'S GASPER AIR VENT. SHUT OFF ELECTRIC POWER AND EXTINGUISHED WITH HALON. FOUND SDR ASAA1047237Skin · delaminatedNR 4 SLAT T/E OUTBOARD END UPPER SURFACE DELAMINATED. REPAIRED DELAMINATION ON OUTBOARD SURFACE.SDR ASAA1047247Cusp Web · corrodedRIGHT CUSP WEB AT STA 787 - 807 HAS CORROSION. REMOVED CORRODED WEB SECTION, FABBED DOUBLER AND FILLER AND INSTALLED REPAIR PARTS.SDR ASAA1047244Cusp Web · corrodedLEFT CUSP WEB AT STA 727G - 747 HAS CORROSION IN IT. REMOVED CORRODED CUSP WEB, FABBED REPLACEMENT WEB AND INSTALLED.SDR ASAA1047243Intercostal · corrodedINTERCOSTAL CORRODED AFT CARGO COMPARTMENT. REMOVED AND REPLACED INTERCOSTAL.SDR ASAA1047242Intercostal · corrodedINTERCOSTAL CORRODED AFT CARGO COMPARTMENT BS 727A - 727B BETWEEN STRINGER 26R - 27R. REMOVED AND REPLACED WITH NEW.SDR ASAA1047241Cusp Web · corrodedLEFT CUSP WEB AT STA 867 - 887 HAS CORROSION. REMOVED CUP WEB, FABBED REPAIR PART AND INSTALLED.SDR ASAA1047203Intercostal · crackedINTERCOSTAL CORRODED AT CARGO COMPARTMENT BS 727A - 727B BETWEEN STRINGER 26R - 27R. DURING DAMAGE REMOVAL FOUND CRACK IN RADIUS. REMOVED DAMAGED INTERCOSTAL AND REPLACED WITH NEW.
Back to Boeing 737-4Q8