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 SWAA2013100120630Ballast · inoperativeRT OVERWING EMERGENCY EXIT LIGHT INOPERATIVE. R & R BALLAST IAW MM.SDR SWAA2013092620516Light · inoperativeR1 DOOR LOWER EMERGENCY EXIT LIGHT BULB INOPERATIVE. RELAMPED LIGHT IAW AMM.SDR SWAA2013092620515Light · inoperativeLT OVER WING LOWER EMERGENCY EXIT DOOR LIGHT BULBS INOPERATIVE. RELAMPED IAW AMM.SDR SWAA2013100320732Support Angle · crackedRT WING NR 6 TE INBD SIDE FLAP TRACK SUPPORT ANGLE CRACKED. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2013100220700Connector · brokenG4 EMERGENCY EXIT LIGHT BROKEN CONNECTOR. REPAIRED CONNECTOR IAW SWPM & AMM.SDR SWAA2013092620530Slide · out of positionL2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MT.SDR SWAA2013092620509Shear Tie · crackedFRAME SHEAR TIE CRACKED AT BS 400 BETWEEN STRINGER 15R & STRINGER 16R. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2013092420458Bracket · looseL2 DOOR EMERGENCY EVAC SLIDE GIRT BAR HOLDER LOOSE. SECURED BRACKET IAW MM.SDR SWAA2013100921031Skin · corrodedSKIN CORRODED BETWEEN BS 314 TO BS 316. REPAIRED SKIN IAW SRM & DRAWING.SDR SWAA2013093020564Web · crackedFWD CARGO COMPARTMENT WEB CRACKED BETWEEN BS 400 TO BS 420 STRINGER 26L. R & R WEB IAW SRM & DRAWING.SDR SWAA2013092420444Support Fitting · corrodedLT WING NR 2 FLAP TRACK AFT SUPPORT FITTING OTBD HOLE CORRODED. R & R FITTING IAW SRM.SDR SWAA2013101821284Skin · crackedFUSELAGE SKIN CRACKED AT LT BS 420+10, LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2013101521220Stringer Clip · crackedSTRINGER CLIP CRACKED AT STATION 380, STRINGER 8R. R&R CLIP IAW SRM & DRAWING.SDR SWAA2013101521219Skin · crackedLT BS 847+10 LOWER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLES 3,6,7,8. REPAIRED SKIN IAW EA.SDR SWAA2013101521218Skin · crackedLT BS 380+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 5,6,7. REPAIRED SKIN IAW EA.SDR SWAA2013101521217Skin · crackedLT BS 380+10 UPPER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLES 2 - 6. REPAIRED SKIN IAW EA.SDR SWAA2013101421133Skin · crackedLT WING LE SKIN INBD OF THE NR 1 PYLON AT CORNER OF CUTOUT SKIN CRACKED. REPAIRED SKIN IAW SRM.SDR SWAA2013101421114Skin · crackedLT BS 400+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE 4,8. REPAIRED SKIN IAW EA.SDR SWAA2013101421158Flap Track · corrodedLT NR 4 FLAP TRACK FWD ATTACH REAR BOLT HOLE OTBD SIDE CORRODED. REPAIRED FLAP TRACK IAW MM.SDR SWAA2013101421154Skin · crackedLT BS 460+10 UPPER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLE 4. REPAIRED SKIN IAW EA.SDR SWAA2013101421153Skin · crackedLT BS 400+10 UPPER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLES 3 - 6. REPAIRED SKIN IAW EA.SDR SWAA2013100921023Stringer · crackedSTRINGER CRACKED AT BS 380, STRINGER 8R. REPAIRED STRINGER IAW EA.SDR SWAA2013100820979Skin · crackedLT BS 480+10 UPPER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLES 3,4,6,7,8. REPAIRED SKIN IAW SB.SDR SWAA2013100820976Skin · crackedLT BS 500B+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 1,3,4,5,7,8.. REPAIRED SKIN IAW SB.SDR SWAA2013100820975Skin · crackedLT BS 500+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 3 - 8. REPAIRED SKIN IAW SB & TC.SDR SWAA2013100720926Skin · crackedRT BS 767+10 LOWER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLE 3. REPAIRED SKIN IAW SB & TC.SDR SWAA2013100720925Skin · crackedLT BS 360+10 UPPER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLES 4-7. REPAIRED SKIN IAW TC.SDR SWAA2013100720896Skin · crackedLT BS 867+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE 3. REPAIRED SKIN IAW EA & TC.SDR SWAA2013100720895Skin · crackedLT BS 847+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE 1,3,5. REPAIRED SKIN IAW SB &TC.SDR SWAA2013100720894Skin · crackedLT BS 827+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 2,3. REPAIRED SKIN EA.SDR SWAA2013100720893Skin · crackedLT BS 807+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 2,3. REPAIRED SKIN IAW SB & TC.SDR SWAA2013100720892Skin · crackedLT BS 867+10 LOWER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLES 3,12. REPAIRED SKIN IAW SB & TC.SDR SWAA2013100720891Skin · crackedLT BS 827+10 LOWER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLE 3. REPAIRED SKIN IAW SB & TC.SDR SWAA2013100720890Skin · crackedRT BS 867+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE 3. REPAIRED SKIN IAW SB &TC.SDR SWAA2013100720889Skin · crackedRT BS 847+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE 3. REPAIRED SKIN IAW SB & TC.SDR SWAA2013100720888Skin · crackedRT BS 827+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE 4 & HFEC CRACK INDICATION AT HOLE 3. REPAIRED SKIN IAW SB & TC.SDR SWAA2013100720887Skin · crackedRT BS 807+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE 3. REPAIRED SKIN IAW TC & EA.SDR SWAA2013100720886Skin · crackedRT BS 787+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT INDICATION AT HOLE 3. REPAIRED SKIN IAW SB & TC.SDR SWAA2013100720885Skin · crackedRT BS 767+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE 3. REPAIRED SKIN IAW SB.SDR SWAA2013100720884Skin · crackedRT BS 887+10 LOWER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLE 3. REPAIRED SKIN IAW SB.SDR SWAA2013100720883Skin · crackedRT BS 867+10 LOWER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLE 3. REPAIRED SKIN IAW SB.SDR SWAA2013100720882Skin · crackedLT BS 500C+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 3,5,6,8. REPAIRED SKIN IAW EA.SDR SWAA2013100720881Skin · crackedLT BS 500A+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 4-8. REPAIRED SKIN IAW TC & EA.SDR SWAA2013100720880Skin · crackedLT BS 480+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 4 - 88. REPAIRED SKIN IAW TC & EA.SDR SWAA2013100720879Skin · crackedLT BS 460+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 4,5,8. REPAIRED SKIN IAW TC & EA.SDR SWAA2013092620508Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 384.5 TO BS 388.5 STRINGER 15R. REPAIRED SKIN IAW EA.SDR SWAA2013092620507Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 500B+6" TO BS 500B+7" STRINGER 15R. REPAIRED SKIN IAW EA.SDR SWAA2013092620506Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 503.5 TO BS 504.5 STRINGER 16R. REPAIRED SKIN IAW EA.SDR SWAA2013092320388Fitting · brokenLT WING NR 4 GROUND SPOILER INBD ACTUATOR FITTING FWD LUG BROKEN. R & R FITTING IAW SRM.SDR SWAA2013092320367Lanyard · looseRT OVERWING EMERGENCY EXIT LANYARD LOOSE. SECURED LANYARD IAW MM.
Back to Boeing 737-3H4