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 SWAA2014021825262Lens · brokenAFT LAVATORY WALL EMERGENCY EXIT SIGN LENS BROKEN. R & R LENS IAW AMM.SDR SWAA2014021725217Pressure Deck · crackedMAIN WW PRESS DECK CRACKED AT BS 672, LBL 31. REPAIRED DECK IAW SRM.SDR SWAA2014021725179Web · crackedSHEAR BEAM WEB CRACKED BETWEEN BS 711 TO BS 727, RT SIDE. R & R WEB IAW EA.SDR SWAA2014021125048Access Panel · crackedRT HORIZONTAL STABILIZER PLATE ACCESS PANEL 9224R CRACKED. R & R PANEL IAW SRM & DRAWING.SDR SWAA2014030625817Frame · crackedFRAME OUTER CHORD CRACKED AT BS 727, STRINGER 18A LT. R & R CHORD IAW EA.SDR SWAA2014030525779Pressure Deck · crackedMAIN WW PRESS DECK CRACKED AT BS 664, LBL 24.5. REPAIRED WEB IAW EO & EA.SDR SWAA2014030425753Panel · crackedCORRUGATED PANEL CRACKED BETWEEN BS 717 TO BS 727 ON MLG BAY. R & R PANEL IAW SRM & DRAWING.SDR SWAA2014030325703Floor Support · crackedLONGITUDINAL FLOOR BEAM UPPER CHORD CRACKED AT BS 727B, RBL 45.5. REPAIRED CHORD IAW EA.SDR SWAA2014022425435Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 663+17. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014021125066Lug · brokenLT WING INBD GND SPOILER CTR INBD LUG BROKEN. R & R SPOILER IAW AMM.SDR SWAA2014021125065Slide · out of positionR2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MT.SDR SWAA2014022625554Structure · crackedAFT CARGO DOOR FWD END OF THE CROSS BEAM AT THE T CHORD CRACKED. REPAIRED T CHORD IAW EA & DRAWING.SDR SWAA2014021125004Slide · out of positionR2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW TC.SDR SWAA2014030325684Skin · crackedSKIN CRACKED AT BS 360, BETWEEN STRINGER 3L TO STRINGER 4L. REPAIRED SKIN IAW EA.SDR SWAA2014022825664Frame · crackedFUSELAGE FRAME OUTER CHORD CRACKED APPROXIMATELY STATION 348.2, 0.5 INCHES. BELOW STRINGER 16L. REPAIRED FRAME IAW SWA EA.SDR SWAA2014022825663Frame · crackedFUSELAGE FRAME OUTER CHORD CRACKED APPROXIMATELY STATION 348.2, STRINGER 16L. REPAIRED FRAME IAW SWA EA.SDR SWAA2014022825662Frame · crackedFUSELAGE FRAME CRACKED AT STATION 348.2 INNER CHORD, STRINGER 17L. REPAIRED FRAME IAW SWA EA.SDR SWAA2014022525520Crossbeam · crackedAFT CARGO COMPARTMENT DOOR FWD END OF CROSS BEAM WEB CRACKED. REPAIRED WEB IAW EA.SDR SWAA2014022125381Skin · crackedSKIN CRACKED AT BS 303.5, STRINGER 8R. REPAIRED SKIN IAW SWA EA.SDR SWAA2014031025885Lens · missingOVERWING EMERGENCY EXIT LIGHT LENS MISSING. INSTALLED LENS IAW AMM.SDR SWAA2014021125051Web · crackedWEB CRACKED BETWEEN BS 440 TO BS 460, BETWEEN STRINGER 25L TO STRINGER 26L. R & R WEB IAW SRM & DRAWING.SDR SWAA2014021125008Window · arcedDIVERSION DECLARED, EMERGENCY L1 WINDOW ARCED IN FLIGHT. R & R WINDOW IAW MM.SDR SWAA2014022725607Channel · corrodedAFT CARGO COMPARTMENT CHANNEL CORRODED BETWEEN BS 727D TO BS 727E, BL 0. REPAIRED CHANNEL IAW EA.SDR SWAA2014022125366Support Angle · crackedMAIN WW SUPPORT ANGLE TEE CRACKED AT BS 727, BETWEEN STRINGER 21R TO STRINGER 26R. R & R TEE IAW SRM & DRAWING.SDR SWAA2014021725198Angle · crackedANGLE CRACKED BETWEEN BS 887 TO BS 907. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014021425138Web · crackedWEB CRACKED AT BS 525, BETWEEN STRINGER 21R TO STRINGER 24R. R & R WEB IAW SRM & DRAWING.SDR SWAA2014021125010Door Frame · crackedR1 DOOR LOWER FRAME AT LOWER AFT STOP ATTACH AREA CRACKED. R & R DOOR IAW MM.SDR SWAA2014021024957Light · inoperativeRT OVERWING EXTERNAL EMERGENCY LIGHT BULB INOPERATIVE. RELAMPED BULB IAW MM.SDR SWAA2014021024956Angle · crackedRT WING INBD ANGLE CRACKED AT THE AFT END. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014020624913Lens · missingLT EEPLS LENS MISSING AT ROW 22. INSTALLED LENS IAW MM.SDR SWAA2014020624912Light · inoperativeRT EEPLS INOPERATIVE BETWEEN ROW 1 TO ROW 5. RELAMPED EEPLS IAW MM.SDR SWAA2014022725606Floorbeam · crackedFLOOR BEAM UPPER CHORD CRACKED AT BS 947.5, LBL 52.5. REPAIRED CHORD IAW EA.SDR SWAA2014022825661Frame · crackedFUSELAGE FRAME CRACKED AT STATION 951, STRINGER 6R. REPAIRED FRAME IAW SWA EA.SDR SWAA2014022825660Frame · crackedFUSELAGE FRAME CRACKED AT STATION 348.2, STRINGER 17L. REPAIRED FRAME IAW SWA EA.SDR SWAA2014022625553Web · crackedLT NLG WW WEB CRACKED AT BS 259, WL 169.1+8.5. REPAIRED WEB IAW SRM.SDR SWAA2014022625552Panel · crackedNLG WW PANEL CRACKED AT BS 243+3.5, RBL 16. REPAIRED PANEL IAW SRM.SDR SWAA2014022625551Panel · crackedNLG WW PANEL CRACKED AT BS 243.7+2.5, RBL 16. REPAIRED PANEL IAW SRM.SDR SWAA2014022425439Retainer · crackedL1 DOOR CUTOUT RETAINER FWD LOWER CORNER CRACKED. R & R RETAINER IAW SRM & DRAWING.SDR SWAA2014022425438Retainer · crackedL1 DOOR CUTOUT RETAINER FWD UPPER CORNER CRACKED. R & R RETAINER IAW SRM & DRAWING.SDR SWAA2014022425437Retainer · crackedL1 DOOR CUTOUT RETAINER CRACKED BETWEEN STRINGER 8L TO STRINGER 9L. R & R RETAINER IAW SRM & DRAWING.SDR SWAA2014022425436Retainer · crackedL1 DOOR CUTOUT AFT LOWER CORNER RETAINER CRACKED. R & R RETAINER IAW SRM & DRAWING.SDR SWAA2014021925304Web · crackedWEB CRACKED LOCATED BETWEEN BS 348.2 TO BS 351.2, STRINGER 16L. R & R WEB IAW SRM & DRAWING.SDR SWAA2014021925303Web · crackedWEB CRACKED BETWEEN BS 947.5 TO BS 967, LBL 21. R & R WEB IAW SRM & DRAWING.SDR SWAA2014021725197Intercostal · crackedINTERCOSTAL CRACKED BETWEEN BS 312 TO BS 328, RBL 12. R & R INTERCOSTAL IAW SRM & DRAWING.SDR SWAA2014021725196Angle · crackedFWD ENTRY DOOR CUTOUT ANGLE CRACKED AT BS 312, STRINGER 15L. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014021725195Web · crackedWEB CRACKED BETWEEN BS 294.5 TO BS 312, STRINGER 4L. R & R WEB IAW SRM & DRAWING.SDR SWAA2014021725194Support Angle · crackedLT WING SUPPORT ANGLE CRACKED AT TE WING STATION 537.806. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014021725193Strap · crackedSTRAP CRACKED BETWEEN BS 294.5 TO BS 312, STRINGER 4L. R & R STRAP IAW SRM & DRAWING.SDR SWAA2014021725185Proximity Sensor · faultyRT MLG UNSAFE LIGHT ON APPROACH FOR LANDING, CYCLED LANDING TWICE, GOT 3 GREEN LIGHTS, LANDED NORMAL. R & R LANDING GREEN LOGIC CARD M982 & PROXIMITY SENSOR S73 IAW MM.SDR SWAA2014021325118Tie Clip · crackedTIE CLIP CRACKED AT BS 277, STRINGER 15R. R & R TIE CLIP IAW SRM & DRAWING.
Back to Boeing 737-3H4