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 SWAA2013032514035Splice · crackedSPLICE FITTING CRACKED AT BS 360, STR 5L. REMOVED AND REPLACED SPLICE FITTING IAW SRM AND DWG.SDR SWAA2013032113977Skin · crackedFUSELAGE SKIN CRACKED AT BS 500B+13, STR 1L. REPAIRED SKIN PER EA.SDR SWAA2013032113920Skin · crackedFUSELAGE SKIN CRACKED AT BS 727A+6, STR 4R. REPAIRED SKIN PER EA.SDR SWAA2013031913779Skin · crackedFUSELAGE SKIN CRACKED BS 259.5, STR 23L. REPAIRED SKIN PER SRM.SDR SWAA2013031513693Fire Detector · faultyAIR TURNBACK / DECLARED EMERGENCY. FWD CARGO COMPARTMENT FIRE WARN ALARM SOUNDED. C/W WITH FWD CARGO COMPT INSPECTION. NO DEFECT FOUND. REMOVED AND REPLACED FIRE WARN NR 1, 2, 3 & 4 DETECTORS PER MM.SDR SWAA2013041514844Nut Plate · crackedCRACK ON NUT STRIP LOCATED UNDER ACCESS PANEL 58710R UPPER PYLON AREA ENGINE 2. REMOVED AND REPLACED NUT STRIP IAW SRM AND DRAWING.SDR SWAA2013040114340Retainer · crackedRIGHT WING TO BODY FAIRING RETAINER CRACKED BETWEEN BS 697 TO BS 727, STR 22R. REMOVED AND REPLACED RETAINER IAW SRM AND DWG.SDR SWAA2013040114334Rub Strip · crackedRUB STRIP LOCATED ON INTERNAL STRUCTURE OF ACCESS PANEL 5847R FWD STRUT FAIRING AREA ENGINE NR 2 CRACKED. REMOVED AND REPLACED RUB STRIP IAW SRM AND DRAWING.SDR SWAA2013032013862Angle · crackedRIGHT AILERON BALANCE BAY HORIZ ANGLE AT NR 2 HINGE CRACKED. REMOVED AND REPLACED ANGLE PER EA.SDR SWAA2013032013861Light · inoperativeLEFT CABIN EMERGENCY EXIT LIGHT INOP AT ROW 21. REMOVED AND REPLACED LAMP PER MM.SDR SWAA2013032013866Access Panel · corrodedACCESS PANEL 1506L LOCATED ON LOWER FUSELAGE OF APU DUCT CORRODED. REMOVED AND REPLACED PANEL PER SRM.SDR SWAA2013032013864Fairing · delaminatedRIGHT WING FAIRING DELAMINATED I/B SIDE. REPAIRED FAIRING PER SRM.SDR SWAA2013032013863Angle · crackedRIGHT WING AILERON BALANCE BAY VERTICAL ANGLE AT NR 2 HINGE CRACKED. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA2013032013845Window · arcedR1 WINDOW OUTER PANE ARCED. REMOVED AND REPLACED R1 WINDOW PER MM.SDR SWAA2013031513682Light · inoperativeEMERGENCY EXIT LIGHT AFT OF L2 DOOR INOP. RELAMPED PER AMM.SDR SWAA2013041514843Nut Plate · crackedCRACK ON NUT STRIPS LOCATED INTERNAL AREA OF ACCESS PANEL 57710L ENGINE NR 1. REMOVED AND REPLACED NUT STRIPS IAW SRM AND DWG.SDR SWAA2013041514842Floor Support · crackedLONGITUDINAL FLOORBEAM WEB CRACKED AT BS 707, LBL 24.5. REPAIRED WEB PER EA.SDR SWAA2013040914617Skin · crackedLEFT WING NR 3 SLAT SKIN CRACKED LOCATED AT STA 122 OUTBOARD EDGE LOWER SURFACE. REPAIRED SKIN IAW SRM.SDR SWAA2013040114333Skin · crackedLEFT WING NR 2 SLAT EXTERNAL SKIN CRACKED BETWEEN SLAT STA 216 AND SLAT STA 217 LOWER SURFACE. REPAIRED SKIN IAW SRM.SDR SWAA2013031513690Hook · out of adjustR2 DOOR SLIDE GIRT BAR HARD OPERATE. ADJUSTED GIRT BAR HOOKS PER MM.SDR SWAA2013031413661Stringer Clip · damagedSTRINGER CLIP DAMAGED AT STA 312, STR 1. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA2013031413660Stringer Clip · damagedSTRINGER CLIP DAMAGED AT STA 294, STR 4R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA2013031313571Actuator · leakingAIR TURNBACK, HYD B-SYS QTY LOSS WITH LOW PRESSURE LIGHT INDICATION. FOUND NR 7 SPOILER ACT LEAKING. REMOVED AND REPLACED ACTUATOR PER MM.SDR SWAA2013040914585Web · crackedWEB CRACKED AT BS 847, BETWEEN STR 18R TO STR 25R. REMOVED AND REPLACED WEB IAW SRM.SDR SWAA2013040314461Stop Fitting · crackedRIGHT OVERWING DOOR CUTOUT STOP PAD FITTING CRACKED. REMOVED AND REPLACED FITTING IAW SRM.SDR SWAA2013040314426Bracket · crackedLEFT WING BRACKET CRACKED AT WBL 198.60. REMOVED AND REPLACED BRACKET IAW SRM AND DWG.SDR SWAA2013040114339Angle · crackedRIGHT WING FIXED TRAILING EDGE ANGLE CRACKED AT WBL 181.15. REMOVED AND REPLACED ANGLE IAW SRM AND DRAWING.SDR SWAA2013032614138Stringer Clip · corrodedSTRINGER CLIP CORRODED AT BS 360, STR 22L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA2013032614137Stringer Clip · corrodedSTRINGER CLIP CORRODED AT BS 351, STR 22L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA2013032614112Slat · delaminatedRIGHT WING NR 5 SLAT I/B END DELAMINATED. REPAIRED SLAT IAW SRM.SDR SWAA2013032614111Support Angle · crackedLEFT WING SUPPORT ANGLE CRACKED AT TRAILING EDGE LOWER SURFACE AT WBL 198.60. REMOVED AND REPLACED ANGLE IAW SRM.SDR SWAA2013032113915Angle · crackedRIGHT WING FIXED TRAILING EDGE ANGLE CRACKED, WBL 71.24. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA2013031513691Skin · crackedFUSELAGE SKIN CRACKED AT BS 500D+11, STR 10L. REPAIRED SKIN PER EA.SDR SWAA2013040114272Structure · wornRIGHT WING NR 6 SLAT I/B SLAT CAN WORN. REMOVED AND REPLACED SLAT I/B CAN IAW EA.SDR SWAA2013032814216Skin · crackedRIGHT BS 867+10 LOWER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3 AND NR 8. REPAIRED SKIN IAW EA.SDR SWAA2013032614136Fitting · corrodedKEEL BEAM CLIP CORRODED AT BS 767, STR 27L. REMOVED AND REPLACED CLIP IAW SRM.SDR SWAA2013032614135Stringer Clip · corrodedSTRINGER CLIP CORRODED AT BS 767, STR 26R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA2013032614134Fitting · corrodedKEEL BEAM CLIP CORRODED AT BS 767, STR 27R. REMOVED AND REPLACED CLIP IAW SRM.SDR SWAA2013032514034Skin · crackedRIGHT BS 807+10 LOWER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 2. REPAIRED SKIN IAW SB.SDR SWAA2013032514033Skin · crackedRIGHT BS 767+10 LOWER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLES 2, 3. REPAIRED SKIN IAW SRM.SDR SWAA2013031913810Angle · crackedRIGHT WING ANGLE CRACKED. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA2013031913841Skin · crackedRIGHT BS 847+10 LOWER FORWARD WINDOW SKIN CUTOUT CRACKED. REPAIRED SKIN IAW SB.SDR SWAA2013040114327Skin · crackedLEFT BS 500C+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 3, 5. REPAIRED SKIN IAW EA.SDR SWAA2013040114326Skin · crackedLEFT BS 360+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 2, 3. REPAIRED SKIN IAW EA.SDR SWAA2013040114348Skin · crackedLEFT BS 360+10 UPPER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLES 3, 4, 5. REPAIRED SKIN IAW EA.SDR SWAA2013040114274Skin · crackedLEFT BS 520+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 4, 5 ,6, 7. REPAIRED SKIN IAW EA.SDR SWAA2013040114273Skin · crackedLEFT BS 380+10 UPPER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLES 1, 5. REPAIRED SKIN IAW EA.SDR SWAA2013032814215Skin · crackedLEFT BS 500B+10 UPPER FORWARD WINDOW SKIN CUTOUT CRACKED INDICATION AT HOLES 2, 6. REPAIRED SKIN IAW EA.SDR SWAA2013032614175Skin · crackedLEFT BS 500+10 UPPER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLES 1, 3, 5, 7, 9. REPAIRED SKIN IAW EA.SDR SWAA2013032614133Fitting · corrodedKEEL BEAM CLIP CORRODED AT BS 767, STR 27R. REMOVED AND REPLACED CLIP PER SRM.
Back to Boeing 737-3H4