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 ASAA0945605Beam · damagedOPEN HOLE IN VERTICAL WEB OF LONGITUDINAL BEAM. REMOVED OPEN HOLE BY EXTENDING SLOT IN WEB HFEC INSPECTED TREATED AND PRIMED.SDR ASAA0945604Frame · crackedFRAME AT STR 8L BS 727F CRACKED AT FASTENER HOLE. REPAIRED.SDR ASAA0945603Hinge Fitting · crackedFWD ENTRY DOOR UPPER FUSELAGE HINGE FITTING CRACKED. REMOVED AND REPLACED UPPER HINGE FITTING ON FWD ENTRY DOOR.SDR ASAA0945573Support Channel · corrodedCORROSION ON AFT PRESSURE BULKHEAD CHANNEL STIFFENER RT SIDE. REPAIRED AFT PRESSURE BULKHEAD CHANNEL STIFFENER PER EA.SDR ASAA0945581Frame · misrepairedFRAME 787 S8R HAS PREVIOUS REPAIR WITH DEVIATIONS. REMOVED PREVIOUS, FABRICATED NEW REPAIR PARTS AND INSTALLED.SDR ASAA0945580Support Bracket · dentedSUPPORT BRACKET DENTED FWD SIDE OF RT ELEV STA 123. REPLACED SUPPORT BRACKET DENTED FWD SIDE OF RT ELEV STA 123.SDR ASAA0945579Frame · misrepairedFRAME AT 907 STR 8R HAS PREVIOUS REPAIR ACCOMPLISHED WITH DEVIATION. REMOVED EXISTING REPAIR, FABRICATED NEW REPAIR PARTS AND INSTALLED.SDR ASAA0945578Support Bracket · dentedSUPPORT BRACKET DENTED FWD SIDE OF RT ELEV STA 119. REPLACED SUPPORT BRACKET AT STA 119.SDR ASAA0945577Support Bracket · dentedSUPPORT BRACKET DENTED FWD SIDE OF RT ELEV STA 174. REPLACED SUPPORT BRACKET ON FWD SIDE OF RT SIDE ELEV STA 174.SDR ASAA0945576Support Bracket · dentedSUPPORT BRACKET DENTED FWD SIDE OF RT ELEV STA 123. REPLACED SUPPORT BRACKET ON FWD SIDE OF RT SIDE ELEV STA 123.SDR ASAA0945575Support Bracket · dentedSUPPORT BRACKET DENTED FWD SIDE ELEV STA 41. REPLACED SUPPORT BRACKET ON FWD SIDE OF RT SIDE ELEV STA 41.SDR ASAA0945574Frame · crackedFRAME AT 747 CRACKED AT FASTENER HOLE STR 8R. REPAIRED.SDR ASAA0945568Stringer · corrodedAPU RT UPPER STRINGER CORRODED AT AIR INLET DUCT OPENING. REMOVED AND REPLACED STRINGER AT APU AIR INLET DUCT OPENING IAW SRM 51 40 02.SDR ASAA0945572Support Channel · crackedBS 540 LBL 25 LBL 45 WL 208 SUPPORT CHANNEL UPPER COVER IS BENT AND PUNCTURED. REMOVED AND REPLACED SUPPORT CHANNEL IAW SRM 51 40 02 AND SRM 51 40 05.SDR ASAA0945571Support Channel · crackedBS 540 BL 0 LBL 25 WL 208 SUPPORT CHANNEL UPPER COVER IS BENT AND PUNCTURED. REMOVED AND REPLACED SUPPORT CHANNEL IAW SRM 51 40 02 AND SRM 51 40 05.SDR ASAA0945570Support Channel · damagedBS 540 BL 0 RBL 25 WL 208 SUPPORT CHANNEL UPPER COVER IS TORN AND BENT. REMOVED AND REPLACED SUPPORT CHANNEL IAW SRM 51 40 02 AND SRM 51 40 05.SDR ASAA0945569Stringer · corrodedAPU RT UPPER TORQUE BOX LOWER STRINGER CORRODED. REMOVED AND REPLACED LOWER STRINGER ON APU RT TORQUE BOX.SDR ASAA0945567Bulkhead · corrodedPRESSURE BULKHEAD IS CORRODED. REPAIRED PRESSURE BULKHEAD PER EA 400-53EA-01476.SDR ASAA0945566Flap Track · corrodedCORROSION ON 32 FLAP TRACK. REPAIRED TRACK PER OHM.SDR ASAA0945546Frame · misrepairedEXISTING REPAIRS ON 847 FRAME NOT PER DWG A 5330018185 FIG 5. REMOVED AND REPLACED FRAME.SDR ASAA0945547Frame · crackedFRAME CRACKED AT FASTENER HOLE FOR OVERHEAD CENTER LINE DUCT SUPPORT STA 767 2IN LT SIDE OF STR 1. REPAIRED IAW SRM.SDR ASAA0945545Support Bracket · crackedSUPPORT BRACKET CRACKED ON FWD SIDE OF RT ELEV STA 123. REPLACED SUPPORT BRACKET ON FWD SIDE OF RT ELEVATOR STA 123.SDR ASAA0945543Support Angle · crackedFWD ENTRY DOOR FWD LINER SUPPORT ANGLE CRACKED. REMOVED AND REPLACED FWD ENTRY DOOR FWD LINER SUPPORTSDR ASAA0945542Support Angle · crackedFWD ENTRY DOOR LOWER LINER SUPPORT ANGLE CRACKED. REMOVED AND REPLACED FWD ENTRY DOOR AFT LINER SUPPORT ANGLE.SDR ASAA0945541Bracket · crackedAFT ENTRY DOOR LOWER PAN BRACKETS ARE CRACKED. REPLACED PAN BRACKETS.SDR ASAA0945540Frame · crackedFRAME CRACKED AT FASTENER HOLE FOR OVERHEAD CENTER LINE DUCT SUPPORT STA 767 2 INCHES LT SIDE OF STR 1. TRIMMED OUT DAMAGE AND REPAIRED PER SRM.SDR ASAA0945516Crease Beam · corrodedCREASE BEAM HAS AREAS OF CORROSION REMOVED AND REPLACED CORRODED SECTION OF CREASE BEAM WITH NEW FABRICATED SECTION.SDR ASAA0945515Frame · damagedRT FAIRING FORMER HAS ELONGATED HOLES FAIRING FORMER REPLACED.SDR ASAA0945519Strap · crackedFLOORBEAM STABILIZATION STRAP CRACKED STA 328 RBL 0 WL 200. REPAIRED STABILIZATION STRAP STA 328 RBL 0 WL 200.SDR ASAA0945518Strap · crackedFLOORBEAM STABILIZATION STRAP CRACKED STA 328 RBL 46 WL 200. REPAIRED STABILIZATION STRAP STA 328 RBL 46 WL 200.SDR ASAA0945514Frame · crackedFRAME CRACKED STA 440 BETWEEN STR 8R AND 9R OUT OF LIMITS SRM 53-00-07. REPAIRED PER SRM.SDR ASAA0945513Frame · crackedFRAME CRACKED STA 480 BETWEEN STR 8R AND 9R OUT OF LIMITS SRM 53-00-07. REPAIRED FRAME IAW SRM 53-00-07.SDR ASAA0945512Intercostal · corrodedCORROSION ON INTERCOSTAL IN AFT CARGO BAY. FABRICATED REPLACEMENT INTERCOSTAL AND INSTALLED.SDR ASAA0945511Web · damagedFWD CARGO BAY DOOR CUTOUT FWD FRAME CLOSE OUT WEB DAMAGED HOLES. REPLACED WITH NEW CLOSE OUT WEB PER SRM.SDR ASAA0945500Support · gougedAFT CARGO DOOR CUTOUT CARGO TIE DOWN SUPPORT PLATE. FABRICATED NEW SUPPORT PLATE PER SRM/DRAWING.SDR ASAA0945502Frame · crackedFRAME CRACKED AT FASTENER HOLE FOR OVERHEAD CENTERLINE NUT. TRIMMED CRACKED SECTION AND REPAIRED PER SRM.SDR ASAA0945503Frame · crackedFRAME CRACKED AT FASTENER HOLE FOR OVERHEAD CENTERLINE NUT. REMOVED AND REPLACED CRACKED SECTION OF FRAME PER REPAIR.SDR ASAA0945527Skin · dentedSKIN AT AFT CARGO DOOR DENTED. REMOVED AND REPLACED AFT CARGO DOOR SKIN IAW SRM.SDR ASAA0945526Shear Tie · damagedFWD CARGO BAY DAMAGED SHEAR TIE IN. REMOVED DAMAGED SHEAR TIE FABRICATED REPAIR PARTS AND INSTALLED.SDR ASAA0945525Shear Tie · damagedDAMAGED SHEAR TIE IN FWD CARGO BAY. REMOVED DAMAGED SHEAR TIE FABRICATED REPAIR PARTS AND INSTALLED.SDR ASAA0945520Intercostal · damagedFWD CARGO BAY INTERCOSTAL DAMAGED AT LIGHTNING HOLE. REMOVED AND REPLACED INTERCOSTAL.SDR ASAA0945510Skin · chafedRT OTBD FORE FLAP LE CHAFED 6 INCH FROM INBD END. REPAIRED PER SRM. BLIND REPAIR FASTENERS INSPECTION REQUIRED AT EVERY C-CHECK.SDR ASAA0945508Bracket · crackedLT HORIZONTAL STAB NR 5 GAP PANEL BRACKET ASSY CRACKED AT LOWER INBD SPT. REMOVED AND REPLACED.SDR ASAA0945507Attach Bracket · crackedINTERCOSTAL ATTACH BRACKET CRACKED. FABRICATED REPLACEMENT BRACKET AND INSTALLED.SDR ASAA0945506Attach Bracket · crackedINTERCOSTAL ATTACH BRACKET CRACKED. REMOVED AND REPLACED BRACKET.SDR ASAA0945505Attach Bracket · crackedINTERCOSTAL WEB ATTACH BRACKET CRACKED. REMOVED AND REPLACED ATTACH BRACKET.SDR ASAA0945504Frame · crackedFRAME CRACKED AT FASTENER HOLE FOR OVERHEAD CENTERLINE DENT. CUT OUT CRACKED FRAME SECTION AND REPAIRED FRAME IAW SRM 53-00-07.SDR ASAA0945501Support Angle · damagedFWD CARGO BAY SIDEWALL SUPPORT ANGLE HAS DAMAGE AT NUTPLATE. REMOVED SIDEWALL SUPPORT BY REMOVING DAMAGE FABRICATING REPAIR PARTS AND INSTALLED.SDR ASAA0945499Web · corrodedCORROSION AFT CARGO DOOR CUTOUT MID CLOSEOUT WEB. REMOVED AND REPLACED.SDR ASAA0945485Mechanism · corrodedAFT GALLEY DOOR MECHANISM HOUSING CORRODED. REPLACED GALLEY DOOR MECHANISM.
Back to Boeing 737-4Q8