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 SWAA2013122723660Frame · crackedFUSELAGE FRAME CRACKED AT STATION 500B, BETWEEN STRINGER 19R & STRINGER 22R. REPAIRED FRAME IAW SRM.SDR SWAA2013122723657Stringer Clip · crackedSTRINGER CLIP CRACKED AT STATION 380, STRINGER 8L. R & R STRINGER CLIP IAW SRM & BAC DRAWING.SDR SWAA2013122323588Light · inoperativeLT OVERWING EMERGENCY HANDLE LIGHT INOPERATIVE. RELAMPED IAW MM.SDR SWAA2013122323587Light · inoperativeRT OVERWING EMERGENCY HANDLE LIGHT INOPERATIVE. RELAMPED IAW MM.SDR SWAA2013121923535Light · inoperativeLT STOW BIN BULLNOSE EMERGENCY LIGHT INOPERATIVE AT ROW 17. R & R LIGHT IAW MM.SDR SWAA2013121623369Cover · brokenRT OVERWING EMERGENCY EXIT LIGHT COVER BROKEN. REPAIRED COVER IAW EA.SDR SWAA2014010223732Shear Tie · crackedSHEAR TIE CRACKED AT BS 520 BETWEEN STRINGER 11R TO STRINGER 10R. REPAIRED SHEAR TIE IAW SRM & DRAWING.SDR SWAA2013121823485Frame · crackedFRAME CRACKED AT STATION 500B, BETWEEN STRINGER 20R TO STRINGER 21R. REPAIRED FRAME IAW SRM.SDR SWAA2013121623362Stiffener · crackedLT WING NR 3 FLAP TRACK INTERNAL AREA STIFFENER CRACKED. R & R STIFFENER IAW SRM & DRAWING.SDR SWAA2013121623334Door · out of adjustL1 DOOR OUT OF ADJUSTMENT. ADJUSTED DOOR IAW MM.SDR SWAA2013121623368Battery Pack · dischargedR1 DOOR EMERGENCY EXIT LOWER LIGHT INOPERATIVE. R & R BATTERY PACK IAW AMM.SDR SWAA2013121623289Spoiler · delaminatedLT WING NR 3 FLIGHT SPOILER DELAMINATED. R & R NR 3 SPOILER IAW MM.SDR SWAA2013121223241Lens · looseRT OVERWING LOWER EMERGENCY EXIT LIGHT LENS LOOSE. REPAIRED LENS IAW MM.SDR SWAA2013121823499Forging · crackedRT BS 480+10 UPPER FWD CORNER OF WINDOW FORGING CRACKED AT HOLE NR 7. R & R FORGING IAW DRAWING.SDR SWAA2013121623288Angle · crackedRT WING CRACKED VERTICAL ANGLE INBD & FWD OF NR 2 AILERON HINGE FITTING. R & R ANGLE IAW SRM.SDR SWAA2013121623317Skin · crackedLT WING FIXED LE INBD OF PYLON AT FSS 197 CRACKED AT DEFLECTOR DOOR CUTOUT. REPAIRED CUTOUT IAW EA.SDR SWAA2014010723831Skin · crackedRT BS 520+10 UPPER FWD SKIN CUTOUT CRACKED AT HOLE NR 3 - 7. REPAIRED SKIN IAW EA.SDR SWAA2014010723829Flap · delaminatedLT WING INBD FORE FLAP DELAMINATED. REPAIRED FORE FLAP IAW SRM.SDR SWAA2014010223736Skin · crackedLT BS 520+10 LOWER AFT SKIN CUT OUT CRACKED AT HOLE NR 8 & NR 7. REPAIRED SKIN IAW DRAWING.SDR SWAA2014010223733Skin · crackedRT BS 360+10 LOWER AFT SKIN CUT OUT CRACKED INDICATION AT HOLE NR 3. REPAIRED SKIN IAW EA.SDR SWAA2014010223713Skin · crackedLT BS 420+10 UPPER FWD SKIN CUT OUT CRACKED INDICATION AT HOLES 5 & 6. REPAIRED SKIN IAW EA.SDR SWAA2014010223712Skin · crackedLT BS 400+10 UPPER FWD SKIN CUT OUT CRACKED INDICATION AT HOLES 3 & 6. REPAIRED SKIN IAW EA.SDR SWAA2014010223711Skin · crackedLT BS 380+10 UPPER FWD SKIN CUT OUT CRACKED INDICATION AT HOLES 3, 4 & 5. REPAIRED SKIN IAW EA.SDR SWAA2014010223747Skin · crackedLT BS 520+10 UPPER FWD SKIN CUTOUT CRACKED INDICATION AT HOLES 4,5 & 7. REPAIRED SKIN IAW EA.SDR SWAA2013121823498Skin · crackedLT BS 500+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 3,4 & 5. REPAIRED SKIN IAW SB.SDR SWAA2013121823497Skin · crackedLT BS 500+10 UPPER FWD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR SWAA2013121823496Skin · crackedLT BS 480+10 UPPER FWD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR SWAA2013121823517Skin · crackedRT BS 500A+10 UPPER FWD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR SWAA2013121723431Skin · crackedLT BS 867+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR SWAA2013121623396Skin · crackedRT BS 360+10 UPPER FWD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 7. REPAIRED SKIN IAW EA.SDR SWAA2013121623380Light · crackedAFT LAVATORY MOUNTED EMERGENCY LIGHT CRACKED. R & R LIGHT IAW MM.SDR SWAA2013121623374Skin · crackedRT BS 460+10 UPPER FWD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW EA.SDR SWAA2013121623373Skin · crackedRT BS 440+10 UPPER FWD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 6. REPAIRED SKIN IAW EA.SDR SWAA2013121623372Skin · crackedRT BS 400+10 UPPER FWD WINDOW SKIN CUTOUT CRACKED AT HOLES 2 & 3. REPAIRED SKIN IAW EA.SDR SWAA2013121623298Skin · crackedRT BS 827+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE NR 4. REPAIRED SKIN IAW EA.SDR SWAA2013121623323Skin · crackedRT BS 867+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 5, 9,10 & 12. REPAIRED SKIN IAW EA.SDR SWAA2013121623322Skin · crackedRT BS 767+10 LOWER FWD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW TC & EA.SDR SWAA2013121323264Flap · out of positionR2 DOOR SLIDE LOWER FLAP OUT OF POSITION. REPOSITIONED R2 DOOR SLIDE LOWER FLAP IAW MT.SDR SWAA2013121223248Indicator · faultyDECLARED EMERGENCY WHEN FLAPS PLACED TO "25" POSITION, INDICATOR SHOWED APPROXIMATELY 15 & 20 & NO ROLL NOTED. R & R FLAP POSITION INDICATOR IAW MM.SDR SWAA2014010723830Skin · crackedRT WING NR 5 SLAT LOWER SURFACE SKIN CRACKED. REPAIRED SKIN IAW SRM.SDR SWAA2014010223735Access Panel · chafedDORSAL FIN ACCESS PANEL 9503 CHAFFED. REPAIRED PANEL IAW SRM & DRAWING.SDR SWAA2013121623381Light · unsecureRT EEPLS FELL OFF AT ROW 13. SECURED EEPLS IAW AMM.SDR SWAA2013121623296Failsafe · corrodedFRAME FAILSAFE CORRODED AT BS 767, BETWEEN LBL 20 TO RBL 20. R & R CHORD IAW SRM & DRAWING.SDR SWAA2013121323263Shaft · brokenNR 1 ENG WOULD NOT MAKE CLIMB POWER. R & R NR 1 ENG VBV GEAR MOTOR SPLINED SHAFT IAW MM.SDR SWAA2013121323262Slide · unsecureL1 DOOR ESCAPE SLIDE CAME OUT OF HOLDING CASE BUT DID NOT DEPLOY. REINSERTED L1 DOOR SLIDE IN CASE IAW MT.SDR SWAA2013121123215Battery · weakFWD GALLEY RT EMERGENCY FLASH LIGHT BATTERY WEAK. R & R BATTERY IAW MM.SDR SWAA2013121123204Light · inoperativeEXTERNAL EMERGENCY EXIT LIGHT INOPERATIVE AT LT AFT ENTRY DOOR. RELAMPED LIGHT IAW AMM.SDR SWAA2013121623371Light · inoperativeCABIN EMERGENCY LIGHTS INOPERATIVE. RELAMPED LIGHTS IAW AMM.SDR SWAA2013120923062Light · inoperativeAFT LT EMERGENCY EXIT LIGHT IN BIN BULLNOSE INOPERATIVE. R & R LIGHT IAW MM.SDR SWAA2013121623359Angle · crackedFRAME ANGLE CRACKED AT STATION 363.65 OTBD SIDE RT PYLON. R & R ANGLE IAW SRM.
Back to Boeing 737-3H4