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 ASAA0945290Intercostal · crackedINTERCOSTAL CORRODED. REMOVED AND REPLACED INTERCOSTAL.SDR ASAA0945289Intercostal · crackedINTERCOSTAL CRACKED.SDR ASAA0945288Intercostal · crackedINTERCOSTAL DAMAGED. FABRICATED REPLACEMENT INTERCOSTAL AND INSTALLED.SDR ASAA0945287Intercostal · crackedINTERCOSTAL CRACKED. REMOVED AND REPLACED INTERCOSTAL.SDR ASAA0945286Intercostal · crackedINTERCOSTAL CRACKED. FABRICATED REPLACEMENT INTERCOSTAL AND INSTALLED.SDR ASAA0945284Support Angle · corrodedCORROSION ON BULKHEAD SUPPORT ANGLE. REMOVED AND REPLACED BULKHEAD SUPPORT ANGLE.SDR ASAA0945283Support · corrodedCORROSION ON SURFACE OF FLOOR TO SIDEWALL SUPPORT. REMOVED AND REPLACED FLOOR TO SIDEWALL SUPPORT.SDR ASAA0945228Web · corrodedCORROSION ON WEB BOTTOM SURFACE. REMOVED AND REPLACED WEB.SDR ASAA0945227Seat Track · corrodedCORROSION ON SEAT TRACK STA 685 RBL 45. REMOVED AND REPLACED SEAT TRACK.SDR ASAA0945226Door Frame · corrodedCORROSION ON AFT CARGO DOOR CUTOUT AFT FRAME CLOSEOUT WEB. REMOVED WE FABRICATED NEW WEB WEB TO BE INSTALLED ON MIG 5.SDR ASAA0945225Floorbeam · corrodedCORROSION ON FCB FLOORBEAM RBL 13 WL 156 BS 500F+14 AND BS 500E AT NUT PLATES. REMOVED AND REPLACED WITH NEW FLOORBEAM SECTION.SDR ASAA0945213Attach Bracket · corrodedL1 DOOR AFT GIRT BAR FITTING ATTACH BRACKET HAS CORROSION. REMOVED AND REPLACED GIRT BAR FITTING ATTACH BRACKET.SDR ASAA0945214Stringer Clip · crackedSTRINGER CLIP CRACKED. REMOVED AND REPLACED STRINGER CLIP.SDR ASAA0945220Mount · corrodedCORROSION ON GALLEY MOUNT BS 998.5 RBL 32 WL 208. MOUNT TO BE REPLACED ON NRC.SDR ASAA0945219Mount · corrodedCORROSION ON GALLEY MOUNT BS 1016 RBL 32 WL 208. REMOVED AND REPLACED.SDR ASAA0945216Mount · corrodedCORROSION ON GALLEY MOUNT BS 998.5 LBL 32 WL 208. REMOVED AND REPLACED.SDR ASAA0945222Bear Strap · crackedCRACK IN BEAR STRAP AT FASTENER HOLES AT FWD ENTRY DOOR UPPER HINGE CUTOUT. REMOVED CRACKS REPAIRED PER ASA EA 400-53EA-01453.SDR ASAA0945221Web · corrodedCORROSION ON WEB BS 986. REPLACED SHEAR WEB WITH FABRICATED WEB.SDR ASAA0945218Channel · corrodedCORROSION ON ZEE CHANNEL BS 992.5 LBL 33-43 WL 208. REMOVED CORROSION FOUND TO BE 100% MATERIAL LOSS PER SRM 51-10-02 REMOVED AND REPLACED ZEE CHANNEL PER SRM 51-40-02.SDR ASAA0945217Channel · corrodedCORROSION ON ZEE CHANNEL BS 992.5 LBL 33-43 WL 208. REMOVED AND REPLACED ZEE CHANNEL.SDR ASAA0945215Sill · corrodedCORROSION ON R2 MOPSILL SUB THRESHOLD WEB BS 952 986 AT FASTENER HOLE. REMOVED MOPSILL FABRICATED NEW MOPSILL AND INSTALLED.SDR ASAA0945212Sill · corrodedR2 MOPSILL SUB THRESHOLD WEB IS CORRODED BS 952-986.5 RBL 53. REMOVED AND REPLACED.SDR ASAA0945211Stringer · damagedDRILL START IN TOP OF STR 16L BS 603 NEXT TO HI-LOK FASTENER. REPAIRED PER EA.SDR ASAA0945207Web · gougedFWD CARGO DOOR SURROUND WEB DAMAGED GOUGED. REPLACED WEB SURROUND WEB.SDR ASAA0945203Channel · corrodedCORROSION ON ZEE CHANNEL. REMOVED AND REPLACED ZEE CHANNEL.SDR ASAA0945209Sill · damagedAFT CARGO DOOR SURROUND LOWER SILL TOP I/B EDGE HAS MECHANICAL DAMAGE AND SHARP EDGES. REMOVED AND REPLACED AFT CARGO DOOR LOWER SILL CENTER SCUFF PLATE ASSY.SDR ASAA0945208Web · corrodedCORROSION WEB BULGING AT BS 987 LBL 34-42 WL 208. REPLACED SHEAR WEB WITH FABRICATED WEB.SDR ASAA0945206Support Channel · corrodedL1 DOOR O/B THRESHOLD SUPPORT Z-CHANNEL HAS CORROSION BS 320 340 WL 208 LBL 65. REPLACED WITH NEW ZEE PER SRM.SDR ASAA0945205Channel · corrodedL1 DOOR I/B THRESHOLD SUPPORT C-CHANNEL HAS CORROSION BS 312-340 WL 208 LBL 67. REMOVED AND REPLACED C-CHANNEL.SDR ASAA0945202Web · corrodedCORROSION ON WEB AT BS 1000-1003 RBL 36-39 WL 208. WEB REPLACED.SDR ASAA0945201Bear Strap · crackedBEAR STRAP CRACKED AT FASTENER HOLE BS 304.5 WL 238. REMOVED CRACKS REPAIRED PER ASA EA 400-53EA-01453.SDR ASAA0945200Skin · damagedDENT/BULGE ON FUSELAGE EXTERNAL SKIN. CUT OUT DAMAGED SKIN ACCOMPLISHED FUSELAGE SKIN REPAIR BS 951 STR 22L TO STR 23L. SRM 53-00-01SDR ASAA0945199Floorbeam · corrodedCORROSION AFT WET AREA ON 986 FLOORBEAM SKIN TO SKIN. REPAIRED FLOORBEAM UPPER TEE.SDR ASAA0945198Sill · corrodedCORROSION ON R1 DOOR MOPSILL. REMOVED AND REPLACED MOPSILL.SDR ASAA0945204Sill · corrodedCORROSION AFT WET AREA R2 MOPSILL HAS NUMEROUS AREAS OF CORROSION. REMOVED AND REPLACED PER SRM.SDR ASAA0945180Floorbeam · corrodedCORROSION AFT WET AREA BS 986 FLOORBEAM UPPER CHORD HAS EXTENSIVE CORROSION SKIN TO SKIN.SDR ASAA0945088Stringer Clip · corrodedSTRINGER CLIP CORRODED AFT CARGO BAY. REMOVED CRACKED STRINGER CLIP INSTALLED NEW POS 794 RBL 9 WL 150.SDR ASAA0945092Skin · dentedDENT IN FUSELAGE SKIN BELOW AFT CARGO DOOR CUTOUT. REPAIRED USING DOUBLER AND TRIPLER PER ER 09-2311 AND SRM 53-00-01.SDR ASAA0945069Guide Arm · wornF/A REPORTED L2 DOOR DIFFICULT TO CLOSE AND SEEMS TO HANG UP. REMOVED AND REPLACED L2 DOOR GUIDE ARM AND GUIDE ARM ROLLER PER MM 52 13 31. OPS CHECK GOOD.SDR ASAA0945035Bear Strap · misrepairedL1 UPPER HINGE CUTOUT REPAIR REQUIRES REPLACEMENT WITH APPROVED REPAIR. REMOVED EXISTING REPAIR, FABRICATED NEW REPAIR PARTS AND INSTALLED.SDR ASAA0945021Support Beam · wornLT RAM AIR INLET DUCT UPPER AFT O/B SUPPORT BRACKET WORN BS 570. REPLACED BRACKET.SDR ASAA0945022Frame · misrepairedFRAME DAMAGED BS 727D STR 8L IAW EA 400-53EA-00717. FABRICATED REPAIR PARTS AND INSTALLED.SDR ASAA0945094Guide Arm · wornF/A REPORTS L1 DOOR EXTREMELY HARD TO CLOSE AND LATCH. REMOVED AND REPLACED UPPER GUIDE ARM AND ATTACH FITTING PER AMM 52 11 21. DOOR OPERATES AND CLOSES SMOOTHLY.SDR ASAA0945002Structure · crackedLT ELEVATOR CRACKED UNDER PANEL 9142 ON I/B LEADING EDGE. REMOVED AND INSTALLED ROBBED ELEVATOR PER 27 31 11 404 025.SDR ASAA0945001Door Frame · chafedFWD ENTRY DOOR AFT EDGE FRAME TOP CORNER IS CHAFED. REPAIRED IAW.SDR ASAA0944997Strap · crackedSTABILIZER STRAP CRACKED. REPAIRED STABILIZER STRAP.SDR ASAA0944996Intercostal · crackedFWD CARGO COMPARTMENT INTERCOSTAL CRACKED. REMOVED & REPLACED INTERCOSTAL PER SRM 51 40 02.SDR ASAA0944995Intercostal · crackedFWD CARGO COMPARTMENT INTERCOSTAL CRACKED. REMOVED & REPLACED INTERCOSTAL PER SRM 51 40 02.SDR ASAA0945182Reflector · defectiveEXTERIOR EMERGENCY EXIT LIGHT AT R1 DOOR INOP. REMOVED AND REPLACED R1 EXTERIOR EMERG LIGHT REFLECTOR ASSY REF CMM 33 50 27, OP CHECK NORMAL.SDR ASAA0944991Support · puncturedFWD CARGO COMP LT FLOOR TO SIDEWALL SUPPORT IS PUNCTURED. REMOVED SUPPORT, FABRICATED NEW SUPPORT AND INSTALLED PER SRM 51 40 02.
Back to Boeing 737-4Q8