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 SWAA2013110521872Skin · crackedLT BS 500C+10 UPPER FWD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW EA.SDR SWAA2013110521871Skin · crackedLT BS 500B+10 UPPER FWD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW EA.SDR SWAA2013110521870Skin · crackedLT BS 500A+10 UPPER FWD WINDOW SKIN CUTOUT CRACKED AT HOLE 3,5,6,9. REPAIRED SKIN IAW EA.SDR SWAA2013110421808Support Angle · crackedEE COMPARTMENT SUPPORT ANGLE CRACKED AT BS 312+9, STRINGER 20L. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2013110421796Angle · crackedVERTICAL ANGLE CRACKED AT BS 294.5, STRINGER 27R. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2013103121771Skin · crackedRT BS 500A+10 UPPER FWD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW TC & SWA EA..SDR SWAA2013103121770Skin · crackedRT BS 420+10 UPPER FWD WINDOW SKIN CUTOUT CRACKED AT HOLES 3,4 & 7. REPAIRED SKIN IAW TC & EA.SDR SWAA2013103121755Tie Clip · crackedTIE CLIP CRACKED AT BS 380, STRINGER 22L. R&R TIE CLIP IAW SRM & DRAWING.SDR SWAA2013102821513Tie Clip · crackedTIE CLIP CRACKED AT BS 380, STRINGER 26R. R & R TIE CLIP IAW SRM & DRAWING.SDR SWAA2013102821512Tie Clip · crackedTIE CLIP CRACKED AT BS 380, STRINGER 21L. R & R TIE CLIP IAW SRM & DRAWING.SDR SWAA2013102821480Splice · crackedOTBD MIDFLAP LE SKIN SPLICE CRACKED AT OTBD END. REPAIRED SPLICE IAW EA.SDR SWAA2013102821605Flap Track · crackedLT WING NR 2 FLAP TRACK CORRODED AT REAR SPAR ATTACH POINT. R & R TRACK IAW MM.SDR SWAA2013112022602Floorbeam · crackedFLOOR BEAM CRACKED AT BS 947.5, LBL 53.5. REPAIRED BEAM IAW EA.SDR SWAA2013111922569Support Angle · crackedLT WING NR 1 SUPPORT ANGLE CRACKED ON OTBD FLAP TRACK. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2013111822502Rib · crackedLT WING RIB LOWER CHORD CRACKED AT WBL 135.5, BETWEEN STRINGER 2 & STRINGER 3. REPAIRED CHORD IAW EA.SDR SWAA2013111822473Door Frame · crackedFRAME CRACKED BETWEEN BS 947.5 +10 TO BS 967, BETWEEN STRINGER 16R TO STRINGER 17R ON AFT SERVICE DOOR RT. REPAIRED FRAME IAW EA.SDR SWAA2013111422379Shear Tie · corrodedSHEAR TIE CORRODED AT BS 967, BETWEEN STRINGER 20R TO STRINGER 21R. R & R SHEAR TIE IAW SRM & DRAWING.SDR SWAA2013111222253Web · corrodedWEB CORRODED BETWEEN BS 500C TO BS 500D, BETWEEN STRINGER 25L & STRINGER 26L. R & R WEB IAW SRM & DRAWING.SDR SWAA2013110521940Stringer · corrodedSTRINGER CORRODED BETWEEN BS 1006 TO BS 1016, STRINGER 26R. R & R STRINGER IAW SRM & DRAWING.SDR SWAA2013110521939Shear Tie · corrodedSHEAR TIE CORRODED AT BS 520, BETWEEN STRINGER 27L TO STRINGER 28L. R & R SHEAR TIE IAW SRM & DRAWING.SDR SWAA2013110421807Web · corrodedWEB UPPER FLANGE CORRODED BETWEEN BS 500B TO BS 500C, BETWEEN STRINGER 25L & STRINGER 26L. R & R WEB IAW SRM & DRAWING.SDR SWAA2013103121754Tie Clip · crackedTIE CLIP CRACKED AT BS 480, STRINGER 23L. R & R TIE CLIP IAW SRM & DRAWING.SDR SWAA2013102221356Wire · brokenWIRE BROKEN AT STATION 908, BL 0. REPAIRED WIRE IAW SWA WDM & MM.SDR SWAA2013111422378Frame · corrodedFRAME CORRODED AT BS 787, BETWEEN STRINGER 27R TO STRINGER 27L. REPAIRED FRAME IAW SRM.SDR SWAA2013111222252Fitting · corrodedRT VERTICAL STABILIZER OTBD REAR DRAG ANGLE FITTING CORRODED. R & R FITTING IAW SRM & DRAWING.SDR SWAA2013111222251Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 540, RBL 3. R &R ANGLE IAW SRM & DRAWING.SDR SWAA2013111122128Shear Tie · corrodedFWD CARGO COMPARTMENT FRAME CORRODED AT BS 500B, BETWEEN STRINGER 27R TO STRINGER 28R. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2013110421806Bracket · crackedBRACKET CRACKED AT BS 380, STRINGER 26L FWD CARGO COMPARTMENT. R & R BRACKET IAW SRM & DRAWING.SDR SWAA2013110421805Shear Tie · corrodedSHEAR TIE CORRODED AT BS 500D, BETWEEN STRINGER 27L TO STRINGER 28L. R & R SHEAR TIE IAW SRM & DRAWING.SDR SWAA2013110421804Web · crackedWEB CRACKED BETWEEN STATION 344 TO STATION 360, BL 0. R &R WEB IAW SRM & DRAWING.SDR SWAA2013102821604Plate · crackedAFT CARGO COMPARTMENT PLATE CRACKED AT BS 794, STRINGER 24R. R & R PLATE IAW SRM & DRAWING.SDR SWAA2013102221329Resistor · inoperativeCOCKPIT EMERGENCY EXIT LIGHT IN DOME LIGHT ASSEMBLY INOPERATIVE. REPAIRED RESISTOR IAW BSWPM & AMM.SDR SWAA2013102221325Lens · looseRT OVERWING EMERGENCY EXIT SIGN LOOSE. SECURED LENS IAW SIP.SDR SWAA2013112122640Tab · delaminatedRT ELEVATOR TAB TE DELAMINATED. R & R TAB IAW SRM.SDR SWAA2013112122639Stiffener · corrodedAFT BULKHEAD CHORD ANGLE STIFFENER CORRODED AT BS 1016, BETWEEN STRINGER 27R TO STRINGER 27L. REPAIRED STIFFENER IAW EO & EA.SDR SWAA2013112122638Stiffener · corrodedAFT PRESSURE BULKHEAD CHORD ANGLE STIFFENER CORRODED AT BS 1016, BETWEEN STRINGER 27R TO STRINGER 27L. REPAIRED STIFFENER IAW EO & EA.SDR SWAA2013111422377Frame · corrodedFRAME CORRODED AT BS 727D, BETWEEN STRINGER 27L TO STRINGER 27R. REPAIRED FRAME IAW SRM.SDR SWAA2013111422376Bracket · crackedBRACKET CRACKED AT BS 727, RBL 6. R & R BRACKET IAW SRM & DRAWING.SDR SWAA2013111122127Stiffener · crackedAFT CARGO COMPARTMENT STIFFENER CRACKED AT BS 727, RBL 5. R & R STIFFENER IAW SRM & DRAWING.SDR SWAA2013110122126Plate · crackedAFT CARGO PLATE CRACKED AT BS 794, BETWEEN STRINGER 21R TO STRINGER 25R. R & R PLATE IAW SRM & DRAWING.SDR SWAA2013110521952Flap · delaminatedLT WING INBD AFT FLAP LOCATED AT INBD SIDE DELAMINATED. REPAIRED AFT FLAP IAW SRM.SDR SWAA2013110421803Angle · crackedAFT CARGO COMPARTMENT ANGLE CRACKED AT BS 727A, STRINGER 25R. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2013110421802Tie Clip · crackedTIE CLIP CRACKED AT BS 727C, STRINGER 25R. R & R TIE CLIP IAW SRM & DRAWING.SDR SWAA2013110421801Shear Tie · corrodedSHEAR TIE CORRODED AT BS 500D, BETWEEN STRINGER 27R TO STRINGER 28R. R & R SHEAR TIE IAW SRM & DRAWING.SDR SWAA2013110421795Tie Clip · crackedTIE CLIP CRACKED AT BS 727B, STRINGER 25R. R & R TIE CLIP IAW SRM & DRAWING.SDR SWAA2013110421794Strap · crackedUNDER FWD GALLEY AREA STRAP CRACKED AT STATION 328, LBL 45. R & R STRAP IAW SRM & DRAWING.SDR SWAA2013103021689Angle · crackedAFT CARGO COMPARTMENT ANGLE CRACKED AT BS 747, STRINGER 25R. R &R ANGLE IAW SRM & DRAWING.SDR SWAA2013102821530Intercostal · crackedINTERCOSTAL CRACKED BETWEEN STATION 328 TO STATION 344, LBL 46. R & R CHANNEL IAW SRM & DRAWING.SDR SWAA2013102821511Strap · crackedUNDER FLOOR STRUCTURE FWD GALLEY STRAP CRACKED AT STATION 312, RBL 30. R & R STRAP IAW SRM & DRAWING.SDR SWAA2013102221330Retaining Clip · failedR1 DOOR EMERGENCY EVAC SLIDE RETAINER CLIP FOR GIRT BAR STOWAGE FAILED. R & R CLIP IAW SRM.
Back to Boeing 737-3H4