Boeing 737-5H4
Service difficulty reports · 8,230
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 = '7375H4' 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 = '7375H4' 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 SWAA2013080818949Skin · crackedFS SKIN CRACKED AT BS 474, STRINGER 16R. REPAIRED SKIN IAW SRM.SDR SWAA2013080818948Skin · crackedFS SKIN CRACKED AT BS 432, STRINGER 17R. REPAIRED SKIN IAW SRM.SDR SWAA2013080818947Skin · crackedFS SKIN CRACKED AT BS 778, STRINGER 18R. REPAIRED SKIN IAW SRM.SDR SWAA2013083019736Angle · crackedLT WING TO BODY FAIRING TEE ANGLE CRACKED AT BS 727 BETWEEN STRINGER 21L & STRINGER 26L. R&R ANGLE IAW SRM & DRAWING.SDR SWAA2013082619524Fitting · crackedL1 DOOR SURROUND STRUCTURE CLIP CRACKED BETWEEN BS 294.5 TO BS 303.9 STRINGER 11L. R&R CLIP IAW SRM & DRAWING.SDR SWAA2013082619523Support Channel · crackedSUPPORT CHANNEL CRACKED AT BS 727+4 BL 6.5. R&R CHANNEL IAW SRM.SDR SWAA2013080618866Slide · out of positionR2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MT.SDR SWAA2013080618865Fastener · shearedL1 DOOR EMERGENCY EVAC SLIDE COVER AFT GIRT BAR HOLDER FASTENER SHEARED. R&R FASTENER IAW AMM & MT.SDR SWAA2013090619930Skin · crackedFS SKIN CRACKED AT BS 807 + 15.5, STRINGER 18L. REPAIRED SKIN IAW EA.SDR SWAA2013090619929Skin · crackedFS SKIN CRACKED AT BS 807+7, STRINGER 17L. REPAIRED SKIN IAW EA.SDR SWAA2013082619522Angle · crackedANGLE CRACKED AT BS 947.5 STRINGER 24R. R&R ANGLE IAW SRM & DRAWING.SDR SWAA2013082619521Fitting · crackedCLIP CRACKED AT BS 807 STRINGER 25R. R&R CLIP IAW SRM & DRAWING.SDR SWAA2013082319466Bracket · crackedL2 DOOR AFT LOWER CORNER BRACKET CRACKED. R&R BRACKET IAW SRM & DRAWING.SDR SWAA2013082319465Angle · crackedL1 DOOR FWD LOWER CORNER BRACKET CRACKED. R&R ANGLE IAW SRM & DRAWING.SDR SWAA2013082319464Bracket · crackedL1 DOOR AFT LOWER CORNER BRACKET CRACKED. R&R BRACKET IAW SRM & DRAWING.SDR SWAA2013081919299Pressure Deck · crackedMAIN WW PRESSURE DECK CRACKED AT BS 663.75+ 2", RBL 45.50+3". REPAIRED DECK IAW SRM.SDR SWAA2013081219026Tie Clip · crackedTIE CLIP CRACKED AT BS 727C, STRINGER 23R. R&R TIE CLIP IAW SRM & DRAWING.SDR SWAA2013081219025Tie Clip · crackedTIE CLIP CRACKED AT BS 727B, STRINGER 23R. R&R TIE CLIP IAW SRM & DRAWING.SDR SWAA2013080518828Gasper Fan · faultyOBSERVED STRONG ACID HOT ELECTRICAL SMELL, NO SMOKE FROM A/C SYSTEM, WENT AWAY WHEN GASPER FAN TURNED OFF. R&R GASPER FAN & HEPA FILTER IAW MM.SDR SWAA2013090619928Access Panel · crackedRT WING ACCESS PANEL 5864R CRACKED. REPAIRED PANEL IAW EA.SDR SWAA2013090619927Skin · crackedFS SKIN CRACKED AT BS 927+15", STRINGER 23R. REPAIRED SKIN IAW EA.SDR SWAA2013082619549Skin · crackedFS SKIN CRACKED AT BS 360 STRINGER 3L. REPAIRED SKIN IAW EA.SDR SWAA2013082619548Skin · crackedFS SKIN CRACKED AT BS 908 STRINGER 3L. REPAIRED SKIN IAW EA.SDR SWAA2013082319463Angle · crackedBULKHEAD ANGLE CRACKED AT BS 727 WW AREA. R&R ANGLE IAW SRM & DRAWING.SDR SWAA2013081419210Skin · crackedFS SKIN CRACKED AT BS 967+6.5, STRINGER 4L. R&R SKIN IAW SRM.SDR SWAA2013081319171Stiffener · crackedRT WING NR 6 AFT FLAP TRACK STIFFENER CRACKED. R&R STIFFENER IAW SRM.SDR SWAA2013081219024Angle · crackedFORWARD WING TO BODY FAIRING ANGLE CRACKED AT BS 540, STRINGER 24L. R&R ANGLE IAW SRM & DRAWING.SDR SWAA2013080618875Light · out of positionLT EMERGENCY EXIT LIGHT STRIP OUT OF POSITION AT ROW 6. REPOSITIONED STRIP IAW SIP.SDR SWAA2013080618874Plate · crackedWING TO BODY FAIRING ACCESS PANEL NR 3678R PLATE CRACKED. R&R PLATE IAW SRM.SDR SWAA2013090919970Frame · crackedFRAME OUTER CHORD CRACKED AT BS 727, STRINGER 18A CENTER LINE LT SIDE. REPAIRED CHORD IAW EA & EO.SDR SWAA2013090919961Frame · crackedFRAME OUTER CHORD CRACKED AT BS 727, STRINGER 18A CENTER LINE RT SIDE. REPAIRED CHORD IAW EA.SDR SWAA2013090619926Skin · crackedSKIN CRACKED AT BS 482B+5, STRINGER 15L. REPAIRED SKIN IAW EA.SDR SWAA2013090619925Skin · crackedFS SKIN CRACKED AT BS 440+4, STRINGER 16R. REPAIRED SKIN IAW EA.SDR SWAA2013090619924Stringer · crackedSTRINGER OUTER CHORD CRACKED AT BS 727, STRINGER 18A LT SIDE. REPAIRED CHORD IAW EA.SDR SWAA2013090419833Shear Web · crackedSHEAR BEAM WEB CRACKED AT BS 727, BELOW STRINGER 18A CENTER LINE LT SIDE. R&R WEB IAW SRM, DRAWING & EA.SDR SWAA2013081919305Stringer · corrodedSTRINGER CORRODED AT BS 1088+28" IN TORQUE BOX BEAM RT SIDE. R&R STRINGER IAW SRM & DRAWING.SDR SWAA2013081619275Skin · crackedFS SKIN CRACKED AT BS 380+5, STRINGER 26L. REPAIRED SKIN IAW SRM.SDR SWAA2013080618864Slide · out of positionL1 DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT, DID NOT DEPLOY, STILL OPERATIONAL. REINSTALLED SLIDE IAW MT.SDR SWAA2013082619547Floorbeam · crackedFLOOR BEAM UPPER CHORD CRACKED AT STATION 947.5 LBL 54. REPAIRED CHORD IAW EO & EA.SDR SWAA2013082319474Stiffener · corrodedBULKHEAD WEB STIFFENER CORRODED AT BS 1016 BL 0. REPAIRED STIFFENER IAW EA.SDR SWAA2013073118705Slide · out of positionR1 DOOR SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MM.SDR SWAA2013081419209Bracket · crackedBRACKET CRACKED BETWEEN BS 992.8 TO BS 1006, STRINGER 5R. R&R BRACKET IAW SRM & DRAWING.SDR SWAA2013081219050Web · crackedWEB CRACKED BETWEEN BS 986.5 TO BS 1006, STRINGER 5R. R&R WEB IAW SRM & DRAWING.SDR SWAA2013080919006Stringer Clip · crackedAFT CARGO COMPARTMENT STRINGER CLIP CRACKED AT STATION 927, STRINGER 24L. R&R CLIP IAW DRAWING.SDR SWAA2013073118706Slide · out of positionL1 DOOR SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MT.SDR SWAA2013082219438Fitting · crackedFITTING CRACKED AT BS 332.1 STRINGER 8R. R&R FITTING IAW EA.SDR SWAA2013082219437Fitting · crackedFITTING CRACKED BETWEEN BS 291.5 & BS 294.5 STRINGER 8R. R&R FITTING IAW EA.SDR SWAA2013081519244Reveal · crackedFWD ENTRY AFT LOWER CORNER OF CUTOUT CRACKED. R&R IAW SRM & DRAWING.SDR SWAA2013081419208Tie Clip · crackedTIE CLIP CRACKED AT BS 947.5, STRINGER 25R. R&R TIE CLIP IAW EA.SDR SWAA2013081319162Web · crackedWEB CRACKED AT BS 294.5+2, STRINGER 17R. R&R WEB IAW SRM & DRAWING.
Back to Boeing 737-5H4