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 SWAA2013032113950Skin · crackedAFT CARGO COMPARTMENT DOOR SKIN CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2013031313596Sill · crackedSILL WEB CRACKED AT STA 328+7", STR 17L. REMOVED AND REPLACED WEB PER SRM.SDR SWAA2013031313580Support Angle · crackedCRACK ON SUPPORT ANGLE LOCATED ON INTERNAL AREA FLAP TRACK NR 3 AT LEFT WING. REMOVED AND REPLACED SUPPORT ANGLE PER SRM.SDR SWAA2013031113537Skin · crackedFUSELAGE SKIN CRACKED AT STA 500D+5.7, STR 16L. REPAIRED SKIN PER SRM.SDR SWAA2013031113536Skin · crackedFUSELAGE SKIN CRACKED AT STA 500A, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA2013031113535Skin · crackedFUSELAGE SKIN CRACKED AT STA 974, STR 21L. REPAIRED SKIN PER SRM.SDR SWAA2013031513459Angle · crackedNR 6 FLAP TRACK ANGLE, INTERNAL AREA SIDE OF THE DOOR, RIGHT WING CRACKED. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA2013030513342Mount · brokenEMERGENCY EXIT LIGHT ON GALLEY G-1 MOUNTING BASE IS BROKEN. REMOVED & REPLACED BASE IAW AMM.SDR SWAA2013030513330Cover · brokenFWD ENTRY EMERGENCY EXIT LAMP COVER BROKEN. REMOVED & REPLACED COVER PER MM.SDR SWAA2013030413316Sign · unsecureRIGHT OVERWING EXIT SIGN NEEDS RE-SECURING. SECURED SIGN PER M/M.SDR SWAA2013030413315Light · brokenL1 DOOR EMERGENCY EXIT LIGHT BROKEN. REMOVED AND REPLACED LIGHT ASSY PER AMM.SDR SWAA2013032113954Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 341, BETWEEN STR 16L AND STR 17L. REMOVED AND REPLACED ANGLE IAW SRM.SDR SWAA2013031313599Channel · crackedCHANNEL CRACKED AT STA 540, BL 0 TO LBL 24.7. REMOVED AND REPLACED CHANNEL PER SRM.SDR SWAA2013031113546Skin · crackedLEFT WING LEADING EDGE SKIN AT WBL 208 CRACKED. REPAIRED LEADING EDGE PER EA.SDR SWAA2013030413238Slide · out of positionL2 DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT. RE-INSTALLED SLIDE IAW MT.SDR SWAA2013030413255Window · crackedAT TOP OF DESCENT CAPTAIN'S L1 WINDOW SHATTERED WITH VISIBLE ARCED. REMOVED AND REPLACED WINDOW PER MM.SDR SWAA2013031413617Support Angle · crackedSUPPORT ZEE ANGLE AT STA 847 AND BETWEEN STR 24L AND STR 25L CRACKED. REMOVED AND REPLACED ZEE ANGLE PER SRM.SDR SWAA2013030413233Attach Fitting · brokenLEFT WING GROUND SPOILER (NR 4) ATTACH FITTING BROKEN. REMOVED AND REPLACED SPOILER PER MM.SDR SWAA2013032113953Flap · delaminatedLEFT WING I/B FORE FLAP DELAMINATED. REPAIRED FORE FLAP IAW SRM.SDR SWAA2013032113949Skin · crackedSKIN CRACKED AT BS 958.5, BETWEEN STRINGER 16L AND STRINGER 17L. REPAIRED SKIN IAW EA.SDR SWAA2013031913787Web · crackedWEB CRACKED BETWEEN BS 927 TO BS 947.5+5, BETWEEN STR 10R TO STR 15R. REMOVED AND REPLACED WEB IAW SRM AND DWG.SDR SWAA2013031113532Stringer Clip · crackedSTRINGER CLIP CRACKED AT STA 380, STR 21L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA2013030713430Tie Clip · crackedCRACK ON TIE CLIP AT BS 380, STR 26L. REMOVED AND REPLACED CLIP IAW SRM.SDR SWAA2013030613366Tie Clip · crackedCRACK ON TIE CLIP AT BS 380 AT LEVEL STR 22L. REMOVED AND REPLACED CLIP IAW SRM.SDR SWAA2013030613365Tie Clip · crackedCRACK ON TIE CLIP AT BS 380 AT LEVEL STR 20L. REMOVED AND REPLACED TIE CLIP IAW SRM.SDR SWAA2013030413303Controller · faultyL1 WINDOW ARCING AND CRACKED. REMOVED AND REPLACED L1 WINDOW HEAT CONTROLLER PER MM.SDR SWAA2013030113204Slide · out of adjustAFT SERVICE DOOR OUTER HANDLE DOES NOT AUTO STOW WHEN DOOR SHUT FROM OUTSIDE. ADJUSTED SLIDE PER M/M.SDR SWAA2013040114315Skin · crackedSKIN CRACKED AT BS 727B+4, STR 1R. REPAIRED SKIN IAW EA.SDR SWAA2013040114314Skin · crackedSKIN CRACKED AT BS 727C+4, STR 1R. REPAIRED SKIN IAW EA.SDR SWAA2013040114293Web · crackedRIGHT NLG WHEEL WELL WEB CRACKED AT BS 243.7+3.5, WL 169.1. REPAIRED WEB IAW EO AND EA.SDR SWAA2013040114245Duct · crackedDUCT ASSY CRACKED BETWEEN BS 294.5 TO BS 312, BETWEEN STR 26R TO STR 26L. REPAIRED DUCT ASSY IAW EA.SDR SWAA2013040114264Web · crackedRIGHT NLG WHEEL WELL WEB CRACKED AT BS 243.7+4.5, WL 169.1. REPAIRED WEB IAW EO AND EA.SDR SWAA2013032214023Skin · crackedFUSELAGE SKIN CRACKED AT BS 500D + 4, STR 16L. REPAIRED SKIN IAW EA.SDR SWAA2013032113952Flap · corrodedRIGHT WING O/B MID FLAP CORRODED. REMOVED AND REPLACED MID FLAP IAW AMM.SDR SWAA2013032113948Web · crackedWEB CRACKED AT BS 277, STR 16L. REPAIRED WEB IAW EA.SDR SWAA2013032113939Skin · crackedRIGHT WING LEADING EDGE SKIN CRACKED AT FS 542. REPAIRED SKIN IAW SRM.SDR SWAA2013031913820Frame · corrodedFRAME CORRODED AT BS 727E, BETWEEN STR 27R TO STR 27L. REPAIRED FRAME IAW SRM.SDR SWAA2013031913789Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 312+9, STR 21L. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA2013031913788Skin · crackedRIGHT WING INBOARD FIXED LEADING EDGE SKIN CRACKED. REPAIRED SKIN IAW SRM.SDR SWAA2013031813750Angle · crackedANGLE CRACKED AT BS 348.2, STR 15L. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA2013031413618Angle · crackedANGLE ATTACH CLIP AT STA 348.2, STR 15L CRACKED. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA2013031413616Support Angle · crackedSUPPORT ANGLE AT STA 312, STR 21L E/E COMPARTMENT CRACKED. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA2013031413615Angle · crackedRIGHT WING INBD FIXED CRACKED AT L/E ANGLE AT STA 190. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA2013031313597Support Angle · crackedSUPPORT ANGLE CRACKED AT STA 328+9", STR 21L. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA2013031313595Shear Tie · corrodedSHEAR TIE CORRODED AT STA 344 BETWEEN STR 26R & STR 27R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA2013031113545Support Angle · crackedSUPPORT ANGLE AT BS 351, E/E COMPARTMENT CRACKED. REMOVED AND REPLACED SUPPORT ANGLE PER SRM.SDR SWAA2013031113544Angle · crackedANGLE AT BS 294.5, STR 23L CRACKED. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA2013031113543Shear Tie · corrodedSHEAR TIE FRAME AT BS 344, STR 27R CORRODED. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA2013031113530Stringer Splice · crackedSTRINGER SPLICE CRACKED AT STA 348.2 TO STA 367, STR 15L. REMOVED AND REPLACED STR SPLICE PER SRM.SDR SWAA2013031113529Support Fitting · crackedSUPPORT CLIP CRACKED AT STA 294.5, STR 23L. REMOVED AND REPLACED CLIP PER SRM.
Back to Boeing 737-3H4