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 SWAA2013120923097Floorbeam · corrodedFLOOR BEAM CORRODED AT BS 328, BL 0. REPAIRED BEAM IAW SRM.SDR SWAA2013120923078Angle · crackedRT WING REAR SPAR AREA ANGLE CRACKED AT RSS 545. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2013120923066Angle · crackedFWD ENTRY DOOR SURROUND STRUCTURE ANGLE CRACKED AT BS 348.2, STRINGER 15L. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2013120923065Web · crackedFWD GALLEY DOOR CUTOUT INTER SURROUND STRUCTURE ATTACHMENT WEB ANGLE CRACKED AT BS 291.5, BETWEEN STRINGER 12R & STRINGER 13R. R & R WEB IAW SRM & DRAWING.SDR SWAA2013120923064Floorbeam · corrodedFLOOR BEAM UPPER CHORD AT THE AFT PAX CABIN FLOOR STRUCTURE CORRODED AT BS 967, BETWEEN RBL 7 & LBL 7. REPAIRED CHORD IAW SRM.SDR SWAA2013120923063Floorbeam · corrodedFLOOR BEAM UPPER CHORD CORRODED AT BS 967, LBL 27.5. REPAIRED CHORD IAW SRM.SDR SWAA2013120523025Attach Angle · crackedFWD GALLEY DOOR CUTOUT SURROUND INTERNAL STRUCTURE ATTACHMENT ANGLE CRACKED AT BS 291.5, BETWEEN STRINGER 8R & STRINGER 9R. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2013120523024Angle · crackedFLIGHT DATA RECORDER SUPPORT STRUCTURE IN THE AFT PAX CABIN ANGLE CRACKED AT BS 967, LBL 18. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2013120422993Web · crackedWEB CRACKED AT BS 328+2, LBL 45. R & R WEB IAW SRM.SDR SWAA2013120422981Angle · crackedRT WING NR 6 FLAP TRACK INTERNAL ANGLE CRACKED. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2013121923533Skin · crackedFUSELAGE SKIN CRACKED AT BS 420 + 12, STRINGER 2R. REPAIRED SKIN IAW EO & EA.SDR SWAA2013121723439Web · crackedLT SIDE NLG WW WEB CRACKED AT BS 243.7+3, WL 169.1. REPAIRED WEB IAW SRM.SDR SWAA2013121623347Floor Support · crackedLONGITUDINAL FLOOR BEAM UPPER CHORD CRACKED AT BS 670, BBL 0.07. REPAIRED CHORD IAW EA.SDR SWAA2013121623307Angle · crackedLT WING TE STRUCTURE ANGLE CRACKED AT WING RSS 175. R & R ANGLE IAW SRM.SDR SWAA2013121623279Web · crackedFWD EDGE INTERNAL AREA OF AFT CARGO DOOR WEB CRACKED AT LOWER EDGE. R & R WEB IAW SRM & DRAWING.SDR SWAA2013121123191Angle · crackedRT WING REAR SPAR AREA ANGLE CRACKED AT RSS 545. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2013120923104Stringer Clip · crackedSTRINGER CLIP CRACKED AT STATION 380, STRINGER 8L. R & R CLIP IAW DRAWING.SDR SWAA2013120923077Splice · crackedLT SPLICE CRACKED AT BS 663.5. R & R SPLICE IAW SRM & DRAWING.SDR SWAA2013120322932Doubler · crackedR2 DOOR UPPER HINGE FUSELAGE CRACKED AT STATION 950, STRINGER 11R. REPAIRED DOUBLER IAW SRM.SDR SWAA2013120322901Power Supply · inoperativeFWD SERVICE DOOR EXTERIOR EMERGENCY EXIT LIGHT INOPERATIVE. R &R POWER SUPPLY IAW AMM.SDR SWAA2013120322896Battery Pack · dischargedR2 DOOR EMERGENCY EXIT LIGHT INOPERATIVE. R & R BATTERY PACK IAW AMM.SDR SWAA2013120222863Gasper Fan · faultyDIVERSION DECLARED EMERGENCY. AT CRUISE SMOKE SMELL BEGAN TO FILL CABIN, GASPER FAN WAS TURNED OFF & IT EASED THE SMELL. R & R GASPER FAN IAW AMM.SDR SWAA2013122623609Bulkhead · corrodedAFT PRESS BULKHEAD WEB CORRODED AT STATION 1016, RBL 1. REPAIRED IAW SWA EA.SDR SWAA2013122023580Stiffener · corrodedAFT PRESSURE BULKHEAD STIFFENER CORRODED AT STATION 1016, BL 0. REPAIRED STIFFENER IAW SWA EA.SDR SWAA2013121923532Skin · crackedRT WING LE INBD FIXED LE SKIN CRACKED AT STATION 208. REPAIRED SKIN IAW EA.SDR SWAA2013121923531Stiffener · crackedBULKHEAD ZEE STIFFENERS CRACKED AT BS 1016, STRINGER 13R. REPAIRED ZEE STIFFENER IAW EA.SDR SWAA2013121923530Keelbeam · corrodedLT KEEL BEAM CORRODED BETWEEN BS 707 TO BS 727. REPAIRED KEEL BEAM IAW EA.SDR SWAA2013121923529Keelbeam · corrodedRT KEEL BEAM CORRODED BETWEEN BS 707 TO BS 727. REPAIRED KEEL BEAM IAW EA.SDR SWAA2013121823480Skin · crackedSKIN CRACKED BETWEEN BS 460 TO BS 500, BETWEEN STRINGER 3R & STRINGER 4R. REPAIRED SKIN IAW EA.SDR SWAA2013121623370Frame · damagedFRAME DAMAGED AT BS 807, STRINGER 23L. REPAIRED FRAME IAW SRM & DRAWING.SDR SWAA2013121623360Floor Support · crackedLONGITUDINAL FLOOR BEAM UPPER CHORD CRACKED AT BS 663+1.5, BBL 0.07. REPAIRED CHORD IAW EA.SDR SWAA2013121623346Stringer Splice · crackedSTRINGER SPLICE CHANNEL CRACKED AT BS 360, STRINGER 16L. R & R CHANNEL IAW SRM & DRAWING.SDR SWAA2013121623345Floor Support · crackedLONGITUDINAL FLOOR BEAM UPPER CHORD CRACKED AT BS 661, BBL 0.07. REPAIRED CHORD IAW EA.SDR SWAA2013121623293Frame · crackedFRAME CRACKED AT BS 500D, RBL 5. REPAIRED FRAME IAW ER & SWA EA.SDR SWAA2013121623278Floor Support · crackedLONGITUDINAL FLOOR BEAM WEB CRACKED AT BS 709, RBL 24.8. REPAIRED WEB IAW EA.SDR SWAA2013121623276Stringer Splice · crackedSTRINGER SPLICE CHANNEL CRACKED AT BS 360, STRINGER 14L. R & R CHANNEL IAW SRM & DRAWING.SDR SWAA2013121623275Angle · crackedRT WING REAR SPAR AREA ANGLE CRACKED AT WBL 198.60. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2013121623274Lens · brokenFWD LAVATORY EMERGENCY EXIT LIGHT LENS BROKEN. R & R LENS IAW AMM.SDR SWAA2013121623273Angle · crackedLT WING AILERON TAB INFERNAL ANGLE CRACKED AT RSS 533+12. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2013121223258Tie Clip · crackedTIE CLIP CRACKED AT BS 277, STRINGER 10R. R & R TIE CLIP IAW SRM & DRAWING.SDR SWAA2013121123192Bulkhead · crackedFWD PRESSURE BULKHEAD CRACKED AT BS 178, LBL 5.7. REPAIRED BULKHEAD IAW SRM.SDR SWAA2013121123168Hinge · brokenLT WING NR 4 SPOILER HINGE BROKEN. R & R SPOILER IAW MM.SDR SWAA2013120923121Stringer Splice · crackedSTRINGER SPLICE CRACKED AT STATION 907, STRINGER 11R. REPAIRED SPLICE IAW SRM & DRAWING.SDR SWAA2013120322900Cover · looseFWD ENTRY EMERGENCY EXIT COVER LOOSE. SECURED COVER IAW SIP.SDR SWAA2013122023579Floorbeam · corrodedFLOOR BEAM CORRODED AT STATION 989.5, LBL 15 TO RBL 46. REPAIRED BEAM IAW SWA EA.SDR SWAA2013121823479Fitting · crackedFITTING CRACKED BETWEEN BS 291.3 & BS 294.3, STRINGER 8R. R & R FITTING IAW EA.SDR SWAA2013121823478Door Frame · crackedFWD GALLEY DOOR STUB FRAME CUT OUT CRACKED AT BS 296.4, BETWEEN STRINGER 7R & STRINGER 10R. REPAIRED STUB FRAME IAW EO & EA.SDR SWAA2013121623344Web · crackedWEB CRACKED BETWEEN BS 294.5 TO BS 312, STRINGER 4L. R & R WEB IAW SRM & DRAWING.SDR SWAA2013121623343Floorbeam · corrodedFLOOR STRUCTURE BEAM CORRODED AT BS 344, BETWEEN LBL 7 & LBL 9. REPAIRED BEAM IAW SRM.SDR SWAA2013121623292Skin · damagedSKIN DAMAGED AT BS 727, STRINGER 26L. REPAIRED SKIN IAW ER & SWA EA.
Back to Boeing 737-3H4