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 SWAA2013052016205Door Frame · crackedFWD CARGO DOOR, AFT LOWER FRAME CHAFED AND CRACKED. R & R DOOR IAW AMM & SRM.SDR SWAA2013051516076Flap · delaminatedLEFT WING OUTBOARD MAIN FLAP OUTBOARD TRAILING EDGE CORNER DELAMINATED. REPAIRED MAIN FLAP IAW SRM.SDR SWAA2013050715796Web · crackedWEB CRACKED BETWEEN BS 616 AND BS 639, STR 17L. REMOVED AND REPLACED WEB IAW SRM AND DWG.SDR SWAA2013050715749Support Bracket · crackedSUPPORT BRACKET CRACKED BETWEEN BS 663.75 TO BS 675, BETWEEN RBL 30 TO RBL 40. REMOVED AND REPLACED BRACKET IAW SRM AND DWG.SDR SWAA2013050715724Retainer · crackedAFT CARGO DOOR CUTOUT AFT LOWER RETAINER CRACKED. REMOVED AND REPLACED RETAINER IAW SRM AND DWG.SDR SWAA2013050715723Angle · crackedLEFT WING T/E PANEL INBD OF NR 5 SPOILER OUTBOARD ANGLE CRACKED. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA2013050615661Track · crackedTRACK TIE DOWN CRACKED AT BS 500, LBL 18.2. REPAIRED TRACK TIE IAW EA.SDR SWAA2013042415154Beam · corrodedUNDERSIDE OF NUT PLATE HOLE CORRODED AT BS 807+6, RBL 3. REPAIRED BEAM PER EA.SDR SWAA2013042515206Flap Track · looseLEFT WING INBD FORE TO MID FLAP TRACK LOOSE. REMOVED AND REPLACED TRACK PER M/M.SDR SWAA2013042415077Light · inoperativeAFT ENTRY DOOR LOWER EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2013042415076Light · inoperativeAFT SERVICE DOOR LOWER EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2013042415075Light · inoperativeFORWARD ENTRY DOOR LOWER EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2013050715726Skin · crackedSKIN CRACKED BETWEEN STA 379.5 AND STA 380.5, STR 14R. REPAIRED SKIN IAW EA.SDR SWAA2013050715725Skin · crackedSKIN CRACKED BETWEEN STA 379.5 AND STA 380.5, STR 14R. REPAIRED SKIN IAW EA.SDR SWAA2013041915023Spoiler · delaminatedLEFT WING NR 4 GROUND SPOILER BOARD O\B END DELAMINATED. REMOVED AND REPLACED NR 4 GROUND SPOILER PER AMM.SDR SWAA2013050615660Strap · corrodedINTERNAL STRAP CORRODED AT BS 986.5, BETWEEN STR 27L TO STR 27R. REPAIRED STRAP IAW EA.SDR SWAA2013050215450Angle · crackedANGLE CRACKED AT BS 540, STR 21R. REPAIRED ANGLE IAW SRM.SDR SWAA2013043015362Wedge · delaminatedLEFT WING I/B MID FLAP LOWER SURFACE WEDGE PANEL DELAMINATED. REPAIRED MID FLAP IAW SRM.SDR SWAA2013043015381Fitting · crackedCLIP CRACKED AT BS 178, RBL 25. REMOVED AND REPLACED CLIP IAW SRM AND DRAWING.SDR SWAA2013043015380Angle · crackedLEFT SIDE ANGLE CRACKED AT BS 178, LBL 13.83. REMOVED AND REPLACED ANGLE IAW AND DRAWING.SDR SWAA2013042615269Tie Rod · crackedSTOW BIN TIE ROD CRACKED AT STA 440, STR 8L. REMOVED AND REPLACED TIE ROD IAW SRM.SDR SWAA2013041915032Lens · brokenFORWARD ENTRY DOOR EMERGENCY EXIT LIGHT LENS BROKEN. REMOVED AND REPLACED LENSES PER M/M.SDR SWAA2013050715814Stringer · corrodedSTRINGER CORRODED AT BS 996, STR 25L. REPAIRED STRINGER PER EA.SDR SWAA2013050715813Intercostal · corrodedRIGHT INTERCOSTAL WEB CORRODED BETWEEN BS 927 TO BS 947. REMOVED AND REPLACED WEB PER SRM.SDR SWAA2013050615659Shear Tie · corrodedSHEAR TIE CORRODED AT BS 987, BETWEEN STR 27R TO STR 27L. REMOVED AND REPLACED SHEAR TIE IAW SRM AND EA.SDR SWAA2013050615604Stringer · crackedSTRINGER CRACKED AT STA 380, STR 5L. REPAIRED STRINGER IAW EA.SDR SWAA2013050615603Stringer · damagedSTRINGER DAMAGED AT STA 440, STR 9L. REPAIRED STRINGER IAW EA.SDR SWAA2013042415158Floorbeam · corrodedAFT CARGO FLOORBEAM CORRODED AT BS 858, RBL 11. REMOVED AND REPLACED TRACK PER SRM.SDR SWAA2013042415167Intercostal · shearedAFT SIDE INTERCOSTAL WEB SHEARED AT BS 947, FWD SIDE OF FRAME UNDER RIGHT TRANSITION ANGLE. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA2013042415166Floorbeam · corrodedAFT CARGO FLOORBEAM CORRODED AT BS 858, LBL 11. REPAIRED BEAM PER EA.SDR SWAA2013042415165Floorbeam · corrodedAFT CARGO FLOORBEAM CORRODED AT BS 858, LBL 7. REPAIRED BEAM PER EA.SDR SWAA2013042415164Floorbeam · corrodedAFT CARGO FLOORBEAM CORRODED AT BS 858, LBL 2. REPAIRED BEAM PER EA.SDR SWAA2013042415163Floorbeam · corrodedAFT CARGO FLOORBEAM CORRODED AT BS 858, RBL 3. REPAIRED BEAM PER EA.SDR SWAA2013042415159Floorbeam · corrodedAFT CARGO FLOORBEAM CORRODED AT BS 858, RBL 8. REMOVED AND REPLACED TRACK PER SRM.SDR SWAA2013042415091Rib · crackedRIGHT HORIZONTAL STABILIZER LEADING EDGE RIB CRACKED AT STAB STA 101.90. REMOVED AND REPLACED RIB IAW SRM AND DRAWING.SDR SWAA2013041714903Angle · crackedL-ANGLE AT AFT I/B OF RIGHT WHEEL WELL CUTOUT CRACKED. REMOVED AND REPLACED L-ANGLE IAW SRM.SDR SWAA2013041714902Frame · crackedLEFT WING NR 2 FLAP TRACK FAIRING "A" FRAME CRACKED. REMOVED & REPLACED "A" FRAME PER CMM.SDR SWAA2013050615658Stringer · corrodedSTRINGER CORRODED AT BS 987, STR 27L. REPAIRED STRINGER IAW SRM.SDR SWAA2013043015379Channel · crackedCHANNEL CRACKED BETWEEN BS 616 TO BS 639, STR 2R. REMOVED AND REPLACED CHANNEL IAW SRM AND DRAWING.SDR SWAA2013043015378Web · crackedWEB CRACKED BETWEEN BS 188 TO BS 196.5, STR 17L. REMOVED AND REPLACED WEB IAW SRM AND DWG.SDR SWAA2013041714947Retaining Clip · crackedRIGHT VERTICAL STABILIZER LOWER ACCESS PANEL 9508R RETAINER CLIP CRACKED. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA2013041614868Sign · brokenL1 DOOR EMERGENCY EXIT SIGN BROKEN. REMOVED AND REPLACED SIGN PER M/M.SDR SWAA2013050115416Web · crackedVERTICAL DUCT ASSY WEB CRACKED BETWEEN BS 294.5 TO BS 312, STR 27R. REMOVED AND REPLACED WEB IAW SRM AND DRAWING.SDR SWAA2013042415169Web · crackedWEB CRACKED BETWEEN BS 500B TO BS 500C, STR 26R. REMOVED AND REPLACED WEB IAW SRM AND DRAWING.SDR SWAA2013042415131Sign · looseRIGHT OVERWING EMERGENCY EXIT SIGN LOOSE. SECURED SIGN PER M/M.SDR SWAA2013042415074Skin · crackedFUSELAGE SKIN CRACKED AT BS 940, STR 4L. REPAIRED SKIN IAW SRM.SDR SWAA2013042415073Skin · crackedFUSELAGE SKIN CRACKED AT BS 415, STR 2R. REPAIRED SKIN IAW ER AND EA.SDR SWAA2013042415072Skin · crackedFUSELAGE SKIN CRACKED AT BS 362, STR 8R. REPAIRED SKIN IAW ER AND EA.SDR SWAA2013042415071Power Supply · inoperativeL2 DOOR EMERGENCY LIGHT INOP. REMOVED AND REPLACED POWER SUPPLY PER AMM.SDR SWAA2013041714901Skin · crackedLEFT WING I/B FORE FLAP UPPER SURFACE CRACKED. REPAIRED FORE FLAP IAW SRM.
Back to Boeing 737-3H4