Boeing 737-5H4
Service difficulty reports · 8,230
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 = '7375H4' 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 = '7375H4' 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 SWAA2000040126994Lens · looseRIGHT OVERWING EMERGENCY EXIT SIGN LENS LOOSE. SECURED LENS IAW MM.SDR SWAA2014040726864Skin · crackedFUSELAGE SKIN CRACKED AT BS 385, STRINGER 15R. REPAIRED SKIN IAW EA.SDR SWAA2014040726862Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 482B+3.5' TO BS 482B+7, STRINGER 8L. REPAIRED SKIN IAW EA.SDR SWAA2014040726861Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 482A+14.5' TO BS 482A+16, STRINGER 8L. REPAIRED SKIN IAW EA.SDR SWAA2014041427093Skin · crackedL1 DOOR SKIN CUT OUT LOWER AFT CORNER UNDER THRESHOLD PLATE CRACKED AT BS 348. REPAIRED SKIN IAW EA & SWA EA.SDR SWAA2014040726865Battery Pack · dischargedLEFT EEPLS INOPERATIVE AT ROW 15. R & R BATTERY PACK IAW MM.SDR SWAA2014040726863Skin · crackedFUSELAGE SKIN CRACKED AT BS 400, STRINGER 14R. REPAIRED SKIN IAW EA.SDR SWAA2014032426412Light · inoperativeL2 DOOR EXTERIOR EMERGENCY SLIDE LIGHT INOPERATIVE. R & R LIGHT IAW AMM.SDR SWAA2014032426411Light · inoperativeLT EMERGENCY EXIT LIGHT INOPERATIVE AT ROW 11. R & R LIGHT IAW AMM.SDR SWAA2014031826194Light · brokenAFT ENTRY EMERGENCY EXIT LIGHT BROKEN. R & R LIGHT ASSEMBLY IAW MM.SDR SWAA2014032426413Skin · crackedCHEM MILL SKIN CRACKED BETWEEN BS 384.7 TO BS 386.1, STRINGER 15L. REPAIRED SKIN IAW EA & ER.SDR SWAA2014031726137Housing · brokenLT EMERGENCY EXIT LIGHTS BATTERY SUPPLY PACK HOUSING BROKEN. R & R HOUSING IAW AMM.SDR SWAA2014031726136Slide · out of adjustL2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUSTMENT. ADJUSTED SLIDE IAW SIP.SDR SWAA2014033126633Frame · crackedFRAME CRACKED AT BS 348.2 BETWEEN STRINGER 13L TO STRINGER 17L. REPAIRED FRAME IAW SRM.SDR SWAA2014031426048Light · inoperativeEGRESS AISLE LIGHT INOPERATIVE AT 19 ABC. RE LAMPED IAW MM.SDR SWAA2014031426054Skin · crackedFUSELAGE SKIN CRACKED AT STATION 373 TO STATION 374.5, STRINGER 26R. REPAIRED SKIN IAW SRM.SDR SWAA2014030625823Lens · looseRT EMERGENCY EXIT LIGHT LENS LOOSE. SECURED LENS IAW SOPM.SDR SWAA2014030625822Light · inoperativeL2 DOOR EEPLS INOPERATIVE. RELAMPED EEPLS IAW AMM.SDR SWAA2014030425741Lens · looseRT OVERWING EXIT EMERGENCY LIGHT LENS LOOSE. SECURED LENS IAW MM.SDR SWAA2014030625821Skin · crackedFUSELAGE SKIN CRACKED AT BS 482B+17, STRINGER 16L. REPAIRED SKIN IAW SRM.SDR SWAA2014030425740Angle · crackedRT WING PYLON UPPER TE PANEL OTBD ANGLE CRACKED. R & R ANGLE IAW SRM.SDR SWAA2014030525762Skin · crackedFUSELAGE SKIN CRACKED AT BS 482B+6, STRINGER 16L. REPAIRED SKIN IAW ER & EA.SDR SWAA2014030525761Frame · crackedFUSELAGE FRAME OUTER CHORD WEB CRACKED AT BS 348.2, STRINGER 16L. REPAIRED WEB IAW ER & EA.SDR SWAA2014030425757Frame · crackedFRAME CRACKED AT BS 482A, BETWEEN STRINGER 20L TO STRINGER 21L. REPAIRED FRAME IAW SRM.SDR SWAA2014030425755Frame · crackedFRAME CRACKED AT BS 482A, BETWEEN STRINGER 20R TO STRINGER 21R. REPAIRED FRAME IAW SRM.SDR SWAA2014030425739Angle · crackedWEB ANGLE CRACKED AT BS 348.2, STRINGER 16L. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014022125407Bracket · looseRT WING NR 5 SPOILER IND ACTUATOR BRACKET LOOSE AT FWD ATTACHMENT. REPAIRED BRACKET IAW EA.SDR SWAA2014022725650Housing · crackedR1 DOOR UPPER HINGE HOUSING CRACKED. R & R HOUSING IAW EA & ER.SDR SWAA2014021925295Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 346 TO BS 347, STRINGER 2L. REPAIRED SKIN IAW SRM.SDR SWAA2014021925294Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 804.25 TO BS 805, STRINGER 24L. REPAIRED SKIN IAW SRM.SDR SWAA2014021925293Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 800 TO BS 800.8, STRINGER 22L. REPAIRED SKIN IAW SRM.SDR SWAA2014022625563Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 804.5 TO BS 805.5, STRINGER 18L. REPAIRED SKIN IAW EA.SDR SWAA2014022625562Skin · crackedR1 DOOR FUSELAGE SKIN LOWER HINGE CUTOUT CRACKED AT BS 292. REPAIRED CUTOUT IAW SRM.SDR SWAA2014022025349Slide · out of adjustR2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUSTMENT. ADJUSTED SLIDE IAW MM.SDR SWAA2014021425168Angle · crackedLT WING NO STEP PANEL OTBD ANGLE CRACKED AT THE AFT END. REPAIRED ANGLE IAW EA.SDR SWAA2014021024977Lens · looseR2 DOOR EMERGENCY EXIT SIGN LENS ASSEMBLY LOOSE. R & R LENS ASSEMBLY IAW MM.SDR SWAA2014021024976Light · inoperativeRT EXTERNAL EMERGENCY LIGHT BULBS INOPERATIVE. R & R BULBS IAW MM.SDR SWAA2014021024984Wedge · delaminatedLT WING INBD MIDFLAP TE WEDGE DELAMINATED. R & R WEDGE IAW AMM.SDR SWAA2014021024983Angle · crackedLT MAIN WW OPENING CRACKED IN THE UNDERBODY FAIRING ATTACH FRAME. R & R ANGLE IAW SRM.SDR SWAA2014021024971Skin · crackedFUSELAGE SKIN CRACKED AT BS 380+6, STRINGER 16R. REPAIRED SKIN IAW EA.SDR SWAA2014012924656Support Angle · crackedLT WING INBD UPPER FIXED FAIRING INBD SUPPORT ANGLE CRACKED AT AFT END. R & R ANGLE IAW SRM.SDR SWAA2014021024941Support Fitting · crackedSUPPORT CLIP CRACKED AT BS 348, STRINGER 16L. R & R CLIP IAW SRM & DRAWING.SDR SWAA2014012924658Angle · crackedSHEAR TIE ANGLE CRACKED AT BS 727A BETWEEN STRINGER 23L TO STRINGER 24L. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014012424537Display · faultyAIR TURN BACK ON TAKEOFF ROLL THE HEADING CARD LOCKED UP WITH HEADING FLAG ON BOTH SIDES. R & R ISDU IAW MM.SDR SWAA2014012824633Channel · crackedCHANNEL CRACKED BETWEEN BS 787 TO BS 807 RBL 17.43. R & R CHANNEL IAW SRM & DRAWING.SDR SWAA2014012024306Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 425 TO BS 428 STRINGER 26L. REPAIRED SKIN IAW SRM.SDR SWAA2014011624144Light · inoperativeRT OVERWING EMERGENCY EXIT LIGHT BULBS INOPERATIVE. R & R BULBS IAW AMM.SDR SWAA2014012724572Flap · corrodedRT WING NR 6 MID FLAP CORRODED. REPAIRED MID FLAP IAW CMM.SDR SWAA2014012224401Retainer · crackedL2 DOOR LOWER PLATE ANGLE RETAINER CRACKED. R & R RETAINER IAW SRM & DRAWING.SDR SWAA2014020524873Flap · crackedRT WING OTBD AFT FLAP CRACKED. REPAIRED AFT FLAP IAW EA.
Back to Boeing 737-5H4