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 SWAA2013092420446Angle · crackedFWD CARGO COMPARTMENT AT BULKHEAD FWD FACE ANGLE CRACKED AT BS 540 LBL 1. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2013091820235Battery Pack · dischargedL1 DOOR EMERGENCY EXIT LIGHT INOPERATIVE. CHARGED BATTERY PACKS IAW MM.SDR SWAA2013091820212Slide · out of positionL2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW SIP.SDR SWAA2013100920999Skin · crackedSKIN CRACKED AT BS 727C + 6 TO 8 INCHES STRINGER 14R. REPAIRED SKIN IAW MM.SDR SWAA2013100720866Frame · corrodedFRAME CORRODED AT BS 500D, BETWEEN STRINGER 26R TO STRINGER 27R. REPAIRED FRAME IAW SRM.SDR SWAA2013100720800Frame · corrodedFRAME CORRODED AT BS 500 BETWEEN STRINGER 27L TO STRINGER 28L.. REPAIRED FRAME IAW SRM.SDR SWAA2013100720799Frame · corrodedFRAME CORRODED AT BS 500C BETWEEN STRINGER 26L TO STRINGER 27L. REPAIRED FRAME IAW SRM.SDR SWAA2013093020572Panel · crackedWING TO BODY FAIRING PANEL 3378L CRACKED FASTENER HOLE. REPAIRED PANEL IAW SRM.SDR SWAA2013092620523Angle · crackedLT WING FIXED TE STRUCTURE RSS 545 ANGLE CRACKED. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2013091820230Battery Pack · dischargedFWD LT SECTION OF EMERGENCY LIGHTS INOPERATIVE. R & R BATTERY PACK IAW AMM.SDR SWAA2013100720865Pressure Deck · crackedMAIN WW PRESSURE DECK CRACKED AT BS 663.75 + 2 RBL 24.5 + 17. REPAIRED DECK IAW SRM.SDR SWAA2013100320729Web · crackedNLG WW WEB CRACKED AT BS 243.7 + 4.5 WL 169.1 RT SIDE. REPAIRED WEB IAW SRM.SDR SWAA2013100320728Frame · crackedFRAME CRACKED AT BS 947.5 STRINGER 18R. R & R FRAME IAW DRAWING & SRM.SDR SWAA2013100220710Pressure Deck · crackedMAIN WW PRESSURE DECK CRACKED AT BS 663.75 + 2 RBL 24.5 + 14.5". REPAIRED DECK IAW SRM.SDR SWAA2013093020573Frame · crackedFRAME CRACKED AT BS 500B STRINGER 20R. REPAIRED FRAME IAW SRM.SDR SWAA2013093020561Frame · crackedFRAME CRACKED AT BS 947.5 STRINGER 18L. R & R FRAME IAW SRM & DRAWING.SDR SWAA2013092620522Angle · crackedVERTICAL STABILIZER ACCESS PANEL NR 9504 ANGLE CRACKED. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2013092520478Plate · crackedRT HORIZONTAL STABILIZER ACCESS PANEL NR 9226R PLATE CRACKED. R & R PLATE IAW SRM.SDR SWAA2013092420445Angle · crackedAFT CARGO COMPARTMENT ANGLE CRACKED AT BS 947.5 STRINGER 25R. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2013092320342Tie Clip · crackedTIE CLIP CRACKED AT BS 887 STRINGER 20L. R & R TIE CLIP IAW SRM & DRAWING.SDR SWAA2013091920295Angle · crackedLT HORIZONTAL STABILIZER ANGLE CRACKED AT ACCESS PANEL NR 9126L. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2013100720864Frame · corrodedFRAME CORRODED AT BS 747 BETWEEN STRINGER 27L TO STRINGER 27R. REPAIRED FRAME IAW SRM & DRAWING.SDR SWAA2013100720798Tie Clip · crackedTIE CLIP CRACKED AT BS 947.5 STRINGER 25R. R & R TIE CLIP IAW EA.SDR SWAA2013100320727Frame · crackedFRAME CRACKED BS 907 BETWEEN STRINGER 25R TO STRINGER 26R. REPAIRED FRAME IAW SRM.SDR SWAA2013100220699Support Bracket · crackedCONNECTOR SUPPORT BRACKET CRACKED AT BS 665 RBL 3. R & R BRACKET IAW SRM & EA.SDR SWAA2013092620521Tie Clip · crackedTIE CLIP CRACKED AT BS 727E STRINGER 25R. R & R TIE CLIP IAW SRM & DRAWING.SDR SWAA2013092620519Tie Clip · crackedTIE CLIP CRACKED AT BS 727A STRINGER 25R. R &R TIE CLIP IAW SRM & DRAWING.SDR SWAA2013092620518Plate · crackedWING TO BODY FAIRING ACCESS PANEL NR 3678R PLATE CRACKED. R & R PLATE IAW SRM & DRAWING.SDR SWAA2013091820207Battery Pack · dischargedL2 DOOR EMERGENCY EXIT LIGHT INOPERATIVE. R&R BATTERY PACK IAW MM.SDR SWAA2013100320726Floorbeam · crackedFLOOR BEAM CRACKED AT BS 666.25 LBL 24.5. REPAIRED BEAM IAW EA.SDR SWAA2013092620529Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 360 STRINGER 9R. R & R CLIP IAW SRM & DRAWING.SDR SWAA2013092620528Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 360 STRINGER 8R. R & R CLIP IAW SRM & DRAWING.SDR SWAA2013091820234Flap · delaminatedRT WING INBD FORE FLAP DELAMINATED. REPAIRED FORE FLAP IAW SRM.SDR SWAA2013092620517Pan · crackedR2 DOOR LOWER AREA PAN CRACKED. R & R IAW SRM & DRAWING.SDR SWAA2013092320387Shear Tie · corrodedSHEAR TIE CORRODED AT BS 520, BETWEEN STRINGER 27L & STRINGER 28L. R & R SHEAR TIE IAW SRM & DRAWING.SDR SWAA2013100220698Structure · crackedRT CHORD CRACKED AT BS 727 STRINGER 18A. REPAIRED CHORD IAW ER & EA.SDR SWAA2013100220697Structure · crackedLT CHORD CRACKED AT BS 727 STRINGER 18A. REPAIRED CHORD IAW ER & EA.SDR SWAA2013100220696Pressure Deck · crackedMAIN WW PRESSURE DECK CRACKED AT BS 674.25, LBL 40. REPAIRED WEB IAW ER & EA.SDR SWAA2013091120064Light · inoperativeL1 DOOR EMERGENCY EXIT LIGHT INOPERATIVE. REPAIRED LIGHT IAW MM.SDR SWAA2013091120059Light · inoperativeR1 DOOR EMERGENCY EXIT LIGHT INOPERATIVE. REPAIRED LIGHT IAW MM.SDR SWAA2013092620524Sign · brokenL1 DOOR EMERGENCY EXIT SIGN TAB BROKEN. R & R SIGN ASSEMBLY IAW AMM.SDR SWAA2013092620520Sign · looseR1 DOOR EMERGENCY EXIT SIGN LOOSE. R & R SIGN ASSEMBLY IAW AMM.SDR SWAA2013092620527Stringer Splice · crackedSTRINGER SPLICE CRACKED AT BS 908 STRINGER 4R. R & R SPLICE IAW SRM & DRAWING.SDR SWAA2013090919982Stringer Clip · crackedSTRINGER CLIP CRACKED AT STATION 400, STRINGER 8L. R&R CLIP IAW DRAWING.SDR SWAA2013092620526Skin · crackedFUSELAGE SKIN CRACKED AT BS 520 + 2 LBL 4. REPAIRED SKIN IAW SRM.SDR SWAA2013090919980Mount Bracket · crackedR2 DOOR EMERGENCY EVAC SLIDE FWD MOUNT BRACKET CRACKED. R&R BRACKET IAW AMM.SDR SWAA2013100720808Skin · crackedLT BS 727A+10 LOWER FWD WINDOW SKIN CUTOUT CRACKED AT HOLES 1,4,5,8,9 & HFEC CRACK INDICATION AT HOLES 2,3,10,11,12. REPAIRED SKIN IAW EA.SDR SWAA2013100720807Skin · crackedRT BS 500A+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 3 - 6. REPAIRED SKIN IAW EA.SDR SWAA2013100220716Skin · crackedLT BS 500C+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 12,3,4,6,7,8,10,12. REPAIRED SKIN IAW EA.SDR SWAA2013100220683Skin · crackedLT BS 767+10 LOWER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLES 1,3,10,11,12. REPAIRED SKIN IAW EA.
Back to Boeing 737-3H4