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 SWAA2014053028534Floor Support · crackedLONGITUDINAL FLOORBEAM WEB CRACKED AT BS 710, LBL 24.8. REPAIRED WEB IAW EA.SDR SWAA2014053028530Floor Support · crackedLONGITUDINAL FLOORBEAM WEB CRACKED AT BS 708, LBL 24.8. REPAIRED WEB IAW EA.SDR SWAA2014053028529Floor Support · crackedLONGITUDINAL FLOORBEAM WEB CRACKED AT BS 707, LBL 24.8. REPAIRED WEB IAW EA.SDR SWAA2014052928471Former · looseWING TO BODY FAIRING FORMER LOOSE AT BS 727, LBL 31. R & R FORMER IAW DWG & SRM.SDR SWAA2014052928469Skin · crackedFUSELAGE SKIN CRACKED AT BS 520+2.5, LBL 4.5. REPAIRED SKIN IAW SRM.SDR SWAA2014052928451Stiffener · crackedPRESSURE BULKHEAD Z STIFFENER CRACKED AT BS 1016, BETWEEN STRINGER 25L TO 26L. REPAIRED Z STIFFENER IAW EO & EA.SDR SWAA2014052228259Skin · crackedFUSELAGE SKIN CRACKED AT BS 520+8.5, LBL 5.5. REPAIRED SKIN IAW SRM.SDR SWAA2014052128225Panel · crackedKEEL BEAM STRESS PANEL CRACKED AT BS 707, RBL 7. REPAIRED PANEL IAW SRM.SDR SWAA2014051628065Web · corrodedAFT CARGO COMPARTMENT WEB CORRODED BETWEEN BS 947.5 TO BS 967, BETWEEN STRINGER 25R TO STRINGER 26R. R & R WEB IAW SRM & DWG.SDR SWAA2014051427990Cover · crackedR1 DOOR AFT CUT OUT COVER CRACKED. R & R COVER IAW AMM.SDR SWAA2014051427985Carriage · corrodedLEFT WING INBD FLAP, OTBD CARRIAGE INBD CORRODED. REPAIRED FLAP IAW CMM.SDR SWAA2014050527681Battery · dischargedFORWARD INBD FLASHLIGHT INOPERATIVE. R & R BATTERY IAW AMM.SDR SWAA2014050527645Slide · unsecureL1 DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT, DID NOT DEPLOY, STILL OPERATIONAL. REINSTALLED SLIDE IAW MT.SDR SWAA2014053028495Web · crackedWEB CRACKED AT BS 639, STRINGER 17L. REPAIRED WEB IAW EA.SDR SWAA2014052928450Angle · crackedFORWARD ENTRY DOOR SURROUND STRUCTURE LWR POSITION ANGLE CRACKED AT BS 348.2, STRINGER 15L. REPAIRED ANGLE IAW EA & EO.SDR SWAA2014052928449Angle · crackedFORWARD ENTRY DOOR SURROUND STRUCTURE LWR POSITION ANGLE CRACKED AT BS 348.2, STRINGER 16L. REPAIRED ANGLE IAW EA & EO.SDR SWAA2014052928448Angle · crackedFORWARD ENTRY DOOR SURROUND STRUCTURE UPPER POSITION ANGLE CRACKED AT BS 348.2, STRINGER 16L. REPAIRED ANGLE IAW EA & EO.SDR SWAA2014052728331Strap · crackedSTRAP CRACKED AT BS 947.5, STRINGER 16L. R & R STRAP IAW SRM & DWG.SDR SWAA2014052128207Angle · crackedCRACK ON RETAINER LOCATED AFT CUT OUT FWD ENTRY DOOR ANGLE CHORD CRACKED AT BS 348.2 & BETWEEN STRINGER 8L TO STRINGER 9L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014051528038Lens · brokenFORWARD GALLEY EMERGENCY EXIT LIGHT LENS BROKEN. R & R LENS IAW AMM.SDR SWAA2014051528037Lens · brokenFORWARD LAVATORY WALL EMERGENCY EXIT LIGHT LENS BROKEN. R & R LENS IAW AMM.SDR SWAA2014051528036Wedge · crackedLEFT WING MID FLAP CRACK INBD WEDGE PANEL CRACKED. REPAIRED WEDGE IAW SRM.SDR SWAA2014051528035Angle · crackedFORWARD GALLEY DOOR SURROUND STRUCTURE ANGLE CRACKED BETWEEN BS 277 TO BS 291.5, BETWEEN STRINGER 11R TO STRINGER 12R. R & R ANGLE IAW SRM & DWG.SDR SWAA2014051427989Cover · crackedCOVER OF LOWER HINGE CRACKED AT BS 303.9, BETWEEN STRINGER 13L TO STRINGER 14L. R & R COVER IAW SRM.SDR SWAA2014051427988Cover · crackedCOVER OF UPPER HINGE CRACKED AT BS 303.9, BETWEEN STRINGER 10L TO STRINGER 11L. R & R COVER IAW SRM.SDR SWAA2014051427984Tie Clip · crackedTIE CLIP CRACKED AT BS 277, STRINGER 10R. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014051427983Angle · crackedANGLE CRACKED BETWEEN BS 277 TO BS 291.5, BETWEEN STRINGER 9R TO STRINGER 10R. R & R ANGLE IAW SRM & DWG.SDR SWAA2014051427975Angle · crackedANGLE CRACKED AT BS 344, LBL 11. R & R ANGLE IAW SRM & DWG.SDR SWAA2014051427972Angle · crackedANGLE CRACKED BETWEEN BS 277 TO BS 291.5, BETWEEN STRINGER 12R TO STRINGER 13R. R & R ANGLE IAW SRM & DWG.SDR SWAA2014051427971Tie Clip · crackedTIE CLIP CRACKED AT BS 277, STRINGER 15R. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014050527647Pump · failedDIVERSION, DECLARED EMERGENCY. DURING CLIMB OUT A SYS HYD SYS FAILED. R & R NR 3 FLT SPOILER TEST PORT CAP, O RING & ENG DRIVEN PUMP IAW MM.SDR SWAA2014050527643Controller · failedAIR TURN BACK, CLIMBING THROUGH 230 BOTH AUTO CONTROLLERS FAILED. R & R NR 1 & NR 2 CABIN PRESS CONTROLLERS IAW MM.SDR SWAA2014050527674Power Supply · inoperativeMID AFT EMERGENCY EXIT LIGHT INOPERATIVE. R & R POWER SUPPLY IAW AMM.SDR SWAA2014060228567Floorbeam · corrodedFLOORBEAM CORRODED AT BS 986.5, BETWEEN RBL 5 TO RBL 45. REPAIRED CHORD IAW EO & EA.SDR SWAA2014060228566Pressure Deck · crackedMAIN WW PRESS DECK CRACKED AT BS 664+1, LBL 24.5+14.5. REPAIRED DECK IAW EO & EA.SDR SWAA2014060228565Pressure Deck · crackedCRACK ON MAIN WW PRESS DECK LOCATED AT BS 664+1.5, LBL 24.5+8. REPAIRED DECK IAW EA.SDR SWAA2014060228564Pressure Deck · crackedMAIN WW PRESS DECK CRACKED AT BS 664+1, LBL 24.5+7.5. REPAIRED DECK IAW EO.SDR SWAA2014052928447Floorbeam · crackedFLOORBEAM CRACKED AT BS 947.5, STRINGER 17L. REPAIRED FLOORBEAM IAW EO & EA.SDR SWAA2014052728327Support Angle · crackedLEFT WING FIXED TE SUPPORT ANGLE CRACKED AT BS 537.80. R & R ANGLE IAW SRM & DWG.SDR SWAA2014051928094Support Angle · crackedLEFT WING FIXED TE SUPPORT ANGLE CRACKED AT WBL 70.85. R & R ANGLE IAW SRM & DWG.SDR SWAA2014051528034Fitting · crackedFITTING CRACKED AT BS 333, STRINGER 8R. R & R FITTING IAW SRM & DWG.SDR SWAA2014051427974Angle · corrodedSPLICE ANGLE CORRODED AT BS 1006, STRINGER 17R. R & R SPLICE ANGLE IAW & DWG.SDR SWAA2014051427973Angle · corrodedZ DOOR ANGLE CORRODED AT BS 967+12, STRINGER 17R. R & R Z ANGLE IAW SRM & DWG.SDR SWAA2014050827791Support · crackedR2 DOOR LOWER LINER SUPPORT CRACKED FWD OF AFT END. R & R SUPPORT IAW SRM & DWG.SDR SWAA2014050827790Support Angle · crackedR2 DOOR LOWER AFT LINER SUPPORT ANGLE CRACKED. R & R ANGLE IAW SRM & DWG.SDR SWAA2014050827789Support Angle · crackedR2 DOOR LOWER FWD LINER SUPPORT ANGLE CRACKED. R & R ANGLE IAW SRM & DWG.SDR SWAA2014050827785Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 328, RBL 34. R & R ANGLE IAW SRM & DWG.SDR SWAA2014050727749Intercostal · crackedINTERCOSTAL CRACKED BETWEEN BS 328 TO BS 344, RBL 11. R & R INTERCOSTAL IAW SRM & DWG.SDR SWAA2014050527719Outflow Valve · faultyIN DESCENT OUT OF FL 280 ALTITUDE WARNING HORN SOUNDED & CABIN PRESS ROSE TO 12000 FT. AFTER DESCENDING TO 10,000' THE AUTO FAIL & STANDBY LIGHTS ILLUMINATED. R & R OUTFLOW VLV & PRESS CONTROLLER IAW MM.SDR SWAA2014050527718Actuator · faultyRED NOSE GEAR LIGHT ILLUMINATED WITH GEAR HANDLE UP. NOSE GEAR EXTENDS TO DOWN POSITION WITH GEAR HANDLE IN THE OFF POSITION. CYCLED GEAR DOWN THEN UP TWICE. R & R NLG RETRACT ACTUATOR IAW MM.
Back to Boeing 737-3H4