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 SWAA2014041727201Bulkhead · crackedDOME CAP WEB CRACKED AT BS 1016, STRINGER 15R. REPAIRED WEB IAW SRM.SDR SWAA2014041627156Skin · delaminatedLEFT WING INBD FORE FLAP UPPER SURFACE DELAMINATED. REPAIRED FORE FLAP IAW SRM.SDR SWAA2014041627155Fitting · looseLEFT WING OTBD FORE FLAP NR 2 CARRIAGE FITTING LOOSE. SECURED FITTING IAW MM.SDR SWAA2014041427062Attach Angle · crackedINTERCOSTAL ATTACH ANGLE CRACKED AT BS 348, STRINGER 15L. REPAIRED ANGLE IAW EA.SDR SWAA2014041427048Skin · crackedFUSELAGE SKIN CRACKED AT FWD SERVICE DOOR, LOWER HINGE CUT OUT, FWD EDGE. REPAIRED SKIN IAW SRM.SDR SWAA2014040926962Lens · looseOVERHEAD EMERGENCY EXIT LIGHT LENSES LOOSE AT ROW 3. SECURED LENSES IAW SIP.SDR SWAA2014050827799Floor Support · crackedLONGITUDINAL FLOORBEAM UPPER CHORD AFT END CTR SECTION CRACKED AT BS 727B, LBL 45.5. REPAIRED CHORD IAW EA.SDR SWAA2014050227600Pressure Deck · crackedMAIN WW PRESS DECK WEB CRACKED AT BS 663.75+9.5, LBL 24.5 + 6.5. REPAIRED WEB IAW SRM.SDR SWAA2014050227599Pressure Panel · crackedMAIN WW PRESS DECK WEB CRACKED AT BS 663.75, RBL 42. REPAIRED WEB IAW SRM.SDR SWAA2014042827431Floorbeam · crackedLONGITUDINAL FLOORBEAM CTR SECTION WEB CRACKED AT BS 708, RBL 24.8. REPAIRED WEB IAW EA.SDR SWAA2014042427354Fitting · crackedCLIP CRACKED AT BS 320, STRINGER 21L. R & R CLIP IAW SRM & DWG.SDR SWAA2014042227278Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 294.5, STRINGER 23L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014042127238Angle · crackedANGLE CRACKED AT BS 328, LBL 46. R & R ANGLE IAW SRM & DWG.SDR SWAA2014041427096Bearing · brokenLEFT WING NR 2 A FRAME FLAP TRACK CARRIAGE BEARING BROKEN. R & R BEARING IAW CMM.SDR SWAA2014041427081Web · crackedWEB CRACKED AT BS 303, BETWEEN STRINGER 27R TO STRINGER 28L. R & R WEB IAW SRM & DWG.SDR SWAA2014041427080Web · crackedWEB CRACKED BETWEEN BS 351 TO BS 360, BETWEEN STRINGER 28L TO STRINGER 28R. R & R WEB IAW SRM & DWG.SDR SWAA2014041427079Web · crackedWEB CRACKED BETWEEN BS 312 TO BS 318, BETWEEN STRINGER 28L TO STRINGER 28R. R & R WEB IAW SRM & DWG.SDR SWAA2014040826919Windshield · crackedDIVERT & DECLARED EMERGENCY. FIRST OFFICER`S FWD WINDSHIELD ARCING AT FL350 TURNED OFF PITOT HEAT, 1.5 MIN LATER WINDSHIELD CRACKED. R & R R1 WINDOW & HEAT CONTROLLER IAW MM.SDR SWAA2014050527659Shear Web · crackedSHEAR WEB CRACKED AT BS 348.2, STRINGER 17L. REPAIRED WEB IAW EA.SDR SWAA2014050527658Shear Web · crackedSHEAR WEB CRACKED AT BS 348.2, STRINGER 16L. REPAIRED WEB IAW EA.SDR SWAA2014050527672Frame · crackedFRAME CHORD CRACKED AT BS 348.2, STRINGER 16L. REPAIRED FRAME IAW EA.SDR SWAA2014050527664Structure · crackedCHORD CRACKED AT BS 727, STRINGER 18R. REPAIRED CHORD IAW EA.SDR SWAA2014050527663Structure · crackedCHORD CRACKED AT BS 727, STRINGER 18L. REPAIRED CHORD IAW EA.SDR SWAA2014042827455Stiffener · crackedZ STIFFENER CRACKED AT BS 1016, STRINGER 21R. REPAIRED Z STIFFENER IAW EA.SDR SWAA2014042827454Structure · crackedINNER CHORD CRACKED AT BS 348.2, STRINGER 17L. R & R CHORD IAW SRM & DWG.SDR SWAA2014042827453Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 540, RBL 1. R & R ANGLE IAW SRM & DWG.SDR SWAA2014042827452Frame · corrodedFRAME CORRODED AT BS 727D, BETWEEN STRINGER 26R TO STRINGER 27R. REPAIRED FRAME IAW SRM.SDR SWAA2014042827451Structure · crackedLEFT WING UPPER CHORD CRACKED AT WBL 114, STRINGER 2. REPAIRED CHORD IAW EA.SDR SWAA2014042827450Frame · corrodedFRAME CORRODED AT BS 807, BETWEEN STRINGER 27L TO STRINGER 26L. REPAIRED FRAME IAW SRM.SDR SWAA2014042827449Stringer · corrodedSTRINGER CORRODED AT BS 967, STRINGER 27L. REPAIRED STRINGER IAW SRM.SDR SWAA2014042427350Stiffener · corrodedSTIFFENER CORRODED BETWEEN BS 219.8 TO BS 227.8, BL 0. R & R STIFFENER IAW SRM & DWG.SDR SWAA2014042227277Channel · crackedCHANNEL CRACKED AT BS 540, RBL 1. R & R CHANNEL IAW SRM & DWG.SDR SWAA2014041627154Channel · crackedCHANNEL CRACKED AT BS 540, LBL 1. R & R CHANNEL IAW SRM & DWG.SDR SWAA2014040926964Tie Clip · crackedTIE CLIP CRACKED AT BS 927, STRINGER 20L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014040826931Skin · delaminatedLEFT WING OTBD AFT FLAP LOWER SURFACE DELAMINATED AT INBD SIDE. R & R AFT FLAP IAW MM.SDR SWAA2014050527657Tie Clip · crackedTIE CLIP CRACKED AT BS 947.5, STRINGER 25R. R & R TIE CLIP IAW EA.SDR SWAA2014050127585Frame · crackedFUSELAGE FRAME CRACKED AT STATION 947.5, STRINGER 26R. REPAIRED FRAME IAW EA.SDR SWAA2014043027541Frame · crackedFRAME CRACKED AT BS 492.4, STRINGER 24R. R & R FRAME IAW EA.SDR SWAA2014042827448Fitting · crackedCLIP CRACKED AT BS 348.2, STRINGER 16L. R & R CLIP IAW SRM & DWG.SDR SWAA2014042827447Tie Clip · crackedTIE CLIP CRACKED AT BS 967, LBL 3. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014042827408Fitting · crackedCLIP CRACKED AT BS 947.5, BETWEEN STRINGER 25L TO STRINGER 24L. R & R CLIP IAW SRM & DWG.SDR SWAA2014042827407Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 348.2, STRINGER 15L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014042827406Frame · crackedFRAME CRACKED AT BS 947.5, STRINGER 19L. R & R FRAME IAW SRM & DWG.SDR SWAA2014042227276Web · crackedWEB CRACKED AT BS 360, BL 0. R & R WEB IAW SRM & DWG.SDR SWAA2014042127237Stiffener · crackedSTIFFENER CRACKED BETWEEN BS 312 TO BS 328, RBL 32. R & R STIFFENER IAW SRM & DWG.SDR SWAA2014041627157Wire · brokenR2 DOOR EMERGENCY HEADER LIGHT WIRE BROKEN AT QUICK DISCONNECT. REPAIRED WIRE IAW SWPM.SDR SWAA2014041427118Strap · crackedTIE STRAP CRACKED AT BS 350, STRINGER 16L. R & R TIE STRAP IAW SRM & DWG.SDR SWAA2014041427077Skin · delaminatedLEFT WING AFT FLAP INBD LOWER SURFACE DELAMINATED. REPAIRED AFT FLAP IAW SRM.SDR SWAA2014041427073Floorbeam · crackedFLOORBEAM UPPER FLANGE CRACKED AT BS 328, BL 0. REPAIRED FLOORBEAM IAW SRM.SDR SWAA2014041427072Tie Clip · crackedTIE CLIP CRACKED AT BS 787, STRINGER 21R. R & R TIE CLIP IAW SRM & DWG.
Back to Boeing 737-3H4