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 SWAA2014032426333Pressure Deck · crackedPRESS DECK LOWER SURFACE CRACKED BETWEEN BS 663 TO BS 674, LBL 32 OF LT MLG BAY. REPAIRED WEB IAW EA 1-353-24709.SDR SWAA2014031726098Web · crackedNLG BEAM WEB CRACKED. R & R WEB IAW SRM & DWG.SDR SWAA2014031225989Skin · delaminatedLT WING NR 3 SLAT UPPER INBD CORNER AREA SKIN DELAMINATED. REPAIRED SKIN IAW SRM.SDR SWAA2014030725855Flap · delaminatedRT WING INBD AFT FLAP, AFT OTBD CORNER DELAMINATED. REPAIRED AFT FLAP IAW SRM.SDR SWAA2014030425737Angle · crackedFWD ENTRY DOOR, FWD UPPER CORNER ANGLE CRACKED. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014030325717Angle · crackedLT WING TE AT AILERON 2ND BAY OTBD ANGLE CRACKED. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014022725622Light · missingLT EEPLS STRIP MISSING AT ROW 14. INSTALLED EEPLS IAW MMM.SDR SWAA2014022725621Flap · looseRT WING OTBD AFT FLAP LOOSE. SECURED AFT FLAP IAW MM.SDR SWAA2014022725620Flap · looseRT WING INBD AFT FLAP LOOSE. SECURED AFT FLAP IAW MM.SDR SWAA2014022725619Stiffener · crackedRT WING AILERON STIFFENER CRACKED INBD OF NR 2 HINGE. R & R STIFFENER IAW SRM.SDR SWAA2014032826607Pressure Panel · crackedMLG WW PRESS WEB CRACKED AT STATION 665, LBL 39, WL 203. REPAIRED WEB IAW EA.SDR SWAA2014032826606Flashlight · inoperativeFWD FLIGHT ATTENDANT'S INBD FLASHLIGHT INOPERATIVE. R &R FLASHLIGHT ASSEMBLY IAW MM.SDR SWAA2014032426444Structure · crackedCHORD CRACKED AT BS 727, STRINGER 17R. REPAIRED CHORD IAW EA & ER.SDR SWAA2014031426067Web · crackedRT NLG WW WEB CRACKED AT STATION 259.5, WL 174 TO WL 176. REPAIRED WEB IAW SWA EA.SDR SWAA2014031426066Web · crackedLT NLG WW WEB CRACKED AT STATION 259.2, WL 177 TO WL 178. REPAIRED WEB IAW SWA EA.SDR SWAA2014022725623Frame · crackedFRAME OTBD CHORD CRACKED AT BS 727, STRINGER 18A RT. REPAIRED CHORD IAW TC.SDR SWAA2014022825668Flap · delaminatedRT WING OTBD AFT FLAP INBD END DELAMINATED. R & R AFT FLAP IAW MM.SDR SWAA2014022625561Sign · unsecureOVERHEAD EMERGENCY EXIT SIGN FELL OFF AT ROW 3. SECURED SIGN IAW MM.SDR SWAA2014022525508O-Ring · damagedAIR TURN BACK DECLARED EMERGENCY LOST A SYS INFLIGHT ENG PUMP LOW PRESS AT QUANTITY ZERO. R & R O RING IAW MM.SDR SWAA2014030325707Channel · crackedCHANNEL INNER CHORD CRACKED AT BS 348.5 BETWEEN STRINGER 16L TO STRINGER 17L. R & R CHORD IAW SRM & DRAWING.SDR SWAA2014022725602Slide · out of positionR1 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW AMM.SDR SWAA2014022625580Skin · crackedSKIN CRACKED AT BS 727B+7, STRINGER 10R. REPAIRED SKIN IAW EA.SDR SWAA2014022625579Skin · crackedSKIN CRACKED AT BS 500A+6.5, STRINGER 10R. REPAIRED SKIN IAW EA.SDR SWAA2014022425423Slide · unsecureL1 DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT, DID NOT DEPLOY, STILL OPERATIONAL. REINSTALLED SLIDE IAW MT.SDR SWAA2014031726143Skin · damagedEXTERNAL POWER DOOR CUT OUT DAMAGED LOWER & FWD EDGE. REPAIRED CUT OUT IAW ER & SWA EA.SDR SWAA2014030425745Splice · crackedSPLICE CRACKED AT BS 908, STRINGER 4R. R & R SPLICE IAW SRM & DRAWING.SDR SWAA2014022425493Slide · out of positionR1 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MT.SDR SWAA2014022425461Light · inoperativeRT EMERGENCY EXIT LIGHT INOPERATIVE AT ROW 20. R & R LIGHT IAW AMM.SDR SWAA2014022425426Tru · faultyFOUL BURNING ODOR FROM RT PACK WHEN PROVIDING HEAT. R & R NR 1 & NR 2 TRANSFORMER RECTIFIERS IAW MM.SDR SWAA2014022425425Sign · looseFWD OVERHEAD EMERGENCY EXIT SIGN LOOSE. SECURED SIGN IAW MM.SDR SWAA2014022425457Channel · corrodedCHANNEL CORRODED AT BS 847+13, RBL 3. REPAIRED CHANNEL IAW EA.SDR SWAA2014022425456Channel · corrodedCHANNEL CORRODED AT BS 847+13, LBL 3. REPAIRED CHANNEL IAW EA.SDR SWAA2014022425442Light · inoperativeFWD EMERGENCY EXIT LIGHT BULBS INOPERATIVE. R & R BULBS IAW MM.SDR SWAA2014022425441Fitting · looseR1 DOOR EMERGENCY EVAC SLIDE GIRT BAR FITTING LOOSE. SECURED FITTING IAW MM.SDR SWAA2014022425440Structure · crackedR1 DOOR UPPER HINGE ARM CUT OUT AFT CORNER CRACKED. REPAIRED CUT OUT IAW EA.SDR SWAA2014030425735Skin · crackedSKIN CRACKED AT BS 727+13, LBL 1. REPAIRED SKIN IAW EA.SDR SWAA2014022425494Lug · brokenRT WING NR 5 GND SPOILER ACTUATOR LUG BROKEN. R & R SPOILER IAW MM.SDR SWAA2014022425455Light · inoperativeAFT EMERGENCY EXIT LIGHTS INOPERATIVE. R & R LIGHTS IAW MM.SDR SWAA2014022125382Light · inoperativeRT BULLNOSE EMERGENCY EXIT LIGHT INOPERATIVE AT ROW 24. R & R LIGHT IAW AMM.SDR SWAA2014022125373Angle · crackedLT WING ANGLE CRACKED AT WBL 198.60 TE. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014022125367Light · crackedAFT EEPLS CRACKED. R & R EEPLS IAW AMM.SDR SWAA2014030325716Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 400, STRINGER 8L. R & R CLIP IAW SRM & DRAWING.SDR SWAA2014030325715Stringer · damagedSTRINGER DAMAGED AT BS 450, STRINGER 6L. REPAIRED STRINGER IAW SRM.SDR SWAA2014030325714Stringer · damagedSTRINGER DAMAGED AT BS 379, STRINGER 6L. REPAIRED STRINGER IAW SRM.SDR SWAA2014022025355Light · inoperativeL1 DOOR EXTERNAL EMERGENCY EXIT LIGHT LAMP INOPERATIVE. R & R LAMP IAW AMM.SDR SWAA2014030425734Skin · crackedSKIN CRACKED BETWEEN BS 727D+8 TO BS 727+13, LBL 1. REPAIRED SKIN IAW EA.SDR SWAA2014030325692Skin · delaminatedRT WING INBD AFT FLAP OTBD EDGE LOWER SURFACE DELAMINATED. R & R AFT FLAP IAW MM.SDR SWAA2014022725608Bracket · crackedLT WING FLAP TRACK FAIRING BRACKET CRACKED. R & R BRACKET IAW SRM & DRAWING.SDR SWAA2014022025354Fuse · inoperativeR1 DOOR OVERHEAD BATTERY PACK FUSE INOPERATIVE. R & R FUSE IAW WDM & AMM.SDR SWAA2014022725610Web · crackedAFT CARGO COMPARTMENT WEB CRACKED BETWEEN BS 927 TO BS 947.5, BL 0. R & R WEB IAW SRM & DRAWING.
Back to Boeing 737-3H4