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 SWAA2013041514835Stringer Splice · corrodedSTRINGER SPLICE CORRODED AT BS 360+4, STR 27L. REMOVED AND REPLACED SPLICE IAW SRM AND DWG.SDR SWAA2013041514834Skin · crackedLEFT WING INBOARD FORE FLAP CRACKED AT 16IN OF INBOARD END ON LOWER SURFACE. REPAIRED FORE FLAP IAW SRM.SDR SWAA2013041214769Floorbeam · crackedFLOORBEAM UPPER CHORD CRACKED AT BS 312, RBL 34. REPAIRED CHORD IAW SRM.SDR SWAA2013041214768Web · crackedWEB CRACKED BETWEEN BS 312 AND BS 328, LBL 46. REMOVED AND REPLACED WEB IAW SRM AND DRAWING.SDR SWAA2013041014663Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 294.5, STR 23L. REMOVED AND REPLACED CLIP IAW SRM AND DRAWING.SDR SWAA2013041014662Web · crackedWEB CRACKED BETWEEN BS 747 TO BS 767, STR 25R. REMOVED AND REPLACED WEB IAW SRM.SDR SWAA2013041014661Angle · crackedANGLE CRACKED AT BS 380, BETWEEN STR 20L AND STR 21L. REMOVED AND REPLACED ANGLE IAW SRM.SDR SWAA2013041014648Shear Tie · corrodedSHEAR TIE CORRODED AT BS 360, BETWEEN STR 27L AND STR 28L. REMOVED AND REPLACED SHEAR TIE IAW SRM & DRAWING.SDR SWAA2013042014647Panel · crackedAFT WING TO BODY FAIRING PANEL 3578L CRACKED. REPAIRED PANEL IAW SRM.SDR SWAA2013041014646Strap · crackedSTRAP CRACKED AT BS 328, RBL 45.5. REMOVED AND REPLACED STRAP IAW SRM AND DRAWING.SDR SWAA2013041014645Strap · crackedSTRAP CRACKED AT BS 328, BL 0. REMOVED AND REPLACED STRAP IAW SRM AND DRAWING.SDR SWAA2013041014644Web · crackedWEB CRACKED BETWEEN BS 344 TO BS 360, BL 0. REMOVED AND REPLACED WEB IAW SRM AND DRAWING.SDR SWAA2013040914607Strap · crackedSTRAP CRACKED AT BS 328+ 2, LBL 45.5. REMOVED AND REPLACED STRAP IAW SRM AND DRAWING.SDR SWAA2013040914606Support Angle · crackedSUPPORT ANGLE CRACKED BETWEEN BS 344 TO BS 360, LBL 10. REMOVED AND REPLACED ANGLE IAW SRM AND DRAWING.SDR SWAA2013040914584Tie Clip · crackedTIE CLIP CRACKED AT BS 380, STR 26R. REMOVED AND REPLACED TIE CLIP IAW SRM AND DRAWING.SDR SWAA2013040914581Tie Clip · crackedTIE CLIP CRACKED AT BS 380, STR 22L. REMOVED AND REPLACED TIE CLIP IAW SRM AND DRAWING.SDR SWAA2013040914580Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 351.5, STR 26R. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA2013040914579Tie Clip · crackedTIE CLIP CRACKED AT BS 380, STR 21L. REMOVED AND REPLACED TIE CLIP IAW SRM AND DRAWING.SDR SWAA2013040414474Web · crackedWEB CRACKED BETWEEN BS 259.5 TO BS 312, BETWEEN STR 27L TO STR 27R. REMOVED AND REPLACED WEB IAW SRM AND DWG.SDR SWAA2013040414473Angle · crackedANGLE CRACKED BETWEEN BS 259.5 TO BS 312, STR 27L. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA2013040414481Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 380, STR 8L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA2013040314453Angle · crackedANGLE CRACKED AT BS 336, STR 21L. REMOVED AND REPLACED ANGLE IAW SRM AND DRAWING.SDR SWAA2013040314452Angle · crackedANGLE CRACKED AT BS 320, STR 21L. REMOVED AND REPLACED ANGLE IAW SRM AND DRAWING.SDR SWAA2013040314451Web · crackedWEB CRACKED BETWEEN BS 500A TO BS 500B, STR 26R. REMOVED AND REPLACED WEB IAW SRM AND DRAWING.SDR SWAA2013040314450Tie Clip · crackedTIE CLIP CRACKED AT BS 927, STR 21L. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2013040214398Glowstrip · loosePHOTO LUMINSCENT FLOOR PROXIMITY EMERGENCY ESCAPE PATH MARKING LIGHT LOOSE. SECURED EEPLS PER MM.SDR SWAA2013050115402Structure · crackedRIGHT WING UPPER CHORD CRACKED AT BS 114.00, S-2. REPAIRED CHORD IAW EO AND EA.SDR SWAA2013041714899Attach Fitting · crackedATTACH CLIP CRACKED AT BS 348.2, STR 15L. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA2013041714898Hinge · crackedL1 DOOR SHIELD HINGE ON FLAP ASSY CRACKED. REMOVED AND REPLACED SHIELD HINGE IAW SRM.SDR SWAA2013041714897Web · crackedWEB CRACKED AT BS 718, BL 0. REMOVED AND REPLACED WEB IAW SRM AND DRAWING.SDR SWAA2013040914583Stiffener · crackedSTIFFENER CRACKED AT BS 947.5+10, BETWEEN STR 24L TO STR 26L. REMOVED AND REPLACED STIFFENER IAW SRM AND DRAWING.SDR SWAA2013040914582Stiffener · crackedSTIFFENER CRACKED AT BS 947.5+6, BETWEEN STR 24L TO STR 26L. REMOVED AND REPLACED STIFFENER IAW SRM AND DRAWING.SDR SWAA2013040914578Web · crackedWEB CRACKED AT BS 794.3, STR 25R. REMOVED AND REPLACED WEB IAW SRM AND DWG.SDR SWAA2013040914560Skin · crackedSKIN CRACKED AT BS 380-1, STR 14R. REPAIRED SKIN IAW SRM & EA.SDR SWAA2013040114331Skin · crackedFUSELAGE SKIN CRACKED AT BS 727A + 10 2.4, STR 10R. REPAIRED SKIN PER EA.SDR SWAA2013040114328Skin · crackedFUSELAGE SKIN CRACKED AT BS 420 + 12, STR 10R. REPAIRED SKIN PER EA.SDR SWAA2013040114318Pan · crackedLEFT PYLON HEAT SHIELD STRUT FAIRING PAN CRACKED. REPAIRED PAN IAW EA.SDR SWAA2013040114277Skin · crackedFUSELAGE SKIN CRACKED AT BS 807+9, STR 4R. REPAIRED SKIN PER EA.SDR SWAA2013040114276Skin · crackedFUSELAGE SKIN CRACKED AT BS 787+6, STR 4R. REPAIRED SKIN PER EA.SDR SWAA2013032814241Slide · out of positionL2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER M/M.SDR SWAA2013042615277Structure · crackedLEFT HORIZONTAL STABILIZER LOWER CHORD CRACKED AT STA 120.30. REPAIRED CHORD IAW EO AND EA.SDR SWAA2013042615276Skin · crackedSKIN CRACKED AT BS 500C+5, STR 8R. REPAIRED SKIN IAW EA.SDR SWAA2013042415067Tie Clip · crackedTIE CLIP CRACKED AT BS 947.5, STR 25R. REMOVED AND REPLACED TIE CLIP IAW EA.SDR SWAA2013042415066Web · crackedWEB CRACKED AT BS 712, LBL 4. REMOVED AND REPLACED WEB IAW SRM AND DWG.SDR SWAA2013042415065Frame · corrodedFRAME CORRODED AT BS 727E, BETWEEN 27R TO STR 27L. REPAIRED FRAME IAW SRM.SDR SWAA2013041014637Retainer · crackedRIGHT AIR CONDITIONING ACCESS PANEL 3403R SEAL RETAINER CRACKED. REMOVED AND REPLACED RETAINER IAW SRM & DRAWING.SDR SWAA2013040414472Tie Clip · crackedTIE CLIP CRACKED AT BS 420, STR 27L. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2013040314449Lens · brokenFWD EMERGENCY EXIT LENS BROKEN. REMOVED AND REPLACED LENS IAW AMM.SDR SWAA2013040314448Tie Clip · crackedTIE CLIP CRACKED AT BS 727A, STR 26L. REMOVED AND REPLACED TIE CLIP IAW SRM & DWG.SDR SWAA2013040314447Tie Clip · crackedTIE CLIP CRACKED AT BS 927, STR 25R. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.
Back to Boeing 737-3H4