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 SWAA2015112546459Strap · crackedFLOORBEAM STRAP CRACKED AT BS 312, RBL 24. R & R STRAP IAW SRM.SDR SWAA2015112546458Lens · looseFORWARD ENTRY LOWER EXIT LIGHT LENS LOOSE. SECURED LENS IAW AMM.SDR SWAA2015112546457Skin · crackedL1 DOOR INNER SKIN CRACKED, LOWER HINGE CUT OUT FWD VERTICAL FRAME. REPAIRED DOOR IAW EA.SDR SWAA2016010747753Spar · crackedLEFT WING INBD & OTBD OF WING, BETWEEN RSS 223.14 - 225.14, CRACKED IN UPPER SPAR. REPAIRED CHORD IAW EA.SDR SWAA2016010747752Web · crackedLEFT WING UPPER WEB INBD & OTBD, BETWEEN RSS 220.14 - 225.14 AT THE FASTENER HOLE. REPAIRED WEB IAW EA.SDR SWAA2016010747751Web · crackedRIGHT WING FASTENER HOLE INBD OF WING RSS 224.14, CRACKED IN UPPER WEB. REPAIRED WEB IAW EA.SDR SWAA2016010747748Web · crackedRIGHT WING FASTENER HOLE AT WING RSS 225.14, CRACKED IN UPPER WEB. REPAIRED WEB IAW ER & EA.SDR SWAA2016010747747Spar · crackedRIGHT WING FASTENER HOLE INBD OF WING RSS 224.14 INDICATED AS HOLE NR 5, CRACKED IN UPPER REAR SPAR. REPAIRED CHORD IAW EA.SDR SWAA2015113046512Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 787, STRINGER 24R. R & R CLIP IAW DWG & SRM.SDR SWAA2015112446386Girt Bar · looseR2 DOOR EMER EVAC SLIDE GIRT BAR ASSEMBLY LOOSE. SECURED GIRT BAR ASSEMBLY IAW MT.SDR SWAA2015112446406Retainer · crackedFORWARD CABIN OTBD FLASHLIGHT RETAINER CRACKED. R & R RETAINER IAW SIP.SDR SWAA2015112346290Sign · looseRIGHT EMER EXIT SIGN LOOSE. SECURED SIGN IAW SIP.SDR SWAA2015121146968Lens · missingRIGHT OVERHEAD BULLNOSE BIN EMER LIGHT LENS MISSING AT ROW 2. INSTALLED LENS IAW AMM.SDR SWAA2015121146967Lens · missingAFT CTR EMER EXIT SIGN LENS MISSING. INSTALLED LENS IAW AMM.SDR SWAA2015121146966Crease Beam · corrodedCREASE BEAM WEB CORRODED, BETWEEN BS 727C - 727D, WL 208 LT SIDE. R & R WEB IAW SRM.SDR SWAA2015112346346Door Frame · crackedAFT CARGO DOOR, FWD FRAME CRACKED AT THE EDGE OF LOWER STOP FITTING CUT OUT. R & R DOOR IAW AMM.SDR SWAA2016011948085Floorbeam · crackedAFT SEAT TRACK FLOORBEAM INBD & OTBD TRACK MOUNT FLANGE CRACKED AT BS 727B, RBL 24.8. REPAIRED FLOORBEAM IAW EA.SDR SWAA2016010647709Skin · crackedLEFT WING REAR SPAR UPPER SKIN, CRACKED IN OPEN FASTENER HOLE, LOCATED AT RSS 268. REPAIRED SKIN IAW EA.SDR SWAA2016010647708Skin · crackedLEFT WING REAR SPAR UPPER SKIN, CRACKED IN OPEN FASTENER HOLE, LOCATED AT RSS 267. REPAIRED SKIN IAW EA.SDR SWAA2016010647707Skin · crackedLEFT WING REAR SPAR UPPER SKIN, CRACKED IN OPEN FASTENER HOLE, LOCATED AT RSS 265. REPAIRED SKIN IAW EA.SDR SWAA2016010647706Skin · crackedLEFT WING REAR SPAR UPPER SKIN, CRACKED IN OPEN FASTENER HOLE, LOCATED AT RSS 239. REPAIRED SKIN IAW EA.SDR SWAA2016010647705Skin · crackedLEFT WING REAR SPAR UPPER SKIN, CRACKED IN OPEN FASTENER HOLE, LOCATED AT RSS 235. REPAIRED SKIN IAW EA.SDR SWAA2016010447633Crease Beam · corrodedLEFT CREASE BEAM CORRODED AT STATION 360 - 380. REPAIRED BEAM IAW SRM.SDR SWAA2015123147582Skin · crackedRIGHT WING UPPER SKIN CRACKED AT STATION RSS 269. REPAIRED SKIN IAW EA.SDR SWAA2015123147581Skin · crackedRIGHT WING UPPER SKIN CRACKED AT STATION RSS 257. REPAIRED SKIN IAW EA.SDR SWAA2015123147580Skin · crackedRIGHT WING UPPER SKIN CRACKED AT STATION RSS 255.5. REPAIRED SKIN IAW EA.SDR SWAA2015123147579Skin · crackedRIGHT WING UPPER SKIN CRACKED AT STATION RSS 230. REPAIRED SKIN IAW EA.SDR SWAA2015123147578Skin · crackedRIGHT WING UPPER SKIN CRACKED AT STATION RSS 155. REPAIRED SKIN IAW EA.SDR SWAA2015122947496Crease Beam · corrodedRIGHT CREASE BEAM CORRODED AT STATION 360 - 380. REPAIRED BEAM IAW SRM.SDR SWAA2015122947493Crease Beam · corrodedRIGHT CREASE BEAM CORRODED AT STATION 727C - 727C. REPAIRED BEAM IAW SRM.SDR SWAA2015122347397Skin · crackedLEFT SIDE FUSELAGE SKIN CRACKED AT STATION 289, WL 254. REPAIRED SKIN IAW EA.SDR SWAA2015122347376Shear Tie · corrodedSHEAR TIE CORRODED AT STATION 747, STRINGER 26R - 27R. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2015122347375Shear Tie · corrodedSHEAR TIE CORRODED AT STATION 747, STRINGER 26R - 27R. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2015122347370Attach Angle · corrodedATTACH ANGLE CORRODED AT BS 326.7, STRINGER 28L. R & R ANGLE IAW EA.SDR SWAA2015121647188Floor Support · crackedFLOOR TRACK FLOOR SUPPORT ANGLE, CRACKED AT BS 380, STRINGER 27R. R & R FLOOR TRACK IAW SRM.SDR SWAA2015121647187Shear Tie · corrodedSHEAR TIE CORRODED AT BS 360, BETWEEN STRINGER 28L - 28R. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2015121547100Shear Web · corrodedSHEAR WEB CORRODED, BETWEEN BS 986 - 1016, RBL 60. R & R SHEAR WEB IAW SRM & DWG.SDR SWAA2015121447070Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 380, STRINGER 16L. R & R CLIP IAW SRM & DWG.SDR SWAA2015121447069Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED, BETWEEN BS 460 - 480. R & R WEB IAW SRM & DWG.SDR SWAA2015121447066Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 360, STRINGER 8R. R & R CLIP IAW SRM.SDR SWAA2015121146965Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 500D, STRINGER 8R. R & R CLIP IAW SRM.SDR SWAA2015121146964Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 500C, STRINGER 8R. R & R CLIP IAW SRM.SDR SWAA2015121146963Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 500B, STRINGER 8R. R & R CLIP IAW SRM.SDR SWAA2015121146962Seat Track · crackedSEAT TRACK WEB UPPER RADIUS CRACKED AT BS 727B+1.5, RBL 45.5. REPAIRED SEAT TRACK IAW SRM.SDR SWAA2015120946896Support Bracket · crackedSUPPORT BRACKET, CRACKED AT BS 540, LBL 45. R & R BRACKET IAW SRM & DWG.SDR SWAA2015120746800Skin · delaminatedLEFT WING INBD FORE FLAP, DELAMINATED ON LOWER SURFACE. REPAIRED FORE FLAP IAW SRM.SDR SWAA2015113046550Link · missingRIGHT MLG MISSING FITTING, UPPER DOWNLOCK LINK. R & R DOWNLOCK LINK IAW AMM.SDR SWAA2015113046511Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 887, STRINGER 9L. R & R CLIP IAW DWG & SRM.SDR SWAA2015113046510Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 727A, STRINGER 14R. R & R CLIP IAW DWG & SRM.SDR SWAA2015113046509Crossbeam · corrodedCREASE BEAM WEB CORRODED, BETWEEN BS 727D - 727E, STRINGER 17L. R & R WEB IAW DWG & SRM.
Back to Boeing 737-3H4