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 SWAA2013050615593Frame · corrodedFRAME CORRODED AT BS 500B, BETWEEN STR 28R TO STR 28L. REPAIRED FRAME IAW SRM.SDR SWAA2013050615592Frame · corrodedFRAME CORRODED AT BS 500A, BETWEEN STR 28R TO STR 28L. REPAIRED FRAME IAW SRM.SDR SWAA2013050215458Seat Track · crackedSEAT TRACK INBOARD FLANGE CRACKED AT BS 520, LBL 24.5. REPAIRED SEAT TRACK IAW EO.SDR SWAA2013050115430Support Angle · crackedRIGHT WING SUPPORT ANGLE CRACKED AT WBL 71.24 TRAILING EDGE AREA. REMOVED AND REPLACED ANGLE IAW SRM AND DRAWING.SDR SWAA2013050115429Web · crackedWEB CRACKED AT BS 520+6, BETWEEN STR 21L TO STR 24L. REMOVED AND REPLACED WEB IAW SRM AND DWG.SDR SWAA2013050115426Rib · crackedLEFT WING RIB LOWER CHORD BETWEEN STRINGER 2 AND STRINGER 3 OF WBL 135.5 CRACKED. REPAIRED CHORD IAW EA.SDR SWAA2013043015345Frame · corrodedFRAME CORRODED AT BS 727E, BETWEEN STR 25L TO STR 26L. REPAIRED FRAME IAW SRM.SDR SWAA2013043015372Strip · crackedACCESS PANEL AFT EDGE STRIP CRACKED ON NR 3403R. REMOVED AND REPLACED STRIP IAW SRM AND DRAWING.SDR SWAA2013042915321Support Angle · crackedSUPPORT ANGLE CRACKED BETWEEN BS 500D TO BS 520, BL 0. REMOVED AND REPLACED ANGLE IAW SRM.SDR SWAA2013042615307Roller · corrodedLEFT WING NR 2 SLAT TRACK CORRODED ON ROLLER. REMOVED AND REPLACED ROLLER IAW AMM.SDR SWAA2013042615275Stringer · corrodedSTRINGER CORRODED BETWEEN BS 460 AND BS 480, STR 27R. REMOVED AND REPLACED STRINGER IAW SRM AND DRAWING.SDR SWAA2013042415173Support Channel · crackedSUPPORT CHANNEL CRACKED AT BS 727A, BETWEEN STR 25R TO STR 26R. REMOVED AND REPLACED CHANNEL IAW SRM & DRAWING.SDR SWAA2013042415172Stiffener · crackedSTIFFENER CRACKED AT BS 727, STR 27L. REMOVED AND REPLACED STIFFENER IAW SRM AND DRAWING.SDR SWAA2013041915035Channel · crackedCHANNEL CRACKED AT BS 540, BETWEEN RBL 24.7 TO RBL 45.5. REMOVED AND REPLACED CHANNEL IAW SRM & DRAWING.SDR SWAA2013041814988Tie Clip · crackedTIE CLIP CRACKED AT BS 727A, STR 25L. REMOVED AND REPLACED TIE CLIP IAW SRM AND DRAWING.SDR SWAA2013041214792Rub Strip · missingRUB STRIP MISSING AT INTERNAL AREA OF CUT OUT OF PYLON ACCESS PANEL 5724L NR 1 ENGINE. INSTALLED RUB STRIP IAW DWG.SDR SWAA2013041214781Tie Clip · crackedTIE CLIP CRACKED AT BS 727B, STR 25R. REMOVED AND REPLACED TIE CLIP IAW SRM.SDR SWAA2013041014716Angle · crackedANGLE CRACKED AT BS 328, LBL 46. REMOVED AND REPLACED ANGLE IAW SRM AND DRAWING.SDR SWAA2013040814543Cover · brokenFORWARD LEFT EMERGENCY EXIT SIGN COVER PLATE BROKEN. REMOVED & REPLACED LIGHT ASSY PER MM.SDR SWAA2013050715755Floorbeam · crackedFLOORBEAM UPPER CHORD CRACKED AT BS 947.5, LBL 53.5. REPAIRED CHORD IAW EO AND EA.SDR SWAA2013050215457Frame · crackedFRAME CRACKED AT BS 947.5, BETWEEN STR 24R TO STR 25R. REMOVED AND REPLACED FRAME IAW SRM AND DRAWING.SDR SWAA2013050115428Support · corrodedSUPPORT Z CORRODED BETWEEN BS 727 TO BS 827, STR 25L. REMOVED AND REPLACED SUPPORT "Z" IAW SRM AND DWG.SDR SWAA2013042915318Floorbeam · corrodedFLOORBEAM CORRODED AT BS 986.5, RBL 43.5. REPAIRED BEAM IAW SRM.SDR SWAA2013042415181Web · crackedWEB CRACKED BETWEEN BS 344 TO BS 360, LBL 2.5. REMOVED AND REPLACED WEB PER SRM AND DRAWING.SDR SWAA2013042415180Support Angle · crackedSUPPORT ANGLE CRACKED BETWEEN BS 344 TO BS 360, LBL 12. REMOVED AND REPLACED ANGLE IAW SRM AND DRAWING.SDR SWAA2013042415179Floorbeam · crackedFLOORBEAM UPPER CHORD CRACKED AT BS 328, LBL 24. REPAIRED CHORD IAW SRM.SDR SWAA2013042415178Floorbeam · crackedFLOORBEAM UPPER CHORD CRACKED AT BS 312, RBL 24. REPAIRED CHORD PER SRM.SDR SWAA2013042415177Sill · crackedFWD GALLEY SILL WEB CRACKED AT BS 294.5+3, STR 17R. REMOVED AND REPLACED WEB IAW SRM AND DWG.SDR SWAA2013042415171Skin · crackedSKIN CRACKED AT BS 715 AND STR 27L. REPAIRED SKIN IAW SRM.SDR SWAA2013042415112Bulkhead · crackedVERTICAL BEAMS WEB CRACKED AT BS 178, LBL 17. REMOVED AND REPLACED WEB IAW EA.SDR SWAA2013042415111Structure · wornRIGHT WING NR 6 SLAT INBOARD SLAT TRACK CAN INTERIOR SURFACE OF CAN WORN. REMOVED AND REPLACED NR 6 I/B SLAT CAN IAW EA.SDR SWAA2013042415084Stiffener · crackedSTIFFENER CRACKED LOCATED AFT STRUT FAIRING LOWER SURFACE OF ENGINE NR 1. REMOVED AND REPLACED STIFFENER IAW SRM AND DRAWING.SDR SWAA2013041915033Angle · crackedLEFT WING AILERON ANGLE CRACKED AT LEVEL OF RSS 533 INTERIOR CAVITY. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA2013041814968Stiffener · crackedNR 6 INBD SIDE RT PYLON STIFFENER CRACKED AT ON FLAP TRACK FAIRING. REMOVED AND REPLACED STIFFENER IAW SRM AND DWG.SDR SWAA2013041514824Web · crackedWEB CRACKED BETWEEN BS 312 TO BS 328, RBL 34. REMOVED AND REPLACED WEB IAW SRM AND DRAWING.SDR SWAA2013040814523Lens · looseFWD GALLEY RIGHT LOWER EMERGENCY EXIT LIGHT COVER LOOSE. SECURED LENS COVER PER M/M.SDR SWAA2013040814511Controller · faultyR2 SLIDING WINDOW ARCED AND CRACKED AT BOTTOM OF WINDOW AND BOTTOM CORNERS. REMOVED AND REPLACED WINDOW CONTROLLER AND REMOVED AND REPLACED F/O'S SLIDING WINDOW (R2) IAW M/M.SDR SWAA2013052116315Pressure Deck · crackedMAIN WHEEL WELL PRESSURE DECK CRACKED AT BS 672.75, LBL 42. REPAIRED WEB IAW EO AND EA.SDR SWAA2013052116314Beam · crackedSTUB BEAM CRACKED AT BS 685, BETWEEN LBL 45.57 AND LBL 60.5. REPAIRED BEAM IAW EA.SDR SWAA2013052116311Pressure Deck · crackedMAIN WHEEL WELL PRESSURE DECK CRACKED AT BS 665.75, LBL 42.5. REPAIRED WEB IAW EO.SDR SWAA2013052116310Pressure Deck · crackedMAIN WHEEL WELL PRESSURE DECK CRACKED AT BS 665.25, LBL 39. REPAIRED WEB IAW EO AND EA.SDR SWAA2013052116309Floor Support · crackedLONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 663.75+8, LBL 24.5. REPAIRED BEAM IAW EA.SDR SWAA2013052116302Beam · crackedSTUB FRAME CRACKED AT BS 706, BETWEEN RBL45.5 TO RBL 60.5. REPAIRED BEAM IAW EA.SDR SWAA2013051616107Beam · crackedSTUB BEAM CRACKED AT BS 706, BETWEEN LBL 45.57 AND LBL 60.5. REPAIRED STUB BEAM IAW EO AND EA.SDR SWAA2013051516077Structure · crackedRIGHT SIDE CRACKED LOWER CHORD LOCATED AT MAIN LANDING GEAR BAY AT BS 680. REMOVED AND REPLACED CHORD IAW SRM AND DRAWING.SDR SWAA2013051315935Floor Support · crackedLONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 663.75, RBL 24.5. REPAIRED CHORD IAW EA.SDR SWAA2013051315932Skin · crackedRIGHT WING NR 5 SLAT LOWER SURFACE CRACKED. REPAIRED NR 5 SLAT IAW SRM.SDR SWAA2013050715810Skin · crackedRIGHT WING NR 6 SLAT LOWER SURFACE CRACKED. REPAIRED NR 6 SLAT IAW SRM.SDR SWAA2013050715757Frame · crackedFRAME CRACKED AT BS 616, BETWEEN STR 8L AND STR 9L. REPAIRED FRAME IAW EA.SDR SWAA2013050715710Skin · crackedLEFT WING NR 1 SLAT LOWER SURFACE CRACKED. REPAIRED SKIN IAW SRM.
Back to Boeing 737-3H4