Boeing 737-3H4
Service difficulty reports · 52,340
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 = '7373H4' 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 = '7373H4' 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 SWAA2016061752969Splice · crackedLEFT WING REAR SPAR UPPER CHORD SPLICE CRACKED ON RSS 214.14. REPAIRED SPLICE IAW EA.SDR SWAA2016061752968Skin · crackedLT WING UPPER WING SKIN CRACKED BETWEEN RSS 232 TO RSS 272. REPAIRED SKIN IAW ER AND EA.SDR SWAA2016061652950Splice · crackedRT WING REAR SPAR UPPER CHORD SPLICE CRACKED ON RSS 224.14. REPAIRED SPLICE IAW EA.SDR SWAA2016061552887Attach Bracket · crackedRIGHT WING T/E PANEL NR 8715 ATTACH BRACKET CRACKED. R & R BRACKET IAW SRM.SDR SWAA2016061552886Attach Angle · crackedLEFT WING REAR SPAR ATTACH ANGLE CRACKED. R & R ANGLE IAW DWG & SRM.SDR SWAA2016060952711Skin · delaminatedLEFT WING AILERON TAB LOWER SKIN DELAMINATED. REPAIRED TAB IAW SRM.SDR SWAA2016051751867Attach Angle · corrodedATTACH ANGLE CORRODED AT BS 328, STRINGER 20L. R & R ANGLE IAW SRM & DWG.SDR SWAA2016051051682Stringer Clip · crackedFORWARD CARGO BAY STRINGER CLIP CRACKED AT BS 500D, STRINGER 19R. R & R CLIP IAW SRM & DWG.SDR SWAA2016050951669Battery Pack · faultyM1673 EMER EXIT LIGHT BATTERY PACK FAULTY AT BS 973, LBL 7. R & R BATTERY PACK IAW AMM.SDR SWAA2016050951668Battery Pack · faultyM1675 EMER EXIT LIGHT BATTERY PACK FAULTY AT BS 318, LBL 3. R & R BATTERY BACK IAW AMM.SDR SWAA2016050951631Cover · missingOVERWING EXIT SIGN COVER MISSING. INSTALLED COVER IAW AMM.SDR SWAA2016050951598Slat · delaminatedLEFT WING NR 2 SLAT DELAMINATED ON OTBD UPPER WEDGE SECTION. R & R NR 2 SLAT IAW AMM.SDR SWAA2016062253124Puck · corrodedAFT CARGO FLOOR TIE DOWN HOCKEY PUCKS CORRODED AT BS 847, BETWEEN STR 20L TO STR 22L. R & R PUCK IAW SRM.SDR SWAA2016061352804Strap · crackedAFT SPAR STRAP CRACKED AT BS 660, LBL 36. R & R STRAP IAW SRM AND DWG.SDR SWAA2016060652487Shear Tie · crackedSHEAR TIE CRACKED AT BS 520, BETWEEN STRINGER 28L - 27L. R & R SHEAR TIE IAW SRM & DWG.SDR SWAA2016060652478Rib · crackedLEFT HORIZONTAL STABILIZER RIB LOWER CHORD CRACKED ON STAB STATION 120.30. R & R CHORD IAW SRM & DWG.SDR SWAA2016052652158Stringer Clip · corrodedSTRINGER END CLIP CORRODED AT BS 500, STRINGER 28R. R & R CLIP IAW SRM & DWG.SDR SWAA2016052352002Angle · crackedFORWARD CARGO COMPARTMENT ANGLE CLIP CRACKED AT BS 380, STRINGER 26L. R & R ANGLE CLIP IAW SRM & DWG.SDR SWAA2016051751881Link · corrodedLEFT MLG TRUNNION LINK, OTBD AFT FACE CORRODED. R & R LINK IAW AMM.SDR SWAA2016051751866Threshold · corrodedR2 DOOR CUT OUT LOWER THRESHOLD CHORD CORRODED. R & R CHORD IAW SRM & DWG.SDR SWAA2016050951666Fitting · corrodedL1 DOOR CUT OUT AFT GIRT BAR SUB FLOOR FITTING CORRODED. REPAIRED FITTING IAW SRM.SDR SWAA2016070653553Support Fitting · crackedRIGHT WING UPPER SPAR AFT MAIN LANDING GEAR SUPPORT FITTING CRACKED, RSS 224.14. REPAIRED FITTING ER AND EA.SDR SWAA2016070553469Spar · crackedRIGHT WING UPPER SPAR CRACKED BETWEEN RSS. 223.14 TO RSS. 285. REPAIRED IAW EA.SDR SWAA2016070553447Spar · crackedRIGHT WING UPPER SPAR WEB CRACKED BETWEEN RSS. 211 TO 238. REPAIRED THE WEB IAW EA.SDR SWAA2016070553446Spar · crackedLEFT WING UPPER SPAR WEB CRACKED RSS. 224.14. REPAIRED SPAR WEB IAW ER AND EA.SDR SWAA2016070553444Spar · crackedLEFT WING UPPER SPAR CRACKED AT RSS. 224.14. REPAIRED THE SPAR IAW ER AND EA.SDR SWAA2016062853299Link Assy · corrodedLT MLG SUPPORT BEAM SWING LINK CORRODED AT AFT BUSHING BORES. R & R LINK ASSEMBLY IAW EA.SDR SWAA2016062453203Spar · crackedLEFT WING REAR SPAR WEB CRACKED AT MLG AFT SUPPORT FITTING. REPAIR WEB IAW EA.SDR SWAA2016062453202Spar · crackedRIGHT WING REAR SPAR WEB UNDER AFT SUPPORT FITTING CRACKED. REPAIRED WEB IAW EA.SDR SWAA2016062453209Axle · corrodedNLG AXLE CORRODED ON UPPER SIDE OF LT AND RT AXLE AT 12 O'CLOCK POSITION. R & R NLG INNER CYLINDER IAW MM.SDR SWAA2016061352803Frame · corrodedFRAME CORRODED AT BS 500D, BETWEEN STR 28L TO STR 28R. REPAIRED FRAME IAW SRM AND EA.SDR SWAA2016061352802Structure · crackedOUTER CHORD CRACKED AT BS 360, STR 14L. R & R CHORD IAW EA.SDR SWAA2016060952716Frame · corrodedSHEAR TIE CORRODED AT BS 747, BETWEEN STRINGER 26L - 27L. R & R FRAME IAW SRM & DWG.SDR SWAA2016060652541Structure · crackedWEB OUTER CHORD CRACKED BETWEEN BS 277 - 291.5, BETWEEN STRINGER 8R - 9R. R & R CHORD IAW SRM & DWG.SDR SWAA2016052552102Attach Angle · corrodedFORWARD CARGO AFT BULKHEAD FLOOR PANEL ATTACH ANGLE CORRODED UPPER & LOWER. R & R ANGLE IAW SRM & DWG.SDR SWAA2016052552101Web · crackedWEB OUTER CHORD CRACKED BETWEEN BS 277 - 291.5, BETWEEN STRINGER 13R - 14R. R & R CHORD IAW SRM & DWG.SDR SWAA2016052552100Intercostal · crackedINTERCOSTAL WEB CRACKED AT BS 277, STRINGER 14R. R & R WEB IAW & DWG.SDR SWAA2016052452046Flap Track · corrodedRIGHT WING NR 5 FLAP TRACK FWD ATTACH POINT INBD AFT BOLT HOLE CORRODED. REPAIRED TRACK IAW EA.SDR SWAA2016052352001Stringer Splice · crackedSTRINGER SPLICE CRACKED AT BS 360, STRINGER 14L. R & R SPLICE IAW SRM.SDR SWAA2016051751864Flashlight · crackedFORWARD GALLEY AREA FLASHLIGHT BASE CRACKED. R & R FLASHLIGHT ASSEMBLY IAW CMM.SDR SWAA2016050951655Stop Fitting · crackedL1 DOOR AFT SLIDE UPPER STOP FITTING CRACKED. R & R DOOR IAW AMM.SDR SWAA2016050551585Lens · looseRIGHT EMER EXIT HATCH EXIT LIGHT LENS LOOSE. SECURED LENS IAW AMM.SDR SWAA2016050551584Strap · crackedFLOORBEAM STABILIZER STRAP CRACKED AT BS 344, BL 0. R & R STRAP IAW SRM & DWG.SDR SWAA2016062753276Hinge Fitting · corrodedRIGHT HORIZONTAL STABILIZER CENTER SECTION HINGE FITTING CORRODED AT FORWARD LOWER LUG OTBD SIDE. REPAIRED FITTING IAW EA.SDR SWAA2016062753275Hinge Fitting · corrodedRIGHT HORIZONTAL STABILIZER CENTER SECTION HINGE BEARING FITTING CORRODED ON INNER RACE. REPAIRED FITTING IAW EA.SDR SWAA2016060952715Pressure Deck · crackedMAIN WW PRESS DECK CRACKED AT BS 673.25, RBL 41.5. REPAIRED DECK IAW SRM & EA.SDR SWAA2016060852668Skin · delaminatedLEFT WING AILERON TAB LOWER SKIN DELAMINATED. REPAIRED SKIN IAW SRM.SDR SWAA2016060652485Fitting · crackedLEFT WING AFT MLG FITTING CRACKED AT NR 5 HOLE APPROX RSS 223.14. REPAIRED FITTING IAW ER & EA.SDR SWAA2016052452043Skin · delaminatedRIGHT WING OTBD FORE FLAP DELAMINATED AT UPPER SURFACE 84 INCHES OF INBD END. REPAIRED FORE FLAP IAW SRM.SDR SWAA2016052352003Shear Tie · corrodedFRAME SHEAR TIE CORRODED AT BS 787, BETWEEN BL 0 - LBL 5. R & R SHEAR TIE IAW SRM.
Back to Boeing 737-3H4